How do I Export Transactions to Xero?

To export invoices and payments from MemNet to Xero go to Administration / Import/Export / Account System Extracts. This page provides the following options:

• Select Xero as the Accounting system
• Select General Ledger Extract. This will create Journal entries within your Xero ledger (this is the only option available at this time)
• The Narration Prefix is included at the beginning of the journal narration included in the export.
• Select the Extract type that matches your accounting processes. Note that accrual accounting has separate extracts for invoice and payment data as invoices that are unpaid at the time of the extract will still be recorded on the ledger, cash accounting presumes all invoices are paid and extracts paid invoice only.
• MemNet can create $0 transactions in some circumstances, Xero does not like this, so an option is provided to exclude these from the extract.
• From and to dates. This is the date range of transactions to be included in the export. All transactions within this date range will always be included in the extract.
• Click Submit.

This will produce a file in a format compatible with Xero's journal import functionality. This file should be saved on your workstation or local network and imported directly into Xero. For help with Xero consult your Xero documentation.

Notes:

1. GL revenue account codes and control account codes need to be configured within MemNet to match your Xero chart of accounts.
2. It is the MemNet users responsibility to ensure transactions are not back dated to a time period already transferred to Xero. Whenever a transaction is backdated a pop up window will remind you of this.

See also What is the Accounting Cut Off Date?