cancel
Showing results for 
Search instead for 
Did you mean: 
Swilli
Level 1

Reconciliation Discrepancy

Hey QB community! I have a client that wrote a check in August and the check cleared in September. September will not reconcile and it is off by the amount of the check written in August. It was included on the September statement. I have combed the entire account looking for another discrepancy but couldn’t fond one. Should I do an adjustment? If so should adjustment dates go according to the date it cleared or the date written?

Thank you all for your time!

2 Comments 2
GenmarieM
QuickBooks Team

Reconciliation Discrepancy

Welcome to the Community space, @Swilli.

 

I'm here to share information about your written check in QuickBooks Online (QBO).

 

If the check wasn't included in the reconciliation in August, you can include it in September. You can consider editing the date period in the reconciliation table.

 

In case you want to make adjustments, you'll need to reach out to your accountant for the accuracy of the data.

 

Moreover, I'm adding this helpful article in case you encounter discrepancies in your reconciliation: Fix issues at the end of a reconciliation in QuickBooks Online.

 

Return to this post if you have other concerns about reconciling your bank transactions in QBO. I'll be here to lend a hand. Have a good one!

Rainflurry
Level 14

Reconciliation Discrepancy

@Swilli 

 

"September will not reconcile and it is off by the amount of the check written in August. It was included on the September statement. I have combed the entire account looking for another discrepancy but couldn’t fond one. Should I do an adjustment?"

 

Something doesn't sound right.  Was the check reconciled in August?  The date of the check is irrelevant as long as it is dated prior to the statement ending date.  When you write a check it will appear on your reconcile screen.  You reconcile (mark as cleared) the check in the month it appears on the statement.  If you cleared it when doing the September reconciliation, and you're off by that amount than something else is causing the discrepancy.  Both your bank statement and QB use the same formula: Beginning Balance - Payments + Deposits = Ending Balance. The bank statement and QB list those amounts separately.  Confirm they match.   

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us