How to reconcile storefront sales with your bank statement

You open your bank app expecting yesterday’s sales to be there. Instead, the deposit is smaller than the total shown in your storefront, and the payment dashboard seems to use a different date. A refund from last week may be mixed into today’s payout, while Stripe’s processing fee is listed separately. The answer is usually not that money has gone missing. You are comparing different stages of the same transactions.

Start with the four numbers

Before you compare totals, label what each total means. Gross sales are the prices customers were charged before deductions. Processor fees are the fees charged by Stripe for handling payments. Net payment activity is what remains after fees, refunds or other adjustments in the payment records. Payouts are amounts sent from Stripe to your bank. The bank statement records the final deposit, not the individual customer orders behind it.

1. 1Choose a period, such as 1–31 March, and write down the period’s storefront orders.
2. 2Export or copy the corresponding payment records from Stripe, including transaction IDs, dates, amounts, fees, refunds and currency where available.
3. 3List each payout that reached your bank during the period, including its payout date and amount.
4. 4Compare the payout total with the bank deposits, allowing for payouts created at the end of one period and deposited in the next.
5. 5Investigate unmatched items individually rather than changing the totals until they agree.

Why the dates do not line up

A customer may place an order on 31 March, the payment may be recorded by Stripe on 31 March, the payout may be created on 1 April, and the bank may show the deposit on 2 April. Those are four dates for one sale. Your chosen reporting period therefore matters. If you report by order date, you are measuring sales activity. If you report by bank date, you are measuring cash received. Neither is automatically the correct view; they answer different questions.

Build a transaction-level reconciliation

A single monthly total hides the useful detail. Create one row per payment, with columns for order date, payment ID, product, gross amount, processor fee, refund, currency, net amount, payout ID and bank date. You do not need an elaborate accounting system to begin. A spreadsheet is enough if every row can be traced back to the storefront or Stripe record.

Then calculate the expected net amount for each payment. In simple terms: gross payment minus Stripe’s processing fee, minus any refund or other adjustment recorded against that payment. Do not describe the result as profit. You may still have income tax, VAT or other business costs to deal with, and the treatment depends on your circumstances and where your customer lives. For digital products, keep the customer and tax information your records require; see the tax records your storefront should keep for every digital sale.

Treat fees, refunds and taxes as separate lines

Storefront sales and bank deposits are not supposed to match before deductions. store.fan takes 0% of sales, but Stripe’s own processing fee still applies. Money goes straight to your own Stripe account, so your reconciliation needs to start with the payment records there and finish with the payout shown by your bank.

A refund is not a new negative sale in your storefront analysis. Link it to the original order and payment. If the refund appears after the original payout, it may reduce a later payout instead. Record the refund date as well as the original sale date so you can explain why two reporting periods differ.

Taxes need their own column and decision. Whether tax is included in the customer’s price, collected separately or owed by you depends on your setup and the customer’s location. Do not use the bank deposit as your taxable-sales figure without checking the underlying order records. A deposit is a cash movement, not a complete description of the sale.

Use your storefront as the sales index

Your storefront is useful for identifying the order, product and customer context. Your payment account is useful for confirming whether money was processed, adjusted and included in a payout. Your bank is useful for confirming arrival. Keeping those roles separate makes the review quicker.

If you sell downloads, courses or memberships through store.fan, you can use the storefront as the starting index and follow each order into the payment record. The platform’s analytics features can help you understand sales activity, but do not treat an analytics total as a substitute for transaction-level payment records when you are reconciling cash.

A monthly routine that stays manageable

• At month end, save the storefront sales report and the relevant Stripe payment and payout records.
• Match every payout to a bank deposit using the payout amount, date and bank reference.
• Mark each payment as matched, refunded, pending, disputed or requiring review.
• Carry late-month payments and early-next-month payouts into a short timing list instead of forcing them into the wrong month.
• Investigate the unmatched list before filing records, while the transaction is still easy to find.
• Keep the final spreadsheet and supporting exports together with your other business records.