Skip to main content
September 5, 2022
Question

Credit Card Reconciliation

  • September 5, 2022
  • 1 reply
  • 0 views

Help please! I am reconciling my Capital One statements. The total cleared transactions/ending balance from the previous month matches the beginning balance of the following month. I decided to take a break and closed down QB. I come back 2 days later and the beginning balance changed.. what just happened? Now there is a discrepancy because the new balance does not match the previous month's beginning balance. I don't know how to fix this.

1 reply

Rubielyn_J
September 5, 2022

I've got your back to help fix your credit card reconciliation discrepancy in QuickBooks, @Jennycase.

 

There are possible reasons why the beginning balance change. This could be because of the following reasons:

 

  • No balance or an incorrect balance was entered when the account was set up.
  • Previously cleared and reconciled transactions were voided, deleted, or modified.
  • The file was converted from a different version of QuickBooks.
  • Possible data damage.

 

To find the transactions causing the discrepancy, we can run the Reconcile Discrepancy report. Let me show you how:

 

  1. Proceed to the Reports menu.
  2. Choose Banking, then Reconciliation Discrepancy.
  3. Select the appropriate Account, then click OK. You now have a list of transactions that were changed since the last reconciliation. Use this report to identify the transaction/s causing the issue.
  4. If you find a discrepancy, note the transaction date and the Entered/Last Modified, which will tell you when the change occurred.

 

Then, correct the discrepancy by re-entering or editing the transactions. We can also undo a previous reconciliation and redo it. Let me show you how: 

  1. Back up the QuickBooks company file.
  2. In the Begin Reconciliation window, click Undo Last Reconciliation.
  3. When prompted, select Continue then OK.
  4. Close and reopen the Begin Reconciliation window.

 

For additional information, you can also check out this article: Fix beginning balance issues in QuickBooks Desktop

 

Once everything is settled, you can start reconciling your credit card account again. 

 

Please let me know if you have further questions about fixing the reconciliation discrepancy in QuickBooks. It'll always be my pleasure to help. Have a good one.