Running the Sales Tax Journal

Run the Sales Tax Journal to list the sales taxes your company owes. You can run the report for the branches and period of time you specify. You have the option to show the report in a Detail format that lists individual sales orders. Or choose the Summary format that omits the order details. You can 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 amounts for gross sales, full tax sales, and other sales. The report also includes rental agreements. Additional columns show amounts for full tax due, other tax due, and the total tax due for each account. Columns for total tax charged and cash receipts tax adjustments, for example, miscellaneous adjustments at the time of payment, may also show. The detailed report format also shows the order number and customer name.

Note: 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 at a lower rate.

Each tax account is subtotaled, and grand totals for all columns display at the bottom of the report. The report notes that the grand totals may be inflated by sales for tax jurisdictions with multiple general ledger accounts.

To run the Sales Tax Journal:

From the Orders > Reports > Tax menu, select Sales Tax Journal to display the Sales Tax Journal screen.
In the Br/Tr/All field, press F10 and specify which or all branches and territories to report on.
In the Start Date and End Date fields, press F10 and specify the desired calendar date range. You can also specify dates using variable dating.
In the Detail/Summary field, press F10 and specify Summary to omit the individual order details, or specify Detail to include the orders.
In the Invoiced/Paid field, press F10 and specify whether to include all orders that have been Invoiced, or just report on invoices that customers have Paid.
In the Credits (Inc/Exc/Only) field, press F10 and select from one of the following to determine which type of payables to include in the report:

Include – Includes both debits and credits.
Exclude – Includes only debits.
Only – Includes only credits.

Set options, if needed, and generate the report.