Taxes Help Again!

Further to topic #324485 - Taxes Help!

I now need to create a report of quarterly sales. I am able to collect the data and produce a report using some custom MySQL and PHP. Where I am stuck is how to determine the tax calculation used in the purchase, as there are a number of different rules and rates. Is this information captured in the basket or payment details, or elsewhere?

Thanks,
Ed

If you're building a report of payments from _cbsubs_payments database table the tax amount should just be in the `tax` column. If building a report based off baskets from _cbsubs_payment_baskets database table it should also be in the `tax` column.

Thanks, Kyle.

Unfortunately, these are total tax amounts, and in some provinces, this has been calculated using federal and provincial percentage rates. But this isn't the same in all provinces.

Can you provide a breakdown of the item_number field in cbsubs_payments. I've determined that the last number after the second hyphen is the plan id, which I can use to determine the tax amount charged. I'm just wondering if there is any other information I can use from this field.

Thanks for all your help.

Ed

You'll probably need to query against _cbsubs_payment_totalizers then if you need the tax lines. I assume you've 2 different tax rules 1 for federal and 1 for provincial so there should be 2 tax rate lines per payment in that table keeping track of that.