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.
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?
---
### ✅ **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
Click here to login now
Similar Resolved Queries
Unanswered Queries
- CAPITAL GAIN REDEVELOPED FLAT
- Multiple payment of self assessment tax for A Y 2025-2026
- REGARDING ITR FILING QUESTION
- Requirement under FEMA &RBI
- DUE DATE FOR ITR FILING
- ITC BENEFIT ON BROKRAGE PAID
- Correction in TDS return New Traces Portal
- Sale of Mutual Funds In Diffirent Financial Years
- Gst reverse charge mechanism to be claimed in the month of payment
- TDS NOT YET CREDIED
- GST REGISTRATION REQUIRED TO DIAGNOSTIC UNIT
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
- EXPORT PAYMENT
- NRI ITR2 account in 2025-26.
- Query regarding reporting of exempt foreign remuneration in ITR (AY 2026-27)
- FEMA/RBI treatment — Amazon.ca arbitrage (US buy, Canada sell, goods never enter India)
- Goods return by customer
- INWARD REMITTANCE FOREIGN
- CPC and SAC
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
