Bank Account - View of the reconciliation (statement line & transactions)
It would be great to have a view into the reconciliation history that has the same format as the current Reconcile view - showing which statement line was reconciled against which Invoice/transaction - with the ability to "Remove and Redo". This would be helpful when analysing and fixing incorrect allocations.
Rob Allan
shared this idea
Hi Rob, appreciate raising the idea here. This could be a lot of information to show in one screen, especially if multiple transactions have been coded to a single statement line.
Being open it's not something we have planned however there are a couple of reports that you may find useful in Xero depending on your needs.
- Bank Reconciliation reports - specifically the Bank Statement & Statemernt exception reports will help paint a picture of the statement lines that have been imported and reconciled within a bank account, and any abnormalities through mark as reconciled, duplicates, and deletions.
- Account Transactions report - You can add a related account column which'll help understanding of where lines in a bank account have been coded to across your organisations accounts.
- Account Transactions tab of the bank account - As you've likely found the Account transactions tab is the best place to view and understand the reconciliations within a bank account. You do need to click into individual transactions to understand see the statement line it's been matched too, however you can bulk Remove & Redo from here.
We'll keep the idea open here so we can get a sense of the interest.
-
Lauren Mitchell
commented
Can we please have a report where we can print off a bank statement and it says where the transactions have been coded to.
Thank you