cancel
Showing results for 
Search instead for 
Did you mean: 
LindaJo
Level 1

Beginning Balance in reconciliation window does not match statement

I started using QB Desktop for Mac in January. I set up my accounts correctly. All my opening balances matched my ending balances in the previous software. I have been reconciling the checking account monthly. It always balanced. I tried today to balance to the April statement and noticed that the beginning balance was off by $6,188.72. I followed the advice on other threads and ran the discrepancy report which showed nothing. I looked at the audit trail and found nothing. So I began looking all the way back to Jan 1. And when I ran the Previous Reconciliation report for January it showed a beginning balance that was wrong by $6,188.72. I was puzzled. I looked and looked and looked. Most recently I undid the Jan, Feb and March reconciliations thinking that if I started from scratch maybe the error would be gone. It is still there even though I can see in my register the correct starting balance. You can see this in the screen shot. I don't know what else to do. (Oh, I also verified my data--no problems found--and rebuilt the data but nothing changed.) What should I do?Screen Shot 2020-05-07 at 4.24.10 PM.png

1 Comment
Kristine Mae
QuickBooks Team

Beginning Balance in reconciliation window does not match statement

Good work for doing the necessary steps, LindaJo.

 

Let's also check the Bank Account Quick report. This will help us look for recent transactions that may have cleared or uncleared intentionally. Here's how:

  1. Click Lists, then go to Chart of Accounts.
  2. Select the affected bank account.
  3. Go to Reports, then click QuickReport.
  4. Select Customize Report.
  5. In the Columns list on the Display tab, tick the Clr box, then OK.
  6. Compare transactions on the report with the status in the Clr column to identify transactions that are cleared or uncleared.

If you find one, follow these steps:

  1. Click Lists, then go to Chart of Accounts.
  2. Double-click the affected bank account to open the register.
  3. Find the transaction and the field with a check mark to clear or unclear the transaction.
  4. Click Record

You can also check this reference on how to find reconciliation discrepancies (Mac) for more information.

 

Although, if everything looks good and the figure is still wrong, I'd suggest reaching out to our technical support so an agent can take a better look at this. Here's how:

  1. Visit our website.
  2. Select QuickBooks Mac Desktop.
  3. On the Contact Us page, select a topic, then click Start a Message

Once it's fixed, you can reconcile the bank account again. 

 

Feel free to visit us if you have other concerns. We're here to help you out. 

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up