By Vincent Howard, CPA | Managing Partner, Howard, Howard and Hodges | SkillAbility for Accounting Firms
Last updated: August 14, 2026 | 54-minute read
- What ecommerce accounting training means
- Why ecommerce demands specialized accounting fluency
- The COMMERCE framework
- Map the ecommerce business model and channels
- Order-to-revenue accounting
- Gross vs net revenue and marketplace relationships
- Payment processor and marketplace reconciliation
- Form 1099-K and gross payment reporting
- Inventory, COGS, and landed cost
- Inventory across warehouses and fulfillment partners
- Returns, refunds, chargebacks, and reverse logistics
- Economic nexus, marketplace facilitators, and sales tax
- Gross margin and contribution margin
- Shipping, fulfillment, and channel economics
- Advertising, CAC, and customer economics
- Gift cards, credits, discounts, and promotions
- Multi-currency and international complexity
- Ecommerce cash flow and working capital
- Tax-method and entity awareness
- Ecommerce KPIs that change decisions
- Run the monthly ecommerce economics review
- Build recurring ecommerce advisory
- AI and ecommerce accounting
- Worked ecommerce economics example
- 90-day firm implementation plan
- 30-day staff training curriculum
- 30/60/90 live-work progression
- 100-point readiness scorecard
- 15 realistic ecommerce scenarios
- What the CPA firm should measure
- Common ecommerce-training mistakes
- Frequently asked questions
An ecommerce owner says revenue is up 22% and asks why cash is down.
A generalist accountant sees higher inventory purchases, ad spend, and fulfillment fees.
An ecommerce-fluent accountant asks:
- Did order volume increase—or mostly average order value?
- Did channel mix shift toward a marketplace with higher fees?
- Are gross sales being confused with processor or Form 1099-K gross payments?
- Did discounts, returns, or chargebacks grow?
- Is inventory sitting longer or trapped at fulfillment partners?
- Did outbound shipping and pick-and-pack costs rise?
- Did customer acquisition cost increase faster than contribution?
- Did marketplace-facilitated sales grow while direct-channel sales created additional nexus obligations?
- Did the business buy holiday inventory months before collecting the related cash?
Ecommerce accounting becomes advisory-ready when staff can trace one order from checkout through revenue, settlement, inventory, tax, returns, contribution, and cash.
Who I Am and Why This Matters
I have practiced public accounting since 1990. I founded my accounting firm in 1993, merged it in 2001 to form Howard, Howard and Hodges, and helped grow the organization from three people to approximately 50 staff across multiple Florida locations and states. Our firm was named PASBA Firm of the Year in 2015.
Ecommerce is exactly the kind of niche where accounting staff can produce technically correct books and still misunderstand the business. A processor deposit can combine dozens or thousands of orders, refunds, fees, taxes, chargebacks, reserves, and timing differences. Inventory can exist in multiple warehouses, in transit, at a marketplace fulfillment center, or physically returned but not yet inspected. A marketplace may collect sales tax on some transactions while the seller remains responsible for direct-channel sales in the same state.
Since 2020, I have built and run the SkillAbility accounting workforce development platform, used by more than 1,000 accounting professionals across dozens of PASBA firms.
The development opportunity is to teach staff the ecommerce operating system before expecting them to interpret an ecommerce P&L.
Read Industry Specialization Training for Accountants for the broader niche-development model and Knowledge Transfer System for CPA Firms for transferring industry expertise beyond one partner.
What Is Ecommerce Accounting Training for Accountants?
Ecommerce accounting training develops an accountant’s ability to understand how online orders become revenue, payment settlements, inventory relief, sales-tax liabilities, returns, channel costs, contribution margin, and cash across websites, marketplaces, payment processors, warehouses, fulfillment partners, and advertising platforms.
Ecommerce accounting is not “bank-feed bookkeeping”
Staff need to understand the source systems behind the entries:
- Storefront / order-management platform
- Marketplace
- Payment processor
- Merchant acquirer
- Bank
- Inventory system
- Warehouse / 3PL
- Shipping platform
- Sales-tax platform
- Advertising platforms
- General ledger
The accountant should be able to explain why five numbers that look like “sales” are different
Those may include:
- Gross order value
- Net merchandise sales
- Marketplace gross payments
- Form 1099-K gross reportable payments
- Net cash settlement
Training should build both technical and operating fluency
The accountant should know when an issue is a:
- Revenue-recognition question
- Payment-reconciliation problem
- Inventory / cutoff problem
- Sales-tax problem
- Returns / reserve problem
- Margin problem
- Cash-flow problem
Why Ecommerce Demands Specialized Accounting Fluency
Ecommerce continues to outgrow total retail
The U.S. Census Bureau reported seasonally adjusted U.S. retail ecommerce sales of $326.7 billion in the first quarter of 2026, up 2.7% from the fourth quarter of 2025 and 9.8% from the first quarter of 2025. Total retail sales increased 3.9% year over year. Ecommerce represented 16.9% of total retail sales in the quarter.
Source: U.S. Census Bureau — Quarterly Retail E-Commerce Sales.
Ecommerce Is Growing Faster Than Total Retail
Source: U.S. Census Bureau, first-quarter 2026 seasonally adjusted estimates. The ecommerce-share bar is visually scaled to a 20% maximum for readability; it is not on the same scale as the growth bars.
Returns create a second transaction after the sale
The National Retail Federation’s 2025 Retail Returns Landscape projected $849.9 billion of retail merchandise returns for 2025 and estimated that 19.3% of online sales would be returned. The study also reported that 82% of consumers considered free returns important when shopping online.
Source: National Retail Federation — 2025 Retail Returns Landscape.
2025 NRF Return Estimates
Source: NRF and Happy Returns 2025 study. The online-return bar is visually scaled to a 20% maximum; the consumer-preference bar uses a 100% scale.
This changes what “revenue growth” means
An ecommerce company can report higher orders while also experiencing:
- Higher discounting
- More returns
- Higher shipping cost
- Higher marketplace fees
- Higher payment fees
- Higher ad spend
- More inventory
- More sales-tax registrations
That is why a niche accountant needs a full order-to-cash and order-to-margin model.
The COMMERCE Framework for Ecommerce Accounting Training
C-O-M-M-E-R-C-E
C — Channels and Customer Journey
Map direct website, marketplaces, wholesale, subscriptions, social commerce, international sales, fulfillment, and owner goals.
O — Orders to Revenue
Trace orders, shipping status, discounts, returns, gift cards, tax, and revenue-recognition questions.
M — Money and Settlement Reconciliation
Reconcile processor and marketplace gross payments, fees, refunds, reserves, chargebacks, and bank deposits.
M — Merchandise and Inventory
Understand landed cost, COGS, inventory in transit, warehouses, returns, obsolescence, and working capital.
E — Economic Nexus and Sales Tax
Track direct and marketplace sales by jurisdiction, thresholds, facilitator collection, registration, filing, and reconciliation.
R — Returns, Refunds, and Revenue Leakage
Measure refunds, return shipping, restocking, chargebacks, fraud, markdowns, and recovered inventory value.
C — Contribution by SKU, Order, and Channel
Move beyond gross margin to payment fees, fulfillment, outbound shipping, returns, marketplace fees, and advertising.
E — Evaluate Cash, Tax, and Next Decisions
Forecast inventory buys, settlements, sales tax, ad spend, vendor payments, debt, and owner distributions.
Map the Ecommerce Business Model and Channels
Start with where orders originate
Common channels include:
- Direct-to-consumer website
- Large marketplaces
- Wholesale / B2B portals
- Social commerce
- Subscription programs
- Retail pop-ups
- International storefronts
Then map who fulfills the order
Inventory may move through:
- Seller-owned warehouse
- Third-party logistics provider
- Marketplace fulfillment center
- Dropship supplier
- Multiple regional warehouses
Map the payment rails
The seller may receive cash from:
- Card processor
- Digital wallet
- Marketplace settlement
- Buy-now-pay-later provider
- Wholesale ACH / wire
Define the ownership and pricing model
An ecommerce accountant should know:
- Private label vs resale
- Owned inventory vs dropship
- Domestic vs imported products
- Freight and duty terms
- Return policy
- Shipping policy
- Discount strategy
- Subscription terms
- Marketplace dependence
This business map determines which reports matter and where margin can leak.
Order-to-Revenue Accounting
Order date, payment date, ship date, delivery date, and revenue date can differ
Staff should not assume an order becomes recognized revenue simply because a card was authorized or cash was received.
FASB Topic 606 establishes principles for revenue from contracts with customers and focuses on the nature, amount, timing, and uncertainty of revenue. Ecommerce businesses may need to evaluate when control of goods transfers, return rights, shipping terms, discounts, gift cards, subscriptions, and principal-versus-agent relationships.
Source: FASB — Revenue Recognition / Topic 606.
Build an order-status bridge
Common ecommerce revenue questions include:
- When does the customer obtain control?
- Does shipping represent a separate performance obligation?
- How should returns be estimated?
- How are gift cards and store credits treated?
- Is the seller principal or agent in a marketplace arrangement?
- How should subscriptions be recognized?
- How should discounts and coupons reduce revenue?
Keep operational reporting separate from GAAP conclusions
Gross merchandise value can be an important operating metric even when it is not the amount presented as GAAP revenue. Staff should label management metrics clearly and keep them reconciled to the general ledger.
Gross vs Net Revenue and Marketplace Relationships
A marketplace can create a principal-versus-agent question
FASB issued Topic 606 guidance specifically addressing principal-versus-agent considerations and whether revenue is reported gross or net. The accounting conclusion depends on the contractual relationship and control of the specified good or service—not simply which party processes the payment.
Source: FASB — ASU 2016-08, Principal versus Agent Considerations.
Do not infer gross or net presentation from the settlement statement
A marketplace may send the seller:
- Order proceeds
- Marketplace fees
- Fulfillment fees
- Advertising charges
- Refunds
- Chargebacks
- Storage fees
- Tax amounts
The net cash deposit is a settlement amount. It is not, by itself, the accounting answer for revenue presentation.
Use a marketplace reconciliation bridge
Then separately determine:
- Revenue recognized
- Sales tax liability
- Marketplace / fulfillment expense
- Refund / return treatment
- Cash receivable or reserve
Payment Processor and Marketplace Reconciliation
The processor is another subledger
A settlement should explain:
- Gross charges
- Refunds
- Disputes / chargebacks
- Processor fees
- Foreign exchange
- Reserves
- Timing differences
- Net deposit
Build a processor clearing account
One practical method is to use a clearing account so the accountant can reconcile expected processor receivables to actual bank deposits rather than treating every deposit as a standalone sale.
Reconcile by settlement date and source
A monthly total can hide:
- Missing settlements
- Duplicate deposits
- Unposted refunds
- Chargebacks
- Rolling reserves
- Foreign-currency conversions
Payment fees belong in margin analysis too
A 3% payment cost may be immaterial on a high-contribution product but significant on a low-margin, high-return SKU.
Form 1099-K and Gross Payment Reporting
Form 1099-K is not a revenue statement
The IRS states that Box 1a reports the gross amount of reportable payment transactions without adjustments for credits, refunds, fees, shipping, discounts, or other amounts. Ecommerce accountants therefore need to reconcile Forms 1099-K to source payment records and the client’s books—not force tax-return revenue to equal the form mechanically.
Source: IRS — Form 1099-K FAQs.
The current TPSO threshold returned to $20,000 and more than 200 transactions
IRS guidance updated after 2025 legislation states that third-party settlement organizations generally have a Form 1099-K filing requirement when gross reportable payments to a payee exceed $20,000 and the number of transactions exceeds 200. Payment-card transactions have no comparable de minimis dollar threshold.
Source: IRS — Understanding Form 1099-K.
A seller can receive multiple Forms 1099-K
That makes source-level reconciliation essential across:
- Direct card processor
- Marketplace A
- Marketplace B
- Digital wallet / app
Gross payment reporting can exceed accounting revenue
Reasons may include:
- Refunds
- Shipping amounts
- Sales tax
- Processor fees
- Marketplace fees
- Other gross-payment components
The accountant should retain a documented reconciliation for year-end review.
Inventory, COGS, and Landed Cost
Ecommerce inventory can consume cash long before it creates revenue
Build landed cost intentionally
Depending on the accounting framework and facts, inventory cost may involve:
- Purchase price
- Inbound freight
- Customs duties
- Brokerage
- Other acquisition costs
Do not confuse freight-in with outbound shipping
Inbound freight may be part of product cost under the applicable accounting policy. Outbound customer shipping is a separate fulfillment / selling economics question.
Tax methods for small businesses can differ from book inventory methods
IRS guidance provides special inventory-accounting options for qualifying small business taxpayers. Current IRS small-business guidance uses a $31 million average annual gross-receipts threshold for the 2025 tax year, indexed for inflation, and explains that eligible businesses may use certain methods based on nonincidental materials and supplies or their financial/book treatment. Tax-method elections and changes require facts-specific analysis.
Source: IRS Publication 334 — Inventory and Small Business Taxpayers.
Operational inventory reporting should still be rigorous
Even when a tax method permits simplification, management still needs:
- Units on hand
- Units available to sell
- Units in transit
- Units reserved
- Units returned
- Units damaged
- Units at 3PL / marketplace fulfillment
- Inventory age
Inventory Across Warehouses and Fulfillment Partners
Location matters
Inventory may be physically located at:
- Company warehouse
- 3PL
- Marketplace fulfillment center
- Supplier under dropship arrangement
- International warehouse
- In transit between facilities
Ownership and physical possession are different questions
The accountant should understand:
- Incoterms / shipping terms
- When title or control transfers
- Consignment terms
- Goods in transit
- Returns not yet inspected
- Damaged or quarantined units
Reconcile the inventory subledger to the general ledger
A strong process includes:
- SKU quantities
- Location quantities
- Unit cost
- Inventory adjustments
- Cycle counts
- Physical counts
- Transfer activity
Measure inventory efficiency
But use age by SKU too
Average turns can hide:
- Fast sellers
- Dead stock
- Seasonal products
- New launches
- Pre-orders
Inventory aging should lead to a decision
Possible actions include:
- Reorder
- Pause purchasing
- Bundle
- Mark down
- Liquidate
- Return to vendor
- Write down where required
Returns, Refunds, Chargebacks, and Reverse Logistics
Returns are not simply negative sales
A returned order can create:
- Customer refund
- Return-shipping cost
- Inspection / handling labor
- Restocking
- Damaged inventory
- Markdown
- Processor refund fees
- Lost outbound shipping
Online return rates are economically meaningful
NRF estimated that 19.3% of online sales would be returned in 2025. That means return economics can materially change the contribution of categories with high initial gross margins.
Build a return-cost bridge
Separate refund timing from physical return timing
A refund may be issued before the item reaches the warehouse. That can create temporary differences between cash, refund liabilities, returned-inventory status, and the inventory subledger.
Chargebacks are different from ordinary returns
Track:
- Unauthorized transaction claims
- Product / delivery disputes
- Processor fees
- Recovered disputes
- Fraud patterns
Shipping promises can create refund exposure
The FTC’s Mail, Internet, or Telephone Order Merchandise Rule generally requires online sellers to have a reasonable basis for promised shipping times and, if no time is stated, generally to ship within 30 days. When required delays occur, customers must be given appropriate cancellation / refund rights.
Source: FTC — Mail, Internet, or Telephone Order Merchandise Rule.
Economic Nexus, Marketplace Facilitators, and Sales Tax
Sales-tax boundary: Ecommerce nexus, thresholds, product taxability, marketplace rules, sourcing, registration, filing, exemption certificates, and local taxes vary by state and can change. Use current state guidance and qualified multistate tax review for actual conclusions.
Physical presence is no longer the only nexus question
The Multistate Tax Commission’s Wayfair implementation project explains that the U.S. Supreme Court’s 2018 Wayfair decision removed the prior physical-presence limitation and states developed economic-nexus thresholds and marketplace-facilitator rules.
Source: Multistate Tax Commission — Wayfair Implementation.
Economic-nexus thresholds vary by state
Some states use dollar thresholds, some historically used transaction counts, and requirements have continued to change. For example, Streamlined Sales Tax’s current state tables note that Illinois eliminated its 200-transaction alternative effective January 1, 2026 and uses a $100,000 gross-receipts threshold for the covered sales described in its guidance.
Source: Streamlined Sales Tax — State Economic Nexus Tables.
Marketplace facilitator laws shift collection responsibilities—but not all obligations
Streamlined Sales Tax explains that many states require marketplace facilitators to collect and remit tax on facilitated sales once applicable requirements are met. The seller still needs to understand:
- Which sales the marketplace collected tax on
- Which direct-channel sales remain the seller’s responsibility
- Whether registration is still required
- Whether marketplace sales must be reported on returns
- How exemption documentation is handled
Source: Streamlined Sales Tax — Marketplace Facilitator Guidance.
Build a jurisdiction matrix
| State | Direct Sales | Marketplace Sales | Threshold Status | Registration / Filing |
|---|---|---|---|---|
| State A | Track | Track separately | Below / nearing / exceeded | Current state guidance |
| State B | Track | Facilitator collecting | Exceeded | Verify filing treatment |
Reconcile tax by channel
Each month:
- Storefront tax collected
- Marketplace tax collected / remitted
- Tax refunds
- Tax payable
- Returns filed
- State payments
Do not infer nexus from Form 1099-K
Payment reporting and sales-tax nexus are different systems.
Gross Margin and Contribution Margin
Gross margin is only the first layer
Ecommerce needs contribution analysis
For customer-acquisition decisions, firms may also analyze contribution after advertising.
Analyze margin at multiple levels
Useful views include:
- SKU
- Product family
- Order
- Channel
- Marketplace
- Country
- Customer cohort
A high gross-margin SKU can be a weak ecommerce product
Why?
- High return rate
- Bulky shipping
- Expensive fulfillment
- High marketplace fee
- Heavy discounting
- High acquisition cost
Use margin bridges
Separate changes caused by:
- Price
- Discount
- Product mix
- Channel mix
- COGS
- Freight
- Marketplace fees
- Return rate
- Ad spend
Read Client Profitability Analysis for Accounting Firms for the broader principle of moving beyond revenue to economic contribution.
Shipping, Fulfillment, and Channel Economics
Shipping has both revenue and cost sides
Track separately:
- Shipping charged to customers
- Carrier cost
- Packaging
- Pick-and-pack
- Residential / fuel / oversized surcharges
- Return shipping
“Free shipping” is a pricing decision
If the customer pays $0 for shipping, the business still incurs fulfillment economics. The margin model should show where that cost is absorbed.
Fulfillment partner invoices need order-level context
A 3PL invoice may include:
- Receiving
- Storage
- Pick-and-pack
- Packaging
- Postage
- Special handling
- Returns
Channel contribution should include channel-specific costs
A direct website order may have higher advertising cost but lower marketplace fees. A marketplace order may bring organic demand but carry referral, fulfillment, storage, and advertising costs. The accountant should model the actual economics rather than assume one channel is always superior.
Advertising, CAC, and Customer Economics
Advertising can create revenue growth that destroys contribution
Track ad spend by channel and compare it with orders, new customers, and contribution.
But CAC alone is incomplete
Pair it with:
- First-order contribution
- Repeat-purchase rate
- Return rate
- Average order value
- Gross margin
- Contribution after fulfillment
Distinguish accounting from marketing attribution
The general ledger tells you how much the company spent. Marketing platforms estimate which sales they influenced. Staff should reconcile total spend to accounting while treating attribution as a management model rather than a bank-level fact.
Build cohort economics when repeat purchases matter
A company may tolerate lower first-order contribution if customers reliably reorder. That requires evidence, not a vague belief that “lifetime value will make it work.”
Scenario analysis is useful before increasing ad spend
Read Scenario Planning Training for Accountants for teaching staff to model decisions before clients commit cash.
Gift Cards, Store Credits, Discounts, and Promotions
Gift-card cash and revenue timing are different questions
Gift cards can create cash before the related merchandise transfers. Staff should understand:
- Gift-card sales
- Redemptions
- Outstanding liability
- Breakage policy where applicable
- Expiration / unclaimed-property considerations
Store credit is not the same as cash refund
Track credits issued for:
- Returns
- Customer-service adjustments
- Promotions
- Referral programs
Discounts should be visible by type
Examples:
- Coupon
- Automatic promotion
- Influencer code
- Affiliate promotion
- Bundle discount
- Marketplace promotion
- Loyalty reward
A promotion can increase conversion while reducing order contribution
Analyze both:
This is a management formula, not a GAAP measure.
Multi-Currency and International Complexity
International ecommerce adds another reconciliation layer
Potential issues include:
- Customer currency
- Processor settlement currency
- Foreign-exchange fees
- Marketplace conversion
- Customs / duties
- VAT / GST
- Foreign warehouses
- International returns
Separate transaction economics from currency effects
A channel can appear to lose margin because of:
- FX movement
- Conversion fees
- Duties
- Higher shipping
- Higher returns
Do not let staff improvise foreign tax conclusions
VAT, GST, permanent establishment, customs, transfer pricing, and foreign registrations require jurisdiction-specific review.
Ecommerce Cash Flow and Working Capital
Growth can consume cash faster than it creates profit
A seller may pay for inventory:
- At order
- Before production
- At shipment from supplier
- Weeks before the product sells
Then it may spend on freight, duties, advertising, fulfillment, and payroll before collecting the final customer cash net of returns.
Build a 13-week ecommerce cash forecast
Forecast by settlement source
Different channels may settle:
- Daily
- Every few days
- Weekly
- On marketplace-specific cycles
- After reserves
Inventory purchasing needs a separate cash schedule
Track:
- Purchase orders
- Deposits
- Production payments
- Freight
- Duties
- Expected arrival
- Expected sell-through
Returns should be in the forecast
If a large holiday sales period creates refunds in January, the cash model should not treat December settlements as permanently available.
Sales-tax cash is not owner cash
Amounts collected for jurisdictions should be reconciled to liabilities and filing schedules.
Read Cash Flow Advisory Training for Accountants and Financial Modeling Training for Accountants for building forward-looking decision models.
Tax-Method and Entity Awareness
Ecommerce creates tax questions beyond sales tax
Common areas include:
- Inventory tax method
- Section 263A / small-business exceptions
- Form 1099-K reconciliation
- Entity structure
- Owner compensation
- State income / franchise tax nexus
- Foreign operations
- Fixed assets / warehouse equipment
Inventory tax methods require deliberate choices
IRS Publication 334 explains that qualifying small business taxpayers can have simplified inventory methods, but the business still must use a method that clearly reflects income. A tax-method simplification does not eliminate the management need for reliable SKU and inventory data.
Information-reporting thresholds are not taxable-income thresholds
The IRS emphasizes that Form 1099-K thresholds determine reporting obligations for payment entities; they do not determine whether business income is taxable.
State income-tax nexus is separate from sales-tax nexus
Do not assume that a sales-tax marketplace-facilitator rule resolves state income, franchise, gross-receipts, or other tax exposure.
Read Strategic Tax Planning Training for Accountants for teaching staff to identify planning triggers before year-end.
Ecommerce KPIs That Actually Change Decisions
| Metric | What It Can Tell You | What It Can Hide |
|---|---|---|
| Net revenue | Top-line performance | Order volume vs price vs discount |
| Orders | Transaction volume | Order contribution |
| Average order value | Basket size | Discounts and return exposure |
| Gross margin | Product economics | Fulfillment, shipping, payment, returns, ads |
| Contribution margin | Order / channel economics | Fixed overhead and capital needs |
| Return rate | Revenue reversal pressure | Recovered inventory value |
| Inventory turns / days | Working-capital efficiency | SKU-level dead stock |
| CAC | Acquisition efficiency | Repeat purchase and contribution |
| Settlement variance | Payment reconciliation quality | Revenue-recognition questions |
| Sales-tax exposure status | Compliance readiness | Product taxability / filing details |
Use a KPI tree
Read KPI Advisory Training for Accountants for choosing metrics around decisions rather than dashboard volume.
Run the Monthly Ecommerce Economics Review
1. Orders and revenue
Review:
- Orders
- Gross order value
- Net revenue
- Discounts
- Average order value
- Channel mix
- Returns / refunds
2. Settlement and cash reconciliation
Review:
- Processor clearing
- Marketplace settlements
- Chargebacks
- Reserves
- Fees
- Unreconciled deposits
3. Inventory and COGS
Review:
- Inventory balance
- Inventory in transit
- Age by SKU
- Turns / days
- Landed-cost changes
- Write-down / obsolescence issues
4. Margin
Review:
- Gross margin
- Contribution by SKU
- Contribution by channel
- Shipping
- Fulfillment
- Marketplace fees
- Returns
- Advertising
5. Sales tax and information reporting
Review:
- State sales by channel
- Nexus thresholds
- Marketplace-facilitated sales
- Sales-tax liabilities
- Returns / payments
- 1099-K reconciliation status
6. Cash and working capital
Review:
- 13-week forecast
- Inventory purchase commitments
- Vendor terms
- Ad spend
- Sales tax
- Debt
- Owner distributions
Finish with three decisions
The monthly meeting should end with:
- One margin action
- One inventory / working-capital action
- One compliance / cash action
Build Recurring Ecommerce Advisory
A scalable ecommerce service needs standardized inputs
Required data may include:
- Storefront order exports
- Marketplace reports
- Processor settlements
- Bank statements
- Inventory subledger
- 3PL / fulfillment reports
- Shipping invoices
- Sales-tax reports
- Advertising spend
Standardize the monthly output
A recurring service could include:
- Order-to-revenue reconciliation
- Payment clearing reconciliation
- Inventory / COGS roll-forward
- Sales-tax dashboard
- SKU / channel contribution
- 13-week cash forecast
- Monthly owner review
Define exclusions
Examples:
- Formal revenue-recognition memos
- Multistate tax opinions
- VAT / GST registration
- Customs advice
- Transfer pricing
- Valuation
- Transaction due diligence
Price the service for reconciliation and interpretation
Read Accounting Advisory Proposal Template for defining outcomes, scope, cadence, fees, and client responsibilities.
Build redundancy inside the CPA firm
A niche is not scalable if:
- One partner understands marketplace statements
- One manager knows sales-tax nexus
- One staff member knows inventory
- Everyone else waits for instructions
Industry expertise should be converted into playbooks, scenarios, review standards, and measurable readiness.
AI and Ecommerce Accounting
Ecommerce produces ideal data for AI-assisted analysis
Potential uses include:
- Settlement variance detection
- SKU margin classification
- Inventory aging summaries
- Return-pattern analysis
- Sales-tax threshold monitoring
- Ad-spend variance analysis
- Cash-scenario generation
But AI can amplify bad source data
If marketplace refunds are missing from the data, an AI model can confidently produce the wrong margin answer faster.
Build source hierarchy first
For each metric, define:
- Source system
- Report name
- Cutoff
- Reconciliation owner
- Manager review
Do not paste sensitive commerce data into unapproved tools
Protect:
- Customer personal information
- Payment details
- Bank credentials
- Employee information
- Marketplace credentials
- Vendor pricing
AI should accelerate judgment practice
It can also create realistic staff-development scenarios such as:
- Marketplace settlement mismatch
- Sales-tax threshold change
- High-return SKU
- Inventory cash squeeze
- Revenue gross-versus-net question
Worked Example: Ecommerce Revenue Is Up, but Margin and Cash Are Down
Illustrative training example only: The figures below demonstrate ecommerce diagnostic logic. They are not ecommerce-industry benchmarks or recommendations for a specific company.
A direct-to-consumer brand sells through its own website and two marketplaces. Management reports strong growth but is using its credit line more heavily.
Year-over-year operating facts
- Net revenue: +22%
- Orders: +14%
- Average order value: +7%
- Gross margin: 58% → 55%
- Return rate: 11% → 16%
- Marketplace share of sales: 28% → 41%
- Inventory dollars: +46%
- Paid advertising: +38%
- Cash balance: -25%
The inexperienced conclusion
“Growth is expensive. We just need more working capital.”
The ecommerce-fluent accountant builds the bridge
Revenue: Order growth is healthy, but a larger share comes from discount-driven marketplace promotions.
Gross margin: Product cost increased because of freight and duty changes. Marketplace mix also shifted toward lower-priced bundles.
Returns: One apparel category has a 27% return rate and generates disproportionate return shipping and markdown cost.
Inventory: Management ordered nine months of stock ahead of a seasonal launch to secure supplier capacity. Inventory growth far exceeds sales growth.
Advertising: Direct-channel customer-acquisition cost rose while first-order contribution declined.
Cash: The company paid for inventory and advertising before collecting the related sales, then issued more refunds than forecast.
Revenue Growth Can Hide Margin and Working-Capital Deterioration
Illustrative indices only. Prior year = 100. Return-rate index reflects the relative change from 11% to 16%. Bars are visually capped for readability and are not market benchmarks.
The better advisory conclusion
“The business is growing, but the quality of growth weakened. Marketplace mix and promotions compressed gross margin, returns increased materially, direct-channel acquisition became more expensive, and inventory was purchased far ahead of demand. The credit-line need is not just a symptom of growth—it is a signal that contribution and inventory velocity need to improve.”
The next six management actions
- Analyze contribution by SKU and channel after returns and fulfillment.
- Fix or exit the highest-return SKUs.
- Reduce purchase commitments where inventory age is increasing.
- Separate marketplace growth from direct-channel customer economics.
- Reforecast advertising based on first-order and cohort contribution.
- Base inventory buys and owner distributions on the 13-week cash forecast.
A 90-Day Ecommerce Accounting Implementation Plan for CPA Firms
Days 1–30: Build the ecommerce financial architecture
- Choose the target ecommerce client profile
- Map storefronts, marketplaces, processors, banks, warehouses, and 3PLs
- Define order-to-revenue workflow
- Create processor / marketplace clearing reconciliations
- Create inventory / COGS roll-forward
- Create returns and refund schedule
- Create sales-tax nexus dashboard
- Create SKU / channel contribution model
- Create 13-week cash forecast
- Define GAAP / tax / sales-tax / foreign escalation rules
Deliverable: One standardized ecommerce accounting playbook.
Days 31–60: Train through realistic cases
- Processor settlement mismatch
- Marketplace gross-versus-net issue
- 1099-K reconciliation
- Inventory-in-transit cutoff
- High-return SKU
- Economic-nexus threshold
- Marketplace facilitator reconciliation
- Contribution-margin decline
- Holiday inventory cash squeeze
Deliverable: Scored reconciliations, analyses, and simulated founder conversations.
Days 61–90: Pilot with live ecommerce clients
- Select clients with reliable order and inventory data
- Build order-to-cash reconciliation
- Analyze inventory and returns
- Build sales-tax dashboard
- Analyze channel contribution
- Update cash forecast
- Lead part of the monthly ecommerce review
- Capture recurring manager corrections
- Measure CPA-firm delivery hours
Deliverable: Evidence that ecommerce expertise can transfer beyond one niche partner.
Read Scenario-Based Training for Accountants for developing judgment before live client decisions depend on it.
The Complete 30-Day Ecommerce Accounting Training Curriculum
Days 1–5: Ecommerce foundations
- Business models
- Sales channels
- Order lifecycle
- Payment processors
- Marketplaces
- Fulfillment models
- Revenue terminology
Evidence: Ecommerce systems and transaction-flow map.
Days 6–10: Revenue and payment reconciliation
- Gross vs net sales
- Topic 606 triggers
- Processor clearing
- Marketplace settlement
- Refunds
- Chargebacks
- 1099-K
Evidence: Order-to-bank and Form 1099-K reconciliation.
Days 11–15: Inventory and returns
- Landed cost
- COGS
- Inventory in transit
- Warehouse / 3PL inventory
- Inventory aging
- Returns
- Damaged inventory
Evidence: Inventory roll-forward and return-cost analysis.
Days 16–20: Sales tax and compliance
- Wayfair framework
- Economic nexus
- Marketplace facilitators
- Direct vs marketplace sales
- Registration / filing dashboard
- Tax reconciliation
Evidence: Multistate sales-tax monitoring matrix with specialist escalations.
Days 21–25: Margin and cash
- Gross margin
- SKU contribution
- Channel contribution
- Shipping / fulfillment
- CAC
- Inventory working capital
- 13-week cash
Evidence: Ecommerce owner economics package.
Days 26–30: Independent capstone
- Receive an unfamiliar ecommerce company
- Map systems and channels
- Reconcile orders and settlements
- Analyze inventory
- Analyze returns
- Assess sales-tax monitoring
- Build channel / SKU contribution
- Forecast cash
- Present three management actions
- Escalate GAAP, multistate, international, and complex tax questions
Evidence: Complete COMMERCE capstone and 100-point readiness score.
The 30/60/90-Day Live-Work Progression
Days 31–60: Controlled analytical responsibility
The learner may:
- Prepare processor reconciliations
- Update marketplace settlements
- Prepare inventory roll-forwards
- Update return and refund reports
- Maintain nexus dashboards
- Prepare channel-margin schedules
- Update cash forecasts
Days 61–90: Scoped client-facing responsibility
Expand responsibility when the learner can:
- Explain why orders, revenue, 1099-K gross payments, and bank deposits differ
- Identify processor / marketplace reconciliation issues
- Explain inventory and return effects on margin and cash
- Recognize economic-nexus triggers without giving unsupported state-law conclusions
- Build SKU and channel contribution
- Frame inventory and ad-spend cash decisions
- Escalate revenue-recognition, multistate, and international questions appropriately
After day 90: Increase complexity without blurring authority
Complex Topic 606 memos, state sales-tax opinions, VAT/GST, customs, foreign tax, transfer pricing, inventory-method changes, valuation, and M&A matters remain subject to the firm’s competence and specialist-review rules.
100-Point Ecommerce Accounting Readiness Scorecard
| Capability | Points | Observable Evidence |
|---|---|---|
| Business model / channel fluency | 8 | Explains storefront, marketplace, fulfillment, processor, inventory, and customer journey |
| Order-to-revenue judgment | 12 | Separates order, payment, fulfillment, shipping, returns, gross/net presentation, and revenue-recognition questions |
| Payment / marketplace reconciliation | 14 | Reconciles gross payments, refunds, fees, reserves, chargebacks, and deposits |
| Inventory / COGS / landed cost | 14 | Builds inventory roll-forward across locations and understands landed cost, transit, aging, and write-down triggers |
| Returns / refund economics | 8 | Connects refund cash, reverse logistics, recoverable inventory, chargebacks, and contribution |
| Sales-tax monitoring | 12 | Tracks direct / marketplace sales, nexus thresholds, facilitator collection, registrations, filings, and escalations |
| Margin / channel judgment | 12 | Builds gross and contribution margin by SKU, order, and channel with relevant variable costs |
| Cash-flow / working-capital judgment | 10 | Forecasts settlements, inventory payments, freight, ads, tax, debt, and distributions |
| Tax / information-reporting awareness | 5 | Reconciles 1099-K and recognizes inventory-method, entity, state, and foreign tax triggers |
| Communication / escalation | 5 | Explains ecommerce economics clearly and routes GAAP, multistate, international, and legal matters appropriately |
Suggested readiness rule: Require at least 85 points overall, no zero category, an accurate payment-settlement reconciliation, defensible inventory and contribution analysis, a complete cash forecast, and successful transfer to an unfamiliar ecommerce case before the learner independently leads a material ecommerce advisory discussion.
15 Realistic Ecommerce Accounting Training Scenarios
Scenario 1: The Processor Deposit Is 12% Below Store Sales
The learner must reconcile refunds, processor fees, chargebacks, and timing instead of reducing revenue to the bank deposit.
Scenario 2: Marketplace Gross Sales Do Not Equal Revenue
A marketplace statement includes customer payments, tax, refunds, commissions, fulfillment, and advertising deductions. The learner separates the settlement from the principal-versus-agent and revenue-recognition questions.
Scenario 3: Form 1099-K Is Higher Than the Books
The learner reconciles gross reportable payments to refunds, fees, shipping, tax, and accounting revenue rather than forcing the general ledger to match the form.
Scenario 4: Inventory Is “Missing”
The general ledger shows $1.8 million of inventory, but the primary warehouse holds only $1.3 million. The learner identifies inventory in transit and stock at two fulfillment partners.
Scenario 5: High Revenue, High Returns
An apparel category looks attractive at 62% gross margin but has a 28% return rate. The learner models return shipping, handling, markdowns, and recovered inventory value.
Scenario 6: New State Crosses a Nexus Threshold
Direct sales increase rapidly in a state. The learner updates the nexus dashboard, verifies current state rules, and escalates registration / filing conclusions rather than relying on last year’s threshold.
Scenario 7: Marketplace Collects Sales Tax
The founder assumes that means the company can close its state sales-tax account. The learner separates facilitated sales from direct-channel obligations and verifies state filing rules.
Scenario 8: “Free Shipping” Promotion
Conversion rises but order contribution falls because outbound freight on low-value orders exceeds the incremental margin.
Scenario 9: Paid Ads Scale Faster Than Contribution
Revenue from the direct website grows 30%, but acquisition cost rises 45% and first-order contribution turns negative.
Scenario 10: Holiday Inventory Buy
The company commits to six months of stock before peak season. The learner models deposits, freight, duties, warehouse timing, sell-through, refunds, and liquidity.
Scenario 11: Inventory Turns Look Healthy in Total
Fast-selling core products hide $400,000 of aged seasonal inventory. The learner moves from total turns to SKU aging.
Scenario 12: Subscription Revenue Collected Up Front
The company collects a year in advance for a recurring product program. The learner identifies the revenue-recognition question and separates cash receipt from recognized revenue.
Scenario 13: Store Credit Instead of Refund
Return activity falls in cash terms because customers accept credits. The learner recognizes that store credit creates an obligation and should not be treated as recovered margin immediately.
Scenario 14: International Channel Looks Unprofitable
The learner separates currency conversion, duties, shipping, marketplace fees, and returns before concluding the market should be closed.
Scenario 15: “Can We Take a Distribution?”
The bank balance looks strong, but supplier deposits, sales tax, freight, ad commitments, and expected January refunds are due within six weeks. The learner uses the 13-week forecast before discussing owner distributions.
Each scenario should require the learner to identify the source system, accounting bridge, compliance boundary, margin effect, cash effect, management question, and next action.
What the CPA Firm Should Measure
| Metric | What It Reveals |
|---|---|
| Processor / marketplace reconciliations completed accurately | Control over ecommerce revenue and cash |
| 1099-K reconciliations completed | Year-end information-reporting readiness |
| Inventory exceptions identified before close | Operational and accounting inventory fluency |
| Sales-tax threshold alerts surfaced | Proactive multistate awareness |
| SKU / channel contribution analyses completed | Movement beyond top-line reporting |
| Cash forecasts kept current | Forward-looking advisory capability |
| Manager rebuild hours | Whether ecommerce expertise is transferring |
| Recurring review notes by category | Training gaps that should become scenarios or playbook content |
| Ecommerce advisory opportunities surfaced | Connection from bookkeeping / tax data to owner decisions |
| Ecommerce client realization / contribution to CPA firm | Whether the niche is profitable for the accounting firm |
Read Accounting Firm Realization Rate and Revenue per Professional for CPA Firms for measuring the CPA firm’s own economics around specialized advisory delivery.
Common Ecommerce Accounting Training Mistakes
Mistake 1: Booking bank deposits as revenue
Refunds, taxes, fees, reserves, and chargebacks disappear.
Mistake 2: Treating Form 1099-K as the income statement
Gross payment reporting is confused with accounting revenue.
Mistake 3: Treating every order as revenue at checkout
Shipping, control transfer, returns, subscriptions, and other Topic 606 questions are ignored.
Mistake 4: Assuming marketplace settlement proves gross or net presentation
Principal-versus-agent analysis is skipped.
Mistake 5: Ignoring inventory in transit
COGS and working capital become distorted around month-end.
Mistake 6: Measuring inventory only in dollars
Dead stock hides behind fast-moving products.
Mistake 7: Analyzing gross margin without returns
High-return SKUs appear far more attractive than they are.
Mistake 8: Treating shipping as one expense line
Inbound freight, outbound delivery, return shipping, and customer shipping revenue are mixed together.
Mistake 9: Assuming the marketplace handles all sales tax
Direct sales, registration, filing, and other state obligations may remain.
Mistake 10: Using stale economic-nexus thresholds
State rules change while the firm’s checklist does not.
Mistake 11: Treating CAC as a complete profitability metric
Gross margin, returns, fulfillment, repeat purchase, and contribution are ignored.
Mistake 12: Celebrating revenue growth without channel mix
Growth may come from a lower-contribution marketplace or heavy promotions.
Mistake 13: Treating gift-card or store-credit cash as ordinary earned revenue
Future obligations disappear.
Mistake 14: Letting AI analyze unreconciled commerce data
Bad source data produces faster but more convincing errors.
Mistake 15: Building the ecommerce niche around one partner
The CPA firm markets specialization but cannot deliver it without constant senior intervention.
Frequently Asked Questions About Ecommerce Accounting Training
What is ecommerce accounting training?
It is a structured development process that teaches accountants to connect online orders, revenue recognition, payment settlements, inventory, returns, sales tax, channel costs, margin, and cash flow to ecommerce management decisions.
Why is ecommerce accounting different from ordinary retail accounting?
Ecommerce businesses often sell through multiple digital channels, use multiple processors and fulfillment partners, hold inventory across locations, face high return volumes, encounter multistate sales-tax rules, and receive net settlements that combine many accounting components.
Why should ecommerce revenue not simply equal bank deposits?
Bank deposits may be net of processor fees, marketplace fees, refunds, chargebacks, reserves, taxes, and timing differences. Revenue and settlement cash require a gross-to-net reconciliation.
What is Form 1099-K?
Form 1099-K is an IRS information return reporting certain payment-card and third-party-network transactions. Box 1a generally reports gross reportable payments without reducing them for fees, refunds, shipping, discounts, and other adjustments.
What is the current Form 1099-K threshold for online marketplaces and payment apps?
Current IRS guidance says a third-party settlement organization generally must report when gross reportable payments to a payee exceed $20,000 and the number of transactions exceeds 200. Payment-card transactions have different reporting rules and no comparable de minimis dollar threshold.
Does Form 1099-K determine taxable ecommerce revenue?
No. It is an information-reporting form. The business still determines taxable income using its books, tax accounting method, and applicable law, and should reconcile the form to its source records.
How should ecommerce inventory be accounted for?
Inventory accounting depends on the reporting and tax framework, but management should maintain reliable quantities, location, unit cost, landed cost, goods in transit, returns, aging, and reconciliation to the general ledger.
What is landed cost?
Landed cost is the total cost required to acquire inventory and bring it to the relevant location and condition, potentially including purchase price, freight, duties, and other costs depending on the applicable accounting policy.
How should ecommerce returns be analyzed?
Measure the refund plus return shipping, processing, handling, lost or damaged product value, fees, and markdowns, less the value of inventory that can be recovered and resold.
What is economic nexus for ecommerce?
Economic nexus refers to state tax jurisdiction based on economic activity rather than only physical presence. Thresholds and rules vary by state and must be monitored using current state guidance.
Do marketplace facilitator laws mean ecommerce sellers never need sales-tax registrations?
No. Marketplace facilitators may collect and remit tax on facilitated sales, but sellers can still have direct-channel collection, registration, reporting, filing, or other obligations depending on the state.
What is gross margin in ecommerce?
Gross margin generally means net revenue minus cost of goods sold. It does not necessarily include fulfillment, shipping, marketplace fees, payment fees, returns, or advertising.
What is ecommerce contribution margin?
A useful management measure subtracts relevant variable order and channel costs—such as COGS, payment fees, marketplace fees, fulfillment, outbound shipping, and return costs—from net revenue. The exact definition should be documented.
Why can a high gross-margin product be unprofitable?
It may have high return rates, expensive shipping, marketplace fees, fulfillment cost, discounting, or customer-acquisition cost that consumes the gross margin.
How should accountants analyze ecommerce advertising?
Reconcile total advertising spend to accounting, calculate acquisition metrics consistently, and compare spend with first-order and cohort contribution rather than relying only on platform-attributed revenue.
Why can a growing ecommerce company run out of cash?
Inventory may be purchased months before sale, advertising may be paid before customer acquisition pays back, refunds may follow peak sales periods, and sales tax, freight, fulfillment, debt, and vendor commitments can consume cash before profit turns into liquidity.
Can AI help with ecommerce accounting?
Yes. AI can help identify settlement variances, inventory patterns, high-return SKUs, sales-tax threshold changes, and margin outliers, but source data should be reconciled and sensitive customer, payment, bank, and marketplace data must be protected.
How can a CPA firm build a scalable ecommerce advisory niche?
Standardize the source-data map, payment reconciliations, inventory roll-forward, sales-tax dashboard, margin model, cash forecast, staff training, manager review, scope, and pricing so multiple accountants can deliver consistent ecommerce insight.
Can Your Staff Explain Why Orders, Revenue, Processor Settlements, Inventory, Sales Tax, Margin, and Cash All Tell Different Parts of the Same Story?
SkillAbility helps accounting firms develop technical execution, industry fluency, advisory judgment, client communication, manager capability, and leadership readiness through structured practice, scenarios, feedback, and measurable development pathways.
Book Your Free 10-Minute Structural Alignment Review →
Includes our 45-Day Out-of-Pocket Performance Guarantee.
To turning ecommerce complexity into better decisions,
Vincent Howard, CPA
Managing Partner, Howard, Howard and Hodges
SkillAbility for Accounting Firms
About the Author
Vincent Howard, CPA has practiced public accounting since 1990. He earned a Bachelor of Science in Accounting and a Master’s in Taxation from the University of Central Florida, founded his accounting firm in 1993, and serves as Managing Partner of Howard, Howard and Hodges. He helped grow the organization from three people to approximately 50 staff across multiple Florida locations and states. He has participated in PASBA since 1997, and the firm was named PASBA Firm of the Year in 2015. Since 2020, he has built and run the SkillAbility accounting workforce development platform, used by more than 1,000 accounting professionals across dozens of PASBA firms.
© 2026 SkillAbility for Accounting Firms. This article provides general educational information and does not replace accounting, GAAP, tax, sales-tax, information-reporting, customs, VAT/GST, legal, cybersecurity, valuation, or other qualified advice. Ecommerce economics and applicable rules vary materially by channel, contract, product, jurisdiction, entity, fulfillment model, and accounting method.
