29.30 - 6.153 = 23.147

23.147 may have been stored as 23.14 in the table
23.14 + 6.15 = 29.29 -> one possibility.

Now when preparing the report (dividing factor = 1.00 - 0.21):
23.14 / 0.79 = 29.2911 rounded off to 29.29 -> second possibility.

That is how the error comes in.

The fix should be in storing the properly rounded value in the table and in small value divisions these errors make it to the hundredths position and show up.

Anyone working in a bank that uses FA type accounting system can take all the less than 1 cent values into their account and make millions on billions of transactions!

The base amount of the purchase is 29.30

then the tax is 21.000% calculated via Import tax found on:

frontaccounting.com/fawiki/index.php?n=Main.TaxSystem

then the amounts are after using the import tax quick entry

Sub-total:    29.30
(%)    -6.15
(%)    6.15
Invoice Total:    29.30

Then I save the page.

Then I go to Tax report and it shows this:

Supplier Invoice 21 13/01/2013 - 29.29 21.00 6.15 BTW IC
Supplier Invoice 21 13/01/2013 -- 29.29 21.00 -6.15 BTW hoog

But the amount given was 29.30 not 29.29

Tax inquiry shows the same

Type    Description    Amount    Outputs/Inputs
BTW hoog 21%    Charged on sales (Output Tax):    11.87    56.53
BTW hoog 21%    Paid on purchases (Input Tax):    -6.15    -29.29
BTW hoog 21%    Net payable or collectible:    5.72   
BTW IC 21%    Charged on sales (Output Tax):    0.00    0.00
BTW IC 21%    Paid on purchases (Input Tax):    6.15    29.29
BTW IC 21%    Net payable or collectible:    6.15   
Total payable or refund:    11.87

When I watch Reports and Analysis > Balance Sheet

Account Account Name Open Balance Period Close Balance
Assets
HUIDIGE ACTIVA
1200 Debiteuren 0.00 68.40 68.40
Total HUIDIGE ACTIVA 0.00 68.40 68.40
Total Assets 0.00 68.40 68.40
Liabilities
HUIDIGE PASSIVA
2100 Crediteuren 0.00 29.30 29.30
2310 BTW hoog 0.00 5.72 5.72
2312 BTW IC 0.00 6.15 6.15
Total HUIDIGE PASSIVA 0.00 41.17 41.17
Total Liabilities 0.00 41.17 41.17
Calculated Return 0.00 27.23 27.23
Total Liabilities and Equities 0.00 68.40 68.40

Apache 2.4.3    Running
MySQL 5.5.27    Running
Php 5.4.10    Installed

But it is running php v5.3(5.4 is dual php version)

Also if I remember good I also have tried php v 5.4

TAX rate is 21%

I am adding the amount of €29.90 and using the function Import tax so with quick entry adding the tax to GL item.

In the invoice payment and bank it shows 29.90 and the right TAX, but when I go to General Ledger > Tax Inquiry it shows the right TAX amount but the invoice is now 29.29. So missing 1 cent.

If you need I can provide access to frontaccounting or other information.

Have tried different versions of frontaccounting but I can replicate the problem.

Thanks

But sorry I don't see the solution, I am not really familiar with php.

$net_amount = $amount/$tax['rate']*100;

What needs to be done is how the $dec is being used from the Page Preferences > Decimal Places > Prices/Amounts.

We have a big issue with TAX calculation.

I are using version Mercurial Build 3131

We have setup frontaccounting with Import TAX from the wiki.

But when we enter amount with the import tax with feature Quick Entry, the amounts are correctly showing.

But when I go to Banking and General Ledger > Tax Inquiry it shows not the same amount (29.30) but it shows 29.29 missing 1 cent.

Have found a temp fix, settings the Page Preferences > Decimal Places > Prices/Amounts: from 2 to 4 and do the same procedure adding a new invoice of amount 29.3000 now with more Decimals the amount is correct in Tax Inquiry.

So we have a problem with the tax calculation or rounding.

Hope someone have a good fix that we don't have to use the 4 decimals.

Thanks