Import spend money into Xero

You can import spend money (bank transactions - spend) into Xero from text, Excel and IIF files into Xero using Zed Axis.  Follow these steps:
  1. Open Zed Axis and connect to your Xero company file
  2. Click on the import tab
  3. Browse to the file that you wish to import into Xero
  4. Create a map between the columns in your import file and the corresponding fields in Xero, a detailed explanation of the fields are included below.
  5. Click import and your data will be imported into Xero as spend money.
Here is a description of the fields that you can import on an spend money.


Xero field   Description
Contact name   Name of contact (supplier)
Line Item Description   Description of the purchase
Line Item Quantity   Quantity purchased (cannot be negative)
Line Items Unit Amount   Item price (must be greater than 0)
Line Items Account Code   Account code used on purchase
Line Items Tax Type   Tax type used on the purchase (see Tax Types)
Line Items Amount   Line amount
Bank Account Code   Bank account for the money spent
Date   Date of Transaction in the format YYYY-MM-DD
Reference   Reference for the Money spent transaction
Currency Rate   Exchange rate to base currency
URL   Url link to source document
Status   Transaction status code (ACTIVE)
Sub Total   Total of transaction excluding tax
Total Tax   Total tax on transaction
Total   Total of transaction including tax

Add Feedback