Management Report

RFMS Navigator>Sales Reports>File>Finance>Management Report

This selection prints a management report that is a "snapshot" or summary of several financial areas in the RFMS system.  All important areas of business are included in one report for instant and easy analysis.  Areas reported are Cash on Hand, Receipts, Sales by Store and Salesperson, Profit Analysis, A/R Again, Undelivered Sales, A/P Aging and a complete Inventory value. The report may be calculated for any range of dates, i.e., daily, weekly, monthly, etc.

 Note: This report is not designed to report for Month End Balancing/reconciliation. Some portions report on current values. This is noted in the header.

Tips:

• It is suggested that Management review this report daily.

• The Management Report is not designed to be a balancing tool in reconciling other reports. Instead, it consolidates key financial totals as of the point in time the report is generated.

• The data for this report is compiled from
  • Cash Analysis: Bank Account
  • Receipts: Receipt File

  • Sales: Written-Order Header

  • Delivered-Job cost file

  • Profit Analysis-Job cost file

  • AR & Undelivered Aging- Order header

  • A/P-Payables File

  • Inventory- Inventory files

• The Order status must be written or delivered.

Field	Explanation
Begin/End Date	Enter the beginning date of the period to print. Enter the ending date of the period to print.
Fiscal Year Begin Month	Enter the beginning of the fiscal year for which the report will use to figure the year-to-date information.  This field is sticky.
Print Preview	See a preview of the report before printing it.
Output CSV	Include a CSV export of fields and data that can opened in a spreadsheet program.

Report Sections

Cash Analysis

This is a recap of the cash position. It lists information for each bank accounts and gives a total. It does not necessarily balance with the check register.  

Beginning Balance: Ending balance minus deposits plus checks, bank charges.

Ending Balance:  Uses the last transaction with an ending date that is the same as the ending date parameter entered when running the report

Change: The total increase or decrease between the beginning and ending balances.

Receipts

Recap of how cash was received for this time frame

Sales by Store/Salesperson/Customer Type

Both written and delivered sales are listed by store code. These are listed for reference only. Although interesting on its own merit, the user may want to correlate this with the installation capacity for this period.

If our crews were working at capacity to install the $98k, how will they possibly install $160k?  By Salesperson can be used to review individual sales performance. 

Sales by Customer type can mitigate any concerns created with over-commitment of installation capacity. In this example, $50k is attributed to Commercial. If this job has a longer than typical installation time frame, capacity may not be an issue.

Information pulled from the job cost file.

Written-Delivered Net: LESS Sales Tax

GP %: Total Cost divided by Total Sale Amount LESS Sales Tax.

Profit Analysis

Information pulled from the job cost file. 

Delivered for Period (Gross): Amount for dates entered only, Includes Sales Tax 

Delivered YTD (Gross): Amount for date entered for beginning of year to date to current- Includes Sales Tax

Gross Profit %: Total Cost (includes use tax) divided by Total Sale - INCLUDES Sales Tax

A/R Aging

From Job Cost Data-Does not include invoices on hold.

Undelivered Aging

Reports on open orders. Data is collected from the Header Data. Uses the order date and is through the ending date of the report.  Does NOT recreate what was undelivered for the dates entered.

A/P Totals

Uses the due date and is through the ending date of the report, does NOT recreate what was cue for the dates entered. Cash requirements listed by week with discounts.

Periods:

First- Beginning of G/L Install date through today’s date

Next 10- Next ten weeks

Last-Week 11 through all open A/P. 

Inventory Value

Data from Roll and Item Inventory files.

Cost used is GROSS, includes both costed and un-costed inventory.  Inventory totals are as of the point in time the report is generated — inventory recap by line status.

Aged Inventory Value

Totals by product code for inventory aging