General Ledger Interface; added Xero Manual Journals file export

Two new interfaces for exporting General Ledger/ Accounting transactions to Xero have been added.

These interfaces can be imported via the "Manual Journal" import within Xero.

The interfaces are:

• "Xero Journal". This file export only includes Journal Transactions.
• "Xero Journal (Bank Transactions)". This file export only includes Bank Transactions.

To use the Xero interface you should configure finPOWER Connect to use GST as follows:

1. Under Admin, Information Lists, edit "GstCodes" and add Xero GST Rates. For example in NZ, add "I", "15% GST ON EXPENSES"; "J", "15% GST ON INCOME" and "X", "NO GST". The Alternate Value must match your Tax Rates in Xero.
2. Under Global Settings, GL and Accounting, check "Use Goods and Services Tax?" and enter the Exempt Code, e.g. "X".
3. Under Admin, Elements, Options page define the GST Code and Rate for each Element.

You must define this information, even if you do not use GST within finPOWER Connect.

In Xero you cannot directly post Manual Journals to Bank Accounts. Therefore, you can either not transfer Bank Transactions to Xero, or use a Bank Account Clearing account.

To use a Bank Clearing Account, create a new GL "Clearing" Account for each Bank Account in finPOWER Connect, and link these to Bank Accounts. All "Bank Transactions" are then posted to these clearing GL Accounts. In Xero code Bank Account transactions to these Clearing Accounts - at the end of each day the balance should be Nil.

Note, because of the way Xero works, you may find many "Draft" Manual Journals are created. A separate Manual Journal is created for each Date and Narration combination. To minimise this, consider changing the Element's Summary Type to "EOM" (End of Month).

In addition, Xero currently has a limit of 300 lines per import file. If you reach this maximum you will need to manually split the file.