E-commerce financial management turns marketplace, payment, inventory, return, tax, and bank data into reliable profit and cash information. The central problem is that a store’s order total rarely equals the bank deposit. Fees, reserves, refunds, chargebacks, tax, tips, gift cards, and timing create differences.
Build a transaction data map
For every channel, identify the order system, payment processor, bank account, inventory record, tax engine, and general ledger. Assign one source of truth for order ID, payment ID, settlement ID, SKU, tax, and refund. Preserve timestamps and currency.
Reconcile gross sales to deposits
Do not record the net bank deposit as revenue. Reconstruct each settlement:
Gross captured sales + other receipts − refunds − chargebacks − processor fees − reserves withheld = net payout.
Then match the payout to the bank and post each component to the correct account. Investigate missing orders, duplicate payouts, unexpected fees, and refunds that cross accounting periods.
| Example settlement | Amount |
|---|---|
| Gross product sales | $10,000 |
| Refunds | ($600) |
| Processor and platform fees | ($420) |
| Reserve withheld | ($300) |
| Bank payout | $8,680 |
This example is simplified; sales tax collected and shipping income or cost may require separate treatment.
Measure contribution by order and channel
Track sales less discounts, returns, product cost, outbound and return fulfillment, payment fees, channel fees, and directly attributable marketing. This contribution view shows why revenue growth can coexist with falling cash.
Allocate shared overhead separately and consistently. Avoid presenting an arbitrary allocation as if it were an order-level cash cost.
Control inventory and returns
- Reconcile units ordered, shipped, returned, damaged, and on hand.
- Document cost-flow and landed-cost policies.
- Count high-risk inventory more frequently and investigate shrinkage.
- Estimate return liabilities and obsolete stock when applicable.
- Separate gift-card cash from recognized revenue until obligations are satisfied under the applicable rules.
Handle tax and currency deliberately
Sales-tax, VAT, marketplace-facilitator, nexus, and filing duties depend on jurisdiction and facts. Map who collects and remits, retain reports, and reconcile liabilities. For foreign-currency sales, record the transaction and settlement rates and identify exchange gains, losses, and conversion fees.
Adopt a close calendar
Daily or weekly, reconcile payouts and high-volume exceptions. Monthly, close bank and processor balances, refunds, chargebacks, inventory, payables, tax liabilities, deferred items, and foreign exchange. Review channel contribution, cash conversion, return rate, inventory aging, and concentration.
Use the criteria in How to Choose Accounting Software when selecting connectors, and connect the close to the company’s cash management process.
Frequently asked questions
Why does store revenue not equal bank deposits?
Payouts can be net of refunds, chargebacks, fees, reserves, taxes, and timing differences. Reconcile gross activity to each settlement.
Should sales tax collected be revenue?
Generally, amounts collected on behalf of a taxing authority are tracked as liabilities, but the applicable law and platform arrangement determine treatment.
How often should payouts be reconciled?
High-volume businesses often reconcile daily or weekly, with a complete month-end close. The cadence should catch errors before records become difficult to trace.
Sources reviewed
Last reviewed: August 15, 2026. General education only; accounting, revenue, inventory, and tax treatment depends on facts and applicable standards.