Run the Sales Tax Code Report to list the sales taxes your company owes, organized by tax jurisdiction codes. Your company has a different code for each tax jurisdiction in which you do business, plus another generic OOS code for out-of-state sales. You can run the report for the branches and period of time you specify. You can also run the report for sales tax that you have collected (Paid) or for sales tax that is owed to you (Invoiced).
The report columns show you the jurisdiction code, exemption type, amounts for all sales, full tax sales, and other sales. The report also includes rental invoices. Additional columns show amounts for full tax due, other tax due, and the total tax due. The Detail report format also shows the branch, invoice number, and customer name. The full sales or taxes are those taxed at the full rate. The other sales or taxes are those taxed at any other reduced rate, such as freight charges that are taxed lower. The report's level of detail, subtotals, and totals depend on your Detail/Summary field choice.
Note:Progress Billing orders are not included on this report.
From the Orders > Reports > Tax menu, select Sales Tax Code to display the Sales Tax Code Report window.
In the Branch field, specify which or all branches and territories to report on.
In the Start Date and End Date fields, enter the desired calendar date range. You can also specify dates using variable dating.
Note: If you do not specify an end date, the system populates the End Date field with the information you entered in the Start Date field.
In the Primary Sort field, select one how to sort the report listing: Branch, Jurisdiction Code, and Exemption Code.
In the Secondary Sort field, select one of the following to specify how to sort the report listing: : Branch, Jurisdiction Code, and Exemption Code.
In the Select area, specify whether to include all orders that have been Invoiced, or just report on invoices that customers have Paid.
In the Mode area, select one of the following to specify how much detail to include in the report:
Detail - Lists the individual transactions, subtotals for each tax code and branch, and the grand total amount of tax owed.
Summary - Lists the subtotals for each tax code within each branch, followed by the subtotals for each branch or the subtotals for each branch within each tax code. This is followed by the subtotals for each tax code based on the parameters in both the Primary Sort and Secondary Sort fields, as well as the grand total amount of tax owed.
Totals - Lists the totals for each branch or tax code, based on the parameter in the Primary Sort field, as well as the grand total amount of tax owed.
In the Credits area, select one of the following to determine which sort of payables to include in the report.
In the Tax Exempt Order area, select whether to include, exclude, or run the report only for tax exempt orders. The default of Excludeincludes only taxable orders in the report.
Select the Only Items Over Max Taxable check box to include items over the maximum taxable amount. This amount can be set for each tax code. The default is deselected.
Select the Display Jurisdiction Totals check box to displays additional columns for state, county, city, and local taxes that display after the Tax Amount column. The default is deselected.
See Also: