Your Shopify dashboard shows $48,000 in sales. Your bank shows a $41,300 deposit. Where did the rest go? Fees, refunds, sales tax, and gift cards all got netted out before the money landed. This gap trips up thousands of merchants every month. It quietly wrecks profit and tax numbers. Strong Shopify accounting closes that gap. It separates real revenue from fees and tax. It tracks cost of goods sold. It shows what you truly earned. This guide breaks down the systems, the tools, and the tax rules that keep your Shopify books clean all year.
What Is Shopify Accounting and Bookkeeping?
Shopify accounting is the practice of recording, categorizing, and reconciling every dollar that moves through your store. Bookkeeping is the daily data entry. Accounting is the analysis on top of it. Bookkeeping records the transactions. Accounting turns those records into profit, tax, and cash flow decisions. Both matter. Clean Shopify bookkeeping protects your margins, your tax compliance, and your growth plans. Solid bookkeeping for Shopify keeps every payout accounted for, from the first order to the bank deposit. Think of Shopify accounting as built for the way Shopify actually pays you.
Can You Do Accounting on Shopify?
No. Shopify is not accounting software. It gives you sales reports and analytics. It does not give you double-entry accounting, bank reconciliation, or accounts payable. You still need a proper ledger or an accountant to close your books. That gap is exactly what Shopify accounting fills. Here is what the native tools do and do not do.
Get proper bookkeeping services that pick up where Shopify stops.
| Shopify does this | Shopify does not do this |
|---|---|
| Sales and payout reports | Double-entry general ledger |
| Order and product analytics | Bank reconciliation |
| Tax calculation at checkout | Sales tax filing and remittance |
| Basic finance summary | Profit and loss or balance sheet |
Shopify Accounting Best Practices and Month-End Checklist
Consistency beats intensity. Strong Shopify accounting is a habit, not a heroic month-end. Reconcile often. Track cost of goods sold. Keep business and personal money apart. Use this monthly checklist to close your books.
- Reconcile every payout to the bank deposit.
- Record refunds, chargebacks, and fees separately.
- Update inventory and cost of goods sold.
- Confirm sales tax collected by state.
- Review the profit and loss statement.
- File the month in a fixed folder.
The same discipline, three store types
- Single-gateway store: Every Shopify Payments payout ties to one bank deposit, with fees and tax split out on the same journal.
- Store plus marketplace: Shopify payouts reconcile on a rolling cycle while marketplace settlements arrive on a fixed one, so each channel gets its own mapping before the two consolidate.
- Store selling internationally: Payouts land converted, books record in your home currency, and the exchange difference gets its own account instead of quietly reducing gross margin.
Download the repeatable month-end checklist. 
The Shopify Month-End Close Checklist
Why Shopify Accounting Is Uniquely Complex
Shopify pays you in lump sums, not per order. Each payout blends many things together. You may run several gateways at once, like Shopify Payments, PayPal, Stripe, Shop Pay, Klarna, and Afterpay. Add Amazon or Etsy and it becomes , where every channel reports revenue on its own schedule and settles on its own clock. Layer inventory, refunds, high volume, and multi-state sales tax on top of that. That is why generic accounting for Shopify often breaks. Shopify accounting is a specialist job, not a spreadsheet chore. Here is the anatomy of a single payout.
Gross sales + shipping + sales tax collected + gift cards − discounts − refunds − chargebacks − Shopify fees = net payout (your bank deposit)
What Every Payout Deduction Does in Your Books
The payout formula tells you what came out. It does not tell you where each piece goes in the ledger, which is where books actually break. Eight lines, four different account types. Get one wrong and your profit is wrong every month.
Use this as the map for your chart of accounts.
| Payout line | Where it goes | Account type |
|---|---|---|
| Gross sales | Revenue, at full value | Income |
| Shipping charged to customer | Revenue, separate line | Income |
| Sales tax collected | Owed to the state, never income | Liability |
| Gift cards sold | Owed to the customer until redeemed | Liability |
| Discounts | Reduction of revenue | Contra income |
| Refunds | Reduction of revenue | Contra income |
| Chargebacks | Reduction of revenue, plus the dispute fee as an expense | Contra income and expense |
| Shopify and gateway fees | Cost of doing business | Expense |
Two lines catch almost everyone.
Gift cards are the quiet one. Selling a $200 gift card puts $200 in your bank and zero in your revenue, because you owe the customer $200 of product. Book it as income on sale and you overstate revenue now and have nothing to reverse later.
Chargebacks are the other, and they are two entries, not one. The disputed sale reverses, and the dispute fee is a separate expense that survives even when you win. Proper also handles the timing gap, because a chargeback filed in April against a March sale straddles two closed months.
Cash vs Accrual Accounting for Shopify
Cash accounting records money when it moves. Accrual accounting records sales when they happen and expenses when you incur them. It matches revenue with the cost of goods sold in the same period, so your margin is real. The IRS position is that if inventory is an income-producing factor in your business, you must generally use an accrual method, unless you qualify as a small business taxpayer with average annual gross receipts of $31 million or less over the three prior tax years, as set out in IRS Publication 334. Almost every Shopify store falls under that ceiling, so cash basis is legal for you. It is still the worse choice once you hold stock, because your margin stops matching the period it was earned in.
“Clears that bar” reads as being over $31 million, which inverts the meaning. Also drops the now-redundant “Growing stores should move to accrual” and the double space.
Your Shopify accounting method sets the foundation for everything else.
You pick your method on your first tax return, and changing it later means filing for IRS consent, which IRS Publication 538 covers in detail. Choose deliberately now rather than switching in year three.
| Factor | Cash basis | Accrual basis |
|---|---|---|
| Best for | Tiny, simple stores | Inventory and growing stores |
| Inventory accuracy | Weak | Strong |
| Investor and loan ready | No | Yes |
How to Set Up Shopify Accounting in 7 Steps
Good Shopify accounting practices follow a simple order. Do these steps once and the rest gets easy.
- Separate business and personal finances with a dedicated bank account.
- Choose your method, cash or accrual.
- Pick your accounting software.
- Build a clear chart of accounts.
- Connect Shopify and every payment gateway.
- Set up sales tax tracking by state.
- Establish a fixed month-end close routine.
How to Reconcile a Shopify Payout (Worked Example)
Book the gross, not the net deposit. This one rule fixes most Shopify books. Record the full sale, then record each deduction as its own line. Here is a simple example.
| Line | Amount |
|---|---|
| Gross sales | $10,000 |
| Refunds | −$400 |
| Sales tax collected | −$700 |
| Shopify fees | −$300 |
| Net payout to bank | $8,600 |
Your revenue is $10,000, not $8,600. The fees are an expense. The tax is a liability. Record it that way and your profit and loss statement stays honest. The number one mistake is treating the $8,600 deposit as revenue. It is not.
Best Shopify Accounting Software
Most tools cannot read raw Shopify data on their own. They need a connector to translate payouts into clean entries. The right Shopify accounting software does the heavy lifting, and the wider field of covers more platforms than the short list below. Get proper bookkeeping services alongside it and the two together pick up where Shopify stops.
| Software | Best for | Shopify connection | Price tier |
|---|---|---|---|
| QuickBooks Online | Most stores | Native app or A2X | From $35 per month |
| Xero | International sellers | A2X or Synder | Mid |
| Sage | Larger operations | A2X | Mid |
| FreshBooks | Service-led sellers | Third-party sync | Budget |
| Finaloop | All-in-one ecommerce | Built in | Premium |
What “Connects to Shopify” Actually Means
Every vendor claims a Shopify integration. Three very different things hide behind that claim. Knowing which one you are buying saves a rebuild later.
The difference shows up at month end, not at setup.
Order-level sync: Every order posts as its own invoice. Detailed, and it buries a busy store in thousands of entries a month.
Payout-level sync: One summary journal per payout, split into sales, fees, refunds, and tax, matching the bank deposit exactly. This is what accountants want.
Report-only sync: The tool reads Shopify numbers for dashboards but posts nothing to your ledger. Useful for reporting, useless for closing books.
How to Choose Shopify Accounting Software in Five Questions
Skip the feature grids. Five questions separate the tools that work from the ones you abandon in month three.
Answer these before you install anything.
- Does it post one journal per payout that ties to the bank deposit to the cent?
- Does it split sales tax collected into a liability account, not into income?
- Does it track cost of goods sold per product, or only total purchases?
- Does it handle every gateway you run, not just Shopify Payments?
- Does it handle refunds and chargebacks issued in a different month than the sale?
Any tool that fails question one will cost you more in cleanup than it saves in data entry.
Do You Need a Separate Connector?
Usually yes. Native connectors are built for simple stores and they thin out fast.
The rule of thumb is order volume.
Under roughly 100 orders a month with one gateway, a native connector is fine. Above that, or with two or more gateways, a dedicated payout connector pays for itself in the first close. Above 1,000 orders a month with inventory, you want payout-level sync plus an inventory system, because per-order posting will slow your ledger to a crawl.
Does Shopify Integrate With QuickBooks?
Yes. Shopify integrates with QuickBooks Online several ways. The right choice depends on your order volume and how much detail you need. This is the core of any .
| Method | How it works | Best for |
|---|---|---|
| Shopify Connector by QuickBooks | Free native app, syncs orders and payouts | Simple, lower-volume stores |
| A2X | One summary journal per payout, matches the deposit | Accrual and growing stores |
| Synder | Per-order or summary sync via a clearing account | Multi-processor sellers |
| MyWorks Sync | Shopify-native, two-way inventory sync | Stores needing inventory control |
To connect, install your chosen app, link QuickBooks Online, link Shopify, map your accounts, then test one payout before you automate. The depth varies a lot. Native tools are simple. Third-party tools like A2X give cleaner, detailed reconciliation.
How to Set Up Automated Shopify Accounting
Automation tools remove the manual grind. Automate the payout sync, the categorization, the cost of goods sold, and the sales tax coding. Let the software post entries every day. Then a human reviews the exceptions. Automation handles the volume. People handle the judgment. That mix is modern Shopify accounting. That is how to set up Shopify automated accounting you can trust.
When One Shopify Store Becomes Several Systems
A single store with one gateway is a solved problem. Growth breaks the solution in five predictable ways, and each one needs a different fix rather than more effort on the old one.
Find yours below before you outgrow your setup.
One store, years of backlog: The most common state is not complexity, it is months of unreconciled payouts. The cleanup follows the same arc every time, as this shows: rebuild the payouts, split fees and tax back out, then reconstruct cost of goods sold.
Shopify plus other sales channels: Each channel reports revenue on a different cycle and nets different fees, so needs one mapping per channel before anything consolidates.
More than one legal entity: Two brands under two companies means two ledgers, intercompany transactions, and a consolidation step, which is what exists to handle.
Selling in more than one currency: Payouts convert at one rate and your books record at another, so a has to hold the exchange difference somewhere rather than let it distort margin.
Payment processors that will not agree: When Shopify Payments, PayPal, and Stripe each report the same order differently, is the step that produces one true revenue figure.
Shopify Sales Tax and Compliance in the United States
Sales tax is a liability you collect, not income you keep. Tax is where Shopify accounting gets risky, so treat it with care. Economic nexus rules mean you may owe tax in states where you have no office. The thresholds vary widely, and the $100,000 figure most guides quote applies to almost no large state. The table below has the real numbers. Shopify Tax calculates the rate at checkout. You still file and remit the tax yourself. On the federal Form 1099-K, the reporting threshold returned to more than $20,000 and more than 200 transactions for 2025 and later. Some states set lower limits. Miss these rules and penalties follow.
Shopify Sales Tax Nexus Thresholds, State by State
The $100,000 figure everyone quotes is one state’s law, not the national rule. Copying it into your compliance calendar gets you registering in the wrong states at the wrong time. Here is what the actual statutes say.
The numbers below are the registration triggers, not the tax rates.
| State | Sales threshold | Transaction count | Both required |
|---|---|---|---|
| South Dakota (the Wayfair standard) | Over $100,000 | 200 or more | No, either one |
| California | $500,000 | None | Sales only |
| Texas | $500,000 total Texas revenue | None | Sales only |
| New York | Over $500,000 | More than 100 sales | Yes, both |
The $100,000 or 200 transaction figure comes from the South Dakota statute the Supreme Court upheld in South Dakota v. Wayfair. Many states copied it in 2018 and 2019. Several then raised the dollar figure and dropped the transaction count, because 200 small orders was catching sellers with almost no revenue in the state.
The three biggest divergences matter most:
California requires registration once combined sales for delivery into the state hit $500,000, with no transaction element at all, per the California Department of Tax and Fee Administration. A store doing 400 orders and $80,000 into California has no obligation.
Texas uses a $500,000 safe harbor on total Texas revenue over the preceding twelve months. Cross it and you must permit and collect from the first day of the fourth month after the month you crossed.
New York requires both tests. Over $500,000 in receipts and more than 100 sales, measured across the immediately preceding four sales tax quarters. Hit one and not the other and you do not register.
Check your own thresholds every quarter, not every year. The lookback periods are rolling, so you can cross a line in March and owe from June.
Does Shopify Report Your Income to the IRS?
Yes, and the threshold changed twice in three years. Getting this wrong means either a surprise form or an unreported deposit. Both cause problems. Here is the current rule and what the form actually says.
The number on that form is not your revenue.
The Current Form 1099-K Threshold
The One, Big, Beautiful Bill retroactively restored the threshold that applied before 2021. Shopify must issue you a Form 1099-K only when your gross payment volume exceeds $20,000 and you have more than 200 transactions, per the IRS guidance on the change. Some states set lower limits, so you may get a form from a state even when you fall under the federal line.
Why the 1099-K Number Never Matches Your Books
The form reports gross payment volume. It does not subtract refunds, chargebacks, Shopify fees, or shipping labels, and the IRS guidance on Form 1099-K is explicit that the gross amount is reported without adjustment. So a store with $260,000 in gross volume, $12,000 in refunds and $10,000 in Shopify fees still sees $260,000 on the form. Revenue after refunds is $248,000. The $10,000 of fees sits below that as an expense, not as a cut to revenue.
Same arithmetic base, but now it agrees with your payout table and your worked example. As written it teaches the exact mistake the article was built to correct.
You are not expected to report the form number as income. You are expected to reconcile it. That means showing gross sales of $260,000, then each deduction as its own line. Book the gross and the reconciliation writes itself.
You Still Owe Tax Below the Threshold
No form does not mean no income. Every dollar of profit is reportable whether Shopify issues a 1099-K or not. A store doing $14,000 in sales gets no form and still files. The threshold governs Shopify’s paperwork, not your obligation.
Shopify Financial Reports Every Merchant Should Read
Three reports tell the whole story. The profit and loss statement shows revenue, cost of goods sold, and profit. The balance sheet shows what you own and owe. The cash flow statement shows the money coming in and going out. Watch a few too: gross profit, contribution margin, and cash on hand. Your Shopify accounting should surface these numbers every month.
| Report | What it answers |
|---|---|
| Profit and loss statement | Am I making money? |
| Balance sheet | What is my business worth? |
| Cash flow statement | Can I pay my bills? |
Common Shopify Accounting Mistakes That Cost Real Money
Most broken Shopify books fail in the same eight places. None of them are hard to fix. All of them are expensive to leave alone through a full tax year.
Check yours against this list.
- Treating the net deposit as revenue: The single most common error. An $8,600 deposit from $10,000 of sales understates revenue by $1,400 and hides the fees entirely. Your profit and loss statement looks lean and your tax return looks wrong.
- Counting sales tax as income: The tax you collect is money you hold for a state. Book it as revenue and you inflate profit, then pay income tax on money you are about to hand over.
- Dumping every sale into one account: Sales, shipping income, and gift cards behave differently. Merged into one line, you cannot see which product line actually makes money.
- Ignoring cost of goods sold until year end: Without COGS tracked monthly, gross margin is a guess. You will discover in February that your best-selling product was your worst earner.
- Booking a marketplace settlement as one sale: Amazon settles on a fixed cycle rather than Shopify’s rolling payouts, which is why the most common start with recording one settlement as a single transaction instead of unbundling it.
- Buying a tool that cannot read payouts: Plenty of syncs orders beautifully and still cannot produce a journal that matches your bank deposit. Order sync is not reconciliation.
- Assuming every gateway costs the same: Fee structures differ by processor and by transaction type, so a comparison changes your effective margin, not just your checkout experience.
- Letting months pile up: Three closed months take an afternoon. Nine open months take a rebuild, and by then you are reconstructing from bank statements rather than reconciling from records.
DIY or Hire a Shopify Accountant?
The dividing line is not revenue, it is complexity. One gateway, no inventory, and one state means software is probably enough. Two gateways, stock on shelves, and sales into five states means you are past what a template can hold.
Three signals say hire.
- You are past two gateways: Every extra processor adds a settlement cycle and a fee structure your ledger has to model separately.
- You hold inventory: Cost of goods sold per product is where margin lives, and it is the first thing a general bookkeeper skips.
- You have crossed a nexus threshold: Registering, filing, and remitting in a second state is a recurring compliance calendar, not a one-time task.
A good Shopify accountant or Shopify bookkeeper knows payouts, gateways, inventory, and multi-state tax cold. A general bookkeeper will treat your deposit as revenue and hand you clean-looking books that are wrong. When you compare Shopify store accounting services, ask one question: how do you reconcile a payout? The answer tells you everything.
Keeps the three keywords that have real volume and cost per click (Shopify accountant, Shopify bookkeeper, Shopify store accounting services). Drops “bookkeeping near me” and “small business accounting”, which have no volume and were only there to hold the phrase.
Our Guarantees
We put our promises in writing, because your compliance and your calendar both matter.
Regulatory Compliance Assurance
We ensure all tax filings, payroll, and financial reports meet compliance standards. If an error on our part results in a financial penalty, we will cover the cost.
Financial Reports Delivered on Schedule
Monthly, quarterly, and annual reports arrive without delays. If we miss a compliance deadline due to our fault, we pay a 50% fee. Your books stay on time, every time.
Conclusion: Clean Books, Clear Profit
Shopify shows you sales. It does not close your books. Strong Shopify accounting turns messy payouts into clear profit, accurate tax, and confident decisions. Set up the system, automate the volume, and reconcile every payout to the penny. Do that and tax season stops being a scramble. Whether you handle it yourself or hire specialist Shopify accountants, the goal is the same. Books you can trust, all year.
We will review your last three months of Shopify payouts, your sales tax settings by state, and how your cost of goods sold is currently tracked. Then we will tell you exactly what is misbooked, what it is costing you, and what we can automate. Thirty days, one clear answer, no obligation.
and let us take Shopify bookkeeping off your plate.
Frequently Asked Questions – Shopify Accounting
Does Shopify integrate with QuickBooks?
Yes. You can connect Shopify to QuickBooks Online with the free native Shopify Connector, or with tools like A2X, Synder, and MyWorks for deeper reconciliation.
Which accounting software connects to Shopify?
QuickBooks Online, Xero, Sage, and FreshBooks all connect to Shopify. Most need a connector such as A2X or Synder to read your payout data cleanly.
How do I set up Shopify automated accounting?
Pick your software, add an automation tool, connect Shopify and your gateways, map your accounts, then automate the daily sync and review the exceptions.
What is the best accounting app for Shopify?
For most stores, QuickBooks Online paired with A2X gives the cleanest payout reconciliation. The best fit depends on your volume and how much order detail you need.
Does Shopify report income to the IRS?
Yes. Shopify issues a Form 1099-K when your gross payment volume exceeds $20,000 and you have more than 200 transactions. Below that you get no form and still owe tax on your profit.
Does Shopify have a bookkeeping system?
No. Shopify gives you sales reports, payout records, and analytics. It has no general ledger, no bank reconciliation, and no accounts payable, so you still need accounting software or an accountant to close your books.
Does Shopify replace QuickBooks?
No. Shopify records what you sold. QuickBooks records what that means financially, including fees, tax liability, cost of goods sold, and profit. They do different jobs and most stores run both.
How much does Shopify take from a $20 sale?
Shopify Payments charges a percentage of the sale plus a flat fee per transaction, and the percentage drops as you move up plans. Check your exact rate under Settings then Payments, because it varies by plan and by country. Whatever the figure, it is an expense in your books, not a reduction of revenue.
