Reconciliation - Edit imported bank statement CSV directly in Xero
For manual reconciling, the bank statement file can be generated using a CSV template and requires inputting details like the Date, Description, and Reference. However, users, especially those with high monthly transactions, may want to change/edit the descriptions after the file has been uploaded and reconciled.
Currently, to do so, the bank statement needs to be deleted and re-uploaded, which means unreconciling previously reconciled items and repeating the entire process. If there are many to be amended, this process may need to be repeated multiple times. It would be beneficial if we could directly edit the contents of the bank statement from Xero without having to delete and re-upload it, avoiding the need to repeat the entire process.
Jia Ling Hau
shared this idea
Hi team, with the new Bank Reconciliation report you can now enter a Bank statement ending balance.
This means, if you don't have an imported statement balance or this doesn't match your actual bank statement balance you can enter the balance yourself, update the report and Xero will show the Calculated balance out by amount.
-
Nana Anyina Cudjoe
commented
I am currently facing this challenge and, in my case, when uploading the statement, the description column had details but after uploading, i realized there were no descriptions for any of the transactions. I tried to re-upload and realized that on the edit statement preview page, the description column was showing "not assigned" to a xero column and when I manually assigned it, the statement line now appeared with the details.