Xero Journal Upload File

Xero Journal Upload File

Xero Journal Upload

This article is for customers who use Xero Accounting and want to post GL items to Xero using an upload file generated by iPayroll instead of the direct transfer (Xero Interface).
You must connect to Xero to complete the Costing and GL setup.
Once you have completed your set up and successfully posted a journal, disable the Xero Interface to stop any error messages.
For more information here Xero Price Plans
For more information here Xero Cashbooks
If you need to change or add a Tracking Category in Xero in the future, you will need to enable the Xero Interface.

Connect Xero

  1. Log on to iPayroll go to Setup > Interfaces
  2. Select > Xero > Enable
  3. You will be directed to your Xero account
  4. Log on with your Xero credentials.
  5. Allow iPayroll Access or Choose the appropriate Xero organisation if you have more than one.
  6. Save
  7. If successful the Enable button with display DISABLE
For more information here Connecting to Xero

Set up your Cost Centres

  1. Log on to iPayroll go to Setup > Costing/GL
  2. Select  > Enable Costing
  3. Add relevant Cost Centre codes for your payroll
  4. Add Cost Centre information to Employee Personal Details or Pay Elements.
For more information here Cost Centres

Set up the GL Accounts

  1. Go to Setup > Costing/GL > GL Accounts
  2. Add Cost Centre code to your clearing accounts
  3. Save
For more information here GL Accounts

Review the General Ledger 

  1. In an Open Payroll
  2. Go to Reports > Financial > General Ledger Postings
  3. Review the information
  4. Amend any information by editing employee cost centre, editing timesheet entries, adding new cost centres or editing GL Accounts
  5. Confirm Payroll

Generate a Journal File 

  1. Go to Reports > Financial > General Ledger Postings
  2. File Format* > Select Xero Journal from Drop Down
  3. Select > Create GL File
  4. glfile.csv.file created message will display 
  5. Select > Download file
  6. Save the file

In Xero

  1. In Accounting
  2. Select > Manual Journals > Import
  3. Go to Step 3: Import the updated template file
  4. Select > Browse
  5. Find your file
  6. Select > Import

Disable Xero Interface

  1. Log on to iPayroll go to Setup > Interfaces
  2. Select > Xero > Disable
  3. iPayroll will not be connected to Xero Accounting
For more information here Xero Posting Errors


    • Related Articles

    • Xero Accounting

      This article is for customers who use the Interface between iPayroll and Xero Accounting and want to automatically post your GL to Xero when you confirm a pay. The GL accounts will also need to be set up in iPayroll. Customers that do not want to use ...

    • How do I repost to Xero?

      Repost Historical Information to Xero This article is for customers who use Xero Accounting and post your GL to Xero when you confirm a pay. If there is an error in the process, a message will display on the confirm screen and a system generated ...

    • Disconnect iPayroll from Xero Accounting

      This article is for when you are experiencing issues with the iPayroll to Xero Interface. If you have tried to connect iPayroll to Xero and you are still not able to post invoices, you may need to disconnect the connection in Xero Accounting in order ...

    • Connect iPayroll to Xero Accounting

      Connect your iPayroll to Xero interface Log on to iPayroll go to Setup > Interfaces Select Xero > Enable You will be directed to your Xero account Log on with your Xero credentials. Allow iPayroll Access or Choose the appropriate Xero organisation if ...

    • BNZ File Transfer Channel & ANZ Fileactive Customers - Your Xero Reconciliations

      Reconciling your Bank Statement Line in Xero Customers using the BNZ File Transfer Channel (BNZ FTC) or the new ANZ Fileactive payment method to pay their employees will only see a single bank statement line in Xero. You can now post one combined ...