Columns of the Invoice Revenue By Group report
The Invoice Revenue By Group report shows many different columns in its output. It is important to know which types of information each column has.
| Column name | Information shown |
|---|---|
| Quantity Sold | Shows the total number of invoiced products. ezyVet uses the Qty value of each invoice line item to calculate the data. |
| Total Cost | Shows the total of the cost price of all invoiced products. To calculate the this data, ezyVet uses the Pricing (Per Unit) Cost value that is set for each product. If the Pricing (Per Unit) Cost value of a product changes, ezyVet calculates the historic reports again to show the new cost price of products. |
| Markup | This column shows the markup as a dollar value. To calculate the markup, ezyVet subtracts the total cost price of all invoiced products from the total sell price of all invoiced products. The column only shows data of products that have the Has Direct Cost (Has Markup) configuration property set to Yes. |
| Markup % | This column shows the markup as a percent value. To calculate the markup, ezyVet subtracts the total cost price of all invoiced products from the total sell price of all invoiced products. The column only shows data of products that have the Has Direct Cost (Has Markup) configuration property set to Yes. |
| Discount | Shows the total dollar quantity discounted of all invoiced products. ezyVet uses the Disc.($) value of each invoice line item to calculate the data. |
| Total Revenue w/ Markup | |
| Total Revenue Excl. Dispense Fees | Shows the total value minus the dispense fees of all invoiced products. To calculate this data, ezyVet subtracts the Dispense($) value of a given invoice line item from the Total($) value of the invoice line item. To include tax information in the data, set the Include GST setting of the report to ON. |
| Dispense Fees | Shows the total of all dispense fees of all invoiced products. ezyVet uses the Dispense($) value of each invoice line item to calculate the data. To include tax information in the data, set the Include GST setting of the report to ON. |
| Total Revenue | Shows the total revenue of all invoiced products. The total includes dispense fees. ezyVet uses the Total($) value of each invoice line item to calculate the data. To include tax information in the data, set the Include GST setting of the report to ON. |
| Average Unit Price | Shows the average price of all invoiced products. The data does not include dispense fees. To calculate the data: To include tax information in the data, set the Include GST setting of the report to ON.
|
| Total Earned | Shows the total value of revenue that is available to calculate staff commission. Note: ezyVet only shows this column if you set Include Earned/Commission to ON in the report settings.
Note: Use the Total Earned value to calculate staff commission. Do not use the Total Revenue value.
ezyVet uses the Earned($) value of each invoice line item to calculate the data. To include tax information in the data, set the Include GST setting of the report to ON. The Total Earned value is the same as the Total($) value of an invoice line item unless the invoiced product has one of two possible conditions. The conditions are as follows.Condition 1: The invoiced product is related to a client’s wellness plan. In this condition, the Earned($) value of the applicable invoice line item uses the Earned Value Estimate values in the configuration of the wellness plan. Condition 2: The invoiced product has the Excluded From Staff Sales Figures property in its configuration set to Yes. In this condition, the Earned($) value of the applicable invoice line shows $0.00. |
| Price Commission | Shows the dollar value of the staff commission that is related to all invoiced products. ezyVet uses the Earned($) value of each invoice line item to calculate the data. The data does not include service fees. Note: ezyVet only shows this column if you set Include Earned/Commission to ON in the report settings. |