Multi-Channel E-Commerce Bookkeeping Workflow

The Multi-Channel Challenge

If you're a bookkeeper serving e-commerce clients, chances are your clients don't sell on just one marketplace. A typical client might sell on Amazon and Shopify. A larger client might be on Amazon, Shopify, Etsy, Walmart, and eBay — all at once.

Each marketplace has its own settlement report format, fee structure, payout schedule, and download process. Managing all of this efficiently is the core challenge of multi-channel e-commerce bookkeeping.

This guide presents a practical workflow for handling settlements across all five major marketplaces. Whether you manage one multi-channel seller or fifty, the principles are the same: standardize your process, batch your work, and use the right tools.

Settlement Report Formats at a Glance

Before diving into the workflow, let's understand what you're working with:

Marketplace	Report Format	Delimiter	Key Fees	Payout Frequency	Download Location
Amazon FBA	TSV (V2) or CSV (V1)	Tab	Referral, FBA, Storage	Biweekly	Seller Central > Reports > Payments
Shopify	CSV	Comma	Processing fee only	Daily to weekly	Settings > Payments > View Payouts
Etsy	CSV	Comma	Transaction, Listing, Processing, Ads	Weekly (configurable)	Shop Manager > Finances
Walmart	CSV	Comma	Commission, WFS	Biweekly	Seller Center > Payments > Statements
eBay	CSV	Comma	FVF (fixed + variable), International, Ads	Weekly to biweekly	Seller Hub > Payments > Reports

Key Observations

• No two formats are the same. Column names, fee categories, and data structures differ across every marketplace.
• Payout frequencies vary. You can't just do everything at month-end because payouts arrive at different cadences.
• Fee complexity varies dramatically. Shopify has 1 fee type. Amazon has 15+. Your workflow needs to handle both ends of the spectrum.

The Efficient Multi-Channel Workflow

Here's the workflow we recommend for bookkeepers managing multi-channel clients:

Cadence: Weekly or Biweekly

Don't wait until month-end. Processing settlements weekly or biweekly keeps the workload manageable and catches errors early. Most marketplace payouts settle within this window, so you're working with complete data.

Step 1: Download All Settlement Reports

At the start of your processing cycle, download pending settlement reports from each marketplace:

1. Amazon: Seller Central > Reports > Payments > Date Range Reports
2. Shopify: Settings > Payments > View Payouts > Export
3. Etsy: Shop Manager > Finances > Payment Account > Download CSV
4. Walmart: Seller Center > Payments > Statements > Download
5. eBay: Seller Hub > Payments > Reports > Transaction Report

Save files with a consistent naming convention: {client}_{marketplace}_{date}.csv. For example: acme_amazon_2025-01-15.csv, acme_shopify_2025-01-15.csv.

Step 2: Convert to Journal Entries

For each settlement file, create a balanced journal entry. This means:

• Parsing the marketplace-specific format
• Categorizing each fee type to the correct account
• Summing by category
• Generating debit and credit lines
• Verifying the total balances

You can do this manually in Excel (see our guides for Amazon, Shopify, Etsy, eBay, and Walmart), or use a tool to automate it.

Step 3: Review the Journal Entries

Never import blindly. For each journal entry:

• Verify the balance (total debits = total credits)
• Check that the bank/payout amount matches the client's bank statement
• Look for unusual amounts or new fee categories
• Confirm the date matches the payout date

This review step takes 1-2 minutes per settlement and catches errors before they hit the books.

Step 4: Export in the Client's Format

Export each journal entry in the format your client's accounting software requires:

• QuickBooks Online: CSV journal import
• QuickBooks Desktop: IIF format
• Xero: Manual journal CSV
• Sage: CSV with Nominal Codes and DD/MM/YYYY dates

Different clients may use different software. Your export tool needs to handle all of them.

Step 5: Import and Reconcile

Import the journal entries into the accounting software. Then reconcile:

• Match each bank line item (the payout deposit) to the corresponding journal entry
• Verify that the bank balance matches after all entries are posted
• Flag any unmatched deposits for investigation

Standardizing Your Chart of Accounts

One of the biggest decisions for multi-channel bookkeeping is how to structure the chart of accounts.

Option A: Unified Accounts

Use generic account names that apply across all marketplaces:

• Marketplace Sales (Revenue)
• Marketplace Commission Fees (Expense)
• Marketplace Fulfillment Fees (Expense)
• Payment Processing Fees (Expense)
• Marketplace Advertising (Expense)
• Refunds Issued (Contra-Revenue)

Pros: Simpler chart of accounts. Easy to see total e-commerce performance. Cons: Can't easily see per-marketplace profitability.

Option B: Per-Marketplace Accounts

Create separate accounts for each marketplace:

• Amazon Sales, Shopify Sales, Etsy Sales, etc.
• Amazon Referral Fees, Shopify Processing Fees, Etsy Transaction Fees, etc.

Pros: Full visibility into per-marketplace performance. Cons: Chart of accounts grows quickly. 5 marketplaces × 6 categories = 30 accounts.

Option C: Unified Accounts with Tracking (Recommended)

Use unified account names but add a tracking dimension (QuickBooks Class, Xero Tracking Category, Sage Department) for the marketplace. This gives you both the simplicity of unified accounts and the ability to filter reports by marketplace.

For most multi-channel clients, Option C is the sweet spot.

Batch Processing: Converting Multiple Files at Once

When you're processing 5-10 settlement files per client per cycle, doing them one at a time is inefficient. Batch processing changes the workflow from:

Download → Convert → Export → Import → Download → Convert → Export → Import → ...

To:

Download all → Convert all → Review all → Export all → Import all

SettleBooks supports batch uploads of up to 10 files at once. Upload all of a client's settlement files, review the generated journal entries together, and download a combined ZIP file with all exports in the correct format. One upload, one download, all marketplaces.

This is especially powerful for bookkeepers with multiple clients. Process Client A's 5 marketplace files, then Client B's 3 files, then Client C's 7 files — all in a single session.

Managing Multiple Clients

Multi-client management adds another layer of complexity. Each client may have:

• Different marketplaces (Client A: Amazon + Shopify; Client B: Etsy + eBay)
• Different accounting software (Client A: QuickBooks; Client B: Xero; Client C: Sage)
• Different chart of accounts and account naming
• Different levels of detail (some want every fee broken out, others want summary entries)

Custom Category Mappings

The key to efficient multi-client management is saved category mappings. Once you set up how Amazon referral fees map to a specific client's chart of accounts, that mapping should persist. You shouldn't have to reconfigure it every settlement cycle.

SettleBooks lets you save custom category mappings per client. Set it up once, and every future settlement for that client uses the same mapping automatically.

Different Export Formats

Client A uses QuickBooks Online. Client B uses Xero. Client C uses Sage. A good workflow tool should export in any format without requiring you to switch tools or maintain separate processes.

API for High-Volume Firms

If you manage 20+ clients with 50+ settlement files per month, a manual upload workflow may not scale. SettleBooks offers an API for high-volume firms that want to automate the upload → convert → export pipeline programmatically.

Month-End Close Checklist

Here's a practical 7-step checklist for closing the books on a multi-channel e-commerce client:

1. Verify all settlements are downloaded Check each marketplace for any outstanding settlements in the period. Amazon and Walmart are biweekly, so a month may have 2-3 settlements each.

2. Convert all settlements to journal entries Process every settlement file through your conversion workflow.

3. Review each journal entry Verify balances, check for unusual amounts, confirm payout dates.

4. Import all journal entries Upload to the client's accounting software.

5. Reconcile bank deposits Match each marketplace payout to a bank line item. Every deposit should trace to a journal entry.

6. Check for unreconciled items Investigate any bank deposits that don't match a settlement, or settlements that don't match a deposit (timing differences around month-end are common).

7. Review marketplace P&L If using tracking categories, run a per-marketplace P&L to spot anomalies: unexpected fee increases, refund spikes, or revenue changes.

Tool Comparison for Multi-Channel Accounting

Let's compare the main approaches for handling multi-channel settlements:

Manual Excel Reconciliation

• Cost: Free
• Time per settlement: 30-60 minutes
• Scales to: 1-3 clients before it becomes unsustainable
• Formats: Any (you build the import file manually)
• Multi-marketplace: You need to know every format

Per-Marketplace API Tools (A2X, Link My Books)

• Cost: $19-79/month per marketplace per client
• Time per settlement: ~0 minutes (fully automated)
• Scales to: Unlimited (but cost scales linearly)
• Formats: QuickBooks Online, Xero only
• Multi-marketplace: Separate subscription per marketplace

The cost math for firms: 10 clients × 3 marketplaces each = 30 marketplace connections. At $19/month each = $570/month minimum. At $39/month each (for higher tiers) = $1,170/month. This cost scales with every new client and marketplace.

File-Based Conversion (SettleBooks)

• Cost: Per-settlement pricing, regardless of marketplace or client count
• Time per settlement: 1-2 minutes (upload + review + export)
• Scales to: Unlimited clients and marketplaces at flat per-use pricing
• Formats: QuickBooks (CSV + IIF), Xero CSV, Sage CSV, Generic CSV
• Multi-marketplace: All 5 marketplaces in one tool, batch upload supported

The cost math for firms: Flat per-settlement pricing. 10 clients × 3 marketplaces × 2 settlements/month = 60 settlements. The cost is the same whether you process 10 settlements or 100 — it doesn't multiply per client or per marketplace like API tools.

When API Tools Win

API-based tools like A2X are the right choice when:

• The client wants zero-touch automation (no manual downloads)
• They use QuickBooks Online or Xero exclusively
• They sell on only 1-2 marketplaces
• Budget isn't a primary concern

When File-Based Tools Win

File-based tools like SettleBooks are the right choice when:

• You manage multiple clients on different accounting software
• Clients use Sage (no API tool supports Sage)
• Clients sell on 3+ marketplaces (cost advantage at scale)
• Data-sharing policies prevent third-party API access
• You need to review entries before importing (compliance, accuracy)

Getting Started

If you're ready to streamline your multi-channel e-commerce bookkeeping:

1. Try SettleBooks free — upload your first settlement file and see the journal entry output: Upload a settlement →
2. Test with one client — pick your most complex multi-channel client and process one cycle through the tool
3. Save your mappings — once the category mappings match your client's chart of accounts, save them for future use
4. Scale to all clients — roll out the workflow across your client base

The goal is a repeatable, efficient process: download, upload, review, export, import. Once you have the workflow down, multi-channel settlement accounting becomes routine instead of a monthly ordeal.