A Practical Guide to a Financial Copilot for Ecommerce

Every example and amount on this page is illustrative. It shows the method and is not a benchmark, a quote or advice.

What a Financial Copilot Is, and Is Not

A financial copilot for ecommerce is an AI-assisted decision layer over the data a store already generates: ecommerce orders and products, marketing spend, payment activity, inventory, and finance records. It brings those sources into a shared view, applies defined calculations, and explains what the numbers mean for a product, collection, customer, or trading period. The aim is not to create another report. It is to help an operator move from a question to a defensible answer.

That makes a copilot different from a dashboard. A dashboard displays selected metrics, such as revenue, orders, or ad spend. A copilot can relate those figures, identify the relevant measure, show its basis, and answer a question about the merchant’s own data. For example, revenue may be useful for tracking sales volume, while contribution after advertising is the measure to use when deciding whether a product’s paid acquisition is economically viable. ORVX provides this kind of ecommerce financial analytics, including product- and collection-level profitability rather than revenue alone.

It is also not a bookkeeping system. Bookkeeping records and classifies financial transactions for accounting purposes. A copilot uses financial information alongside operational and commercial data to analyse performance. It should not replace reconciliation, accounting controls, or the source records that finance teams rely on.

Finally, “copilot” does not mean autonomous decision-maker. A reliable system reports the calculation, assumptions, reason, and confidence so a person can decide. ORVX may surface a recommendation such as scale, reduce, fix economics, test, or stop, computed from the store’s own numbers. It does not change prices, bid on ads, reorder stock, fulfil orders, issue refunds, or take another action in the store. The ORVX commerce intelligence platform reads and reports; the operator remains accountable for the decision.

What a Financial Copilot for Ecommerce Actually Measures

Each measure answers a different operating question. Net revenue asks, “What sales did we actually keep?” It starts with order value and removes refunds, returns, cancellations, and other reductions. For an ecommerce operator, delivered orders are the reliable starting point; counting a returned order as revenue overstates every downstream margin. ORVX calculates realized revenue from delivered orders only and keeps each merchant’s trading currency separate.

Gross profit asks, “What remains after making or buying the products?” It compares net revenue with cost of goods, using the merchant’s product cost model. This is useful for assessing product pricing, assortment, and supplier economics before marketing costs enter the picture. A store can have strong gross profit and still lose money acquiring customers.

Contribution profit asks, “What remains after the variable costs required to generate these sales?” In this comparison, advertising is the critical additional deduction. Contribution margin expresses that remainder relative to net revenue, so it allows products, collections, and periods of different sizes to be compared. ORVX reports contribution after advertising at product and collection level, rather than stopping at revenue or gross profit.

Customer acquisition cost (CAC) asks, “What did it cost to add a new customer?” It relates acquisition spend to newly acquired customers, making it relevant when deciding whether to scale a channel or campaign. It should be read alongside attributed ROAS and MER: attributed ROAS uses an attribution view, while MER compares total advertising spend with total store revenue. Cash impact asks a different question: “What changed in the bank account, and when?” Payout timing, ad charges, refunds, inventory purchases, and payment fees can make cash movement differ from accounting profit. A financial copilot for ecommerce therefore needs all six views, not one headline number; ORVX’s ecommerce financial analytics keeps profitability, advertising, returns, and inventory context together.

The Formula, Stated Plainly

Contribution profit answers a narrower question than sales: after the costs that rise with each order, and the advertising used to acquire it, what remains? A plain formula is:

Contribution profit = realized revenue − product cost (COGS) − variable order costs − advertising spend. Variable order costs can include payment processing, marketplace fees, packaging, pick-and-pack, shipping subsidies, and return shipping or restocking fees where those costs apply. Refunds and cancelled orders should not be deducted twice: if realized revenue already excludes them, they are not revenue in the starting figure.

Contribution margin puts that result on a comparable basis: contribution profit ÷ realized revenue × 100. A store should state whether its contribution figure includes advertising. For decisions about scaling acquisition, “contribution after advertising” is the useful version. A pre-ad contribution figure can still help assess the underlying product economics, but it should not be mistaken for the profit left after acquisition.

This is different from gross profit. Gross profit = realized revenue − COGS. Gross profit therefore shows what remains after making or buying the product, before payment, fulfilment, returns, marketing and other variable selling costs. Use it to assess product cost, pricing and assortment economics; use contribution profit when deciding whether the order or customer is economically worth acquiring.

ROAS is not a profit formula. ROAS = attributed ad revenue ÷ ad spend. If attributed revenue is $10,000 and spend is $2,000, ROAS is 5.0x. It says nothing by itself about COGS, fulfilment or fees, and attributed revenue may not match realized revenue. Use ROAS to evaluate attributed advertising efficiency, then check contribution after advertising before treating a campaign, product or collection as profitable. Ecommerce Financial Analytics keeps these measures separate.

A Worked Example From Order to Contribution Profit

Take one month in the store’s trading currency. The store records $20,000 in gross order sales, but $1,500 is refunded for returned items. Realized net sales are therefore $18,500. The calculation should use delivered orders only, so cancelled and returned orders do not remain in revenue.

The cost lines then answer different operating questions. Product cost shows what the merchandise itself consumed. Fulfillment covers pick, pack and shipping. Payment fees are calculated here as 3% of net sales: $18,500 × 3% = $555. Advertising is kept separate because it measures acquisition cost rather than the physical cost of serving an order.

The result is $4,545 of contribution profit, or 24.6% of net sales: $4,545 ÷ $18,500 = 24.57%. That is the figure to use when deciding whether the period generated enough after variable costs and advertising. Gross profit would stop before fulfillment, payment fees and advertising; net profit would also include costs outside this order-level view. A financial copilot for ecommerce should show those measures separately rather than label every remaining dollar profit. ORVX can calculate the same view by product or collection, so a positive store-level margin does not hide an unprofitable product.

The Mistakes That Make the Number Wrong

Gross revenue is an order-volume measure, not the amount the business kept. If a store records $20,000 in orders, then refunds $1,500 and cancels $500, the realized revenue is $18,000 before other adjustments. Using $20,000 to calculate margin makes every percentage look better than it is. Gross revenue is useful for tracking demand; realized revenue is the right base for profitability and cash decisions. A financial copilot for ecommerce should make that distinction explicit rather than quietly substituting one for the other.

Tax treatment creates another silent error. One channel may report prices tax-inclusive while an accounting export reports sales before tax. Comparing $10,000 including 20% VAT with $10,000 excluding VAT does not compare equal sales: the tax-exclusive value of the first figure is $8,333. Mixing currencies creates the same problem. A valid comparison keeps each merchant’s trading currency consistent and labels whether tax is included or excluded (Source: GOV.UK).

Returns, refunds and shipping need their own treatment. A $60 order with a $10 refund is not $60 of retained revenue. If delivery costs $7 and return shipping costs $5, omitting those costs overstates the order’s contribution by $12. Shipping charged to the customer may offset part of that amount, but it should not be assumed to equal the fulfilment cost. Return rate by units and refund value against revenue answer different questions, so both can matter.

Allocating fixed costs evenly across products can also produce a false ranking. If $4,000 of monthly software and rent is divided across 1,000 orders, each order appears to carry $4 of overhead. That allocation may be useful for a full-period net-profit view, but it should not decide whether a product-level campaign is scaled. Contribution after variable costs and advertising is the more direct measure for that decision; allocated fixed costs belong in the broader business view.

Finally, timing differences can make a correct calculation look inconsistent. Ad spend may post daily, orders may arrive before fulfilment, and refunds may appear weeks later. A dashboard that combines yesterday’s spend with last month’s settled revenue can create a misleading return. ORVX connects Shopify orders, products and customers with advertising data, and calculates realized revenue from delivered orders only. The ecommerce financial analytics view is useful only when the reporting period, tax basis, currency and source timestamps are aligned.

What to Do With the Answer

Use the measure that matches the decision, not the most flattering number. A campaign can show strong attributed ROAS while leaving little contribution profit after product cost, fulfilment, refunds and advertising. Conversely, a channel with lower ROAS may produce more total contribution because it drives higher-margin orders.

Separate the decision from the diagnosis. Margin and gross profit explain product economics; contribution profit tests whether an order remains worthwhile after acquisition; cash data sets the constraint on what the business can fund now.

• Campaigns and channel allocation: use attributed ROAS to compare tracked ad efficiency, MER to assess total advertising against store revenue, and contribution profit to decide whether scaling leaves money after variable costs. Use CAC when the question is the cost to acquire a customer, especially alongside repeat behaviour.
• Pricing: use gross profit and gross margin to see how a price change affects each unit before advertising. A $5 price increase on 100 units adds $500 to revenue, but only the portion left after product and other variable costs is relevant.
• Promotions: use contribution profit, not revenue or ROAS alone. A $20 discount on 50 orders costs $1,000 before considering any incremental demand; the promotion needs enough additional contribution to justify it.
• Inventory: use gross profit by product, return rate, dead stock and remaining stock value to decide what needs attention. Cash data matters when stock ties up funds or a purchase would strain near-term liquidity.
• Channel allocation: compare contribution by product or collection and customer profitability, then check cash capacity before moving budget. The answer should state the reason and confidence, rather than imply that a metric alone settles the next decision.

A financial copilot is useful when it turns connected ecommerce data into a traceable economic answer, not when it produces another unexplained score. Start with a clearly defined contribution-profit formula, validate every input, and match the measure to the decision: margin for efficiency, contribution profit for scalable growth, and cash for commitments the business must fund.

General information only: tax, duty and import rules change and depend on your situation, so check with an accountant or the official source before acting.