Skip to main content
A
andy65
April 6, 2025
Question

Adjusted CC Payments after Reconciliation, throwing off previous reconcile with deleted transactions.

  • April 6, 2025
  • 2 replies
  • 0 views

Hi Community!

 

My bank account was reconciled through the end of the year, but I was having issues with balances within my credit cards and bank accounts. Post reconciliation of my BMO account, I undid all of my CC Payment Transfers and was able to get them all in alignment and accurate. In doing so, things got messy before they were cleaned up. Now having my accounts balance, the prior reconciliation has been thrown off by $100k due to deleted transactions. I don't understand what's happening entirely - how was I able to reconcile if things were off, and how did actually reconciling the cc account payments that were matched with the bank account throw off my reconciliation?

 

I've unreconciled the deleted transactions and that didn't do anything more than seem to complicate the situation further. Can anyone help me get this corrected?

2 replies

A
andy65Author
April 6, 2025

Attaching screen shot of reconciliation.

A
andy65Author
April 6, 2025

 And here are the deleted transactions that are no longer affecting actual balances, but are throwing off the reconciliation.

J
Jessavell_A
April 6, 2025

If a reconciled transaction is deleted, it will affect the ending balance of your last reconciliation, which in turn influences the beginning balance of your next reconciliation, Andy. To resolve this issue seamlessly, we need to follow a few precise steps outlined below.

 

First, you'll have to recreate the transactions that were previously reconciled and then deleted. To retrieve the necessary details for recreating these transactions, access the Audit Log by following these steps:

 

1. Click on the Gear icon.

2. Select Audit Log.

3. Filter the data by choosing the correct user, the date when the transactions were deleted, and the relevant event(s).

4. Find the deleted items in the list and click View under the History column. You can use the information displayed here to re-create the transaction.

 

Once done, manually reconcile the deposit on the Chart of Accounts page to resolve the discrepancy. Follow these steps:

 

1. Click Transactions on the left menu. Then, select Chart of Accounts. 

2. Locate the appropriate bank account and click View register in the Action column.

3. Find the recreated transactions and click the checkbox under the ✓ column until you see the letter R. This indicates that the transaction is reconciled. Then, click  Save.

 

If you encounter reconciliation issues in the future, here are some helpful resources you can refer regarding bank reconciliation in QuickBooks Online:

 

 

Additionally, when you're ready to close out the year, you can close your books to prevent unwanted modifications to past transactions.

 

Now that we fixed your opening balance, QuickBooks Live Expert Assisted can help you categorize transactions and reconcile your bank statements every month. They can also teach you how to automate your workflows to save time in your bookkeeping.

 

Please let me know if you need further assistance with bank reconciliation or QuickBooks in general. Your efforts are much appreciated.

A
andy65Author
April 6, 2025

Thank you for the quick help. Before I start doing this my concern is it’s going to recreate the issue with account balances that was corrected by deleting these transactions. As it stands now, given the reconciliation was clean when completed initially, can my accountant work through last year’s accounting and then I can correct this when I go in to reconcile Q1 of 2025?

Terms & ConditionsAccessibility statement