Ecommerce Accounting: Complete Guide for Online Sellers
On This Page
Why Ecommerce Accounting Is Different
Ecommerce accounting is more complex than accounting for a typical service business because online sellers deal with inventory valuation, cost of goods sold calculations, multi-channel sales reconciliation, payment processor fee tracking, sales tax across multiple jurisdictions, and returns and refunds that affect revenue recognition. A freelance designer invoices clients and records expenses. An ecommerce seller buys 500 units of product at $8.50 each, pays $1,200 in shipping to a warehouse, sells 340 units across Shopify and Amazon at different price points, processes 28 returns, pays different processing fees on each platform, and needs to value the remaining 160 units of inventory on the balance sheet. The accounting complexity scales with every new product, sales channel, and market you add.
Payment processors complicate bookkeeping because the amount deposited to your bank account is not the same as your gross sales. Stripe deposits your sales revenue minus processing fees, typically 2.9% plus $0.30 per transaction. Shopify Payments deducts its fees before depositing. Amazon holds funds, charges referral fees, FBA fees, storage fees, and advertising costs, then deposits a net settlement amount every two weeks. Recording these transactions correctly means tracking gross revenue, processing fees, and net deposits as separate line items, not just recording whatever lands in your business bank account as revenue.
Inventory accounting adds another layer of complexity that service businesses never face. You need to track the cost of every unit you purchase, including the product cost, shipping to your warehouse, duties and tariffs for international sourcing, and any other costs required to get the product ready for sale. When you sell a unit, you need to move its cost from inventory (an asset on your balance sheet) to cost of goods sold (an expense on your income statement). The method you use for this, whether FIFO, LIFO, or weighted average, affects your reported profit and your tax liability. Getting inventory accounting wrong means your profit numbers are wrong, your tax estimates are wrong, and your financial statements misrepresent the health of your business.
Sales tax compliance has become significantly more complex since the 2018 South Dakota v. Wayfair Supreme Court decision, which allowed states to require online sellers to collect sales tax based on economic nexus, meaning you can owe sales tax in states where you have no physical presence simply because your sales volume or transaction count exceeds that state's threshold. Most states set their nexus threshold at $100,000 in sales or 200 transactions. An ecommerce seller with national reach can easily trigger nexus in 10 to 20 states, each with different rates, product taxability rules, and filing frequencies. Your accounting system needs to track sales tax collected, remit it to the correct jurisdictions, and file returns on the correct schedule.
Getting Started With Bookkeeping
If you are launching your first online store or you have been running one without proper books, the most important step is establishing a clean starting point. Open a dedicated business bank account if you have not already. Every business transaction should flow through this account, not your personal checking. This single change makes bookkeeping dramatically simpler because every transaction in the account is business-related by definition.
Set up a chart of accounts tailored to ecommerce. Your bookkeeping basics guide covers this in detail, but at minimum you need revenue accounts for each sales channel (Shopify sales, Amazon sales, wholesale), expense accounts for cost of goods sold, shipping costs, payment processing fees, advertising, software subscriptions, and supplies, and asset accounts for inventory and equipment. Most accounting software comes with a default chart of accounts that you can customize. Do not accept the defaults without modification because they are designed for generic businesses and miss ecommerce-specific categories.
Connect your bank accounts and payment processors to your accounting software immediately. Modern accounting software pulls transactions automatically from your bank, Stripe, PayPal, Shopify, and Amazon, reducing manual data entry to near zero for routine transactions. The key to making this work is setting up bank rules that automatically categorize recurring transactions. If Stripe deposits hit your bank three times per week, a bank rule can automatically categorize them as sales revenue without any manual action on your part.
Establish a weekly bookkeeping routine. Spend 30 to 60 minutes each week reviewing imported transactions, categorizing anything that was not automatically matched, reconciling your bank balance against your book balance, and checking for anomalies. This weekly habit prevents the end-of-year scramble where you face hundreds of uncategorized transactions and vague memories of what each expense was for. Weekly bookkeeping takes 2 to 4 hours per month. Catching up on a year of neglected books takes 20 to 40 hours or $3,000 to $6,000 if you hire someone to do it.
Choosing Accounting Software
Accounting software is the foundation of your financial management. The right choice depends on your sales volume, number of channels, inventory complexity, and whether you plan to do your own books or work with an accountant.
QuickBooks Online is the most widely used accounting software for small businesses and has the strongest ecosystem of ecommerce integrations. Third-party apps like A2X, Synder, and Link My Books connect QuickBooks to Shopify, Amazon, Stripe, and other platforms to automatically record sales, fees, and payouts with proper accrual accounting entries. Plans start at $30 per month for Simple Start, with most ecommerce sellers needing the $60 Plus plan for inventory tracking. QuickBooks is the safest choice if you work with an accountant because nearly every bookkeeper and CPA knows the platform. Our QuickBooks for ecommerce guide covers setup and best practices.
Xero is the strongest alternative to QuickBooks, with a cleaner interface and better multi-currency support for sellers with international operations. Xero handles bank feeds and transaction categorization well, supports the same third-party ecommerce integrations as QuickBooks through apps like A2X, and includes unlimited users on all plans, which matters if multiple team members need access. Plans start at $15 per month for the Starter tier, with the $40 Growing plan covering most ecommerce needs. Xero is particularly strong for businesses that sell internationally and need to manage multiple currencies.
Wave is a free accounting platform that works well for new sellers with simple operations. It handles basic bookkeeping, invoicing, and bank connections without charging a monthly fee. The trade-off is fewer integrations, limited inventory features, and a smaller ecosystem of add-on apps. Wave is a reasonable starting point for a single-channel seller doing under $100,000 in revenue who wants to keep costs minimal while learning bookkeeping fundamentals.
FreshBooks excels at invoicing and is a strong choice for sellers who also provide services, such as a business that sells products on Shopify and also does consulting or custom work. FreshBooks is less robust than QuickBooks or Xero for pure ecommerce inventory management, but its time tracking, proposal, and project features make it valuable for hybrid businesses. Plans start at $19 per month.
Key Accounting Concepts for Online Sellers
Cost of goods sold (COGS) is the direct cost of producing or purchasing the products you sell. It includes the product purchase price, inbound shipping and freight, import duties and tariffs, and any direct costs to prepare the product for sale such as packaging or assembly. COGS does not include marketing, rent, software, or other operating expenses. Calculating COGS correctly is critical because it determines your gross profit margin, which is the fundamental measure of whether your product pricing is sustainable. Our cost of goods sold guide explains exactly what to include and how to calculate it.
Gross profit margin is revenue minus COGS, expressed as a percentage. If you sell a product for $40 and your COGS is $16, your gross margin is 60%. Most successful ecommerce businesses maintain gross margins between 50% and 70% for private label products and 30% to 50% for resold products. If your gross margin is below 30%, you likely cannot sustain the business after accounting for operating expenses. The profit margins guide shows you how to calculate and improve your margins at the product level.
Inventory valuation determines how you assign costs to the products sitting in your warehouse. The three main methods are FIFO (first in, first out), LIFO (last in, first out), and weighted average. FIFO assumes you sell your oldest inventory first and is the most commonly used method for ecommerce. In a rising-cost environment, FIFO results in lower COGS and higher reported profit because the older, cheaper units are matched against revenue first. LIFO does the opposite and is less common, especially for businesses using IFRS standards. The inventory accounting methods guide compares all three approaches with real examples.
Cash vs accrual accounting determines when you recognize revenue and expenses. Cash basis records revenue when money hits your bank account and expenses when money leaves. Accrual basis records revenue when earned (when the product ships) and expenses when incurred (when you receive the supplier invoice), regardless of when cash changes hands. Businesses with over $29 million in average annual gross receipts must use accrual. Smaller businesses can choose, but accrual gives a more accurate picture of your financial position, especially if you carry inventory. The cash vs accrual accounting guide explains when each method makes sense.
Account reconciliation is the process of matching your book records against external statements from your bank, payment processors, and sales platforms. If QuickBooks shows $47,832 in your checking account but the bank statement shows $48,190, you have a $358 discrepancy that needs investigation. Common causes include unrecorded bank fees, transactions that cleared the bank but were not imported to your books, or duplicate entries. Monthly reconciliation catches errors early when they are easy to identify. Our reconciliation guide walks through the process for each platform.
Tax Planning and Filing
Ecommerce tax obligations include federal income tax, state income tax (in most states), self-employment tax for sole proprietors and single-member LLCs, and sales tax collected on behalf of customers. The total tax burden for a profitable ecommerce business typically ranges from 25% to 40% of net profit, depending on your entity structure, state of residence, and total income level.
Quarterly estimated tax payments are required if you expect to owe $1,000 or more in federal taxes for the year. Missing quarterly payments results in underpayment penalties that accrue interest. The quarterly payment deadlines are April 15, June 15, September 15, and January 15. Most ecommerce sellers calculate their quarterly estimate by taking their year-to-date net profit, projecting it to year end, applying their effective tax rate, and dividing by four. Overpaying slightly is better than underpaying because the IRS refunds overpayments but charges penalties on underpayments.
Tax deductions directly reduce your taxable income, so every legitimate deduction you miss is money you overpay to the IRS. Common ecommerce deductions include home office expenses, product costs, shipping materials and postage, website hosting and software subscriptions, advertising and marketing costs, payment processing fees, business insurance premiums, professional services such as accounting and legal, and business equipment depreciation. Keeping organized records throughout the year ensures you capture every deduction at tax time.
Filing your annual return requires understanding which tax forms apply to your business structure. Sole proprietors and single-member LLCs file Schedule C with their personal 1040. Partnerships and multi-member LLCs file Form 1065. S corporations file Form 1120-S. Each structure has different implications for self-employment tax, estimated payments, and deduction strategies. The tax filing guide covers the process for each entity type. If your business has grown beyond simple sole proprietor status, hiring a CPA can save you money in the long run through better tax planning and fewer errors.
Automation and Efficiency
Manual bookkeeping for a multi-channel ecommerce business is not sustainable past a few hundred orders per month. The volume of transactions, the number of fee types, and the complexity of matching platform reports to bank deposits makes manual recording prone to errors and extremely time-consuming. Accounting automation eliminates the bulk of this manual work through direct integrations between your sales channels, payment processors, and accounting software.
The most impactful automation is a platform-to-accounting connection that records daily sales summaries rather than individual transactions. Apps like A2X create a single journal entry for each daily payout from Shopify, Amazon, or Stripe, breaking it down into gross sales, fees, refunds, and net deposit. This approach keeps your books accurate without creating thousands of individual transaction records that slow down your accounting software and make reconciliation tedious.
Bank rules in your accounting software handle recurring transactions automatically. Once you create a rule that says "any deposit from Stripe goes to Sales Revenue," every future Stripe deposit is categorized without manual intervention. Well-configured bank rules can automate 70% to 90% of your transaction categorization, reducing your weekly bookkeeping time to 15 or 20 minutes of reviewing exceptions and verifying that automated rules are working correctly.
End-of-year processes still require manual attention even with strong automation. Year-end tasks include physical or system inventory counts, reviewing and reclassifying miscategorized transactions, confirming 1099 information for contractors, verifying depreciation schedules, and preparing documentation for your tax preparer. Starting your year-end process in November rather than waiting until January gives you time to resolve discrepancies before filing deadlines.