Skip to content
Tutorials Center
My learning

Topics

Lesson 6 of 36 ยท Setup and Chart of Accounts

QuickBooks Opening Balances and the Conversion Date

Move your books into QuickBooks correctly: choose a conversion date, enter opening balances, open invoices and bills, the opening balance equity account and how to verify them.

If you are not starting a brand-new business, QuickBooks needs to know where you stand on day one: how much is in the bank, what customers owe you and what you owe vendors. Those starting amounts are opening balances, and the date they apply to is the conversion date (also called the start date). Getting them right means every later report begins from truth.

Choose the conversion date

The best conversion date is the end of a month or fiscal year, with all transactions before it summarized as balances and all transactions after it entered one by one. Reasons: bank statements close on month ends, and a fiscal-year start gives clean year-to-date reports. If you start mid-year, you will need extra detail for the period already passed (year-to-date income and expenses) for tax reporting.

You need these figures as of that date:

  • Bank and credit card balances from the last statement before the start.
  • Open customer invoices (unpaid), each with customer, date, number and amount.
  • Open vendor bills (unpaid), each with vendor, date, number and amount.
  • Other assets and liabilities: equipment (with cost and depreciation), loans, payroll liabilities, sales tax payable.
  • Inventory quantities and cost, if you track stock.
  • Equity accounts, which QuickBooks will help you balance.

Opening balance equity

When you enter a starting balance in an asset or liability, the double entry needs an opposite side. QuickBooks uses a special equity account named Opening Balance Equity for this. Think of it as a temporary bucket. If you enter a bank balance of 5,000 with no other history, QuickBooks debits the bank 5,000 and credits Opening Balance Equity 5,000.

After all opening items are in, move the balance of Opening Balance Equity into the true equity accounts (owner's equity, retained earnings), usually with a journal entry made with your accountant. A good conversion ends with Opening Balance Equity at zero.

A large leftover in Opening Balance Equity means the opening entries do not tell a coherent story. Do not hide it with random adjustments; check each opening figure against statements.

Entering the opening balances

flowchart TD
    A["Pick conversion date"] --> B["Enter bank and card balances"]
    B --> C["Enter open invoices (A/R)"]
    C --> D["Enter open bills (A/P)"]
    D --> E["Enter other assets, liabilities, inventory"]
    E --> F["Journal entry: clear Opening Balance Equity"]
    F --> G["Compare with the old trial balance"]

Each step uses the normal forms, dated on or before the conversion date.

  1. Bank accounts: when you create an account in the chart, or connect it, you may enter Balance and as of date. Use the statement's closing balance on the conversion date.
  2. Open invoices: enter each unpaid invoice with its original date (or the conversion date if history is not needed) so that aging reports are right. Use the same amounts as your old records.
  3. Open bills: enter each unpaid bill the same way, using the Bill form.
  4. Inventory: use the product's Initial quantity on hand and as of date plus a cost per unit.
  5. Loans and other liabilities: add them from the chart of accounts with an opening balance, or use a journal entry.
  6. Journal entry: from + New > Journal entry, post lines to move Opening Balance Equity to the correct equity accounts.

Checking your work

Run a Trial Balance report dated the conversion date and compare each line with the figures from your old system. Total debits must equal total credits. Run Balance Sheet as of that date too, and a Reconciliation of each bank account against its statement (covered later in the course). Finally confirm A/R and A/P totals match the sum of open items.

If you are importing from QuickBooks Desktop or a spreadsheet, check the Import data options under the gear. Always import into a test company first if you can.

Stand-in: trial balance checker

A trial balance lists every account's balance as a debit or a credit. The totals must match. This stand-in builds one from opening balances and shows how Opening Balance Equity absorbs the difference.

Python Stand-in: opening balances and Opening Balance Equity

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Python Stand-in: do the open invoices match the A/R balance?

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Common mistakes

  • Entering opening balances on the wrong date, which skews prior-period reports.
  • Re-entering paid invoices, which inflates A/R and income.
  • Entering bank balances from the bank's view (including pending items) instead of the book balance on the statement date.
  • Forgetting payroll and sales tax liabilities.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. What is the conversion date?

    It is the start date: balances are entered as of it, and transactions after it are entered individually.
  2. 2. What does Opening Balance Equity normally hold?

    It balances the opening entries and should be cleared to real equity accounts by a journal entry.
  3. 3. Which report best checks opening balances against your old system?

    The trial balance lists every account and its debit or credit balance.
  4. 4. How should open invoices be entered?

    Individual open invoices keep customer balances and aging reports accurate.

Summary

  • Choose a clean conversion date such as a month or year end.
  • Enter bank and card balances, open invoices and bills individually, plus other assets and liabilities.
  • Clear Opening Balance Equity to zero with a journal entry.
  • Verify with a trial balance, balance sheet and bank reconciliations.

Next: Sales tax setup