Skip to main content
November 30, 2024
Question

How to reconcile a deleted and then recreated transaction that was previously reconciled from a prior fiscal year

  • November 30, 2024
  • 1 reply
  • 0 views

A prior fiscal year bank deposit transaction was reconciled. This transaction was incorrectly deleted and then recreated.  What is the process to reconcile this item (again) which would allow reconciliations in the current fiscal year to be in balance?

1 reply

November 30, 2024

Let me help you with your reconciliation and keep your current fiscal year balanced, Nino. 

 

To accurately reconcile a bank deposit that was deleted and recreated after being previously reconciled, use QuickBooks Desktop's (QBDT) mini-reconciliation feature to maintain accurate balances in your current-year reconciliations. Before you begin, ensure you have the final balance from your most recent reconciliation. Here's how:

 

  1. Go to the Banking menu and hit Reconcile.



  2. Select the bank account with the transaction you need to reconcile.



  3. In the Statement Date field, enter the date for an off-cycle reconciliation. You can choose any date between your last reconciliation and the next scheduled one.
  4. In the Ending Balance field, type the balance of your last successful reconciliation and click Continue.
  5. Place a checkmark before the deposit transaction you're fixing and re-reconciling in the Reconcile window.
  6. Make sure the Difference field shows $0.00.



  7. When everything looks good, click the Reconcile Now button. 

 

Additionally, I'll share this resource to aid you in checking your accounts in QBDT and getting them ready for the end of the year: Year-end guide for QuickBooks Desktop.

 

If you have other questions about handling reconciliations in QBDT, comment below. The Community team is always ready to provide further guidance and support.

ninomcdAuthor
November 30, 2024

Please know that the original transaction is from Sept 2023. Please provide a date to consider using in the Date of Statement field for off cycle reconciliation to better clarify the date required. The last reconciliation completed is Oct 2024 and the next scheduled reconciliation is Nov 2024. It appears that entering the balance of the last successful reconciled balance which is from Oct 2024 does not allow me to reconcile a 2023 statement, select the transaction and see a difference of 0.

November 30, 2024

Your prompt and detailed response is valued, @ninomcd. Let me provide additional information about mini reconciliation in QuickBooks Desktop (QBDT).

 

When performing a mini-reconciliation, use an off-cycle date in the Date of Statement field for corrections. Since the original transaction was in September 2023, choose any date between the last reconciliation in August 2023 and the next scheduled one that year. This step ensures you're within the correct timeframe.

 

QuickBooks will then notify you that you're performing a mini reconciliation. This process reintroduces previously unreconciled transactions without disrupting your regular reconciliation cycle, keeping your current fiscal year balanced.

 

Additionally, I recommend working with your accountant for further guidance on reconciling your account. They have the best ideas on what statement date is applicable.

 

Furthermore, you can check out this article to help you review your past reconciliation: Get reports for previous reconciliations.

 

I hope this helps you reconcile your bank account successfully. Let me know if you have further questions about the special reconciliation or any QuickBooks-related concerns.