How do I Export Transactions to MYOB?

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

• Select MYOB as the Accounting system
• Select General Ledger Extract. This will create Journal entries within your MYOB ledger
• 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 still need to be recorded on the ledger, cash accounting presumes all invoices are paid.
• Optionally you can enter the next MYOB Journal Number, this will include the journal numbers in the export, rather than them being generated by MYOB when the extract is imported.
• Journal entries can be created in MYOB as one transaction for the entire extract or as individual journal entries for each transaction (this is done by including a blank line between each transaction in the extract). Checking the next box causes the latter behaviour.
• MemNet can create $0 transactions in some circumstances, MYOB 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 MYOB's journal import functionality. This file should be saved on your workstation or local network and imported directly into MYOB. For help with MYOB consult your MYOB documentation.

Please Note

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