Brazilian Users and Taxes

[Henrique Arake]

Derek Atkins <warlord <at> MIT.EDU> writes:

> 
> Hi,
> 
> You want to use the "TaxIncluded" marker in the invoice (on each taxable
> line-item). This will tell gnucash that the tax is included in the item's
value
> instead of added on top of the item's value.
> 
> -derek
> 
> Quoting Igor Morgado <igor <at> gnutech.com.br>:
> 
> > Hi all gnucash users.
> > 
> > I want to know if there is some brazilians that use gnucash to business
> > account management.
> > 
> > There is some weird things in brazilian taxes that isn't supported by
> > gnucash (or I don't know how to do it).
> > 
> > 
> > Example: 
> > 1. I create a customer (Foo Bla)
> > 2. I create a project for customer (Linux System Service)
> > 3. I made a Invoice (1000 $ )
> > 
> > BUT some brazilian taxes goes in invoice but the customer pay them (not
> > me). The taxes didn't increat the value to recieve, they're are RECUCED.
> > 
> > There is 4 taxes here: IRRF, PIS, COFINS, CS
> > 	IRRF = 1,5% 
> > 	PIS = 1%
> > 	COFINS = 3,0%
> > 	CS = 0,65%
> > 
> > then... When I sent the invoice I dont recieve 1000$ PLUS 6,15%
> > I recieve 1000 MINUS 6,15%
> > 
> > 61,50 to be more exact
> > 
> > There is a way to do it in gnucash?
> > 
> > I cant use negative values to get inverted taxes
> > 
> > There is some brazilian experienced with gnucash? Someone can send me
> > some tips?
> > 
> > Tkz in advance
> > 
> 

Hello everybody!

That doesn't work. The thing is that our tax system is... complicated.

First of all, gnucash uses the following formula to compute the included taxes:

subtotal = total/(1+taxrate).

But, in our case, it should be subtotal = total/(1-taxrate).

What I did was this. My firm is taxed with a 11,33% rate. So, if a charge R$
1.000,00 for a service, this will be considered as the gross value charged
from my client.

So, X = grossvalue - grossvalue*taxrate

subtotal = 1000 - 1000*0,1133 = 886,7

Then, as X=subtotal, in gnucash it becomes:

X= total/(1+taxrate)
886,7=1000/(1+taxrate)
taxrate=12,77.

The amount is QUITE the same. Apparently, there's some rounding issue. After
all that, I make the proper adjusts so the total amount of the taxes are
correctly distributed.

We, also, have a rule that says that, in some cases, the client should
retain part of the taxes owed by the seller, but we can adjust this manually.