Topic: Tax problem for implement FrontAccounting in my country
Hi
I am new in FrontAccounting and I am try to implement this system in my country
We have the tax requirements for sales in this way here
For sales we have two tax
IVA = 13%
IT = 3%
I have created in setup for taxes, an group called "Imp S/sales" that include this two taxes
Also I have created in setup "Item Tax Types" one type called "regular" which is not tax exempt, this type is set for all items in the inventory (the field "Item Tax Type:" is set to "regular")
Also a have created "in Sales>sale types" an type called "Incluye IT e IVA" (for IVA and IT are include) this have the "Tax included:" cheched
In "Sales>Add and Manage Customers" for all customers the field "Sales Type/Price List:" is set to "Incluye IT e IVA"
in "Sales>Customer Branches" associated for the customers the field "Tax Group:" is set to "Imp S/sales"
the problem is that when I am filling an Direct Invoice in "Sales>Direct Invoice"
after the select an customer and select the items for sale I have wrong values for the taxes showing
For example
For an Item called "Mensualidad Gastronomia" this has the price in 100, as the tax is included the detail of the tax sale should be as follows
(This is the rigth result)
Description item Quantity Price with tax included? Total
-------------------------------------------------------------------------------------------------------
Mensualidad Gastronomia 1 100.00 100.00
Sub-total 100.00
Included IT (3%) 3.00
Included IVA (13%) 13.00
Importe Total 100.00
But FrontAccounting is doin other things like this
Description item Quantity Price with tax included? Total
-------------------------------------------------------------------------------------------------------
Mensualidad Gastronomia 1 100.00 100.00
Sub-total 100.00
Included IT (3%) 2.59
Included IVA (13%) 11.21
Importe Total 100.00
Also the "Journal Entries for this Invoice" is generating this wrong results for my balance
The system is generating this WRONG results in the Journal entries
Account Name of Account Dimensión Debit Credit
--------------------------------------------------------------------------------------------------------
4.1.01.01.001 Mensualidades Gastronomia 86.20
1.1.02.01.1000 client CXC 100.00
2.1.01.04.002 IT (3%) 2.59
2.1.01.04.003 IVA (13%) 11.21
---------------------------------------------------------------------------------------------------------
Total 100.00 100.00
I need this results in the Journal entries (this is the right for me accounting)
Account Name of Account Dimensión Debit Credit
--------------------------------------------------------------------------------------------------------
4.1.01.01.001 Mensualidades Gastronomia 84.00
1.1.02.01.1000 client CXC 100.00
2.1.01.04.002 IT (3%) 3.00
2.1.01.04.003 IVA (13%) 13.00
---------------------------------------------------------------------------------------------------------
Total 100.00 100.00
Please this is urgent to resolve, what is bad in my configuration?