Now how about tax tables

[Derek Atkins]

Quoting Nancy Brose <InnerStrengthPilates at comcast.net>:

> Derek Atkins wrote:
>
> Um, I'd need to see your tax tables to see what it's doing.
>
> Sorry I can't do that I deleted them both and set up a whole new tax 
> table.  Thats why I couldn't believe that the new invoice still used 
> the old, deleted tax tables when calculating the tax for items billed 
> on dates prior to the deletion.  Before I deleted them I had two tax 
> tables, both with only one entry, one was for merchandise and the 
> other was for service, the difference between percent tax was minimal 
> so...  Now I only have one table.  From what I could tell the two tax 
> tables were both being applied when I only chose one of them.  Either 
> that or something else was happening to double the tax when it was 
> applied.  I don't know if that is enough information for you.

Well, when you unpost an invoice you should have the choice of whether
to keep the existing tax tables or reset them.  (Maybe that's only in
1.9?)  i think in 1.8 it does keep the old tax tables..  But you could
unpost and then choose new ones.

I can't imagine how gnucash is applying multiple tax tables at once.
I'd certainly like to see a case where that's the case if you can
reproduce it.  The invoice should only post a single tax table.  I
highly doubt that both tax tables were applied...   Very hard to tell.

> Gnucash applies ALL taxes in a particular tax table,
>
> Yes, that I knew when setting up the tables, thats why I thought it 
> would be OK to have more than one table to choose from.

It should definitely be okay to have more than one table to choose from.
I've tested this numerous times, and it always has done the right thing.

> and yes, it combines all taxes destined for a particular witholding 
> account into a single
> Split.
>
> Hmm, I don't understand what that means.  Splits still confuse me.

A split is a part of a transaction.  A standard balanced transaction
has at least two splits.   A split has an account, an amount (in the
account commodity), and a value (in the transaction currency).   The
sum of all split values in a transaction equals 0.   I suggest reading
the gnucash concepts guide.

> Nancy

-derek

>
>
>> Quoting Brose Nunan <kayakpeople at comcast.net>:
>>
>>> I set up two tax rates listed in my tax table, thinking I could 
>>> chose whichever was appropriate for my transaction when invoicing. 
>>> Upon reviewing my accounts I noticed that rather than applying just 
>>> one tax rate, gnucash applied all the tax entries from both tax 
>>> tables as one tax rate, resulting in over 20% sales tax on an 
>>> item... I unposted the invoices with the problem, deleted the items 
>>> and re-entered them. The program still assigned the 20+% tax for 
>>> any item I listed as purchased prior to the date that I changed the 
>>> tax table. This was the case even after I removed all the old 
>>> tables and left only one table with an 8% tax rate in the system. 
>>> There was no other difference than the date of the transaction 
>>> between the problem invoices and those that were correct. I figured 
>>> the system had some kind of memory for transaction dates and I just 
>>> needed to start over. I just was hoping to reduce my workload. I 
>>> can't change the purchase dates because it would wreak havoc with 
>>> my Quarterly state tax reporting. Any ideas?
>>
>>  -derek
>>
>
>



-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available