Sales Tax Report - Cash Basis
complete
M
Moishe
Sales tax has to be paid based on when it actually got paid by the customer. There is no report that shows the sales tax collected in a given period regardless when the job/invoice was created, scheduled or completed etc. The sales report does not show "collected amounts." The sales tax report, if you check off paid only, can show you only paid amounts, but only for jobs "created, scheduled or closed" in the selected period, and not if it's a payment for something a year old. The easiest will be putting it by the payment report, which is cash basis, where you just have to add a column "sales tax paid." This should give you sales tax actually paid in the selected period.
idan kadosh
complete
D
Doug Steel
idan kadosh You guys fixed the report to just run payments received during the reporting period but it still just gives the total leaving us to have to figure out the sales tax. Can the report not separate the tax out?
D
Doug Steel
100% We've been struggling with this. You have run a payments report, sort by month, export, manually pull out any untaxed payments, then run the new total though a free calculator online to separate the pretax total and tax just to determine how much tax you actually collected in that month so you can send it to the state. There should be a simple report that show how much sales tax you actually collected during the selected time frame. Knowing what tax you collected on jobs that were completed during that time frame is totally useless if some of those invoices have yet to be paid since you do not remit tax that you haven't collected.