How to Vet an Ecommerce Bookkeeper: A Buyer's Framework

Key Takeaways: An ecommerce bookkeeper is a specialist who records Shopify, Amazon, and marketplace sales on an accrual basis. They reconcile payouts, accrue sales tax as a liability, and track inventory at the unit level. Generalist bookkeepers fail on Shopify because they book the net bank deposit as revenue. This guide gives Shopify owners a buyer-side framework with the four failure modes we see most.

An ecommerce bookkeeper is a specialist who records Shopify, Amazon, and other platform sales into accounting software the right way. That means matching gross revenue, refunds, merchant fees, sales tax, and inventory cost to the period each order happened. They reconcile platform payouts, accrue sales tax liability, and roll inventory forward each month. A generalist bookkeeper usually does not.

Most articles ranking for this term are sales pages. This one is not. In our work with 100+ Shopify brands at Ottit, we see the same four failure modes almost every time a store switches from a generalist. This guide turns those failure modes into questions a Shopify owner can use to vet any provider, including us.

What Does an Ecommerce Bookkeeper Actually Do?

An ecommerce bookkeeper translates platform order data into accrual-basis financials. That means turning Shopify payouts, Amazon settlements, and Stripe deposits into journal entries that split gross sales, discounts, refunds, processing fees, shipping income, and sales tax collected. They also track inventory cost of goods sold and reconcile each payout against the bank.

The work breaks into five recurring jobs across a typical month:

• Payout reconciliation: matching every Shopify, PayPal, Shop Pay Installments, Afterpay, and Amazon deposit to the underlying orders, fees, and refunds
• Sales tax accrual: recording the tax Shopify or a tax engine collected as a liability, then clearing it when remitted to each state
• Inventory and COGS: posting purchases to inventory, relieving inventory when units ship, and reconciling to a physical or 3PL count
• Multi-channel revenue: combining Shopify, Amazon, Faire, TikTok Shop, and wholesale into one P&L without double-counting
• Monthly close and review: tying out the balance sheet, flagging anomalies, and producing a P&L by channel

For a deeper job description, see our post on what an ecommerce accountant actually does. The bookkeeper handles the recording. The accountant handles tax strategy, entity structure, and review.

Takeaway: Before any pricing conversation, ask a prospective provider to walk you through how they handled last month's close for a similar Shopify brand. The answer tells you whether they actually do the five jobs above or just categorize the bank feed.

Why Do Generalist Bookkeepers Fail on Shopify?

Generalist bookkeepers fail on Shopify because they treat the bank feed as the source of truth. On Shopify, the bank deposit is a net number after fees, refunds, chargebacks, and sometimes sales tax. Booking that net deposit as revenue understates gross sales, hides merchant fees, and makes margin analysis impossible. The order data, not the deposit, is the source of truth.

Across the brands that switch to us each year, we see four specific failure modes. We call them the four failure modes because they show up together about 80% of the time.

Each one is fixable, but compounded over twelve months they produce a P&L that no investor, lender, or buyer will trust. Per Digital Commerce 360 industry research, DTC brands that scale past $5M in revenue routinely fail diligence on inventory and revenue cutoff issues that started as basic bookkeeping errors.

Generalist vs. Ecommerce Bookkeeper at a Glance

The differences show up in specific deliverables, not in marketing copy. The table below compares the two approaches across the work that matters for a Shopify brand. Use it as a checklist when reviewing a sample monthly close package.

Our Shopify bookkeeping buyer's guide walks through how to spot these failure modes on a trial close.

Takeaway: Pull last month's P&L and look for these line items: gross sales, discounts, refunds, shipping income, merchant fees, sales tax payable on the balance sheet, and inventory movement. If any are missing, the four failure modes are probably present.

How Should an Ecommerce Bookkeeper Handle Shopify Payout Reconciliation?

The correct method is to build a journal entry per payout that splits the gross order value into its components. Shopify Payments deposits net of fees, refunds, and sometimes chargebacks. According to the Shopify Help Center guide to payouts, payouts arrive on a rolling 2-3 business day pay period, which means the order date and the deposit date almost never match.

Here is a realistic payout entry for a single Shopify Payments deposit on a DTC apparel brand. The bank received $48,217.43. The orders inside that payout totaled $52,400 in gross sales.

When the $48,217.43 bank deposit lands, it clears the Shopify Clearing account to zero. Tools like A2X and Synder generate this entry automatically. The A2X documentation for Shopify accounting and the Synder Shopify integration guide cover the integration mechanics in detail.

Things that complicate this entry in real Shopify stores:

• Shop Pay Installments and Afterpay payouts arrive separately and have their own fee schedules
• PayPal and Amazon Pay orders are inside Shopify but settle to different bank accounts
• Recharge subscription orders may settle through a separate Stripe account, not Shopify Payments
• Gift cards are a liability when sold and revenue when redeemed, not when the deposit hits
• Chargebacks and reserves show up as negative line items in payouts weeks after the original sale

Our close playbook on reconciling Shopify payouts in QuickBooks walks through each of these step by step.

Takeaway: Ask any prospective bookkeeper to show you a sample payout journal entry. If the entry has fewer than five lines, or if Shopify Clearing does not appear on the balance sheet, they are not doing this correctly.

How Do Ecommerce Bookkeepers Track Sales Tax Liability?

An ecommerce bookkeeper accrues sales tax as a liability the moment Shopify or a tax engine collects it. The tax sits in a Sales Tax Payable account on the balance sheet. When the brand remits the tax to a state, the payment debits the liability, not an expense account. Sales tax collected is never revenue and never an expense.

Here is what a clean sales tax flow looks like for a Shopify brand registered in 12 states:

1. Shopify or a tax engine collects sales tax on each order and reports it per state
2. The bookkeeper credits Sales Tax Payable for the total collected each month, split into sub-accounts by state if useful
3. When the brand files a state return and pays, the bookkeeper debits Sales Tax Payable and credits cash
4. At month-end, the Sales Tax Payable balance should equal tax collected but not yet remitted, by state
5. If a state shows a negative balance, it usually means a remittance was booked to the wrong account or refunds reversed prior collections

We use Bookkeep for sales tax automation across the 100+ Shopify stores Ottit closes books for. It posts the daily summary entries and keeps the liability account clean by state. Sales tax has gotten more complex since the Wayfair decision expanded economic nexus across all 50 states . Most growing DTC brands trip nexus thresholds in 5-15 states within 18 months of scaling.

Our Shopify sales tax guide and Amazon FBA sales tax nexus guide cover the registration side. The bookkeeping side is what we focus on here.

Takeaway: Pull the Sales Tax Payable account history for the last 6 months. If it only goes up, remittances are being miscoded. If it never moves, sales tax probably is not being accrued at all and is sitting inside revenue.

How Do Ecommerce Bookkeepers Handle Inventory and COGS?

Ecommerce bookkeepers post inventory purchases to a balance sheet asset, then relieve that asset to Cost of Goods Sold when units ship. The two main costing methods are FIFO (first in, first out) and weighted average. The choice affects gross margin reporting, especially when landed costs swing because of tariffs or freight. LIFO is rare for DTC because IFRS prohibits it and it usually hurts the tax picture for inventory-light brands.

Here is a simplified inventory roll-forward for a single SKU on a Shopify brand using weighted average:

FIFO would produce different COGS in any month where unit cost is changing. With the same activity, FIFO would relieve the older $8.50 layer first, producing lower COGS and higher gross margin in April but pushing the higher-cost layer into May.

The April COGS difference between methods is $359 on this one SKU. Across 80 SKUs and tariff-driven cost swings, the cumulative difference can move gross margin by 1-2 points. Our Shopify inventory accounting methods guide compares FIFO, LIFO, and weighted average in more depth.

Common inventory tools an ecommerce bookkeeper integrates with:

• ShipBob, ShipHero, and Stord for 3PL inventory and fulfillment cost
• Cogsy and Inventory Planner for purchase orders and demand forecasting
• Cin7 for multi-warehouse and multi-channel inventory of record
• Katana for brands that manufacture in-house or do light assembly

Takeaway: Ask any prospective bookkeeper which costing method they will use, how often they reconcile to the 3PL count, and whether they produce a monthly inventory roll-forward. If the answer is vague, COGS is probably being booked from bills paid rather than units shipped.

How Does Multi-Channel Revenue Recognition Work?

Multi-channel brands sell on Shopify, Amazon, Faire, TikTok Shop, eBay, and sometimes wholesale at the same time. An ecommerce bookkeeper consolidates these into one P&L without double-counting and produces a P&L by channel for margin analysis. Each channel has its own settlement schedule, fee structure, and sales tax treatment, so each gets its own clearing account.

A typical chart of accounts for a multi-channel brand includes:

Marketplace facilitator laws are why Amazon and TikTok sales tax handling is different. The marketplace collects and remits the tax, so the brand records gross sales net of tax and does not accrue a liability. On Shopify, the brand is the merchant of record and does accrue the liability. Mixing these up is the most common multi-channel mistake we fix. Our Amazon FBA bookkeeping guide covers the Amazon side in depth.

Takeaway: A clean multi-channel P&L should let the owner see gross sales, refunds, fees, and gross margin by channel side by side. If the books only show one Sales line, channel-level margin analysis is impossible and ad spend decisions are flying blind.

How Much Does an Ecommerce Bookkeeper Cost?

Monthly fees for an ecommerce bookkeeper typically range from about $300 to $2,500 per month, scaling with transaction volume, number of sales channels, and inventory complexity. Pricing tiers usually align with monthly revenue bands because revenue correlates with order count and the work required to reconcile it. Below is what we see across the market in 2026.

Pricing Tiers by Revenue Band

The table below summarizes the pricing bands we see most often when Shopify brands shop the market. Use it to sanity-check any quote against the scope you actually need.

Tooling is sometimes bundled and sometimes billed separately. A2X for Shopify and Amazon runs roughly $19-$249 per month depending on order volume per the A2X documentation for Shopify accounting. QuickBooks Online runs $35-$235 per month. Some firms include these in the monthly fee, others pass them through.

What pushes a brand toward the higher end of each band:

• Subscription product on Recharge with high churn and proration
• International stores with multi-currency and VAT or GST
• Heavy returns volume requiring RMA reconciliation
• Bundles, kits, and assemblies that need BOM-based COGS
• Multiple legal entities or holding company structure

According to Statista's US e-commerce market reports, US ecommerce continues to expand share of total retail, which is why brands cross these revenue bands faster than they expect and outgrow their generalist bookkeeper sooner than planned.

Takeaway: When comparing quotes, normalize on what's included. A $400 quote that excludes inventory and sales tax accrual is more expensive than a $900 quote that includes both, because the gaps will surface as adjustments at year-end with the CPA.

What Questions Should You Ask Before Hiring an Ecommerce Bookkeeper?

The right questions are operational, not credential-based. Ask about specific tools, specific journal entries, and specific close steps. The answers reveal whether a provider has actually closed Shopify books or just lists ecommerce on their website. Below are the questions we'd ask if we were hiring an ecommerce bookkeeper today, including how we'd want a buyer to grill us.

1. Show me a sample payout journal entry. It should split gross sales, discounts, refunds, fees, shipping income, and sales tax. Five-plus lines minimum.
2. How do you handle Shop Pay Installments, Afterpay, and PayPal payouts? Each should have its own clearing account.
3. Walk me through your sales tax accrual process. They should describe a payable account that climbs and clears, not an expense account.
4. FIFO or weighted average, and how often do you reconcile to the 3PL count? Vague answers mean COGS is from bills paid, not units shipped.
5. How do you book Amazon and TikTok Shop sales differently from Shopify? They should mention marketplace facilitator and net-of-tax recording.
6. What's your monthly close timeline and what does the deliverable look like? Industry standard is 10-15 business days with a P&L, balance sheet, and cash flow.
7. Which app stack do you use? A2X, Synder, QuickBooks Online, Xero, Bookkeep, Gusto, Ramp, BILL are all reasonable. No tooling is a red flag.
8. Can I see a sample monthly close package for a similar Shopify brand? A real one, redacted, beats any sales pitch.

Takeaway: Run these eight questions on every provider on your shortlist, including us. Score the answers on specificity. The provider who answers in journal entries and tool names usually outperforms the one who answers in adjectives.

How Do You Transition From a Generalist to an Ecommerce Bookkeeper?

A clean transition takes 30-60 days and includes a catch-up or cleanup of prior periods. The new bookkeeper rebuilds the chart of accounts, sets up clearing accounts and tooling, restates prior periods so the P&L is comparable, and reconciles the balance sheet. Most brands time the switch to the start of a quarter or fiscal year to keep the comparison clean.

A typical transition timeline:

1. Week 1: Diagnostic close on the most recent month. The new bookkeeper identifies which of the four failure modes are present and quantifies the cleanup scope.
2. Week 2: Chart of accounts rebuild. Add clearing accounts per channel, sales tax payable by state, inventory and COGS structure.
3. Week 3-4: Tool setup. Connect A2X or Synder to Shopify, Amazon, and other channels. Connect the inventory tool. Connect payroll and AP.
4. Week 4-8: Cleanup of prior periods. Most brands clean up the current fiscal year so the CPA has accurate financials at tax time.
5. Ongoing: Monthly close on a 10-15 business day cadence, with a recurring review call.

Cleanup pricing is usually a one-time fee, often equal to 1-3 months of the ongoing fee per month being cleaned up, depending on how messy the books are. Our Shopify automated accounting setup guide covers the tool setup phase in detail, and our Shopify accounting policies memo covers the policy decisions to lock down before the rebuild.

Takeaway: Do not skip the diagnostic close. It is the cheapest way to learn whether a provider can actually do the work, and it gives both sides a quantified scope for cleanup pricing.

Sources

• 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