Orders / Quotes Profit Report

Sales Report>File>Profitability>Orders / Quotes Profit Report

This report is similar to the Quotes report in Order Entry, but not identical. For Quotes and Undelivered Orders the Gross Profit % default same as in OE.  

 This report is useful to spot check quotes or orders to see abnormal profit percents or zero cost lines. This report is similar to the Quotes report in Order Entry, but not identical. The default Overhead % is inherited from the Standard Overhead Margin, but can be edited here.

Purpose	Spot Checking Quotes	Data Source	Quotes: Estimate Header Orders: Job Cost file
By Store	Y	By Sales Rep	Y	By Product Code	N
Profit	Y	Customer Type	Y	Balance Due		Y
Order Status		.CSV output	Y	User Defined		Y
Paper Size	8.5 X 11	Balance to
Common uses: Spot check quotes or orders to see abnormal profit percents or zero cost lines Tips for Use:  Maintain accurate costs in products file for accurate reporting.

Use

Choose either Orders or Quotes (Note some options change depending on the choice here.) (Related quotes are not counted separately. So a quote with one or more related quotes still counts as 1)

Sort Order

Selecting Billing Group/Invoice number will include only orders which are within a billing group.

Print Options

Break after sort changes- This option will cause a separate page to be printed each time a new value for the sort option occurs. For example, if sorted by Salesperson/Customer type, a page break will be inserted after each Salesperson. 

Print Summary Only- Does not include detail of individual orders

Print Preview – Click to review this report before printing.

Print Greenbar- Check this box for highlighting every other line for easier reading.

Output to CSV – Click to export this report to an external CSV file which can be opened with excel.

Select Printer- The default printer is listed.  To change this printer, click the ellipsis button. 

Report Options

Merge Freight/Overhead with material costs: Check this box to include all the costs together rather than in two separate columns.

Print Extended Costs: Checking this box will give a breakdown of profit and GP Percent of the material Sale/Cost column.

Use overhead margin of ____ % for UNDELIVERED orders- Checking this box and entering a percentage will add overhead to the Frt + OH + Load + Use Tax column without having to have overhead on each individual order.  It will not affect the remaining columns; overhead is only added to these columns for delivered orders.  The default Overhead % is inherited from the Standard Overhead Margin, but can be edited here.

Balance Due

When printing this report by salesperson the balance due does not split. Because of this it is better to not allow balance due to be printed in this case and has been disabled in V. 23.0.

Include Referral Costs in Service Column

As of version 22.0  this report has the option to include referral costs in with the service column of the orders report.

This new check box is a sticky setting that applies to both Delivered and Undelivered.

If “Include Referral Costs in Service Column” is checked, Referral Costs will be included in the “Cost” field of the “Inst Svc” column.

CSV Output will have a separate column for Referral Costs. Referral Costs will not be included with the Labor Costs.

Since the Referral Costs are coming from the Referral Tracing tables or the Provider records, it is possible that the line Referral Costs will not match the Total Referral Costs being represented. This can happen if the Referral Costs were overridden and locked.

“Referral Tracing” must be turned on.

“Include Referrals in Job Costed Analysis” must be turned on.

Orders that were created and/or job costed with these either of these switches turned off, may not calculate the referrals correctly on this report.

Report Columns

Misc. Charge: Amounts added to jobs during job costing will show here.

Frt + OH + Load + Use Tax: Overhead number is listed in this column but not included for quotes or undelivered orders net cost or profit numbers.  Delivered orders will include overhead in these numbers. 

Net Sale/Cost Gross Profit Gross Profit % Invoice Total: These numbers will not include overhead nor misc. costs for quotes or undelivered orders.

Related Quotes

These related quotes are shown on the Orders/Quotes Profit Report but not included in the calculations.

In this sample report, ES100005 is a related quote and is therefore not included in the totals or the averages.

This report can Save/Load/Clear filters.  For more information on these, go to Saving and Loading Filters