How to Allocate Shared Expenses Across Divisions in QuickBooks Online
If your company has multiple locations, departments, or classes sharing overhead expenses — you already know the monthly pain of splitting those costs manually in QuickBooks Online. Here's how to do it right, and how to automate it entirely.
The problem with shared expenses
Most multi-division businesses share overhead costs that don't naturally belong to a single location or department. Think rent for a shared facility, the owner's salary, company-wide insurance, accounting fees, or software subscriptions that everyone uses.
QuickBooks Online is excellent at tracking these expenses — but it doesn't automatically split them across your locations, classes, or departments. That means every month, someone has to manually calculate the right split and post a journal entry to allocate those costs.
For a business with two divisions, that might be manageable. For three or more? It becomes a time-consuming, error-prone monthly chore.
The two most common allocation methods
Before we get into the mechanics, it helps to understand the two most common ways businesses split shared expenses:
1. Revenue percentage split
Each division pays a share of the overhead proportional to its share of total revenue. If your Chiropractic division generates 60% of revenue and your Behavioral Health division generates 40%, then shared expenses are split 60/40.
This method is considered the most equitable because it ties overhead costs to the division's ability to generate revenue. It's also the most complex to calculate because the percentages change every month.
2. Fixed percentage split
You set a fixed percentage for each division that stays the same every month — for example, 50/50, 70/30, or any split that makes sense for your business.
This method is simpler and more predictable. It's common when divisions are roughly equal in size, or when management wants consistent cost allocation regardless of monthly revenue fluctuations.
How to do it manually in QuickBooks Online
Here's the manual process most accountants follow each month. Fair warning — it's tedious.
1. Run your P&L by Class or Location
Go to Reports → Profit & Loss → Customize → add the Location or Class column. This shows revenue by division, which you'll need to calculate revenue percentages.
2. Calculate the split percentages
Divide each division's revenue by total revenue. If Division A had $60,000 and Division B had $40,000 in revenue, your split is 60% / 40%. Do this in a spreadsheet.
3. Run your General Ledger report
For each shared expense account, run the GL report to see the untagged balance — the amount not already assigned to a location or class. That's the amount you need to allocate.
4. Calculate the amounts per division
Multiply the untagged balance by each division's percentage. For a $10,000 rent expense with a 60/40 split: $6,000 to Division A, $4,000 to Division B.
5. Create the journal entry
In QBO, go to + New → Journal Entry. Create debit lines for each division with the location/class tag applied, and a single credit line for the untagged offset. Make sure debits = credits.
6. Repeat for every shared expense account
If you have 8 shared expense accounts and 3 divisions, that's 8 separate calculations and potentially 32 journal entry lines — every single month.
⚠️ The real problem
This process is completely manual, highly repetitive, and prone to errors — especially when revenue percentages change month to month. One wrong formula in your spreadsheet, one mistyped amount in QuickBooks Online, and your financial statements are off.
A better way: automate the entire process
This is exactly the problem that Allocate was built to solve. Instead of manually pulling reports, calculating percentages, and typing journal entries, Allocate connects to your QuickBooks Online and does everything automatically.
Pulls live data from QuickBooks Online
Allocate reads your actual GL balances and P&L revenue figures directly from QuickBooks — no manual exports or spreadsheets.
Calculates splits automatically
Revenue percentage splits are recalculated fresh each month using your actual QBO data. Fixed splits stay exactly where you set them.
Review before posting
You see the full journal entry before it goes anywhere. Edit any line if needed, then approve with one click.
Posts directly to QuickBooks
The journal entry posts to QuickBooks Online instantly — properly tagged to each location or class. No copy-pasting, no typos.
Saves your configuration
Save your account rules as a template. Next month, run the same allocation in seconds.
Who needs expense allocation?
If any of these describe your situation, expense allocation is probably part of your monthly close:
- ✓Multi-location businesses (retail, healthcare, restaurants, professional services)
- ✓Companies with multiple service lines or product divisions sharing overhead
- ✓Healthcare practices with multiple specialties (chiropractic + behavioral health, dental + ortho)
- ✓Franchises allocating corporate overhead to individual locations
- ✓Accounting firms managing clients with shared expense structures
- ✓Any QuickBooks Online company using Locations, Classes, or Departments to track divisions
Getting started
Allocate works with any QuickBooks Online company that uses Locations, Departments, or Classes. Setup takes about 5 minutes:
- 1Connect your QuickBooks Online company
- 2Select which accounts have shared expenses
- 3Set your allocation rule for each account (revenue % or fixed split)
- 4Run your first allocation — review the journal entry and post
Stop doing this manually every month
Allocate automates your shared expense journal entries and posts them directly to QuickBooks. Try it free for 14 days.
Start free trial14-day free trial · Cancel anytime