Users & setup

2 results found

1. Bank statement import - Bank statement balance check

   When importing a bank statement, it would be great if just before completing the import, Xero could show the end bank statement balance based on the existing bank balance and the transactions that are about to be imported. This could then be checked with the actual bank statement to make sure it matches.

   1 vote

   vote vote vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   vote

   We’ll send you updates on this idea

   0 comments  ·  Import  ·  delete…  ·  Admin →
   Completed  ·  AdminKelly Munro (Community Manager, Xero) responded

   Hi Mihaela, while it's not before statement lines imported. The Bank Reconciliation Summary report now allows you to enter a Bank statement ending balance. The Summary report will then calculate the balance out by based on the figure you enter. 🙂

2. 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.

   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… more

   3 votes

   vote vote vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   vote

   We’ll send you updates on this idea

   1 comment  ·  Import  ·  delete…  ·  Admin →
   Completed  ·  AdminKelly Munro (Community Manager, Xero) responded

   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.