Income Statement right now is only available for merchant with Master Product feature, please confirm first if you have Master Product access in your Genie.

This report provides you with profit and loss statistics over a period of time-based on changes in orders and SKU Stocks associated with Product Masters that have been synced with Genie.

Please be noted :

  1. Since SKU Stock itself does not have a channel attribute, when filtering by channel or store, the quantity value associated with the stock will not change.

2. Operational Income only counts the finished order

3. Tokopedia and Shopify orders are limited by API, so commission information cannot be obtained. Set the order-setting commission before using the income statement.

Operation IncomeIncome = Sales Amount-Discount-Promotion-Coins
Sales AmountOrder Create Time = Sum of Amount and Subtotal on the Selected date
DiscountOrder Create Date = Sum of Promotion on the Selected Date
PromotionOrder Create Date = Sum of Voucher amount on the Selected Date
CoinOrder Create Date = Sum of Coin on the Selected Date
Non-Operation IncomeNon-Operating Income = Shipping Fee + Rebate + Stock Movement (+)
Shipping FeeOrder Create Date = Sum of Shipping Fee and Shipping Fee paid by System on the Selected Date
RebateOrder Create Date = Sum of Rebate on the Selected Date
Inbound StockInbound Order Record Date = Inbound stock quantity * Cost Price on the Selected Date
Operating ExpenseOperating Expense = Cost of Good Sold (COGS)
Cost of Good Sold (COGS)Outbound Order Record Date = Outbound stock quantity * COGS Average Price on the Selected Date
Non-Operating ExpensesNon-Operating Expenses = Insurance + Tax
InsuranceOrder Create Date = Sum of Insurance Fee on the Selected Date
TaxOrder Create Date = Sum of Tax on the Selected Date
Other ExpensesOther Expenses = Service Fee + Commission Fee + Cashback + Refund Fee + Outbound Stock
Service FeeOrder Create Date = Sum of Service Fee on the Selected Date
Commission FeeOrder Create Date = Sum of Commission Fee on the Selected Date
CashbackOrder Create Date = Sum of Cashback on the Selected Date
Refund FeeOrder Create Date = Sum of Return Refund Amount on the Selected Date
Outbound StockInbound Order Record Date = Outbound stock quantity * COGS Average Price on the Selected Date
Net Profit/Income StatementNet Profit/Income Statement=Operating Income + Non-Operating Income – Operating Costs – Non-Operating Expenses – Other Expenses