How to import a CSV file with transactions into Xero

How to import a CSV file with transactions into Xero

Import created CSV file into Xero Online accounting system

From this step, you must have already created a CSV file. You can download it from your Online Banking or you can create with ProperSoft converter, for example, PDF2CSV or Bank2CSV converters. And when you convert to CSV, select Xero, as a 'CSV Target' for your CSV file. So the file will be properly formatted for Xero. If your CSV file downloaded from your Online Banking, maybe you would need to map it.

CSVIMPORTXERO Step 1: main menu Xero

So first, click on 'Accounting' and then click on 'Bank accounts'. Now you have to select Bank account or Credit Card account to import transactions into.

CSVIMPORTXERO Step 2: Accounting in Xero

So, for example, you have a Checking account. Look for the 'Manually import a statement' or click on 'Manage Account' and look for the link 'Import a Statement'. In your accounting software, look for "Upload a bank file" or similar links to upload created CSV file.

CSVIMPORTXERO Step 3: Manage Account in Xero

Click the 'Browse' button and select a CSV file.

CSVIMPORTXERO Step 4: click Browse in Xero

Then click the 'Import' button.

CSVIMPORTXERO Step 5: click Import in XeroMap your CSV file to Xero transaction fields. Make sure that you are converting correctly a CSV file. You can review the transactions before importing into Xero account.

CSVIMPORTXERO Step 6: statement import options in Xero

Names, like 'Date', 'Amount', 'Payee', 'Description', 'Reference', 'Check number' are from the CSV file. So when you create a CSV file with ProperSoft converter and you select the option 'CSV Target' as Xero, it will add the header column names to the CSV file. So it's easier than to map it when you import into Xero. And another thing it will name the columns that Xero can understand on automatically map. So, in this case, Date automatically mapped to transaction 'Date', Amount automatically mapped to transaction 'Amount', Payee to 'Payee' and Description to 'Description'.

CSVIMPORTXERO Step 7: date, amount, payee in Xero

Only two columns 'Reference' and 'Check number' are not automatically mapped. But they would be on your CSV file if you convert with ProperSoft converter and the file, which you convert, has checks and check numbers, then the column gonna be filled. And if there's additional information on your OFX file or a PDF file, then it would go to 'Reference' column and then you can map it as well. QuickBooks doesn't have this', but Xero has this additional column. That is very convenient when you would like to store additional details about transactions.

CSVIMPORTXERO Step 8: reference, check number in Xero

Create 'Reference', select 'Check Number' and now you can review transactions if you like. Click 'Next' and you can see Dates, Amounts, you can see how they will be in Xero.

CSVIMPORTXERO Step 9: click next in Xero

Click the 'Save' button.

CSVIMPORTXERO Step 10: click save in Xero

And click 'Ok'. Now your transactions are imported.

CSVIMPORTXERO Step 11: click ok in Xero

Next step is to map Payee names to Vendor Records. Let's say you would have Payee something like Shell 1, 2, 3 or Shell, or something like that, but you have Vendor called Shell in your Xero accounting. And then you would select Vendor Record in Xero for that transaction. Categorize transactions by selecting the account. And then transactions will be under your account.

CSVIMPORTXERO Step 12: categorize transactins in Xero

Related articles