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
- Refund Annexure-B
- Liable to deduct tds and 44ADA
- Sale of Equity shares for Purchase of Residential Property
- Nomination of Bank for refund in itr 2
- Section 56(2) of the Income tax Act 1961 , Gift to relative .
- ECO SUPPLY REPORTIONG IN GSTR-1
- Is Interest applicable for payment made through credit ledger vide DRC03 for FY 2020-21 & 2021-22
- CCFS 2026 Schemed
- Subscription paid to foreign customer
- Two seprate Invoice needed
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Tds on GST in connection with sale to public company
- Restoration of certificate of practice
- Regarding change in correspondence address in SSP portal
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
