Sales Summary

Represents your total sales for a given period. Period and amounts displayed can be selected.

 4 similar widgets can be used:

• Sales summary sorts your sales by product (product name or code)
• Sales by customer (eg: "Company A", "John Doe"...)
• Sales by location (location of your customers as defined in the applications)
• Sales by industry (eg: "Construction", "Retail"...)

By default, these widgets will represent the total gross value sold for each product, customer. etc. But this can also be changed to net value sold, quantity sold, or even net/gross value or quantity purchased.

Calculation

The total invoiced amount within a given time period is used to determine what the total sales is.

Settings

The widget can be filtered by a settable percentage value of gross amount sold, and time range scope (top-right cogwheel).

 The time range to be used can also be modified by selecting the two dates on the front of the widget.

Sales summary (sorted by product) can be found in on Xero in the report: Reports > All Reports > Sales by Item (screenshot).

Make sure the time range matches between Xero and Impac!.

For the 3 other widgets, the invoices list report can be used (see: Invoices List).

Noticeable differences with the Impac! widget

• Amounts are shown excluding GST

• on Xero. Excluding or excluding GST can be chosen

• on Impac! widget
• Mismatch between the "Sales By Item" report on Xero and "Sales Summary" widget on Maestrano: On Xero, the "sales by Item" report shows all sales of untracked inventory items (in opposition with tracked inventory items, as defined by Xero). On Maestrano, the "Sales Summary" widget displays the total numbers of sales including tracked items and untracked items. Therefore, the total number of sales shown in the "sales by item" widget on Maestrano and the figures shown on the "sales by items" report on Xero do not match.
• The Sales Summary does not take into account the credit notes.
  
  

Image Modified

Equivalent report can be found in “Sales by Product / Service Summary”.

Set the QBO date parameter to “All dates”. Set the value sold to (excl. taxes) in Impac!.

Noticeable differences with the Impac! widget

The Credit Note are included in the sales in QBO.

Image Modified

Sales per Item can be found in on MYOB under Reports > Index to Reports > Sales > Item > Sales (Item Summary).

Sales per Customer can be found in on MYOB under Reports > Index to Reports > Sales > Customer > Sales (Customer Summary).

 By default, the Impac! widget Item Summary displays only data for the current calendar year. So the MYOB report must be set to the date range 1st January of current year up to today. The amounts in on Impac! have to be set to "excluding taxes" to match the MYOB report.

Noticeable differences with the Impac! widget

The data range in on MYOB AccountRight and Impac! must match to see similar results. Only the top X items are displayed on the list (configurable in the widget settings).

Image ModifiedImage Modified