I need to run a Sales Tax Liability report for a client so that I can prepare monthly/quarterly/annual sales tax returns (for multiple states) and remit the proper payments to the various states. I am relatively new to Sage 50, and have not had to run a Sales Tax Liability report (in Sage) before, and I'm not sure how to do it.

There are multiple sales tax rates applicable to each state where my client has sales tax liability. The Sales Tax Liability report needs to show me the total sales for each state, as well as the sales for each tax rate (showing the break down of total sales at the tax rate, as well as the total amount of tax due for that tax rate). The report should also show all sales for each state that are "exempt" from sales tax (and the type of exemption - such as "Tax Exempt", "Resale", etc.).

My client just started (incurred) sales tax liability with a second state (which currently only has one sale in that state). Previously, the client only had sales tax liability in one state (with multiple tax rates). The second state will also have multiple tax rates (when my client begins to have more sales in that state). The tax rates in the second state will be dependent on the mailing address(es) of each customer in that state.

I need to know the best way to be able to setup the tax rates for the second state, so that I can track sales tax for each customer (in the second state) at the correct tax rate. (The second state is Kansas. I only have one rate at the moment - 7.5%. I set it up as KS-7.5%. The tax rates can be anywhere from 5% to 9%, depending on the mailing/shipping address of each customer within the state.)