Gst Reconciliation With Books Vs Electronic Credit Ledger In Excel
This query is : Resolved
Ashwin Joshi
(Querist)
13 August 2024
PLS PROVIDE ABOVE RECO SHEET IN EXCEL .
12 August 2025
Sure! I can help you create a simple **GST Reconciliation template in Excel** to compare your **Books** vs **Electronic Credit Ledger** (ECL) balances.
Here’s what the reconciliation sheet will include:
---
### GST Reconciliation Excel Sheet: Books vs Electronic Credit Ledger
| **Particulars** | **Books Amount (₹)** | **ECL Amount (₹)** | **Difference (₹)** | **Remarks** |
| ------------------------------- | -------------------- | ------------------ | ------------------ | ----------- |
| Opening Balance | | | | |
| ITC Claimed (Input Credit) | | | | |
| ITC Reversed (Reversals) | | | | |
| ITC Utilized Against Output Tax | | | | |
| ITC Refund Adjusted | | | | |
| Closing Balance | | | | |
| **Total** | | | | |
---
### How to use:
1. Enter figures from your **Books** in the 2nd column.
2. Enter figures from the **Electronic Credit Ledger (ECL)** on GST portal in the 3rd column.
3. The **Difference** column automatically calculates the difference (Books - ECL).
4. Use **Remarks** column to note reasons for differences or action items.
---
### I can create this Excel file for you now.
Would you like me to generate and share the Excel file here? If yes, any additional columns or details you want to include?
Here’s what the reconciliation sheet will include:
---
### GST Reconciliation Excel Sheet: Books vs Electronic Credit Ledger
| **Particulars** | **Books Amount (₹)** | **ECL Amount (₹)** | **Difference (₹)** | **Remarks** |
| ------------------------------- | -------------------- | ------------------ | ------------------ | ----------- |
| Opening Balance | | | | |
| ITC Claimed (Input Credit) | | | | |
| ITC Reversed (Reversals) | | | | |
| ITC Utilized Against Output Tax | | | | |
| ITC Refund Adjusted | | | | |
| Closing Balance | | | | |
| **Total** | | | | |
---
### How to use:
1. Enter figures from your **Books** in the 2nd column.
2. Enter figures from the **Electronic Credit Ledger (ECL)** on GST portal in the 3rd column.
3. The **Difference** column automatically calculates the difference (Books - ECL).
4. Use **Remarks** column to note reasons for differences or action items.
---
### I can create this Excel file for you now.
Would you like me to generate and share the Excel file here? If yes, any additional columns or details you want to include?
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
- Tax on Amount transferred in HUF Account
- Nursery business
- Working on Gold wastage during Melting of old gold jewellery
- GST REFUND ISSUE ON PURCHASE OF PLANT AND MACHINERY
- TDS on Dashcam rent and allied services
- Condonation Request sec 119(2) b -Enhancement Limit of Leave Exemption prior to AY 2023
- Gift to nri relatives residing in usa
- GST input credit on commercial property
- ETDS return q4 25-26
- Section 269ST applicability for capital introduced by partner to his partnership firm
- GSTR-9C filing
- Royalty payments to the Mining Department for procurement of murum - GST input
- HOW TO ADJUST CREDIT NOTE AMOUNT ?
- Import Order Cancelled.
- WRONG GSTR7 ENTRIES ACCEPTED ERRONEOUSLY
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Tally: Imported bank entries do not show up in manual reconciliation
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
