Question

Reconciliation Report Issues

Forum|Forum|4 years ago
May 24, 2022
1 reply
0 views

I am wondering if anyone else is having this issue or if I am doing something incorrectly -- since the beginning of the this year, when I reconcile an account and want to pull up the detail and summary reports, the beginning balance is 0.00 and makes the reports all wrong.

When I actually do the reconciliation, the beginning and ending balance are both correct and everything looks good with the difference at 0.00. But then I pull up the reports and they're wrong because the beginning balance is 0.00 and not what I had initially entered.

I didn't have this issue at all last year -- is it a glitch or did I forget something?

QuickBooks Desktop for Mac

C

Charies_M

Level 9

I've got you covered with your concern about the reconciliation report, r_gazz.

You'll want to run the Reconciliation Discrepancy Report are review the transactions made from there. This way you can trace which transaction causes the incorrect balance.

To do this:

Navigate to Reports.
Choose Banking.
Select Reconciliation Discrepancy Report.
Review the list of transactions. Doube-click on the transactions to locate the issue and fix them.

For a complete process on how to fix Reconciliation reports in QBDT Mac, visit this article: Reconciliation Discrepancy Report.

You can also visit our page for inquiries and how do I questions while working with QuickBooks Desktop for Mac: QuickBooks Desktop for Mac FAQ's

Please feel free to get back to me here for any additional questions about handling reconciliation reports. I always have your back. Cheers for more success!

R

r_gazzAuthor

Hi Charies,

Thank you for reaching out. The issue is the beginning and ending balance are correct when I reconcile. It's just when I pull up the reports that they change. When I am doing the actual reconciliation, everything ends up balanced. The statement date is also correct.

Can you help with that?

R

Rea_M

Level 10

Hello there, @r_gazz. I appreciate your immediate response.

You'll need to update QuickBooks Desktop (QBDT) for Mac and scan your company file for errors or data damage to correct the beginning and ending balance on your reconciliation reports. I'll be glad to help you with that.

You'll want to ensure QBDT for Mac is updated to the latest release. This way, we can guarantee the program is running with the newest fixes and patches. Here's how to do an in-product update:

From the QuickBooks dropdown, select Check for QuickBooks Updates.
Select Install Update.
When prompted, click Install and Relaunch.
When the update is complete, QuickBooks for Mac automatically opens.

If you want to do a manual update, please see this article for the detailed steps: Update QuickBooks for Mac to the latest release.

When you're done, go ahead and scan your company file for errors or data damage. You can utilize the Verify and Rebuild Data tools to do this.

To verify your company file data, here's how:

Go to the File menu.
Select Utilities.
Choose Verify Data, then click OK to close all windows. If you see Your data has failed the integrity check you need to rebuild your file. If there are no problems with your data, you’re done.

Then, to rebuild your file, you can refer to this article for the step-by-step guide: Verify and rebuild data in QuickBooks Desktop for Mac.

Once everything is set, you can pull up the reconciliation report again from the Reports menu. Your beginning and ending balance should now be showing the correct amounts.

Also, you may want to check out these great articles to help you resolve reconciliation issues in the future using QuickBooks Mac:

Keep me posted on how it goes. If you have other reporting and reconciliation concerns, I'm always ready to help. Have a great day, @r_gazz.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded