How to create a Sales Tax Details report

The Sales Tax Details report provides state, county and city tax details by invoice line item and includes a tax summary with taxable and non-taxable sales totals. The report opens as an Excel worksheet and can be created for a period of up to 31 days.

1. On the top ribbon, click the Reports module.
2. In the Report Area pane, click Sales Analysis, and then click What I Need To Know.
3. In the Report List, click Sales Tax Details.
4. In the Choose Report pane, click Next or press F12.
5. In the Sales Tax Details window, in the Report Settings pane, in the Invoice Date row, specify a date range for 31 days or less.
6. Optional: In the Additional Settings pane, if you want to include line items that are notes, select the Show invoice notes checkbox.
7. In the Sorting Options pane, click Run Report or press F12.
8. In the lower right corner, watch the progress bar, and wait for this message:  Report Complete.
9. To see the Sales Tax Details Report, open the downloaded Excel icon in your task bar.

Note:  If you need tax details to support an audit, contact Paladin Support (800-725-2346 or support@paladinpos.com).

Example:  Line items details in the Sales Tax Details report:

Example:  Tax summary with taxable and non-taxable totals is included at the bottom of the worksheet:

The following information will help you understand the tax summary values:

• The Totals values match the Comparative Revenue report revenue and tax totals.
• The Total Taxable Sales and Non-Taxable Sales values break down the taxable and non-taxable sale totals for each tax type, and are the sum of individual line items.
• Each value in the last row is the sum of all taxes collected (State Tax, County Tax and City Tax) and the column’s Total Taxable Sales and Non-Taxable Sales values.

The Sales Tax Details report complements the Comparative Revenue report, which calculates taxable and non-taxable values by line item, instead of by invoice.

Example:  Sales tax details for each tax type (state, city, etc.) with the following conditions:

• The taxable sales total is the sum of the line items that were taxed.
• The non-taxable sales total is the sum of the line items that were not taxed.

Note:  When you run the Sales Tax Details report, the following message may appear:

If you click OK or press F8 to continue with the report, a note will appear at the bottom of the spreadsheet, and State, County and City Tax totals will not reflect all sales and may be zero (0).

Note:  When you run the Comparative Revenue Report, a message appears below the SALES TAX DETAILS table. Paladin Point of Sale will also estimate and itemized sales tax amounts. These estimates will appear with a tilde (~).