The Payout Never Equals the Revenue: An E-Commerce Close

Start every close by reconciling gross sales in the order system against the net payout, itemizing processing fees, refunds, and chargebacks separately rather than accepting the payout figure as revenue. A brand that books the payout amount directly as revenue is quietly understating gross sales and overstating what fees actually cost, which distorts both the top line and the real cost of accepting payments.

Say a $50,000 payout lands in the bank but gross sales for that same window were actually $58,000, with $6,000 in processing fees and $2,000 in refunds accounting for the difference, so booking the $50,000 directly as revenue instead of reconciling it against the gross figure means your income statement never shows the true cost of accepting payments, which makes it harder to notice if that fee percentage creeps up over time.

A returns reserve set at close is an estimate of expected future returns on sales already recognized, and it needs to be trued up against actual return merchandise authorization data once it catches up, usually with a lag of several weeks. A reserve that's never revisited against real RMA data drifts further from reality every cycle, either overstating liabilities or, more dangerously, understating them right before a busy return season.

A reserve that consistently runs too low right before a known return-heavy period, the weeks after a holiday sales spike, for example, is a predictable miss, not a surprise, and it's worth adjusting the reserve rate seasonally rather than using one flat percentage all year.

Gift cards sold create a liability, not revenue, until they're actually redeemed, and unredeemed balances can sit on the books for years. Treating gift card sales as revenue at the point of sale overstates the current period and understates a real future obligation that a growing brand can lose track of if it's buried inside general deferred revenue.

A brand running a large gift card program during the holidays, then seeing that balance barely move through the following months, should treat the size and age of that liability as something to actively monitor rather than a number that simply sits quietly on the balance sheet. A growing, aging gift card balance is real cash the brand is holding on behalf of customers, and it deserves the same attention as any other significant liability.

A brand selling through its own storefront plus one or two marketplaces is reconciling several settlement files with different formats, fee structures, and payout timing every month. Tie each channel out on its own line before rolling them into a combined view, since a single combined number hides which channel's fees or return rate is actually the problem.

Marketplace fees rarely break down as one flat percentage the way a payment processor's fee does. A brand selling through a marketplace is typically charged a referral fee on the sale price, plus separate fulfillment and storage fees if the marketplace is warehousing inventory, and each of those deducts from the payout on its own line rather than as a single blended rate.

Say your marketplace payout report groups everything into one net number with no breakdown by fee type. Reconciling against gross sales that way tells you total fees moved, but not whether the increase came from a referral rate change, a storage fee spike during a busy season, or a rise in fulfillment costs, so pull the itemized fee report before you accept the payout figure as fully understood.

A brand selling primarily through its own storefront, with a manageable order volume and a single payment processor, does well on FloQast. Retailers in this general category run accounts payable of roughly 43.4 days on average¹, and a young brand well outside that range on its own vendor payments is often carrying a cash timing issue worth investigating alongside the sales-side reconciliation.

A brand selling across its own storefront and multiple marketplaces, each with its own settlement schedule and fee structure, benefits from BlackLine's stronger matching once reconciling every channel by hand each month becomes the actual bottleneck in the close.

Confirm that your order management system and your accounting system agree on the definition of a sale, at checkout, at shipment, or at delivery, before configuring either FloQast or BlackLine around that number. A brand that automates a reconciliation checklist on top of two systems using different recognition points just automates a discrepancy that used to at least get caught by a human reviewer doing the math manually.

Before configuring either tool, confirm these points:

• Your order management system and accounting system use the same definition of a sale: at checkout, at shipment, or at delivery.
• Fees, refunds and chargebacks are itemized separately from the net payout instead of being booked straight to revenue.
• The returns reserve gets trued up against actual return merchandise authorization data once it catches up.
• Gift card liability sits on its own line, and each sales channel's settlement file is tied out separately.