Service Titan Knowledge Base

Tax Detail Report GuideLast updated on 03/22/2022


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)

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]



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