Quickbooky

Accounting News

Customers & Vendors

QuickBooks Online Users Advised to Leave Customer and Vendor Opening Balances Blank

New QuickBooks Online users are told to skip profile opening balances and enter unpaid customer invoices and vendor bills one by one.

COMMUNITY ISSUESQUICKBOOKY

QuickBooks Online users moving older books into the software keep hitting the same setup question. Where does money a customer already owes, or a bill already due, belong when a new profile is created? The documented answer is blunt: leave the opening balance field blank and enter each unpaid invoice and open bill as its own transaction.

The question lands hardest on first-time subscribers. Anyone starting fresh carries a roster of customers who owe money and vendors awaiting payment, and the profile form appears to offer a one-field shortcut. Current guidance from Intuit says the shortcut costs more than it saves.

An inviting field that is best left empty

When you create a customer or vendor profile, QuickBooks Online offers a slot for an opening balance. Anyone arriving from a spreadsheet or a desktop product reads it as the obvious home for an amount already owed. The recommendation is to skip it entirely and save the profile with the field blank.

The reasoning is practical. A number typed into a profile carries no detail about what it represents. When a payment later arrives, there is no document to apply it to, and the story of what the customer was settling disappears.

The problem with a single lump number

An opening balance records one fact: that a balance exists. Aging reports and payment matching work from individual transactions, not from a name with a number attached. Entering the open invoices instead gives each amount a date, line items, and something specific to settle against. Bills behave the same way on the payable side, where every open bill carries its own due date.

Bank accounts are the exception

The guidance draws a line between people and financial accounts. When you connect a bank or credit card account, an opening balance helps QuickBooks agree with your statements from the start date you choose. That is the job the field was designed for. Customers and vendors sit on the other side of the line, because their balances are really bundles of open invoices and bills. Those bundles belong in the ledger as individual entries.

Enter unpaid invoices for a customer

The routine starts in the profile itself. Create the customer, leave the opening balance blank, and save. Then open the customer center, select the customer, and choose Invoice from the new transaction menu. Date each invoice to the day the products or services were actually delivered, not to your QuickBooks start date. Fill in the lines as you would for any current invoice, then repeat for every unpaid one.

Enter open bills for a vendor

The vendor side mirrors it. Create the vendor profile with the balance blank and save it. From the expenses area, open the vendors list and select the name. Choose Bill from the new transaction menu, and date it to the day the bill actually arrived. Repeat for each open bill you owe.

Only what is still outstanding

One restriction runs through both lists: unpaid items only. Transactions that were paid and closed before the move to QuickBooks should stay in the old records. Re-entering settled history would count income or expense a second time and bury the new file under activity that no longer matters. The aim is a short, accurate list of what is genuinely owed in each direction.

Do the dates on these entries matter?

Yes, and the guidance is specific about them. An invoice should carry the real date the work or goods were provided. A bill should carry the date it actually arrived. Honest dates keep aging reports truthful, since they show how long a balance has really been open. They also drive when a bill comes due. A date invented for convenience quietly distorts both.

The takeaway

QuickBooks Online will accept a number in the opening balance field on a customer or vendor profile, but acceptance is not endorsement. Skip it. Enter the open invoices and the open bills, each with its true date, and let the detail live in the ledger. Your receivables and payables then reflect reality from the first day, and every payment that follows has a specific document to settle against.

← Back to Community Issues