A Shopify Payments deposit should be reconciled as a settlement, not recorded as one line of sales. A reliable close connects Shopify order and finance reports to gross sales activity, refunds, fees, disputes, gift-card activity, the Shopify Payments balance, and the amount that actually reached the bank. Daxable can maintain this bookkeeping in the seller's own QuickBooks Online file; sales-tax returns, income-tax decisions, legal conclusions, and inventory-valuation policy remain with the responsible specialists.
Why does a Shopify Payments payout not equal Shopify sales?
The payout and the sales report answer different questions. Shopify says its Payments activity report explains balance movement such as gross activity, fees, payouts, and the ending balance, but is not a statement of accounting revenue. A sales report follows order activity and can use different timing and totals. Treating either report as a substitute for the other leaves part of the close unsupported.
One bank deposit can contain customer payments from several days, less processing fees, refunds, disputes, adjustments, or other balance activity. Some captured payments can still be pending, and a refund or dispute can reduce a later payout instead of the payout associated with the original order. The bank feed therefore proves cash received, not the makeup of revenue or the reason for every deduction.
Use a clearing workflow to keep those questions separate. Approved order or finance activity records the business event, settlement detail explains the movement through Shopify Payments, and the bank deposit clears the amount actually transferred. The remaining clearing balance should equal identifiable pending, reserved, disputed, or otherwise unsettled activity rather than an unexplained plug.
Which Shopify reports should support the monthly close?
Save the Shopify Payments activity report for the close period and payout currency. It provides a period-level view of starting balance, gross activity, fees, payouts, net movement, and ending balance. Then save payout-level detail or the exported balance-transactions CSV so each bank deposit can be traced to its transaction types, orders, amounts, fees, and net activity.
Also retain the sales, payments, taxes, refunds, discounts, shipping, and gift-card reports relevant to the store's setup. A multi-currency store needs separate attention by payout currency, and third-party payment processors need their own settlement evidence because Shopify's Payments activity report does not include every outside processor or payment method.
Keep the exported files with the closing workpapers instead of relying on a dashboard that can change after the period. Label each file with the store, period, time zone, currency, and export date. If an app or connector posts entries to QuickBooks, retain its mapping and sync-status report too; the connector output still needs to tie to Shopify and the bank.
How should Shopify Payments activity enter QuickBooks Online?
Choose one documented posting method and apply it consistently. A seller might post summarized daily or monthly activity, detailed orders, or connector-generated entries depending on volume, reporting needs, accounting policy, and source-system controls. The method should preserve gross activity and supported deductions without turning thousands of orders into an unreconciled ledger.
Map sales, shipping, discounts, refunds, payment fees, sales-tax liabilities, gift-card liabilities, and other material categories to approved accounts. Record the Shopify Payments clearing balance separately from the bank account. When the payout arrives, match it against clearing instead of recording new sales. If the connector already posted the payout or underlying activity, a second manual journal can duplicate revenue, fees, or cash.
QuickBooks reconciliation is the final cash control, not the first classification step. Intuit describes reconciliation as matching entered transactions to the bank statement until the difference is zero. Before finishing, confirm that each Shopify deposit in QuickBooks matches the bank statement and that the supporting payout detail explains the amount.
How should refunds, disputes, reserves, and negative balances be handled?
Follow the transaction evidence and the period in which the activity occurred. Shopify states that a Shopify Payments refund is generally deducted from an available payout and that the original card-processing fee is not returned. A dispute, reserve, adjustment, or negative-balance debit can also move separately from the original sale. Do not erase the original event or code the later cash difference to miscellaneous expense without support.
Keep a rollforward that begins with the prior Shopify Payments balance, adds current activity, subtracts payouts, and arrives at the reported ending balance. List open refunds, disputes, reserve movements, negative balances, and failed or delayed payouts separately. The workpaper should show whether an item is pending, resolved, charged to the bank, included in a later payout, or awaiting owner documentation.
The bookkeeper can record and reconcile supported activity, but management and the responsible accountant decide accounting policy, loss recognition, reserve presentation, and period cutoffs. Dispute responses, customer claims, payment-provider terms, and legal rights are not bookkeeping determinations.
How should gift cards and sales tax stay separate from payout cash?
Gift-card cash, gift-card redemption, product sales, and Shopify Payments settlement are different events. Shopify's sales-report guidance says selling a gift-card product is not included in sales reports, while the payment received appears in payments reporting; when the card is redeemed, the purchased item appears in sales reporting and the gift-card payment appears in payments reporting. Keep a gift-card liability rollforward so issuance and redemption do not create duplicate revenue.
Sales-tax amounts collected from customers should also remain distinguishable from sales and payout cash. Tie the liability activity to the store's tax reports and returns supplied by the owner or tax provider. Daxable can organize and reconcile the bookkeeping records but does not decide nexus, taxability, filing frequency, marketplace rules, or amounts to remit.
Review stale gift-card balances, manual adjustments, store credit, refunds to gift cards, and unclaimed-property questions with the appropriate accountant or attorney. A payout reconciliation can prove cash movement, but it cannot by itself settle revenue recognition, tax, or legal treatment.
What should a Shopify month-end reconciliation prove?
The close should prove five linked totals: sales and other order activity from the approved Shopify reports; Shopify Payments balance movement; each payout's transaction detail; bank deposits and debits; and the ending clearing balance. Each difference needs a named cause, supporting record, owner, and expected resolution date.
Reconcile every bank, credit-card, payment-clearing, and material liability account to an outside statement or source-system report with the same cutoff. Review gross margin separately using the inventory and cost policy approved by the accountant. A payout tie-out can show that cash and fees are complete without proving that inventory quantities, landed cost, or cost of goods sold are correct.
A useful management package can include the profit and loss, balance sheet, cash-flow view, sales and refund trends, payment-fee summary, gross-margin view under the approved policy, gift-card and sales-tax liability schedules, clearing rollforward, and an exception list. Label internal views as management reports rather than tax returns, audited results, or platform certifications.
When should a Shopify seller hire a bookkeeping service?
Look for help when deposits are posted directly to sales, the Shopify Payments balance never clears, fees and refunds disappear into net revenue, gift cards are treated as immediate sales, the connector creates duplicates, inventory reports do not agree, or the tax professional must reconstruct the year from bank statements. Those are recurring control problems, not one-click software settings.
A discovery call should identify the legal entities, stores, currencies, payment processors, sales channels, inventory system, connectors, bank and card accounts, reporting policy, sales-tax workflow, and oldest unreconciled month. Historical cleanup may need a separate scope before monthly bookkeeping can begin.
What does Daxable provide for Shopify sellers?
Daxable provides scoped bookkeeping, cleanup assessment, reconciliations, closing workpapers, exception tracking, and management-use reporting for US Shopify sellers. The work can include Shopify Payments clearing, payout-to-bank tie-outs, supported fee and refund classification, gift-card and sales-tax liability schedules, bank and card reconciliations, and organized records for the client's CPA or tax provider.
Daxable works in the client's own QuickBooks Online file and coordinates with the Shopify exports, payment processors, inventory records, and connectors named in the written scope. Daxable is not affiliated with or endorsed by Shopify or Intuit, and it does not prepare tax returns, file sales-tax returns, provide legal advice, audit records, certify platform data, or determine inventory-valuation policy.
Sources
Frequently Asked Questions
Should I record a Shopify payout as sales in QuickBooks?
No. A payout is the net transfer of Shopify Payments balance activity to the bank. Reconcile the underlying sales, refunds, fees, disputes, and adjustments through a documented clearing workflow, then match the payout to cash.
Why is my Shopify sales total higher than the bank deposits?
Sales and bank deposits use different timing and scope. Deposits can be reduced by fees, refunds, disputes, reserves, or other adjustments, while some captured payments remain pending until a later payout. Use sales reports, Payments activity, payout detail, and the bank statement together.
What Shopify files should I give my bookkeeper each month?
Provide the Shopify Payments activity report, payout or balance-transaction exports, relevant sales and finance reports, refund and dispute detail, gift-card activity, tax reports, connector sync reports, and statements for every bank, card, and outside payment processor.
Can a Shopify-to-QuickBooks connector finish the reconciliation automatically?
A connector can transfer summarized or detailed activity, but its mappings, duplicates, failures, cutoff, and clearing balance still need review. The books are not reconciled until the posted activity ties to Shopify source reports and the bank statement.
How should Shopify gift cards be recorded?
Track gift-card issuance, redemption, refunds, and adjustments in a separate liability rollforward under the policy approved by the accountant. Do not treat both the gift-card sale and the later product redemption as new revenue.
Does Shopify payout reconciliation prove inventory and COGS are correct?
No. The payout reconciliation proves payment activity, clearing, and bank cash. Inventory quantities, landed costs, write-offs, and cost of goods sold need separate source records and an accounting policy approved by the responsible accountant.
Can Daxable file sales-tax returns for my Shopify store?
No. Daxable provides bookkeeping, reconciliations, schedules, and management-use reporting. Nexus, taxability, marketplace rules, return preparation, filing, and remittance decisions remain with the seller and its tax professional.