Ecommerce Bookkeeping for Beginners: A Simple Guide

Here's an uncomfortable truth: most ecommerce sellers don't do their bookkeeping properly. Some ignore it entirely until tax season rolls around. Others dump everything into a single spreadsheet and hope for the best. A few don't track expenses at all — they just check their bank balance and assume things are fine.

This approach works until it doesn't. And when it stops working, the consequences are painful: surprise tax bills, cash flow crises, incorrect profit calculations, and missed deductions that could have saved you thousands of dollars. Some sellers discover they've been losing money on specific products for months without realizing it.

The reality is that ecommerce bookkeeping for beginners doesn't have to be complicated. You don't need an accounting degree. You don't need to spend hours every week on it. You just need to understand the basics, set up a simple system, and follow it consistently. This guide walks you through everything you need to get started.

Why Bookkeeping Matters for Ecommerce

Before diving into the how, let's address the why. Bookkeeping isn't just a box you check to satisfy the IRS. It serves four critical functions for your ecommerce business:

Tax Compliance

If you're selling online, you owe taxes. Period. The IRS requires you to report all income — including income from platforms like Amazon, Shopify, Etsy, and eBay. Without proper bookkeeping, you risk underreporting income (which triggers audits and penalties) or overreporting income (which means you're paying more tax than you should).

Good bookkeeping also ensures you capture every legitimate deduction. Ecommerce sellers often miss deductions for home office expenses, software subscriptions, shipping supplies, and product samples. These add up fast.

Profit Tracking

Revenue is not profit. This sounds obvious, but a shocking number of sellers confuse the two. Your Shopify dashboard might show $50,000 in sales last month, but after you subtract product costs, platform fees, shipping, advertising, returns, and software subscriptions, your actual profit might be $5,000 — or even negative.

Bookkeeping gives you the real numbers. You can see exactly how much profit each product generates, which sales channels are most profitable, and where your money is actually going. Use our free profit calculator to get a quick snapshot of your margins.

Loan and Funding Applications

If you ever want to apply for a business loan, a line of credit, or bring on investors, they'll ask for your financial statements. Clean, organized books make this process smooth. Messy or nonexistent books can disqualify you from funding opportunities or result in less favorable terms.

Better Business Decisions

Should you invest more in advertising? Can you afford to hire a virtual assistant? Is it time to expand to a new marketplace? These decisions require data. Bookkeeping provides that data. Without it, you're guessing — and guessing with real money is a bad strategy.

Ecommerce Bookkeeping Basics

Let's cover the fundamental concepts you need to understand. Don't worry — we'll keep this practical, not academic.

Revenue Recognition

When do you record a sale? For most ecommerce sellers, revenue is recognized when the order is placed and payment is processed. However, if you accept pre-orders or have subscription models, the timing can differ. The key principle is consistency: pick a method and stick with it.

Also, be aware that gross revenue is not the same as net revenue. Gross revenue is the total amount customers pay. Net revenue is what remains after you subtract returns, refunds, and discounts. Your bookkeeping should track both.

Cost of Goods Sold (COGS)

COGS represents the direct costs of producing or purchasing the products you sell. This includes:

Product purchase price or manufacturing cost
Inbound shipping and freight
Customs duties and import taxes
Packaging materials (product-specific packaging, not shipping boxes)
Labeling and prep costs

COGS is one of the most important numbers in your business because Revenue minus COGS equals Gross Profit. If your COGS is too high relative to your selling price, no amount of marketing will make the product profitable.

Expense Categories

Beyond COGS, your business has operating expenses. These need to be categorized properly so you can see where your money goes. Common ecommerce expense categories include platform fees, payment processing fees, shipping costs, advertising spend, software subscriptions, office supplies, and professional services (accountant, lawyer, etc.).

The more granular your categories, the more useful your financial data becomes. Don't lump everything into "business expenses" — break it out so you can analyze spending patterns.

Accrual vs. Cash Basis Accounting

This is an important choice for your business:

Cash basis: You record income when you receive payment and expenses when you pay them. Simple and intuitive. Most small ecommerce sellers start here.
Accrual basis: You record income when it's earned and expenses when they're incurred, regardless of when cash changes hands. More accurate for businesses with inventory, but more complex.

If your business earns less than $30 million in annual gross receipts, you can generally use either method. Cash basis is easier for beginners, but if you carry significant inventory, accrual basis gives you a more accurate financial picture. Consult a tax professional to determine which is best for your situation.

Key Financial Reports You Need

Proper bookkeeping produces three essential financial reports. Think of these as the vital signs of your business — they tell you whether your business is healthy or heading for trouble.

Profit and Loss Statement (P&L)

Also called an income statement, the P&L shows your revenue, costs, and expenses over a specific period (usually monthly or quarterly). It answers the fundamental question: "Is my business making money?"

The basic structure is:

Revenue (total sales)
Minus COGS = Gross Profit
Minus Operating Expenses = Operating Profit
Minus Taxes and Interest = Net Profit

Review your P&L monthly. Look for trends — are expenses growing faster than revenue? Is your gross margin shrinking? Catch problems early before they become crises.

Balance Sheet

The balance sheet is a snapshot of your business's financial position at a specific point in time. It shows three things:

Assets: What your business owns (cash, inventory, equipment, accounts receivable)
Liabilities: What your business owes (loans, credit card balances, accounts payable)
Equity: The difference between assets and liabilities — your ownership stake in the business

The balance sheet follows a simple formula: Assets = Liabilities + Equity. If this equation doesn't balance, something is wrong with your bookkeeping.

Cash Flow Statement

The cash flow statement tracks the actual movement of cash in and out of your business. This is critical because a business can be profitable on paper and still run out of cash. This happens more often than you'd think in ecommerce, especially when you're investing heavily in inventory.

For example, you might place a $20,000 inventory order in January that you expect to sell over 3 months. Your P&L will show profits as those sales happen, but your cash flow took a massive hit in January. The cash flow statement makes this visible.

Setting Up Your Chart of Accounts

Your chart of accounts is the organizational framework for your bookkeeping. It's a list of all the categories (accounts) you use to classify your financial transactions. Getting this right from the start saves you from a painful reorganization later.

Here's a chart of accounts tailored for ecommerce businesses:

Category	Account Name	Type
Revenue	Product Sales	Income
Revenue	Shipping Revenue	Income
Revenue	Refunds & Returns	Contra Income
COGS	Product Costs	Cost of Goods Sold
COGS	Inbound Freight & Shipping	Cost of Goods Sold
COGS	Customs & Duties	Cost of Goods Sold
COGS	Packaging Materials	Cost of Goods Sold
Expenses	Platform / Marketplace Fees	Operating Expense
Expenses	Payment Processing Fees	Operating Expense
Expenses	Outbound Shipping & Postage	Operating Expense
Expenses	Advertising & Marketing	Operating Expense
Expenses	Software & Subscriptions	Operating Expense
Expenses	Office & Supplies	Operating Expense
Expenses	Professional Services	Operating Expense
Expenses	Insurance	Operating Expense

You can add or adjust accounts as your business grows. The important thing is to start with a structure that separates your major cost categories so you can track them independently.

Tracking Ecommerce-Specific Expenses

Ecommerce businesses have expenses that don't exist in traditional retail. These are easy to overlook — and when they're missed, your profit calculations are wrong. Here are the expenses you need to track carefully:

Platform and Marketplace Fees

Amazon charges referral fees (typically 8%–15% of the sale price), FBA fees, and various other charges. Shopify charges a monthly subscription plus transaction fees. Etsy takes listing fees, transaction fees, and payment processing fees. eBay has insertion fees and final value fees. Each platform has its own fee structure, and these fees can eat 15%–30% of your gross revenue.

Payment Processing Fees

Every time a customer pays with a credit card, you pay a processing fee — usually around 2.9% + $0.30 per transaction. If you use PayPal, Stripe, or Shopify Payments, these fees vary slightly. Track them as a separate line item, not bundled with other platform fees.

Refunds and Returns

Returns are a reality in ecommerce. The cost isn't just the refunded amount — it includes return shipping, restocking labor, and potentially unsellable inventory. Some sellers experience return rates of 10%–30% depending on the category. Your books need to reflect the true cost of returns, including any partial refunds and return shipping you absorb.

Advertising and Marketing Costs

Amazon PPC, Facebook Ads, Google Ads, influencer fees, email marketing software — advertising spend can quickly become your second-largest expense after COGS. Track each advertising channel separately so you can calculate the return on ad spend (ROAS) for each one.

Inventory Costs

Inventory is technically an asset on your balance sheet, not an expense. It only becomes an expense (COGS) when the item is sold. This distinction matters for tax purposes and is one reason why accrual accounting can be more accurate for inventory-heavy businesses. Also track inventory shrinkage — products lost, damaged, or stolen.

Shipping and Fulfillment

If you fulfill orders yourself, track the cost of shipping supplies (boxes, tape, labels, poly mailers), postage, and any warehouse or storage costs. If you use a third-party logistics (3PL) provider, track their per-order fees, storage fees, and any additional charges. These costs are easy to underestimate and can significantly impact your margins.

DIY vs. Hiring a Bookkeeper vs. Using Software

There's no one-size-fits-all answer to how you should handle your bookkeeping. The right approach depends on your business stage, complexity, and budget. Here's a comparison:

Factor	DIY (Spreadsheets)	Bookkeeping Software	Hire a Bookkeeper
Monthly Cost	$0	$0–$80/month	$300–$1,000+/month
Time Required	4–8 hours/month	1–3 hours/month	Minimal
Accuracy	Moderate (error-prone)	High (automated)	High (professional)
Scalability	Low	High	High
Best For	Just starting out, <$10K/month revenue	Growing sellers, $10K–$100K/month	Established sellers, $100K+/month or complex operations
Learning Curve	Low	Moderate	None
Ecommerce Integrations	Manual	Automated	Depends on provider

Our recommendation: Start with bookkeeping software as soon as possible. Even if you're a brand-new seller, the automation saves you time and reduces errors. As your business grows past $100K in monthly revenue or involves multiple entities, sales channels, and complex inventory, bring in a professional bookkeeper or accountant.

5 Best Bookkeeping Tools for Ecommerce

Here are the top bookkeeping tools that work well for ecommerce businesses, from full-featured platforms to specialized connectors:

1. QuickBooks Online

QuickBooks Online is the most popular small business accounting software in the US, and for good reason. It offers robust ecommerce integrations with platforms like Shopify, Amazon, and WooCommerce. Features include automated bank feeds, invoicing, expense tracking, inventory management, and comprehensive financial reporting.

Price: Starting at $30/month (Simple Start plan)
Pros: Huge ecosystem of integrations and add-ons, widely used (easy to find accountants who work with it), strong mobile app
Cons: Can get expensive with add-ons, interface has a learning curve for non-accountants
Best for: US-based sellers who want the broadest integration options

2. Xero

Xero is a cloud-based accounting platform that's especially popular with international sellers and businesses outside the US. It's known for its clean interface and strong multi-currency support — a major advantage for cross-border ecommerce.

Price: Starting at $15/month (Starter plan)
Pros: Excellent multi-currency handling, unlimited users on all plans, clean design
Cons: Fewer US-specific integrations than QuickBooks, some features limited on lower-tier plans
Best for: International sellers, multi-currency businesses, and those who prefer a modern interface

3. Wave (Free)

Wave offers completely free accounting and invoicing software — no trial period, no feature gating. It's funded by optional paid services like payment processing and payroll. For very small ecommerce businesses or those just getting started, Wave is hard to beat on value.

Price: Free (paid add-ons for payroll and payments)
Pros: Genuinely free, easy to learn, decent reporting
Cons: Limited ecommerce integrations, no inventory management, fewer features than paid tools
Best for: Brand-new sellers on a tight budget who need basic bookkeeping

4. FreshBooks

FreshBooks started as invoicing software but has grown into a full accounting platform. It's praised for being extremely beginner-friendly — the interface is designed for business owners, not accountants. Time tracking and project-based billing features make it great for sellers who also offer services.

Price: Starting at $19/month (Lite plan)
Pros: Very easy to use, excellent customer support, strong invoicing features
Cons: Limited inventory tracking, fewer ecommerce-specific integrations
Best for: Sellers who also provide services (consulting, design) alongside physical products

5. A2X

A2X isn't a standalone accounting tool — it's a connector that automates the flow of ecommerce data into QuickBooks or Xero. It pulls settlement data from Amazon, Shopify, eBay, Etsy, and Walmart, then categorizes and posts accurate journal entries into your accounting software. If you sell on multiple platforms, A2X can save you hours of manual data entry every month.

Price: Starting at $19/month per channel
Pros: Extremely accurate transaction matching, handles multi-channel complexity, saves significant time
Cons: Requires QuickBooks or Xero as the base accounting software, adds to total software cost
Best for: Multi-channel sellers who need precise, automated bookkeeping entries

Monthly Bookkeeping Checklist

Consistency is the key to good bookkeeping. Set aside time at the end of each month (or the beginning of the next) to complete these 10 tasks. Once you've done it a few times, it takes about 1–2 hours:

Reconcile all bank accounts and credit cards. Match every transaction in your accounting software with your bank statements. Fix any discrepancies immediately.
Categorize all transactions. Make sure every income and expense transaction is assigned to the correct account in your chart of accounts.
Review and record marketplace payouts. Check settlement reports from Amazon, Shopify, Etsy, or other platforms. Ensure payouts match what's in your bank account.
Update inventory records. Record new inventory purchases, adjust for items sold, and account for any shrinkage, damages, or returns to stock.
Record refunds and returns. Log all refunds issued during the month and the associated costs (return shipping, restocking, unsellable inventory).
Track advertising spend by channel. Pull reports from Amazon Ads, Facebook Ads, Google Ads, and any other advertising platforms. Record the exact amounts spent.
Review subscription and software charges. Check for any new or changed subscription fees. Cancel tools you're no longer using.
Generate and review your P&L statement. Look at your revenue, COGS, gross profit, expenses, and net profit. Compare to previous months and note any significant changes.
Check accounts receivable and payable. Follow up on any outstanding invoices. Make sure all bills are paid on time to avoid late fees.
Back up your financial data. Export your reports and save copies in a secure location. Cloud accounting software does this automatically, but keep your own backups as well.

Pro tip: Schedule a recurring calendar event for your monthly bookkeeping session. Treat it like a non-negotiable appointment with your business. Skipping one month makes the next month twice as hard.

Frequently Asked Questions

Do I need a separate bank account for my ecommerce business?

Yes, absolutely. Mixing personal and business finances is one of the most common bookkeeping mistakes. A separate business bank account makes bookkeeping dramatically easier, provides clearer financial records for tax time, and is required if your business is structured as an LLC or corporation. Even if you're a sole proprietor, a separate account is strongly recommended.

How often should I do my bookkeeping?

At minimum, do a full bookkeeping review once a month using the checklist above. However, daily habits make the monthly review much easier. Get into the habit of categorizing transactions as they happen, saving receipts immediately, and checking your dashboard weekly. The more frequently you touch your books, the less overwhelming it feels.

Can I do ecommerce bookkeeping myself, or do I need an accountant?

Most ecommerce sellers can handle their own bookkeeping using software like QuickBooks or Xero, especially when combined with a connector like A2X. However, you should still work with a tax professional (CPA or enrolled agent) at least once a year to file your taxes, ensure compliance, and identify tax-saving strategies. As your business grows in complexity — multiple entities, international sales, employees — the value of a professional bookkeeper increases significantly.

Start Getting Your Books in Order

Ecommerce bookkeeping for beginners doesn't have to be intimidating. The core concepts are straightforward: track your income, categorize your expenses, reconcile your accounts, and review your financial reports regularly. Start with the right tools, set up a proper chart of accounts, and commit to a monthly routine.

The sellers who succeed long-term aren't just good at marketing or product sourcing — they know their numbers. They can tell you their exact profit margins, their cost per acquisition, and their cash flow projections. That clarity comes from good bookkeeping.

Take the first step today: calculate your true profit margins with our free tool, then set up your bookkeeping system using one of the tools recommended above. Your future self — especially at tax time — will thank you.