Payment gateways make it easy to collect customer payments, but the amount shown in the payment platform does not always equal the amount deposited into the bank. Processing fees, refunds, chargebacks, timing differences, payout batching, and posting errors can all create differences between sales, gateway activity, and bank deposits.
A clean bookkeeping process therefore needs to follow the complete transaction path: customer payment → payment gateway → fees/refunds/adjustments → payout or settlement → bank deposit → accounting records. The goal is not simply to make the bank deposit match. The goal is to make sales, customer payments, fees, refunds, and cash all agree with reliable source records.
What You’ll Learn
⦁ Why payment gateway balances and bank deposits may not match.
⦁ How Stripe, PayPal, and Square transactions can create bookkeeping differences.
⦁ How to separate gross customer payments from processing fees and refunds.
⦁ How to trace a payout from the gateway to the bank.
⦁ How to identify duplicate, missing, misclassified, or incorrectly matched transactions.
⦁ How to clean up payment gateway clearing accounts without duplicating income.
⦁ How to build a repeatable reconciliation workflow for monthly bookkeeping.
INFOGRAPHIC 1 — The Payment-to-Bank Flow
Image Generation Prompt: Create a clean professional 3D accounting infographic in Accounting Touch style, teal + green + white with deep navy text. Show one clear flow: Customer Payment → Stripe / PayPal / Square → Fees & Refunds → Net Payout → Bank Deposit → Accounting Records. Use green arrows for the correct flow and a small red warning icon where mismatches can occur. Minimal, spacious, realistic 3D objects, no people, no logo
1. Why Does a Payment Gateway Deposit Not Match the Sale?
A common bookkeeping mistake is assuming that one bank deposit should equal one customer sale. In reality, a gateway may process multiple payments together, deduct fees, include refunds or adjustments, or send the payout to the bank at a different time
⦁ Gross sales are recorded, but gateway fees are not recorded separately.
⦁ A net payout is matched directly to income even though the underlying sales were already recorded.
⦁ Multiple customer payments are combined into one bank deposit.
⦁ Refunds or chargebacks reduce the payout but are not reflected in the books.
⦁ A payment or payout is duplicated through a bank feed or manual entry.
⦁ A payout remains in a clearing account because the bank deposit was not matched correctly.
⦁ The accounting date and settlement date differ, creating a temporary timing difference.
INFOGRAPHIC 2 — Gross Payment vs. Net Bank Deposit
Image Generation Prompt: Design a simple 3D before-and-after accounting infographic. Show: Gross customer payments $5,000 → Processing fees $150 → Refunds $350 → Net bank payout $4,500. Clearly label that $4,500 is the bank deposit, not the original sales amount. Use teal, green, white, and deep navy; calculator, payment terminal, bank icon, and receipt; clean professional layout.
2. Stripe Cleanup
What Commonly Goes Wrong
Stripe activity can contain customer payments, fees, refunds, disputes, and payouts. A bookkeeping file can become inaccurate when the payout is treated as the sale instead of tracing the gross activity and related deductions.
⦁ Stripe gross payments are recorded as income, but fees are missing.
⦁ Net Stripe payouts are also added as income, creating duplicate revenue.
⦁ Refunds are recorded incorrectly or are not linked to the underlying customer transaction.
⦁ Payouts are duplicated through bank-feed matching or manual entries.
⦁ Stripe payouts remain unexplained in a clearing account.
⦁ The payout date is used without considering the underlying transaction and settlement timing.
How to Clean Up Stripe
- Start with the Stripe transaction or payout report for the period being reconciled.
- Identify gross customer payments and confirm that sales are recorded only once.
- Separate processing fees from customer revenue.
- Review refunds, disputes, and other adjustments and confirm their accounting treatment.
- Match each net payout to the corresponding bank deposit using payout date, amount, and supporting detail.
- Investigate unmatched or duplicated payouts before making adjustments.
- Reconcile the Stripe clearing account and document any legitimate timing differences.
INFOGRAPHIC 4 — Stripe Cleanup Workflow
Image Generation Prompt: Create a horizontal 3D workflow: DOWNLOAD STRIPE REPORT → VERIFY GROSS PAYMENTS → SEPARATE FEES → REVIEW REFUNDS/DISPUTES → MATCH NET PAYOUT → MATCH BANK DEPOSIT → RECONCILE. Use green arrows, one red warning icon for duplicates, teal and green accents on white, deep navy text, clean accounting aesthetic, no logo, no people.
3. PayPal Cleanup
What Commonly Goes Wrong
PayPal can contain customer receipts, fees, refunds, disputes, transfers, and balance movements. The key bookkeeping challenge is distinguishing customer activity from transfers between PayPal and the business bank account.
⦁ A PayPal receipt is recorded as income and the later bank transfer is recorded as income again.
⦁ PayPal fees are netted from receipts but never recorded separately.
⦁ Refunds are posted to an incorrect account or customer.
⦁ PayPal-to-bank transfers are mistaken for new revenue.
⦁ Duplicate bank-feed transactions are created when the transfer is also entered manually.
⦁ The PayPal balance contains old or unexplained transactions that were never reconciled.
How to Clean Up PayPal
- Review PayPal transaction activity and identify customer receipts, refunds, fees, disputes, and transfers.
- Confirm that customer receipts are recorded as revenue or Accounts Receivable payments only once.
- Record applicable PayPal fees separately according to the business’s accounting policy.
- Treat PayPal-to-bank movements as transfers when they represent movement of already-recorded funds.
- Match the bank transfer to the corresponding PayPal transaction or settlement evidence.
- Investigate duplicate receipts, transfers, and refunds before deleting or reversing anything.
- Reconcile the PayPal balance and investigate any unexplained residual amount.
INFOGRAPHIC 6 — PayPal Cleanup Workflow
Image Generation Prompt: Design a clean 3D workflow: IDENTIFY PAYPAL RECEIPTS → VERIFY CUSTOMER/SALE → RECORD FEES → REVIEW REFUNDS → SEPARATE TRANSFERS → MATCH BANK TRANSFER → RECONCILE PAYPAL. Use teal, green, white and deep navy, realistic wallet, bank and receipt objects, green check marks, minimal professional layout, no people, no logo
4. Square Cleanup
What Commonly Goes Wrong
Square may combine card payments and other sales activity into deposits or transfers that do not equal the gross sales shown in the sales system. Fees, refunds, and timing differences can therefore create a gap between sales reports and bank activity.
⦁ Gross Square sales are confused with net deposits.
⦁ Processing fees are not separated from sales.
⦁ Refunds or adjustments are missing from the accounting records.
⦁ A Square deposit is recorded as new income even though the sales were already recorded.
⦁ One deposit contains multiple sales transactions and cannot be traced to a single invoice or receipt.
⦁ Duplicate Square deposits appear because the same activity is imported through more than one source.
How to Clean Up Square
- Obtain the relevant Square sales or payment report and settlement/deposit detail.
- Confirm gross sales and make sure they are recorded only once.
- Identify processing fees and record them separately when appropriate.
- Review refunds, voids, disputes, or adjustments and confirm their treatment.
- Match Square settlements to the bank deposits rather than matching the bank deposit directly to gross sales.
- Investigate differences caused by timing, batching, duplicates, or missing transactions.
- Reconcile any Square clearing account and document unresolved timing items.
INFOGRAPHIC 8 — Square Cleanup Workflow
Image Generation Prompt: Create a simple 3D seven-step workflow: SALES REPORT → GROSS SALES → FEES → REFUNDS → NET SETTLEMENT → BANK MATCH → RECONCILED. Show a green check at the final stage and a small red warning icon at the mismatch stage. Teal + green + white, deep navy text, realistic accounting objects, no people, no logo.
5. One Real-World Example: Why the Bank Deposit Looks Wrong
Suppose a business processes $8,000 of customer payments through a gateway during a period. The gateway deducts $240 in processing fees and $500 in refunds before sending a net payout of $7,260 to the bank. If the bookkeeper records the $7,260 deposit directly to Sales Income, the books may understate gross sales and fail to show the related fees and refunds correctly.
During cleanup, the bookkeeper should trace the gateway report, confirm the gross activity, identify fees and refunds, match the net payout to the bank deposit, and then verify that income, expenses, refunds, and cash are represented correctly. The exact correction depends on how the original books were recorded.
INFOGRAPHIC 9 — Before vs. After Gateway Cleanup
Image Generation Prompt: Create two clean 3D panels. BEFORE: Gateway Gross Payments $8,000; Fees/Refunds not properly recorded; Bank Deposit $7,260; Books unclear. AFTER: Gross Payments verified; Fees $240 identified; Refunds $500 identified; Net Payout $7,260 matched to Bank; Clearing Account reconciled. Use teal + green + white with deep navy text, red warning only in BEFORE, green checks in AFTER, premium professional accounting style.
6. Checks After the Fix
⦁ Gross sales are recorded only once.
⦁ Payment gateway fees are correctly identified and classified.
⦁ Refunds and other adjustments are properly reflected.
⦁ Each payout or transfer is represented only once.
⦁ Bank deposits agree with the related net payout or settlement evidence.
⦁ Payment gateway clearing accounts have no unexplained balance.
⦁ No duplicate income has been created.
⦁ Accounts Receivable or customer balances are not distorted by gateway activity.
⦁ Any timing differences are understood and documented.
⦁ The bank reconciliation can be completed without unexplained differences.
7. What Bookkeepers Should Avoid
⦁ Do not treat every payment gateway deposit as new income.
⦁ Do not record both gross gateway sales and the net bank payout as revenue.
⦁ Do not ignore processing fees simply because they are deducted before settlement.
⦁ Do not delete or reverse a transaction before understanding what it represents.
⦁ Do not force a clearing account to zero with an unexplained journal entry.
⦁ Do not assume a gateway balance and bank balance should always match on the same date.
⦁ Do not ignore refunds, disputes, or duplicate transactions.
Payment gateway cleanup is not simply about making a deposit match a bank statement. It is about connecting the entire money trail—customer payment, gross sales, fees, refunds, settlement, and bank deposit—so that every part of the accounting record tells the same story.
Whether the business uses Stripe, PayPal, or Square, a disciplined reconciliation process can uncover duplicate income, missing fees, unapplied refunds, unexplained clearing balances, and other issues that reduce the reliability of financial reports.
Clean gateway records. Accurate deposits. Reliable financial reporting.