My opening balances do not match
Compare committed opening records and their dates with the trial balance before replacing an import.
- Who can do this
- Owners, or people with opening-import access and View financial reports
- Where
- Books, then Import data
- You'll need
- General edition, the transition date and your source trial balance
An incomplete import sequence or a skipped row can leave the opening totals different from your source. Compare the transition date first.
Check what was added
- Open Books, then Import data.
- Review the completed open invoice and bill imports, including duplicate skips.
- Review the remaining opening-balance file and its as-of date.
- Compare the trial balance at that date with your source.
Opening-import access needs Create journal entries and Post journal entries. Opening imports use Opening Balance Equity for the other side. The import page shows its current balance, which can differ from the balance at your transition date. Open documents and remaining balances need to be reviewed together; follow Check your opening numbers before deciding what is missing.
Replace an incorrect opening file
WarningUndo reverses the opening journal on its original as-of date. It changes reports for that date. Review the source file and intended replacement before proceeding.
Use Undo opening balances on the completed opening-balance import. It needs Reverse posted entries and access to that import. A closed year, a closed or locked month, the backdating limit or a later bank reconciliation can block the reversal. Confirm the undo succeeded before uploading a replacement; QixCount blocks another active opening-balance import.
Ask your accountant to review an unexplained difference. Contact support with the import reference, dates, skipped rows and totals if the records do not explain it.