Versions Compared

Old Version 2

changes.mady.by.user Johan Erchoff (Unlicensed)

Saved on

compared with

New Version 3

changes.mady.by.user Cesar Tonnoir (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Gross Margin

Status
colourGreen
titletested
Status
title
colourYellow
work in progress
Status
colourRed
titleknown bug

Overview

Tracks the Gross Margin through of your company over a period of time.

Users have the ability to either view the gross margin for a particular period (a dropdown allows users to include or exclude taxes) or the history of this KPI (with a chart).

Calculation

Gross Margin is calculated as follows:

Gross (over selected period) → Gross Margin = Total sold - Total purchased

Settings

Click the cogwheel to access the following settings:

  • Time period selection: pick the time period you want the widget to be based on.
    • Account: select the account whose you want to check the balance

    The time period can be changed in the settings section (top-right cogwheel).

     

    See it in Xero

    There is no "Gross Margin" report in Xero by the time this article is written. The only way to reconcile the data shown in Impac! is to retrieve both the total amount sold and the total amount purchased and calculate the difference between the 2 to get the gross margin.

    To that end you can use the Customer Invoices Report and Supplier Invoices Report, available in Reports > All Reports.Cesar Tonnoir (Unlicensed) I am not sure where to find the total sold and the total purchased in Xero. Can you help me?

    Image AddedImage Added

     

    See it in QuickBooks

    Same thing for QuickBooks: The gross margin has to be calculated manually using the Sales Transactions and Expenses Transactions reports available in Transactions > Sales / Expenses.

    Image AddedImage Added