Partner Zone
Partner Zone

Essentials transfer to MYOB classic

Trusted User ford
130 Posts
Trusted User
New Zealand
ford
Trusted User

259Posts

14Kudos

3Solutions

Essentials transfer to MYOB classic

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

6 REPLIES 6
Ultimate User gavin12345
2,000 Posts
Ultimate User
Australia
gavin12345
Ultimate User

2711Posts

2070Kudos

387Solutions

Re: Essentials transfer to MYOB classic

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

MYOB Staff Post Mark_St
38 Posts
MYOB Staff Post
Australia
Mark_St
MYOB Staff Post

38Posts

3Kudos

3Solutions

Re: Essentials transfer to MYOB classic

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.

Cheers,
Mark

Practice Support Analyst

Online Help| Forum Search| my.MYOB

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Trusted User ford
130 Posts
Trusted User
New Zealand
ford
Trusted User

259Posts

14Kudos

3Solutions

Re: Essentials transfer to MYOB classic

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

Don't know what you mean sorry

 

Trusted User ford
130 Posts
Trusted User
New Zealand
ford
Trusted User

259Posts

14Kudos

3Solutions

Re: Essentials transfer to MYOB classic

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

 

Ultimate User gavin12345
2,000 Posts
Ultimate User
Australia
gavin12345
Ultimate User

2711Posts

2070Kudos

387Solutions

Re: Essentials transfer to MYOB classic

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

Trusted User ford
130 Posts
Trusted User
New Zealand
ford
Trusted User

259Posts

14Kudos

3Solutions

Re: Essentials transfer to MYOB classic

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

 

 

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post