Forum Discussion

redrascal's avatar
redrascal
Experienced Cover User
5 years ago

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

Replies have been turned off for this discussion
  • 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.

    • redrascal's avatar
      redrascal
      Experienced Cover User

      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

      • Mark_St's avatar
        Mark_St
        MYOB Staff

        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.