One deposit can contain many accounting events

Shopify Payments usually transfers a net amount to the bank. That amount may combine orders from several days, subtract refunds and processing fees, include adjustments, and leave newer orders for a later payout. If the bank deposit is posted directly to sales, the cash balance may look right while revenue, fees, taxes, and receivables are wrong.

Suppose customers placed orders with gross sales of $24,862.40. Discounts reduced the selling price by $412.00, refunds returned $1,147.25, payment fees cost $638.91, and $1,257.06 of net order activity had not settled yet. The bank might receive $21,407.18. Recording only that deposit as revenue hides the economic activity that produced it.

The control: gross activity, deductions, unsettled amounts, and the bank deposit must form one explainable bridge with a zero unexplained difference.

Build the settlement bridge

A reliable reconciliation starts with the payout report or API data, not with a guess based on the bank memo. Group the source activity by payout identifier and preserve the settlement date. Then map each component to the account where it belongs.

  • Gross sales show customer demand before discounts, refunds, and payment costs.
  • Discounts reduce sales rather than becoming an operating expense.
  • Refunds and returns reverse the appropriate revenue and, when inventory is returned, may also affect COGS and inventory.
  • Processing and platform fees are expenses that never arrive in the bank deposit.
  • Sales tax collected is generally a liability rather than revenue.
  • Unsettled funds remain in a clearing or payment processor receivable account until a later payout reaches the bank.

The entry should clear the payout receivable for the amount that actually settled. If a reserve, chargeback, or timing difference remains, it stays visible instead of being forced into revenue merely to make the deposit match.

Put activity in the correct month

Cash and revenue do not always occur in the same accounting period. An order placed on January 31 may settle on February 2. Cash-basis reports may focus on when money moves, while accrual books generally recognize the sale when the earning event occurs and show the unsettled amount as an asset at month-end.

This distinction matters when a month ends during a busy sales period. Posting February payouts entirely into February can move January sales, refunds, and fees into the wrong month. The result distorts growth, gross margin, sales tax balances, and comparisons with the commerce platform.

A month-end reconciliation should therefore answer two questions separately: what activity belongs to the month, and which portion of that activity has reached the bank? When those questions are collapsed into one deposit entry, the books cannot answer either one well.

Keep evidence someone else can follow

A reviewer should be able to start with a bank deposit, locate the matching payout, inspect the transactions inside it, and confirm the accounts used for discounts, refunds, taxes, fees, and unsettled funds. The accounting system should retain payout IDs, source dates, and supporting reports rather than only a summarized journal entry.

Investigate any difference instead of automatically posting it to a miscellaneous account. Common causes include a refund processed outside the normal payout, a chargeback, a rolling reserve, a foreign exchange conversion, a manually captured payment, or a payout that covers a different date range than expected.

Questions to ask your bookkeeper

  1. Can every Shopify payout be tied to one bank deposit or a documented combination of deposits?
  2. Are processing fees and refunds visible separately from net sales?
  3. Where are orders that have been sold but not yet paid out shown at month-end?
  4. Can the team reproduce the reconciliation from retained source records?

When those answers are clear, the payout is no longer a mysterious bank line. It becomes a documented settlement of activity already represented correctly in the books.

This article is general information, not accounting, tax, or legal advice for a specific business. Treatment can vary by jurisdiction, accounting method, contract terms, and facts. Consult a qualified professional about your circumstances.