Reconciliation - Change reporting date for reconciliation of checks
When I enter the month of the bank statement with the bank statement beginning and ending balances and want to make sure all of the transactions from that month's bank statement are accounted for, checks that were written in a previous month but not posted in the bank statement until another month aren't showing up in coded transactions in the month where the bank transaction occurred. The reconciliation with the check payment and the bank transaction can be made, but the transaction doesn't show up in coded transactions section of the bank reconciliation detail report for the month the bank transaction occurred. This makes it so you can't actually reconcile the bank statement for that given month without changing the date the check was cut. I've never run into this problem with other accounting programs I've used. It also throws off the detailed bank reconciliation report for the month that the check was cut because when the transaction is reconciled, it puts it into the bank reconciliation detailed report for the month the check was cut instead of the month the bank transaction occurred.
Julie Painter
shared this idea
Thank you for sharing this detailed idea about how the reporting date is handled for reconciled checks.
We understand the issue you've described. When a check from a previous period clears the bank, the reconciliation report posts the transaction to the month the check was written, not the month it actually appeared on the bank statement. We can definitely see how this makes it challenging to use the report to verify a specific month's bank activity.
We're grateful for your engagement and letting us know the changes that matter to you. We've reviewed your idea and now it can gain support from other community members. Along with votes, others can now comment to share additional detail about how changing the reporting date for reconciled transactions could improve their experience with Xero.
