UK-registered +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Keep Intercompany Balances Agreeing for Clients With Several Companies?
Problems We Solve

How Do We Keep Intercompany Balances Agreeing for Clients With Several Companies?

Bookkeeping firm group clients need intercompany recharges posted in each company and balances that agree. We build monthly recharges and a mismatch check.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer: TL;DR

Intercompany balances stop agreeing because each company in a group is a separate ledger, often worked on by different people, and recharges are posted by hand on both sides. We build monthly recharge postings from agreed rules into each company, and a check that compares both sides of every intercompany account and flags differences for the bookkeeper.

Four companies, one owner, and balances that never agree

A client runs a trading company, a property company that owns the unit, a holding company and a small side venture. Rent goes from trading to property. Management charges go from holding to the others. The owner pays things from whichever account has money in it. Each company has its own Xero file.

Every month the bookkeeper posts recharges on both sides by hand. By year end, the amount the trading company says it owes property does not match what property says it is owed, and someone spends a day working out why.

Why intercompany goes out of step

Each ledger only knows its own side. A payment from one company for another's cost needs a matching entry in the other company, and if it is missed, nothing tells you. Recharges agreed with the client, such as a monthly management charge, are posted from memory. When different bookkeepers look after different companies in the same group, the two halves can be done in different months or not at all.

Owners also blur the lines. A director pays a supplier for company B from company A's card and forgets to mention it, which is one of the most common sources of a difference.

What mismatched intercompany costs

Unreconciled intercompany balances are a classic year-end problem, and a slow one to unpick months later. Management figures for each company are misstated in the meantime, which undermines the reporting you provide. The group client's accountant raises queries. And the owner loses confidence when balances that should obviously agree do not.

Cause of the differenceHow the check spots it
Recharge posted on one side onlyMovement in one ledger with no partner entry
Posted in different monthsTiming difference that clears next month
Different amounts postedBoth sides present but unequal
Company paid another's costSupplier coded in the wrong entity
VAT treated differently on each sideNet and gross amounts differ

How we build intercompany support for group clients

  1. We map the group: each company's ledger, the intercompany accounts in each, and the recurring recharges you have agreed with the client, such as rent or management charges.
  2. Each month, the recurring recharges are drafted in both companies through the Xero or QuickBooks API, as matching entries, ready for the bookkeeper to approve and post.
  3. A check reads every intercompany account in every company in the group and pairs them up, showing the balance on each side and the difference.
  4. Differences are broken down by transaction so the bookkeeper can see which entry has no partner, rather than starting from a single total.
  5. Payments that look like one company paying for another, such as a supplier normally used by a sister company, are flagged for a question to the client.
  6. The group view is included in the month-end status for the client, so a group is not closed until its intercompany agrees or the difference is explained.

What recharges should exist and how they are treated for VAT and tax is decided by you and the client's advisers. The system posts and checks what you agree.

Groups that close cleanly each month

Recharges are posted on both sides at once, in the same month, every month. Differences show up while they are small and recent. Different bookkeepers on different companies can see the whole group. And year end stops including a day of hunting for why two numbers do not match.

Do your group clients look like this?

  • Intercompany balances rarely agree without investigation.
  • Recharges are posted by hand in each company.
  • Different staff look after companies in the same group.
  • Owners pay costs from whichever company has money.
  • Year end for groups always takes longer than planned.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly. A senior engineer reads every question.

Ask about your project

Do all the companies need to be on the same ledger software?

It is simpler if they are, but the check can compare across Xero and QuickBooks files. Other packages depend on what data they expose.

Will it post entries without approval?

No. Recurring recharges are drafted, and a bookkeeper approves them before they post.

Can it handle foreign currency intercompany?

Yes, where the ledgers hold currency amounts. Exchange differences are shown separately so they are not mistaken for missing entries.

Does this consolidate the group accounts?

It is not a consolidation tool, although the paired balances make consolidation easier for whoever does it.

Keep reading

More on Problems We Solve

Start here

Tell us where your bookkeeping firm loses time

Describe how many clients you look after, the ledgers and practice tools you use, and where the work stalls. We will tell you what we would build, what we would leave alone, and if a smaller change would fix it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate, with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →