Applies to: RollMaster (RM) Core
Covers a version of the billed vs unbilled job cost report that strips out any overhead and overbill so owners can see true costs.
Menu path: Owner Functions > Detailed JC View/Print (Owner's Version)
This report module for Owners works the same as the report you will find in the Job Cost Reports menu but will be reflective of true costs, meaning no overhead or overbill costs will be reflected in this report.
Owners/managers of all flooring businesses should consider printing this report on almost a daily basis to assist with staying on top of open jobs in the system. The report will indicate whether inventory on a job has been received (it will show in the Material Costs To Date column), whether the job has been invoiced but not closed or only partially invoiced (the amount invoiced will show in the Total Billed To Date column), whether the job has been installed (it will show in the Labor Cost To Date column), and the profit and margin on each job (these will display in the Profit and Profit % columns respectively).
Unless there are extenuating circumstances, no residential job should be more than 3-4 weeks old. If there are no remaining costs to complete on a job, the job is more than likely ready to be invoiced and closed. Residential, Property Management, and Builder dealers will not necessarily use the Unbilled column of this report—that was implemented primarily for large commercial dealers to keep track of whether they are over or under billed on long-term projects.
The “Material Costs To Date” column of this report gets its cost information from the value of the inventory that has been assigned to a line. The information that appears in this column is the same information that can be seen in the “View Job Cost” or “Cost Maintenance” modules. By the time the vendor invoice is posted in the system, this value may change. The “Labor Costed To Date” values come from the same source for all of the reports—the Installer Payables Report. The “Special Costed To Date” values come from the cost inputted at the time the special charge line was entered in the system—this is also the same for all reports. The “To Be Costed” column values for all reports come from Catalog Maintenance initially, and are updated through the Purchase Order module. This report will export to Excel.
When you enter this report module, the screen will appear as follows:
Through the various Print Options, you have the ability to customize this report. If you do not wish to customize the report, you can simply click the Generate Report button to view the data on screen or export to Excel. However, you can narrow the data by programming one or more of these options based on the data you are seeking. At the By Branch (1) option, use the drop-down arrow menu to select a specific Branch if applicable. If you have enabled Region Reporting in the Company Control 2 level screen of the System Control Maintenance module, you will also have the option to sort the report by Region. At the Customer (2) field, click the button if you would like to select a specific customer for the report; otherwise leave the default setting for ALL customers. The By Job Number (3) option will allow you to print the report for a specific job. Type the job number in this field or leave the field set to “0” to include all jobs. At the By Job Type (4) option, use the drop-down arrow to select a specific Job Type for the report; otherwise, leave the default setting for ALL job types. At the By Salesrep (5) option, use the drop-down arrow to select a specific salesperson for the report; otherwise, leave the default setting for ALL salespeople. At the By Job Status (6) option, use the drop-down arrow to select a specific Job Status for the report; otherwise, leave the default setting for ALL.
In the first box of options (7), the only option automatically selected is the following: Include Unassigned / Unordered Material In Costs to Complete. You can uncheck this option to exclude unassigned/unordered material if applicable. The first option, Only print jobs with Zero Cost To Complete, should be checked if you only wish to see jobs that most likely should be closed in the system. The third option, Only Print Jobs That Are Progress Billed, will only be applicable if your company utilizes the Progress Billing feature in the system. If this is the case, then to only see Progress Billed Jobs, select this option. The fourth option, Only Print Closed Jobs, should be checked if you are only interested in looking at Closed Jobs in the system. The fifth option, Only print jobs that have a balance, is useful for designating jobs that may be stalled or have “fallen through the cracks.” The last option, Generate Debug Data, is a BMS Support item and should be used in conjunction with a member of the support team.
In the last box (8), you will determine if you want a date range for the report and if you want the system to use the Order Date or Invoice Date. Use the drop-down arrows to change the Start Date and End Date calendar fields. When you are ready to generate report data to screen, click the Generate Report button. The system will prompt a Search Results screen as follows:
There are several columns on this screen and there will likely be several rows, so you will need to utilize the vertical (1) and horizontal (2) bars to slide the screen and view additional data. At the bottom left, the system will display the Total Number of Jobs Printed (3) to this report. Once you have reviewed the data, you can click the Excel button to export to Excel, or click the Exit button to return to the prior screen.