Taxable / Tax Exempt Invoice Report

This report lists tax collected by tax code on invoices issued by division in a defined time period.
It provides a breakdown of taxable revenue by rentals, sales, and services.

It is used primarily by clients in the United States, who must collect and remit taxes for multiple states and cities, according to the Ship To location where the rentals/sales were used.
The spreadsheet output includes columns by the city and county when using GEOCodes, so that it can be sorted and totalled by those columns to be more useful for customers who have to report to each county.
It calculates the subtotals by tax code, by Ship to, and a Grand Total, to provide remittance amounts.

The option to request only Paid Invoices, is available for firms that remit tax only when the customer pays the invoice. These firms work on a cash basis only, and do not have an official Accounts Receivable.

If Enhanced Taxing is utilized as activated in the Company Taxing Parameters, the reporting option is provided to print the Taxable and Non-taxable information by individual invoice, with no totals.

Customer A/R tax amounts that have been written off or collected in Bad Debts And Collections can be optionally reflected in this tax report.

The report selection prompts include:

ALL DIVISIONS

Check this box to include all the divisions in the tax report.

Uncheck this box to select a single division for the report

DIVISION

This field is disabled if All Divisions has been selected for the report.
For a single division enter the division code, or select it from the drop-down list.

The divisions included in the report output are restricted by the Divisional Restricted Views assigned to the operator.

PAID INVOICES ONLY

This options is useful for firms that work on a cash basis and only remit tax when the customer pays the invoice.

Check this box to only include invoices that have been paid.
Uncheck this box to include both paid and unpaid invoices in the report.

FROM TAX CODE

Leave this field blank to include all tax codes, or select a starting tax code for the reporting range from the drop-down list.

TO TAX CODE

Leave this field blank to include all tax codes, or select an ending tax code for the reporting range, or enter the same code as the From Tax Code to report on that single tax code.

FROM DATE

Enter a start date for the report.

• If the option to report on Paid Invoices Only is selected, the date range is based on the Check Payment Date.
• If both Paid and Unpaid invoices are to be included in the report, the date range selection is based on only the Invoice Date.

TO DATE

Enter an end date for the report.

FROM SHIP TO PROVINCE/STATE

This is the site province or state where the rentals/sales were used.

Leave this field blank to include all sites, or enter the starting province or state for the reporting range, or select it from the drop-down list.

TO SHIP TO PROVINCE/STATE

Leave this field blank to include all sites, or enter the ending province or state for the reporting range, or enter the same code as the From Ship To Province/State to report on that single province or state.

FROM SHIP TO CITY

This is the site city where the rentals/sales were used.

Leave this field blank to include all cities, or enter the starting city for the reporting range, or look for it in the City Search window.

TO SHIP TO CITY

Leave this field blank to include all cities, or enter the ending city for the reporting range, or enter the same code as the From Ship To City to report on that single city.

ALL CUSTOMERS

Check this box to include all the customers in the tax report.

Uncheck this box to select a single customer for the report

CUSTOMER

This field is disabled if All Customers has been selected for the report.
For a single customer enter the division code, or look for it in the Accounting Customer Search window.

SEARCH FOR INVOICE IN

Select one of the following invoice statuses:

• Select Current to report on taxes for unposted invoices only.
• Select Batch to report on taxes for invoices that have successfully posted through Daily Close1 and are now in Batch status.
• Select History to report on taxes for invoices that are posted to History from Daily Close2.

PRINT TAX EXEMPT

If Enhanced Taxing is utilized as activated in the Company Taxing Parameters, then all tax exemptions must be included in the report.

Select one of the following options:

• Select Tax1 to only report on exemptions for Tax Code 1.
• Select Tax2 to only report on exemptions for Tax Code 2.
• Select All to report on exemptions for both Tax1 & Tax2 if Standard Taxing is utilized, or to report on all tax exemptions for Enhanced Taxing.

REPORT BY INVOICE

This option is only available if Enhanced Taxing is utilized as activated in the Company Taxing Parameters.

Check this box to print the taxes by invoice.
Tax totals are not provided when the report is generated by invoice.

Uncheck this box to print the report by tax code, and then list the invoices and transactions within each tax code.

PRINT TOTALS ONLY

This prompt only applies when NOT generating the Report by Invoice.
Check this box to only print out the tax sub-totals and totals.
Uncheck this box to print the tax details.

INCLUDE BAD DEBTS/COLLECTIONS

This prompt only applies when NOT generating the Report by Invoice.
Check this box to include tax transactions written-off and collected from posted Bad Debt and Collection records.
Uncheck this box to omit tax transactions from posted Bad Debts and Collections.

REPORT OPTIONS

This value defaults to the operator preference as defined in Operators.
Select one of the output options to Print a report or export the data to Excel as outlined in Report Options.

Finished?

Click the ACCEPT button to begin printing the report, or CANCEL to abort.

Note: When Standard Taxing to track only Tax 1 and Tax 2 is utilized as activated in the Company Taxing Parameters, if a tax code is duplicated on an invoice detail (e.g. HST/HST) then Tax 2 is considered exempt to avoid doubling the tax amounts on the report.
Similarly if the invoice header is configured with GST/NTX, but a detail or service is NTX/GST, then the exempt tax from the header applies on the report to prevent reporting 'double' the tax amounts or 'double' the exemptions.