Tax Detail Report GuideLast updated on 03/22/2022

Purpose of the Tax Detail Report:
Common uses for this report:
How to find this report:
Required Setup for this Report:
Report filters

Purpose of the Tax Detail Report:

This report provides an overview of posted and exported invoices, based on tax zone. Data in this report is based on invoices within the report date range.

Common uses for this report:

Use this report to view the invoice, customer, business unit, zone name, zone rate, gross total, taxable, tax liability, and tax invoiced.

How to find this report:

Click Reports > Search Tax Detail> Click the report name. Then you will be able to set filters and run the report.

Required Setup for this Report:

Tax zones are not configured by default. To configure tax zones, go to Settings > Invoicing > Tax Zones.

Note: You can also configure your account for multiple tax rates, for example, local, county, and state taxes. This report includes separate entries for each tax rate. Account configuration is required to use this feature. Contact your success or support manager for details.

Report filters

Business Unit

Filter by business unit. This report can be run by a single business unit or all business units.

Customer Type

Filter by customer type. This report can be run by taxable, non-taxable, or all customer types.

Tax Zone

Filter by tax zone. This report can be run by a single tax zone or all tax zones.

Date Range

Filter by date range. Use the From and To fields to set a custom date range.

View or download the report

Click Update to view the report.

The report can be downloaded in three different formats:

Download PDF
Export to Excel (*.xlsx) (click the dropdown arrow next to Download PDF)
Export to Comma separated (*.csv) (click the dropdown arrow next to Download PDF)

Explanation of report columns

The report includes the following columns:

(Report columns)

Invoice	The invoice number will be attached to a particular job. Your account can be configured so the invoice number will always match the job number by default. You may configure the invoice number to be the same as the job number.
Invoiced On	Date on the invoice.
Customer	Customer name. This is the Bill To customer on the invoice.
Address	Address of the service location where work was performed.
Business Unit	Business unit under which the job was booked. This information is pulled from the invoice. Note: Business units can be used to separate your business by geographic locations, or business units can be used to separate service divisions within a company (HVAC, plumbing, electrical).
City	City of the service location where work was performed.
Zip	Zip code of the service location where work was performed.

(Report columns continued)

Zone Name	Tax zone name on the invoice. Note: If there is a membership item on the invoice, the zone name will populate for the location the membership is attached to. If there is no membership item on the invoice, the zone name will populate for the service location. How to Configure - Zone Name:To set zones names, navigate to Settings > Tax Zones > Add Tax Zone.
Zone Rate	The tax zone percentage rate that corresponds with the zone name. How to Configure - Zone Rate:To set zones rates (tax rates), navigate to Settings > Tax Zones > Add Tax Zone > Tax Rate.
Customer Type	Taxable or Non-Taxable customer type, based on the invoice.
Gross Total	Total dollar amount for all invoice items. This is the sum of all invoice items for taxable and non-taxable sales. Calculation - Gross Total: [Subtotal] + [Discounts and fees]
Taxable	Sales that are taxed. Calculation - Taxable: [Sum of taxable invoice items] How to Configure - Taxable Sales:To set sales as taxable, navigate to Settings > Pricebook > Services/Materials/Equipment > Details tab > Taxable.
Tax Liability	The tax liability (sales tax) owed to the government. Some states require businesses to pay sales tax once a payment is applied to an invoice. Tax liability will display the total dollar amount of tax owed on each invoice, whether a payment has been applied to the invoice, and the dates and amounts of payments made on the invoice. Calculation - Tax Liability: [Taxable Sales] x [Zone Rate] How to Configure - Zone Rate (Tax Rate):To set zone rates (tax rates), navigate to Settings > Tax Zones > Add Tax Zone > Tax Rate.
Tax Invoiced	The amount of sales tax on the invoice that was charged to the customer. Calculation - Tax Invoiced:[Sum of the tax amount on each invoice]

Explanation of report totals

(Report totals)

Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.

Disclaimer: Information provided in this article is for informational purposes only and it should not be construed to be legal advice. Information provided in this article may also not constitute the most up-to-date legal or other information. You should not act or refrain from acting on the basis of any information in this article to meet any compliance requirements without seeking independent legal or other professional advice.

Gross Total	Gross Total is calculated by taking the sum of the entire column. Calculation - Gross Total: [Sum of column totals]
Taxable	Taxable is calculated by taking the sum of the entire column. Calculation - Taxable: [Sum of column totals]
Tax Liability	Tax Liability is calculated by taking the sum of the entire column. Calculation - Tax Liability: [Sum of column totals]
Tax Invoiced	Tax Invoiced is calculated by taking the sum of the entire column. Calculation - Tax Invoiced: [Sum of column totals]