Problem statement: Many companies require cost centre wise analysis(specifically with Tally). Their needs are as follows:
- Profit analysis per cost centre
2. Understanding the billing implications for various projects. Material could have been purchased but billing would not have been done.
Relevant industries: any project related industries for construction.
In order to meet the need for cost center analysis we have a software add on for revenue analysis.
For quick querying we have developed the same over SQL Server. The clients can also develop workflows over the cost center module.
Why is the SQL Server module required?
a.) The logic as per the required revenue accounts has been developed in the database. We extensively use ledger flattening for the same.\
b.) In order to make the system more secure and customizable we have used python code.
c.) The client can specify the screen to be shown based on ledger and item hierarchy flattening.
Why is this module better than the Tally system:
a.) Customized revenue models have been developed
b.) Better control flows can be specified using item hierarchy and ledger hierarchy flattening. That is a CEO can contact his subordinates with ease using the module.
Explanation of the module:
In the sample screen below we make a preliminary snapshot of a sample cost center module developed for a company.
a.) Company name is a drop down box: we can work with unlimited companies
b.) Cost center: these are the associated cost centers for the company that has been selected in the combo box above.
Hereafter we explain each of the list boxes below:
1.) Sales: this gives the total sales entries as per the sales accounts for the given cost center.
2.) Purchase: this portion can be further customized base don the ledger flattening by the end client. Various sub groups can be added. this indicates the total purchase(across all voucher types) for the purchase accounts.
(Note: delivery notes, receipt notes, purchase order and sales order have been excluded. The revenue accounts report from Tally has been used to generate the given numbers).
The sales and purchase entries include both ledger and inventory movements(so the journal entries for the sales shall also be counted)
Labour, Transport and other expenses have been extracted from the ledger flattening.
The net profit per project is sales-purchase-indirectexpense-direct expense for a project per cost center.
Other customizations that are possible:
For example automated emailing and whatsapp feature across various ledger level hierarchies are also possible(the same is been done for a client given below):
Inventory movement analysis: In order to make the module more comprehensive and showcase more details for the project movement we also have added sections to showcase the inventory movement for sales, purchase. In the module the following actions can also be taken:
a.) Conversion of units can be done
b.) Link with bill receivable can be done
c.) Workflows based on project completion can be done.
For deployment of the module please contact:
Name: Apoorv Chaturvedi
email: support@mndatasolutions.com;support@turbodatatool.com
Phone:+91-8802466356
Estimated cost: (To be decided on case by case basis)
Website: https://mn-business-intelligence-india.business.site?whatsapp
Youtube channel: https://www.youtube.com/@mndatasolutions2042
No comments:
Post a Comment