Import receive money into Xero

You can import receive money (bank transactions - receive) 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 receive money.
Here is a description of the fields that you can import on a receive money.
 
Xero Receive Money

 
Xero fieldDescription
Contact nameMandatory - Name of contact (customer)
Line Item DescriptionDescription of the sale
Line Item QuantityQuantity sold (cannot be negative)
Line Items Unit AmountItem price (must be greater than 0)
Line Items Account CodeMandatory - Account code used on sale
Line Items Tax TypeTax type used on the sale (see Tax Types)
Line Items AmountLine amount
Bank Account CodeMandatory - Bank account for the money received
DateDate of Transaction in the format YYYY-MM-DD
ReferenceReference for the Money received transaction
Currency RateExchange rate to base currency
URLUrl link to source document
StatusTransaction status code (ACTIVE)
Sub TotalTotal of transaction excluding tax
Total TaxTotal tax on transaction
TotalTotal of transaction including tax
 
 
Troubleshooting:
 
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.

Add Feedback