GST Reconciliation Report in Excel

I need a comprehensive reconciliation between GSTR-1 and GSTR-3B prepared in Microsoft Excel for 3–5 business units and up to five individual projects. The workbook should present the data both month-wise and on a consolidated annual basis, with clear segregation by business unit and project so management can instantly spot discrepancies.

Please structure each project sheet to show:
• GSTR-1 liability booked each month and year-to-date
• Declared liability in GSTR-3B for the same periods
• Actual tax payments made, shown month-wise and cumulatively
• ITC details: claimed, utilised, and closing balance
• An “As-on-Date” summary that flags any mismatch between GSTR-1, GSTR-3B, and cash outflow

Use standard Excel functions (pivot tables, SUMIFS, conditional formatting, etc.) so the file stays fully editable—no macros unless absolutely necessary. Where mismatches arise, add a brief note indicating possible reasons (e.g., timing differences, data entry errors) to guide corrective action.

Acceptance criteria
1. One Excel workbook containing:
– A control sheet summarising variance totals for all business units
– Separate tabs for each project with the five data blocks listed above
2. Figures must tie back exactly to my GSTR-1 and GSTR-3B filings for every month of the financial year.
3. Conditional formatting to highlight any variance above ₹1.
4. Delivery within five working days after I provide the raw data dumps (CSV from GST portal).

If you are comfortable reconciling GST returns and can lay out numbers cleanly in Excel, I look forward to handing over the raw files so you can get started right away.