Ecommerce Bookkeeping: A Complete Guide

Most ecommerce store owners did not start their business because they love bookkeeping. But if your books are a mess, you will not know whether you are making money until tax season. By then it is too late to fix anything.

This guide covers everything you need to know about ecommerce bookkeeping: what to track, the most common mistakes, a step-by-step checklist, how to handle multiple currencies and marketplaces, and when it makes sense to hire help.

What Is Ecommerce Bookkeeping?

Ecommerce bookkeeping is the process of recording, organizing, and tracking every financial transaction in an online store. It covers sales, refunds, fees, shipping costs, ad spend, and product costs across every platform where money moves in or out of your business.

Unlike traditional bookkeeping for a brick-and-mortar shop, ecommerce bookkeeping involves more systems, more transaction types, and more timing gaps between when a sale happens and when the money reaches your bank account. A physical store might have one register and one bank account. An ecommerce store might have five or six different platforms, each taking fees and sending payouts on different schedules.

Getting this right matters because your books are the foundation for every financial decision you make. If your books are wrong, your profit numbers are wrong, your tax filings are wrong, and the decisions you base on those numbers are wrong too.

Why Ecommerce Bookkeeping Is Different

A traditional retail business has one register and one bank account. An ecommerce business might have:

• Shopify processing payments and holding funds for several days before paying out
• Stripe or PayPal as additional payment processors, each with their own fee structure
• Meta, Google, and TikTok charging ad spend from different credit cards on different billing cycles
• ShipStation or a 3PL billing for fulfillment, packaging, and outbound shipping
• Recharge collecting subscription payments and taking its own percentage
• Amazon paying out on a 14-day cycle with its own fee deductions
• Sales tax collected in dozens of states, each with different rules and filing schedules

Each of these systems generates transactions, takes fees, and sends money to your bank account on its own schedule. If you only look at your bank deposits, you have no idea what actually happened inside your business.

There are three things that make ecommerce bookkeeping especially tricky:

Multiple sources of truth. Shopify says one revenue number. Stripe says another. Your bank account shows a third. None of them are wrong, but they are each measuring something different. Good ecommerce bookkeeping reconciles all of these into one accurate picture.

What You Need to Track

Revenue (Gross and Net)

Gross revenue is the total amount customers paid before any deductions. Net revenue is what you keep after refunds, returns, and discounts.

The gap between these two numbers matters more than most store owners realize. A store with $100,000 in gross revenue and a 12 percent return rate has only $88,000 in net revenue. That $12,000 difference changes every profit calculation downstream.

Track both numbers, and track refunds as a separate line item rather than just subtracting them from revenue. This way you can see your refund rate trending over time. If it is climbing, you have a product quality or expectation problem that needs attention.

Cost of Goods Sold (COGS)

This is what each product costs you to buy or make. A complete COGS number includes:

• Purchase price from your supplier or raw material costs
• Inbound freight (shipping from supplier to your warehouse)
• Packaging materials (boxes, poly mailers, tissue paper, inserts)
• Customs and duties on imported goods
• Labeling or kitting if you assemble or repackage products

Payment Processing Fees

Every transaction costs money. Shopify Payments charges 2.4 to 2.9 percent plus $0.30 per transaction. Stripe charges similar rates. PayPal often charges more. If you process $50,000 per month, you are paying $1,500 or more just in processing fees.

Ad Spend

Track ad spend by platform (Meta, Google, TikTok) and by month. For most ecommerce businesses, advertising is the largest operating expense after COGS. You need to know your total ad spend relative to revenue so you can measure whether your marketing is actually profitable.

Do not just track the total. Break it down by platform and by campaign type. A store spending $10,000 per month on ads needs to know that $6,000 goes to Meta, $3,000 to Google, and $1,000 to TikTok, because performance varies across platforms.

Shipping Costs

Track both inbound shipping (supplier to you) and outbound shipping (you to customer) as separate line items. Inbound shipping is part of COGS. Outbound shipping is an operating expense.

If you offer free shipping, the cost still exists. It comes out of your margin instead of the customer's pocket. Many store owners do not realize that "free shipping" on a $30 order with a $7 shipping cost means they are giving up 23 percent of the order value before any other expenses.

Operating Expenses

Everything else your business spends money on: software subscriptions (Shopify, Klaviyo, apps), warehouse rent, team payroll, contractor payments, insurance, office supplies, and professional services like your accountant or lawyer.

Track these in categories that are specific enough to be useful. "Software" as a single line item is not helpful when you are paying for 15 different tools. Break it into subcategories so you can see where your money goes and identify subscriptions you no longer need.

Sales Tax

If you collect sales tax, track it separately from revenue. Sales tax is not your money. It is money you collect on behalf of state and local governments and pass through. Mixing sales tax into your revenue numbers makes your business look bigger and more profitable than it actually is.

If you sell in multiple states, track the liability for each state separately so you know exactly what you owe when filing deadlines arrive.

The 5 Most Common Ecommerce Bookkeeping Mistakes

1. Recording Shopify Payouts as Revenue

Shopify sends you a lump sum every few days. That payout is not your revenue. It is revenue minus payment processing fees, minus refunds, minus reserves, minus any Shopify charges. If you record the payout amount as revenue, your books will be wrong by the total of all those deductions.

Over a year, this can add up to tens of thousands of dollars in misrecorded revenue. Your profit and loss statement will show lower expenses than reality because the fees were never recorded.

2. Ignoring the Timing Difference

A customer orders on March 28, you get paid on April 2. Which month does that revenue belong to? Under accrual accounting, it belongs to March because that is when the sale happened. Under cash accounting, it belongs to April because that is when the money arrived.

This matters more than you think. If you run a promotion at the end of the month, accrual accounting shows the revenue bump in that month. Cash accounting might push it into the next month, making it look like you had a slow month followed by a great one.

3. Not Tracking COGS Per Product

If you have 50 products and use one average COGS number for all of them, your margin calculations are wrong for every single product. A $30 product with $5 COGS and a $30 product with $22 COGS have wildly different profitability. You might be spending your ad budget promoting products that barely break even.

Fix: Set up COGS tracking at the SKU level. Update your costs whenever supplier pricing changes. If you import goods, account for exchange rate changes on each purchase order. This takes effort upfront but prevents you from making decisions based on incorrect margins.

4. Mixing Personal and Business Expenses

If your ad account is on your personal credit card, or you buy office supplies with your personal Amazon account, those transactions need to be separated and recorded in your business books. Mixing them creates tax problems, makes your profit and loss statement unreliable, and makes it harder to get a business loan or line of credit.

Fix: Open a dedicated business bank account and credit card. Run every business expense through those accounts. If you do accidentally pay for something personally, record it as an owner contribution and reimburse yourself properly.

5. Reconciling Once a Year

If you only look at your books at tax time, you are 12 months behind. A duplicate charge in January, a missing refund in March, or a miscategorized expense in June will compound into a mess by December. Small errors that take 5 minutes to fix when fresh can take hours to untangle months later.

Ecommerce Bookkeeping Checklist

Breaking your bookkeeping into weekly, monthly, and quarterly tasks makes the work manageable and prevents problems from piling up.

Weekly Tasks

• Categorize transactions. Review new transactions in your accounting software and make sure each one is in the right category. Mislabeled transactions create inaccurate reports.
• Record ad spend. Log your weekly spend by platform (Meta, Google, TikTok) so you always know your running total.
• Check for failed payments. Look for subscription renewals or supplier payments that failed and need to be retried.
• Review refunds and chargebacks. Make sure every refund issued on your store is recorded in your books as a reduction of revenue, not an expense.
• Scan for duplicate charges. Quick check for any transactions that appear twice, especially from apps or subscriptions that may have double-billed.

Monthly Tasks

• Reconcile bank accounts. Match every transaction in your bank statement to a record in your books. Investigate any differences.
• Reconcile payment processors. Compare Shopify, Stripe, and PayPal reports against your accounting records. Each processor's report should tie out exactly.
• Update COGS. If you received new inventory, make sure the costs are recorded correctly, including shipping and duties.
• Review your profit and loss statement. Does the bottom line make sense? Are there any categories that look unusually high or low? See our guide on how to read your ecommerce P&L.
• File and pay sales tax. If you have monthly filing obligations, submit them before the deadline to avoid penalties.
• Archive receipts. Save receipts and invoices for every expense. Digital storage is fine, but make sure they are organized by month and category.

Quarterly Tasks

• Review profit margins by product. Are your margins holding steady, improving, or shrinking? If a product's margin has dropped, investigate whether supplier costs or shipping rates changed.
• Audit subscriptions and software. Cancel any tools you are no longer using. These small charges add up over a year.
• Estimate tax liability. If you make quarterly estimated tax payments, calculate your liability based on year-to-date profit.
• Review your chart of accounts. As your business grows, you may need new categories or subcategories to keep your reporting useful.
• Compare actual vs budget. If you set spending targets for ad spend, shipping, or other categories, check how actual spending compares.

Multi-Currency Ecommerce Bookkeeping

If you sell to customers in other countries, you need to handle currency conversion in your books. This adds complexity, but ignoring it leads to inaccurate profit numbers.

The Core Problem

You sell a product for 50 EUR. At the time of the sale, 50 EUR equals $54 USD. By the time the money reaches your bank account three days later, 50 EUR equals $53.50 USD. You lost $0.50 to exchange rate movement. Where does that loss show up in your books?

Most payment processors (Shopify Payments, Stripe, PayPal) handle the conversion for you and deposit USD into your account. But the exchange rate they use includes a markup of 1 to 2 percent. That markup is a real cost that needs to be tracked.

How to Track It

Record revenue in your home currency (USD) at the exchange rate on the date of the sale. This is the standard accounting approach. When the payout arrives at a slightly different amount, the difference is a "foreign exchange gain or loss" and should be recorded in its own account.

Track conversion fees separately. If Shopify Payments charges a 1.5 percent currency conversion fee on international orders, that is a processing cost, not a foreign exchange loss. Record it alongside your other payment processing fees.

Use your accounting software's multi-currency feature. Both QuickBooks Online and Xero support multi-currency transactions. Turn this on if you have not already. It automatically tracks exchange rate differences and keeps your reporting accurate.

Common Multi-Currency Mistakes

• Ignoring conversion fees entirely. A store doing $20,000 per month in international sales at a 1.5 percent conversion rate is losing $300 per month ($3,600 per year) that never shows up on their P&L.
• Using one exchange rate for the whole month. Exchange rates change daily. If you batch-convert at the end of the month, you lose accuracy. Record each transaction at the rate on its transaction date.
• Forgetting about supplier payments. If you pay suppliers in a foreign currency, the same exchange rate rules apply. Track the conversion cost on purchases, not just sales.

Marketplace Ecommerce Bookkeeping

Selling on marketplaces like Amazon, Etsy, or Walmart adds another layer of bookkeeping complexity. Each marketplace has its own fee structure, payout schedule, and reporting format.

Amazon

Amazon is the most complex marketplace for bookkeeping. Fees include referral fees (8 to 15 percent depending on category), FBA fees (pick, pack, ship), storage fees (monthly and long-term), advertising fees, and various smaller charges. Amazon pays out every 14 days, and each payout groups together hundreds or thousands of transactions with all fees already deducted.

Key challenge: Amazon's settlement reports show the net payout after all deductions. You need to break apart each settlement into gross revenue, referral fees, FBA fees, storage fees, ad costs, and refunds. Tools like A2X or Link My Books automate this.

Do not record Amazon payouts as revenue. This is the same mistake as recording Shopify payouts as revenue, but worse because Amazon takes a larger cut. Your actual revenue could be 30 to 40 percent higher than your payout amount.

Etsy

Etsy charges a listing fee ($0.20 per item), a transaction fee (6.5 percent), and a payment processing fee (3 percent plus $0.25). If you use Etsy Ads, those costs are deducted from your deposit too.

Key challenge: Etsy deposits are net of all fees, and the deposit schedule varies. Break apart each deposit into gross sales, listing fees, transaction fees, processing fees, and ad costs.

Walmart Marketplace

Walmart charges referral fees (6 to 15 percent depending on category) but does not charge monthly subscription fees. Walmart also handles payment processing, so there is no separate processing fee.

Key challenge: Walmart's reporting is less detailed than Amazon's. You may need to manually calculate some fee breakdowns if your accounting integration does not support Walmart directly.

Selling on Multiple Marketplaces

If you sell on more than one marketplace plus your own Shopify store, you need to track revenue and fees separately for each channel. This lets you see which channels are actually profitable after all fees are deducted. A product that earns $25 profit on your own store might only earn $10 on Amazon after referral and FBA fees.

Use your accounting software's class or location tracking to tag each transaction by sales channel. This gives you a profit and loss breakdown per channel without maintaining separate books.

When to Hire a Bookkeeper

Not every store owner needs to hire someone from day one. But as your business grows, doing your own books becomes a poor use of your time. Here is how to think about it.

Do It Yourself (Under $20,000/Month Revenue)

At this stage, the volume of transactions is manageable. You might have 100 to 300 orders per month, one or two ad platforms, and straightforward expenses. Set up QuickBooks or Xero, connect your platforms, and spend 2 to 3 hours per month on bookkeeping.

This works if: You are comfortable with basic accounting concepts, you have connected your platforms to reduce manual entry, and your business model is relatively simple (one store, one country, one currency).

Hire a Part-Time Bookkeeper ($20,000 to $100,000/Month Revenue)

At this volume, bookkeeping takes more time than most owners can afford. You probably have multiple ad platforms, multiple payment processors, higher return volumes, and possibly inventory management complexity.

A part-time bookkeeper costs $500 to $1,500 per month depending on transaction volume and complexity. They handle categorization, reconciliation, and monthly close so you can focus on growing the business.

Look for someone who: Has ecommerce experience specifically (not just general bookkeeping), understands payment processor reconciliation, and is familiar with your accounting software.

Hire a Bookkeeping Service (Over $100,000/Month Revenue)

At this scale, you need consistent, reliable bookkeeping with proper processes. Services like Bench, Pilot, or a dedicated ecommerce accounting firm provide a team rather than a single person, so you are not dependent on one individual.

These services typically cost $1,000 to $3,000 per month. They handle everything from categorization to monthly financial statements. Some specialize in ecommerce and understand platform-specific nuances.

This works if: You want to fully hand off bookkeeping, you need monthly financial statements delivered on a consistent schedule, and you want professional review of your numbers.

What a Bookkeeper Does Not Replace

A bookkeeper records and organizes your financial data. They do not tell you what to do with it. You still need to understand your numbers well enough to make decisions about pricing, ad spend, inventory purchasing, and growth.

How to Set Up Your Books

Step 1: Choose Your Accounting Software

Step 2: Set Up Your Chart of Accounts

Create accounts that match how your business actually works:

• Revenue: Product Sales, Shipping Revenue, Subscription Revenue
• COGS: Product Costs, Packaging, Inbound Freight, Customs and Duties
• Operating Expenses: Ad Spend (by platform), Payment Processing Fees, Outbound Shipping, Software Subscriptions, Payroll, Rent, Professional Services
• Other: Sales Tax Payable, Refunds and Returns, Foreign Exchange Gains/Losses

Keep your chart of accounts detailed enough to be useful but not so granular that categorizing every transaction becomes a chore. If you have 200 line items, you have too many. If you have 10, you do not have enough detail to make decisions.

Step 3: Connect Your Platforms

The fewer manual entries you make, the fewer errors you have. Connect your ecommerce platform, payment processors, and bank accounts to your accounting software. Tools like A2X, Synder, or Link My Books automate the transaction mapping between platforms like Shopify and accounting software like QuickBooks.

For each platform you connect, verify that the mapping is correct for the first month. Check that revenue, fees, and refunds are landing in the right accounts. A misconfigured integration will create wrong data faster than manual entry.

Step 4: Reconcile Monthly

At the end of each month, make sure every bank transaction matches a record in your books. If you have unexplained differences, investigate them before moving on. A $50 discrepancy in January becomes a $600 mystery by December.

Start with your bank statement and work backward. Every deposit should match a payout from a processor or marketplace. Every withdrawal should match an expense in your books. Any amount that does not match needs an explanation.

Ecommerce Bookkeeping and Financial Intelligence

Good ecommerce bookkeeping tells you what happened. Financial intelligence tells you what to do about it.

Bookkeeping records that you spent $5,000 on Meta Ads last month. Financial intelligence tells you that $5,000 generated $18,000 in revenue at a 22 percent net margin, and shows you that shifting some of that budget to Google would improve your overall return.

Nummbas sits on top of your bookkeeping data (through QuickBooks or Xero) and your ecommerce data to give you that intelligence layer. Instead of spending hours building spreadsheets to figure out your real profitability, you get dashboards that show net profit by channel, expense trends, cash flow projections, and recommendations on where to focus next.