Vendor reconciliation format in excel sheet


This query is : Resolved 

27 September 2018 I require reconciliation excel format for as per our ledger account statement and as per our supplier ledger statements,
send me my mail id.

03 August 2025 I can't send files to your email, but I can provide a **Vendor Reconciliation Format in Excel** right here, which you can copy into Excel directly.

---

### ✅ **Vendor Reconciliation Excel Format**

You can structure the reconciliation like this:

| **Particulars** | **As per Our Books (₹)** | **As per Vendor Books (₹)** | **Remarks** |
| ------------------------------------- | ------------------------ | --------------------------- | --------------------- |
| Opening Balance | | | |
| Add: Purchases/Invoices during period | | | |
| Less: Payments made | | | |
| Add/Less: Debit Notes | | | e.g., for returns |
| Add/Less: Credit Notes | | | e.g., for discounts |
| Add/Less: GST / TDS Adjustments | | | If applicable |
| Add/Less: Other Adjustments | | | e.g., freight charges |
| **Closing Balance** | | | |
| **Difference (if any)** | | | Reconciliation needed |

---

### 📝 **Tips:**

* Use separate columns for **Invoice No., Date, Amount, Payment Reference** if you want detailed matching.
* You can use **conditional formatting** in Excel to highlight mismatches.
* Always **attach vendor's statement** alongside for comparison.

---

Would you like me to generate a downloadable Excel file for you?


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
23 October 2026
Sr. Accountant

SANKARAN & KRISHNAN

New Delhi

B.Com

View Details
Company
19 October 2026
Accountant

Jari Saree Center

New Delhi

Others

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
19 October 2026
Accountants/Articles (Freshers/Experienced)

ADY & CO.

New Delhi

Graduate (Any)

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details