Essentials transfer to MYOB classic

[ford]

Essentials transfer to MYOB classic

When I am importing data from a clients ledger in Essentials into MYOB classic

I map the GST Collected to imputs (expenses) 9140 and GST Paid to outputs (sales) 9142

The codes as set up in myob are 9140 - imputs and 9142 outputs but when I do the import it seems to change them round and my sales income have the GST code of imputs 9140 and on purchases GST items are coded with GST output 9142 which is supposed to be sales.

I noticed when I did the import and when to recode an expense item to another expense item and it wanted to change the GST code to outputs.

All our customer ledgers are set up for purchase GST codes to go to input 9140 and for sales gst codes to go to outputs 9142. But when I map them they seem to reverse and before I do the import I have to make the GST collected be 9142 and GST paid to be 9140.

I tried with both a txt extract file and an mye file but it still seems to be reversing

Thanks

[gavin12345]

Hi @ford 

Most import problems can be solved by first entering manually a sample transaction, and export that, study the export file and format import file to match. I suspect your issue with general journal imports is the sale/purchase indicator - this may be missing and MYOB defaults to the wrong one.

Regards

Gavin

[Mark_St]

Hi ford,

As you are importing as a txt file, open the txt file and look at the journals. Examine some of the sales and puchases journals. These will be a third line which will have the GST account code assigned to it.

Also, under General Ledger > Options > GST Accounts, make sure the GST Payable and Input Tax accounts are correct there.

[ford]

I don't know what the sales/purchaser indicator is or where to find it.

Don't know what you mean sorry

[ford]

I don't know what they are supposed to be so don't know if they are correct, that is why I posted the message in the first place

[gavin12345]

Hi @ford 

What you tried what was suggested - enter a sample journal in MYOB and export and study? If yes, upload the export file and someone may be able to identify the indicator for you.

Regards

Gavin

[ford]

is there a demo company that can be set up in essentials.

In the meantime I'll try and post my question in another forum