Correct GST return

Please @lubos can you fix the NZ GST returns the import amount goes into box 13(purchases credits)

So looking at the NZ GST return localisation in Managers Settings -> Report transformations

You are happy with the calculation section

But want the gstInImports variable shown somewhere.
13 label is “Any credit adjustments” which in not very intuitive.

You can just type that in if that is what you want

As discussed in another post the Total Purchases should not include GST on imports. GST on imports should be in box 13 “any credit adjustments” Yes I have tried to change it but I can not seem to get the correct amount for refund/pay with all variables ie if there is no Purchases and expenses and just GST on imports ,it will show a negative when it should not be or a positive when it should not be or if there is no sales and just GST on imports it does the same . If the return is open to anyone it should be right with out someone having to go in and try and change it more so if they have no idea what they are doing

Fixing this will require debugging and accounting input.
For the debugging I suggest

  1. Importing the NZ GST worksheet into a test business

  2. Edit the GST worksheet to showing all interim calculation variables as shown below


Note extra cells can easily be added by a mouse menu shown from the left grid numbers.
NZ%20menu

  1. Then enter a single transaction and check the worksheet results. Testing a:
  • Sale
  • Purchase
  • Sale return (ie negative value)
  • Purchase return (ie negative value)
  • Both local and imports

Compare the results to hand generated answers. Note this requires knowledge of local accounting rules and as I’m not an New Zealand accountant, is not something I can do.

When the worksheet is corrected, the correct worksheet entries can be copied to a fresh business / worksheet import. This updated worksheet could then be exported for others to use.

Hi Patch I am way ahead of you done all that and saved it back as a jason file so I could down load it to my other clients business. I can not seem to figure out how to make the end figure consistent .This is what I have
{% assign totalImports = taxOnSalesMinusTaxOnPurchases[GST_15_on_Imports] | times: -1 | times: 23 | divided_by: 3 | round: 2 %}
{% assign gstOnImports = taxOnSalesMinusTaxOnPurchases[GST_15_on_Imports] | times: -1 %}

{% assign C11 = totalPurchases[GST_15] | plus: totalImports %}
{% assign C12 = taxOnPurchases[GST_15] | default: 0.00Format: 0.00 %}
{% assign C13 = GSTOnImports| default: 0.00Format: 0.00 %}
{% assign C14 = C12 | minus: C13 |times: -1 | Format: 0.00 %}

which looks like this


and runs like this

but if I dont have any import GST it comes out like this

I am not sure how to write it so if there is no import GST . it has something to do with this line
{% assign C14 = C12 | minus: C13 |times: -1 | Format: 0.00 %} because all I have to do to fix it is go in and take out |times: -1 so I am not sure how to write it if there is no import GST then dont do the times-1

I will have to test later what this is actually doing. It is possible if one of the variable is blank rather than zero the expression evaluation order changes.

Printing the actual variables would confirm it.
If so this could be avoided by using an if statement or possibly brackets.

correct but I dont know how to write an if statement in HTML?

It’s in liquid https://shopify.github.io/liquid/tags/control-flow/

I am a dummy thats what I meant .And yes I have that site booked marked to. Just not sure how to use it

{% if C12 == " " %}
 {% assign C14  = C12 | minus: C13 | Format: 0.00 %}
{% elsif C12 == " " %}
 {% assign C14  = C12 | minus: C13  | times: -1| Format: 0.00 %}
{% endif %}

Does that look right?? so I am saying if C12 (GST on purchases) = Blank then...... if not then  out the times:-1 in

For Boolean conditions see
https://shopify.github.io/liquid/basics/truthy-and-falsy/
From which an empty or nil variable test false

When C12 in not a number, we can leave it out of the arithmetic (assuming that is why you are getting results you don’t agree with)

{% if C12 %}
 {% assign C14  = C12 | minus: C13  | times: -1| Format: 0.00 %}
{% else}
 {% assign C14  =  C13 | Format: 0.00 %}
{% endif %}

But it is probably easier just to copy the original C12 assignment to the C14 assignment ie

{% assign C14 = taxOnPurchases[GST_15] | plus: gstOnImports %}

As I think this is what you are doing

Report Original Edited
C5 GST_15 TotalSales +GST_0 sales + GST_exempt TotalSales Same
C6 GST_0 TotalSales + GST_Exempt TotalSales Same
C7 GST_15 TotalSales (or C5 - C6) Same
C8 GST_15 TaxOnSales Same
C10 GST_15 TaxOnSales (or C8) Same
C11 GST_15 TotalPurchases + (GST_15_on_imports Nett_GSTinclusive ie Purchase - sales) Same
C12 GST_15 TaxOnPurchases + (GST_15_on_imports Nett_GST ie PurchaseGST - SalesGST) GST_15 TaxOnPurchases
C13 - GST_15_on_imports Nett_GST ie PurchaseGST - SalesGST
C14 C12 GST_15 TaxOnPurchases + (GST_15_on_imports Nett_GST ie PurchaseGST - SalesGST)

First off I really really appreciate your help.
I am editing the report in notepad+++ so I can save it back as a jason file to use for all my clients.
this is what I have
“{% assign C11 = totalPurchases[GST_15] | plus: totalImports %}”,
“{% assign C12 = taxOnPurchases[GST_15] | default: 0.00Format: 0.00 %}”,
“{% assign C13 = GSTOnImports| default: 0.00Format: 0.00 %}”,
“{% if C12 %}”,
" {% assign C14 = C12 | minus: C13 | times: -1| Format: 0.00 %}",
“{% else}”,
“{% assign C14 = taxOnPurchases[GST_15] | plus: gstOnImports %}”,
“{% endif %}”,
],
It down loads into manager fine but when I run the report it does this


am using desktop lasest version 41
it also comes up with this on the 2nd try

I don’t believe you need to do this.
You can export the report transformation when you have it working (or prior as a backup), then they can import it.

I had a similar problem when editing the .json file with a text editor so avoid that now, and use the editor built into Manager instead.

I suspect the.json file looks like a text file but actually contains unprintable characters to delimit document structure. So using a text editor probably deletes the unprintable characters causes a parsing error when later trying to use it in Manager.

So you can I am sure that was not there when they first bought it out good will give it a try in manager
thank you will come back and let you know how I get on

I can not export the file I can not find where to export it

It was near the localisation import button. Will check later. Hopefully this feature has not been removed

But I now have it working thank you so much. Incase anyone else in NZ wants to know I edit it in manager I put
{% assign C11 = totalPurchases[GST_15] | plus: totalImports %}
{% assign C12 = taxOnPurchases[GST_15] | default: 0.00Format: 0.00 %}
{% assign C13 = GSTOnImports| default: 0.00Format: 0.00 %}
{% if C12 %}
{% assign C14 = taxOnPurchases[GST_15] | plus: gstOnImports %}
{% else%}
{% assign C14 = C13 Format: 0.00 %}
{% endif %}

No that just exports the list of localisations not the report its self

Now I some how have to change C11 because they way we put purchases bought overseas in to manager is from the over seas suppliers invoice we enter it as a purchases at 0% GST and then when the customs freight documentation comes in we enter that as a separate payment and the GST is on that and thats when we put the GST amount in @ 15% on imports. I now realise that it adds the purchases price on based off of the GST amount. I dont know why but purchase price not always the same as what the price paid from the supplier(ask customs who knows how the govt work lol) so I need to swap C11 total imports for something else. Thought I might try and make a special tax rate for the supplier and capture that so
when I enter an over seas supplier I use special rate and C11 picks it up.
If that makes sense
Ok to do that I need the field key and when you go batch up date and copy to excel it does not give you the custom Tax rates field key

  1. Open Manger

  2. Open a Manger window in your browser (so it shows the page address bar). How to do this varies with operating system. In windows right click on a link and choose open in a new window)

  3. Go to the tax code page in Manger in you business

  4. Edit the page address to add “.json” It needs to go at the right hand side but before the parameters (which results in it being towards the left hand side of the full string). Will post a picture later today.

  5. That should show all the tax code UUID. You should see the ones already in your localisation as well as any new ones you have created

  6. Add the new tax code to your localisation.

Actually I’m hoping to post a full guide later today

I have the desktop version so can not open in browser