GST-Reconciliation-project

GST Reconciliation project comparing GSTR-1 and GSTR-3B to identify mismatches.

GST Reconciliation Project (January 2026)

📋 Project Overview

This project performs reconciliation between GSTR-1 (sales register) and GSTR-3B (monthly return) for January 2026 using Microsoft Excel.

🎯 Objective

• Identify mismatches between invoice-wise GSTR-1 data and GSTR-3B summary
• Detect discrepancies in tax liability and Input Tax Credit (ITC)
• Create a reusable template for monthly GST compliance

📊 Dataset

• Total Invoices: 25 transactions
• Total Value: ₹8,35,200
• Period: 1st August 2024 to 31st August 2024

🔍 Key Findings

Particulars	GSTR-1	GSTR-3B	Difference
Sales Value	₹8,35,200	₹7,85,000	₹50,200
Tax Amount	₹41,698	₹40,501	₹1,197
ITC	₹7,15,200	₹6,95,000	₹20,200
TOTAL MISMATCH			₹71,597

🛠️ Tools & Techniques Used

• ✅ VLOOKUP - For matching invoices with GSTR-3B data
• ✅ Pivot Tables - For summary analysis
• ✅ Conditional Formatting - To highlight mismatches
• ✅ Data Validation - For reason categorization
• ✅ Charts - For visual representation

📈 Mismatch Analysis

• Sales Value Mismatch: ₹50,200 (70%)
• ITC Mismatch: ₹20,200 (28%)
• Tax Amount Mismatch: ₹1,197 (2%)

🎓 Learning Outcomes

• Hands-on experience with GST reconciliation process
• Advanced Excel functions implementation
• Data analysis and mismatch identification
• Creating reusable templates for business use

📁 Files Included

• GST_Reconciliation_Project.xlsx - Main Excel file with all sheets

🚀 How to Use

1. Download the Excel file
2. Replace sample data with your own invoices
3. Check "Reconciliation" sheet for mismatches
4. Use "Summary" sheet for total figures
5. Refer "Instructions" sheet for detailed guide

📧 Contact

Created by Krati Kulshrestha kratikulshrestha2@gmail.com

• feel free to reach out!

---

⭐ Star this repository if you find it helpful!