What an Ecommerce Accountant Actually Does (Buyer's Guide)

Key Takeaways (TL;DR): An ecommerce accountant is a specialized bookkeeper or CPA who reconciles Shopify payouts, Amazon settlements, and processor fees on accrual basis weekly. They track inventory and COGS at the SKU level, monitor multi-state sales tax nexus, and deliver channel-level margin reports by business day 10 to 15 each month. The work is operational, not annual tax filing.

An ecommerce accountant is a specialized bookkeeper or CPA who reconciles Shopify payouts, Amazon settlement reports, and payment processor fees on an accrual basis, tracks inventory and COGS by SKU, monitors multi-state sales tax nexus, and produces channel-level margin reports. The work is weekly and operational, not just an annual tax filing.

Most posts about hiring an ecommerce accountant are written by firms trying to sell you their service. They list credentials and benefits without showing what the job actually looks like. This guide is the buyer-side version. In our work with 100+ Shopify brands at Ottit, what follows is the actual workflow a competent ecommerce accountant runs, the deliverables you should expect, and the red flags that tell you a generalist is in over their head.

Ecommerce Accountant vs. Generalist CPA at a Glance

Before the workflow detail, here is the side-by-side view of what separates a specialist from a generic CPA. The differences compound every month an ecommerce store waits to switch.

What Does an Ecommerce Accountant Actually Do Weekly?

A competent ecommerce accountant runs a weekly cycle: pull Shopify payout reports and reconcile them to bank deposits, sync Amazon settlement reports through a payout-sync tool, categorize processor fees and chargebacks, update inventory receipts from 3PL and supplier invoices, and flag sales tax thresholds. None of this is optional. Skipping any step breaks the financials within a quarter.

Here is what the weekly cadence looks like across the Shopify brands we serve. The work is concrete, not abstract.

1. Monday — Payout reconciliation. Pull last week's Shopify Payments deposits, match each to the underlying payout report, and book gross sales, refunds, fees, gift card liability, and sales tax separately. Same exercise for Stripe, PayPal, Shop Pay Installments, and Affirm if connected.
2. Tuesday — Marketplace settlements. Sync Amazon settlement reports. Each settlement period gets split into FBA fees, referral fees, advertising, returns, reserves, and net deposit. Walmart, eBay, and TikTok Shop follow the same pattern.
3. Wednesday — Inventory and COGS. Book inventory receipts from supplier invoices, update landed cost (freight, duties, 3PL inbound), and post COGS journal entries based on units shipped from ShipBob, Amazon FBA, or a self-managed warehouse.
4. Thursday — Subscriptions and deferred revenue. Reconcile Recharge or Skio subscription billing against Shopify orders. Adjust deferred revenue if the brand sells prepaid bundles or annual memberships.
5. Friday — Sales tax and cash review. Pull updated economic nexus tracking, review state-by-state thresholds, confirm filings due, and produce a 13-week cash flow snapshot for the operator.

Generalist CPAs typically do none of this. They wait until quarter-end, pull the bank feed, categorize deposits as 'Sales,' and call it done. That single shortcut destroys gross margin reporting because Shopify payouts are net of fees and refunds, not gross sales.

Takeaway for Shopify stores: Ask your accountant to walk you through last week's Shopify payout reconciliation. If they cannot show you the journal entry splitting fees, refunds, and sales tax, the books are already off.

How Does an Ecommerce Accountant Reconcile a Shopify Payout?

A Shopify payout is a net deposit. Inside that single bank credit are gross sales, refunds, processor fees, gift card redemptions, sales tax collected, tips, and adjustments. An ecommerce accountant uses the payout report (or a sync tool like Bookkeep) to break each deposit into its components and post the correct journal entry instead of booking the lump sum as sales.

Per the Shopify Help Center guide to payouts, Shopify Payments deposits arrive on a rolling schedule and bundle activity from a defined pay period. The deposit amount almost never matches gross sales for that period.

Here is a realistic example. A DTC apparel brand on Shopify Payments receives a $42,180.55 deposit on a Tuesday. The underlying payout report shows the following activity.

A generalist would book $42,180.55 to 'Sales.' That is wrong by roughly $6,700 on revenue, hides $1,490 of processor fees, and leaves sales tax sitting in revenue instead of a liability account. The correct entry separates each component.

For Shopify stores using Xero or QuickBooks, we recommend Bookkeep — it's the tool we use for revenue recognition across the 100+ Shopify stores Ottit closes books for. Other tools in this category include the Synder Shopify integration guide and A2X, though Bookkeep handles sales tax liability splits more cleanly in our workflow. We cover the manual version step by step in our Shopify payout reconciliation playbook.

Takeaway for Shopify stores: If a payout-sync tool is not connected, the books are almost certainly being kept on a cash basis and miss gift card liability, sales tax payable, and processor fees as separate line items.

How Does an Ecommerce Accountant Handle Amazon Settlements?

Amazon pays sellers every two weeks via a settlement report. Each report contains 30+ transaction types: product sales, refunds, FBA storage fees, FBA fulfillment fees, referral fees, advertising, reimbursements, and inventory reserves. An ecommerce accountant maps every transaction type to a GL account and posts a summarized journal entry per settlement, never as a single deposit.

Most Amazon settlement periods cross month-end. A settlement covering April 25 through May 8 contains revenue and fees from two months. A specialist splits the report at month-end so April financials reflect April activity, not a deposit timing artifact.

We go deeper on the multi-channel side in our Amazon FBA bookkeeping guide, including how to handle inventory transfers between Shopify-fulfilled and FBA channels.

Takeaway for Shopify stores: A brand selling on both Shopify and Amazon needs channel-level P&Ls, not a blended one. Ask your accountant to produce gross margin by channel for last month before you hire them.

How Does an Ecommerce Accountant Track Sales Tax Nexus?

Economic nexus rules trigger sales tax registration once a seller crosses a state's revenue or transaction threshold (commonly $100,000 in sales or 200 transactions, though thresholds vary). An ecommerce accountant pulls Shopify and Amazon sales by ship-to state monthly, compares against current thresholds, and flags states approaching nexus before the brand crosses them.

The work is not the actual filing. For sales tax filing, we use Bookkeep across most of the Ottit Shopify book of business; Avalara is a strong fit for larger brands with international VAT exposure. The accountant's job is the monitoring layer: knowing where the brand is registered, where it has economic nexus but is not registered, and where physical nexus exists from inventory in FBA warehouses or 3PL locations.

Amazon FBA creates inventory nexus in every state where Amazon stores the seller's goods. For most FBA sellers, that is 20+ states immediately. We unpack this in our Amazon FBA sales tax nexus guide and the broader Shopify sales tax automation guide.

• Monthly state-by-state sales report broken down by ship-to state, gross sales, and transaction count.
• Threshold tracker showing each state's threshold, current trailing 12-month sales, and percent of threshold used.
• Registration log listing every state where the brand is registered, the registration date, filing frequency, and last filing date.
• Physical nexus inventory log showing FBA warehouse locations and any 3PL facilities holding the brand's inventory.

Takeaway for Shopify stores: Sales tax exposure is cumulative. A brand that crossed nexus in 8 states 18 months ago and never registered owes back tax plus penalties. The threshold tracker is the prevention tool, not the filing software.

How Does an Ecommerce Accountant Track Inventory and COGS?

Inventory accounting is where most generalist CPAs collapse. An ecommerce accountant tracks inventory at the SKU level, books receipts at landed cost (product + freight + duty + inbound 3PL), uses FIFO or weighted average to relieve inventory when units ship, and performs an inventory cutoff at month-end so units in transit are not double-counted.

The accounting equation here is simple but the data work is not.

A generalist often books supplier invoices straight to COGS when paid. That records $148,200 of purchases as April expense even if 70% of those units are still sitting in a container at the port. Gross margin gets distorted by tens of points month over month, and the operator cannot trust the P&L for pricing decisions.

Method choice matters too. FIFO, LIFO, and weighted average produce different COGS during periods of changing input costs. We compare them in Shopify inventory accounting methods.

Takeaway for Shopify stores: Inventory must be an asset on the balance sheet that ties to a physical count. If the inventory line on the balance sheet has not changed in three months, the books are wrong.

What Should an Ecommerce Accountant Deliver Each Month?

A monthly close package from an ecommerce accountant typically includes accrual-basis P&L by channel, balance sheet, cash flow statement, inventory roll-forward, sales tax tracker, AR/AP aging, and a brief variance commentary. Delivery target is business day 10 to 15 of the following month. Anything later is too stale to drive operating decisions.

Brands using Triple Whale or Northbeam often want marketing-attributed contribution margin layered on top. A specialized accountant can pull ad spend from Klaviyo, Meta, and Google into the channel P&L so the operator sees true CAC-adjusted contribution. Generalists will not even know what these tools are.

Our full close playbook is in Shopify bookkeeping best practices, and the buyer's framework for evaluating providers is in the Shopify bookkeeping buyer's guide.

Takeaway for Shopify stores: Ask for a sample monthly package before signing. If the firm cannot show a redacted close package with channel-level P&L and an inventory roll-forward, they do not produce one.

What Are the Red Flags When Hiring an Ecommerce Accountant?

The clearest red flag is a generic CPA who does not name specific tools. An ecommerce specialist names Bookkeep or Synder for payout sync, QuickBooks Online or Xero for the GL, Avalara for sales tax filing, and Inventory Planner or Cogsy for inventory. If the answer is 'we use QuickBooks,' that is a generalist.

• Cash-basis only books. A DTC brand with inventory needs accrual basis. Cash basis hides gift card liability, deferred revenue, and inventory.
• No payout-sync tool connected. Manual payout categorization at scale is unreliable. Every brand we onboard from a generalist has miscategorized payouts.
• 'I'll just book the deposit as sales.' This single shortcut breaks gross margin and sales tax tracking immediately.
• No channel-level P&L. A blended P&L hides which channels are profitable and which are subsidized.
• No inventory roll-forward. Inventory must reconcile from beginning balance through purchases and COGS to a physical count.
• No sales tax nexus tracker. Filing software is not the same as exposure monitoring. The accountant should know thresholds.
• Quarterly-only delivery. Operators making weekly inventory and ad spend decisions cannot run on quarterly numbers.
• No experience with subscription tools. Recharge, Skio, and Stay AI create deferred revenue that requires specific handling.
• Charges by the hour with no scope. Specialized firms typically price by transaction volume, channel count, and complexity, not hourly.

Test questions to ask in a sales call: 'Walk me through how you booked a Shopify payout last week for a similar-sized brand.' 'How do you handle an Amazon settlement that crosses month-end?' 'Show me a sample inventory roll-forward.' Specificity in the answer separates specialists from generalists.

Takeaway for Shopify stores: Run the test questions before signing. The answers reveal whether the firm operates inside the ecommerce stack or just adapts a generic bookkeeping process.

How Much Does an Ecommerce Accountant Cost in 2026?

Specialized ecommerce bookkeeping in 2026 typically runs $400 to $2,500 per month based on order volume and channel count. Fractional CFO services add $1,500 to $5,000 monthly. Tax preparation is usually billed separately at $1,500 to $4,000 for an S-corp return. Pricing scales with transaction volume, number of sales channels, inventory SKU count, and subscription complexity.

US ecommerce continues to grow as a share of total retail, with category data tracked in Statista's US e-commerce market reports and retailer-level performance covered in Digital Commerce 360 industry research. As a brand crosses $1M monthly, the cost of bad books (audit risk, missed sales tax, broken margin reporting) typically exceeds the fee for a specialist by a wide margin.

Entity structure also affects pricing. A multi-entity setup (holding company plus operating LLC, common for brands with outside investors) requires consolidated reporting. Background on entity choices is in the SBA guide to choosing a business structure.

Takeaway for Shopify stores: Price on scope, not hourly. A flat monthly fee tied to transaction volume and channel count is the industry standard. Hourly billing for ongoing bookkeeping usually means the firm has not productized the work.

Does an Ecommerce Accountant Need to Be Local?

Location does not matter for ecommerce accounting in 2026. The entire stack — Shopify, QuickBooks Online, Xero, Bookkeep, bank feeds, payment processors — is cloud-based. What matters is specialization in DTC and marketplace accounting, familiarity with the apps a brand actually runs, and a delivery cadence that matches the brand's operating rhythm.

The 'near me' search persists because some founders still want a face-to-face relationship. That is fine, but the trade-off is real: a local generalist almost certainly does not have specialized Shopify and Amazon experience. A remote specialist with 50 to 200 ecommerce clients has seen every payout edge case the brand will encounter.

State income tax filing is the one place location can matter. A CPA in the brand's state of incorporation is helpful but not required, since state filings are routinely prepared remotely. For tax-specific questions about a particular situation, a brand should consult a CPA familiar with its facts.

Takeaway for Shopify stores: Optimize for ecommerce specialization first, communication cadence second, and geography last. Most of the brands we serve at Ottit have never met us in person and have cleaner books than they did with a local generalist.

References

• the Shopify Help Center guide to payouts
• the A2X documentation for Shopify accounting
• the Synder Shopify integration guide
• Statista's US e-commerce market reports
• Digital Commerce 360 industry research
• the SBA guide to choosing a business structure

This guide is educational. It describes how the ecommerce accounting industry typically handles these situations across the 100+ Shopify brands we work with. It is not individualized tax, legal, or accounting advice. Brands should consult their own CPA or tax professional for guidance on their specific circumstances.