Applies to: RollMaster (RM) Core
Use this article as a reference for the Sales Tax Reporting Details module, including printing and clearing monthly sales tax reports into a long-term historical ledger, supporting both detailed job-by-job line audits and high-level financial summaries.
Does Not Cover: Retail Lead Management (RLM).
Menu Path: Sales Processing > Reports 2 > Sales Tax Reporting Details
Sales Processing > Reports 2 > Sales Tax History
For other Sales Processing programs, refer to the Sales Processing module documentation.
The Sales Tax Reporting Details and Sales Tax History report modules have been combined and modernized into one graphical screen as follows:
The default report selection will be on Sales Tax Report, and only those options that relate to this report will be enabled, such as Detail and Summary. When the Sales Tax Report History option is selected, you will see the other options enabled as follows:
As a reminder, no data will appear on the Sales Tax Report History until that data has first been printed and cleared from the Sales Tax Report.
The Sales Tax Reporting Details or Sales Tax Report is a monthly report that will show all the tax that was invoiced for the month. If your state requires that you pay sales tax based on sold jobs and not on whether the customer has paid for the job in full, this report will give you the information and backup you need. No value is sent to this report until a Job is invoiced in the system. With this report, you have the option of printing a Detailed report or a Summary report. The Detailed report will list each sale and denote whether it was a Contract sale or an Invoice sale. At the bottom of the report you will see a total of all Contract sales, Invoice sales, Tax Exempt sales, and finally a grand total of all tax invoiced and therefore due. The Summary report simply lists all the totals without the job-by-job breakdown, but does list Total Taxable Sales. When the report is cleared, it is sent to the Sales Tax History Report explained below. Please Note: if using the Sales Tax Collected report—see separate documentation—you will not clear this report.
The Sales Tax Report History is updated only from printing and clearing the Sales Tax Reporting Details report. When you clear that report, the information is transferred into this report where it becomes history. If you ever need to pull the history, select this option and set any print options desired. The Tax Code field can be used to isolate a single Tax Code on the history report. This report looks exactly like the one that prints from the Sales Tax Reporting Details module, except that it has a Date column to the right of the Invoice column. It will also display a Job Type and Salesperson ID for each Invoice. This report can be exported to Excel by selecting that checkbox prior to printing. The Excel Invoice Detail checkbox has been added to assist with Sales Tax Audits of PST/GST tax, but can be used by anyone wishing to see the listed data. This export data will include the following: Tax Code, C/I, Invoice, Date, Cust.ID, Job Type, Sls ID, Job Number, Job Line Number, PO Br, PO #, Vendor Name, Vendor Invoice Number, and Material Cost Per Line.
As with all reports that are now exporting, the data in each column will not automatically total; you will need to use Excel formula functionality to create totals. This export includes a column for any Labor tax and for any Special Charge tax that was collected.