Questions about Revenue and Profit

Question 1. What is the formula for calculating order profit when using the Inventory Module in Getfly?

Order Profit = Quantity × Selling Price - Product Discount - Order Discount + Installation Fee (if any) - Quantity × Cost of Goods Sold (COGS) from warehouse (including gift products) - Quantity × Input Price for service products (entered in order details)

The COGS from warehouse is calculated as:

COGS = (Opening Stock × Opening Price + Incoming Stock × Incoming Price) / (Opening Stock + Incoming Stock)

Notes:

• COGS is calculated based on the inventory data at the time the product is dispatched.

For example, if the order is fulfilled in February, the COGS will reflect February’s data.

• You can check the COGS in the “Stock Movement Report” under the Outflow During Period column. COGS is calculated per warehouse — the system uses the COGS of the warehouse from which the item is dispatched. To calculate order profit, the order must be fulfilled (dispatched). If not, the system assumes COGS = 0.

• If only part of the order has been dispatched, the system treats the remaining products as having COGS = 0.

• Gift products are included in profit calculation, but their selling price is assumed to be 0.

• For service products, if the “Input Price” field is not filled, it defaults to 0.

• To enable the Input Price column, you must contact Getfly Support by submitting a ticket: https://wiki.getfly.vn/portal/post/1702

• Profit calculation excludes VAT and shipping fees.

Question 2. What is the formula for calculating order profit when not using the Inventory Module?

If the Inventory Module is not used, the system needs the Input Price column enabled in the order to calculate profit.

• Order Profit = (Quantity × Selling Price) - Product Discount - Order Discount + Installation Fee (if any) - (Quantity × Input Price)

Notes:

• You must request Getfly Support to enable the Input Price column via ticket: https://wiki.getfly.vn/portal/post/1702

• The Input Price should be entered for each product in the order.

• Gift products are not included in the profit calculation.

• Profit calculation excludes VAT and shipping fees.

Question 3. How to view order profit in Getfly?

To view order profit, your account must have the "Order Profit" permission.

Once granted, order profit is shown on the Order List screen (Sales → F4).

Question 4. What is the formula for calculating product profit when using the Inventory Module?

Product Profit = Quantity × (Selling Price - COGS) - Discount

Question 5. What is the formula for calculating product profit when the Input Price column is enabled?

Product Profit = Quantity × (Selling Price - Input Price) - Discount

Question 6. What is the formula for calculating product profit when not using the Inventory Module and Input Price is not enabled?

Product Profit = Quantity × Selling Price - Discount

Question 7. How to view product profit in Getfly?

To view product profit, your account must have the "View Product KPI Statistics" permission.

Once granted, go to KPI Statistics (F7) → Select Products → The profit information will be displayed in the Products Sold During the Period table.

Question 8. How to filter customer revenue over a specific time period?

To filter revenue by customer:

Go to Sales → Sales → Click Filter → Switch to the Customer tab

Search by customer name, phone number, or email → Click Apply

Then, choose the desired time range (this month, this quarter, this year, or custom period). The revenue is shown in the Total section.