Intercompany balances that don’t match in QuickBooks Online
Last updated: Oct 6, 2026
Why the due to / due from balances between a client’s related QuickBooks Online companies drift apart, and how to find and correct the difference.
Jump to a topic 6 sections
When a client runs two or more related companies, each in its own QuickBooks Online file, a balance one company shows as owed to it by another should appear, in the same amount, as owed on the other side. At month end it often doesn’t.
This guide covers why the two sides drift apart, a manual way to find the difference, and how to correct it without plugging the gap.
Why the two sides stop matching
- One company recorded the transaction and the other didn’t: Admin Co paid a repair bill for Property Co and recorded it as owed, and Property Co never recorded the bill.
- The two sides were recorded in different months.
- The amounts differ: a fee calculated another way, a partial payment, a transposed figure.
- One side went to the wrong account: an expense, owner’s draws or a clearing account instead of the due to / due from account.
- A payment between the companies was recorded as income, or as a transfer inside one file.
- The reports being compared use different dates, or one is on a cash basis and the other on accrual.
Find the difference
- Run the Balance Sheet for each company at the same month-end date and on the same accounting basis.
- Note the pair’s balance in each: Due from Property Co in Admin Co, and Due to Admin Co in Property Co. When the books agree, the amount Admin Co is owed equals the amount Property Co owes.
- If they differ, open the account in each company for the months since the two last agreed (the account’s register, or a transaction report filtered to it).
- Match the transactions across the two lists by amount and date. Whatever has no partner is the difference, or part of it.
- For each unmatched item, find the source document and decide which side recorded what actually happened.
| Admin Co | Property Co | |
|---|---|---|
| Account | Due from Property Co | Due to Admin Co |
| Balance | $50,000.00 | $48,000.00 |
| Difference | $2,000.00 | |
| Unmatched | Aug 14 · paid roof repair for Property Co · $2,000.00 | — |
Correct it, don’t plug it
Correct the side that’s wrong, with an entry that records what actually happened. In the example, Property Co never recorded the repair bill Admin Co paid for it, so the correction belongs in Property Co:
| Account | Debit | Credit |
|---|---|---|
| Repairs & maintenance | Debit2,000.00 | No amount |
| Due to Admin Co | No amount | Credit2,000.00 |
Posting the gap to a suspense or “intercompany adjustment” account makes the pair agree, but the repair is still missing from Property Co’s expenses, and the next month starts from a balance nobody can explain.
Keep a short note with every correction: the cause and the source document. It’s the first thing the client’s accountant asks for at year end.
Keep it from happening again
- Give each pair of related companies its own due to / due from accounts, named for the other company.
- Record both sides of an intercompany transaction in the same month.
- Tie out every pair before the month is closed, while the cause is still easy to find.
- Agree with the client who records payments one company makes for another.
Free template: tie out every due to / due from pair in Excel, with a worked example. Get the reconciliation template
Where Flatbooks fits
Flatbooks reads a client’s related QuickBooks Online companies for the month you choose and puts each due to / due from pair side by side, with the difference between the two sides. To help find the entries behind a difference, it can lay the two companies’ ledgers for the period next to each other.
When you’ve found the cause, it prepares one correcting journal entry for the company you choose. The intercompany side is calculated; the other account is yours to pick, with a note of the cause and source. Nothing posts to QuickBooks until you approve it, Flatbooks reads QuickBooks again afterwards to check the result, and a posted correction can be reversed.
Once the pairs agree, it exports the consolidated workbook: the group statements, the eliminations, and a verification sheet tying every company back to its own QuickBooks report. The client’s companies stay in QuickBooks Online. It handles due to / due from balances and management fees between sibling companies; when one company owns another, or other group adjustments are needed, it says so and pauses the export.
The sample is fictional and needs no account. Your first client’s diagnostic is free. No card needed.