Export Transactions to General Ledger

This section describes the process to export transactions from Grain Trader and then import them to MYOB.

• click on Utility
• click on Export
• click on General Ledger Transactions

The Export window allows the user to export all transactions not yet exported or to export all transactions even if they have already been exported. In conjunction with this option the user can select transactions from last month, this month or a specific date range.

• Once the parameters have been set, click on the OK button.

When the export is complete a summary window is displayed. This window tells the user how many of each transaction was exported and where the export files are located. Payments, Receipts and Journals are exported to different files.

• Click OK the close this window.

In your MYOB program

• open your company file
• then click on File
• click on Import Data
• click on Transaction Journals
• change Import File Format to – Comma-Separated
• change First Record to – Data Record
• click Continue
• you will now be asked to select your Import File
• browse to where your Grain Trader Export files were saved and select the first file to be imported. It will have todays date as part of the file name. (e.g. GLPAY-20110406_1.txt)
• this is the first Payment Export file which Grain Trader has exported today
• once the file has been selected
• click the Match All button to match the field types
• then click the Import button to import the transactions
• MYOB will tell you how many records were imported and how many records were skipped due to error
• repeat this procedure for Receipts and for Journals