EN
Bookkeeping

How Do You Measure Branch Profitability? A Guide to the Branch Income and Expense Table, Shared Cost Allocation and Break-Even Revenue

How do you measure profitability by branch? Branch income statement, shared cost allocation, branch break-even revenue and comparison: an 8-lesson guide with examples.

Contents 14 sections
  1. What will you be able to do by the end of this training?
  2. Lesson 1: Why isn't branch profitability measured by revenue?
  3. Lesson 2: How is data split by branch?
  4. Lesson 3: How do you prepare a branch income statement?
  5. Lesson 4: How do you separate direct expenses from shared costs?
  6. Lesson 5: Which key is used to allocate shared costs?
  7. Lesson 6: How is a branch's break-even revenue calculated?
  8. Lesson 7: How do you compare branches fairly?
  9. Lesson 8: How do you monitor the branch profitability report monthly?
  10. What are the most common mistakes in branch profitability?
  11. How does NetKasam make branch-level tracking easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Calculate each branch's contribution this month
  14. Frequently Asked Questions About Profitability by Branch

You have three branches and each one's revenue looks good. In the management meeting, the line "the Kadıköy branch made ₺450,000 in revenue" gets applause. But when you look at the cash at the end of the month, the company as a whole has earned less than you expected. Revenue does not show a branch's success; the number that shows what a branch earns is branch profitability. A branch can be second in revenue but last in profit, while another can be small but the most efficient location in the company. To know this, you need to draw up each branch's own income statement.

This article is not a lecture but an 8-lesson hands-on course. We will answer how to measure profitability by branch with a sample business that has three branches: we will work through the branch income statement, the split between direct and shared costs, the shared cost allocation key, branch break-even revenue and comparison between branches with figures. At the end there is a mini quiz and a monthly routine. For a single company's overall income statement, see the article how to prepare an income statement; here we bring the same logic down to the branch level.

What will you be able to do by the end of this training?

In short: You will draw up each branch's income statement, separate direct and shared costs, allocate shared costs with a key, find the branches' break-even revenue and compare branches fairly.

Course mapSix steps of a branch profitability analysis
  1. 01
    SplitTag sales and expenses by branch.
  2. 02
    GrossDeduct the cost of goods sold from the branch's net sales.
  3. 03
    DirectSubtract branch-specific expenses such as rent, staff and energy.
  4. 04
    SharedAllocate headquarters costs with an allocation key.
  5. 05
    Break-evenCalculate break-even revenue for each branch.
  6. 06
    DecideCompare branches by contribution and net result, and take action.

The course's 8 lessons: (1) why branch profitability isn't measured by revenue, (2) splitting data by branch, (3) the branch income statement, (4) direct and shared costs, (5) the allocation key, (6) break-even revenue, (7) comparing branches, (8) a monthly routine.

Lesson 1: Why isn't branch profitability measured by revenue?

In short: Revenue shows how much a branch sells; profitability shows how much of what it sells stays with the company. Differences in margin, rent and staff can make the revenue ranking completely different from the profit ranking.

Our sample business has three branches: Headquarters (A), the Kadıköy store (B) and the Çankaya store (C). Their monthly net sales are A ₺600,000, B ₺450,000, C ₺300,000 (the figures were chosen only to illustrate the method). The revenue ranking is A, B, C. We will see the profit ranking in the coming lessons; the surprise is B.

CriterionWhat does it show?Can it be misleading?
RevenueSales volumeYes; margin and expenses are invisible
Gross profitWhat is left from selling goodsPartly; branch expenses are missing
Branch contributionWhat is left after direct expensesSlightly; no share of shared costs
Branch net resultWhat is left after the share of shared costsDepends on the key

Lesson 2: How is data split by branch?

In short: Branch profitability depends on specifying, at the moment of recording, which branch every sale and every expense belongs to. Branch information guessed after the fact is not reliable.

  1. Link sales to the branch: Every sale should carry which branch or warehouse it was made from.
  2. Link inventory movements to the branch: The cost of goods sold should come out of the branch's stock.
  3. Tag expenses to the branch: Select the branch when entering expenses such as rent, energy and staff.
  4. Keep shared costs separate: Label expenses such as headquarters accounting, software and management as "shared".
  5. Link users to the branch: An employee should see and process only their own branch's transactions.

In NetKasam, by reporting each of your branches or warehouses separately, you can see your inventory and sales separately and, if you wish, compare a branch's sales with other branches (branch and warehouse management, can I see my branch inventory and sales separately). To tag expenses by employee or branch, see the expense management page. If you want to set up a stock map for channels and warehouses, take a look at the article how to manage store and e-commerce inventory from one center.

Free toolProfit Margin Calculator

Lesson 3: How do you prepare a branch income statement?

In short: A branch income statement is the overall income statement brought down to the branch: net sales, cost of goods sold, gross profit, direct expenses, branch contribution, share of shared costs and net result are listed one below the other.

Item (monthly, ₺)A: HeadquartersB: KadıköyC: ÇankayaTotal
Net sales600.000450.000300.0001.350.000
Cost of goods sold360.000315.000192.000867.000
Gross profit240.000135.000108.000483.000
Gross margin%40,0%30,0%36,0%35,8
Direct expenses (rent, staff, energy)130.00095.00040.000265.000
Branch contribution110.00040.00068.000218.000
Share of shared costs (by net sales)40.00030.00020.00090.000
Branch net result70.00010.00048.000128.000
Net margin%11,7%2,2%16,0%9,5
ChartTotal of three branches: from ₺1,350,000 net sales to ₺128,000 net result
  1. Net sales₺1,350,000
  2. Cost of goods sold−₺867,000
  3. Gross profit₺483,000
  4. Direct expenses−₺265,000
  5. Total branch contributions₺218,000
  6. Shared costs−₺90,000
  7. Net result₺128,000

Prepared with sample values.

Kadıköy, second in revenue, is last in net result: its gross margin is 30% (lower than the others) and its direct expenses are ₺95,000. Small Çankaya is first in net margin at 16%. To review the structure of the overall income statement, see the income statement guide; for the difference between gross and net profit, see the article on profit margin.

Recommended readingHow to Prepare an Income Statement?

Lesson 4: How do you separate direct expenses from shared costs?

In short: A direct expense is one that will disappear if the branch closes (rent, branch staff, energy). A shared cost is a headquarters expense that continues even if the branch closes (general management, accounting, software). The split is the key to seeing the branch's true contribution.

ExpensesTypeWhy?
Branch rentDirectEnds when the branch closes
Branch staff salaries and bonusesDirectTied to the branch
Branch energy, internetDirectTied to the branch
Branch shipping and packaging materialsDirectRises with branch sales
Headquarters accounting, management salariesSharedContinues even if the branch closes
Accounting software and general marketingSharedServes all branches

Lesson 5: Which key is used to allocate shared costs?

In short: Shared costs can be allocated by share of net sales, number of employees, floor area or equally. The choice changes the result; so write the key down from the start, use the same one every month and question the cause, not the result.

KeyA: HeadquartersB: KadıköyC: ÇankayaInterpretation
Share of net sales (600/450/300)40.000 ₺30.000 ₺20.000 ₺Most common; puts more burden on the larger branch
Equal split30.000 ₺30.000 ₺30.000 ₺Simple; strains the small branch
Share of branch contribution (110/40/68)45.413 ₺16.514 ₺28.073 ₺Penalizes the profitable branch; not recommended

With an equal split, net results are A 80,000, B 10,000, C ₺38,000: the ranking does not change, but C's net result drops from ₺48,000 to ₺38,000. When the choice of key is disputed, looking at branch contribution is the most solid approach, because direct expenses are not open to debate.

Lesson 6: How is a branch's break-even revenue calculated?

In short: Branch break-even revenue = direct expenses ÷ gross margin. Below this revenue, the branch does not contribute to the company. The difference between actual revenue and break-even revenue, expressed as a percentage of revenue, is the margin of safety.

FormulaSix formulas for branch profitability analysis
  1. Gross profit = Net sales − Cost of goods sold
  2. Branch contribution = Gross profit − Direct expenses
  3. Branch net result = Branch contribution − Share of shared costs
  4. Break-even revenue = Direct expenses ÷ Gross margin
  5. Margin of safety = (Net sales − Break-even revenue) ÷ Net sales
  6. Net margin = Branch net result ÷ Net sales

The break-even formula assumes direct expenses are fixed; if the margin changes, it is recalculated.

BranchAccountBreak-even revenueActual revenueMargin of safety
A: Headquarters130.000 ÷ 0,40325.000 ₺600.000 ₺%45,8
B: Kadıköy95.000 ÷ 0,30316.667 ₺450.000 ₺%29,6
C: Çankaya40.000 ÷ 0,36111.111 ₺300.000 ₺%63,0

Çankaya has a margin of safety equal to 63% of its revenue: even if revenue falls by more than half, it does not lose money. Kadıköy's margin is 29.6%; if revenue falls by about 30%, the branch's contribution drops to zero. To widen this margin, you need to improve either the gross margin (price, cost, discounts) or direct expenses (rent, staff). For the margin effect, see the article how to discount without losing money, and for break-even logic, see how to calculate the break-even point.

ChartBranches' net margin: Kadıköy, second in revenue, is last in profitability
  1. C: Çankaya16.0%
  2. A: Headquarters11.7%
  3. B: Kadıköy2.2%

Prepared with sample values. Net margin = net result ÷ net sales.

Lesson 7: How do you compare branches fairly?

In short: Compare branches not only by revenue but also by gross margin, branch contribution, net margin and margin of safety. Also evaluate branches of different sizes with ratios such as sales per m² or sales per employee.

IndicatorA: HeadquartersB: KadıköyC: ÇankayaBest
Net sales600.000 ₺450.000 ₺300.000 ₺A
Gross margin%40,0%30,0%36,0A
Branch contribution110.000 ₺40.000 ₺68.000 ₺A
Net margin%11,7%2,2%16,0C
Margin of safety%45,8%29,6%63,0C

Ways to rescue Kadıköy: increase gross margin (discount discipline, product mix, cost), reduce direct expenses (shift planning, renegotiating rent) or increase sales (campaigns, combining with the online channel). Take seasonality into account when comparing: do not decide based on a single month of the year. For sales forecasting, see the article how to forecast sales.

Takeaways from the exampleFour numbers from the sample branch analysis
  • ₺128,000total net result of the three branches
  • 2.2%Kadıköy's net margin (second in revenue)
  • 16.0%Çankaya's net margin (last in revenue)
  • 29.6%Kadıköy's margin of safety

Lesson 8: How do you monitor the branch profitability report monthly?

In short: Draw up the branch income statement with the same template every month and compare it with the previous month and the same month last year. The trend is more valuable than a single month's figure.

When?What to do?Who?
Every weekTake a quick look at branch revenue and gross marginBranch manager
Month-end +3 daysDraw up the branch income statement and allocate shared costsAccounting
Month end +5 daysCompare branches and have deviations explainedManager
Once a quarterUpdate break-even revenue and margins of safetyAccounting
Once a yearReview the allocation key and branch targetsManagement

To set up a profit-based bonus system for the branch manager, see the article how to calculate sales bonuses; to define permissions for branch users, see the article on user permissions.

What are the most common mistakes in branch profitability?

  1. Ranking branches by revenue. Differences in margin and expenses are invisible.
  2. Not tagging expenses to the branch. Direct expenses cannot be assigned to the branch.
  3. Ignoring shared costs. Branches look more profitable than they are.
  4. Changing the allocation key every month. Comparison becomes meaningless.
  5. Deciding on net result without seeing contribution. The closed branch's share of shared costs is shifted onto the others.
  6. Not taking the season into account. A single month's figure is misleading.
  7. Not calculating break-even revenue. The branch's risk margin is unknown.

How does NetKasam make branch-level tracking easier?

  • Branch and warehouse reports. You report each of your branches or warehouses separately, see your inventory and sales separately and compare your branches (branch and warehouse management).
  • Branch-specific users and permissions. You define separate users and permissions for each branch.
  • Wholesale and retail separation. You define your branches' sales terms and block sales outside them.
  • Expense tracking. You categorize expenses and report them by employee (expense management).
  • Saved reports. You save the monthly branch report and export it to Excel (reports).
  • Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.

Mini quiz: Test what you have learned

In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.

  1. If net sales are ₺400,000, the cost of goods sold is ₺280,000 and direct expenses are ₺70,000, what is the branch contribution?
  2. If the same branch's share of shared costs is ₺20,000, what are the net result and net margin?
  3. If the gross margin is 30% and direct expenses are ₺90,000, what is the break-even revenue?
  4. Why can closing a branch with positive contribution but a negative net result be risky?
  5. Why shouldn't you change the shared cost allocation key often?

Answer key:

  1. Gross profit is ₺120,000; contribution is 120,000 − 70,000 = ₺50,000.
  2. 50,000 − 20,000 = ₺30,000; net margin is 30,000 ÷ 400,000 = 7.5%.
  3. 90.000 ÷ 0,30 = 300.000 ₺.
  4. Shared costs do not disappear when the branch closes; its share is shifted onto the other branches and the company's result gets worse.
  5. Comparisons between branches and between periods become meaningless.

Frequently Asked Questions About Profitability by Branch

How do you measure profitability by branch?

Branch contribution is found by deducting the cost of goods sold and direct expenses from each branch's net sales, and the net result is calculated by subtracting its share of shared costs. Branches are compared by contribution, net margin and break-even revenue.

What is the difference between a direct expense and a shared cost?

A direct expense is specific to the branch and disappears when the branch closes (rent, branch staff). A shared cost is incurred at headquarters and serves all branches (management, accounting, software).

How are shared costs allocated?

They can be allocated by share of net sales, number of employees, floor area or equally. What matters is to write down the key from the start and use the same one every month.

What is branch break-even revenue?

It is the revenue at which the branch starts contributing to the company: direct expenses divided by gross margin. For example, with ₺95,000 in expenses and a 30% margin, break-even revenue is ₺316,667.

Is the decision to close a branch made by looking at its net result?

Branch contribution is looked at first. If its contribution is positive, a branch that appears to be losing money because of its share of shared costs may make the company's result worse if it closes.

How do I compare branches fairly?

Along with revenue, look at gross margin, branch contribution, net margin and margin of safety; for different sizes, look at sales per m² or per employee, and take seasonality into account.

Can I see branch inventory and sales separately in NetKasam?

Yes. By reporting each of your branches or warehouses separately, you can see your inventory and sales separately and, if you wish, compare a branch's sales with your other branches.

Can I define separate users for branches in NetKasam?

Yes. You can define separate users and separate permissions for each of your branches or warehouses.

Conclusion: Calculate each branch's contribution this month

Branch profitability looks like a complex financial analysis, but at its core there are three lines: gross profit, direct expenses and share of shared costs. This month, pull these three lines for each branch, calculate break-even revenue and rank the branches by net margin. If the ranking differs from the revenue ranking, your first meeting agenda is ready.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeProfit Margin Calculator

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools