Prior bank reconciliation had $0 discrepancy, but now shows $1195 discrepancy.

Hello there, patmol.

When you reconcile an account, compare your bank statement to what’s in QuickBooks to make sure everything is accurate and matches. That said, the period or month you're reconciling should be the right one.

Based on the scenario, we can run several reports to determine the cause of the discrepancy. You can choose any of the following:

• Reconciliation Discrepancy Report
• Previous Reconciliation Report
• Bank Account QuickReport
• Audit Trail report

Let me show you the steps on how to build the Reconciliation Discrepancy report. Here's how:

1. Go to Reports at the top bar to choose Banking and Reconciliation Discrepancy Report.
2. Select the appropriate account and click OK.
3. Review the report to identify any discrepancies.

If you're unable to find what causes the amount to change, let's open some of the reports mentioned above. Each one contains specific instructions on how to troubleshoot the issue. For detailed instructions, check this article: Reconcile accounts in QuickBooks for Mac. Proceed directly to the What if I don't want to enter an adjustment? section.

I've also attached a link that contains resources on how to troubleshoot reconciliation issues: QBDT online resources. 

In case need more information on a specific task, feel free to use our self-help articles. There, you'll find topics about banking, payroll, cashflow management, and other accounting activities. 

Keep me posted if you have additional questions about balancing and matching your account and transactions. I'll get back to make sure this is taken care of for you. 

I am having the same problem!  I have been balancing my checking account month by month since 1/31/17. When I run the reconciliation discrepancy report (Quickbooks desktop for Mac), it shows no discrepancies at all. Ever. I last reconciled Sept and Oct on 11/17/23 (running behind due to some shoulder surgery), and everything reconciled. When I went to reconcile my Nov statement, the beginning balance was off by about $850 and change. Again, nothing on the reconciliation discrepancy report. I ran the reconciliation detail, and everything for Oct matched my checking statement. I exited and restarted QB several times, but that didn't correct the beginning balance. I clicked "undue last reconciliation" twice, hoping it would fix things - it did not. I don't know what to try next! I am the only person with access to this account. It is not linked to my bank, so any transactions are entered manually by me. Any suggestions?

Hello joyin,

I'm here to help fix the discrepancy issue you encountered. I appreciate you for running a report and for undoing the reconciliation report to fix this matter.

To ensure the transactions match your bank records, I suggest using your bank statement as a reference. You can use it to compare the entries on your QuickBooks transactions.

If some transactions are listed on QuickBooks, but not on your bank statement, you may delete them. These entries may be the reason for the discrepancy issue.

From there, you can reconcile the account again. You can check this article as your guide: Reconcile account.

I'm always around whenever you have reconciliation concerns.

Hi joyin.  After spending time on the phone with QuickBooks support and checking a few different reports as well as Verifying and Rebuilding data, I was able to finally balance my books after going back 6 months to find a discrepancy that just mysteriously popped up.  As I put in my original post and you even stated it happened to you, the books balanced and then mysteriously they didn't.  Ended up going back to June of 22 to rebalance and find the issue.  No rhyme or reason on why it happened and it has never happened in the 17 years of owning my business.  I would reach out to support first by doing online chat and then talk to someone on the phone.  It took a few hours and some alcohol but it all got worked out.  Good luck!

I have been successfully balancing this account since 2017.  The discrepancy report shows no discrepancies.  The verify data utility shows no problem.  All transactions on my bank statement are able to be matched to transactions in Quickbooks.  There are some outstanding checks paid out that have not been cashed yet, and some deposits I have recorded in Dec that would not have hit the Nov statement yet, but this is normal in the course of doing business.  I do not want to delete them, as they will hit in future bank statements.  Any new suggestions?  I see I am not the only person to have had this problem.

Hi there, Joy.

I understand the importance of reconciling your bank statement with your QuickBooks transactions. Rest assured, we'll assist you in fixing these discrepancies so you can continue doing your business needs. Before doing these steps, please note that you'll need to back up your company file to ensure your data is safe.

Since some deposits you recorded in December have yet to hit the November statement, I recommend doing a mini or off-cycle reconciliation so that it won't mess up your future bank statements. This puts unreconciled transactions back without affecting the cycle that you follow. Please refer to your accountant so they can guide you on doing this correctly.

Here's how: 

1. Go to the Banking menu and select Reconcile.
2. Select your bank account you need to reconcile.
3. In the Date of Statement field, enter the date for an off-cycle reconciliation. This date can be between your last reconciliation and the next scheduled one.
4. In the Ending Balance field, enter the balance based on your QuickBooks.
5. While in the reconcile window, check off the transactions you are fixing and re-reconciling.
6. Make sure there's no difference. When everything looks good, select Reconcile now.

For more details about off-cycle reconciliation, please refer to this article: Reconcile previously deleted and re-entered checking or credit card transactions.

After resolving your reconciliation discrepancies, you may consider closing your books to avoid unwanted changes.

Let me know if you have further questions or details about your reconciliation concerns in QuickBooks Desktop. I'm always here to provide you with the best solutions.