EVOPOS can export files ready to be imported into MYOB.
They are 3 formats to choose from:
- MYOB Sales Export (Reduced Fields)
- MYOB Sales Export (All Fields)
- MYOB Retail Manager Format
Setting the export format and file location:
Exporting the File
The export file will be created when you close the batch in EVOPOS.
By setting the export program in the setup, EVOPOS will export the file when closing the batch in Sales\Options\Close Batch.
MYOB Retail Manager Format
This export uses the same method of exporting as MYOB Retail Manager to MYOB Accounting.
The Nominal accounts defaults are listed below, however they can be changed in Accounts / Nominal by entering the MYOB Nominal code in the Export Code. For example if you wanted the MYOB Nominal for Sales Department 1 to be 41000 you would go to Evopos Nominal: 04-01-01 and enter: 41000 in the Export Code.
Evopos Nominal MYOB Defaults
- Purchase Orders (Stk-In) 01-01-01 - 11300
- Inventory Adjmt (Stk-Out) 01-01-01 - 11300
- Inventory Adjmt (COGS) 05-01-01 - 51000
- Debtor Difference 01-07-01 - 11200
- Payments Received 01-09-01 to 01-09-99 - 11101 to 11199
- Sales (Dept 1 to 9) 04-01-01 to 04-01-09 - 41001 to 41009
- Sales Difference 04-01-01 - 41001
The difference between Sales and Payments Received is normally the Debtor Difference. If this does not match (Settlement Discounts etc) the difference will be entered in the Sales Difference.
Evopos will create the file with the Purchase Orders first, and then the other entries grouped by each day. This means you get summary figures for each day and not the individual transactions. Sales are divided by Department and Payments Received are divided by the Payment Method.
MYOB Sales Export (Reduced Fields)
Individual Items by Transaction. Tab delimited chr(9)
MYOB Sales Export (All Fields)
Individual Items by Transaction. Full number of fields. Tab delimited chr(9)
Addr 1 - Line 1
"- Line 2
- Line 3
- Line 4
Salesperson Last Name
Salesperson First Name
Inc-Tax Freight Amount
Freight Tax Code
Freight Non-GST Amount
Freight GST Amount
Freight LCT Amount
Terms(-Payment Is Due)
- Discount Days
- Balance Due Days
- % Discount
- % Monthly Charge
Name on Card