Reconciliation difference because of date cleared

@TB201 

The date of the transaction in QB vs. your bank statement should have no effect on your bank reconciliation.  You mark it as cleared regardless of the date and it should reconcile.  If you don't see the transaction on your reconcile screen, remove the 'statement ending date' filter.     

Hi TB201,

I agree with Rainflurry. Only include a transaction in a reconciliation period when it clears your bank.

If you are sure that the E-payment dated 5/02 in QBO is the one dated 4/29 in your bank statement, you will include it in your April reconciliation. This means you'll want to redo your April reconciliation and include it this time.

Unreconcile each transaction using the steps below so you'll be able to redo your reconciliation:

1. Go to Accounting tab on the left panel.
2. Under Your Company, select Chart of Accounts.
3. Choose the account you’re working on, and click on View Register.
4. Select the transactions you want to unreconcile.
5. Keep on clicking the R status until it shows blank or cleared (C).
6. Click on Save.
7. Choose Yes in the confirmation window.

Feel free to go back to this thread if you have more questions about your reconciliation.

Hi,

I am having the same issue.  These suggestions don't resolve the issue of performing a month end reconciliation.  I am just going to change the transaction date in Quickbooks to agree with the date it cleared the bank.  This only matters if a transaction clears in advance at the end of the month.  If this happened mid month, it would not have any effect when reconciling.