Import receive money into Xero

Axis

Overview of importing receive money

You can import receive money (bank transactions - receive) into Xero from text, Excel and IIF files into Xero using Zed Axis.  

Steps to import into Xero

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 receive money.

Here is a description of the fields that you can import on a receive money.

Where the fields appear in Xero

Xero Receive Money

Detailed descriptions of the fields you can map

Xero field
Description
Contact name
Mandatory Name of contact (customer)
Line Item Description
Description of the sale
Line Item Quantity
Quantity sold (cannot be negative)
Line Items Unit Amount
Item price (must be greater than 0)
Line Items Account Code
Mandatory - Account code used on sale
Line Items Tax Type
Tax type used on the sale (see Tax Types)
Line Items Amount
Line amount
Tracking Name 1
StrName of the first Tracking Category more here 
Tracking Option 1
StrValue for the first Tracking Category more here 
Tracking Name 2
Str
Name of the second Tracking Category more here 
Tracking Option 2
Str
Value for the second Tracking Category more here
Bank Account Code
Mandatory - Bank account for the money received
Date
Date of Transaction in the format YYYY-MM-DD
Line Amount Type
Whether the line amount are Exclusive, Inclusive or NoTax on them
Reference
Mandatory - Reference for the Money received 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
 
 

Troubleshooting errors:

 
Error: The document total does not equal the sum of the lines
This error occurs when the Total value of the Receive Money transaction does not match the calculated total of the Line Items Amount.  In order to successfully import into Xero this is required to match the calculation made by Xero.  In some instances please make sure that if Exclusive amounts are being imported that the calculated amounts once tax is applied round to 2 decimal places.
Article ID: 200, , Modified: 10/11/2022 at 2:00 AM

Was this article helpful?

Share this article