Automating a process

Credit card payment reconciliation: A guide for merchants

Credit card payment reconciliation compares a merchant's sales with the payment provider's settlement and the bank deposit. It helps identify pending payments, fees, and differences that need review.

In short

  • Check four records: sales, provider payment records, settlements, and bank deposits.
  • A difference isn't always an error: a payment may have been collected but is still awaiting settlement.
  • Fees, refunds, and chargebacks can explain why a deposit doesn't match gross sales.
  • Start with verifiable rules: use AI only if you need to interpret documents or descriptions that rules can't handle.

What is credit card payment reconciliation?

For a merchant, reconciliation means following the money from the sale to the bank. The team compares sales records, provider payment records, settlements, and bank statements. This shows which sales have been paid out and which are still pending.

The term can also refer to reconciling a card a company uses to pay expenses. This guide covers payments received by a merchant.

A payment provider may settle a sale after recording the payment. Before investigating a difference, check the dates and status of each transaction.

How do you follow a sale through to the bank deposit?

The process depends on the provider and your agreement. Keep each stage separate so you don't mistake a pending sale for missing money.

  1. Gather the records. Download sales records, provider payment records, settlements, and bank transactions. Keep the reporting period, currency, and identifier for each file. File-based reconciliation compares these downloaded records instead of looking them up one at a time.
  2. Match sales to payments. Find the transaction reference and compare the amount and status. Review voided sales separately. Also review payments that appear with the provider but not in your sales records. Don't match transactions solely because they have the same amount.
  3. Check the settlement. Match payments to their settlement and review the reported adjustments. Fields and applicable deductions vary by provider.
  4. Verify the deposit. Compare the net settlement amount with the bank transaction using the reference and expected date. One deposit may cover several sales. If the provider groups or splits settlements, keep track of those relationships before flagging a difference.
  5. Assign exceptions. Record the reason, owner, and next review date for each pending item. Don't store card security codes: PCI DSS prohibits storing sensitive authentication data after authorization. Limit access to the files people need.

How do you investigate a difference? An example

This example is illustrative; it doesn't describe a client or a provider's terms.

A store records two sales: one for 100,000 pesos and another for 50,000 pesos. The provider confirms both payments but includes only the first sale in that day's settlement.

For that sale, the settlement shows a hypothetical fee of 3,000 pesos and a net amount of 97,000 pesos. The bank statement shows a deposit of 97,000 pesos with the matching reference. The team reconciles that sale and marks the 50,000-peso sale as pending settlement.

The team keeps the pending sale's reference and checks the payment date provided by the provider. If the sale doesn't appear in the expected settlement, the team asks the provider for details. A missing bank deposit alone doesn't mean the money is lost.

If a refund occurs later, the team links it to the original sale and checks which settlement includes the adjustment. A chargeback needs a separate review. The team should track the claim's status and check its effect on the deposit. It shouldn't treat a chargeback as an ordinary refund.

Which reconciliation tool should you use?

The choice depends on transaction volume, file quality, and the control you need over exceptions.

OptionWhen it fitsWhat to check
Provider's toolWhen its reports cover the payments and settlements you need.Data exports and traceability through to the bank.
SpreadsheetWhen the volume is manageable and one person can review each difference.Versions, formulas, and who is responsible for changes.
Rules-based automation platformWhen files are consistent and matching criteria are clear.Access to sources, errors, and duplicates.
Custom developmentWhen you need to integrate several systems or handle complex groupings.Maintenance, permissions, and decision logs.
AI for supportWhen variable documents or descriptions need interpretation.Human review and interpretation errors.

Cost and timing depend on data access, the number of sources, and the exceptions involved. Testing, security controls, and maintenance also affect both.

How do you measure reconciliation automation?

Before changing the process, we measure a sample reviewed by the team. Then we compare results using the same definition for each metric.

  • Coverage: Divide automatically reconciled transactions by the transactions that entered the process. Review transactions missing from the files separately.
  • Incorrect matches: Count matches the system marked as correct but the team rejected. Review a sample of accepted matches, not just exceptions.
  • Pending items: Measure their count, value, and age. Separate sales still within the expected timeframe from those that need investigation.
  • Review time: Compare the time the team spends investigating and closing differences before and after automation. Include time spent correcting automation errors.
  • Tests with real cases: Prepare a reviewed set that includes fees, refunds, and grouped deposits. Check that the system preserves references and explains each match.

What we do

Frequently asked questions

How do I reconcile my credit card?
It depends on whether you mean payments received or expenses. A merchant compares sales with provider payment records, settlements, and bank deposits. If a company uses the card for expenses, it compares the card statement with receipts and accounting records.
Why is the bank deposit less than my credit card sales?
Some sales may be pending settlement, or fees and refund adjustments may apply. A claim could also affect the payment. First, review the settlement details and dates. Then compare the net amount with the bank statement before concluding that money is missing.
How can I find out when I'll be paid for a sale?
Check the sale's status and the payment date your provider gives you. The date the provider records the payment may differ from the settlement and deposit dates. If payment doesn't arrive when expected, keep the reference and ask the provider for transaction details.
What does file-based reconciliation mean?
It means downloading records from your sources and comparing them in a spreadsheet or system. Settlement files are usually available through the provider's portal or other channels. Before automating, confirm they contain enough references, dates, statuses, and amounts to match the records.
What should I do when a chargeback appears?
Link the chargeback to the original sale and review the provider's communication. Gather the requested documentation, track the claim's status, and check for a settlement adjustment. Don't mark it as a refund without reviewing its cause and how it's handled.
Message on WhatsApp