VAT rounding error with 3-decimal-place currency

VAT calculated wrongly and related transactions for Payments, here is only one example.
Proof as below - Payment VAT BD: 0.005

Why V AT amount is showing BHD 0.010 fils - This is calculation error . We have several similar issues in Cash and Bank.


Note: Our customer is not accepting the differences and asking to get solution.

Also we checked the Regional Settings for 3 decimal places for Bahraini Dinars as suspected due to the 2 decimals by default.

This is an important matter during audit so kindly advice solution ASAP.

Your screen shots do not provide enough information to tell what’s going on because:

  • you do not describe what they show, and
  • you do not include the headings and bread crumbs at the top.

It is not even possible to tell if the payment in your first screen shot is actually the transaction you have highlighted in the second screen shot.

You also have another problem. Assuming your last two screen shots are showing your VAT liability account, payments and purchase invoices should result in debits. But receipts should result in credits. Instead, everything is a debit.

@Tutu thanks for the reply, it quite evident that Manager having a bug and must be solved as it’s losing credibility for been a good software.

All VAT related to payments or purchases hence Debit. nothing for here as receipt or sales, therefore no Credit.

What else you need to see this issue?

@lubos kindly fix this bug in the next release as we are losing customer’s trust.

Then why are some of your transactions listed as payments and others as receipts?

Explain what your screenshots show, and let us see the headings and bread crumbs (the path to the current transaction as shown by the links at the top of the page) as @Tut suggested. We need to know what we’re looking at. For each transaction you use as an example, show the edit screen including dates and reference numbers so it’s easy for us to identify that transaction in your other screenshots.

How has your “VAT Control Account” been set up? Is “VAT 5%” a built-in or custom tax code? Let us see the edit screen for that.

1 Like

Here are the info:

Let us know if any further info required…

Thank you. I see the discrepancy with payment # 352, but also note that you still have payments and receipts showing up as debits. As @Tut said, the receipts should appear as credits. So there seems to be more going on than we can see.

As a start, could you provide screenshots of the following, please:

  1. The edit screen for payment # 352.
  2. Create a test receipt similar to payment # 352, and show us the edit screen for that.
  3. Show us the VAT Control Account summary page as you have above but including the test receipt you created in 2. above.

@GrahamvdR appreciate your comments, yes agreed with @Tut that about the credit since it was only to test and been performed on the Test Database only.

  1. The edit screen for payment # 352.

  2. Create a test receipt similar to payment # 352, and show us the edit screen for that.


  3. Show us the VAT Control Account summary page as you have above but including the test receipt you created in 2. above.

Kindly check and advice.

Thank you @danowagroup. I have tried setting up a test business and performing the same actions, and I get the same results.

Changing the unit price to 1.000 BHD gives the correct VAT of 0.050 BHD. Changing the currency to US Dollars and entering a unit price of 0.10 USD gives VAT of 0.01 USD, which I suppose is what we would expect as a result of rounding to the nearest cent. However, it looks to me like the same rounding is happening with BHD and you’re getting the VAT calculated to two decimal places instead of three. So to me it looks like it is indeed a bug. You’ll need one of the forum moderators to verify and categorise it as a bug, and hopefully it’ll be fixed in a future update.

Many thanks @GrahamvdR for your great support, indeed it’s a bug and must be fixed soon as it’s upsetting the customers and creating issues for the trust we had created here.

@Tut @lubos over to you guys now!

Any updates please?

Any updates will be posted in this thread, and the bugs categorization will be removed when fixed.

Thanks for the feedback @Tut

All users using BHD suffering due to this bug

@lubos kindly rectify this in the up coming version.

Fixed in the latest version (19.12.20)

Great thank you @lubos