Allocate shared costs when support departments serve each other

An IT department can support administration while administration supports IT. Allocating each team's direct spending only to operating departments ignores that exchange. A reciprocal allocation reflects it by solving the support departments together before assigning their costs to the final recipients.

First decide why the allocation is needed. An internal full-cost report may benefit from a more complete service picture. A decision about an extra order may instead depend on incremental costs. The allocation method should fit the report's purpose; a more detailed distribution does not make every allocated dollar avoidable.

ACCA describes direct, step-down and reciprocal methods of reallocating service cost-center costs. Its reciprocal method uses simultaneous equations or repeated distribution. The original example below uses two support departments so the arithmetic and the reconciliation can be followed without specialized software.

Assume IT has $100,000 of direct cost and Administration has $60,000. IT's measured services go 20% to Administration, 50% to Operations A and 30% to Operations B. Administration's services go 10% to IT, 30% to A and 60% to B. Each supplying department's percentages total 100%.

Let I represent IT's total cost after receiving Administration's service, and let A represent Administration's total after receiving IT's service. The equations are I = $100,000 + 10% × A, and A = $60,000 + 20% × I. The symbols describe the total pools to be distributed, including the internal service received.

Use different labels for the Administration cost variable and Operations A in the actual workbook to avoid confusion. Here the equations refer to the support departments; the operations are the final recipients. Retain the service measurement behind each percentage rather than estimating shares merely to produce a desired departmental margin.

Substitute the Administration equation into the IT equation: I = $100,000 + 10% × ($60,000 + 20% × I). This becomes I = $106,000 + 2% × I, so 98% × I = $106,000. IT's reciprocal pool is approximately $108,163.27.

Administration's pool is then $60,000 plus 20% of $108,163.27, approximately $81,632.65. Operations A receives 50% of the IT pool plus 30% of the Administration pool, approximately $78,571.43. Operations B receives the remaining final-recipient shares, approximately $81,428.57.

The final operating allocations total exactly $160,000 before rounding, matching the original direct costs. The reciprocal support pools themselves total more than $160,000 because they include services exchanged internally. Do not add those gross pools to the original spending and report the result as new company cost.

A direct method would ignore services between the support departments and rescale each team's shares across operations. IT would allocate $62,500 to A and $37,500 to B. Administration would allocate $20,000 to A and $40,000 to B. The totals become $82,500 and $77,500, still summing to $160,000 but distributing it differently.

A step-down approach recognizes some internal services in a chosen sequence. If IT is allocated first, Administration receives $20,000 and then distributes its $80,000 pool across the remaining operations. This gives approximately $76,666.67 to A and $83,333.33 to B. Reversing the sequence gives $84,250 and $75,750 in this example.

That order dependence is a property of the method, not necessarily a spreadsheet error. Document the selected approach and its rationale. A change of method can move departmental profit even when no spending or service consumption changes, so show that effect separately when comparing periods.

Check percentages in their stored form. Entering 20 where a formula expects 0.20 can create a circular system with meaningless results. In the example, substitution leaves a 0.98 coefficient because the two reciprocal shares multiply to 0.02. If measured services circulate almost entirely between support teams, gross pools can become very large relative to direct spending. Investigate whether the recipient definitions still describe useful final services before interpreting those gross totals as departmental inefficiency.

Choose a driver that reflects the supplied service. Ticket counts may be weak when a small password reset and a complex implementation consume very different effort. Headcount can be reasonable for some administration work and unsuitable for transaction-heavy work. Consider whether a small number of separate cost pools would describe the services more faithfully.

Preserve the measurement period and recipient population. A new department, an outsourced activity or missing usage records can change the denominator. A percentage table that still totals 100% can conceal an omitted recipient because the remaining shares were automatically rescaled.

Avoid circular measurement rules where a department's allocated cost becomes the driver used to allocate that same cost back to it. The reciprocal equations handle an explicitly defined exchange of services; they do not justify arbitrary percentages that change whenever the output changes. Review the business meaning of each link before adding another equation.

Reconcile the source pools to the ledger, remove any cost already directly charged to recipients, and check that final allocations sum to the intended source total. Preserve full calculation precision, then assign any presentation rounding difference visibly. A department should not receive a duplicate charge through both direct billing and the shared pool.

These internal calculations do not automatically establish intercompany invoices, tax transfer prices, grant claims or statutory inventory values. Those uses may have their own applicable policies and requirements. Obtain the relevant accounting decision before reusing an internal full-cost number for another purpose.

The final report should show the cost pools, service basis, method, recipient amounts and method changes. Discuss whether the result changes a real management decision. Where reciprocal services are immaterial, the cost of maintaining detailed measurements may exceed the benefit; where they materially shift responsibility, the transparent equations give the conversation a firmer basis.