Sales tax reports

The sales tax reports are found in US accounts and provide a view of sales tax data to assist you with completing your tax returns.

Note: All tax codes are displayed; tax regimes do not apply to these reports.

Sales tax report

Find this report at Reports > Sales tax.

This report displays net and tax values for invoiced sales/credits and invoiced purchases/credits (SI, SC and PI, PC accounting journals). It also includes any bank receipts (BR) or bank payments (BP) which are taxable.

  • Tax code

    The tax by tax code section displays all net and tax amounts for the tax components within each tax code, with an overall total for each code.

    tax_by_tax_code.png
  • Tax component

    The tax by tax component section displays all net and tax amounts for each tax code grouped by tax component, with an overall total for each component.

    tax_by_tax_component.png

You are able to see the net and sales tax per component and the total for each tax code.

The fields on the report are:

Field Description
Net The sum of all entries to the accounts using that code, not including the 1100 Accounts receivable, 2100 Accounts payable, 2200 Sales tax and 2201 Purchase tax codes.
Sales tax The sum of all entries to the 2200 Sales tax account using that tax code.
Purchase tax The sum of all entries to the 2201 Purchase tax account using that tax code.
Gross The sum of the net amount and the sales tax amount.

You can click in to the totals to display all entries making up the figure.

Sales tax detail report

The sales tax detail report is found under Reports > Sales tax detail.

The sales tax detail report lists all items from invoiced sales orders and credit orders with the following information:

  • Order ID
  • Company name
  • Origin city and state (taken from the order warehouse address)
  • Destination city and state (taken from the delivery address on the order)
  • Item SKU and name
  • Net amount
  • Tax amount
  • Tax code

sales_tax_detail.png

Note: The sales tax detail does not show any taxable banking transactions, or any invoices/credits which are not associated to an order.

Exporting the sales tax detail report

When dealing with large amounts of data we recommend exporting the report. This can be done by filtering the report as required, then clicking "Export" on the top right hand side of the page.

The report will be requested as a background task to allow you to continue working. When your report is ready it can be downloaded from Background tasks in your user menu.

export_sales_tax_detail.png

Have more questions? Submit a request