@Wornout, your posts have been very helpful.
For anyone interested, the above fix works for lazy New Zealanders (like me) who have not differentiated between GST collected by NZ suppliers versus overseas suppliers. In recent years, some overseas suppliers have started collecting GST, so I have taken the easy route and just thrown those invoices into Line 11. Bad, bad, bad me.
I took this a bit further last night, after reading and grokking Wornout’s posts about imported goods. Technically, Wornout is correct that imported goods should NEVER be included in line 11, so I decided to bite the bullet and start doing it properly. This necessitated a new tax code, “GST 15% Imported”, which I use for purchases from overseas suppliers. Purchases with this code must be included in the adjustments in line 13. The following is the complete report transformation that I’m using now:
{% assign GST_0 = “1a88fd08-a595-4e12-97d3-85fc165eecdc” %}
{% assign GST_15 = “ee8cacde-58da-48ec-8aa9-aa6acba9c32f” %}
{% assign GST_15_on_Imports = “5c741c75-e192-49a6-b4c0-56b0633484a9” %}
{% assign GST_Exempt = “705acb55-550e-458a-bf9a-c4c7021dc351” %}
{% assign GST_Adjustment = “d865c9b1-17b9-488b-b29b-b15c0b3c3246” %}
{% assign period = transactions | between: report.From, report.To %}
{% assign C5 = period | taxcode: GST_15, GST_0, GST_Exempt | tax_inclusive_sales | reversesign %}
{% assign C6 = period | taxcode: GST_0, GST_Exempt | tax_exclusive_sales | reversesign %}
{% assign C7 = period | taxcode: GST_15 | tax_inclusive_sales | reversesign %}
{% assign C8 = period | taxcode: GST_15 | tax_on_sales | reversesign %}
{% assign C9 = period | taxcode: GST_Adjustment | tax_on_sales | reversesign %}
{% assign C10 = period | taxcode: GST_15, GST_Adjustment | tax_on_sales | reversesign %}
{% assign totalImports = period | taxcode: GST_15_on_Imports | tax_inclusive_purchases %}
{% assign gstOnImports = period | taxcode: GST_15_on_Imports | tax_on_purchases %}
{% assign totalAdjustments = period | taxcode: GST_Adjustment | tax_inclusive_purchases %}
{% assign C11 = period | taxcode: GST_15 | tax_inclusive_purchases %}
{% assign C12 = period | taxcode: GST_15 | tax_on_purchases %}
{% assign C13 = period | taxcode: GST_Adjustment, GST_15_on_Imports | tax_on_purchases %}
{% assign C14 = period | taxcode: GST_15, GST_Adjustment, GST_15_on_Imports | tax_on_purchases %}
{% assign C15 = period | taxcode: GST_15, GST_Adjustment, GST_15_on_Imports | tax_amount %}
{% assign total = C15 | balance %}
The first five lines have UUIDs that will vary from user to user. Follow this post to find your UUIDs. (Be aware that you must manually type each UUID into the Liquid editor, as copying and pasting didn’t work for me!)
The table has not changed at all, although I added a few lines so I can view the imported goods and other adjustments separately:
I’m still trying to figure out how to hide the appropriate duplicate line 15. Something is happening with the Liquid editor, and I’m having trouble with this part. It might need to be manually edited somehow. Anyone have any insights?