Vendor reconciliation format in excel sheet

This query is : Resolved

Sanjay Dnyaneshwar Kobal (Querist)
Follow

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.

Aashok Kumar Sharma online

Aashok Kumar Sharma online

(Expert)
Follow

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

Summarize this with AI

ChatGPT Perplexity Claude Google AI Grok

Similar Resolved Queries

Unanswered Queries

Popular
Recent

Trending Online Classes

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

Meet our CAclubindia PRO Members

vinod

sandhya.v

Suneel Shah

NICKOONJ VANANI

CA.K.RAMAKRISHNA. PRABHU

Subscribe Now

Vendor reconciliation format in excel sheet

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

Accountant

Article Assistant

GST CONSULTANT

CA Final

GST CONSULTANCY