Feature Requests
Share ideas, discuss and vote on requests from other users in community
 

Rounding Invoice Total Due Amount to the Nearest Decimal

Daisuke Nagakawa shared this idea 2 years ago
Already Possible

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!

Comments (7)

photo
1

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.

photo
1

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!

photo
1

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!

photo
1

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.

photo
1

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.

photo
1

That's not a solution. At the same time you can's support other currencies that way where meaningful fractions are used.

photo
1

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.