How to Track Profit by Department or Location
Why one company-wide profit figure hides the problem
A business running three branches, two warehouses, or a handful of projects gets one profit number from its books. That number is real, but it is an average — and averages hide the branch that is quietly losing money while the other two carry it.
The usual workaround is to clone the chart of accounts: Rent — Branch A, Rent — Branch B, Rent — Branch C, then the same again for wages, utilities and everything else. The chart of accounts triples in size, every posting becomes a guessing game about which of six near-identical accounts to pick, and adding a fourth branch means another full round of account creation.
The fix is to stop overloading the account with two jobs. Keep the account answering what kind of transaction it is, and add a separate dimension answering which part of the business it belongs to. That second dimension is a cost center, and it is what lets you slice the same books by location without touching the chart of accounts at all.
Why this happens
- The chart of accounts is the only dimension available, so location detail has to be encoded into account names.
- Duplicated per-branch accounts make the chart unusable and postings error-prone.
- Shared overheads like rent and admin salaries have no obvious home, so they land in one bucket and distort every branch comparison.
- Without a per-location breakdown there is no way to tell a genuinely unprofitable site from one absorbing shared cost.
Biznsbook addresses this through cost centers, the Cost Center Summary report, cost center filters on the trial balance and P&L, per-line tagging on journal vouchers once cost centers are enabled — a free company-settings toggle included with the Accounting or Finance module, not a separate purchase.
Finance teams lose days each month reconciling versions that should never have diverged. Naming Biznsbook screens as the system of record — and closing periods when agreed — prevents silent edits that auditors flag immediately.
Step-by-step: Track Profit by Department or Location
Written for owners, controllers and bookkeepers running more than one branch, warehouse or project — a Company Admin turns cost centers on once, then finance staff tag entries as they post them.
- Turn on cost centers. A Company Admin ticks Enable cost centers under Finance & Accounting → General Ledger & CoA → Accounting settings. It is free and included with the Accounting or Finance module.
- Create a cost center per unit you want to measure. Give each one a short unique code and a name — BR-01 / Karachi Branch, WH-01 / Warehouse A, PRJ-42 / Project Riverside — and pick a type such as Department, Location or Project.
- Add a parent for roll-ups. Optionally nest cost centers, so two branches sit under a Retail Division parent and you can read either level. Biznsbook rejects any parent that would create a loop.
- Tag journal voucher lines. Each line on a journal voucher has its own cost center picker, so a single voucher can split across several cost centers.
- Tag expenses and advances. Pick a cost center on the expense or advance request form and it is carried onto the ledger lines automatically when that expense posts.
- Pull the Cost Center Summary. Reporting → Cost center summary shows debit, credit, net, revenue, expenses and profit per cost center for a date range, with children indented under their parents and an Excel export.
- Read the Unassigned row as a progress bar. Everything not yet tagged sits in an explicit Unassigned row. As you tag more it shrinks — and the named rows plus Unassigned always equal your real totals.
Review results after the first full monthly cycle. Adjust roles, mappings, or approvals where the same exception repeats.
Screen-level flows live in the Help Center. This guide focuses on the business process; help articles cover click-by-click navigation.
Common mistakes to avoid
- Mistake 1: The chart of accounts is the only dimension available, so location detail has to be encoded into account names. Repeating this each month usually shows up first in a per-location profit figure nobody can trust.
- Mistake 2: Duplicated per-branch accounts make the chart unusable and postings error-prone. Repeating this each month usually shows up first in a per-location profit figure nobody can trust.
- Mistake 3: Shared overheads like rent and admin salaries have no obvious home, so they land in one bucket and distort every branch comparison. Repeating this each month usually shows up first in a per-location profit figure nobody can trust.
- Mistake 4: Without a per-location breakdown there is no way to tell a genuinely unprofitable site from one absorbing shared cost. Repeating this each month usually shows up first in a per-location profit figure nobody can trust.
Track recurring exceptions in month-end notes; each should map to a control above.
Best practices that hold up as you scale
- Turn on cost centers — A Company Admin ticks Enable cost centers under Finance & Accounting → General Ledger & CoA → Accounting settings.
- Create a cost center per unit you want to measure — Give each one a short unique code and a name — BR-01 / Karachi Branch, WH-01 / Warehouse A, PRJ-42 / Project Riverside — and pick a type such as Department, Location or Project.
- Add a parent for roll-ups — Optionally nest cost centers, so two branches sit under a Retail Division parent and you can read either level.
- Tag journal voucher lines — Each line on a journal voucher has its own cost center picker, so a single voucher can split across several cost centers.
- Tag expenses and advances — Pick a cost center on the expense or advance request form and it is carried onto the ledger lines automatically when that expense posts.
Tag consistently rather than exhaustively. A handful of cost centers everyone actually uses beats a detailed scheme half the team ignores, and the Unassigned row will tell you honestly which one you have.
How Biznsbook supports this workflow
cost centers is documented in Biznsbook Accounting / Finance capabilities. Use it as part of a controlled finance process — posting, review, and period close — not as an isolated export. When Sales, Purchase, Inventory, Taxation, Expense, or Finance Management modules are enabled, related documents can post through the central accounting posting service with double-entry validation.
the Cost Center Summary report is documented in Biznsbook Accounting / Finance capabilities. Use it as part of a controlled finance process — posting, review, and period close — not as an isolated export. When Sales, Purchase, Inventory, Taxation, Expense, or Finance Management modules are enabled, related documents can post through the central accounting posting service with double-entry validation.
cost center filters on the trial balance and P&L is documented in Biznsbook Accounting / Finance capabilities. Use it as part of a controlled finance process — posting, review, and period close — not as an isolated export. When Sales, Purchase, Inventory, Taxation, Expense, or Finance Management modules are enabled, related documents can post through the central accounting posting service with double-entry validation.
per-line tagging on journal vouchers is documented in Biznsbook Accounting / Finance capabilities. Use it as part of a controlled finance process — posting, review, and period close — not as an isolated export. When Sales, Purchase, Inventory, Taxation, Expense, or Finance Management modules are enabled, related documents can post through the central accounting posting service with double-entry validation.
Two permissions govern access: Finance.ViewCostCenters for the list and report filters, Finance.ManageCostCenters for creating, editing and deactivating. Both are already granted to the Finance Manager and Accounts Manager roles.
Suggested implementation timeline
- Week 1: Document current process gaps and configure cost centers with finance owner sign-off.
- Weeks 2–3: Pilot on one month or one entity; post all test transactions through Biznsbook; freeze parallel spreadsheet journals.
- Week 4: Run first trial balance or report tie-out; fix mapping and permission issues.
- Month 2–3: Roll out to full team; add approvals and period close cadence from this guide.
- Ongoing: Monthly review using what cost centers do not do yet and leadership dashboard.
Metrics to track monthly
- Profit per cost center for the period
- Share of ledger lines still Unassigned
- Revenue and expense split across branches or warehouses
- Cost center totals reconciled against the unfiltered trial balance
Start with three metrics; trend direction matters more than a single point-in-time snapshot.
Spreadsheet / manual books vs integrated ERP
Compare typical manual finance work with Biznsbook cost centers and related capabilities.
| Capability | Manual / Spreadsheet | Biznsbook |
|---|---|---|
| Adding a new location | ❌ Clone every expense account again | ✅ Create one cost center |
| Chart of accounts size | ❌ Grows with every location | ✅ Unchanged |
| Splitting one entry | ❌ One account per line, no overlap | ✅ Different cost center per voucher line |
| Roll-up reporting | ❌ Manual spreadsheet grouping | ✅ Parent cost centers with indented children |
| Partially tagged data | ❌ Silently misleading | ✅ Explicit Unassigned row that still reconciles |
| Retiring a location | ❌ Delete or hide accounts, risk history | ✅ Deactivate; tagged history stays intact |
What cost centers do not do yet
Automatic tagging from operational documents is not shipped: sales, purchases, goods receipts, stock transfers, POS sales and payroll all post unassigned today, and only journal vouchers, expenses and advances can be tagged. There are also no per-cost-center budgets and no allocation rules to split one line across several cost centers by percentage — a shared rent charge has to be entered as separate lines if you want it split. The Cost Center Summary indents children under their parents but reports each row's own activity rather than adding child totals into the parent.
Document this in your finance SOP and revisit each quarter as transaction volume or entity structure changes.
Frequently asked questions
Is cost center tracking a paid add-on in Biznsbook?
No. It is free and built in for any company with the Accounting or Finance module. A Company Admin switches it on from Finance → Accounting settings — there is nothing to purchase and nothing for SiteAdmin to provision.
Which transactions can carry a cost center today?
Journal voucher lines, expenses and advance requests. Sales, purchases, goods receipts, stock movements, POS and payroll currently post unassigned, which is why every cost center report shows an explicit Unassigned row.
Does a missing cost center block a posting?
No. A ledger line with no cost center is simply unassigned, which is a valid state and never an error. Cost centers play no part in the debit-equals-credit check.
Can one journal voucher span several cost centers?
Yes. Each line has its own cost center picker, so a single voucher can split across as many cost centers as you need. The voucher still has to balance overall.
What happens to history if I retire a cost center?
Deactivating removes it from the pickers so nothing new is tagged to it, while every ledger line already tagged keeps its tag and keeps appearing in reports, marked inactive. Cost centers are never deleted.
Why does a cost-center-filtered trial balance ignore opening balances?
An account's opening balance belongs to the account as a whole and carries no cost center. Filtering to one cost center builds the report from that period's ledger movement alone, rather than pinning the whole company's opening position onto whichever cost center you selected.
How this differs by industry
Retail
Multi-branch retailers create a cost center per store, tag branch expenses and journals to it, and finally compare store-level profit instead of one blended chain-wide figure.
Wholesale & distribution
Distributors running several depots create a cost center per warehouse under a shared division parent, so each depot's contribution is visible and the division still rolls up.
Manufacturing
Plants can create cost centers per production line or department for departmental expense reporting, though automatic tagging from work orders and material issues is not yet available — those postings currently land in Unassigned.