cancel
Showing results for 
Search instead for 
Did you mean: 
CSM_Div10
Level 2

Transaction appears as reconciled but was not

Good morning - I have a transaction that is marked as reconciled.  I did not reconcile it.  Last month's bank reconciliation was completed successfully.  When I went to do this month's, there is one transaction that is on the bank statement but is already marked as reconciled in QB.  I have tried to uncheck it and that just throws off the starting balance of this month's.  I have no idea why or how this could have happened.  I just need to correct it.  All assistance is greatly appreciated. 

Solved
Best answer December 14, 2020

Best Answers
CSM_Div10
Level 2

Transaction appears as reconciled but was not

Thank you for your help!  With the audit trail I figured out that I had accidentally changed the date on a reconciled transaction - that happened to be the same type of transaction and amount - from Sept.  I changed the date on the transaction back to what it was originally, and this did not have any impact on the current beginning balance for the Nov reconciliation.  I created the correct transaction in QB for the Nov transaction, exported the transaction from the bank to match it, did the reconciliation and everything seems to be good at this point.  If I was not supposed to do this, please advise. :-)

View solution in original post

6 Comments
ChristieAnn
QuickBooks Team

Transaction appears as reconciled but was not

Hi there, CSM_Div10.

 

I'm glad to see you here posting and welcome to QuickBooks Community. I'll provide steps to ensure that you're properly reconciling and to make sure that your account stays accurate.

 

The transaction in question will be marked as reconciled when it's part of a previously reconciled account. Thus, when you uncheck it on the reconciliation, it will throw off the starting balance for this month. I suggest going to the Account Register page and review your transactions to verify if the said entry is a duplicate. Then, you can delete it so this will not show again in the bank statement.

 

Here's how:

 

  1. Click the Banking menu at the top.
  2. Choose Use Register. Then, select an account and click OK.
  3. Locate the possible double entries. Then, right-click and choose Delete.
  4. You'll be prompted with Delete Transaction. Then, click OK to confirm the deletion.

 

Once done, you can now go bank to the reconciliation page and start reconciling your account.

 

Please refer to this article to see information on how to fix the issue once 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.

 

Please let me know in the comment section below if you still have a concern about reconciliation. I'll be waiting for your response and will be always happy to lend a helping hand. Tale care!

CSM_Div10
Level 2

Transaction appears as reconciled but was not

Thank you for responding so quickly!  But, I still have the problem.  The reconciliation for October was completed successfully.  Later in November, the transaction in question was entered into QB as a GJE.  When I started the November reconciliation, this transaction had already been marked as reconciled.  I don't know why or how. I'm the only one accessing QB.  This transaction is on the bank statement for November.  Nothing I have tried has been able to correct this.  I also ran the reconciliation discrepancy report and there are no errors.  Thanks again!  

MichelleBh
QuickBooks Team

Transaction appears as reconciled but was not

Thanks for the quick reply, @CSM_Div10.

 

I appreciate you for doing some primary troubleshooting steps on your end to fix the transaction that has been marked as reconciled. 

 

Let's check the Audit Trail as an alternative. This way, you can review who made the changes. Then customize and filter the report to locate the specific journal you're looking for.

 

Here's how: 

 

  1. Click Reports at the top menu bar.
  2.  Choose Account & Taxes, then select Audit Trail. 

report.PNG

     3. On the report screen, click Customize Report.

     4. Go to the Filter tab and search for the Transaction type.

     5. Choose Journal and hit OK.

     6. Filter the dates, then find the said transaction. 

report1.PNG

 

If you see Admin in the Last modified by section, then there's a possibility that you've included that transaction on your previous reconciliation or you've manually reconciled it. With that, you can follow the steps presented by the colleague above to resolve the issue. I'd also suggest consulting an accountant for more assistant in undoing the reconciliation.

 

On the other hand, if you see System Administration, I'd recommend communicating with our Customer Care Team. They can access your account in a safe environment and check the root cause of the problem. 

 

Here's how: 

 

  1. Go to this link: https://quickbooks.intuit.com/learn-support/en-us/configure-products/contact-the-quickbooks-desktop-...
  2. Complete the required information. 
  3. Hit Submit

 

Please contact our support within our business hours to ensure we address your concern immediately. For more information, visit this article: Contact QuickBooks Desktop support.

 

I've also added these articles below that can help you troubleshoot reconciliations, reverse journal entries, and other topics: 

 

 

Don't hesitate to tag my name in the comment section below if you have follow-up questions. I'm glad to help. Keep safe!

CSM_Div10
Level 2

Transaction appears as reconciled but was not

Thank you for your help!  With the audit trail I figured out that I had accidentally changed the date on a reconciled transaction - that happened to be the same type of transaction and amount - from Sept.  I changed the date on the transaction back to what it was originally, and this did not have any impact on the current beginning balance for the Nov reconciliation.  I created the correct transaction in QB for the Nov transaction, exported the transaction from the bank to match it, did the reconciliation and everything seems to be good at this point.  If I was not supposed to do this, please advise. :-)

View solution in original post

Ryan_M
QuickBooks Team

Transaction appears as reconciled but was not

Hi @CSM_Div10,

 

Thank you for your prompt reply, as well as for sharing an update on your situation. 

 

There wasn't an issue with what you did after you created the other transaction for November since they have the same amount. To avoid experiencing this type of situation again in the future, I suggest you reconcile your bank account(s) each month to ensure your books remain accurate. 

 

In case you bump into any problems during the reconciliation process, see this article: Fix issues when you're reconciling in QuickBooks Desktop. It's a step by step guide on how you can resolve issues you may encounter during this process.

 

Let me know if you have other queries on your QuickBooks Desktop (QBDT). I'll be sure to take care of them for you. 

CSM_Div10
Level 2

Transaction appears as reconciled but was not

Hi Ryan_M -  Thanks for the message.  I actually do reconcile each month so I was suprised that this happened.  Thanks for the link you sent also!

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us