Payment Report Doesn’t Match Bank Deposit? How to Reconcile

Your payment report shows $12,000 collected. The bank shows a deposit of $11,425. Now someone in finance has to explain the $575 difference.

Before assuming a payment is missing, check what each total represents. A payment activity report and a bank deposit may cover different transactions, dates, fees, or adjustments. Comparing the two totals without that detail can send you looking for an error that isn’t there.

For a small city or county, that can mean another spreadsheet, a call to the processor, and time taken away from the rest of the day’s work.

The place to start is the deposit, not the day’s collection total. Identify the transactions and adjustments included in that deposit, then work back to your payment records.

Start with the Right Report

A resident making a payment and your government receiving the funds are related events. They are not necessarily the same event.

Your payment activity report may show transactions accepted during a selected period. Your settlement or funding report shows the transactions included in a particular batch or deposit. Your bank statement shows when the money posted to the account. If any of those terms are unfamiliar, IntelliPay’s payment processing glossary defines them.

Report names vary by provider. Ask which report identifies the transactions behind each funded deposit. A summary of payments received is useful, but it may not be the report you need to explain a bank entry. Deposit-level detail should let you trace the payments, refunds, fees, and other adjustments included in the transfer.

Before comparing totals, check:

• The account, sub-account, or location selected.
• The payment methods included.
• The report’s date field and time zone.
• Whether the total includes pending, declined, or voided transactions.
• Whether amounts are shown before or after fees and adjustments.
• Whether counter payments taken in cash or by check are recorded in the same system but deposited separately by staff.

Do not assume two reports use the same settings because both say “daily.”

Check the Dates Before Looking for Missing Money

A payment entered on Tuesday may be included in a deposit that posts later. Matching Tuesday’s payment activity to Tuesday’s bank deposits can therefore produce a difference even when the transactions were processed correctly.

Use the batch, settlement, or funding reference to connect the records. Date and amount help, but neither should be your only matching field. Deposit reconciliation is about identifying the transactions included in a transfer—not simply finding two totals on the same calendar date.

If your report does not make that connection clear, ask your provider:

That is a more useful support question than “Why don’t today’s totals match?”

Confirm How Your Fees Are Handled

Do not automatically subtract processing fees from the collection total.

First, confirm your government’s fee arrangement. Many governments absorb processing costs. Others charge residents a service or convenience fee so the government pays little or nothing to accept cards and ACH. The arrangement you chose determines what you should expect to see in the bank account.

The three most common setups look different at the bank:

• Fees deducted from deposits. The deposit is lower than the payments it contains, and the funding detail should show the fee amount.
• Fees billed separately. The deposit should match the payments it contains, and the fees appear on a separate statement or debit.
• Service fee with split funding. The resident pays the fee, and it is routed away from your account. Your deposit should reflect the principal collected, not the principal plus the fee.

IntelliPay’s reconciliation page notes that split funding can simplify fee accounting. That is a reason to confirm your own configuration rather than apply a generic gross-minus-fees formula. For a comparison of absorbing costs versus assessing a fee, see the guide Government Payments: Have Fees Assessed or Absorb the Costs.

Then check the actual funding detail. If a fee appears on an activity report, that alone does not tell you whether it reduced this particular deposit.

Look for Refunds, Chargebacks, and ACH Returns

A refund can relate to a payment collected earlier while affecting a later funding period. Chargebacks and other adjustments can also change the amount deposited.

That is why the original payment report may not explain the current deposit by itself. Review the deposit’s itemized detail for refunds, chargebacks, fees, and other balance adjustments. For more on how disputes work, see What Every Government Agency Should Know About Chargebacks.

For each difference, record:

• The transaction or adjustment reference.
• The amount.
• The original payment, if applicable.
• The deposit affected.
• What needs to be corrected or followed up.

Avoid leaving “processor adjustment” as the explanation when you can identify the actual transaction.

For ACH, also confirm how your provider reports pending payments, funded payments, and returns. A resident’s ACH payment can be returned for reasons such as insufficient funds after it first appeared on your activity report. Your reconciliation procedure needs to distinguish those statuses rather than treat every submitted payment as money already received. IntelliPay’s guide to ACH payments covers how ACH moves in more detail.

Make Sure the Department Totals Belong to That Deposit

A city may collect utility payments, permit fees, and recreation charges through different departments. A county may have several offices accepting payments.

In IntelliPay, departments can be set up as sub-accounts under a master account, with sub-accounts rolling up into summary reports. That structure is useful, but only if you compare the right level. Check whether the bank entry represents one sub-account, several sub-accounts, or the master account total. Then select the same scope in your reports.

Two questions need separate answers:

1. Does the deposit match the transactions and adjustments that funded it?
2. Have those transactions been assigned to the correct department, fund, and revenue account?

A deposit can match perfectly while the department allocation is wrong.

A Worked Example: Explaining a $575 Difference

Suppose a city’s payment activity report shows $12,000, but the bank deposit is $11,425.

For this example, assume the city absorbs its processing costs and the funding detail confirms that:

• $350 of the reported payments belongs to a later funding batch.
• A $150 refund was deducted from this deposit.
• $75 in processing fees was deducted from this deposit.

Illustrative example only. Your funding schedule and fee arrangement may differ.

If the same city instead used a resident-paid service fee with split funding, the $75 fee line would typically not appear in this deposit. The expected deposit would be $11,500, and a $75 shortfall would then be a question to raise rather than an expected fee.

Either way, the $350 is still a follow-up item. It needs to be matched to the later deposit. Explaining today’s difference does not finish the work if an outstanding item remains unresolved.

Keep a Short Exception Log

When a difference cannot be resolved immediately, document it instead of starting the investigation over the next day.

Reconciliation should identify discrepancies, investigate their causes, and document any necessary corrections. A running exception log gives staff a record of what remains open.

Do not change the ledger just to make a difference disappear. Determine whether it is a timing item, a reporting issue, or an accounting error before making a correction under your government’s procedures.

What to Gather Before Calling Your Payment Provider

A support request is easier to investigate when it identifies a specific deposit.

Have these records ready:

• ☐  Bank deposit date, amount, and description.
• ☐  Account or sub-account identifier.
• ☐  Batch, settlement, or funding reference.
• ☐  Reports used, including filters and date ranges.
• ☐  Expected amount and the unexplained difference.
• ☐  Relevant transaction, refund, or adjustment references.

Send transaction identifiers rather than sensitive payment information. Use your provider’s approved support channel for records containing account or personal data.

When the Reporting Itself Is the Problem

If staff must rebuild the same deposit from several reports every day, the issue may be the setup rather than the people doing the work. The fastest way to find out is a walkthrough using one actual deposit: the bank entry, its funding detail, the underlying transactions, and any adjustments. That will show whether the gap is a report setting, a missing reference, or a step in the process.

Already an IntelliPay customer? Contact IntelliPay Support and ask for a walkthrough of one deposit. Have the checklist above ready.

Evaluating providers? Ask any vendor to show how a single deposit traces back to individual payments and departments. IntelliPay’s City in the Cloud and County in the Cloud platforms use master and sub-account reporting built for multi-department governments. Talk with a consultant to see how it maps to your deposits.

Frequently Asked Questions

Should our daily payment total equal our daily bank deposit?

Not necessarily. First confirm that both totals cover the same funded transactions and adjustments. A payment-date report is not automatically a deposit-date report.

If residents pay a service fee, should it show up in our deposit?

It depends on your setup. With split funding, the service fee is typically routed away from your account, so your deposit should reflect the principal collected. Confirm your configuration with your provider before treating a fee-sized difference as expected.

Can we reconcile credit cards and ACH together?

You can use a common tracking process, but preserve the detail needed to identify each payment method, funding batch, and adjustment. Do not force different funding records into one total before establishing what each deposit contains.

Does a matched deposit mean the accounting is correct?

No. It confirms that the deposit agrees with the funding detail you reviewed. You still need to verify the related ledger entries and department allocations. Reconciliation connects bank records, payment records, and accounting records—not just two totals.