! Advertisements ! ⁈

These sections are reserved for advertisements. While our in-house advertising system is under development, Third party Ad-sense will be displayed here. For more information, please refer to our “Advertisements” insight.

Go to Index or search here

Cost Allocation Across Departments: How Growing MSMEs Can Build Internal Accountability

Article ID : Art_6.12.4 Read Time : ⏱ 12-15 min
Published on : 12-Jun-2026 • 06:00 IST

⬟ Intro :

A medium MSME garments manufacturer in Ludhiana, Punjab had grown revenue to Rs. 9.4 crore. But overhead had grown faster: from 14% to 21% of revenue over three years. The owner reviewed the consolidated P&L monthly. Total salaries, rent, utilities, logistics were all visible. But when asked which department was responsible for rising overhead, nobody could answer clearly. The production manager pointed to administration. The sales manager pointed to the factory. Administration pointed to delivery. The CA recommended setting up departmental cost centres in Tally. Three months later, monthly reports showed that administration salaries had grown from Rs. 2.8 lakh to Rs. 4.9 lakh per month over eighteen months, driven by three uncoordinated hiring decisions no one had tracked against a budget. The problem was visible. The accountability was clear.

As an MSME grows to a multi-department business, the consolidated P&L becomes less useful as a management tool. It shows the total result but not which department is driving it. Cost allocation across departments creates responsibility accounting: each department head becomes responsible for the costs their area generates, measured and reported separately. Without this structure, overhead creep is almost inevitable. Costs rise gradually across departments, each increment too small to trigger concern in the consolidated number, until margins compress without any single visible cause. Departmental cost tracking surfaces these increments in real time, department by department.

This article covers what departmental cost allocation involves, how to define departments and cost categories, how to allocate shared costs fairly, how to set up the system in Tally or Excel, and how to use departmental cost data to manage spending and accountability.

⬟ What Is Departmental Cost Allocation and How Does It Work :

Departmental cost allocation is the process of assigning the business's total costs to the specific departments that incur or drive them, creating a financial picture of each department's cost performance separately. Costs fall into two categories. Direct costs clearly belong to a specific department: production team wages belong to production, sales travel belongs to sales, fleet fuel belongs to delivery. These are assigned directly without allocation. Shared costs benefit multiple departments: rent for a building used by production, storage, and administration; electricity for that same building; accounting fees. These are allocated using a basis that reflects how each department uses or benefits from the cost, such as floor space percentage, headcount, or revenue share. The output is a department-wise cost report showing each department's direct costs plus its allocated share of shared costs, updated monthly to show whether each department is within budget or overspending.

A medium MSME food processing company in Pune, Maharashtra has four departments. Total monthly costs: Rs. 18.4 lakh. Without departmental allocation, the owner sees: salaries Rs. 7.2 lakh, rent Rs. 2.1 lakh, utilities Rs. 1.4 lakh, transport Rs. 2.8 lakh, raw materials Rs. 3.6 lakh, other Rs. 1.3 lakh. With departmental allocation: Production Rs. 8.9 lakh. Sales Rs. 3.1 lakh. Warehouse Rs. 2.6 lakh. Administration Rs. 3.8 lakh. The departmental view immediately shows that administration at Rs. 3.8 lakh is running at 42% of production's cost. For a manufacturing business of this size, administration typically runs at 20% to 25% of production cost. The consolidated P&L did not show this. The departmental report makes it obvious.

⬟ Why Cost Allocation Creates Accountability That Consolidated Reporting Cannot :

Departmental cost allocation delivers four specific management benefits. The first is making overspending visible and attributable. A cost increase in any department is immediately visible in that department's monthly report. The responsible manager can be asked to explain and held accountable. This is impossible in a consolidated P&L where a Rs. 1.2 lakh salary increase in administration is diluted across Rs. 18 lakh of total monthly costs. The second is enabling department-level budgeting. Once costs are tracked by department, each department receives a monthly cost budget. Actual versus budget by department creates a specific, actionable performance metric for each department head. The third is supporting pricing decisions. When the cost of production, sales, and delivery is known by department, the true cost of producing and selling each product can be calculated more accurately than from aggregated totals. The fourth is identifying efficiency opportunities. A department consistently above budget is a candidate for process review. A department consistently below budget at the same output level demonstrates a practice that may be replicable elsewhere.

A medium MSME pharmaceutical distributor in Hyderabad, Telangana introduced departmental tracking after selling and distribution costs rose from 8.4% to 13.2% of revenue over two years without a clear cause. The cost centre setup in Tally separated sales, delivery, and warehousing. The first monthly report showed delivery costs had increased by Rs. 1.9 lakh per month over twelve months: vehicle lease payments (tracked) plus informal per-trip contractor payments (not previously tracked). The delivery manager renegotiated the contractor rate, saving Rs. 74,000 per month. A medium MSME engineering services company in Bengaluru, Karnataka used departmental cost allocation to evaluate whether a proposed new site survey department was viable. The CA modelled its direct costs and allocated a 15% share of administration overhead. Fully-loaded cost: Rs. 4.8 lakh per month. The sales team confirmed Rs. 6.2 lakh per month in survey contracts were being declined due to capacity. The department was approved because the model showed positive contribution from day one.

For medium MSME owners, departmental cost allocation is the foundational step in transitioning from owner-managed single P&L accounting to management accounting with internal accountability. For department heads and managers, the monthly departmental cost report creates a personal financial accountability that most managers in growing MSMEs have not previously experienced. For chartered accountants advising MSMEs, setting up cost centre tracking in Tally for a four to six department business typically takes one full working day of configuration and one to two months of parallel running before the data is reliable enough to use for management decisions.

⬟ How Medium MSMEs Currently Manage Departmental Costs :

Most medium MSMEs manage costs through the consolidated P&L. Department-level data, where it exists, is informal: the owner's memory of which manager asked for resources, or the production manager's rough tracking of consumables. Formal departmental cost allocation is rarely in place before overhead has become a visible problem. The trigger is usually the owner noticing margin compression without a clear cause, or overhead as a percentage of revenue rising over two to three years. The implementation gap is not awareness but perceived complexity. Many MSME owners believe departmental tracking requires a sophisticated ERP. In practice, a Tally cost centre setup or a well-structured Excel model achieves 90% of the benefit with minimal ongoing effort once configured.

⬟ How Departmental Cost Tracking Is Evolving for MSMEs :

Cloud accounting adoption among Indian MSMEs, including Tally on Cloud, QuickBooks Online, and Zoho Books, makes cost centre tracking more accessible. These platforms allow cost centres to be configured and accessed by multiple users simultaneously, enabling department heads to view their own reports without manual distribution. Business intelligence tools connected to Tally exports, such as Microsoft Power BI, allow automated departmental cost dashboards that update in near real time from transaction data. Expense management platforms like Zoho Expense and EnKash allow departmental cost tagging at the point of expense submission, reducing retrospective allocation effort and improving accuracy.

⬟ How to Set Up Departmental Cost Allocation in Four Steps :

Setting up departmental cost allocation follows four steps. Define the departments. Identify four to six natural functional units: production or operations, sales and marketing, delivery or logistics, warehouse, and administration. Too few and the allocation loses management value. Too many and data collection becomes burdensome. Classify costs as direct or shared. For each P&L cost line, determine whether it belongs to one department (direct) or is shared. Direct costs are assigned in the accounting entry. Shared costs need an allocation basis. Choose allocation bases for shared costs. Floor space percentage for rent and utilities. Headcount percentage for administration and HR costs. Revenue percentage for management overhead. Usage-based metrics for shared vehicles or IT infrastructure. Apply the chosen basis consistently each month. Implement in Tally or Excel. In Tally Prime, create cost centres for each department and tag accounting entries. The cost centre-wise P&L report then shows department costs automatically from the transaction data. In Excel, a monthly allocation template populated from the Tally P&L export takes thirty to forty-five minutes per month.

● Step-by-Step Process

List the four to six departments to track. For each department, identify the department head accountable for its costs. Review the last twelve months of P&L line items and classify each cost as direct (assigned to one department) or shared (allocated across departments) with the CA. For each shared cost, choose the allocation basis and document the percentage split for each department. This becomes the allocation table applied consistently each month. In Tally Prime, create cost centres under Gateway of Tally > Accounts Info > Cost Centres. Enable cost centre tracking in the company features. Tag each accounting entry to the appropriate cost centre. Each month, run the cost centre-wise P&L from Tally. Apply the overhead allocation table for shared costs in the Excel overlay. Produce the departmental cost summary: actual versus prior month and versus budget. Share the report with each department head. Hold a brief review on any department running more than 10% above its prior period or budget.

● Tools & Resources

Tally Prime's cost centre feature is the most widely used tool for departmental cost tracking among Indian MSMEs. The configuration guide is available at tallysolutions.com. QuickBooks Online's class tracking feature and Zoho Books' project tracking feature serve the same function in cloud-based environments. For businesses not ready to implement in-software tracking, a structured Excel template with the cost classification table and the monthly allocation calculation achieves the same result using data exported from the accounting software. Zoho Expense and EnKash allow expenses to be tagged to departments at the point of submission, reducing the retrospective allocation work. The CA can configure Tally cost centres and build the Excel overlay template in one full working day.

● Common Mistakes

Allocating all shared costs using a single revenue percentage basis regardless of how the cost is actually driven is the most common mistake. Rent allocated by revenue percentage incorrectly burdens the sales department (which occupies little floor space) and under-charges the warehouse (which occupies most of the space). The allocation basis should match the cost driver: floor space for space-related costs, headcount for people-related costs, revenue for central management costs. Setting up cost centres in Tally but not using them consistently in every transaction is the second mistake. If some transactions are tagged and others are not, the departmental reports are incomplete and misleading. The entire accounting team must tag every relevant transaction to the correct cost centre from day one. Inconsistent tagging is harder to fix retrospectively. Presenting departmental cost reports to managers without explaining the methodology is the third mistake. A manager who receives a report showing their department spent Rs. 3.8 lakh against a budget of Rs. 2.9 lakh, without understanding how the allocation was calculated, will dispute the report rather than act on it.

● Challenges and Limitations

The allocation of shared costs involves judgment that cannot be eliminated. Two reasonable accountants can produce different department cost reports from the same data by choosing different allocation bases. Consistency matters more than precision: choosing a basis and applying it unchanged month to month makes the trend data meaningful even if the absolute allocation is imperfect. Departmental cost allocation adds accounting complexity that requires maintenance. When the business changes structure, the cost centre setup and allocation table must be updated. This is manageable but requires designated responsibility. Department heads newly accountable for their costs may initially resist or dispute the methodology. This is normal and should be addressed through transparency: sharing the allocation method clearly, allowing departments to question specific allocations, and refining the method where the challenge is valid.

● Examples & Scenarios

A medium MSME printing services company in Delhi NCR watched administration costs rise from Rs. 1.8 lakh to Rs. 3.1 lakh per month over two years. After implementing cost centres, departmental reports showed administration IT and software costs had risen from Rs. 18,000 to Rs. 64,000 per month through twelve separate software subscriptions approved by different managers with no central oversight. A single approval process was established for software expenditure above Rs. 2,000 per month. Seven redundant subscriptions were cancelled. Monthly savings: Rs. 38,000. A medium MSME auto components distributor in Nashik, Maharashtra used departmental cost data to build a case for outsourcing its delivery function. The departmental cost model showed fully-loaded monthly delivery cost of Rs. 2.7 lakh (salaries Rs. 1.4 lakh, vehicle depreciation Rs. 62,000, fuel Rs. 38,000, maintenance Rs. 24,000, allocated overhead Rs. 24,000). A logistics provider quoted Rs. 1.9 lakh per month for the same volume. The outsourcing saved Rs. 9.6 lakh per year.

● Best Practices

Implement departmental cost tracking during a stable operating period, not during rapid change or system transitions. The system needs two to three months of stable data before the reports are reliable enough to act on. Start with four cost centres maximum for the first implementation. Adding more later is straightforward. Too many centres initially creates data collection complexity and reduces the quality of the first reports. Link each department's monthly cost to a quarterly budget review. Without a budget, the report shows what happened but not whether it was expected. A pre-agreed monthly cost expectation per department converts the report from a historical record to an accountability tool.

⬟ Disclaimer :

This content is intended for informational and educational purposes only and does not constitute professional financial, accounting, or management consulting advice. Departmental cost allocation methods, Tally configuration approaches, and management accounting practices described in this article are general guidance and may not be appropriate for all business structures, accounting systems, or organisational designs. MSME owners should consult a qualified chartered accountant for guidance specific to their business.

⬟ How Desi Ustad Can Help You :

Start with one action this week: take the last month's P&L and classify each cost line as belonging to one of four departments (production or operations, sales, delivery, and administration). Apply a simple headcount-based allocation split for shared costs. Add up the total cost for each department. This rough analysis, done in two hours with the CA, will show whether any one department's cost is disproportionate to its size and contribution. That finding is the starting point for the accountability conversation.

Register your business with our online directory or join our bidding platform.

Frequently Asked Questions (FAQs)

Q1: What is the difference between a cost centre and a department in accounting?

A1: In Tally Prime, cost centres are defined in the accounting configuration and can be structured in a hierarchy. A parent cost centre called Production can have child cost centres for Line 1 and Line 2, allowing both line-level and department-level reporting. For most medium MSMEs implementing departmental cost tracking for the first time, creating one cost centre per department (Production, Sales, Delivery, Administration) is the right starting point. Finer sub-department tracking can be added later once the team is comfortable with the system and the management reporting discipline is established. The important distinction between cost

Q2: How do I choose the right allocation basis for shared costs?

A2: The practical process for choosing allocation bases is: for each major shared cost category, ask which departments cause or benefit from this cost and in what proportion. Rent: which departments occupy which floor areas? Measure and express as percentages. Electricity: for a manufacturing business, production typically uses 60% to 70% of electricity. Estimate based on installed equipment capacity. Owner or director salary: this is typically allocated by revenue percentage as the owner's attention broadly tracks the revenue contribution of each department. Vehicle costs for shared vehicles: allocate by number of trips or kilometres per department

Q3: How do I set up cost centres in Tally Prime for departmental cost tracking?

A3: A few practical implementation details for Tally cost centre setup: first, enable cost centres in the company features before creating them, as the sequence matters in some Tally versions. Second, for salary entries that are split across departments, Tally allows a single payment entry to be split across multiple cost centres in defined percentages using the cost category and cost centre allocation screen within the entry. Third, for shared costs like rent where the allocation is calculated externally (for example, production 60%, administration 25%, sales 15%), the allocation percentages can be entered directly in the

Q4: What should I do when a department consistently overspends its cost allocation?

A4: Consistent overspend in a department is most often caused by one of three things: the budget was set too low relative to the workload the department actually carries, specific cost categories have risen above the level assumed when the budget was set (for example, a salary increase or a utility price rise), or there is no spending approval discipline in the department (managers or staff can incur costs without prior authorisation). The corrective action should match the cause. If the budget was too low, revise it with a more realistic baseline. If specific costs have

Q5: Can cost allocation across departments be done in Excel without Tally cost centres?

A5: The Excel approach is particularly practical for businesses that are not yet ready to implement cost centre tracking in their accounting software, or where the accounting team does not have the Tally configuration skills. The monthly process is: export the P&L from Tally or other accounting software, paste it into the Excel model, and the allocation formulas produce the departmental cost report automatically. The limitation of the Excel approach versus Tally cost centres is that the Excel approach is retrospective: the allocation is calculated once a month after the accounting entries are complete, rather than

Q6: Should department heads be involved in setting their department's cost budget?

A6: Involving department heads in the budgeting process creates ownership of the cost target. When a manager has participated in setting their department's budget, they are more likely to understand why the target is what it is, to flag in advance when they anticipate costs above the budget, and to feel accountable when the actual cost exceeds the target. The practical process for a medium MSME: the owner and CA present each department head with the prior twelve months of actual departmental costs, the proposed budget for the next year, and the rationale for any planned

Q7: How does departmental cost allocation help with outsourcing or make-or-buy decisions?

A7: A common make-or-buy error in MSMEs is comparing only the direct cost of an internal function against the external quote, without including the allocated overhead. For example, an in-house delivery team with Rs. 1.4 lakh in direct salary and vehicle costs appears cheaper than a logistics provider quoting Rs. 1.9 lakh per month. But when the delivery team's allocated share of the factory rent, management time, HR overhead, and administration is included, the fully-loaded cost may be Rs. 2.4 lakh to Rs. 2.7 lakh per month. At that level, outsourcing at Rs. 1.9 lakh is

Q8: How many departments should a medium MSME track separately?

A8: The practical test for whether to add a department is: would knowing its costs separately change any management decision? If yes, track it separately. If not, combine it with the nearest related department. For most medium MSMEs, the natural split is production or operations (where the goods are made or the core service is delivered), sales and marketing (customer-facing costs), logistics or delivery (fulfilling orders), warehouse or inventory management (storing and managing stock), and administration (everything else). For service businesses, the equivalent split is typically delivery or billable services, sales and business development, and administration.

Q9: Does departmental cost tracking create more accounting work and cost for the business?

A9: The question of whether the cost of departmental tracking is worth the benefit depends on the size and complexity of the business. For a medium MSME with three to five departments, thirty to sixty staff, and Rs. 5 crore to Rs. 25 crore in revenue, the management value of departmental cost visibility almost always exceeds the implementation and maintenance cost. The one-time configuration cost is eight to twelve hours of CA time. The ongoing cost is thirty to sixty minutes per month of accounting time. Against this, the benefit is the ability to identify and

Q10: What is the difference between departmental cost allocation and product line profitability analysis?

A10: In many MSMEs, the two analyses overlap and can be combined. If the production department makes only Product A and Product B, the production cost centre data can be directly used in the product line profitability calculation. If the sales team dedicates different proportions of time to different product lines, the sales cost centre data can be allocated across product lines in proportion to time or transaction volume. The combination of departmental cost allocation and product line profitability produces a matrix view: which departments are operating cost-effectively, and which products are being supported by which
Please submit any questions via the 'suggestions' window. We are committed to enhancing the user experience by remaining fair, transparent, and user-friendly.


© 2025 - Desi Ustad, All rights reserved.
! Advertisements !
! Advertisements ! ⁈

These sections are reserved for advertisements. While our in-house advertising system is under development, Third party Ad-sense will be displayed here. For more information, please refer to our “Advertisements” insight.