cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Intuit
3 helpful votes

Fix beginning balance issues in QuickBooks Online

Learn how to review your beginning balance before you start reconciling.

Each time you reconcile an account, you have a beginning balance in QuickBooks. This is the amount in the account on the first day of the time period you're reviewing. Think of it as a checkpoint so you know you're starting with accurate numbers.

This beginning balance should match the beginning balance and date on your bank statements. If it doesn't match, don’t worry. QuickBooks will let you know if you need to change anything. Here's how to fix beginning balance issues so you can start reconciling.

New to reconciling? Start with our reconcile guide.
  • Someone edited, deleted, moved, or unreconciled a transaction that was on a previous reconciliation. This changes ending balance and  impacts the beginning balance on your next reconciliation
  • Someone manually reconciled a transaction. It won't show up for review and can't be added to future reconciliations.

Step 1: Review the original opening balance

The opening balance is the starting point for an account. If it’s incorrect, it affects all of your reconciliations.

Make sure your opening balance is correct. Do this before checking your beginning balance.

Then move on to Step 2.

Step 2: Review any discrepancy reports

If someone makes a change that affects your beginning balance, you'll see a message when you start reconciling.

Follow the link to open your discrepancy report. Use it to decide if and how to make changes.

  1. Select We can help you fix it to open your discrepancy report.Review
  2. Review the discrepancy report. Before editing any of the transactions on it, talk with whoever made the changes - they may be intentional.
  3. Once you know you can make corrections, edit each transaction on the report one at a time.
  4. Select View to see the history of changes to the transaction.
  5. Review the Change Type column. This tells you what changed.Look

When you're ready to make edits, select the transaction to expand the view. Make edits based on the message in the Change Type column:

Someone edited a reconciled transaction or moved it to another account.To fix it:

  1. Select the transaction to expand the view.
  2. Select Edit to open the form.
  3. Adjust the total or change the account as needed.
  4. Select Save and close.

Someone unreconciled the transaction. To reconcile it again:

  1. Select the transaction to expand the view.
  2. Select the box in the tick column until you see an R. This reconciles the transaction.ReconcileReview
  3. Select Save.

Someone added this transaction to a past reconciliation on accident. To remove it so you can add the transaction to your next reconciliation:

  1. Select the transaction to expand the view.
  2. Select the box in the tick column until it's blank or you see a C. This removes the transaction from the reconciliation.
  3. Select Save.

Someone deleted a reconciled transaction. If this was an accident, recreate the transaction exactly as it appears on your discrepancy report.

  1. Select Create (+) and select a form (invoice, sales receipt, expense, etc). Complete the form and select Save and Close
  2. When you’re done, go to the Accounting menu. Then select Chart of Accounts.
  3. Find the transaction and select it to expand the view.
  4. Select the box in the tick column until you see an R. This reconciles the transaction.
  5. Select Save. If you still see an alert the next time you reconcile, open the discrepancy report. The deleted transaction may still be on the list, but the difference should be $0.00. It won't affect your reconciliation.

After you make changes, the Total Discrepancy Difference for the discrepancy report should be $0.00. Your beginning balance in QuickBooks should match the beginning balance on your bank statement.

SelectResume reconciling to continue reconciling.

Next steps: Start reconciling again

Once you know your beginning balance is correct, you can start reconciling again.

If you still have problems, review your ending balance.

If you’ve followed everything in our reconcile guide but still have questions, connect with your accountant. They can help get your reconciliations back on track.

Was this helpful?

You must sign in to vote, reply, or post