This report by division, is based on selected taxes that are charged on any invoices in the date range. It provides the option to include all paid and unpaid invoices, or only paid and unpaid invoices posted to History.
The Tax Codes are always per the invoice detail, service, or damage waiver paid. If a Tax Code is over-ridden by NTX in a detail, the Non-Taxable amount is attributed to the Tax 1 or Tax 2 code from the invoice header, not from the customer file.
The prompts to generate the tax report are:
Note: The divisions included in the report output, are limited to the Divisional Restricted Views assigned to the operator.
Select Detail to print the complete Invoice Detailed report.
Check this box to print divisional summary totals for a single
tax code.
Uncheck this box to suppress the summary totals by division.
Note: The Division Summary cannot be generated for a report that
includes multiple taxes, as the totals per division would be
inflated because they would reflect multiple taxes on the same
invoice amount.
e.g. If an item is subject to GST and PST, it would be counted
twice in the division summary total.
Note: The Excel option is only availble for the invoice Detail output and only exports the "Taxable Variance" value for each invoice per tax.
SUMMARY:
The Summarized report prints totals by division as follows:
TAX CODE : PST - P.S.T. NON-TAXABLE TAXABLE TOTAL CALC. TAX PERCENT ----------- ------- ----- --------- ------- DIVISION 1 RENTALS : 95260.29 68238.98 163499.27 5459.12 8.00 SALES : 2493.32 1326.15 3819.47 106.09 8.00 SERVICES : 484.16 1206.10 1690.26 96.49 8.00 DAMAGE WAIVER : 1422.81 1585.51 3008.32 126.84 8.00 TOTALS : 99660.58 72356.74 172017.32 5788.54 8.00 ACTUAL : .00 72356.74 5788.54 8.00 VARIANCE : .00 .00 0.00
The Totals amounts in the "Taxable" column and the "Calc. Tax" column, are the calculated totals from the invoice detail, service, or damage waiver.
The Actual amounts in the "Taxable" column and the "Calc.
Tax" column, are the amounts actually charged, per the Tax window
on the payments screen of the invoice.
Because the tax amounts in this window can be over-typed, a
discrepancy is sometimes created.
The Variance should normally be zero.
But because the tax amounts in Tax window on the payments screen of
the invoice, can be changed by the counter staff, there is
sometimes a discrepancy between the calculated "Totals" and the
"Actual" amounts invoiced. This becomes the variance.
A detailed report for that Tax Code, Division and dates, can be
printed to determine which invoice caused the variance.
Note: If a variance in the "Tax Calc." column of 1 or 2 cents
shows, this is NOT a concern.
This is caused by rounding and is in the report calculation
only.
DETAIL:
The detailed report prints the tax information for each Invoice and
includes the customer number and name.
The PST exemption number also prints when applicable for the
invoice.
Note: Though the detailed output can be quite a lengthy report, it can best be used to identify the source of a variance discrepancy.
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |