# Correct GST return **URL:** \ **Category:** Uncategorized\ **Created:** [August 11, 2019, 5:44am UTC](https://forum.manager.io/t/correct-gst-return/23613 "2019-08-11T05:44:38Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [August 11, 2019, 5:44am UTC](https://forum.manager.io/t/correct-gst-return/23613/1 "2019-08-11T05:44:38Z")
Please @lubos can you fix the NZ GST returns the import amount goes into box 13(purchases credits) ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [August 11, 2019, 7:56am UTC](https://forum.manager.io/t/correct-gst-return/23613/2 "2019-08-11T07:56:04Z")
So looking at the [NZ GST return localisation](https://www.manager.io/localizations/nz/) in Managers Settings → Report transformations You are happy with the calculation section ![NZ%20calculation](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/b/3/b3746717dbb121d1a0cb8c0c80d9fb6f0216ffa3.jpeg) But want the gstInImports variable shown somewhere. 13 label is “Any credit adjustments” which in not very intuitive. ![NZ%20display](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/e/7ef31badec302dd7e3667f3071e03543c0f9af06.jpeg) You can just type that in if that is what you want ![NZ%20edit](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/4/e43af7f8adcb0716bb6b1b43448706f3c61e4833.jpeg) ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [August 11, 2019, 7:04pm UTC](https://forum.manager.io/t/correct-gst-return/23613/3 "2019-08-11T19:04:34Z")
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 ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [August 12, 2019, 11:58am UTC](https://forum.manager.io/t/correct-gst-return/23613/4 "2019-08-12T11:58:55Z")
> [@Wornout](#): > > I have tried to change it but I can not seem to get the correct amount for refund/pay with all variables 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 ![NZ%20debug](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/8/38ae8ed5bc5c84d9094ce66f0c631ff184b6bb54.jpeg) Note extra cells can easily be added by a mouse menu shown from the left grid numbers. ![NZ%20menu](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/4/94781aa9f43e08ce2c5b9dcf7e2fb881f5840eac.jpeg) 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. ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [August 12, 2019, 7:49pm UTC](https://forum.manager.io/t/correct-gst-return/23613/5 "2019-08-12T19:49:54Z")
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 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/c/a/ca6844ce5cc9f243672d90f49c3adadb5ccd1a17.png) and runs like this ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/4/1/41c34ac232bbc3f93608931aac36c780dbdb3ad5.png) but if I dont have any import GST it comes out like this ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/0/309c30056caabbc3c4a84e5ef982edb6514745b0.png) 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 ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [August 12, 2019, 10:40pm UTC](https://forum.manager.io/t/correct-gst-return/23613/6 "2019-08-12T22:40:33Z")
> [@Wornout](#): > > {% assign C14 = C12 | minus: C13 |times: -1 | Format: 0.00 %} 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. ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [August 13, 2019, 3:15am UTC](https://forum.manager.io/t/correct-gst-return/23613/7 "2019-08-13T03:15:57Z")
correct but I dont know how to write an if statement in HTML? ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [August 13, 2019, 5:26am UTC](https://forum.manager.io/t/correct-gst-return/23613/8 "2019-08-13T05:26:03Z")
It’s in liquid [Control flow – Liquid template language](https://shopify.github.io/liquid/tags/control-flow/) ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [August 13, 2019, 5:45am UTC](https://forum.manager.io/t/correct-gst-return/23613/9 "2019-08-13T05:45:37Z")
I am a dummy thats what I meant .And yes I have that site booked marked to. Just not sure how to use it ```auto {% 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 ``` ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [August 13, 2019, 6:00am UTC](https://forum.manager.io/t/correct-gst-return/23613/10 "2019-08-13T06:00:54Z")
For Boolean conditions see [Truthy and falsy – Liquid template language](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) ```auto {% 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 ```auto {% 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) | ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [August 13, 2019, 6:25pm UTC](https://forum.manager.io/t/correct-gst-return/23613/11 "2019-08-13T18:25:49Z")
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 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/8/78a23c5496b4fa232b0510846a1ba13429972125.png) am using desktop lasest version 41 it also comes up with this on the 2nd try ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/0/7072d75e1fe37d77473bdbc4b7cef5698461d5bf.png) ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [August 13, 2019, 9:14pm UTC](https://forum.manager.io/t/correct-gst-return/23613/12 "2019-08-13T21:14:40Z")
> [@Wornout](#): > > 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. 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. > [@Wornout](#): > > It down loads into manager fine but when I run the report it does this 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. ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [August 14, 2019, 12:42am UTC](https://forum.manager.io/t/correct-gst-return/23613/13 "2019-08-14T00:42:33Z")
> [@Patch](#): > > 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 i 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 ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [August 14, 2019, 1:07am UTC](https://forum.manager.io/t/correct-gst-return/23613/14 "2019-08-14T01:07:35Z")
> [@Wornout](#): > > 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 i I can not export the file I can not find where to export it ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [August 14, 2019, 1:17am UTC](https://forum.manager.io/t/correct-gst-return/23613/15 "2019-08-14T01:17:21Z")
It was near the localisation import button. Will check later. Hopefully this feature has not been removed ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [August 14, 2019, 1:17am UTC](https://forum.manager.io/t/correct-gst-return/23613/16 "2019-08-14T01:17:41Z")
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 %} ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [August 14, 2019, 1:18am UTC](https://forum.manager.io/t/correct-gst-return/23613/17 "2019-08-14T01:18:36Z")
> [@Patch](#): > > It was near the localisation import button. Will check later. Hopefully this feature has not been removed No that just exports the list of localisations not the report its self ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [August 14, 2019, 1:57am UTC](https://forum.manager.io/t/correct-gst-return/23613/18 "2019-08-14T01:57:55Z")
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 ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [August 14, 2019, 3:30am UTC](https://forum.manager.io/t/correct-gst-return/23613/19 "2019-08-14T03:30:41Z")
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 ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [August 14, 2019, 11:15pm UTC](https://forum.manager.io/t/correct-gst-return/23613/20 "2019-08-14T23:15:06Z")
I have the desktop version so can not open in browser [Next page](https://forum.manager.io/t/correct-gst-return/23613.md?page=2)