Sales Tax Report

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:

DIVISION, "ALL" OR "SEL"

• Type ALL to include all divisions in the report.
• To print the report for a single division, leave this field blank for the Head Office Division, or enter a specific division code, or select a division from the drop-down list.
• Type SEL to select several specific divisions or divisions by accounting region to include in the report, as outlined in Division Select By Region.

Note: The divisions included in the report output, are limited to the Divisional Restricted Views assigned to the operator.

TAXES, "ALL" OR "SEL"

• Type ALL to include all taxes in the report.
• Enter a specific tax code select one from the drop-down list.
• Type SEL to select a range of taxes to be included in the report, as outlined in Select Tax By Region.

POSTED INVOICES ONLY

Check this box to include only posted invoices that are in History.
Uncheck this box to include all posted and unposted invoices, having a status of Current, Batch, or History.

FROM DATE

Enter a start date for the invoices to be included in the report.

TO DATE

Enter an end date for the invoices to be included in the report.

REPORT TYPE

Select one of:

• Select Summary to print the Summary Tax report.
  The Excel output option does not apply to the Summary.

• Select Detail to print the complete Invoice Detailed report.

NEW PAGE PER TAX CODE

Uncheck this box to prevent paging between tax codes.
Check this box to list each Tax code on a new page of the report.

PRINT DIVISION SUMMARY

This prompt only applies when generating a detailed report for a single tax code.

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.

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.

Note: The Excel option is only availble for the invoice Detail output and only exports the "Taxable Variance" value for each invoice per tax.

Finished?

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

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.