Taxable / Tax Exempt Invoice Report
Reports Menu -> Taxes ->
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.
Topic Keyword: RSID28