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

Attaching screen shot of reconciliation.

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

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:

• Fix issues for accounts you've reconciled in the past in QuickBooks Online.
• Fix issues at the end of a 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.

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?

Yes, after your accountant has reviewed and finalized the accounting for last year, you can proceed to make corrections during the reconciliation of the first quarter of 2025, Andy. This timing allows you to ensure that all adjustments are made on a clean slate, without disrupting the financial data that has already been reviewed.

Additionally, once you've reviewed all your financial data, you can consider closing your books for the year-end. This prevents any unwanted changes that may affect your reports before filing your sales tax.

Here are the step by step to close your books in QuickBooks Online:

1. Click the Gear icon ⚙ and then select Accounts and settings.
2. Go to the Advanced tab.
3. Select Edit ✎ in the Accounting section.
4. Turn on the Close the books switch.
5. Enter a closing date. Choose a comfortable deadline, ensuring that you do not need to edit any transactions after this date. Your new bookkeeping will begin after this point.
6. Select the Allow changes after viewing a warning and entering a password option from the dropdown menu if you want to require a password before editing your closed books.
7. Hit Save and then Done.

Furthermore, you can run reports in QuickBooks Online to help you track your business performance and make informed decisions.

If you need further information besides reconciliation, you can come back here by clicking the Reply button. We are always here to help!