The Top 5 Reports on BMS

BMS Top 5 Owners/Managers Reports 

1. Job Cost Margin – written business report
2. Detailed JC View/Print – Complete job cost information for 1 job
3. Work in Process Costs from JC – All open jobs
4. Credit Return Report – Credits/refunds given
5. Sales Analysis – 1000’s of possible reports in one*

*see supplemental Sales Analysis insert

1. Job Cost Margin Report:



The Job Cost Margin Report was designed to yield comprehensive margin analysis information for all types of jobs in the system.  The report will allow you to include open and closed jobs, or just open jobs in the system.  You can also customize the report to include only jobs within a particular date range, which means that you can use this report as a written sales report.  This is an excellent report for overall sales and profit margin data by salesperson, branch, and company.  In this example, BU = Builder Business, CC = Cash & Carry Business, CO = Commercial Business, and RE = Retail Business.  Job Type Codes are user defined and can be customized to yield specific job type information by company.  

2. Detailed JC View/Print:
 

This report compiles several areas of Job Costing and brings it together on one report, which is an incredible tool, especially for large commercial dealers.  Everything you need to see as an owner on each job has been combined together on one page of this report.  The Budget is displayed showing the Actual Costs, the Budget as it was set in the beginning and then the Difference between the two.  You can also see the salesperson commission amount, including the commission base and the percentage.  That information is followed by all the totals on the job, such as line totals, any overbill or overhead totals, tax, the total sale, profit and margin, and then information on the invoice if one has been created.  The end of the report lists each line on the job with the corresponding cost, overbill, sale, profit and margin.  On any labor lines where labor has been posted in the system, the Installer ID will also display along with his rate, total paid to date and any quantity remaining to be paid. 
3. Billed vs Unbilled – Costs From JC:
 

The Billed vs Unbilled series of reports were developed originally for large commercial dealers utilizing the Progress Billing feature; however nearly all dealers are using it now in order to assure timely billing.  There is more than one report because each is tied to a different costing source in the system.  This was done in order to accommodate the needs of a variety of users.  The general purpose of these reports is to help the user keep track of cost and revenue information for financial statement purposes.  In other words, the reports show if too much profit is being taken when you don’t yet have costs in the system that correspond with the profit and vice versa.  They also show how much cost has been taken to date and how much still needs to be taken.  In the report above, the cost information is coming from the value of the inventory that has been assigned to a line (based on the catalog value or purchase order value).  By the  time the vendor invoice is posted in the system, this value may change.  The Labor Costed To Date column gets its value from the Installer Payables Report; and the Special Cost To Date column gets its value from the cost entered in the system at the time a Special Charge line is added to a job.  
4. Credit/Return Report:
 

This report works in tandem with the F3 Credit procedures in the system.  This report will print out a list of all credit memos created in the system with the corresponding job number, original invoice # and amount, the amount of the credit, the amount refunded, the salesperson, and the customer.  It will also print any Notes added during credit processing which will help explain the reason for the credit.  It can be sorted to print by Branch, CM Invoice #, CM Invoice Date, Salesperson, and Pay Type Code.  As an example, if you wanted to see a list of credits performed by each salesperson for a specific time period, you could use this report for that purpose.
 
5. Sales Analysis*:
*see supplemental Sales Analysis handout
 
FYI: The Invoice Register – HISTORY report will allow you to retrieve Invoice History by Date Range, Salesperson and Customer.  You can instantly review Gross Profit and Gross Margin for a range of Invoices.  This will show a little more detail than Sales Analysis, such as the breakdown of Material, Labor and Special Charge sales, and Sales Tax.  The Invoice Register creates the Sales Journal data for your financial statements.