Skip to main content
J
jmaurer1
October 20, 2023
Solved

How to handle a minor discrepancy in reconciliation?

  • October 20, 2023
  • 2 replies
  • 0 views

Hello!  I have a very small discrepancy in my September reconciliation that I have been unable to solve.  The amount is .04  (yes 4 cents!) but it is throwing me off and I fear will cause an issue with October's reconciliation.  I have combed through the bank statement and our company's QB register but unable to find the error.   I played around with how to make the Difference = 0, I added .04 cents as a credit to our ledger, but I am unclear what to call this type of entry.  Attached is a screen shot of the register.  Note that I did not check the .04 cent entry which is highlighted.  Once I select it, September will be reconciled but I am not sure if that is the right thing to do.       Any thoughts or is there a better approach?

 

Thank you so very much! 

Best answer by GlinetteC

I appreciate your query regarding handling the discrepancy issue, jmaurer1.

 

Several potential factors could account for the discrepancy in your account balance:

 

  • Someone entered an incorrect ending balance at the start of the reconciliation.
  • Someone edited or deleted transactions that were already reconciled.
  • There are missing or duplicate transactions in QuickBooks.
  • Someone entered transactions into QuickBooks that haven't cleared your bank yet.
  • Someone adjusted your last reconciliation with a journal entry.

 

To handle a minor discrepancy in reconciliation in QuickBooks Desktop, you can run a reconciliation discrepancy report to review and identify the specific transaction(s) causing the imbalance.

 

  1. Go to the Reports menu. Hover over Banking and select Reconciliation Discrepancy.
  2. Select the account you're reconciling and then select OK.
  3. Review the report. Look for any discrepancies.
  4. Talk with the person who made the change. There may be a reason they made the change. Once you know, edit the transaction as needed.

 

If the discrepancy is substantial and you want to ensure the accuracy of your books, I suggest consulting with a professional accountant or bookkeeper. They can offer valuable guidance and explore alternative solutions to rectify the minor difference.

 

If you require further assistance managing reconciliation or related matters, reply to this thread. I am here to support you at any time.

2 replies

G
GlinetteCAnswer
October 20, 2023

I appreciate your query regarding handling the discrepancy issue, jmaurer1.

 

Several potential factors could account for the discrepancy in your account balance:

 

  • Someone entered an incorrect ending balance at the start of the reconciliation.
  • Someone edited or deleted transactions that were already reconciled.
  • There are missing or duplicate transactions in QuickBooks.
  • Someone entered transactions into QuickBooks that haven't cleared your bank yet.
  • Someone adjusted your last reconciliation with a journal entry.

 

To handle a minor discrepancy in reconciliation in QuickBooks Desktop, you can run a reconciliation discrepancy report to review and identify the specific transaction(s) causing the imbalance.

 

  1. Go to the Reports menu. Hover over Banking and select Reconciliation Discrepancy.
  2. Select the account you're reconciling and then select OK.
  3. Review the report. Look for any discrepancies.
  4. Talk with the person who made the change. There may be a reason they made the change. Once you know, edit the transaction as needed.

 

If the discrepancy is substantial and you want to ensure the accuracy of your books, I suggest consulting with a professional accountant or bookkeeper. They can offer valuable guidance and explore alternative solutions to rectify the minor difference.

 

If you require further assistance managing reconciliation or related matters, reply to this thread. I am here to support you at any time.

J
jmaurer1Author
October 25, 2023

Thank you GlinetteC,  

Thank you so much for your response!  This is a new report to me and I appreciate learning more about the Report function in QB and other features.  I ran the report and did not find the discrepancy as I had hoped, so I believe this could be a bank error, as the overage was not posted on the statement and the ending balance represents what would be the closing statement if the overage of .04 was correct.  I've made the reconciliation so that this minimal amount will be reflected as a reconciliation discrepancy in an income account and now we are in balance.   Enjoy the rest of your evening!! 

 

 

J
jmaurer1Author
October 25, 2023

Hello Rainflurry! 

You have always been so helpful with your replies and I appreciate the simple solution. Since .04 overage is a truly minor amount, I created a new Reconciliation Discrepancy - Income account in the chart of accounts so now the ending and cleared balances match.   I have been learning so much with everyone's input within the community and it is very much appreciated!

    Rainflurry
    Rainflurry
    October 21, 2023

    @jmaurer1 

     

    When the amount is immaterial, you can assign that $.04 to income or an expense account so the reconciliation can be completed.  Some people assign it to a "Reconciliation Discrepancy" or "Cash Over/Short" expense account and then move it to an income or expense account at year-end so it's not a separate line item on the P&L.  It's really up to you but, yes, obviously you want to include it so that your Ending Balance and Cleared Balance match.   

      AlcaeusF
      AlcaeusF
      October 30, 2023

      Hello Rainflurry,

       

      Thank you for sharing your input to help address the issue. We love to see members supporting one another! Have a great day.

      Terms & ConditionsAccessibility statement