Upload your transaction data into your Xero account
In Xero, navigate to the Accounting menu and select Bank Accounts.
Locate the bank account you want to import the file into, click Manage Account, then click Import a Statement.
This will open the transaction import wizard. Click Browse and select the saved bank statement file, then click Open.
To import your data, simply hit Import.
Here you can assign the columns in your import file to the corresponding bank statement fields in Xero. It is important that the Account Code and Tax Type match the corresponding fields in Xero to ensure the statement lines reconcile automatically.
When you are finished, click Save.
Check the details in the Import Results dialogue box for any errors, then click OK to finish the import.
Your CSV transactions will now be imported to Xero. Xero confirms how many statement lines are imported and how many are automatically reconciled.
The Prepaid Mastercard® Card is issued by PSI-Pay Ltd pursuant to license by Mastercard
International Incorporated. PSI-Pay Ltd is authorised and regulated by the Financial Conduct
Authority of the United Kingdom under the Electronic Money Regulations 2011 (Ref: 900011) for
the issuing of electronic money. Mastercard is a registered trademark, and the circles design
is a trademark of Mastercard International Incorporated. *Credit terms apply to payment of
statements only and are offered separately by The Rix Group.