Home / Resources / Technical
Technical

How to enter opening balances in QuickBooks correctly

7 min read · Keepsync Systems

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

  1. 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.
  2. 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.
  3. Enter inventory through an inventory adjustment (quantity and value) as of the cutover, matching your valuation report.
  4. 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.

The clean-file test: after setup, your trial balance matches the source and Opening Balance Equity is zero. If equity is holding a stray balance, that’s the thread to pull before you start posting live transactions.
Keepsync Data Prep

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