18. Vendor Reconciliation — Process & Formats


Vendor Reconciliation is one of the most critical AP controls. It ensures that the amount your books show as payable matches the amount the vendor expects.Incorrect reconciliation leads to:
  • Duplicate payments
  • Missed credit notes
  • Wrong GST ITC
  • Audit objections
  • Vendor disputes
  • Overstated or understated liabilities
This guide gives SMEs a complete, structured reconciliation process and templates.

1. Introduction — Why Vendor Reconciliation Matters

Vendor reconciliation compares your ledger balance with the vendor’s statement of account to ensure accuracy.
Common reasons for differences:
  • Missing invoices
  • Duplicate invoices
  • Unaccounted credit notes
  • Wrong postings
  • Payment not adjusted by vendor
  • GST mismatches
  • Advances not settled
Weak vendor reconciliation affects GST compliance (ITC claim), TDS accuracy, expense reporting, and cashflow planning.
Key Points:• Vendor reconciliation prevents overpayments and disputes.• Ensures accurate GST ITC claim and books of accounts.• Mandatory before audit, financial statements, and year-end closing.• Should be performed monthly or quarterly depending on volume.

2. Objective

To explain how to perform proper vendor reconciliation, what documents are required, what differences arise, and provide standard reconciliation formats suitable for SMEs and startups.

3. Core Concepts — What Is Vendor Reconciliation?

Vendor reconciliation is the comparison of:
Your Books (AP Ledger)
vs.
Vendor’s Books (Statement of Account)
Reconciliation ensures:
  • All invoices are accounted for
  • Credit notes are recorded
  • Payments are correctly adjusted
  • Balances match
  • GST ITC is correct
  • No outstanding disputes remain
The final output is a Reconciliation Statement documenting differences and actions required.

4. CABTA Framework — “The 6-Step Vendor Reconciliation Process”

A practical, streamlined method:

STEP 1 — Collect Vendor Statement

Obtain from vendor for the relevant period:• Statement of account (SOA)• Invoice copies• Credit notes• Debit notes• Payment receipts
Request in standard format (preferably Excel or PDF).

STEP 2 — Extract Your Ledger Report

Download or extract from accounting software:• Vendor ledger• Purchase register• Payment history• TDS deduction records• Advance ledger (if any)

STEP 3 — Line-by-Line Matching

Match transactions between both records:
Match:
  • Invoices
  • Credit notes
  • Payments
  • Advances
  • Debit notes
Identify differences such as:
  • Missing invoices
  • Unadjusted payments
  • Wrong amounts
  • Wrong dates
  • Duplicates
  • GST mismatches

STEP 4 — Classify Differences

Group differences into buckets:

A. Invoices in vendor books but missing in your books

→ Post missing invoices→ Important for GST ITC (2B reconciliation)

B. Your invoices not shown by vendor

→ Vendor ledgers not updated → share details

C. Payments made by you but not adjusted by vendor

→ Provide UTR/cheque details to vendor

D. Credit notes not accounted

→ Request vendor to issue CN/adjust in ledger

E. TDS not reflected in vendor’s ledger

→ Send Form 26Q details / TDS certificate

F. Duplicate posting in either book

→ Rectify immediately

STEP 5 — Prepare Reconciliation Statement

A structured reconciliation shows:
  • Opening balances
  • Add invoices
  • Less credit notes
  • Less payments
  • Adjust TDS
  • Adjust advances
  • Closing balance as per each book
  • Differences list
A sample format is provided below.

STEP 6 — Finalise & Obtain Confirmation

Send reconciliation to vendor for acceptance.
Once confirmed:• Post correcting JVs• Update outstanding payable• Clear advances• Prepare GST ITC impact (if required)

5. Common Vendor Reconciliation Issues SMEs Face

• Vendor books show more invoices than your books• Purchases recorded without invoice copies• Duplicate invoices booked• Vendors not adjusting TDS• Wrong GST treatment leading to ITC mismatch• Credit notes missing in AP ledger• Advances not adjusted for years• Vendor accounting based on dispatch date; SME using receipt date• Manual errors due to non-standard formats
These issues inflate liabilities and distort expenses.

6. Vendor Reconciliation Formats

Format 1 — Simple Reconciliation (Summary Format)

Vendor Reconciliation Statement
Vendor Name:
Period:
Opening Balance (as per Books) ₹______
Add: Invoices as per Vendor ₹______
Less: Invoices not accepted ₹______
Add/Less: Credit Notes ₹______
Less: Payments ₹______
Less: TDS Deducted ₹______
Add/Less: Adjustments ₹______
Closing Balance as per Books ₹______
Closing Balance as per Vendor ₹______
Difference ₹______
Reasons for Difference:
1. _________________________________
2. _________________________________
3. _________________________________

Format 2 — Detailed Line-Item Reconciliation (Excel-ready)

Date
Document Type
Document No.
Amount (Vendor)
Amount (Books)
Match? (Y/N)
Difference
Remarks
Invoice
INV001
10,000
10,000
Y
0
Invoice
INV002
15,000
–
N
15,000
Missing in books
Payment
UTR1234
(8,000)
(8,000)
Y
0
Credit Note
CN05
(2,000)
–
N
(2,000)
CN not posted

Format 3 — TDS Adjustment Format

7. Documentation Required for Clean Reconciliation

• Purchase invoices• Credit notes/Debit notes• Vendor SOA• Payment proofs (UTR, cheques)• TDS challans & Form 26Q• GRN/Delivery challans (optional)• GST 2B reconciliation sheet
Maintaining documentation ensures financial and tax accuracy.

8. Case Example — Preventing Overpayment Through Reconciliation

Client: Construction contractorIssue: Vendor claimed ₹18 lakh outstanding. Client books showed ₹12 lakh.
CABTA Intervention:• Conducted line-item reconciliation• Identified missing credit notes worth ₹4 lakh• Found duplicate invoice entry of ₹2 lakh
Result:• Correct payable = ₹12 lakh• Prevented overpayment of ₹6 lakh• Vendor accepted reconciliation• Improved AP discipline across organisation

9. Tools & Templates (Application Layer)

• Vendor Reconciliation Template (Excel)• TDS & Payment Matching Tool• Vendor Master Format• AP Reconciliation SOP• GST 2B Reconciliation File
(Available immediately on request.)

10. CABTA Insight

“Vendor reconciliation is the simplest way to protect cash and prevent GST ITC loss.”

Next Article