Sales Invoice Reports

Occasionally, you may need to generate reports for data associated with Sales 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 Sales Invoice Reports by selecting any of the Sales Invoice Reports within Intelligence (which are identical to the Sales Order Report Types). The main difference is your reports will be calculated based on Invoice totals as opposed to Order totals.

Screen_Shot_2018-05-21_at_12.24.44_PM.png

Similar to Sales Order Reports, you can select the date presets as per your liking. You can either manually select the date range or used one of the preset date ranges using the For Invoices Issued drop-down menu.

Screen_Shot_2018-05-21_at_12.34.52_PM.png 

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:

  1. Total sales
  2. Quantity
  3. Total tax
  4. Total discount

Screen_Shot_2018-05-21_at_12.29.56_PM.png

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.

  1. 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 fulfillment status of an order, the COGs metric is not compatible with invoice based reporting.
  2. Realized and potential profit - Because we don't have COGs, we cannot calculate the profit.
  3. Potential tax - We don't have potential tax because we cannot tie a payment to a specific invoice line item. Payments are linked to a whole invoice.
  4. Potential discount - We don't have potential discount because we cannot tie a 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.

Note
TradeGecko Intelligence Reports generate data based on the sale of individual variants. At this time, for the sale of Pack Size Variants, reports do not reflect the stock movements associated with individual units, only the top level pack size variant itself. Likewise, for the sale of Composite Variants, reports do not reflect the stock movements associated with component variants, only the top level composite variant.
Print Friendly Version of this pagePrint Get a PDF version of this webpagePDF
Have more questions? Submit a request
Was this article helpful?
0 out of 1 found this helpful

Comments

NEW TO TRADEGECKO? START A 14 DAY FREE TRIAL, NO CREDIT CARD REQUIRED