Let's Talk
Industry Expertise

E-commerce
Bookkeeping

Scope of Work & Integrations. Tailored financial management for multi-channel e-commerce, Amazon FBA, and Shopify sellers.

Part 1 — Scope of Work

Comprehensive bookkeeping tasks designed specifically for your e-commerce business.

A. Standard Bookkeeping

Categorization

Daily sales and operational expenses from bank & merchant accounts sorted into correct accounts.

Reconciliation

Bank and payment gateway/marketplace payout reconciliation.

A/R & A/P

Vendor bills, payment tracking, A/R & A/P aging reports.

Payroll

Employee payroll bookkeeping where applicable.

Financial Statements

P&L, Balance Sheet, Cash Flow Statement.

Month/Year-End Close

Journal entries, cleanup/catch-up, CPA-ready books.

B. E-commerce-Specific Scope

Marketplace Reconciliation

Reconcile each channel separately — Shopify, Amazon, eBay, Etsy, Walmart, WooCommerce.

Payout/Settlement Reconciliation

Gross Sales + Refunds + Fees + Adjustments = Net Payout, matched to bank deposit.

Inventory Accounting

Beginning/ending inventory, purchases, adjustments, damaged/lost stock, valuation (inventory ≠ expense).

COGS Tracking

Product cost, freight, customs/duties, fulfillment — Sales − COGS = Gross Profit.

SKU/Product-Level Profitability

Revenue, COGS, and fees tracked per product to find which SKUs actually make money.

Marketplace Fees

Map referral/FBA/storage/ad fees (Amazon), app/transaction fees (Shopify), listing fees (Etsy), etc.

Refunds, Returns & Chargebacks

Track customer refunds, returned inventory, restocking fees, and chargeback adjustments.

Sales Tax Tracking

Multi-state nexus, tax collected vs. payable, marketplace facilitator rules, tax-preparer reports.

Shipping & Fulfillment Cost

USPS/UPS/FedEx/FBA/3PL costs, packaging, freight vs. shipping income charged to customer.

Landed Cost Accounting

True product cost = purchase + freight + customs + import duties.

Amazon FBA Accounting

Settlements, FBA/storage fees, reserves, reimbursements, FBA inventory reconciliation.

Advertising Expense Tracking

Meta/Google/Amazon/TikTok ad spend by platform, ad spend vs. revenue trend.

Contribution Margin

Sales − COGS − Fees − Shipping − Advertising = Contribution Profit.

Multi-Channel Revenue

Revenue, fees, COGS and profit compared side-by-side across every sales channel.

Multiple Brands/Entities

Separate books, stores, and bank accounts for each brand under one owner.

KPI/Management Reporting

AOV, refund rate, ad spend %, contribution margin, inventory turnover, cash flow.

Service Package Flow

The step-by-step lifecycle of managing your e-commerce financials securely and accurately.

Setup/Cleanup
Chart of Accounts & Channel/SKU Structure
Monthly Bookkeeping
Multi-Channel Payout Reconciliation
Inventory & COGS Tracking
SKU/Channel Profitability Reporting
Sales Tax Compliance
Financial Statements
KPI Dashboard

Part 2 — Software Integrations

Connecting the best tools to streamline your e-commerce operations.

Tier 1 — Highly Useful
Shopify + QBO
Orders, sales, discounts, refunds, and payouts sync directly to QuickBooks.
Amazon Seller Central + QBO
Amazon/FBA sales, fees, and settlements — Amazon accounting is its own specialty.
A2X
Settlement accounting 'gold standard' — summarizes sales, fees, refunds & adjustments into one clean journal entry per payout (Amazon/Shopify/Walmart/eBay).
Link My Books
A2X alternative for multi-channel sellers (Amazon, Shopify, eBay, Etsy, Walmart, TikTok Shop, WooCommerce).
Tier 2 — Useful
WooCommerce + QBO
Orders, products, sales, refunds & customers for WordPress-based stores.
eBay + QBO
Sales, selling fees, payment processing, and payouts.
Etsy + QBO
Orders, listing/transaction fees, payment processing, and payouts.
Walmart Marketplace + QBO
Marketplace settlements, fees, refunds and returns.
Tier 3 — Supporting Integrations
Stripe / PayPal
Direct-website or B2B payment processing — gross sales, fees, refunds, net payout.
SOS Inventory / Cin7 / Katana
Multi-SKU, multi-warehouse inventory tracking with automatic COGS updates to QBO.
Avalara / TaxJar
Multi-state sales tax nexus tracking, collection and filing automation.
ShipStation
Shipping, fulfillment, labels and carrier charges for self-fulfilled sellers.

Integration Flow by Business Size

Business Size Recommended Integration Flow
Small
Shopify (Single Channel) ➔ Shopify Payments/Stripe ➔ QuickBooks Online
Medium
Shopify + Amazon Seller Central ➔ A2X or Link My Books (Settlement Accounting) ➔ QuickBooks Online
Large
Shopify + Amazon + Walmart/eBay/Etsy (Multi-Channel) ➔ A2X or Link My Books ➔ SOS Inventory/Cin7 (Inventory) ➔ Avalara/TaxJar (Sales Tax) ➔ QuickBooks Online