Full & Simplified Tax Invoice: Explanation on changes made and Data binding guide

Introduction

The following post discusses about the changes made to the AutoCount Tax Invoices in version 1.8.12 as well as giving a simple data binding guide to help you customize your own Invoice template to show the correct figures in them.

Previously…

In the previous AutoCount Accounting version, the Tax Invoices template that was shipped together had use the inclusive/exclusive tax to differentiate how the report would show it’s tax information in the footer section. This can be seen as when the tax used for the document is exclusive, the footer would show something like below:

Sub Total (Excluding GST)	250.00
GST payable @ 6% on 250.00	15.00
Total (Inclusive of GST)	265.00

Whereas if the document was using inclusive tax, the footer would show something like this:

Total Sales inclusive of GST @ 6%

250.00

This approach on generating the report was unfortunately inaccurate as feedback from customers as well as research and fact checking with the RMCD (Royal Malaysian Customs Department) indicate that the different footers are not caused by inclusive or exclusive tax but an all together different concept.

Now…

In version 1.8.12, the Tax Invoice template has been split into 2 version, the first being Full Tax Invoice while the second would be Simplified Tax Invoice. The split is done because the each invoice actually use the different footer concept in them. For the Full Tax Invoice, the footer uses the full information footer similar to the previously exclusive tax footer format, whereas the Simplified Tax Invoice uses the inclusive tax footer format. For a more clearer picture, please have a look of the images below:

The new Full Tax Invoice

The new Simplified Tax Invoice

Now a user might ask, how about inclusive/exclusive tax? Would it change the format? The answer is surprisingly no actually. You may still use the Full or Simplified Tax Invoice to show both exclusive and inclusive tax because at its core, RMCD only cares about the information presented in the footer area. However, the recipient of the invoice might have issues on the figures shown for each item due to how inclusive and exclusive are calculated on the total of each item. As such to avoid this particular issue, AutoCount also provides an Inclusive template for both Full and Simplified Tax Invoice. The difference between using the normal template and the Inclusive template can be seen below:

In the left hand side, the normal template and in the right hand side, the Inclusive template

The left hand side is the Exclusive template and the right hand side is the Inclusive template

As you can see, in the Full Tax Invoice, an extra column is added in the Inclusive template to allow the recipient to see the total inclusive and that the previously Total column in the normal template is renamed to Total(ex) to show that this is the price of the item excluding the tax amount. This way no confusion can exist for the recipient of this invoice on how much the figure was derived from. You may also notice that without the extra column, both reports are actually identical when previewing an Inclusive tax invoice document. Again it is similar for the Simplified Tax Invoice, only the other way around. The Exclusive template will show the extra column to show the Exclusive figure but the figures are the same for both documents when previewing the same Inclusive tax invoice document.

Data Binding

For users or dealers that do their own report design modification to fit their own needs the following table shows what fields AutoCount use to bind the detail data for the relevant tax fields.

Elements in the report	Data binding used
Total (inc)	SG_SubTotalWithTax
Total (ex)	SG_SubTotalExTax
+ Sub Total (Excluding GST)	TotalExTax
+ GST payable @ 6%	Tax
+ Total (Inclusive of GST)	NetTotal
+ Rounding Adj. *	RoundAdj
+ Final Total *	FinalTotal

⁺: Footer fields
^*: if applicable, check scripts inside the system template on how to hide if not using