Skip to main content
February 25, 2023
Question

I am trying to reconcile but my beginning balance is incorrect. How do I correct this? I changed some already reconciled entries now they are showing as deleted?

  • February 25, 2023
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

MaryLandT
February 25, 2023

I'm happy to help you figure out why the beginning balance is incorrect, pjr0207195.

 

Before we start, please know that your bank statement must always be the basis for reconciling transactions. To proceed, changing the reconciled entries will cause beginning balance issues.

 

When entries are showing as Deleted, this means you've deleted them. You'll want to re-create the transactions exactly as it appears the discrepancy report.

 

Here's how:

 

  1. Click + New, then choose the correct form (invoice, sales receipt, expense, etc).
  2. Fill out the form and select Save and close.
  3. Go to Bookkeeping or Accounting, then select Chart of accounts.
  4. Find the account that you put the transaction into and click View register.
  5. Find the transaction and select it to expand the view.
  6. In the checkmark ✔ column, click the box until you see an R. This manually reconciles the transaction.
  7. Hit 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.

 

Aside from that, here are some activities that will affect the beginning balance.

 

 

To fix the beginning balance, There might be transactions that aren't part of the business. I recommend reviewing your transactions in your bank account. Then, edit the opening balance if it's incorrect. 

 

Another thing to look out for is the previously reconciled transactions. There might be records that were reconciled but under the wrong period. Changes to the reconciled transactions are another culprit. 

 

In this case, you'll want to check your reconciliation history report: 

 

  1. Go to Accounting, then click the Reconcile tab.
  2. Click the History by account link.
  3. Select a statement date, then click View report.
  4. Review any changes on your transactions.

 

 

For more details about the process, you can check this article: Fix issues the first time you reconcile an account in QuickBooks Online.

 

Need to take care of your current bank transactions? You can check our Banking-related articles for guides and important information. 

 

I'll be around if you need help with your bank transactions. Looking to do other processes in QuickBooks Online? Ask away and I'll assist you.