Quick Jump Menu
Advanced Search Search the Knowledgebase
Rounding and Tax Invoice Layouts
Author: Michael Cho Reference Number: AA-05432 Views: 28469 Created: 2015-04-29 14:23 Last Updated: 2015-05-07 13:46 100 Rating/ 1 Voters

There has been many inquiries with regards to GST and rounding, its impact on invoices. Sage would like to share our information to clarify these queries.

Why does rounding exists?

The GST rate is Malaysia is currently 6% and the pricing of goods and services in principle can take any form or price dictated by the supplier. In the instance that the price is a number that does not multiply into a perfect number with 2 decimal places, it will need to be rounded as we do not trade beyond 2 decimal places in the Malaysian currency. Take this example.

Unit price of item A is RM 2.05 inclusive of GST and 3 units are sold. Therefore the calculated amount would be 

  • RM 2.05 X 3 = RM 6.15
  • GST (inclusive) would then be 6/106 X 6.15 = 0.369 which is then rounded to 0.37, 2 decimal places. 
  • The breakdown would then be Net Price (without GST) of RM 5,78 and GST charged of RM 0.37

What is a total?

The total in an invoice is a simple summation of identified values, no more, no less and definitely not any scientific rounding theories that many are trying to convince software users. 1 + 1 =2, that is the function of a total field.

Due to the fact of the simplicity it cannot be used as a definite benchmark for correctness. The following factors will support this conclusion in a practical scenario.

  1. Not all products may be subjected to the same GST treatment or percentage, Therefore applying a simple treatment i.e. 6% on a total will not yield the expected results.
  2. They may be differences in rounding. Therefore trying to calculate a definite 6% on a total will also not yield necessary the correct results as the calculation is done per line.

Therefore, our conclusion, keep the total a simple function as it has always been, a sum of selected values. For example, total of discounts, total of net price and of course total of tax payable.

How does Sage handle GST and rounding?

In reviewing the requirement from JKDM, any calculation or record should be as detailed as possible to aim for correctness and accuracy. Therefore in Sage products, we handle the GST calculation by detailed lines, this is in alignment with the GST Audit File (GAF) which is detailed by line. It may be a line of item in the invoice or a line in your receipt. 

The question will definitely arise, why in the detailed line? The key reason is that the particular transaction line should be able to stand by itself and be correct, and not adjusted because it is part of a total invoice. What happens if subsequently other items are removed or recalculated? Thence it will deem the current line inaccurate.

Refer to the example below. 

Is the correct GST amount 2.36 or 2.37? Let's look at another example.

This example further illustrates our position. Once there is a mixed supply or treatment, (standard and zero rated) the total is not reliable for simplistic analysis. (52.44 X 6% is not equal to 2.37) However, we should still remember the simple fact, a total is just a summation.

Therefore the correct answer to the 1st invoice is RM 2.37

Why are there errors in my Sage printout of invoices?

When GST was first rolled out there were 2 conditions that we faced with users of our products.

  1. They were using the standard layouts for invoices etc. from Sage products.
  2. They were using personalized layouts for invoices etc. that were created prior or even post GST. 

The result  of this was confusion and uncertainty as some of the layouts did not cater fully to the varied implementations and there was little understanding on the rounding impact. Sage acknowledges this and has quickly rendered further assistance to the users.

There is no possible way for Sage to address all the personalized layouts in the market, as there are thousands upon thousand of them, however we have in our effort offered for the market 2 choices.

  1. We have opened up and made available the layout/report designer to the users and provided some simple tutorial for the users to modify the layout on their own. Whilst this can become a bit technical, the user has the choice to manage the situation themselves and be empowered in the process.
  2. We have updated and increased the number of available layouts in our products with each progressive release. The total of available layout now numbers well above 20 types, for users to choose from. However, it has to be practical that we are not able to cater for every specific need. We try to achieve the best balance between practical usage and customer demand while providing the facilities for users to further explore and modify if they want to.

Please look out for the latest releases and the layouts that meet your requirements, and if they don't, create your own style and requirements. 

Bank Negara Rounding

This rounding mechanism suggests that the total bill (including GST) be rounded upwards or downwards to the nearest multiple of 5 sen. The illustration of this is as follow.

  • Amounts ending with 1,2 will round down.
  • Amounts ending with 6,7 will round down.
  • Amounts ending with 3, 4 will round up.
  • Amounts ending with 8,9 will round up.

This is usually applied in retail situations where cash (legal tender) is used. This setting can be enabled in the settings of Sage products. 

Contribution from Ng Wan Hua

Rss Comments 12
  • [chee]: GST invoice amount rounding (version 2015-06-16 14:27 #

    sales invoice total should be [email protected]=RM1,308.74, but totally different in preview before posting dr.RM1,308.75 & cr.RM1,308.76. i have tried press data recovery, my invoice will become [email protected]=RM1,461.30 & preview before posting dr & cr also wrong amount RM1,308.76, dono how ubs get the amount!!! how i post to accounting? please revert, tq

  • [Li Zhen Yap]: Re: GST invoice amount rounding (version 2015-06-16 15:20#

    Dear Chee,

    Thank you for your enquiry.

    Could you provide us print screen below:
    1. Sales Invoice
    2. Preview Before Posting

    You may attach the print screen by replying the email we have sent to you.

  • [ ms teo]: WHAT TO DO IF DIFFERENT OF AMOUNT GST 6% TAX 2015-06-08 11:48 #


  • [Li Zhen Yap]: Re: WHAT TO DO IF DIFFERENT OF AMOUNT GST 6% TAX 2015-06-09 18:00#

    Dear Ms Teo,

    Thank you for your enquiry.

    Kindly do provide information below:

    1. Which version are you using currently?
    2. Print screen on the supplier invoice that having this matter
    3. Print screen on the transaction setting.
    (Print screen can be provided by replying to the email we have sent to you.)

  • [ Chan]: GST Rounding 2015-06-04 09:44 #

    Why the GST charge in body different with GST in footer?
    Assuming sold one item at RM481.92 with GST RM28.91 in body but in footer, GST = RM28.92. The GST summary shown RM28.91.

    It appear is not in line with the illustration above. Please advise.

  • [Li Zhen Yap]: Re: GST Rounding 2015-06-04 10:19#

    Dear Chan,

    Thank you for your enquiry.

    Kindly do provide the information below:

    1. Which version are you using currently?
    2. What is your setting for transaction? (Provide Print needed)
    3. Invoice reference (Print screen needed)

    You may attach all the details by replying to the email we have sent to you.

  • [ kkkoh]: Tax Invoice Rounding 2015-05-22 11:56 #

    Feedback received Print Screen Rquired. Do not really understand how to go about it. Would it be possible to call me at Tel: 03-79839568 as I could not get to talk to your support as there was no answer. Regards

  • [Li Zhen Yap]: Re: Tax Invoice Rounding 2015-05-22 12:16#

    Dear Kkkoh,

    Thank you for the contact provided.

    As spoken, we look forward to receive your email.

  • [ kkkoh]: Tax Invoice Rounding 2015-05-22 11:04 #

    Yes, my Tax Invoice amount must be the same as PO amount and my customer needs me to have the Tax Invoice amount to be adjusted similar to their PO amount inorder to make payment. Please advise how do I adjust.
    If I am able to round my Tax Invoice amount (so far the difference is a matter of sen) then it would be solved. Regards

  • [Li Zhen Yap]: Re: Tax Invoice Rounding 2015-05-22 11:39#

    Dear Kkkkh,

    Could you provide the print screen on your Billing > Housekeeping > Run Setup > General Setup > Transaction Tab?

    Kindly do check your email and attach the print screen via email.

    Thank you.

  • [ kkkoh]: GST Inv Amount Rounding 2015-05-22 09:35 #

    How do I round up or bring down my Inv Amount when it differs from my Customer Purchase Order amount?
    No respond from Sage Support. It went through one time but when I posted the question I was asked to hold on but support personnel didn't come back to me. Your urgent reply is needed as I need to revert to my customer on the issue. Thks.

  • [Li Zhen Yap]: Re: GST Inv Amount Rounding 2015-05-22 10:50#

    Dear Kkkoh,

    Thank you for your feedback.

    Do you mean you have to follow your customer pricing/quotation?

    Or your question is Supplier Invoice?

Info Add Comment
Nickname: Your Email: Subject: Comment:
Enter the code below: