AutoCount Accounting Report Designer: Converting Invoice into Tax Invoice

Home » GST » AutoCount Accounting Report Designer: Converting Invoice into Tax Invoice
GST, Report Designer No Comments

This post will guide on how to convert an Invoice into Tax Invoice format, a format which is required if the company is a GST registered company.

 

There are some requirements for a Tax Invoice:

1. The word “Tax Invoice” should appear

2. Tax Invoice serial number / document number

3. The date of issuance of the Tax Invoice

4. Name, address and GST ID of the supplier

5. Name and address where the goods and services are supply to

6. Sufficient description to understand the goods and services supplied

7. For each description, differentiate the type of supply (Standard Rate, Zero Rate, Exempt Rate), quantity of goods or the extent of the services supplied and the amount payable

8. Any discount provided

9, Total amount payable excluding tax, rate of tax, and the total tax to be shown seperately

10. The total amount payable inclusive of total tax chargeable

11. Any amount that is in foreign currency should also be displayed with local currency (MYR) for 9 and 10

 

Step by Step Guide

 

1. Change the Invoice wording into Tax Invoice.

 

1

Select the Invoice label and look for the properties “Text”, change the INVOICE to TAX INVOICE.

 

2. Tax Invoice Serial Number / Document Number.

 

For this we do not have to do anything as the the older version of Invoice should already had this information shown out in the report / printout.

document number

Binding Field Name: Document No.

 

3. The date of issuance of the Tax Invoice.

 

For this we do not have to do anything as well as the older version of Invoice should already had this information shown out in the report / printout.

document number

Binding Field Name: Document Date

 

4. Name, address and GST ID of the supplier.

 

For this, after you had keyed in your GST ID in your Company Profile, please take an extra step to set the the Default Report Header so that the newly added GST ID would appear in every Letter head (Invoice).

2

For those that use pre-printed form, make sure your pre-printed format contain these information too.

 

5. Name and address where the goods and services are supply to.

 

For this we do not have to do anything as well unless it is being removed. You may check whether these information is still at the header of the Tax Invoice or not

3

Binding Field Name:

Debtor Name: Debtor Name in Document

Address: Invoice Address1, Invoice Address2, Invoice Address3, Invoice Address4

 

6. Sufficient description to understand the goods and services supplied.

 

For this users will need to aware about their Item Description or Service Description so that it is easy to be understand by others (especially your customer and RMCD)

4

 

5

Description that is easy to understand

Binding Field Name: Description

 

7. For each description, differentiate the type of supply (Standard Rate, Zero Rate, Exempt Rate), quantity of goods or the extent of the services supplied and the amount payable.

 

You will need to add 2 labels, one for the Tax Code header and one at the Detail Band to bind to the Tax Code Data. Also you will need to change the binding of the Total, it should be EXCLUDING TAX TOTAL

6

Binding Field Name:

Tax Code: IRASTaxCode

Qty: Quantity

Total: SG_SubTotalExTax or SubTotal exclude Tax

 

8. Any discount provided.

 

7

Binding Field Name: Discount

 

9. Total amount payable excluding tax, rate of tax, and the total tax to be shown separately.

 

8

Create a label Subtotal (Exclude GST), then another label to bind total excluding GST

Binding Field Name: Total Exclude Tax

 

9

Create 1 label, bind to GST Payable

Binding Field Name: GSTPayableDescription

 

10

Create 1 label, bind to Tax Amount

Binding Field Name: Tax Amount

 

Also you will need to add a GST Summary table at the footer to show this Invoice respective Tax Item Amount and the amount of Tax Chargeable. In order to do this, look at the top menu bar, click Edit –> Insert GST Control

gstsummary1.

It will be added to your header and you will need to move it to the footer

 

gstsummary

Sample image of the GST Summary Table

 

*This function will also add a label bind to IRASTaxCode in the detail band, if you had added this in step 7, you can just remove this label.

 

10. The total amount payable inclusive of total tax chargeable.

 

This field by default should be there already unless removed

11

Binding Field Name: Item Amount + Tax

 

These are all the steps that you will need to follow and check if one would like to convert their current Invoice format into Tax Invoice.

 

Happy Accounting !!!