Skip to main content
S
sharieb
May 6, 2022
Question

bank reconciliation showing transactions from previous reconciled month

  • May 6, 2022
  • 1 reply
  • 0 views

Good day,

 

We have been having a crazy time at work and I have just now been able to do a bank reconciliation for the month of January. We have a chequing account we use for pretty much everything, a high interest savings account for large deposits, and several smaller fund accounts that basically just collect interest. Everything balanced out in all the accounts during the reconciliation. I printed reports, and I am now reconciling the chequing account for February. However, there are several transactions from January showing up in this reconciliation...these were deposited into the savings account early January which I already reconciled. I double-checked and they are showing in the bank register for the account they were deposited in, so I don't understand why they are still showing up for this one.

 

Is this normal? And if so how do I remove those items?

Edit: I just looked at the register for the chequing account and these items are also showing there, under Accounts Receivable and not the revenue account they were supposed to go into. Is this why they are still showing up in the reconcile window? When I look at the savings register they are showing in the right account. 

1 reply

C
ChristineJoieR
May 6, 2022

Thank you for keeping us updated on your progress, @sharieb.

 

I'm here to assist you in determining why reconciled accounts keep on showing.

 

Transactions you've already reconciled may appear unreconciled. There could be several causes for this:

 

  • Someone had undone the previous reconciliation.
  • The reconciled transactions were modified or removed by someone.
  • In the account register, cleared transactions were unchecked (uncleared).
  • Funds were transferred to a sub-account from a previously reconciled bank account.
  • Conversions of company files (from QuickBooks for Mac to Windows or QuickBooks Online to Desktop) might cause problems (in the US only).
  • In the company's records, the transactions were never reconciled. This could be the file being restored from a backup, resulting in the data and reconciliations being rewritten.

 

 

Let's do a specific reconciliation to get rid of the balance. An "off-cycle" date is use in this strategy. Please double-check the recent reconciliation's concluding balance.

 

Here's how:

 

  1. Go to the Banking menu and then select Reconcile.
  2. Choose the bank account with the transactions you need to reconcile.
  3. In the Date of Statement field, enter the date for an "off-cycle reconciliation." This date can be modify between your last reconciliation and the next scheduled one.
  4. In the Ending Balance field, enter the balance of your last successful reconciliation. 
  5. Select Continue.
  6. From the Reconcile window, check off the transactions you are fixing and re-reconciling.
  7. Make sure the Difference field shows $0.00.
  8. When everything looks good, select Reconcile Now.

For further guidance, please see this article: Do a Special Reconciliation.

 

If you notice no discrepancy, possibly there's a duplicate transaction on your books. You can delete the following transactions, make sure they are not linked to the other data. Check out this article for your guide: Batch delete or void transactions in QuickBooks Desktop Accountant Edition.

 

Additionally, I've included these articles to ensure you'll reconcile your account successfully:

 

Please return to this topic if you require further assistance with reconciling your account. I'm determined to find a solution. Have a nice day!

S
shariebAuthor
May 9, 2022
  • Nobody could have undone the reconciliation because I'm the only one who uses Quickbooks Desktop.
  • That's the same reason they weren't modified or removed. 
  • I do not know why something needs to be checked off in the account register as I was doing the checking off when recording the deposit. Am I missing a step?
  • There was no transfer of funds; funds were deposited from "Undeposited Funds" into the Savings Account, and that was reconciled as well. I have tried to undo the reconciliation and removed everything from the register then redo it, only to have the exact same thing happen where they show up again in the "cheques and payments section" when going back to the February reconciliation.
  • I have gone through the entire month to see if there were any duplicates but I only saw one, which I promptly removed (both payment and invoice) before re-reconciling
  • There was no file conversions as we just started using QBD in 2022 and had our accountant set up everything for us.
  • I would like to try doing an "off cycle" reconciliation to fix this. The problem is that I'm not sure what date I should be putting for an "off cycle" reconciliation since I still have to reconcile February, March, and April.
    C
    Charies_M
    May 9, 2022

    I appreciate the additional information you shared about your reconciliation concern, sharieb.

     

    The steps shared by Christine enlighten why transactions from the previous reconciled month are showing in your bank reconciliation.

     

    Based on your given scenario, I recommend reaching out to your accountant or bookkeeper for guidance. They share some expert advice on how to deal with this type of situation.

     

    You can also find an account by clicking on this link: Find an accountant.

     

    Feel free to visit this guide when reconciling your account: Reconcile an account in QuickBooks Desktop.

     

    You may find this article helpful in case your accounts in QuickBooks Desktop don't match your bank statements at the end of reconciliation: Fix issues when you're reconciling in QuickBooks Desktop.

     

    For more questions, while reconciling, just drop me a reply below. I'm always here to help. Have a good day ahead.

    Terms & ConditionsAccessibility statement