Accounts Receivable ARSTLSCN Help - Elliott Business Software



Sales Tax Liability Report

Sales Tax Liability Report

 

Application Overview

 

Sales Tax Liability Reports are a function of the A/R Sales Tax Audit Trail feature.  The purpose of this feature is to give a detailed tracking for sales tax so that complete auditing information can be available (especially for state auditing). This feature enables users to create Sales Tax Liability Reports for each tax code based on invoices or cash receipts. It also gives users the choice for printing a report for fully paid invoices only. If the user is tired of paying sales tax for which the invoice has not been paid off or paid in full, or if the user would like to be able to track down the exact sales tax amount based on fully-paid invoices, this feature will serve as a remarkable vehicle for business. 

 

Run Instructions

 

To run these reports, the A/R Sales Tax Audit Trail feature must be enabled, see Utilities Set Setup – A/R Sales Tax Audit Trail .

 

In order to get a glance of how much sales tax the user needs to pay to each state, county, and city, two reports are available to the user. One is Sales Tax Liability By Invoice, and the other is Sales Tax Liability By Cash Receipts. They both can be accessed by going through A/R à Reports à  Sales Tax Liability Report. Figure 2D.2 and Figure 2D.3 display the print screens of each kind.

 

The report by invoice is asking the user to enter starting and ending Invoice Dates versus Cash Receipts Dates in the report by cash receipts.  The report by cash receipt has an additional field - 8. “Print Full-Receipt Invoice Only?”.  Figure 2D.3 displays the Sales Tax Liability Report by Cash Receipts.  The “Receipt-Amt” and “Adj-Tax-Amt” columns will only display if the report is by Cash Receipts.  As you can see, the report by Invoice does not contain these two columns (Figure 2D.4).

 

 

Figure 2D.2. Printing screen for Sales Tax Liability Report by Invoice.

 

 

 

 

 

 

Figure 2D.3 Printing screen for Sales Tax Liability Report by Cash Receipts.

 

 

 

 

 

 

                     S A L E S   T A X   L I A B I L I T Y           R E P O R T

 

            Ship-To-Name                               Ship-To-Address1                   Ship-To-Address2                   City        St Zip-Code

All Tax Codes

All Invoices

Date Range: From  12/01/97  To  12/31/98

 

Tax Code

 Inv-No Cus-No Inv-Date Nontaxable-Amt          Taxable-Amt   Tax-Rt       Tax-Amt Sales-Amt   Freight-Amt      Misc-Amt           Invoice-Amt

 

AX

 

 118163 100001 03/27/98               0.00          5,440.00   1.0000         53.90 5,390.00     50.00      0.00          5,884.68

 

Subtotal :                            0.00          5,440.00                              53.90 5,390.00     50.00      0.00          5,884.68

 

AZ

 

 118163 100001 03/27/98               0.00          5,440.00   7.2500        390.78 5,390.00     50.00      0.00          5,884.68

 

Subtotal :                            0.00          5,440.00                             390.78 5,390.00     50.00      0.00         5,884.68

 

CA

 

 118156 594208 02/23/98               0.00            100.00   7.2550          7.26    100.00      0.00      0.00            107.26

 118161 594208 02/26/98               0.00          1,950.73   7.2550        141.53 1,950.73      0.00      0.00          2,092.26

 118162 594208 03/11/98               0.00            400.00   7.2550         29.02    400.00      0.00      0.00            429.02

 

Subtotal :                            0.00          2,450.73                             177.81 2,450.73      0.00      0.00          2,628.54

 

LA

 

 118155 123456 02/10/98              0.00            200.00   1.0000          2.00    200.00      0.00      0.00            202.00

 

Subtotal :                            0.00            200.00                               2.00    200.00      0.00      0.00            202.00

 

NO

 

 117604 111111 12/31/97             500.00                  0.00   0.0000                  0.00    500.00      0.00      0.00            500.00

 117606 111111 01/07/98       1,024.00                      0.00   0.0000                  0.00 1,000.00     12.00     12.00          1,024.00

 117607 123456 01/07/98       2,044.00                      0.00   0.0000                  0.00 2,000.00     20.00     24.00          2,044.00

 117608 111111 01/07/98       5,000.00                      0.00   0.0000                  0.00 5,000.00      0.00      0.00          5,000.00

 

Subtotal :                    8,568.00                      0.00                           0.00 8,500.00     32.00     36.00          8,568.00

 

Grand Total :                 8,568.00             13,530.73                             624.49 21,930.73   132.00     36.00         23,167.90

 

 

 

 

 

Figure 2D.4 shows a sample of a Sales Tax Liability Report.

 

 

 

 



Elliott Business Software
| Add-ons | Services
3rd Party Solutions | News & Events
Technical Support | Company Profile