Ecommerce Accounting Guide: Inventory, COGS, Sales Tax and Cash Flow

Ecommerce accounting becomes difficult when sales happen in several channels, cash arrives net of processor fees, inventory moves before accounting entries catch up, and sales-tax obligations vary by state. A clean system must reconcile orders, payouts, inventory, cost of goods sold, refunds, fees, and tax without treating a bank deposit as revenue.

Start with the order-to-cash reconciliation

For Shopify, Amazon, marketplaces, and payment processors, the deposit hitting the bank is often net of fees, refunds, reserves, and taxes. Reconcile gross sales and adjustments to the payout report before matching the net deposit to cash.

Inventory and COGS drive real margin

If inventory is expensed when purchased rather than when sold, gross margin can swing wildly. Ecommerce reporting should have a defined inventory method, landed-cost policy, cutoff process, and regular reconciliation between the accounting ledger and the inventory source system.

Accounts every ecommerce business should watch

• Inventory
• Cost of goods sold
• Processor and marketplace clearing accounts
• Merchant fees
• Refunds and returns
• Gift card or store-credit liabilities
• Sales tax payable
• Shipping income and fulfillment expense
• Chargebacks and reserves

Sales tax nexus requires a state-by-state process

Economic nexus thresholds vary by state, and marketplace-facilitator rules can change which sales the merchant must collect on directly. Streamlined Sales Tax maintains state guidance, but each state's own revenue department remains the controlling source. Build a recurring process to monitor where sales, inventory, employees, or other activity create obligations.

Build a channel-level profitability view

A blended company gross margin can hide unprofitable channels. Where data quality allows, separate product revenue, discounts, returns, COGS, marketplace fees, payment fees, fulfillment, and shipping by channel. This helps management distinguish a revenue problem from a margin problem.

Ecommerce month-end close checklist

1. Import and reconcile each sales channel.
2. Reconcile processor and marketplace payouts to bank deposits.
3. Review returns, refunds, disputes, and reserves.
4. Reconcile inventory quantities and valuation.
5. Record COGS and landed-cost adjustments.
6. Reconcile sales-tax liabilities.
7. Review channel margin and inventory aging.

Turn the numbers into a decision system

If your deposits reconcile but gross margin, inventory, or sales tax still feels uncertain, Explore ecommerce bookkeeping can help you build a cleaner monthly finance rhythm and give leadership numbers they can act on.

Build an ecommerce close around the data sources

The close should list each channel and processor as a separate reconciliation task. For every source, finance should know where gross orders come from, where refunds and fees are reported, how sales tax is represented, and how the final payout reaches the bank. This map is especially important when a brand adds marketplaces quickly.

Watch inventory aging as well as inventory value

Slow-moving stock can consume cash long before it becomes an accounting write-down. Pair the inventory balance with units on hand, days of supply, aged inventory, and purchase commitments. The CFO view should connect merchandising decisions to the cash forecast.

Separate contribution margin from gross margin

Gross margin usually stops at product cost, while contribution margin can include variable payment, marketplace, fulfillment, and shipping costs. Define the measure clearly and use it to compare channels or campaigns without confusing it with the accounting gross margin line.

A deeper operating framework for ecommerce accounting that reconciles channels, inventory, tax, and cash

For ecommerce accounting that reconciles channels, inventory, tax, and cash, the most useful finance work is the work that changes a recurring decision. If bank deposits are posted directly to revenue or marketplace fees are netted inconsistently, the answer is usually not another isolated spreadsheet. The better approach is to define the source data, assign ownership, review exceptions on a schedule, and make the output part of the company’s normal operating rhythm.

Signals that the current process needs attention

In ecommerce accounting that reconciles channels, inventory, tax, and cash, one unusual month may not mean much. A pattern of inventory balances do not tie to operational systems or COGS changes sharply without a clear driver is more useful evidence that the workflow needs attention. Review the pattern across several cycles before deciding whether the issue is data quality, timing, ownership, or the underlying economics of the business.

• Bank deposits are posted directly to revenue
• Marketplace fees are netted inconsistently
• Inventory balances do not tie to operational systems
• COGS changes sharply without a clear driver
• Sales tax is mixed into revenue
• Refunds and chargebacks are difficult to trace

If several signals appear together, prioritize the ones most likely to distort gross sales to net revenue bridge or processor clearing. Fix the highest-impact handoff first, prove that the new control works for a full cycle, and then move to the next weak point rather than trying to rebuild everything at once.

Metrics that make the process measurable

For ecommerce accounting that reconciles channels, inventory, tax, and cash, more metrics are not automatically better. Start with measures that clarify whether the process is becoming more reliable and whether leadership can act earlier. In practice, gross sales to net revenue bridge and processor clearing often provide a useful starting view, supported by the additional measures below.

Gross sales to net revenue bridge

Reconcile orders, discounts, refunds, taxes, and channel adjustments to the amount recorded in the books. Review the trend monthly and note the operational reason for any material change.

Processor clearing

Tie each payout to gross activity, fees, refunds, reserves, and deposits so revenue is not recorded at the net bank amount. Keep the definition stable so one period can be compared with the next.

Inventory reconciliation

Compare accounting inventory with the operational inventory source and investigate material differences. Assign one owner for the source data and one reviewer for the finished measure.

Gross and contribution margin

Separate product cost from variable fulfillment, marketplace, payment, and shipping economics. Where possible, connect the measure to an action threshold rather than reporting it passively.

Inventory aging

Track slow-moving stock and purchase commitments because working capital risk appears before an accounting write-down. Reconcile the measure to source systems or the ledger when that connection is relevant.

Channel cash conversion

Measure how quickly sales from each channel convert into available cash after reserves, fees, and return timing. Use the metric to start a discussion, not to replace judgment about the underlying business.

An example of how this plays out in practice

An online brand records a $92,000 marketplace deposit as revenue because that is what hit the bank. The marketplace statement shows $110,000 of customer sales, plus tax collected, refunds, fulfillment charges, advertising deductions, and platform fees. Posting the net deposit destroys margin visibility and can misstate tax and revenue. A proper reconciliation books the components separately, clears the marketplace receivable or clearing account, and ties the final net amount to the bank.

For ecommerce accounting that reconciles channels, inventory, tax, and cash, the example shows why timing matters. The finished report is useful, but the larger value comes from producing a signal early enough to change a decision. If management only learns about the issue after the close, filing, payroll run, or board meeting, the information may be accurate but still arrive too late to be fully useful.

A practical 30-60-90 day implementation plan

Days 1-30: establish the baseline

Start by mapping how gross sales to net revenue bridge and processor clearing are produced today. Identify the source reports, the person who prepares them, the person who reviews them, and any spreadsheet or manual step in between. At the same time, investigate the first two warning signs above: bank deposits are posted directly to revenue and marketplace fees are netted inconsistently. The purpose of the first month is to understand the real workflow before trying to automate or redesign it.

Days 31-60: standardize ownership and review

Turn the baseline into a recurring checklist. Set cutoffs, create a standard file or dashboard structure, and document what evidence supports inventory reconciliation and gross and contribution margin. Decide what can be resolved by the preparer, what requires a reviewer, and what must be escalated to leadership or an outside tax, legal, or accounting adviser. Run the new process through a complete cycle and record every exception instead of solving it only in someone’s inbox.

Days 61-90: connect the process to decisions

By the third month, leadership should be using the output rather than simply receiving it. Put inventory aging and channel cash conversion into the relevant weekly or monthly discussion. Compare expectations with actual results, assign an action when a threshold is missed, and remove reports that no one uses. This is the point where a finance process becomes an operating system instead of an accounting exercise.

Common mistakes that reduce the value of the work

Booking net payouts as revenue

Instead of booking net payouts as revenue, define the scope, owner, and recurring deliverable so the expected result is clear before the next cycle begins.

Leaving sales tax inside the revenue line

When the team is leaving sales tax inside the revenue line, trace the problem back to the source report or handoff. Correcting only the visible month-end symptom usually allows the issue to return.

Relying on inventory value without checking units and aging

Treat relying on inventory value without checking units and aging as a process-design problem. Write down the decision rule and apply it consistently across teams, periods, and outside providers.

Comparing channel profitability before defining shared cost treatment

If the current habit is comparing channel profitability before defining shared cost treatment, move the review earlier. The best control catches the issue before it reaches the final report, filing, payroll run, forecast, or board pack.

Ignoring returns, reserves, and chargeback timing in cash forecasts

A one-time correction does not fully solve ignoring returns, reserves, and chargeback timing in cash forecasts. Add a repeatable check that makes the same error less likely in the next month or quarter.

Questions leadership should ask before calling the process complete

For ecommerce accounting that reconciles channels, inventory, tax, and cash, one clean month or one polished dashboard is not enough evidence that the process is durable. Leadership should be able to answer the following questions using documented sources and named owners rather than relying on one person’s memory:

• Which report is the source of gross orders by channel?
• How are processor and marketplace payouts reconciled?
• Where is sales tax recorded?
• How often is inventory tied between systems?
• What costs are included in gross versus contribution margin?
• Which channels create the longest cash-conversion cycle?

If several answers remain unclear, investigate the handoff behind inventory reconciliation and gross and contribution margin first. The missing piece is often ownership, source-data quality, or review cadence. Outside finance support is most valuable when it closes those gaps and leaves the company with a process the internal team can understand and repeat.

How to keep the improvement from fading after the first quarter

Revisit the ecommerce accounting that reconciles channels, inventory, tax, and cash workflow at least quarterly and whenever the business changes materially. New products, locations, entities, financing, systems, or customer behavior can make an old control less useful. Pay special attention to repeated exceptions involving inventory aging, late tasks, manual workarounds, and measures that leaders have stopped trusting. Update the procedure deliberately while preserving definitions that need period-to-period comparability.

Keep documentation proportionate to the risk. Material balances, tax positions, payroll obligations, investor metrics, revenue policies, and major forecasts deserve a clearer audit trail than immaterial administrative items. For ecommerce accounting that reconciles channels, inventory, tax, and cash, that balance keeps the finance function rigorous enough to support decisions without turning routine work into unnecessary bureaucracy.

Frequently asked questions

Should ecommerce deposits be recorded as sales?

Not directly. Deposits are often net of fees, refunds, tax, reserves, and other adjustments. Reconcile the payout detail so revenue and expenses are recorded correctly.

How often should inventory be reconciled?

At least monthly for management reporting, with cycle counts or physical counts based on operational needs and inventory risk.

Does a marketplace collect all sales tax for me?

Marketplace-facilitator laws cover many marketplace transactions, but obligations vary by state and channel. Direct sales and other business activity can still create registration and filing requirements.