Re: Number of Taxes on an item or service

["Chris Travers" <..hidden..>]

On 4/5/07, Les Richardson <..hidden..> wrote:
> Hi John,
>
> > The sales taxes are uniform in application here but there are US
> > jurisidictions with special tax districts (usually to subsidize stadiums)
> > where the special tax applies only to certain goods.
>
> So there would have to be some sort of identifier to mark certain taxes as
> uniformly applied and others as variable (and therefore stored with
> particular transactions in my app).
You can do that.  Note that with the modular sales tax structure of
1.2.0, you can write a tax module to calculate taxes based on whatever
criteria you want (number of items purchased, what else was on the
invoice, where the item was shipped to, or other arbitrary criteria.
> >> I was thinking of setting _4_ taxes are worst case scenario in the table
> >> structure... with some being left NULL; controlled by values in
> >> configuration file.
> >
> > While I am subject to a maximum of three different sales tax rates, I must
> > itemize total sales and tax collected by county and special tax district.
>
> So each tax would have a different account number, even for the same
> taxs but different county or taxation district... correct? ( Making for an
> interesting COA ).

I don't know.  I would suggest checking with a CPA about the best way
to do it.  Since in all cases there would be records indicating where
an item was shipped, I would think it could go into the same account
and then broken out later, but I don't know.  In your case, though,
that might not work so well.
> I'm interested in generating the journal transactions in my app (Open
> Admin) and then exporting them to ledger-smb. For this to be useful in
> your area, I would have to know all of your account numbers for these Tax
> Payable accounts (stored in OA) and then tag the transactions with the
> appropriate account numbers.... these tax things make everything so...
> ugly! (grin)

What language are you working in?  You may find some parts easier to
run through LedgerSMB tax module.  That way you can have uniform
handling between the school front-end and the accounting back-end.

Best Wishes,
Chris Travers