Ecommerce Bookkeeping for Beginners: Clean Finances Guide

Your Store Is Making Money — But Do You Know Where It Goes?

Most Shopify merchants can tell you their revenue number off the top of their head. Far fewer can tell you their actual profit after transaction fees, shipping costs, returns, ad spend, and sales tax obligations are subtracted. That gap between perceived profit and real profit is where businesses quietly bleed out.

Ecommerce bookkeeping for beginners does not need to be complicated, but it does need to happen. According to A2X's ecommerce accounting guide, the most common reason ecommerce businesses fail financially is not low revenue — it is poor financial visibility. Owners make spending decisions based on bank balances instead of actual profit and loss statements, and the consequences compound every month.

This guide walks you through every foundational concept you need to keep your ecommerce finances clean from day one. You will learn the difference between cash and accrual accounting, how to set up a chart of accounts built for online retail, how to track COGS properly, how to handle sales tax records, how to reconcile your books, which software fits your stage, and when it makes sense to hand the work to a professional.

Cash vs. Accrual Accounting: Pick the Right Method First

Before you record a single transaction, you need to decide how you will recognize revenue and expenses. This is not an abstract accounting theory question — it directly affects your tax filings, your profit calculations, and how you understand your cash position.

How Cash Basis Accounting Works

Cash basis accounting records revenue when money hits your bank account and expenses when money leaves it. If a customer places an order on Monday and Shopify deposits the payout on Wednesday, you record the revenue on Wednesday.

Advantages for beginners:

• Simple to set up and maintain
• Matches your bank statement naturally
• Gives you a clear picture of cash on hand right now
• No tracking of accounts receivable or payable needed

Limitations:

• Does not match revenue to the period it was earned
• Distorts profitability when you prepay for inventory or receive delayed payouts
• Cannot track accounts receivable or payable accurately

How Accrual Basis Accounting Works

Accrual accounting records revenue when it is earned (at the point of sale) and expenses when they are incurred, regardless of when cash actually moves. If you purchase $5,000 of inventory in January and sell it across February and March, accrual accounting spreads that cost across the months where the sales happen.

According to LedgerGurus, accrual accounting is more suitable for businesses dealing with inventory because it provides a clearer picture of profitability even when payments are delayed.

Which Method Should You Choose?

The practical recommendation: start with cash basis if you are under $100,000 in annual revenue with a simple product catalog. Switch to accrual once you carry significant inventory, sell across multiple channels, or plan to seek financing. Lenders and investors expect accrual-based financial statements.

Setting Up Your Chart of Accounts for Ecommerce

A chart of accounts is the backbone of your bookkeeping system. It is the categorized list of every account where you record transactions — think of it as the filing system for your money. According to Finaloop's chart of accounts guide, ecommerce businesses have unique financial complexities that require specialized account structures compared to traditional brick-and-mortar setups.

The Five Core Account Categories

Every chart of accounts follows the same five-category framework:

1. Assets — what your business owns (bank accounts, inventory, prepaid expenses, equipment)
2. Liabilities — what your business owes (credit cards, loans, sales tax payable, gift card balances)
3. Equity — the owner's stake (owner's investment, retained earnings, owner's draws)
4. Revenue — money earned from operations (product sales, shipping revenue, gift card redemptions)
5. Expenses — costs of running the business (COGS, advertising, transaction fees, software subscriptions)

Ecommerce-Specific Accounts You Need

Standard templates miss the accounts that matter most for online sellers. Here is what to add:

Revenue accounts:

• Product sales (broken out by channel if you sell on Shopify + Amazon + wholesale)
• Shipping income (what customers pay for shipping)
• Discounts given (contra-revenue — reduces gross sales)
• Returns and refunds (contra-revenue)

Expense accounts:

• Cost of goods sold (COGS)
• Shopify transaction fees (2.9% + $0.30 per transaction on Basic)
• Payment processing fees (PayPal, Shop Pay Installments, third-party gateways)
• Shipping and fulfillment costs
• Advertising spend (break out by platform: Meta, Google, TikTok)
• Software and app subscriptions
• Packaging materials

Liability accounts:

• Sales tax payable (by jurisdiction)
• Gift card liability (sold but unredeemed gift cards are a liability, not revenue)
• Customer deposits or pre-orders

Keep It Simple, Then Expand

The biggest mistake beginners make is creating too many accounts upfront. Start with 20 to 30 accounts. You can always add sub-accounts later as your business grows and you need more granularity. A bloated chart of accounts makes reconciliation harder and increases the chance of miscategorization.

COGS Tracking: Know What Your Products Actually Cost

Cost of goods sold is the single most important number in your bookkeeping system after revenue. Get COGS wrong, and every profitability metric downstream — gross margin, net margin, contribution margin — becomes unreliable.

The COGS Formula

The standard formula is straightforward:

COGS = Beginning Inventory + Purchases During Period - Ending Inventory

For a Shopify store that started the month with $10,000 in inventory, purchased $4,000 more, and ended with $6,000 remaining, COGS for the month is $8,000.

What to Include in COGS

LedgerGurus' COGS guide breaks COGS into these components for ecommerce:

• Product cost — what you pay your supplier per unit
• Inbound freight — shipping from manufacturer to your warehouse
• Customs and duties — for internationally sourced products
• Assembly or kitting labor — if you bundle or customize products before shipping
• Packaging materials — boxes, inserts, branded tissue paper (if part of the product experience)

What Does NOT Belong in COGS

These are operating expenses, not COGS:

• Outbound shipping to customers (this is a fulfillment expense)
• Advertising and marketing spend
• Shopify subscription fees
• Office rent or coworking space
• Software subscriptions

Inventory Costing Methods

You need to pick a method for valuing the inventory you sell:

FIFO is the default choice for most Shopify stores. It is the most commonly accepted method, matches how most businesses actually move product, and is required under IFRS (international standards). If you use QuickBooks or Xero, both support FIFO natively.

Sales Tax Recordkeeping That Keeps You Compliant

Sales tax is not your money. It is money you collect on behalf of state and local governments, hold temporarily, and remit on a schedule. Treating it as revenue — even accidentally — creates a liability that grows with every transaction.

What You Need to Track

For every order where sales tax applies, your records should capture:

• Tax jurisdiction (state, county, city, special district)
• Tax rate applied at the time of the transaction
• Tax amount collected per line item
• Product taxability — some products are exempt in certain states (clothing in Pennsylvania, groceries in most states)
• Nexus status — which states you have a collection obligation in

Shopify's Built-In Tax Tracking

Shopify handles tax calculation and collection at checkout automatically once you configure it in Settings > Taxes and duties. The admin generates tax reports you can pull for filing, broken down by jurisdiction.

However, Shopify does not file your taxes for you. You need either a manual filing process or an automation tool like TaxJar or Avalara to handle filing and remittance.

Organize Tax Records by Filing Period

Create a folder structure (digital or in your accounting software) organized by:

1. State — one folder per state where you have nexus
2. Filing period — monthly, quarterly, or annually depending on the state's requirements
3. Documentation — keep the Shopify tax report, your filing confirmation, and payment receipt together

This makes audit defense straightforward. If a state sends a notice, you can pull the complete record for any period in under a minute.

Bank Reconciliation: The Habit That Catches Everything

Reconciliation is the process of matching your bookkeeping records against your actual bank and payment processor statements. It is the single most important financial hygiene habit in ecommerce, and skipping it is the number one way small errors become large problems.

How Reconciliation Works

According to Stripe's reconciliation guide, ecommerce reconciliation involves a three-way match:

1. Sales records — orders in Shopify
2. Payment processor records — Shopify Payments, PayPal, or other gateway reports
3. Bank deposits — actual money that arrived in your account

When all three match, the transaction is reconciled. When they do not, you have a discrepancy to investigate.

Why Ecommerce Reconciliation Is Tricky

Unlike a retail store where you count cash in a register, ecommerce has timing gaps:

• Shopify batches payouts, so a single bank deposit might represent 2-3 days of orders minus fees, refunds, and chargebacks
• Payment processors hold reserves on new accounts
• Returns processed today may reference orders from weeks ago
• Currency conversion adds another layer for international sales

The Monthly Reconciliation Process

Follow these steps at the end of every month:

1. Pull your bank statement for the month
2. Pull your Shopify payout report (Settings > Payments > View payouts)
3. Pull your accounting software's ledger for the same period
4. Match each bank deposit to the corresponding Shopify payout
5. Match each payout to the underlying orders in your books
6. Investigate discrepancies — common causes include timing differences, unrecorded refunds, bank fees, and chargebacks
7. Adjust your books for any missed or miscategorized items

Spreadsheets vs. Software: Which Tool Fits Your Stage

Every new store owner faces this decision: can you get by with a spreadsheet, or do you need real accounting software from the start?

When Spreadsheets Work

A well-built spreadsheet handles bookkeeping just fine if:

• You process fewer than 50 orders per month
• You sell on one channel (Shopify only)
• You have a simple product catalog (under 20 SKUs)
• You do not carry significant inventory
• You file sales tax in one or two states

Google Sheets or Excel with a basic income/expense tracker, a COGS calculator, and a reconciliation tab can cover these needs. The key is discipline — you must update it consistently.

When You Need Software

Switch to accounting software when any of these become true:

• Order volume exceeds 50-100/month — manual entry becomes error-prone
• Multi-channel sales — Shopify plus Amazon, Etsy, or wholesale requires consolidation
• Inventory complexity — more than 50 SKUs or variable costs
• Sales tax in 3+ states — tracking and filing manually becomes risky
• You want automated bank feeds — software pulls transactions directly from your bank
• You work with an accountant or bookkeeper — they need software access, not a spreadsheet

The Hidden Cost of Sticking with Spreadsheets Too Long

The real danger is not that spreadsheets are bad — it is that they degrade silently. One missed entry, one formula error, one copy-paste mistake in month four creates a cascade of inaccurate data that you will not notice until tax season or until you try to get a business loan and your numbers do not hold up.

QuickBooks vs. Xero vs. Wave: Choosing Your Software

The three most popular accounting platforms for ecommerce businesses each serve a different profile. Here is how they compare for Shopify store owners.

QuickBooks Online

QuickBooks Online is the most widely used small business accounting software in the US, and the one most CPAs and bookkeepers prefer to work with. According to NerdWallet's comparison, QuickBooks holds the advantage for businesses that work closely with accountants.

Pricing: $35/month (Simple Start) to $235/month (Advanced)

Strengths:

• Largest ecosystem of integrations and accountant familiarity
• Strong inventory tracking and COGS reporting
• Direct Shopify integration via apps like A2X and Synder
• Class and location tracking for multi-channel reporting
• Robust reporting engine

Weaknesses:

• Gets expensive fast — most stores need the $65/month Essentials plan minimum
• User limits on lower tiers (1 user on Simple Start, 3 on Essentials)
• Interface can feel cluttered

Xero

Xero is the top alternative, particularly strong for international sellers and businesses that want unlimited users without paying per seat.

Pricing: $20/month (Starter) to $54/month (Premium)

Strengths:

• Unlimited users on every plan
• Clean, modern interface
• Strong multi-currency support
• Excellent Shopify-Xero integration options
• Bank reconciliation workflow is best-in-class

Weaknesses:

• Smaller accountant/bookkeeper adoption in the US (stronger in UK, Australia, NZ)
• Fewer third-party integrations than QuickBooks
• Limited inventory features on lower tiers

Wave

Wave offers free accounting software that covers the basics for very early-stage businesses.

Pricing: Free for accounting; paid for payroll ($40/month + $6/employee) and payments (2.9% + $0.60 per transaction)

Strengths:

• Completely free core accounting and invoicing
• Simple, intuitive interface
• Good enough for pre-revenue or very early-stage stores
• Basic financial reports included

Weaknesses:

• No inventory management
• Limited integrations (no native Shopify connection — requires Zapier or manual entry)
• No multi-currency support
• Minimal scalability

Quick Comparison

The recommendation: if you are serious about building a real business, start with QuickBooks or Xero. The $20-35/month investment pays for itself the first time it catches an error or saves you an hour of manual work. Wave is fine for validating a business idea, but plan to migrate within your first year of real sales.

When to Hire a Bookkeeper

At some point, doing your own books stops being frugal and starts costing you money in the form of errors, missed deductions, and time you should spend on growth. According to Bench, recognizing the right moment to bring in help is one of the highest-leverage decisions a small business owner can make.

Signs You Have Outgrown DIY Bookkeeping

• Your monthly reconciliation takes more than 2-3 hours
• You have unreconciled months piling up
• Tax season requires a frantic scramble to organize records
• You are unsure whether your financial statements are accurate
• You sell on multiple channels and struggle to consolidate data
• You have employees or contractors requiring payroll
• Revenue exceeds $250,000/year and the stakes of errors are significant

Your Options

What to Look for in an Ecommerce Bookkeeper

Not every bookkeeper understands ecommerce. According to EcomBalance, finding someone who has worked specifically with online businesses is critical. Screen for Shopify experience (payout reports, transaction fees, multi-channel data), software proficiency in QuickBooks or Xero plus integration tools like A2X or Synder, COGS understanding (inventory costing, landed costs, returns), and sales tax familiarity (nexus, multi-state filing). Monthly financial review calls should be standard — anything less is a red flag.

Common Bookkeeping Mistakes to Avoid

According to Zamp's research, nearly 6 in 10 accountants working for US-based ecommerce companies make several bookkeeping mistakes per month. Here are the ones that cost store owners the most.

Mixing Personal and Business Finances

This is the number one mistake and the easiest to fix. Open a dedicated business bank account and a business credit card. Run every business expense through those accounts and nothing else. Commingling makes reconciliation a nightmare, weakens your LLC liability protection, and raises red flags if you are ever audited.

Recording Shopify Payouts as Revenue

Your Shopify payout is not your revenue. It is your revenue minus transaction fees, refunds, chargebacks, and any reserves. Recording the payout amount as revenue understates your gross sales, hides your fee expenses, and makes your profit margins look different than they actually are.

The right approach: record gross sales as revenue, then record fees, refunds, and adjustments as separate expense or contra-revenue line items.

Ignoring Returns and Refunds

Every return needs a bookkeeping entry that reverses the original sale. If you process 50 refunds in a month and do not record them, your revenue is overstated by the total refund amount, and your COGS is wrong because that inventory came back into stock.

Skipping Reconciliation

We covered this in detail above, but it bears repeating: unreconciled books are unreliable books. If you have not reconciled in three months, you do not actually know your financial position. You are guessing.

Not Tracking Sales Tax Separately

Sales tax collected from customers is a liability, not revenue. If you deposit it into your general revenue and spend it, you still owe it to the state. Track it in a dedicated Sales Tax Payable liability account and remit it on schedule.

Building Your Monthly Bookkeeping Routine

Consistency beats perfection. A simple routine done every month is worth more than a perfect system you abandon in February. Here is a repeatable monthly checklist that takes 2-4 hours for a store doing under 500 orders per month.

Week 1: Record and Categorize

• Review and categorize all bank transactions from the prior month
• Verify all Shopify orders synced to your accounting software
• Record any manual transactions (cash purchases, reimbursements)
• Update inventory counts if you track manually

Week 2: Reconcile

• Reconcile your business bank account against your ledger
• Reconcile your Shopify payout report against recorded deposits
• Reconcile your credit card statement
• Investigate and resolve any discrepancies

Week 3: Review and Report

• Generate a Profit and Loss statement for the month
• Generate a Balance Sheet
• Review COGS and gross margin — compare to prior months
• Flag any unusual expenses or revenue variances

Week 4: Tax and Planning

• Verify sales tax collected matches your liability account
• File any sales tax returns due this month
• Set aside estimated income tax (a good rule of thumb is 25-30% of net profit)
• Review upcoming expenses and cash flow for the next 30 days

This routine compounds. By month three, it takes half the time because your categories are dialed in, your reconciliation is clean, and you are catching issues while they are small.

Your Financial Foundation Starts Now

Every section in this guide comes down to one principle: know your numbers, and know them accurately. Ecommerce bookkeeping for beginners is not about mastering double-entry accounting theory. It is about building habits and systems that give you a clear, truthful picture of your business finances so you can make smart decisions with confidence.

Start with the basics: separate your personal and business finances, pick cash or accrual accounting, set up a clean chart of accounts, and commit to monthly reconciliation. Choose QuickBooks or Xero when spreadsheets stop scaling. Hire a bookkeeper when your time is worth more than their fee.

The merchants who build financially healthy stores are not the ones with the most revenue. They are the ones who actually understand where their money goes. Join the Talk Shop community to connect with other Shopify store owners who are figuring out the same challenges — and explore our blog for more guides on running a profitable ecommerce business.

What is the one bookkeeping habit you wish you had started sooner? Share your experience in the comments.

About Talk Shop

The Talk Shop team — insights from our community of Shopify developers, merchants, and experts.