Would you approve another delivery vehicle for your busiest branch?
The sales figures could make a strong case. But how much does the branch earn after serving those customers? If central delivery costs sit elsewhere or supplier rebates arrive as a later adjustment, the P&L in front of you may leave part of that answer out.
Multi-branch distribution finance needs to give you a dependable basis for that decision. This starts with a branch P&L you can trace through stock movements and shared-cost calculations. You need to see what each site contributes before central costs, then what remains after its share of those costs. Otherwise, an expansion decision can rest on a figure you’ll have to revise.
Multi-Branch vs Multi-Entity Finance: What’s the Difference?
Multi-branch finance tracks performance across operating sites. Multi-entity finance manages the accounts of separate legal companies. A distributor can need both, depending on which companies own its branches.
Multi-branch finance: comparing sites within a company
If your depots all belong to one limited company, you need to identify the sales and costs for each location. The finance task is to produce a useful P&L for every branch and apply shared costs consistently. Having several sites doesn’t, by itself, create a need for intercompany consolidation.
Multi-entity finance: reporting across separate companies
Where branches belong to different companies within a group, the work also includes separate company accounts, intercompany transactions, and group reporting. You still need to see how each branch performs within those companies.
A group could own two companies with several depots each. Map the depots to their companies first, then establish the branch and company views you need. A company-wide profit figure can hide differences between its branches.
What Makes a Branch Profit Figure Reliable?
A useful branch profit and loss report shows the result before and after shared central costs. Those views help you judge the branch’s own performance and its contribution to the wider business.
Show contribution before central costs
Show gross profit, the branch’s own operating costs, and its contribution before shared central costs. Then show the allocated costs separately, followed by the result after those charges. Use the same definitions across sites, including where you place delivery and warehouse costs. That gives you a consistent basis for asking why two branches with similar sales produce different returns.
Show the effect of central allocations
A branch manager needs to understand the costs they can influence. You also need to see whether the branch supports the wider business. Keep both views available when judging performance. A fully allocated loss alone doesn’t tell you what the business would save if that branch closed: some central costs could remain and fall on the other sites.
Why Distribution Branch Profits Become Hard to Compare
Sales can reach the correct branch while the related costs follow a different route. Stock movements, shared services, and purchasing arrangements each need clear treatment before the branch comparison is useful.
Stock transfers leave costs hard to follow
One branch takes an order and another supplies the stock. Your reporting needs to identify which branch gets the customer sale, where the cost of those goods appears, and how the delivery cost is assigned. Otherwise, a branch helping another site fulfil orders can carry costs without a clear explanation of the benefit it provides.
Transfers that cross month-end also need a record of despatch, receipt, and any goods still in transit. Set responsibility for checking open transfers and investigating differences. A shared finance system still needs the warehouse team to confirm what actually arrived.
Shared costs reach branches on different terms
Central transport, purchasing, and finance support can serve several sites. A turnover-based allocation is easy to calculate, but it can give a poor picture of transport use where one branch sells large orders locally and another needs long delivery routes for smaller orders.
Choose a basis you can explain for each material cost pool, using reliable activity data where it’s relevant. Document the method and apply it consistently. When a method changes, show its effect separately so the manager can distinguish a change in trading from a change in the calculation.
Supplier rebates obscure the comparison
A supplier agreement negotiated centrally can cover purchases for several branches. Keep a record of which purchases qualify and how the benefit reaches branch reporting. For businesses applying FRS 102, paragraph 13.6 of the Financial Reporting Council’s standard requires purchase rebates to reduce inventory purchase costs. Check that treatment before deciding how the benefit appears in each branch’s margin.
Show where rebate estimates affect the reported margin and explain later adjustments. That helps you identify whether a stronger result came from trading performance or revised purchasing assumptions.
The allocation method can change which branch appears to be performing best.
How Shared Costs Change the Branch Comparison
Consider how a sales-based allocation compares with one based on delivery activity. The calculation below shows the effect on branch results and the questions to ask before using either figure to approve more spending.
The same business, with two allocation methods
Two branches share a £60,000 central delivery cost in this hypothetical month. The branch costs below exclude that shared delivery cost. Assume vehicle hours are recorded reliably: Branch A uses 40% and Branch B uses 60%.
| Management reporting measure | Branch A | Branch B |
|---|---|---|
| Sales | £600,000 | £400,000 |
| Gross profit | £150,000 | £100,000 |
| Branch operating costs | £100,000 | £60,000 |
| Contribution before shared delivery costs | £50,000 | £40,000 |
| Delivery allocation based on sales: 60% / 40% | £36,000 | £24,000 |
| Result using sales allocation | £14,000 | £16,000 |
| Delivery allocation based on vehicle hours: 40% / 60% | £24,000 | £36,000 |
| Result using vehicle-hours allocation | £26,000 | £4,000 |
The two methods are alternatives. Allocating £60,000 by sales charges Branch A £36,000 and Branch B £24,000. Using vehicle hours reverses those charges. The business still earns £30,000 after the shared delivery cost, but the apparent ranking of its branches changes.
Use the example to question the method
Vehicle hours are one possible basis. Your fleet costs may also reflect distance, capacity, and outsourced deliveries. The useful question is whether your chosen basis explains the cost well enough for the decision you’re making. A turnover split needs scrutiny if a lower-sales branch uses most of the delivery capacity.
Keep the contribution figure visible alongside the allocated result. If you’re considering another vehicle, you’ll also need the expected additional cost and capacity. An average allocation of today’s fleet costs can’t answer that investment question on its own.
How Sage Intacct Supports Branch Profitability Reporting
Sage Intacct can bring branch reporting and shared-cost calculations into your finance system. The main areas to configure are branch dimensions and allocation rules, plus the links to operational systems. Separate companies also need intercompany settings.
Report by branch without rebuilding the accounts
Sage’s dimensions documentation explains how transactions can carry attributes such as location and department. You can use location to identify the branch, then filter or group the records in financial reports. Sage’s financial reporting documentation also supports location structures for showing individual sites and regional totals.
With the branch codes captured correctly and the reports configured, you can use the same P&L layout for each location. That lets your team run the branch comparison again without rebuilding it. For example, a branch review and a regional review can use the same underlying records, with the relevant locations selected. Missing or incorrect codes still need a check before the results go out.
Apply shared-cost rules with a calculation you can inspect
Sage’s allocations documentation distinguishes transaction allocations from Dynamic Allocations. Transaction allocations split an amount using a preset definition when the transaction is entered. Dynamic Allocations distribute account balances periodically using the calculation method you define.
For the delivery example, a configured Dynamic Allocation could use vehicle hours recorded in statistical accounts to calculate each branch’s share. You can retain the reason for the method in the allocation definition and inspect the calculations attached to the generated journal. Finance can then answer the manager’s question about a charge from the recorded calculation. Dynamic Allocations requires its own subscription and setup; your team chooses the method and checks the activity data.
Connect the branch activity to the financial record
If you retain a separate stock or branch trading system, agree which system owns each record and what detail reaches Sage Intacct. The integration needs the branch identifiers and relevant dates to support the reports you intend to run. A daily total without the required branch detail leaves finance with another allocation task.
Include failed data imports and corrections in the integration design. Someone needs to know when a batch hasn’t arrived, how it’ll be corrected, and whether the branch report is complete enough to use.
Add intercompany controls where separate companies exist
Where your branches operate through separate companies, Sage Intacct can generate inter-entity receivable and payable entries for configured transactions, such as one company paying another’s bill. Sage’s multi-entity documentation sets out the required account mapping and balancing settings. That reduces manual posting between entities while keeping the additional company-level work separate from ordinary branch analysis.
What To Test Before You Change Your Branch Reporting
Take one completed month into a reporting review or system demonstration. Use it to test whether the figures can be explained, and whether the same process will work at the next close.
Follow one branch’s result back to its records
Choose a branch whose result generated questions. Trace its sales and stock costs, then inspect the shared charges and any rebate adjustments. Ask for the report before and after central allocations, with the calculation behind each material charge.
Use an actual transfer that crossed period-end to test how the movement appears. If you need a spreadsheet to explain a number, identify exactly what information or calculation is missing from the system. That becomes a specific implementation requirement.
Agree when the branch figure is ready to use
Set the checks that must happen before managers receive the final report. These should cover missing branch codes, unprocessed operational data, open transfers, and material allocation adjustments. Give each check an owner and a place in the close timetable. If a report goes out before the allocation run, label it clearly so managers know which costs are still to come.
Also agree how later corrections will be communicated. A manager should be able to see what changed and why. Consistent reporting includes a clear treatment of revisions; it cannot depend on every transaction being right first time.
Use Branch Profit to Decide Where to Invest
When you approve spending on a branch, you should know how much it contributes and which costs the decision will add. A report that needs several adjustments outside the system makes that answer harder to reach and harder to explain to the manager.
Sage Intacct gives you the reporting and allocation tools to build that view within your finance system. Through our implementation and ongoing support services, we help configure the reports, posting rules, and system connections your team needs. If you’re still rebuilding branch profit each month, a discovery session with us is a useful place to start. Bring a recent branch P&L and the question it couldn’t answer.
References
- Financial Reporting Council: FRS 102, September 2024, paragraph 13.6
- Sage: Sage Intacct Dimensions
- Sage Help: Dimension structures for financial reports
- Sage Help: Allocations overview
- Sage Help: Create an allocation definition
- Sage Help: Set up Dynamic allocations
- Sage Help: Manage multiple entities
