How to enter opening balances in QuickBooks correctly
Opening balances are where more QuickBooks files go wrong than almost anywhere else — not because the concept is hard, but because QuickBooks makes the easy path the wrong one. Here’s how to set them so your file ties out and stays clean.
The wrong way (and why it bites)
QuickBooks lets you type an “opening balance” directly into many account setup screens. It’s tempting, but every one of those entries quietly posts the other side to Opening Balance Equity, an account you can’t easily see or control. Do this across dozens of accounts and you end up with a mystery balance in equity that’s painful to unwind. Avoid the per-account opening-balance field.
The right way
- Post a single opening journal entry dated the day before your go-live date, carrying the balance of every balance-sheet account — except AR and AP.
- Bring in AR as itemised open invoices and AP as itemised open bills, so aging reports stay accurate and payments can be applied to the right documents.
- Enter inventory through an inventory adjustment (quantity and value) as of the cutover, matching your valuation report.
- Confirm Opening Balance Equity nets to zero once everything is in. If it doesn’t, something is missing or mis-posted.
Reconcile to the source
Your source system’s trial balance as of the cutover date is the number the QuickBooks opening position must match, account by account. If it doesn’t tie, our guide on why a trial balance won’t match after an import walks through the usual causes.
Catch it before the import
Data Prep maps, validates and reconciles your data before it’s written to QuickBooks — so problems are caught in a preview, not in your live company file.
See Data Prep