Sales Tax

SUGGESTED

Is there a way to have a report that shows the sales tax on accounts receivable?  Our state allows us to take exemption on sales tax payables that are not collected.  At the end of each month we are creating a spreadsheet of accounts receivable and then having to go in to each invoice to see how much sales tax should be listed on those transactions.

Parents Reply Children
  • 0 in reply to StephenC

    I need it for our receivables.  Indiana allows us to not pay the sales tax until we are paid.  So exporting the A/R report into Excel then going through each invoice to find out how much tax was invoiced is a pain.  Just trying to find an easier way.

  • 0 in reply to Ferrer Mechanical
    SUGGESTED

    That's exactly the purpose of the cash basis option on the Taxable/Exempt Sales report. Instead of going through your receivables to see what has not been paid, just run the Taxable/Exempt Sales report and select the Cash Basis option. It will give you are report showing sales and tax collected based on invoices that were paid that month regardless of the invoice date. Invoices that have not been paid will be excluded from the report.