QuickBooks Opening Balance

It is a journal entry, and Opening Balance Equity is the other half

Think about what you are asking QuickBooks to do. You tell it a bank account holds 40,000 on 1 January. QuickBooks now has 40,000 of assets that arrived from nowhere, and a ledger that does not balance is not a ledger.

So it posts the other side to Opening Balance Equity, a holding pen Intuit provides for exactly this. The account exists to absorb the offsets of every balance you carried in from your old system, so that your first day balances without you inventing a revenue entry for money you earned before QuickBooks existed.

That makes Opening Balance Equity a temporary account by design, even though nothing forces you to clean it up. Once the file is running and the balances you brought over are settled, an accountant will normally clear it into retained earnings or owner equity, because it is a bookkeeping artifact rather than a real claim on the business. A balance sitting in it two years later is not an error exactly. It is unfinished setup, and it is worth asking about before it becomes part of the furniture.

The practical consequence is that opening balances are not free-form. Every one you enter posts somewhere, so entering one you did not need is not a harmless overstatement of a bank account. It is an equity entry you did not intend to make.

The As of date decides what the number means

Two fields do the work, and the date is the one that carries the meaning. Intuit describes the sequence as picking "a starting point for the account and enter it in the As of field", then entering "the amount of money you had in your real-life bank account on that day".

So the amount is not negotiable once the date is chosen. It is whatever the account actually held on that date, which you read off a statement rather than decide.

Choosing the date well is the whole job. Intuit points at the common answer: "Most businesses choose to start tracking accounts from the beginning of the year. That way QuickBooks matches your bank records from the start." A year boundary is convenient because it lines up with the point where you already have a closed set of figures and because everything after it lives in one reporting year.

One behaviour surprises people who connect a bank feed. Intuit says that if you connect your bank and credit card accounts, "we add up the transactions you've made since the date you picked and use them to get your opening balance". QuickBooks derives the figure from the imported history rather than waiting for you to type one, which is helpful when it is right and confusing when the pulled history does not reach as far back as you assumed.

One more limit worth knowing before you go looking for the field. Balance sheet accounts, meaning bank, asset, credit card, liability and equity accounts, are the ones that accept an opening balance. Income and expense accounts do not, and the reason is not a missing feature. They measure activity over a period rather than holding a balance, so there is nothing to carry forward.

Adding one after the fact, and the two rules that stop you

Accounts get created in a hurry, and the opening balance is the field people skip. Intuit documents the fix as a journal entry created after the fact, dated so that it "come before the oldest transaction in the account".

The direction depends on what kind of account you are correcting. For asset and expense accounts, you debit the account for the opening balance and credit Opening Balance Equity for the same amount. For liability, equity and income accounts, it runs the other way: credit the account and debit Opening Balance Equity.

Two conditions gate the whole procedure, and both exist to stop you making things worse.

The first is about reconciliation. Intuit is explicit: "Only use this method if you haven't reconciled the account yet." Inserting a dated entry underneath a reconciliation you already completed changes the balance that reconciliation was built on, which is the fastest way to turn one missing number into a month of investigation.

The second is about duplicates. Before creating anything, open the account register and look for an opening balance that is already there. Intuit's instruction if you find one is a full stop: "If you see an opening balance entry, don't go further." An account with two opening balances is overstated by exactly the amount of the second one, and because both entries look deliberate, nothing about the register announces the problem.

When you do create the entry, Intuit adds a finishing step that is easy to skip: reconcile the journal entry by marking it with an R in the checkmark column, so it does not appear as an outstanding item on a future reconciliation.

The Stripe clearing account, where the answer is usually zero

Now the case that brings most people to this term, because a Stripe clearing account is an account almost nobody had before and everybody has to create.

The question is what to put in the opening balance when you create it, and the honest answer is that it depends on one thing: whether the transactions that produced your current Stripe balance are also going to be imported.

If your integration is going to sync historical Stripe activity from before today, do not enter an opening balance. Those sales, fees and payouts will arrive as their own records and build the balance themselves. An opening balance on top of them counts the same money twice, and the clearing account ends up overstated by exactly the balance you typed, permanently, because nothing ever comes along to remove it.

If you are starting the sync from today and leaving the earlier activity out, the opposite applies. Your Stripe balance today exists because of charges that will never appear in QuickBooks, so an account that starts at zero will always be short by that amount. Here an opening balance dated to your start date is the right entry, and Opening Balance Equity takes the other side as usual.

That is the reasoning behind advice you will see stated flatly both ways. "Leave the opening balance at zero" is correct guidance for the common setup where history is being imported. "Record an opening journal entry that matches your current Stripe balance" is correct for a clean cut-over. Neither is a universal rule, and picking the wrong one is not a small error, because the clearing account is the account whose balance you are supposed to be checking against Stripe.

One test settles it before you commit. Ask what your integration will do with the charges that produced today's Stripe balance. If the answer is that it will import them, the opening balance is zero.

When a wrong opening balance finally surfaces

The unpleasant property of a bad opening balance is the delay. It does not break anything on the day you enter it. Every report still runs, every transaction still posts, and the discrepancy sits quietly inside a balance nobody has a second source for yet.

It surfaces at reconciliation, and usually not the first one. Intuit lists an incorrect opening balance entered when the account was created as one of the four documented causes of a beginning balance that has changed on a previously reconciled account, alongside edited or deleted reconciled transactions, a bank feed transaction sent back to pending, and a transaction dated before the last reconciliation that was reconciled by hand.

That list is worth reading in the order it implies. Three of the four causes are things that happened recently, so they are what people check. The opening balance is the one that was wrong from the beginning and has been wrong every month since, which is why it tends to be found last.

On a Stripe clearing account there is an earlier warning available, and it costs nothing to use. The account is supposed to hold what Stripe is holding, so compare the two balances in the first week rather than waiting for a month-end reconciliation to raise it. If the two numbers differ by a constant amount that never moves, that constant is almost always the opening balance.