Why marketplace payouts break normal bookkeeping categories
Bookkeeping for ecommerce sellersis the practice of recording sales how money actually moves through marketplaces like Shopify, Etsy, and Amazon.Unlike a traditional retail storeandard bookkeeping categories.
When you sell on a marketplace, the platform collects the customer's payment, deducts its fees, and deposits the remainder into your bank account. Your bookkeeping must separate gross sales from platform fees, refunds, and chargebacks to show true revenue and profitability. If you simply record the net deposit as income, you understate revenue and hide expenses that are critical for tax deductions and cash-flow analysis.
This guide tackles the messy parts that generic bookkeeping advice ignores:reconciling payouts. It's written for online store owners doing $5k–$50k per month without a full-time bookkeeper.
Key Takeaways
- Record gross sales and platform fees separately; never book net payouts as revenue.
- Use a dedicated ecommerce chart of accounts with clearing accounts for each marketplace.
- Reconcile marketplace payouts monthly to catch missing deposits and fee errors.
- Choose cash or accrual accounting based on inventory size and growth plans.
- Track sales tax separately; marketplace facilitator laws shift collection but not your record-keeping duty.
- Automate fee and payout imports to cut manual data entry and errors.
Chart of accounts tailored to ecommerce sellers
A standard small-business chart of accounts assumes you sell directly and receive gross payments. Ecommerce sellers need additional accounts to capture marketplace-specific transactions. Start with these core accounts and adjust as your sales channels grow.
Essential accounts for online sellers
- Sales – [Marketplace] (income): gross sales by channel, e.g., Sales – Shopify, Sales – Etsy, Sales – Amazon.
- Platform Fees (expense):commissions.
- Shipping Expense (expense): postage, packaging, and fulfillment costs.
- Refunds and Chargebacks (contra-revenue): amounts returned to customers.
- Inventory Asset (asset): cost of inventory on hand.
- Cost of Goods Sold (expense): cost of inventory sold during the period.
- Sales Tax Payable (liability): sales tax collected but not yet remitted.
- Marketplace Clearing (asset): temporary holding account for payouts in transit.
This structure lets you see gross revenue, fee burden, and true profit per channel. For example, if Shopify fees are 2.9% + $0.30 per transaction and Etsy fees are 6.5% plus listing and payment processing, separating them reveals which channel is most profitable after fees.
Reconciling platform fees, refunds, and chargebacks
Marketplace payout reconciliation is the process of matching the net deposit in your bank account to the gross salestform.Done monthlyrt your books.
Step-by-step payout reconciliation
- Download the marketplace payout report for the period (Shopify Payments, Etsy Payments, Amazon Settlement Report).
- Record gross sales as income and platform fees as expenses in your accounting system.
- Record refunds and chargebacks as contra-revenue, not as expenses.
- Post the net payout to your Marketplace Clearing account.
- Match the clearing account balance to the bank deposit; investigate any difference.
- Reconcile sales tax collected and remitted separately.
For sellers on multiple platforms, repeat this for each marketplace. Automation tools can import payout reports directly, but manual reconciliation is still needed to verify accuracy.
How to account for platform fees
Platform fees are a cost of doing business and are typically deductible. Record them as expenses in the period they are incurred, not when the payout arrives. If a marketplace charges a monthly subscription (e.g., Shopify plan), categorize it as a software or platform fee. Transaction fees should be allocated to the corresponding sale.
For accurate platform fees accounting, avoid lumping all fees into a single "bank charges" account. Use sub-accounts for commission, payment processing, and listing fees to analyze cost trends.
Handling refunds and chargebacks
Refunds reduce gross sales; they are not expenses. Record a refund as a debit to Refunds (contra-revenue) and a credit to the original payment account. Chargebacks, however, may include a fee and should be recorded as a chargeback expense plus a reduction in revenue. Keep documentation for disputed chargebacks to support tax deductions.

Inventory timing: cash vs accrual for small sellers
Inventory accounting for online sellers is the method of valuing inventory and recording its cost as it sells. The two main approaches are cash basis and accrual basis. Cash basis records revenue when payment is received and expenses when paid; accrual basis records revenue when earned and expenses when incurred, regardless of cash movement.
Cash vs accrual comparison
| Factor | Cash Basis | Accrual Basis |
|---|---|---|
| Revenue recognition | When payment received | When sale occurs |
| Inventory tracking | Expense when purchased | Asset until sold, then COGS |
| Complexity | Simple | More complex |
| Best for | Small sellers under $25k/month | Growing sellers with inventory |
Most small ecommerce sellers start with cash basis for simplicity. However, if you hold significant inventory or seek funding, accrual provides a clearer financial picture. The IRS requires accrual for businesses with average annual gross receipts over $25 million (for tax years after 2017), but many small sellers choose accrual voluntarily for better insight.
Cost of goods sold for ecommerce
Cost of goods sold (COGS) is the direct cost of the products you sold. Under accrual accounting, COGS is recognized when the sale occurs, not when you pay the supplier. This timing matters for accurate profit measurement. Use the formula: Beginning Inventory + Purchases – Ending Inventory = COGS. Track inventory in a system that updates with each sale to avoid manual errors.
Sales tax tracking for ecommerce
Sales tax tracking ecommerce sellers must handle is complicated by marketplace facilitator laws. As of 2024, most states require marketplaces like Amazon and Etsy to collect and remit sales tax on behalf of sellers. However, you are still responsible for record-keeping and for sales tax on your own website or in states where the marketplace does not collect.
Set up a Sales Tax Payable liability account and record tax collected separately from revenue. Reconcile it monthly against reports from each marketplace. If you sell on multiple channels, consider a sales tax automation tool to calculate rates and file returns. Always consult a tax professional for your specific obligations.
Monthly close checklist and where Smart Finance fits
A monthly close checklist ensures your books are accurate and ready for tax time. Follow these steps each month to keep your ecommerce bookkeeping clean.
Ecommerce bookkeeping checklist
- Download and import all marketplace payout reports.
- Reconcile each marketplace clearing account to bank deposits.
- Record platform fees, refunds, and chargebacks.
- Update inventory and calculate COGS.
- Reconcile sales tax payable and remit if due.
- Review profit and loss by channel.
- Set aside estimated tax payments.
- Back up receipts and documentation.
For sellers using Shopify. The GoWithFund Smart Finance app connects to your accounts to automate transaction imports, categorize fees, and generate cash-flow reports. It's designed for small teams without a bookkeeper, helping you spot trends and make informed decisions.








