Intercompany Transactions Across Multiple QuickBooks Desktop Files

Keep multiple company files in sync with intercompany account mapping and scheduled transfers without relying on Intuit's discontinued services.

Lede: When your business runs separate QuickBooks Desktop company files for different entities, intercompany transactions must be recorded in each file and kept in balance by hand. There is no native sync between two local files. We maintain these setups after Intuit ends connected services, so the workflow keeps working on supported Desktop versions.

Do you need intercompany accounting across files?

You need this when one legal entity owes another, when costs are shared between entities, or when a parent company consolidates results from subsidiaries each in their own company file. QuickBooks Desktop does not link files together. Each transfer must be entered in both files, and the offsetting entries must match exactly or your intercompany account drifts out of balance.

Preparing the company files

Before any mapping, run Verify and Rebuild on each file. A damaged file will corrupt the intercompany entries. Confirm every file uses the same fiscal year and accounting basis. Decide which entity holds the master intercompany account and which holds the matching counterpart. Document the account numbers you will use in each file before you touch the chart of accounts.

Mapping intercompany accounts

Create one intercompany liability or asset account in each file. The parent file usually carries the liability version, the subsidiary the asset version. Use identical account names and descriptions so reports stay readable. Do not reuse an existing account for this purpose. If you already have intercompany entries scattered across other accounts, move them into the dedicated account with a journal entry before you begin.

Recording a transfer between files

Enter the transfer as a journal entry in the source file, debiting the intercompany account and crediting the cash or expense account. In the destination file, enter the mirror entry. The intercompany account must be the only shared line. Date both entries the same day. Add a memo that includes the source file name and the batch reference so you can trace each side later.

Scheduling recurring transfers

Use the memorized transaction feature for transfers that repeat. Set the same date and amount in both files. Do not rely on automatic scheduling across files. Each file schedules its own side. Review the memorized list monthly and update amounts that change.

Verifying balances each period

At month end, run an intercompany detail report in each file. The total of the intercompany account in the parent file must equal the total in the subsidiary file, with opposite signs. If they differ, find the unmatched journal entry and correct it before closing the period. Keep a spreadsheet log of every transfer, the date, the amount, and the file it posted to.

Rolling back a bad entry

If a transfer posts incorrectly, reverse it in both files with a correcting journal entry dated the same day. Do not delete the original entry. Re-enter the correct amount. Re-run the balance check. If the error spans several periods, consult our intercompany reconciliation guide for adjusting entries across closed months.

Clean outcome

A clean outcome means every intercompany journal entry has a matching counterpart in the other file, the intercompany account balances offset to zero across all files, and your month-end reports reconcile without manual adjustments. You can then consolidate or prepare statutory reports from the individual files with confidence.