E-commerce Accounting for Shopify and Amazon Sellers

Ecommerce accounting is different from ordinary bank-feed bookkeeping because the cash deposit is not the sale. Shopify, Amazon, Stripe, PayPal, and other channels may deduct fees, refunds, chargebacks, taxes, advertising, reserves, and other adjustments before transferring money to the bank.

If a bookkeeper records only net deposits as revenue, sales are understated, fees disappear, sales-tax activity becomes unclear, and each channel’s profitability is impossible to measure. A reliable system follows the complete path from order to settlement to bank deposit to financial statement.

Record gross sales—not net payouts

Suppose Amazon reports $25,000 of product sales, $1,500 of refunds, $4,000 of marketplace and fulfillment fees, $500 of other adjustments, and a $19,000 bank deposit. Recording $19,000 as sales would hide both the refunds and fees.

The accounting should preserve the material components so management can understand net sales and selling costs while still reconciling exactly to the payout.

Use a clearing account for each major channel

A clearing account bridges sales activity and cash settlement. Post the channel summary to the clearing account, record fees and adjustments, then match the payout to the bank. A properly reconciled clearing account should contain only explainable timing differences, reserves, or unsettled transactions.

Use separate accounts for Shopify Payments, Amazon, Stripe, PayPal, and other material processors. Combining every channel in one account makes differences harder to trace.

Choose the right level of transaction detail

Importing every order, refund, and fee into QuickBooks Online or Xero can create an oversized ledger and slow reconciliation. Many sellers use summarized settlement entries with order-level detail retained in Shopify, Amazon, the processor, or a dedicated subledger.

A2X states that it summarizes sales, fees, refunds, and taxes from commerce channels into entries that reconcile with payouts in QuickBooks Online or Xero. The right method depends on volume, audit trail, inventory, tax, and reporting needs.

Track cost of goods sold and inventory separately

Revenue does not reveal product profitability without reliable inventory cost. Your process should account for:

• Purchases and manufacturing cost
• Freight, duty, and other landed costs
• Inventory in transit and at third-party warehouses
• Amazon FBA inventory and adjustments
• Bundles, assemblies, samples, and promotional units
• Returns, damaged stock, shrinkage, and obsolescence
• Period-end physical or cycle-count differences

Reconcile the inventory subledger or supporting schedule to the balance sheet. Review negative quantities and large manual adjustments rather than treating the software balance as automatically correct.

Separate refunds, discounts, chargebacks, and fees

These items answer different business questions:

• Refunds and returns reduce net sales and can identify product or fulfillment problems.
• Discounts show the cost of promotions and pricing strategy.
• Chargebacks may indicate fraud, customer-service, or delivery issues.
• Marketplace and fulfillment fees show the cost of each sales channel.
• Payment-processing fees should be measured against the related payment volume.

A chart of accounts should show useful categories without becoming so detailed that monthly reporting is unreadable.

Account for sales tax correctly

Sales tax collected from customers is generally a liability, not income. Marketplace facilitators often collect and remit tax on facilitated sales, while the seller may remain responsible for direct-channel tax and other state obligations.

Maintain destination-level sales data, separate marketplace and direct sales, and reconcile the sales-tax liability to filings and payments. Read our sales tax nexus guide for online sellers.

Do not treat gift-card sales as revenue

Selling a gift card generally creates a liability because the business still owes goods or services to the customer. Recognize revenue when the gift card is redeemed, subject to the applicable accounting and unclaimed-property rules. Reconcile gift cards issued, redeemed, refunded, expired, and outstanding.

Handle multi-currency activity consistently

International sales can create foreign-currency receivables, processor conversions, bank fees, and exchange gains or losses. Preserve the original transaction currency and settlement support. Avoid forcing every difference into payment-processing expense without analysis.

Monthly e-commerce close checklist

1. Confirm all channel and processor reports are complete through month-end.
2. Reconcile every bank, credit card, channel, and payment clearing account.
3. Match gross sales, returns, discounts, fees, taxes, and payouts.
4. Reconcile inventory and post the supported cost-of-goods-sold adjustment.
5. Review sales-tax, gift-card, reserve, chargeback, and deferred-revenue liabilities.
6. Post payroll, bills, prepaid costs, loans, and approved month-end adjustments.
7. Compare channel sales, gross margin, fees, refunds, advertising, and cash with prior periods.
8. Save settlement reports and reconciliation workpapers.

E-commerce KPIs to include in monthly reporting

• Gross and net sales by channel
• Gross margin by product or category where reliable
• Contribution margin after channel, fulfillment, and advertising costs
• Refund and chargeback rates
• Marketplace and processor fees as a percentage of sales
• Inventory turnover, days or weeks of cover, and aging
• Advertising spend relative to net sales and contribution
• Operating cash and a 13-week cash forecast

Common e-commerce bookkeeping mistakes

• Recording net deposits as revenue.
• Posting the same sale from Shopify and Stripe.
• Leaving processor clearing accounts unreconciled.
• Ignoring Amazon reserves, reimbursements, and FBA adjustments.
• Expensing all inventory when purchased without considering the accounting method.
• Combining marketplace-collected tax with sales.
• Using cash in the bank as the only measure of profitability.
• Adding apps without defining which system owns each data point.

Frequently asked questions

Can QuickBooks Online or Xero connect directly to Shopify?

Yes, but the integration method matters. Confirm whether it posts individual orders or summarized settlements, how it handles refunds, fees, taxes, and timing, and whether it duplicates processor data.

Do Amazon sellers need special bookkeeping?

Yes. Amazon settlements can contain sales, refunds, FBA and referral fees, advertising, reimbursements, tax, reserves, and other adjustments. The books should reconcile these components to each payout.

When should a brand upgrade its accounting stack?

Upgrade when transaction volume, channels, inventory complexity, tax exposure, or reporting needs make the existing process unreliable or too manual. Start with the workflow and control problem, then select software.

Get reliable channel-level numbers

AccoTiva provides e-commerce accounting for Shopify and Amazon sellers, including settlement reconciliation, clearing-account review, inventory and cost-of-goods-sold support, sales-tax-ready records, and monthly reporting. Our QuickBooks Online and Xero support can also repair an inefficient app setup.

Book a free e-commerce accounting review to identify duplicate sales, unreconciled payouts, or unclear inventory balances.

Source: A2X payout-reconciliation overview. This article provides general information and is not tax or legal advice.