Shopify Bookkeeping: What Every Merchant Needs to Know

Nobody starts a Shopify store because they love bookkeeping. You start because you have a product, an idea, or a skill — and you want to build something. Bookkeeping is the thing that has to happen in the background.

But "I'll deal with it later" is the most expensive bookkeeping strategy there is. When "later" arrives — usually around January when taxes are due — you're spending days reconstructing records from memory and bank statements, often paying an accountant extra to fix a year of guesswork.

This guide is for Shopify merchants who aren't accountants. We'll cover what you actually need to know, skip the jargon, and give you a system that works.

What is bookkeeping, and why does it matter?

Bookkeeping is simply the process of recording money coming in and money going out. That's it. You're building a record of your business's financial history.

Why it matters:

• Tax filing. You need accurate income and expense records to file your taxes — and to pay only what you actually owe.
• Decision making. If your margins are shrinking, you need to see it in the numbers before you feel it in your bank account.
• Cash flow planning. Understanding how Shopify payouts work — what's included, what's deducted — helps you plan ahead.
• Growing the business. If you ever want a loan or outside investment, you'll need clean financial records.

The Shopify bookkeeping challenge: payouts aren't sales

The most fundamental thing to understand: the money that hits your bank account is not the same as your sales.

Shopify bundles multiple days of sales into a single deposit called a payout. Before sending it, Shopify already deducts payment processing fees and any refunds or chargebacks. So the deposit in your bank is a net number — sales minus deductions.

If you record that net number as your revenue, you're understating sales and hiding fees. Your gross profit margin looks higher than it is because the fees have disappeared. That matters at tax time and when making pricing decisions.

What you need to track as a Shopify merchant

Revenue

Record your gross sales — the full amount customers paid, before any Shopify deductions. Break it down if you collect different types of income: product sales, shipping charged to customers, and tips (if applicable).

Refunds

Refunds reduce your revenue. Every refund needs to be recorded as a negative income entry. Don't ignore refunds and hope they cancel out — they need their own entries.

Shopify fees

Payment processing fees are a business expense. They don't appear on your bank statement (they're deducted before your payout) but they need to show in your books. The difference between your gross sales and your bank deposit is your fees.

Your monthly Shopify subscription fee ($39, $105, or $399/month) is a separate expense charged to your credit card — not deducted from payouts. Record it as a software subscription expense.

Other expenses

Track everything you spend to run the business: cost of goods sold, advertising, shipping costs, apps and subscriptions, packaging, contractors, and staff.

Do you need QuickBooks?

For very early-stage stores (under $2,000/month in revenue, simple product range, no employees), a spreadsheet can work. But it falls apart quickly as volume grows — spreadsheets don't enforce consistency, don't do bank reconciliation, and don't generate the reports your accountant needs.

QuickBooks Online is the most popular small business accounting software in the US, at around $35–$90/month. Once your Shopify store is generating more than a few thousand dollars a month, it's worth it — you'll save that cost in accountant fees alone.

Setting up QuickBooks for a Shopify store

Key accounts you need in your chart of accounts:

• Shopify Clearing (Other Current Asset) — a temporary holding account where payout receipts post before the bank deposit moves the money
• Sales income account — where your product revenue goes
• Your bank account — your actual business checking account
• Optional: separate accounts for shipping income, tips, discounts

The clearing account is the piece that confuses most new merchants. Think of it as a staging area: money flows in from Shopify sales, then flows out when the payout hits your bank. If your clearing account is always near zero, your payout accounting is working correctly.

Cash vs. accrual accounting

Cash accounting records revenue when you receive the money and expenses when you pay them. Simpler, and what most small businesses start with. For Shopify, this means recording each payout when it lands in your bank.

Accrual accounting records revenue when you earn it and expenses when you incur them. More complex, but required for larger businesses. Most Shopify merchants should start with cash accounting. The IRS allows it for businesses under $25M in annual revenue.

Sales tax: don't ignore it

If you sell to US customers, sales tax is unavoidable. Shopify can calculate and collect it automatically in states where you have nexus. That tax goes into a liability account in your books — it's not your income, it's money you're holding on behalf of the state.

Remit it on time. The penalties for late sales tax payments are unpleasant and entirely avoidable.

How often should you do your bookkeeping?

• Weekly — categorise expenses, review payout recordings, check your clearing account balance
• Monthly — run a bank reconciliation, review your P&L
• Quarterly — review year-to-date profitability, check sales tax obligations, set aside money for estimated taxes
• Annually — close out the year with your accountant, file taxes

If you're automating your payout sync, the weekly payout work mostly disappears. You're left with categorising expenses and monthly reconciliations — 30–60 minutes once you're in the habit.

The most common Shopify bookkeeping mistakes

• Recording bank deposits as revenue. This hides fees and understates sales. Always record gross revenue separately from the net deposit.
• Not reconciling your bank account. Errors accumulate and go undetected if you skip reconciliation. Do it monthly.
• Mixing personal and business finances. Get a dedicated business bank account and credit card. The time saved in bookkeeping pays for the accounts many times over.
• Not tracking cost of goods sold. If you buy inventory, COGS needs to come out of your revenue — without it, your profit looks much higher than it actually is.
• Leaving it all for January. A little bookkeeping every week beats a week of bookkeeping every January.

Do you need a bookkeeper or accountant?

A bookkeeper maintains your day-to-day records — categorising transactions, reconciling accounts. Typically $50–$150/hour or fixed monthly packages.

An accountant (CPA) does higher-level work: tax planning, filing, and financial strategy. Most small Shopify merchants don't need a full-time CPA, but working with one for quarterly or annual reviews is worth the cost.

Many merchants start by doing their own bookkeeping in QuickBooks and having a CPA file taxes annually. As the business grows, they bring in a part-time bookkeeper.

How automation changes the picture

The most time-consuming part of Shopify bookkeeping is payout accounting — recording each payout correctly in QuickBooks. Done manually, this takes 15–30 minutes per payout. With payouts every two business days, that's 2–5 hours per month just on payout entries.

PaydayBooks automates this entirely. It reads each Shopify payout, decomposes it into the correct accounting entries, and posts them to QuickBooks automatically — Sales Receipt, Refund Receipt if needed, and Deposit — with the exact amounts, dated correctly, mapped to your accounts.

Automation doesn't replace bookkeeping — you still need to track expenses, do reconciliations, and review your P&L. But it removes the most repetitive and error-prone part of the job.

Getting started: a simple Shopify bookkeeping checklist

1. Open a dedicated business bank account
2. Set up QuickBooks Online
3. Create a Shopify Clearing account in your chart of accounts
4. Connect your bank account to QuickBooks
5. Set up payout sync (manually or with PaydayBooks)
6. Categorise your recurring expenses
7. Set a monthly reminder to reconcile your bank account
8. Review your P&L quarterly

That's the system. Once it's running, it takes less time than you think.

If you'd like to take payout accounting off your plate entirely, try PaydayBooks free for 14 days. Setup takes 10 minutes and it runs automatically from there.

Questions? Email us at [email protected] — we're happy to help.