Check a QuickBooks import before importing
Review QuickBooks CSV validation totals, dates, account matches, and balance checks before anything posts.
Select And Check Both Files
Open the destination company, then go to Settings > Import & Export > QuickBooks Import. Select the original QuickBooks Chart of Accounts CSV and Journal CSV, then choose Check Files. Nothing is imported at this step.
The destination should be an empty company. If it already has journal activity, use Assisted Import or a clean destination rather than trying to replace the ledger through this screen.
Read The Preview
A useful preview shows:
- the account, transaction, and posting-line counts;
- the first and last source dates;
- missing accounts, if any;
- unbalanced entries, if any; and
- skipped or ignored rows that did not become ledger entries.
Missing accounts can also occur when QuickBooks shows an inactive account but omits it from the Chart of Accounts CSV. For every missing account, select its account type and choose Save account types. LedgerHQ adds the confirmed accounts to the checked import. Unbalanced entries still require a corrected, complete Journal report from QuickBooks.
Import Only The Checked Revision
When the counts, dates, account mapping, and balance checks are correct, choose Import QuickBooks. LedgerHQ writes the checked accounts and journal history to the selected company. Resolve every missing account and any remaining validation problem before importing.
After the import, follow Verify a company after import.