Balaji NextGen ERP — GST Module v1.0

GST Dashboard

Demo Trading Pvt Ltd · GSTIN: GST-DEMO-001 · FY 2025-26

ℹ️ Client Active: Demo Trading Pvt Ltd (GST-DEMO-001) — FY 2025-26 data loaded. GSTR-1 & GSTR-3B filed for Apr–Nov. Dec–Mar pending.

🏷️

Total Turnover (GSTR1)

₹7.26 Cr

Taxable: ₹72,567,686

✅

ITC as per 2B

₹59.72 L

Claimed: ₹59,72,237

💸

Tax Liability (3B)

₹56.64 L

GSTR-3B Output Tax

⚠️

ITC Mismatch

₹930.5

2B vs Books Difference

Return Filing Status — FY 2025-26 View 3B →

Monthly Turnover vs ITC GSTR-1 →

Annual Summary — GSTR-9 Preview Full GSTR-9 →

Particulars	IGST (₹)	CGST (₹)	SGST (₹)	Total Tax (₹)	Books (₹)	Diff (₹)

Monthwise Purchase vs Sales (Taxable Value) Full Report →

Month	Purchase (Portal)	Sales (GSTR-1)	Input Tax (ITC)	Output Tax (3B)	Net Tax	Status

Client Manager

Private — GST credentials visible only to admin. Do not share individual client files.

🔒 Privacy Notice: Client GSTIN, credentials and data are private. Do NOT share individual client files with others. Click a client to load their data only in this session.

Upload GST Portal 2B Data

Upload GSTR-2B JSON or Excel from GST Portal

Select Month & Upload

Client

Month

📥

Drop GSTR-2B JSON / Excel here

or click to browse — supports .json .xlsx .csv

Upload Status

📋

No file uploaded yet

Upload GSTR-2B data from GST Portal

Current 2B Data Preview — DR Merchandise (Apr–Nov 2025) Full View →

Month	GSTIN	Supplier Name	Invoice No.	Date	Taxable (₹)	IGST (₹)	CGST (₹)	SGST (₹)	Type

Upload Books ITC Data

Upload purchase register / ITC data from accounting books

Books ITC Upload

Client

Month

📖

Drop Books ITC Excel here

or click to browse — supports .xlsx .csv

Upload Status

📖

No file uploaded yet

Upload Sales Register

Upload outward supply / sales data for GSTR-1

Sales Register Upload

Client

Month

📤

Drop Sales Register Excel here

Columns: Invoice No, Date, Party GSTIN, Taxable, IGST, CGST, SGST

Column Mapping

Invoice Number Column

GSTIN Column

Taxable Value Column

Tax Columns

GSTR-1 — Outward Supply

Auto-calculated from Sales Register · GSTIN: GST-DEMO-001

B2B Invoices

B2CS (Unregistered)

HSN Summary

Credit/Debit Notes

B2B Taxable

₹0

Total IGST

₹0

Total CGST

₹0

Total SGST

₹0

B2B — Registered Supplier Invoices Download JSON ⬇

Month	GSTIN	Name	Invoice No.	Type	Date	Invoice Value	Taxable	IGST	CGST	SGST

Month	Type	Place of Supply	Taxable	IGST	CGST	SGST
Apr–Nov 2025	B2C Large	West Bengal	29,553,149	4,578	737,478	737,478

GSTR-2B — Input Tax Credit

Auto-populated from GST Portal · FY 2025-26

Total ITC (Portal)

₹59,72,237

ITC Claimed (3B)

₹59,72,237

ITC as per Books

₹59,69,369

Difference

₹2,868

GSTR-2B — Portal ITC Data Reconcile with Books →

Month	Supplier GSTIN	Supplier Name	Invoice No.	Date	Taxable (₹)	IGST	CGST	SGST	Remarks

GSTR-3B — Monthly Summary Return

Auto-calculated summary · FY 2025-26

3.1 — Outward Supplies

Nature	Taxable (₹)	IGST	CGST	SGST

4 — Eligible ITC

ITC Type	IGST	CGST	SGST

5.1 — Interest & Late Fee | 6 — Payment of Tax

Description	IGST	CGST	SGST
Tax Payable	—	—	—
Tax Paid via ITC	—	—	—
Net Payable (Cash)	—	—	—

✅ GSTR-3B data auto-calculated. Review and click Generate JSON to download for portal upload.

2B vs Books Reconciliation

Identify mismatches between GST Portal 2B and Accounting Books

Matched Invoices

—

Portal = Books

In 2B Only

0

Not in Books

In Books Only

1

Not in Portal

Amount Difference

₹930.5

ITC Mismatch

All Records

Mismatches Only

In 2B Only

In Books Only

Reconciliation Report — Portal vs Books

Supplier	GSTIN	Invoice	Month	2B Taxable	Books Taxable	2B Tax	Books Tax	Diff	Status

Supplier	GSTIN	Invoice	Issue	Diff (₹)	Action
Demo Supplier One	GST-DEMO-001	PH/4106/25-26	Date Mismatch	930.50

Supplier	GSTIN	Invoice	Date	Taxable	ITC
Demo Supplier One	GST-DEMO-001	PH/4106/25-26	Apr 2025	5,169.49	930.50

GSTR-9 — Annual Return

Auto-compiled annual data · FY 2025-26 · Demo Trading Pvt Ltd

✅ GSTR-9 data auto-populated from GSTR-1, GSTR-3B and 2B records filed throughout the year. Review each table before filing.

Table 4 — Turnover

Table 5 — Non-Tax

Table 6 — ITC

Table 7 — ITC Reversed

Table 8 — ITC Info

Table 9 — Tax Paid

Table 4 — Details of Turnover & Tax Liability Declared

Sl	Nature of Supplies	Taxable (₹)	IGST (₹)	CGST (₹)	SGST (₹)	Total Tax (₹)	Books Tax (₹)	Diff (₹)
4A	B2C Sale (Unregistered)	2,95,53,149	4,578	7,37,478	7,37,478	14,79,534	14,79,534	0
4B	B2B Sale (Registered)	4,30,14,537	7,65,623	15,00,900	10,39,007	33,05,529	21,70,434	11,35,095
4K	B2B Credit Note (Registered)	0	0	0	0	0	0	0
4G	RCM Supplies	1,40,675	7,034	0	0	7,034	7,034	0
	Total Turnover with RCM	7,27,08,362	7,77,234	22,38,378	17,76,485	47,92,098	36,57,003	11,35,095

Sl	Nature	Turnover (₹)
5C	Zero Rated Export	0
5D	Exempt Supplies	0
5E	Nil Rated Supplies	0
5F	Non-GST Supplies	0
	Total Non-Tax Turnover	0

Sl	Details	IGST	CGST	SGST	Total
6A	ITC Availed (Claimed) in GSTR-3B / 2B	74,919	29,52,176	29,52,176	59,79,270
6A1	ITC of Preceding Year in Current Year	0	0	0	0
6A2	Net ITC for the Year	74,919	29,52,176	29,52,176	59,79,270
	ITC on Goods (Inputs)	67,886	29,49,101	29,49,101	59,66,088
	ITC on Capital Goods	0	2,593	2,593	5,186
	ITC on Input Services	0	481	481	962
6C	RCM ITC Claimed	7,034	0	0	7,034
6O	Total ITC Availed	74,919	29,52,176	29,52,176	59,79,270

Details	IGST	CGST	SGST	Total
ITC Reversed (Demo Supplier One mismatch)	0	465	465	930
Net ITC Available for Utilization	74,919	29,52,641	29,52,641	59,80,201

Sl	Details	IGST	CGST	SGST	Total
8A	ITC as per GSTR-2B (Table 3I)	67,886	29,52,176	29,52,176	59,72,237
8B	ITC as per Sum Total of 6B	67,886	29,52,641	29,52,641	59,73,167
8C	ITC of Previous Year	0	0	0	0
8E	ITC Available but Not Availed	0	465	465	930
8F	ITC Available but Ineligible	0	0	0	0
8K	ITC Lapsed in Current Year	0	0	0	0

Description	IGST	CGST	SGST	Total
Tax Payable	7,77,234	22,38,378	17,76,485	47,92,098
Paid via Cash Ledger	7,034	0	0	7,034
Opening Credit Ledger	0	67,448	9,716	77,164
ITC Accrued (Inputs)	74,920	29,51,711	29,51,711	59,78,342
Paid via ITC	74,920	29,11,116	26,77,729	56,63,765
ITC Refund	0	0	0	0
Closing Credit Ledger	0	1,08,043	2,83,698	3,91,741

GSTR-9C — Reconciliation Statement

Turnover & ITC Reconciliation (Books vs Portal) · FY 2025-26

⚠️ GSTR-9C requires CA certification before filing. This report auto-calculates differences. Total unreconciled difference: ₹11,35,095 in B2B Tax (likely rate difference — review with CA).

Part A — Reconciliation of Turnover

Particulars	₹
Turnover as per Audited Accounts	7,25,67,687
Turnover as per GSTR-1	7,25,67,687
Un-reconciled Turnover (A1)	0
Reasons for un-reconciled turnover	—
Net Payable / (Refundable)	0

Part B — ITC Reconciliation

Particulars	₹
ITC Availed as per Books	59,69,369
ITC Availed as per GSTR-3B	59,72,237
Difference (Books vs 3B)	2,868
ITC Available but not Availed	930
Net ITC Difference	3,798

Annual GST Report

Comprehensive FY 2025-26 Analysis — Demo Trading Pvt Ltd

Total Turnover

₹7.26 Cr

FY 2025-26

Total ITC

₹59.72 L

2B Eligible

Tax Paid

₹56.64 L

Via ITC + Cash

Closing ITC Balance

₹3.92 L

Credit Ledger

Monthwise Summary — Purchase vs Sales (Full Year)

Month	Purchase (₹)	Sales (₹)	ITC (₹)	Output Tax (₹)	Net Tax (₹)	GSTR-3B	GSTR-1
TOTAL	10,20,51,974	7,25,67,687	59,72,237	56,63,762	3,08,475	—	—

Supplier-wise ITC Summary (Top 10)

Supplier	Invoices	ITC (₹)

Checklist — Pre-Filing Verification

JSON Export for GST Portal Upload

Generate and download JSON files for direct portal upload

📄

GSTR-1 JSON

Outward Supplies — B2B, B2CS, HSN

📑

GSTR-3B JSON

Monthly Summary Return

📰

GSTR-9 JSON

Annual Return

JSON Preview

Select return type above to preview JSON structure...

ℹ️ Download JSON → Go to GST Portal → File Returns → Upload this JSON file directly.

GST Electronic Ledger

Credit & Cash Ledger movements · FY 2025-26

Opening Balance

₹77,164

ITC Accrued

₹59,78,342

Tax Paid (ITC)

₹56,63,765

Closing Balance

₹3,91,741

GST Credit Ledger — Monthly

Month	Description	IGST (₹)	CGST (₹)	SGST (₹)	Total (₹)	Type