- October 1, 2026
- Posted by: Sonia Bachher
- Category: Business plans
Your sales report shows a stellar week, but the bank deposit tells a much smaller story. And that missing cash? It is incredibly frustrating for Sugar Land business owners trying to close their books. This discrepancy usually boils down to missing a solid merchant settlement reconciliation process. When card payments pass through payment gateways, fees are sliced off the top before the money even moves. The thing is, without proper tracking, you risk recording revenue incorrectly or doubling up on fees.
Merchant settlement reconciliation matches card payments recorded in your books with processor transactions, fees, adjustments, and payouts, then traces those payouts to bank deposits. A clearing account tracks money still with the processor or in transit, helping you explain differences without recording sales or processing fees twice. In this guide, expect a full breakdown on matching payouts, accounting for hidden fees, and maintaining a perfectly balanced ledger.
Need help explaining a card deposit?
Review our bookkeeping services for small business and request a small-business bookkeeping review. Schedule a 15-Minute Consultation!
Why Card Deposits Differ from Recorded Sales
Before diving into adjustments, it helps to understand the exact amounts and dates being compared.
Gross Sales, Card Payments, and Net Deposits
Understanding gross sales vs net deposits starts with separating your revenue from what actually hits the bank.
| Category | Description |
|---|---|
| Gross Sales Revenue | Total value of goods or services sold before any deductions. |
| Gross Card Collections | Total card payments collected, which may include sales tax, tips, or customer deposits. |
| Withheld Fees | Processor charges deducted directly before the payout is sent. |
| Net Payouts | The actual cash amount transferred to the business bank account. |
Card collections often include payments against earlier invoices. Always inspect the underlying records before classifying these amounts as new sales.
What a Card Settlement Clearing Account Tracks
A card settlement clearing account tracks the exact amount awaiting settlement or receipt. It bridges the gap between a customer swiping a card and the money appearing in the bank.
- A batch is simply a group of processed transactions.
- A payout is the actual transfer initiated to the bank.
- The batch timing dictates why sales dates, payout dates, and bank posting dates rarely align perfectly.
Plus, not every single shortfall is a fee. Do not assume an ending clearing balance must be zero at month-end. For a matched payout group, the formula is clear. Gross card collections minus withheld fees and other documented deductions, plus documented credits, equals the expected payout. But remember to account for separately billed fees and funds explicitly excluded from the payout.
Gather These Records Before Merchant Payout Matching
Thorough preparation prevents endless frustration. Gathering the right documentation is the backbone of proper financial tracking.
| Record | What to Verify |
|---|---|
| POS sales and payment reports | Card-only collections, transaction IDs, refunds, and sales/liability breakdown |
| Processor settlement and payout reports | Included payments, payout ID, fees, adjustments, status, and destination account |
| Processor fee statement | Fees withheld from payouts versus separately billed fees |
| Bank statement and transaction detail | Actual amount received, posting date, and reference |
| Ledger and integration activity | Existing sales, payments, fees, transfers, and clearing-account postings |
Always include the opening clearing balance and its supporting unresolved items. Align the merchant account, currency, reporting period, and time zone before starting. Retain enough adjacent-period data to trace transactions across month-end cutoffs. Request exports or authorized access directly from the processor. But never share passwords to obtain these reports. Because processor fees are often the main culprit behind unmatched numbers, having raw data is non-negotiable.
How to Execute Merchant Settlement Reconciliation Step by Step
- Check What the Books Already Contain
Identify whether the POS, processor integration, invoice workflow, or bookkeeper already recorded the sale, payment, fee, and payout.
- Pinpoint the existing clearing or undeposited-funds workflow before adding new accounts or entries.
- If revenue was recorded on an invoice, the payment normally clears the receivable in a standard accrual workflow. Do not create a duplicate sale.
- Match Card Payments to Processor Activity
Next, execute precise matching. Match captured or completed payments using IDs, amounts, and documented timing.
- Separate cash from other payment methods.
- Do not treat an authorization alone as a completed payment.
- Allow for multiple batches in one payout, and recognize that payments are sometimes split across payouts.
- Reconcile Fees and Other Payout Adjustments
This is where strict payment processor fee reconciliation becomes critical. Compare actual processor charges with the settlement detail and the fee statement.
- Account for supported credits, holds, refunds, or disputes affecting the payout, without expanding into full resolution workflows.
- Record a withheld fee exactly once.
- Track separately billed fees in their own distinct category.
Stripe note: Its payout reconciliation report supports automatic payouts. Manual or instant payouts require checking the appropriate balance and transaction records directly. Do not assume automatic batch attribution works for every single payout type.
- Match the Payout to the Bank Deposit
Use the payout ID or trace reference, exact amount, destination account, and specific dates. Match an existing recorded deposit or transfer where appropriate rather than adding a duplicate. This step ties directly into a seamless bank reconciliation process.
- Explain the Remaining Clearing Balance
Show the opening balance, add card collections, subtract posted fees and settled amounts, and adjust for supported other activity.
- Reconcile separately identifiable processor-held funds.
- Track payouts currently in transit.
- Follow the documented transfer-posting policy of the business.
List each remaining item alongside its expected settlement evidence, age, and follow-up owner. Investigate exceptions rather than posting an unsupported adjustment just to achieve payout clearing.
Worked Example: Two Batches and One $9,700 Deposit
Consider a fictional Sugar Land service business. Assume a single-owner US LLC using accrual-based internal books, one USD processor account, and a zero opening clearing balance. Completed services are paid by card. There are no earlier invoices or existing entries for these transactions. Sales tax, tips, customer deposits, refunds, disputes, reserves, and foreign-currency activity are excluded solely to simplify the example. This is not a conclusion about taxability.
Fees are withheld and recorded on each batch date. The fictional 3% charge is an arithmetic assumption, not an advertised processor rate. No sale, fee, or payout is automatically posted by an integration. If records already exist, inspect and match them instead. The processor holds both net batches at June 30. Payout P-701 is released and received July 2, 2026. These are scenario facts, not a timing promise.
Calculate the Expected Deposit
| Batch / Date | Gross Card Sales | Fees | Net Amount |
|---|---|---|---|
| B-629 / June 29, 2026 | $4,000 | $120 | $3,880 |
| B-630 / June 30, 2026 | $6,000 | $180 | $5,820 |
| P-701 / Combined Payout | $10,000 | $300 | $9,700 |
Calculation: $4,000 + $6,000 – $120 – $180 = $9,700.
Record Each Accounting Effect Once
These entries illustrate the accounting effects. Actual software may create them through sales receipts, payments, or deposits.
| Date / Event | Debit | Credit |
|---|---|---|
| June 29: completed card sales | Merchant clearing $4,000 | Sales revenue $4,000 |
| June 29: withheld fee | Processing fees $120 | Merchant clearing $120 |
| June 30: completed card sales | Merchant clearing $6,000 | Sales revenue $6,000 |
| June 30: withheld fee | Processing fees $180 | Merchant clearing $180 |
| July 2: payout received | Bank $9,700 | Merchant clearing $9,700 |
All entries balance. The June 30 clearing balance sits at $9,700, supported by unsettled processor funds. By July 2, the clearing balance drops to $0. The bank receipt simply moves an asset balance and does not create additional revenue. Explain that $9,700 is the net settlement amount, not the total profit of the business. Cash-basis reporting and tax recognition require separate assessment. Do not use the bank arrival date alone to prescribe tax treatment.
Have an unexplained clearing balance?
Ask a small business bookkeeper to review the batch reports, recorded fees, and bank deposits as part of a small-business bookkeeping review. Schedule a 15-Minute Consultation!
Common Credit Card Settlement Bookkeeping Errors and Their Corrections
Errors happen even with the best systems in place. Identifying them quickly keeps the ledger clean.
| Error | Correction to Explain |
|---|---|
| Recording only the net deposit as revenue | Reconstruct the gross payment and supported components, checking existing sales first |
| Adding a payout as income after sales were recorded | Match or transfer the existing balance; review duplicate income |
| Posting fees already created by an integration | Verify the original fee and correct only confirmed duplication |
| Matching by date and amount alone | Confirm included payments, payout references, account, and currency |
| Treating every difference as a processing fee | Investigate timing, holds, adjustments, and separately billed fees |
| Clearing a residual balance with an unsupported write-off | Retain an itemized reconciliation and investigate the underlying transactions |
Corrections affecting prior reconciliations or closed periods require strict review. Do not instruct teams to delete entries indiscriminately just to force a match.
Use This Merchant Settlement Reconciliation Checklist
A strict completion standard prevents lingering discrepancies. Use this checklist for every merchant settlement reconciliation.
- Reports cover the correct account, currency, dates, and time zone.
- Each payout ties to its included payments and supported adjustments.
- Fees appear once and agree to source records.
- Received payouts match the bank; pending amounts remain identified.
- The closing clearing balance has an itemized explanation.
- Unresolved items have an owner, evidence, and follow-up date.
Keep a compact, reusable record template with these exact fields:
- Review period
- Merchant account
- Payout ID
- Included batch IDs
- Gross collections
- Fees withheld
- Other signed adjustments
- Expected net
- Bank amount/date
- Variance/status
- Evidence
- Reviewer/follow-up
For an unpaid payout, mark it as “pending.” Do not automatically label the full amount as a loss. Use one row per payout, keeping a separate list supporting the closing balance.
Get Unexplained Merchant Balances Reviewed
Spotless books rely on matched payouts, supported fees, and a thoroughly explained clearing balance. When evaluating options, remember that processor-level checks should be discussed when comparing support. Their inclusion strictly depends on the agreed scope.
For Sugar Land owners comparing Houston small business bookkeeping support, ask whether monthly bookkeeping services include processor-level merchant settlement reconciliation. Contact GavTax Advisory Services to request a small-business bookkeeping review with your settlement reports and current ledger. Schedule a 15-Minute Consultation!
FAQs About Merchant Settlement Reconciliation
Why are card deposits lower than sales?
Withheld fees, supported payout deductions, and transit timing explain the gap. Total sales differ from card collections. The payout report identifies exactly what was included. A lower bank deposit does not automatically prove missing revenue.
How do I match processor batches to the books?
Use transaction and payout IDs to trace recorded card payments through the processor directly to the bank. Compare fees, identify outstanding balances, and verify existing integration entries before recording anything new.
Do I need a separate card settlement clearing account?
Yes, it tracks pending funds and provides processor-specific visibility. Check if your software already uses a suitable undeposited-funds workflow first. Avoid prescribing a duplicate account for every business operation without checking existing ledgers.
What if June card sales reach the bank in July?
June’s supported processor balance simply carries forward, and the July receipt clears it. Sale, payout, and bank dates remain distinct. This follows standard accrual assumptions, but avoid using it as a strict tax-timing conclusion.
Can accounting software reconcile merchant payouts automatically?
Supported integrations can record or suggest matches, but users must review account mapping, included transactions, fees, and remaining balances. Universal compatibility is rare. Complete automation requires consistent human oversight to catch exceptions.