Forum Discussion

Caroline_V's avatar
Caroline_V
Experienced User
5 years ago
Solved

GST on Pre-Conversion Deposits incorrect

Hi there   I entered 2 pre-conversion deposits on our changeover to AccountRight Premier NZ 2020 from AccountRight Premier v19.8.  These were dated 1/4/2020 being our conversion date and I am now t...
  • Steven_M's avatar
    Steven_M
    5 years ago

    Hi Caroline_V 

     

    From an AccountRight perspective, as a Recieve Payments transaction has been created and the invoice has been paid there will be an impact on the GST reports due to that payment transaction (assuming those reports are being run on a payments basis.

     

    The only way to remove that would be to use a not reportable GST code on the transaction for that deposit amount, having the residual amount of the invoice (i.e. the original invoice amount less the deposit amount) as a separate line with the respective GST code. For example, say the Invoice was for $150, a $10 deposit has been paid you would be looking at having $10 as a not reportable tax code and then $140 against a reportable tax code list GST. 

     

    However, in saying that, I would recommend speaking to an accountant in regards to the best way to handle that situation.

Caroline_V's avatar
Caroline_V
Experienced User

Hi Steven_M 

 

I finally worked out how to fix this.  The GST problem occurred when the Deposit was applied against the Order using Receive Payments, because the Order had S15 applied to it of course.  There is nowhere to specify the GST code during that part of the process.

 

My fix:

1.  Create new customer card to be used to adjust the GST (so it's kept separate from regular transactions).  In the "Ship to" address field I put a description of what it was I was rectifying so it would show on the invoices.

2.  Create 1 new credit invoice under the new customer card for the 2 deposits with the NZ S15 GST code applied.

3.  Create 1 new debit invoice under the new customer card for the 2 deposits (GST inclusive amount) with the NZ N-T GST code applied.

4.  Apply the new credit against the new debit invoice.

 

Now MYOB GST return is correct.

 

5.  Finally, I also had to do a General Journal entry to transfer the GST amount of $#### from the 2-1310 GST Collected Account to the 4-1900 Income/Sales account so that everything balanced correctly.

 

Now the Total GST on the Balance Sheet is correct!  😊 

 

Hopefully this is helpful to others as well.  Took me ages to nut it out.

 

Kind regards

Caroline

Caroline_V's avatar
Caroline_V
Experienced User
5 years ago

... the only thing is it's showing the GST adjustment in the Sales [Customer Summary] Report and Analyse Sales [Customer] Report now for April.  I can't edit/delete this amount from the Customer Card History for April because it's in the current FY (NZ) and the cursor doesn't select the amount for the current FY as it does for previous FYs.  (Using AccountRight Premier NZ 2020.2.2 Build 2020.2.23.9038.)

  • Steven_M's avatar
    Steven_M
    Former Staff
    5 years ago

    Hi Caroline_V 

     

    The Analyse Sales [Customer] report will pull from a Card's History. We have recently identified that the card history doesn't update when the change is made in online company files. This does mean that once a transaction/value has been added to the history any changes to the transaction including deleting the transaction will not update the card history. As such, when you are running the Analyse Sales [Customer] report it will show the original amount regardless of whether that transaction has since been deleted or edited. This situation has been passed across to the required team for further investigation.

    • Caroline_V's avatar
      Caroline_V
      Experienced User
      5 years ago

      Thanks Steven_M  ... Yes, had the same problem with the Supplier card history last week as well.  Glad to hear it's being looked into.  Hopefully a quick and easy fix.

       

      Kind regards

      Caroline