Bookkeeping Basics for Online Sellers

Before You Start

Proper bookkeeping requires two things already in place: a dedicated business bank account and accounting software. If your business transactions are mixed into a personal checking account, separate them before doing anything else. Going forward, every business purchase, deposit, and transfer should flow through the business account. This single step eliminates the most common bookkeeping problem, which is figuring out which transactions are personal and which are business.

You do not need an accounting degree to handle bookkeeping for a small ecommerce business. Modern software automates the majority of transaction recording through bank feeds and integrations. Your job is setting up the system correctly, categorizing transactions that the software cannot match automatically, and reviewing the numbers weekly to catch errors early. If your business grows beyond 500 to 1,000 orders per month or you start feeling overwhelmed, that is the point where hiring a bookkeeper or accountant makes financial sense.

Step-by-Step Bookkeeping Setup

Understanding the Chart of Accounts

Your chart of accounts organizes every financial transaction into five types: assets, liabilities, equity, revenue, and expenses. For daily bookkeeping, you will work primarily with revenue accounts (money coming in from sales) and expense accounts (money going out for costs). Understanding the other three types matters for reading your financial statements and communicating with your accountant.

Revenue Accounts

Create separate revenue accounts for each sales channel and revenue type. A typical ecommerce chart of accounts includes Shopify Sales, Amazon Sales, Etsy Sales, Wholesale Revenue, and Other Revenue. Keeping channels separate lets you see which platform generates the most revenue and track trends over time. Some sellers create further sub-accounts within each channel for product categories, but this level of detail is only necessary if you need category-level profitability reporting that your ecommerce platform does not already provide.

Cost of Goods Sold Accounts

Cost of goods sold is the direct cost of the products you sell and appears as a separate section on your income statement between revenue and operating expenses. COGS sub-accounts typically include Product Purchases (the cost of inventory), Inbound Freight (shipping from supplier to your warehouse), Import Duties and Tariffs, Packaging Materials, and Direct Labor if you have warehouse staff assembling or preparing products. COGS subtracted from revenue gives you gross profit, which is the most important number for evaluating whether your product pricing is viable.

Operating Expense Accounts

Operating expenses are everything you spend to run the business that is not directly tied to producing or purchasing products. Common categories include Payment Processing Fees, Shipping and Postage (outbound to customers), Advertising and Marketing, Software and Subscriptions, Office Supplies, Professional Services (accounting, legal), Rent (if you have warehouse space), Utilities, Insurance, Bank Fees, and Depreciation. The more specific your expense categories, the easier it is to identify cost-cutting opportunities and prepare accurate tax returns.

Asset and Liability Accounts

Assets include your bank accounts (checking, savings), accounts receivable (money owed to you), inventory on hand, equipment, and prepaid expenses. Liabilities include accounts payable (money you owe to suppliers), sales tax collected but not yet remitted, credit card balances, and loans. The difference between total assets and total liabilities is your equity, which represents the net value of your business. You do not interact with these accounts as frequently in daily bookkeeping, but they appear on your balance sheet and are important for understanding your overall financial position.

Recording Common Ecommerce Transactions

Sales and Payment Processor Deposits

When a customer buys a $50 product on Shopify and pays with a credit card, Shopify Payments collects $50, deducts its processing fee (approximately $1.75 for a 2.9% + $0.30 fee), and deposits $48.25 to your bank account. The correct bookkeeping entry records $50 in gross revenue, $1.75 in payment processing fees, and $48.25 as the bank deposit. Many sellers make the mistake of only recording the net deposit as revenue, which understates both revenue and expenses and creates discrepancies with their 1099-K forms.

Integration apps like A2X automate this by creating daily summary journal entries that break each payout into its gross revenue, fee, refund, and net deposit components. Without an integration app, you need to manually reconcile each deposit against the platform's payout report, which is manageable for small volumes but becomes impractical above a few hundred orders per month.

Inventory Purchases

When you buy inventory, record it as an asset (Inventory on Hand), not as an expense. The cost moves from your Inventory asset account to your Cost of Goods Sold expense account only when the product sells. If you buy 200 units at $10 each ($2,000 total), your inventory increases by $2,000. As you sell each unit, $10 moves from Inventory to COGS. This is how inventory accounting works under accrual basis, and it ensures your profit is calculated correctly by matching revenue with the cost of the specific products sold.

Refunds and Returns

Record refunds as negative revenue, not as an expense. If you refund a customer $50, reduce your sales revenue by $50 rather than creating a $50 expense entry. This keeps your gross revenue and refund rate calculations accurate. If the payment processor does not refund its processing fee (most do not refund the full fee on refunds), the difference is a real cost that stays in your processing fee expense account.

Sales Tax Collected

Sales tax you collect from customers is not your revenue. It is a liability, meaning money you hold temporarily on behalf of the state and must remit on the required schedule. Record collected sales tax in a Sales Tax Payable liability account. When you remit the payment to the state, reduce the liability account by the amount paid. Your accounting software can track this automatically if your sales platform reports tax collected, and tools like TaxJar and Avalara can automate the entire process including filing returns.

Common Bookkeeping Mistakes to Avoid

Recording net deposits as revenue. Your 1099-K from Stripe or Shopify reports gross payment volume, not net deposits. If you recorded net deposits as revenue all year, your reported revenue will be lower than your 1099-K, which triggers IRS questions. Always record gross revenue and separate out fees.

Expensing inventory purchases immediately. Buying $5,000 of inventory is not a $5,000 expense. It is converting $5,000 of cash into $5,000 of inventory. The expense only happens as products sell. Recording the full purchase as an immediate expense inflates your expenses in the purchase month and understates them in selling months, making your monthly profit reports inaccurate and your tax estimates unreliable.

Mixing personal and business transactions. Every personal charge on a business card or personal deposit into a business account creates a reconciliation headache. If it happens, record it immediately as an owner draw (money out) or owner contribution (money in) so the books stay clean. The better solution is simply never using your business account for personal spending.

Ignoring books for months. Bookkeeping gets exponentially harder the longer you wait. A week-old transaction is easy to categorize from memory. A six-month-old transaction often requires digging through emails, receipts, and platform records to figure out what it was. The weekly 30-minute habit saves hours of catch-up work and significantly reduces errors.

Not saving receipts for expenses over $75. The IRS requires documentation for business deductions. Digital receipts in your email are acceptable, but you need a system to find them. Most accounting apps let you photograph receipts and attach them to transactions. At minimum, keep a dedicated folder in your email for business receipts.

Building a Sustainable Bookkeeping Routine

The most effective bookkeeping routine is one you actually follow. For most ecommerce sellers, the following schedule balances accuracy with time investment.

Weekly (30 to 60 minutes): Review and categorize new transactions in your accounting software. Check for uncategorized items, duplicates, and obvious errors. Verify that recent payment processor deposits match expected amounts. File or tag any new receipts.

Monthly (1 to 2 hours): Reconcile all bank accounts and credit cards against statements. Review your profit and loss statement for the month. Check that COGS and gross margins look reasonable. Verify sales tax liability balances. Generate and save a monthly P&L and balance sheet for your records.

Quarterly (2 to 3 hours): Calculate and pay estimated tax payments. Review year-to-date financials against your budget or projections. Clean up any lingering uncategorized transactions. Review bank rules and update for new recurring transactions. Assess whether your bookkeeping system is keeping up with your business growth.

Annually (4 to 8 hours): Complete the year-end accounting checklist. Perform a physical or system inventory count. Reconcile 1099 forms against your records. Review all expense categories for missed tax deductions. Prepare documentation for your tax return or deliver organized books to your CPA.