GST Reconciliation Dashboard - GST With Nitesh

GST Reconciliation Dashboard

GST With Nitesh

📖 Dashboard Kaise Use Karein? Click Karein! 👆

📚 Dashboard Kaise Use Karein

1

Dashboard Mein 2 Tabs Hain

Tab 1: "3B vs Books" - GSTR-3B aur Books ke data ko compare karne ke liye

Tab 2: "3B vs GSTR-1" - GSTR-3B aur GSTR-1 ke data ko compare karne ke liye

Jo tab chahiye usko click karein!

2

Data Kaise Enter Karein (2 Tarike)

Tarika 1: CSV File Upload Karein

  • Apne Excel data ko CSV format mein save karein
  • "Upload Data Files" section mein appropriate file chooser par click karein
  • Apni CSV file select karein
  • Data automatically tables mein aa jayega!
CSV File Format Example:
Month,Taxable,CGST,SGST,IGST
APR,100000,9000,9000,0
MAY,120000,10800,10800,0

Tarika 2: Manual Entry

  • Kisi bhi white cell (input field) par click karein
  • Seedhe numbers type karein
  • Enter dabayein ya next field par jayein
3

Color Coding Samjhein

  • White Cells - Input fields (aap yahan data enter karenge)
  • Gray Cells - Auto-calculated (automatic calculate hoga)
  • Green Cells - Match (data match kar raha hai ✓)
  • Red Cells - Mismatch (difference hai, check karein!)
4

Automatic Calculations

Jaise hi aap data enter karenge, ye sab automatic calculate ho jayenge:

  • Total Column - CGST + SGST + IGST ka sum
  • Difference Tables - Do datasets ke beech ka difference
  • Match/Mismatch Highlighting - Jahan difference hai wahan red, jahan match hai wahan green
5

Tab 1: "3B vs Books" Mein Kya Hai

Is tab mein aap ye compare kar sakte hain:

  • GSTR-3B Liability vs Books Liability
  • 3B ITC vs 2A ITC
  • Books ITC vs 3B ITC
  • Books ITC vs 2A ITC

Har comparison ke liye difference table automatically banta hai!

6

Tab 2: "3B vs GSTR-1" Mein Kya Hai

Is tab mein aap compare kar sakte hain:

  • GSTR-3B Liability
  • GSTR-1 Summary
  • Dono ke beech ka Difference
7

Print / PDF Kaise Banayein

Bottom mein "🖨️ Print / Save PDF" button par click karein:

  • Print dialog khul jayega
  • Destination mein "Save as PDF" select karein
  • PDF save kar lijiye!
8

WhatsApp Par Share Karein

"📱 Share on WhatsApp" button par click karein aur apne contacts ke saath share karein!

💡 Pro Tips:

• Mobile par bhi perfect kaam karta hai - tables scroll kar sakte hain
• Data loss nahi hota - browser refresh karne par bhi data rehta hai
• Red cells par focus karein - wahan reconciliation ki zaroorat hai
�� Sabhi months ka data ek saath dekh sakte hain (APR to MAR)

📥 Upload Data Files (CSV Format)

⚠️ Pehle CSV Template Download Karein: Neeche diye gaye buttons se templates download karein, apna data fill karein, aur yahan upload karein.

GSTR-3B Liability

Month Taxable CGST SGST IGST Total

Books Liability

Month Taxable CGST SGST IGST Total

Difference: Books Liability vs 3B

Month Taxable CGST SGST IGST Total

2A ITC (Net of credit note)

Month CGST SGST IGST Total

3B ITC (Net of reversal)

Month CGST SGST IGST Total

Books ITC (Net ITC as per books)

Month CGST SGST IGST Total

Difference: 3B ITC vs 2A ITC

Month CGST SGST IGST Total

Difference: Books ITC vs 3B ITC

Month CGST SGST IGST Total

Difference: Books ITC vs 2A ITC

Month CGST SGST IGST Total

📥 Upload Data Files (CSV Format)

⚠️ Pehle CSV Template Download Karein: Neeche diye gaye button se template download karein, apna data fill karein, aur yahan upload karein.

GSTR-3B Liability

Month Taxable CGST SGST IGST Total

GSTR-1 Summary

Month Taxable CGST SGST IGST Total

Difference: GSTR-1 vs GSTR-3B

Month Taxable CGST SGST IGST Total