How can we improve WHMCS?

Share, discuss and vote for what you would like to see added to WHMCS

  1. Home
  2. Ideas
  3. Payments/Billing
  4. Rounding Invoice Total Due Amount to the Nearest Decimal

Rounding Invoice Total Due Amount to the Nearest Decimal

  • Daisuke Nagakawa shared this idea 7 years ago
  • Payments/Billing
  • 9 Comments


7 Votes
Login to Vote
We are using WHMCS in Japan, a country which the currency does not have decimal points (eg. USD8.99 vs. JPY899).
Generally sales tax is 8%, but with some certain numbers when we calculate the tax in, it results in decimals (eg. JPY660+tax is technically JPY712.8). What we want to do then is we round the decimal down and make it JPY712 (or round up and make it JPY713), since there is no such thing as a "cents (0.01)" in Japanese yen. WHMCS appears to not do so, and it attempts to charge clients for a technically impossible amount.
Currently we take care of this error manually, but I think it would be nice if WHMCS could add a function to round the final total amount due of an order round up or down to a certain level. This would take care of our tax issues, and I can see this potentially being useful for other purposes as well.
Thanks!

9 Comments

Login to post a comment.

Swehoster commented 19th September 19
If I try this in Sweden where we use 1234,56 it doesn't work.
If a client have a total of 12345 the invoice will show 1,2345.
In Sweden that say the cos is 1 SEK and 2345 ore.
In Euro, 1 EUR and 2345 EUR Cent.
Remove the "Already possible" flag since it is not, it might work in some countries but far from all.
Swehoster commented 19th September 19
We are in the same situation.
We would like to have this feature as well.
If the amount is 9,50 the result is 9 and above would be 10.
Is there a plan for this feature yet?
kobuki commented 1st February 18
I run into other problems with invoicing which I detailed to support recently. They recognized the problem and have issued a core bug ticket. That will most probably address all the rounding issues. At least I hope so.

John, sorry for my previous comment, I realized that the currency display format can be changed individually. However it doesn't help since it's for display only and fractional amounts calculated by eg. VAT continue to accumulate and cause payment problems, too.
kobuki commented 25th September 17
That's not a solution. At the same time you can's support other currencies that way where meaningful fractions are used.
Official Response
WHMCS commented 25th September 17
Hi,

This can be achieved by selecting the appropriate currency format. Please select the "1,234" currency format under Setup > Payments > Currencies > Edit.

This will round amounts in that currency to the nearest integer.
kobuki commented 10th September 17
We have the same problem in Hungary. No fractional currency for HUF.
It's required by law to round all prices on an invoice's final net,
gross sum and tax amt. to a whole number. We're considering adding a
billing hook to fix prices to address this issue but it would really be
the job for a WHMCS option.
deepaksakhrani commented 5th July 17
Hello,

We have the same issue with tax rounding off. Section 170 of GST –INDIA requires the tax amount to be rounded off to nearest .0 decimal value.

Please do the needful soon and confirm.

Thank you!
deepaksakhrani commented 4th July 17
We have tax issues with decimal points and must have full amount without decimal points. Can rounded up of tax amount with this to nearest. ..00

Thank you!
Nathan Hilton commented 4th August 16
While I see your point in this about the YEN having no decimal points, how would they keep the support for other currencies, GBP, EUR, CAD, USD, AUD etc. This is a lot more complicated in producing than you think.