Sale Overview Report

This report shows an overview of all sales, the customer and the sale and shipment status. Use this report to get a snapshot of sales status and financials (amount invoiced, paid, due, COGS, profit, etc.). The overview does not show product information. Sale Overview report filters orders based on order date.

This report is only available to users with Sales Reporting permissions.

Prerequisites

Managing Cin7 Core Reports

Data from this report can be exported in Excel, PDF or RTF format.

Input:

Reporting Period	Allows the user to select the reporting period from a list of options or set a custom date range.
Layout	Set to the Default layout. Allows selection of saved layouts, if any.
Save Layout As	Allows saving a layout for potential future use.
Reset Layout	Resets the layout to the default layout or selected saved layout.

Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing Cin7 Core Reports - Filtering Reports for more detailed information about using filters.

Output:

The following output fields are available for this report. You may have to open the Configure Layout menu to add some of them to your report.

Fields
Order #	Sale Order Number identifying the sale
Order Date	Sale order date
Customer	Customer name
Invoice #	Invoice Number identifying the sale invoice
Invoice Date	Date of invoice authorization
Due Date	Payment due date according to the payment terms specified in the document header
Sales Representative	Sales Representative assigned to the sale order
Notes	Notes from the sale order document header
Customer Tags	Any customer tags
Customer Reference	Reference field from the sale document header
Status	Sale status. The same status can be seen on the Sales List. For example, if there is insufficient inventory and it is not possible to pick stock, the status will remain in Picking until stock becomes available and picking can be performed.
Quote Status	Quote status. Possible values are Draft, Authorized and Not Available (no quote).
Sale Order Status	Sale order status. Possible values are Draft, Authorized, Fulfilled and Not Available.
Invoice Status	Invoice status. Possible values are Not Invoiced, Invoiced, Invoiced/Credited and Not Available.
Payment Status	Payment status. Possible values are Prepaid, Partially Paid, Paid, Unpaid and Overpaid/Credited.
Pick Status	Picking status. Possible values are Not Picked, Picking, Picked and Not Available.
Pack Status	Packing status. Possible values are Not Packed, Packing, Packed and Not Available.
Ready For Shipment	Indicates if the sale has been shipped, ready or not ready to be shipped.
Ship Status	Shipping status. Possible values are Not Shipped, Shipping, Shipped and Not Available. This refers to the status of the Ship tab.
Fulfillment Status	Fulfillment status. Possible values are Not Fulfilled, Fulfilled and Not Available. This refers to the fulfillment status of the entire order.
Ship By	Required By date entered in the sale document header if applicable
Shipment Date	Shipment date for the Sale Order
Shipment Line 1	Line 1 from the sale shipping address
City	City from the sale shipping address
State	State from the sale shipping address
Country	Country from the sale shipping address
Postcode	Postcode from the sale shipping address
Customer Additional Attribute 1-10	Values of customer additional attributes
Data Headers
Quoted	Total of the sale quote including tax in base currency
Ordered	Total of the sale order including tax in base currency
Sale	Total of the sale order excluding tax in base currency
Invoice	Total of the invoice - Total of the credit note including tax in base currency
Lines	Total of the sale lines including tax in base currency (Invoice - additional charges)
Additional Charges	Total of additional charges including tax in base currency
Paid	Total Paid - Total Refunded in base currency
Due	Due amount = Invoice - Paid (in base currency)
COGS	Cost of Goods Sold in base currency
Journals	Total of all Additional Transactions associated with the sale in base currency
Profit	Profit = Sale - COGS (in base currency)
Profit less Journals	Profit - Journals in base currency
FX Gain/Loss	Foreign Exchange gains and losses

Note: If you have added an Additional Attribute set to your sale process, the attributes will appear as additional report fields.

FAQs

Can you please tell me why a sale order is missing from this report?

Usually, this is an issue with the date filters. This report pulls sales according to their order date. Double-check that the reporting period covers the sale order date.

When a manual journal is posted against a sale, the Sales Overview Report when calculating the Invoice profit does not offset the journal transaction.

Manual journals are taken only as a record and debited into a specific account. When it comes to the sale, it will not show it as a profit. The profit will be calculated based on the Sale - COGS. The report can be set up to show Profit less Journals, you may have to click "More Fields" to show it.

Why am I getting different totals from Sale Overview Report and Profit Summary Report?

The two reports have different bases. Sales Overview Report sorts data by sale order date. Profit Summary Report is transaction based (authorization of invoice, COGS (ship date), etc.), so it contains all transactions within the date range no matter the order date. Some sales may fall out of the date range of one or the other of the reports.

Is there a reason why the order header field "Location" is not available on the Sale Overview report?

The Sales Overview Report is primarily for COGS and payment information, hence, Location is somewhat irrelevant or this type of reporting. You may use the Sale Order Details report for order details such as Location.

Can you filter the Sales Overview Report by sale amount (for example, only show orders above $1000)?

This is not possible. Unfortunately pivot grid and pre-filter are third party components, so Cin7 Core developers cannot make any changes to how they function.

Would you please confirm what affects the COGS column on the sales overview report? What about for dropshipping with no physical inventory?

COGS is affected when the "ship tab" in a sale order has been authorized. In the case of dropshipping, COGS transactions are created once purchase order has been fulfilled.

On sales orders within Cin7 Core the margin is shown compared to the average cost of the sold product. However when I run the report Sale Overview, I have a different number in the Profit section. Could you please explain the reason behind that?

The margin on the sale order details screen is based on the current average cost (for reference only, calculated from entire purchase history) of the product. Sale Overview margin is based on the cost of the product picked.

I was wondering what is the difference in what sales are being shown between the Sales Overview Report and the Profit & Loss Report?

Sales Overview report shows an overview of all sales orders along with the status of the invoices. However, in the Profit & Loss Report, the 'Sale' will reflect all the items that are captured in the ledger 'Sale' account. If you have done a manual journal or passed an entry to the 'Sale' account then these will be captured too.

For example, if you have created a manual journal due to receiving money for some activity (not for a sale) and then you would credit this to the Sale account (which is categorised under income in the profit and loss statement - in the ledger). Therefore this will now be captured in the Profit and Loss statement, however, this will not reflect in the Sales overview report, this is because it was not an invoice or a sale order. So only the sales Orders will be captured in the Sales overview report. Therefore there will be a discrepancy when you reconcile the line items.

The sales order report shows me all orders prior to being despatched. I'm looking for a report which will give me all orders with order detail irrespective of the status of the order. What can I use?

You may use the Sale Order Details and Sale Overview reports, as these two reports are based on sale orders, these reports will show you all orders regardless if an invoice is authorized or not if the sale is a simple sale. For advanced sale, you need to raise an invoice for it to be included in the report, it can either be authorized or saved as draft.

Still no answer to your question? Please do not hesitate to get in touch with Cin7 Core support.

Sale Overview Report

Prerequisites

Input:

Output:

FAQs

Was this article helpful?