The Sales Tax Report by Invoice Date displays the Sales Tax information according to the Invoice Date. This is the best report to use since Sales Tax should be reported based on the Invoice Date rather than the Accounting Period.

If there is “None” in the Not on File Tax Code, then the Shipto Customer was deleted after the transaction was Posted. This would usually occur with the Cash Customers. To select the orders for the Customers that were deleted do the following TCL command: 

    SP-ASSIGN Fprinter #

SORT ORDER WITH INVOICE.DATE >= “begin date” AND WITH INVOICE.DATE <= “end date” AND WITH SHIPTO.NAME = "" SHIPTO INVOICE.DATE INVOICE.NO (P

Your Aging Type in "Statement Terms and Comments" (6.11.6 field 6) should be set to DATE.

Use this report to prepare your Sales Tax. Each Tax Code is listed for each Location showing Total Sales, Non-Taxable Sales, Taxable Sales, and Total Tax Collected. The number of transactions is printed to help you compare your taxes to your receipts.

For Recurring Sales, the Tax will be broken out into the Mandatory Tax column if the Mandatory Tax account is used in the General Ledger Account distribution in the "Recurring Sales Entry" (6.6.1) and the Mandatory Tax Account is setup in “AR Setup” in SYSTEM MANAGEMENT (10.2.2.1, field 22).

An ERROR LIST will print if the program encounters a Customer, Tax Code or Zip Code that is not on file.

You may select by Customer Sort Code, if chosen, the Sort Code will appear in the heading of the report.

You may sort your Sales Tax Report by Order Location Number, Shipto State, or the Shipto Zip Code. If you choose to sort by the Zip Code, then the report will give the totals by the Shipping Customer’s Zip Code. This is very useful if you have to report sales tax for many states and municipalities by Zip Code. The totals of all Locations, States, or all Zip Codes, depending on the sort criteria selected, are displayed at the bottom of this report.

You also have the option of doing a Page Break on the Sort By entered.

You may print a <D>etail, or <S>ummary version of the Sales Tax Report. The Detail report will print each Invoice or Recurring Sale. It can be very lengthy, but will be useful in viewing all the items that make up the tax code amounts listed.

You may view on the screen or print this report.

The view screen function requires an AccuTerm© station or terminal capable of viewing 132 columns. Update fields 13, 14, and 16 in “Port Entry” in POINT OF SALE (1.10) to enable this function.

After the report is displayed to the screen you also have the option of entering a <D> to download the report to your local hard drive. When downloading the file, the path defaults to C:\TEMP but will use the setup in “Port Entry” in POINT OF SALE (1.10 field 16) for the download path. This directory must exist on the PC executing the download. The Windows© file name will be the report name concatenated to the port number, then .TXT. For example: ORDER.RPT10.TXT, where 10 is the port number or ORDER.RPT10TAB.TXT for the TAB Delimited file name.

<F>ile Option - <P>rinter, <S>creen, <F>ile, <F2>:

*Enter <P> Printer, <S> Screen, <F>ile or <F2>.

*<F2> will create a file for the Zipsales program. This will force Sort By Zip Code and Summary

Sales Tax Report <F2> option - <P>rinter, <S>creen, <F>ile, <F2>

       

*Enter <P> Printer, <S> Screen, <F>ile or <F2>

*<F2> willl create a file for the Zipsales program. This will force Sort By Zip Code and Summary

NOTE: This will produce a file compatable with Zipsales program. Zipsales is provided by another software vendor. It is used to organize sales tax data from multiple municipalities.