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

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.

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.

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.

Is it correct to use a date between August 2023 and September 2023 for the off cycle reconciliation because the transaction was originally reconciled with the Sept 30 bank statement? Which of these statements should be used for the last reconciled statement ending balance amount?

Thanks for getting back to this thread, Ninomcd.

If the previous reconciliation is August 31, 2023, a date between this and September 30, 2023, would be appropriate since you mentioned the transaction was reconciled with the September bank statement. You can work with your accountant so they can help you manage reconciliation further while ensuring your account is accurate.

If you don't have an accountant, we can help you find one near you. Feel free to visit this page to get an accountant for your business: Find a QuickBooks ProAdvisor.

We're open 24/7 if you need assistance reconciling your account or help performing tasks inside the program. As always, feel free to visit us anytime or comment below so we can reply as soon as possible. Keep safe.

Based on the information provided, I can use an off cycle date of 09/10/23 since the prior reconciled report was dated 08/31/23 and the statement with the originally reconciled transaction had a statement ending date of  09/30/23.

When asked for an ending date of the statement to to complete an off cycle reconciliation, should I use the prior reconciliation statement ending 08/30/23 or the ending statement date for the statement with the originally reconciled transaction with a statement date ending 09/30/23?

You'll not be asked for an ending date when performing a mini-reconciliation, ninomcd. I'll be pleased to clarify this process and ensure you stay on the right track.

A mini-reconciliation method can effectively address necessary corrections by utilizing an off-cycle reconciliation date, specifically the Date of Statement. This can be any date between your last reconciliation and the next scheduled one. Hence, you can indeed use 09/10/23, as this is between 08/31/23 and 09/30/23.

On the other hand, note that you no longer need to enter a Statement Ending Date, as this will only be necessary when performing an ordinary reconciliation for an account for online banking.

To keep you on the right path when fixing and re-reconciling your transactions, you'll want to refer to the steps outlined by my colleague above or explore this article: Reconcile previously deleted and re-entered checking or credit card transactions.

Additionally, I recommend seeking guidance from an accountant when fixing your prior reconciliations to keep your ending balance accurate as you go through each process.

Moreover, you can review your past reconciliations anytime with the guide of this material: Get reports for previous reconciliations in QuickBooks Desktop.

This thread is always open to questions about the reconciliation process in QuickBooks Desktop. You may leave your concerns using the Reply button below, and we'll be glad to provide relevant data and resources to address them.

@ninomcd 

A quicker and easier way to do this is to mark the recreated transaction as cleared in the bank register.  To do that, find the transaction in your bank register and click the box under the checkmark until an 'R' appears, then click Save.  If that was causing the discrepancy in the current year, your beginning balance should now be correct.     

Clicking on this multiple times does not produce and R. I only see a check mark, an asterisk, or nothing. Those are the only three options when clicking in this box. Please keep in mind that this is a desktop version of QB.  

@ninomcd 

Oops, forgot this wasn’t QBO.  It’s the checkmark in Desktop.