Import Payments into Xero

Overview of importing payments into Xero

You can import payments (accounts receivable) into Xero from text, Excel and IIF files using Zed Axis

Steps to import payments

Follow these steps
  1. Open Zed Axis and connect to your Xero company file
  2. Click on the import tab and then Browse to the file that contains your payments
  3. Create a map between the columns in your import file and the corresponding fields in Xero that are described in the table below
  4. Click import and the the payments will be importing in Xero.

Detailed description of the fields that you can map

 Xero fieldFormatDescription
Invoice Ref NumberStrThe reference number of the invoice that the payment is being made against
Credit Note NumberStrThe reference number of the credit note that the payment is bing made against
Payment Type EnumThe type of payment that is being made, possible values: ACCRECPAYMENT (accounts receivable payment) or ACREDITPAYMENT (accounts receivable credit payment)
Account Code Code of the account you are using to make the payment from
Date Date the payment. Needs to be in the format YYYY-MM-DD
Currency Rate Exchange rate when payment is received. Only used for non base currency invoices and credit notes
Amount Amount of the payment. Must be less than or equal to the outstanding amount owing on the invoice
Reference An optional description for the payment
Is Reconciled Whether the payment has been reconciled
StatusEnumPayment status. Possible values AUTHORISED or DELETED