Ecommerce Bookkeeping: Orders, Payouts and Cohorts

An ecommerce sale passes through several records: the order, any refund, payment fees, the payout and the bank deposit. Your bookkeeping also needs the cost of the product and other business expenses. Those records explain different parts of the result, so a dashboard showing profit does not necessarily tell you how much cash is available.

Start by following one order from sale to bank deposit, then compare the costs included in each profit report. The sections below show where Finaloop, Shopify and Triple Whale need different checks, including how to compare customer groups fairly.

Shopify helps store owners manage orders and the work after a sale. When Shopify Payments processes a sale, a payout transfers a group of payment transactions to the bank after fees, refunds and other adjustments. Other payment providers have their own payout records. Triple Whale helps ecommerce marketing and finance teams review advertising and profit measures; its dashboard is not the accounting books. Finaloop combines ecommerce accounting and finance services with inventory and customer-value reporting. A company profit-and-loss statement (P&L) shows the business’s revenue and costs for a period; bank records show which money actually arrived. The linked Shopify worked example below demonstrates the full charge-to-payout calculation.

Review customer cohorts at the same observed age

A customer cohort is a group of customers acquired in the same period. Finaloop's Lifetime value dashboard groups identified buyers so you can compare how much those groups spend and return over time. Select the platform icon as well as the store label, retain consistent filters on True LTV (lifetime value after product and delivery costs, before acquisition spending and fixed overhead, under the provider’s definition) and repurchase views, preserve the complete grid and note whether the report includes predictions. A restriction on business-to-business (B2B) exports does not imply that direct-to-consumer (DTC) cohort reports are absent.

Customer acquisition cost (CAC) is acquisition spending per new buyer. The provider’s CAC and profit measures have defined rules for assigning sales and costs, and for estimates. Read those before comparing them with campaign return on ad spend (ROAS), the revenue credited to a campaign per advertising dollar, or the company P&L.

M0 is the acquisition month; M1 is the next calendar month. M3 is the fourth calendar month, not exactly day 90. A young cohort with only M0 and M1 has no observed M3; that cell is unavailable, not zero. A weighted Average combines groups with different histories; keep the provider’s weighting method rather than assuming an average per buyer or per dollar. It is not a uniformly realized customer lifetime.

Fictional example, using invented USD profit per acquired buyer: cumulative profit is 80 at M0, 110 at M1 and 90 at M2 after later refunds, against CAC of 100. These ages and units are teaching conventions, not a Finaloop export. Profit crossed acquisition cost at M1 and later fell below it at M2. That is neither sustained recovery nor bank cash.

Compare the costs inside each profit measure

Triple Whale documents separate inputs for shipping, COGS, gateway costs and custom expenses. COGS means cost of goods sold. Gateway costs are payment-processing fees. Check their coverage and validity before comparing a dashboard profit measure with Finaloop True LTV or the company P&L. A missing or invalid cost input leaves the comparison unresolved.

Keep a cost table with product and landed cost, fulfillment, outbound shipping, payment fees, marketplace fees, advertising and shared overhead. Landed cost includes the product and costs such as freight and duties to bring it to the warehouse. Fulfillment is the work of picking, packing and delivering the order. Mark each category included, excluded or estimated for each report. Avoid counting a parent total and its child expenses together. Allocate a shared pool once: assigning more overhead to a channel changes that channel's result, not company profit. Compare cohorts at the same observed age before deciding that one acquisition period improved.

Preserve the formula before comparing "MER"

MER is an advertising-efficiency label, so keep the provider’s actual formula rather than assuming every dashboard calculates it the same way. The label alone is insufficient. Triple Whale's MER data dictionary defines the measure as blended ad spend divided by order revenue, expressed as a percentage. It calls the inverse, order revenue divided by blended ad spend, Blended ROAS. An export using a percentage and a spreadsheet using an x multiple can describe the same relationship while appearing to disagree.

Fictional example: $4,100 ad spend and $10,000 order revenue produce MER of 41% and Blended ROAS of about 2.44x. They are reciprocal measures, not two observations to average. Retain the provider's native formula, units, custom ad-spend inclusion and revenue adjustments before normalizing. The same formula can still use a different store, period or order population.

Neither measure subtracts every operating cost or establishes available cash. Use the cost-inclusion table above to test contribution, meaning revenue less the variable costs included in that calculation, not full company profit. For funding, separately show which payouts reached the bank and which payments the business still owes. This distinction gives the owner a concrete next step: resolve a definition mismatch before cutting a campaign, and resolve missing costs before calling the campaign profitable.

{
  "fictional": true,
  "unit": "USD cents",
  "id": "margin-basis",
  "comparableGrossProfitCents": 500000,
  "apparentGrossProfitAfterReclassCents": 800000,
  "companyProfitChangeFromReclassCents": 0,
  "bookProfitWithSeparateInventoryExpenseCents": 400000,
  "bookProfitAfterInventoryCorrectionCents": 500000,
  "profitDepressionFromPrematureInventoryExpenseCents": 100000,
  "capitalizationCorrectionRaisesProfitCents": 100000,
  "inventoryAssumption": "Separate purchase-period book scenario: unsold inventory was expensed outside the sold materials input; other operating expenses held at zero; not tax method advice",
  "limitation": "This is teaching arithmetic from supplied invented inputs, not source authenticity, financial assurance or authority to post."
}

Check whether the profitable cohort funds the next purchase

Customer payback does not show whether cash is available for the next inventory purchase. Check the cash actually received, stock purchases already paid or due, and upcoming payroll and other obligations. Timing can leave a profitable business short of cash. Review sales without profit and the next funding decision when the next question concerns that workflow. The Financial Systems Field Guide holds the system-specific report instructions, common problems and prompts with clear limits.

Build a cost-definition bridge before comparing profit

Put the source definition beside each number. An attribution dashboard, which assigns credit for sales to marketing channels, a customer-cohort report and a company P&L can include different advertising records, returns and delivery costs. An unexplained difference is a question to trace, not evidence that one platform is wrong.

Use the cost-definition worksheet to record the source, included costs, population and remaining uncertainty. Keep observed refunds separate from provisional recent-period estimates. Keep company overhead and unassigned marketing visible rather than quietly allocating them to a selected channel.

Then run the Finaloop same-age cohort example and the Shopify payout example. They answer different questions: what the selected buyers contributed at an observed age, and what a particular payout should transfer. Neither calculation alone establishes company profitability or bank reconciliation.

Sources and method

Field Guide; Finaloop LTV methodology; Shopify payout object. Product documentation checked October 6, 2026 where linked. Level guidance explains how to check whether the records support a financial conclusion; fictional arithmetic is visibly labeled and downloadable. No private customer documents or measured customer outcomes are included. Current account eligibility and report definitions must be checked before operational use.

Inventory and tax boundaries

On a capitalization-based book presentation, inventory is recorded as an asset while it remains unsold. Recorded inventory cost moves to cost of goods sold when the goods sell. Storage and other holding costs are generally period expenses. Tax inventory methods require separate advice; do not infer tax treatment from this book example.