What Is Merchant Statement Reconciliation?

Merchant statement reconciliation is the process of comparing payment processor records with bank activity to confirm what was funded and explain the differences between the two.

A processor statement might show sales, refunds, fees, reserves, chargebacks, and adjustments. The bank shows the amount that landed.

Reconciliation connects those records.

At close, the finance team needs to answer two questions:

• Did the expected money reach the bank?
• If the numbers differ, what explains the difference?

A finished reconciliation should answer both without requiring someone to rebuild the analysis later.

Why processor activity and bank deposits differ

Card sales and bank deposits represent different points in the payment process.

Between the original sale and the final deposit, activity might include:

• Processing fees and assessments
• Refunds
• Chargebacks
• Reserve holds or releases
• Adjustments
• Timing differences between processing and funding

That means a difference between gross sales and the bank deposit does not automatically indicate missing funds.

The job is to determine whether the difference is accounted for.

The records involved

Merchant reconciliation typically brings together three record sets.

Processor or merchant statement

This shows what was processed and what happened before funding, including fees, refunds, chargebacks, reserves, and adjustments.

Bank activity

This shows what reached the bank.

A deposit confirms that funds arrived. It does not explain everything that happened between the original transaction and settlement.

Supporting records

These provide the context needed to explain or verify differences.

Depending on the account, that might include:

• Contracted fee schedules
• Reserve terms
• Chargeback notices
• Adjustment records

Together, these records create the evidence behind the reconciliation.

A simple example

Consider a merchant with $10,000 in card sales.

If $8,860 reaches the bank, the $1,140 difference between gross sales and the deposit is explained.

If only $8,760 reaches the bank, $100 remains unexplained.

That $100 is the item the finance team needs to investigate.

The point is not to make every number equal.

It is to separate differences that are accounted for from differences that still need an explanation.

Where reconciliation differences come from

Most differences fall into a small number of categories.

Timing

A batch can close in one period and fund in another, especially around weekends, holidays, or month-end.

Netting and batching

A bank deposit can represent multiple batches or merchant accounts, with fees and other activity already deducted.

Fees

The amount charged might differ from the applicable contracted rate or fee schedule.

Reserves

Funds withheld in one period might be released in another.

Chargebacks and refunds

These reduce funded amounts and do not always appear as separate bank transactions.

Adjustments

Corrections or other account activity can change the amount funded.

Multiple MIDs or processors

Each merchant account can introduce its own statement format, funding schedule, fee structure, and timing.

Reconciliation organizes those differences into a consistent review process.

Matched, Offset, and Exception

A useful reconciliation separates activity into three states.

Matched

The processor record and bank activity agree.

No further investigation is needed.

Offset

A difference exists, but related activity explains it.

A fee, reserve hold, refund, chargeback, or adjustment might account for the gap.

Exception

A difference remains without a confirmed explanation.

That is where the finance team needs to investigate.

This structure matters because the goal is not to have a person inspect every line with the same level of attention.

The team should spend its time on the activity that still needs judgment.

Fee verification is a separate check

A deposit can reconcile correctly even when a fee is wrong.

If a processor deducts a fee and reports that same deduction on the statement, the numbers can still tie to the bank.

Fee verification compares what was charged against the applicable contracted terms.

That might surface:

• A rate that differs from the agreement
• An unexpected per-item fee
• A new or changed charge
• A duplicated fee
• A change in processing cost that needs review

Deposit reconciliation answers where the money went.

Fee verification answers whether the amount charged was consistent with the agreed terms.

Both belong in the same review process.

What a finished reconciliation should leave behind

The final number is only part of the record.

A completed reconciliation should preserve:

• The processor or merchant statement
• The related bank activity
• The explanation behind offsets
• The resolution of exceptions
• Relevant fee-verification results
• Review and approval history

That way, a later question does not require someone to reopen statements, search bank activity, and recreate the analysis.

The explanation stays with the result.

Why manual reconciliation gets harder at portfolio scale

A spreadsheet can work when the number of merchant accounts is small and the process is familiar to the person running it.

The workload changes as the portfolio grows.

More merchant accounts bring more statements, deposits, fee schedules, timing differences, and exceptions.

The accounting logic is not necessarily more complicated.

There is simply more of it to repeat.

That is where a process that depends on manual exports, portal switching, spreadsheet formulas, and individual account knowledge becomes difficult to maintain consistently.

How FeeSuite approaches merchant reconciliation

FeeSuite brings processor statements, bank activity, fees, reserves, chargebacks, and adjustments into one reconciliation workflow.

Fixed rules organize the activity into Matched, Offset, and Exception states.

The same inputs produce the same result.

Your team reviews the items that still need judgment instead of reconstructing the full reconciliation every time.

FeeSuite also compares charged fees against contracted terms within the same workflow and keeps the supporting record connected through review.

The result is a reconciliation your team can review instead of one it has to rebuild.