Txt import to MYOB Classic not posting GST correctly

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
redrascal
Experienced Cover User
23 Posts
Experienced Cover User
New Zealand
Experienced Cover User

23Posts

2Kudos

0Solutions

Txt import to MYOB Classic not posting GST correctly

In Essentials

Output GST 821

Input GST 820

 

In AO Classic codes are the same

 

Import txt file

Pop up window

Select an Account

Transactions do not add to Zero

Choose an Account

 

When you select a suspense account and finish the import

Open the batch

Note on SOME transactions

Debit to Accounts Receivable for full Amount E.G 772.69

Credit to Sales for GST Exclusive Amount  E.G  671.90

Nothing in the GST column

It is the total of these erroneous entries that led to the Error and balancing entry in the batch

 

Ones that are correct show

Debit to Accounts Receivable for full Amount

Credit to Sales for Full Amount

GST portion in GST column

 

When you look at the Journal portion of the txt file on the entries that are correct you see the GST portion showing next to 821

on the incorrect ones no GST portion

 

I am stumped.

Have checked invoices

Have checked customer payments

Have checked GST codes in General Ledger Options

Have checked GST in GL Accounts Maintenance on the income code

4 REPLIES 4
Mark_St
MYOB Staff
122 Posts
MYOB Staff
Australia
MYOB Staff

122Posts

12Kudos

8Solutions

Re: Txt import to MYOB Classic not posting GST correctly

 

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

Mark_St
MYOB Staff
122 Posts
MYOB Staff
Australia
MYOB Staff

122Posts

12Kudos

8Solutions

Re: Txt import to MYOB Classic not posting GST correctly

Hi redrascal,

 

This is an issue that is random.

 

I have known it to appear for transactions with the INV description but that is not definitive.

 

The way to stop the out of balance is to open the txt file and add a line for the GST portion (either account 820 or 821) for the transactions that are missing the GST portion.

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

redrascal
Experienced Cover User
23 Posts
Experienced Cover User
New Zealand
Experienced Cover User

23Posts

2Kudos

0Solutions

Re: Txt import to MYOB Classic not posting GST correctly

Hi Mark

 

You are correct, it is SOME of the transactions that have the ref IV

 

Re your manual fix:  do you mean add a line for each transaction that's missing GST?  

So I would have to calculate the GST and put that in and the code 821?   

 

Please refer attachment the highlighted yellow is correct the red square is where you are saying I need to make the changes?

 

Look forward to your reply.

 

Andrena

Essentials GST Posting Error.JPG
Mark_St
MYOB Staff
122 Posts
MYOB Staff
Australia
MYOB Staff

122Posts

12Kudos

8Solutions

Re: Txt import to MYOB Classic not posting GST correctly

Hi Andrena,

 

That is correct.

 

You need to calculate the GST and enter the details and GST account code in the red square you havew highlighted.

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

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