Shopify or Stripe Payouts: How to Check a Bank Deposit

A payment-provider deposit is often smaller than the customer charges behind it. Recording that deposit as sales can hide fees, understate revenue and lose track of sales taxes. The missing step is a reconciliation between the provider's activity and the cash transferred to the bank.

You can use these checks with different payment providers. This is not a guide to Shopify screens. Shopify Payments and a separate Stripe account are not the same service. Use the reports, terms and rules for the account that actually processed your payments.

1. Identify the account, currency and payout

Start with one bank deposit and the corresponding payout reference. Confirm the legal business, provider account, settlement currency and receiving bank account. Similar dates or identical dollar amounts do not prove that two records belong together.

Keep four dates distinct where available: the customer transaction date, the date funds become available, the payout date and the bank posting date. A payout can contain activity from several sales days, and a month's final sales may settle in the next month.

Schedules, reserves and delays vary by provider, country and account circumstances. Check the actual account information rather than assuming that a sale always reaches the bank a fixed number of days later. Do not book a delayed but valid settlement as missing revenue merely because the bank has not received it.

2. Collect the evidence behind the deposit

Get the payout details and the list of transactions that belong to it. Keep transaction IDs, amounts, currency, fees, refunds, disputes and any changes to the provider balance. Also keep the sales records that explain which amounts are revenue and which are taxes.

A summary screenshot may show the payout total without explaining its composition. Preserve an export or report that allows a reviewer to trace the lines. Avoid combining reports with different time zones, statuses or date filters and then treating the difference as an unexplained fee.

• Separate successful charges from pending or failed attempts.
• Distinguish a customer refund from a payout reversal.
• Identify reserve holds and releases separately from expenses.
• Keep foreign-currency amounts separate from converted settlement amounts.

Protect access-bearing information in the files. A reconciliation needs transaction references and accounting support, not passwords or unrestricted copies of customer payment details.

3. Work from customer payments to the bank deposit

Here is a completely hypothetical payout. The sales report separates $3,640 of sales before tax and $312 of sales taxes, for $3,952 in customer charges. The tax amount is an assumed aggregate from the records, not an illustration of a universal tax rate.

Hypothetical payout bridge in a single currency

Component	Change	Running amount
Customer charges	+$3,952	$3,952
Refund: $180 sale and $15 tax	−$195	$3,757
Processing fees	−$89	$3,668
New reserve hold	−$120	$3,548
Release of a prior reserve	+$45	$3,593
Expected bank deposit	No further change	$3,593

The arithmetic is $3,952 − $195 − $89 − $120 + $45 = $3,593. After the refund, sales before tax are $3,460 and sales taxes are $297. Together they equal $3,757, before fees and reserve movements.

The $120 hold is not automatically an expense, and the $45 release is not new sales revenue. Both need to connect with the relevant provider balance. A dispute may also involve several events; do not assume every temporary hold is a final loss.

4. Reconcile the clearing balance, not just one deposit

A clearing account is a temporary account in your books. It can connect sales already recorded with money the provider sends later. Depending on your accounting setup, its balance shows amounts still waiting to be transferred or explained. Check how your setup works before making adjustments.

If the sales and related activity have already been posted, the $3,593 bank receipt generally transfers value from the appropriate provider clearing balance to the bank. Posting another $3,593 of revenue would count sales again. Likewise, importing fees through two separate feeds can double the expense.

Review the balance carried forward after the payout. It may include unsettled transactions and reserves rather than an error. The opening balance plus recorded activity less transfers must explain the closing balance, with each component supported.

Track provider accounts and currencies separately when combining them would hide the details. One total can look right even when one account is too high and another is too low.

5. Diagnose a mismatch in a consistent order

1. Scope: same account, currency, payout reference and date basis?
2. Completeness: missing refunds, disputes, fees or balance adjustments?
3. Duplication: repeated import, repeated bank match or duplicated sale?
4. Timing: pending activity or a bank posting in another period?
5. Conversion: settlement currency, conversion fees or rounding differences?

Compare identifiers before changing amounts. Two separate customer payments can have the same value. A small difference should not be written off reflexively; first establish whether it represents rounding or a missing transaction with broader implications.

If the provider shows a completed payout but the bank receipt cannot be found, retain the reference and investigate through the provider's supported process. Do not force agreement with an invented receipt.

6. Close the loop with review and follow-up

Save the report filters and dates, worksheet, payout reference, matching bank record and explanation of any balance left over. Give each unanswered question to someone to follow up. Check it again when you next finish the books. Waiting usually makes old differences harder to explain.

Bookwits can coordinate the document requests, review tasks and follow-ups. It does not connect to banking rails or automatically reconcile Shopify or Stripe payouts. The ledger entries and provider reports remain in their respective systems.

Complete the ordinary bank reconciliation after this bridge is understood. Matching the net deposit is necessary, but it does not by itself prove that revenue, fees, taxes and unsettled balances have been recorded correctly.