- Go to the bank and find the manage account, then select import statement.
- Download the Template – Get the Excel (CSV) template from Xero.
- Open the File – Open the downloaded Excel file.
- Enter Transaction Details – Fill in the date, amount, payer/payee, description, and reference.
- Upload the File – Once completed, browse your computer, select the file, and import it.
- Statement Imported – Your bank statement is now uploaded without duplicates
- To delete the bank line on Xero: find the transaction under the Reconcile tab, select Options and Delete line.
I hope you found this tutorial helpful! You can watch a video tutorial below.
Subscribe to the channel for useful videos. Have a question? Please send me a Xero question via form.