Import journals into Xero

You can import journals (manual journals) 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 customer invoices.
Here is a description of the fields that you can import on a journal

Xero field Type Description
Narration   Description of the journal being posted, also used to group batch journals together
Date   Date the journal was posted in the format YYYY-MM-DD
Status   Status of the journal (DRAFT, POSTED, DELETED, VOIDED)
Url   Url link to source document
LineAmountTypes Enum Whether the amounts are including or excluding tax, possible values are NoTax, Exclusive or Inclusive
LineAmount   Total for line, Debits are positive, Credits are negative
Line Account Code   Chart of account.
Line Description   Description for a journal line

Add Feedback