Shopify bookkeeping in QuickBooks Online

Shopify bookkeeping usually goes wrong in the same place: the bank feed. Shopify reports $3,195.00 of total sales for a weekend, and on Wednesday the bank shows a Shopify deposit of $3,125.22. QuickBooks offers to add it as income, and once it does, the books have no discounts, no shipping income, no refund, no fee, a $100 gift card counted as a sale, and $185.00 of sales tax the owner still has to pay the state, all buried in one line called Sales.

This post is the Shopify page in our ecommerce series. It covers which Shopify reports to book from, how each line maps to a QuickBooks Online account, one payout worked line by line, when a connector is worth installing, and the traps that are specific to Shopify: gift cards, Shop Pay Installments, reserves, multi-currency payouts and sales tax. The clearing-account method behind all of it is explained once in payment apps in QuickBooks, and a store selling on Shopify, Amazon and Etsy at the same time is covered in ecommerce bookkeeping.

Why a Shopify payout never matches your orders

A Shopify Payments payout is what is left of a batch of orders after Shopify has taken its share and settled everything else that happened in those days. Shopify’s US terms, read October 25, 2026:

• Timing. The minimum settlement time for US stores is 3 business days, and “payments captured on Friday, Saturday, and Sunday are consolidated and sent as a single payout.” Shopify adds that banks take 24 to 72 hours to post the money, so a deposit typically lands 3 to 5 business days after the customer paid (Shopify payouts, United States). New stores can start on a longer schedule.
• What comes out first. Processing fees, refunds, chargebacks and their dispute fees, money moved into a reserve, the higher fee on Shop Pay Installments orders, and marketplace sales tax on orders placed in the Shop app.
• What is in it that is not a sale. Gift cards customers bought, which are a liability, and sales tax you collected, which belongs to the state.

So a payout is three things at once: several days of sales, several kinds of deduction, and some money that was never revenue. Booking it as one income line gets all three wrong.

Which Shopify reports to book from

Shopify has two sets of numbers, and the books need both. The sales reports say what customers bought. The payments reports say what money moved and where it went. Everything below is in the Shopify admin under Analytics, then Reports, filtered to the Finances category, or under Finance (Shopify finance reports, read October 25, 2026).

Shopify report	What it gives you	What it is for in the books
Total sales breakdown	Gross sales, discounts, sales reversals (returns), net sales, shipping, taxes, return fees	The sales side of each summary entry
Payments by gateway	Money collected by Shopify Payments, PayPal, gift card and any other method	Splitting sales between clearing accounts
Shopify Payments activity report	“A reconciled breakdown of your Shopify Payments balance activity, fees, and payouts,” per Shopify, under Finance, then Documents	Fees, reserves and the month-end balance check
Payouts, then View transactions	Every charge, refund, adjustment and fee inside each payout, exportable	Matching one payout to one bank deposit
Outstanding gift card balance	Starting balance, cards issued, redeemed and deactivated, ending balance by day	The Gift Card Liability balance at month end
United States sales tax report	Taxable sales and tax by state and jurisdiction, for stores on Shopify Tax	The Sales Tax Payable balance and each return
Cost of goods sold	Cost of units sold, but only for sales that had a cost recorded	A cross-check on margin, not the books’ COGS figure

Shopify defines its own headline number this way:

Total sales = Gross sales − Discounts − Sales reversals + Taxes + Shipping + Return fees

Two things in that formula matter for the books. Total sales includes the tax, which is not revenue. And it leaves out gift cards sold, because Shopify says “selling a gift card isn’t counted as a sale because it’s a liability.” A gift card shows up in sales only when a customer spends it, and then “the full value of the item is claimed as sales.”

Shopify report lines and their QuickBooks accounts

Set up each account once, then every summary entry follows the same map. Account names here are the ones used across this series.

Shopify line	QuickBooks Online account	Account type	Notes
Gross sales	Sales	Income	Product price × quantity, before discounts
Discounts	Discounts Given	Income, detail type Discounts/Refunds Given	Keeps list price and discounting visible separately
Sales reversals (returns)	Sales Returns and Allowances	Income	Dated when the refund was processed, not when the order was placed
Shipping charges	Shipping Income	Income	What customers paid for shipping
Taxes, your own store	Sales Tax Payable	Other Current Liabilities	Owed to the states where you are registered
Gift cards sold	Gift Card Liability	Other Current Liabilities	Reduced when a card is redeemed
Shopify Payments fees, Shop Pay Installments fees	Merchant Service Fees	Expense	Never netted against sales
Chargeback amount	Disputed Payments	Other Current Assets	Until the dispute is decided
Dispute fee	Chargeback Fees	Expense
Reserve held or released	Shopify Reserve	Other Current Assets	Or left inside the clearing account
Shopify plan and app bills	Software and Subscriptions	Expense	Listed on the Billing page in the Shopify admin
Shipping labels bought in Shopify	Shipping and Delivery	Expense	Cost of sending orders, not cost of goods
Shopify Capital or Shopify Credit repayments taken from payouts	The loan, advance or credit liability	Other Current Liabilities	Repayments are not an expense; how a Capital financing fee is spread is a question for your CPA
Payout	Shopify Clearing to Business Checking	Transfer	One bank line, one entry

Shopify Clearing is an Other Current Assets account that stands in for your Shopify Payments balance. Sales from Shopify Payments go in at the amount customers paid, fees and refunds come out, and each payout moves the remainder to the bank. Sales paid through PayPal or another gateway never reach a Shopify payout, so they go to that gateway’s own account. Disputes are worked through in chargeback accounting.

One Shopify payout, worked line by line

A home goods store on Shopify Payments takes orders from Friday, October 16 to Sunday, October 18, 2026. Shopify combines the three days into one payout, which reaches the bank on Wednesday, October 21. Over the weekend:

• Products sold at list price come to $3,000.00, with $150.00 of discount codes used.
• Customers paid $240.00 for shipping and $190.00 of sales tax, all in states where the store is registered.
• One customer bought a $100.00 gift card. Another spent $60.00 of an older gift card on an order.
• On Saturday the store refunded an earlier order: $80.00 for the item and $5.00 of tax on it.
• Shopify Payments fees on the weekend’s charges were $109.78, taken from the payout’s transaction export. Shopify did not return the fee on the refunded order, so check your own export for how refunds were charged.

Shopify’s Total sales breakdown for October 16 to 18 reads:

Total sales breakdown, Oct 16 to Oct 18	Amount
Gross sales	3,000.00
Discounts	−150.00
Sales reversals	−80.00
Net sales	2,770.00
Shipping charges	240.00
Taxes ($190.00 collected, $5.00 refunded)	185.00
Total sales	3,195.00

The payout is a different number, because it also carries the gift cards and the fees:

Shopify Payments payout, Oct 21	Amount
Total sales from the report above	3,195.00
Gift card bought by a customer	100.00
Part of an order paid with an older gift card	−60.00
Charged to cards, net of the refund	3,235.00
Shopify Payments fees	−109.78
Payout	3,125.22

The QuickBooks Online entries, one summary journal entry for the three days and one bank-feed match for the deposit:

Date	Account	Debit	Credit
Oct 18	Shopify Clearing	3,235.00
Oct 18	Discounts Given	150.00
Oct 18	Sales Returns and Allowances	80.00
Oct 18	Gift Card Liability	60.00
Oct 18	Sales		3,000.00
Oct 18	Shipping Income		240.00
Oct 18	Sales Tax Payable		185.00
Oct 18	Gift Card Liability		100.00
Oct 18	Merchant Service Fees	109.78
Oct 18	Shopify Clearing		109.78
Oct 21	Business Checking	3,125.22
Oct 21	Shopify Clearing		3,125.22

Shopify Clearing takes in $3,235.00 and gives out $109.78 and $3,125.22, so the payout brings the weekend back to zero. Sales show the list price, discounting and the return each on their own line. Sales Tax Payable holds the $185.00 the store owes. Gift Card Liability rises by $100.00 for the card sold and falls by $60.00 for the card spent, and that $60.00 order still counts in full as sales, which is how Shopify reports it too.

Entered this way, the profit and loss shows $2,770.00 of net sales and $240.00 of shipping income for the weekend. Booked from the deposit, it would have shown $3,125.22 of “sales,” 13% more than the weekend’s net sales, with tax and a gift card inside it.

Where the clearing account should stand at month end

Not at zero, unless the last payout of the month covered every sale. Orders from the last two or three business days of October will still be waiting to be paid out on October 31. The check is that Shopify Clearing equals Shopify’s own figure for money not yet paid out on the same date. Shopify’s payouts page shows that figure as two parts, Pending and Reserve, and says “your total balance is the sum of your Pending and Reserve amounts” (Shopify reserves). If the store books reserves to a separate Shopify Reserve account, compare Pending to the clearing account and Reserve to that account. A difference usually means a payout was coded to Sales, a refund or chargeback was missed, or a weekend was entered twice.

Do you need a connector? Three ways to get Shopify into QuickBooks

The clearing account and the mapping above stay the same whichever route you pick. What changes is who types the entries.

Method	What it posts	Fits	Watch for
Summary journal entry from Shopify’s reports	One entry per payout, or per week or month, as above	A small store, a few dozen orders a month, one sales channel	Do it per payout if you want each bank deposit to match one entry
Payout summary app (A2X, Link My Books, Synder and others)	One summarized entry per payout, mapped to your accounts	Hundreds or thousands of orders, several gateways, frequent refunds	The mapping is set once and then trusted, so check it against a payout by hand in the first month
Shopify Connector by QuickBooks	A sales receipt and a fee expense for each sale, then a deposit for each payout	Stores that need customers, products or B2B invoices inside QuickBooks	Volume, product matching, and the start date

Intuit’s own connector is installed from Integrations, then Find integrations, by searching for Shopify Connector by QuickBooks. During setup it asks for a start date, a deposit account, a payments account, and whether to turn on product and customer tracking. Intuit describes what it does with each payment: when a sale is confirmed, “QuickBooks Online creates a Sales Receipt (for sale details) and an Expense (for fees),” both held in Undeposited Funds or Payments to deposit until the payout is added, when it creates “a Deposit transaction that moves the net payout amount” to the bank account. It can import transactions “from up to one year ago,” and it has separate accounts for gift card liability, reserves, holds and disputes, tips and payout adjustments (Intuit: Connect Shopify to QuickBooks Online, read October 25, 2026).

Two details from the same article decide whether it suits a store. With product tracking on, the connector matches Shopify products to QuickBooks items by SKU and name, but if no match is found, “the product isn’t automatically added; you will need to manually create in QuickBooks Online.” With tracking off, every sale uses one default “Shopify Sales Item.” And Intuit’s instruction for the bank feed is plain: “Do not manually Add the deposit in the bank feed. Always use Match.”

Whatever you choose, use one method for Shopify and only one. A connector posting sales while someone also enters a weekly summary is the most common way a Shopify file ends up with income counted twice, the problem described in a sales receipt and a deposit counted twice.

Shopify-specific traps

Gift cards are a liability until someone spends them

A gift card sold is money the store owes back in goods. Shopify’s reports already treat it that way, and the books should match: credit Gift Card Liability when a card is sold and debit it when a card is redeemed. The month-end test is simple. Shopify’s Outstanding gift card balance report gives an ending balance for any date, and Gift Card Liability should equal it.

Cards you issue yourself from the Shopify admin, for a complaint or a giveaway, are not sales of anything, and Shopify leaves them out of its sales reports. They do count in Shopify’s outstanding balance, though, so decide how to book them before the first month-end check. Either credit Gift Card Liability when a card is issued, against a promotional expense, so the liability matches Shopify’s ending balance; or leave issued cards out of the books until they are spent, code each redemption to Discounts Given instead of the liability, and compare Gift Card Liability with purchased cards only, which Shopify’s Issue method filter on the gift cards page or its CSV export can separate. Shopify also notes that an expired card’s balance “will continue to count toward your outstanding gift card balance.” Whether and when an old balance can come off the books depends on state gift card and unclaimed property rules, which is a question for your CPA.

Shop Pay Installments are a card sale, not a receivable

When a customer splits an order into installments, the store does not wait for them. Shopify says “you’ll receive full payment for your order within 1 to 3 business days, excluding the fee,” inside the normal Shopify Payments payout, and that Affirm collects from the customer, so “you aren’t at risk if your customers stop making payments” (Shopify: getting paid for Shop Pay Installments, read October 25, 2026). Book these orders like any other card sale. There is no receivable, and the only difference is a higher fee, which goes to Merchant Service Fees.

Refunds on installment orders come out of the next payout. Refunds on orders placed before August 29, 2025 could instead be debited from the bank, and if that debit failed Shopify recovers it later as a payout adjustment labeled “Installments Balance Recovery.” It is a refund already given being collected, not a new cost: if the refund is in Sales Returns and Allowances already, the recovery line only clears Shopify Clearing.

Reserves make a payout smaller without costing anything

If Shopify puts a reserve on the account, part of each payout is held back for a set period. Shopify records “Reserve funds,” negative lines that reduce a payout, and “Released funds,” positive lines when the hold ends. Neither is income or an expense. Either leave them inside Shopify Clearing, so the clearing balance includes money on hold, or move them to a Shopify Reserve asset so the held amount is visible on the balance sheet. A reserve of 10% for 120 days, one of Shopify’s own examples, can hold a large sum on a busy store, and booking those lines as fees overstates expenses by the whole amount.

Multi-currency payouts

Shopify can pay out in a different currency from the one a store sells in. When the store currency, the payout currency and the QuickBooks home currency are not all the same, the summary entry has to be made in one currency and converted at a stated rate, or the clearing account will carry exchange differences that never clear. Turning on multicurrency in QuickBooks Online is a one-way switch: Intuit says that once it is on, it cannot be turned off and the home currency cannot be changed (Intuit: multicurrency). Decide with your accountant before switching it on.

Sales tax Shopify calculates but does not pay

On orders through your own Shopify store, Shopify works out the tax and collects it from the customer, but “Shopify doesn’t remit or file your taxes for you” (Shopify: US taxes). The tax is yours to register for, file and pay, so it goes to Sales Tax Payable as in the worked payout, and that account should match the tax due on your returns.

Shopify’s automated filing service, which did file returns for enrolled stores, is closed to new stores and ending. Shopify says it “files your returns for sales made through December 31, 2026,” and that filing records can be downloaded until April 30, 2027 (Shopify: filing after automated filing ends, read October 25, 2026). A store that relied on it needs a new way to file returns for sales from January 2027 on.

Orders placed in the Shop app are the exception. Since January 1, 2025, Shopify collects, remits and files the tax on those orders itself, and deducts it from your payouts as a line marked Marketplace sales tax. Which platforms collect tax for you, and how each case is entered, is in does Etsy, eBay or Shopify collect sales tax?

Cost of goods sold for a Shopify store

Shopify can show cost of goods sold, but only for products where a cost was entered. Its finance reports split net sales into “net sales with cost recorded” and “net sales without cost recorded,” and “only net sales with cost recorded are included in your Cost of goods sold report, and count toward your gross profit.” A store that filled in Cost per item on half its catalog will see a gross profit that looks far too good. Use Shopify’s figure as a cross-check, never as the number in the books.

In QuickBooks, stock bought for resale goes to Inventory Asset and moves to Cost of Goods Sold as it sells, either item by item (quantity tracking in the Plus and Advanced plans) or through a count at month end. Freight to bring stock in is part of its cost; shipping labels to send orders out are Shipping and Delivery. Both methods, the count adjustment and the tax rules behind them are in journal entry for inventory, and the periodic calculation for an online store is worked on the ecommerce bookkeeping page.

Can you have COGS without inventory?

Yes. A dropshipping or print-on-demand store never holds stock. The supplier charges for each order as it is made and shipped, and that charge is cost of goods sold for the month the sale is recorded. Code supplier invoices or card charges to Cost of Goods Sold, not to an operating expense, so gross margin reflects what each sale really cost.

Common questions about Shopify bookkeeping

Does Shopify do bookkeeping for you?

No. Shopify produces sales and payments reports, and its finance reports are a good source for the entries, but it keeps no general ledger, no balance sheet and no bank reconciliation. Those need accounting software such as QuickBooks Online or Xero, with someone posting from Shopify’s reports or a connector doing it.

Can Shopify work with QuickBooks?

Yes, through Intuit’s Shopify Connector by QuickBooks, through payout summary apps, or with summary journal entries from Shopify’s reports. The three are compared above. Shopify also documents its own route for QuickBooks Desktop.

Does Shopify report income to the IRS?

Shopify Payments issues Form 1099-K to US merchants who meet the reporting threshold, and the form shows gross payments before fees and refunds. Why it rarely matches the books, and how to tie the two, is in why your 1099-K doesn’t match your books.

What is the best app to integrate Shopify and QuickBooks?

The one that posts at the level of detail the books need and nothing more. A store that needs only totals is best served by a payout summary app or a summary entry. A store that invoices wholesale customers or tracks inventory item by item in QuickBooks needs order-level detail, which Intuit’s connector gives. Each fits a different store, so test any of them against one real payout before trusting it.

When a year of Shopify payouts was booked as sales

The fix is the same entry, done for every payout or every month: gross sales, discounts, returns, shipping, tax and gift cards from Shopify’s reports into Shopify Clearing, fees out, and each deposit already in the books moved from Sales to the clearing account. Sales tax that sat in income moves to Sales Tax Payable and is checked against the returns filed. In a year already filed, do this only with your CPA, because it changes figures on a return. In an open year it is part of a QuickBooks cleanup.

$99per month of backlog20% off 6+ months

When to hand this off: if more than a few months of Shopify payouts went to Sales, or gift cards and sales tax were booked as income, each month has to be rebuilt from Shopify’s reports before the clearing account, the gift card balance and the tax returns will agree. A free file review counts the months first.