Glossary · Accounting & Bookkeeping
Payment Reconciliation
Definition
Payment reconciliation is the process of matching each payment received or made, as recorded in the accounting books, with the matching records outside the books: bank statements, payment gateway or UPI settlement reports, card statements and the invoices or bills the payments relate to. Its aim is that every payment is recorded once, against the right invoice, for the right amount.
At a glance
- Category
- Accounting & Bookkeeping
- In this entry
- What it means for Indian businesses How it works · Example
In practice
01 What it means for Indian businesses
It is broader than bank reconciliation, which only matches the books to the bank statement:
| Check | Example of what it catches |
|---|---|
| Invoice ↔ receipt | Customer paid ₹49,000 against a ₹50,000 invoice (₹1,000 short or TDS deducted) |
| Gateway ↔ bank | Gateway collected ₹1,00,000 but settled ₹97,640 after fees and GST on fees |
| Books ↔ bank | Payment recorded in books but not yet cleared, or bank charges not booked |
| Vendor bill ↔ payment | Supplier paid twice for the same bill |
How it works
02 How it works
Collect the period's bank statements, gateway settlement reports and open invoices and bills.
Match each bank or gateway line to an entry in the books and to an invoice or bill.
Investigate differences: fees, TDS, short or excess payments, duplicates, timing.
Post adjustments (fees, TDS receivable, write-offs) and update invoice status.
Worked example
03 Example
An example, not advice on your facts.
An online seller's gateway settles ₹4,88,200 for sales of ₹5,00,000 in a week. Reconciliation shows ₹10,000 gateway fees and ₹1,800 GST on fees. The seller books the fees and input GST, clears all customer invoices as paid, and the gateway clearing account comes back to zero.
Watch out
04 Common mistakes
- Matching only totals, not individual payments.
- Booking net settlements as sales, hiding gateway fees.
- Ignoring small unmatched items until they pile up.
Need help with payment reconciliation? See our Bank and Credit Card Reconciliation or Accounting Services.
