Evopos Help - 2.09.068

MYOB

MYOB

Previous topic Next topic  

MYOB

Previous topic Next topic JavaScript is required for the print function  

Please see the Accounting systems - Overview sections first

There currently 3 formats for exporting to MYOB.

MYOB  Sales Export (Reduced Fields)

Individual Items by Transaction. Tab delimited chr(9)

CardName

SaleDate

Part_No

Qty

Description

UnitNet

TotalNet

TotalInc

TaxCode

Tax

LocationID

 

MYOB  Sales Export (All Fields)

Individual Items by Transaction. Full number of fields. Tab delimited chr(9)

Co./Last Name

First(Name)

Addr 1 - Line 1

"- Line 2

- Line 3

- Line 4

Inclusive

Invoice #

Date

Customer(PO)

Ship(Via)

Delivery(Status)

Item(Number)

Quantity

Description

Price

Inc-Tax Price

Discount

Total

Inc-Tax Total

Job

Comment

Journal(Memo)

Salesperson Last Name

Salesperson First Name

Shipping Date

Referral(Source)

Tax Code

Non-GST Amount

GST(Amount)

LCT(Amount)

Freight(Amount)

Inc-Tax Freight Amount

Freight Tax Code

Freight Non-GST Amount

Freight GST Amount

Freight LCT Amount

Sales(Status)

Currentcy(Code)

Exchange(Rate)

Terms(-Payment Is Due)

- Discount Days

- Balance Due Days

- % Discount

- % Monthly Charge

Amount(Paid)

Payment(Method)

Payment(Notes)

Name on Card

Card(Number)

Expiry Date

Authorisation(Code)

BSB

Account(Number)

Drawer/Account Name

Cheque(Number)

Category

Location(ID)

Card(ID)

Record(ID)

 

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.

Area                                Evopos Nominal                MYOB Default

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

 

Note: 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.