Enter your email to watch
Your Ecommerce Sales Are Growing—But Which Channels Actually Make Money?
A poorly structured chart of accounts can hide marketplace fees, distort revenue reporting, and make ecommerce reconciliation harder than it needs to be. In this Ecom Clinic, Webgility's John May and Abhishek Joshi walk through practical ways to organize QuickBooks accounts, clearing accounts, subaccounts, and classes for multichannel businesses. Learn how to separate sales, fees, liabilities, and expenses to support accurate financial reporting, channel profitability analysis, and a more manageable month-end close.
- Identify how a poorly structured chart of accounts can obscure channel profitability and financial performance.
- Set up clearing accounts by sales channel, payment gateway, and currency to support reconciliation.
- Organize gross sales, shipping income, discounts, refunds, and marketplace adjustments into appropriate accounts.
- Separate cost of goods sold from marketplace fees, payment processing, fulfillment, and advertising expenses.
- Understand when to use QuickBooks accounts, subaccounts, and classes for multichannel reporting.
- Track marketplace reserves as assets and unredeemed gift cards as liabilities instead of treating them as ordinary expenses or sales.
- Structure Amazon marketplace accounts by country while maintaining consolidated reporting.
- Use channel-level profit and loss reports to compare revenue, expenses, and margins.
- Follow a practical QuickBooks setup sequence and test account mappings against settlement reports.
- Understand how Webgility helps automate the posting of ecommerce orders, settlement information, and expenses into QuickBooks.
How to Build an Ecommerce Chart of Accounts for Multichannel Profitability
Selling across Amazon, Shopify, Walmart, and other channels creates an accounting challenge: revenue may be growing, but understanding which channels actually generate profit can be difficult.
When sales, marketplace fees, refunds, and payment transactions are grouped into overly broad accounts, business owners lose visibility into their financial performance. Even when transactions are recorded, the structure may not provide the information needed to evaluate margins or reconcile payouts.
A well-organized ecommerce chart of accounts helps turn accounting records into useful business insights.
Why Your Ecommerce Chart of Accounts Matters
Your chart of accounts determines how financial activity appears in your balance sheet and profit and loss statement.
Without the right structure, important questions become difficult to answer:
- Which sales channels generate the strongest margins?
- How much are Amazon marketplace fees affecting profitability?
- Are payment processor charges increasing selling costs?
- Have marketplace payouts been fully reconciled?
The goal isn't to create an account for every transaction detail. It's to organize financial information in a way that supports reconciliation, reporting, and decision-making.
Start With Clearing Accounts for Every Channel
Clearing accounts are foundational to multichannel ecommerce accounting.
They temporarily track funds owed by marketplaces or payment processors before those funds reach your bank account.
For example, businesses selling through Amazon in multiple countries can create separate clearing subaccounts for the United States, Canada, and Mexico under a parent Amazon clearing account.
Similarly, Shopify Payments, PayPal, and Stripe can have dedicated accounts, with additional separation by currency where needed.
This structure makes it easier to compare transactions against settlement statements and investigate outstanding balances during month-end reconciliation.
Organize Revenue, Costs, and Marketplace Adjustments
Gross sales should be visible separately from deductions such as discounts and refunds.
Businesses can use revenue subaccounts to distinguish Amazon, Shopify, Walmart, and other sales channels while maintaining a consolidated view.
Marketplace reimbursements and adjustments also deserve separate treatment. For example, an Amazon inventory reimbursement should not be mixed into ordinary product sales or marketplace fees.
On the expense side, separate cost of goods sold (COGS) from the cost of selling products.
Marketplace referral fees, fulfillment, storage, advertising, and payment processing charges provide different information about profitability. Recording them distinctly helps identify which costs are affecting margins.
Choose Between Accounts, Subaccounts, and Classes
QuickBooks offers several ways to organize financial data.
Use individual accounts for balances requiring reconciliation or separate financial statement lines.
Use subaccounts to group related activity beneath a parent account, such as country-specific Amazon sales or clearing balances.
Use classes to filter financial reports by channel, brand, storefront, or region without creating duplicate account structures.
For example, a business can organize accounts by sales channel and use classes to analyze brands—or reverse that structure depending on its reporting needs.
The most effective configuration depends on the decisions the business needs to make.
Keep Liabilities and Assets Separate From Revenue
Not every incoming payment represents earned revenue.
Unredeemed gift cards and store credits should be tracked separately as liabilities. Marketplace reserves should also be distinguished from operating expenses and tracked as assets.
Sales tax and marketplace-facilitated tax activity require appropriate tracking rather than being combined with ordinary sales.
These distinctions make financial statements easier to interpret and support cleaner reconciliation.
Build a Repeatable Month-End Process
A practical setup begins with enabling account numbers and establishing clearing accounts. Next, organize revenue, expense, and liability categories before mapping transaction items to the correct accounts.
Finally, test the setup using a complete marketplace settlement and verify that the clearing account reconciles as expected.
Webgility helps support this process by automating the flow of ecommerce order, settlement, and expense information into QuickBooks according to the configured mappings.
The strategic takeaway: A well-designed ecommerce chart of accounts is more than an accounting structure. It provides the foundation for understanding channel profitability, maintaining financial visibility, and making better-informed decisions as your business grows.
What is an ecommerce chart of accounts?
An ecommerce chart of accounts organizes financial transactions into categories such as assets, liabilities, revenue, cost of goods sold, and expenses. For multichannel businesses, it can also distinguish sales channels, payment gateways, marketplace fees, and other transaction types to improve financial reporting.
How should I set up a chart of accounts in QuickBooks for multiple ecommerce channels?
What is the difference between accounts, subaccounts, and classes in QuickBooks?
Accounts record financial balances and categories that appear in financial statements. Subaccounts organize related activity under parent accounts, while classes help businesses analyze transactions by dimensions such as channels, brands, storefronts, or regions without duplicating the entire chart of accounts.
Why are clearing accounts important for ecommerce reconciliation?
Clearing accounts track funds moving between ecommerce channels, payment processors, and bank accounts. They help businesses compare recorded transactions with marketplace settlements, identify outstanding amounts, and investigate reconciliation differences during the month-end close.
How does Webgility help manage an ecommerce chart of accounts in QuickBooks?
Webgility helps ecommerce businesses automate accounting workflows by connecting ecommerce sales channels and marketplaces with QuickBooks. Once accounts and mappings are configured, Webgility can help post order, settlement, and expense information to the appropriate QuickBooks accounts, reducing manual entry and supporting more consistent financial reporting.
Watch More
Find out what your operational gaps are actually costing you.
Our team of experts will help surface your operations and finance concerns. In 30 minutes, we will discuss your channels, accounting setup, leakages, inventory inconsistencies, and close process.