You may need to generate reports for data associated with Invoice totals rather than Sales Order totals. This is especially helpful when calculating sales commissions for your sales teams, based on Invoiced Sales.
You can run Invoice Reports by selecting from the “Invoice Reports” tab within the Intelligence section. The report structure is similar to the Order Reports. The main difference is your reports will be calculated based on Invoice totals as opposed to Order totals.
Similar to Sales Order Reports, you can select the date presets as per your liking. You can either manually select the date range or use one of the preset dates ranges using the For Invoices Issued drop-down menu.
You can filter all your Sales Invoice Reports by: Assignee, Channel, Customer, Customer Tags, Customer Type, Location, Order Tags, Total Discount, Total Sales, Total Tax, Product, Product Brand, Product Tags, Product Type, Quantity, Shipping Country, Shipping State, Supplier, Total Sales, and Variant.
With Invoice Reports, only the following metrics can be selected and displayed using the Show Me drop-down menu:
- Total sales
- Total tax
- Total discount
You may notice that some of the metrics available within Sales Order reports are not available for use within Sales Invoice reports. This is because the data these metrics use on Sales Order Reports rely upon are associated with Order values, not Invoices.
The following sales order metrics are not compatible with sales invoice reporting.
- COGs - Cost of Goods Sold calculations are dependent on the Moving Average Cost (MAC) for each variant within a Sales Order. A sales order COGs value is generated when the order is fulfilled. As invoice data is not dependant on the fulfilment status of an order, the COGs metric is not compatible with invoice based reporting.
- Realized and potential profit - Because we don't have COGs, we cannot calculate the profit.
- Potential tax - We don't have potential tax because we cannot tie payment to a specific invoice line item. Payments are linked to a whole invoice.
- Potential discount - We don't have a potential discount because we cannot tie payment to a specific invoice line item. Payments are linked to a whole invoice.
To finalize and generate the report, continue as you would with the regular sales reports by clicking on Apply or Apply Filters, and then Run Report.