Mahesh Kumar Panjwani & Associates - Chartered Accountants

Step 1 — Upload files

GST File (.csv/.xls/.xlsx)

No file selected

Books File (.csv/.xls/.xlsx)

No file selected

Tip: Supported files — CSV (comma-separated), Excel (.xls/.xlsx). The tool auto-detects headers and will prefill mapping; you must confirm mapping before proceeding.

Step 2 — Map GST file columns

We prefill mappings using heuristics. Please confirm or override.

GSTIN of supplier

Party Name

Pick column that contains party names. You can also type an override value (used where the column is blank) or leave blank to use column values.

Invoice number

Invoice Date

Taxable Value

Invoice Value

Integrated Tax

Central Tax

State/UT tax

Cess

Step 3 — Map Books file columns

Confirm or override prefilled mappings for Books data.

GSTIN of supplier

Party Name

Pick column that contains party names. You can also type an override value (used where the column is blank) or leave blank to use column values.

Invoice number

Invoice Date

Taxable Value

Invoice Value

Integrated Tax

Central Tax

State/UT tax

Cess

Step 4 — Results

Matched

0

In Books but not in GST

0

In GST but not in Books

0

Partial Matches

0

Filter

Category	GSTIN	GST Party	Books Party	GST Inv No	GST Date	Taxable Value	Invoice Value	IGST	CGST	SGST	Cess	Books Inv No	Books Date	Books Taxable	Notes
No rows for this filter.

Save a copy of this app (single-file snapshot) to run offline or share.

Mahesh Kumar Panjwani and Associates

GST ↔ Books Reconciliation — Two-file Mapping (v2)

Step 1 — Upload files

Step 2 — Map GST file columns

Step 3 — Map Books file columns

Step 4 — Results