Financial Year-End Closing Checklist (Excel)
Last updated: 27 June 2026
To close your books for the Indian financial year (1 April–31 March), work through eleven areas in sequence: bank reconciliation, debtors/creditors, inventory, fixed assets, accruals, GST, TDS, adjusting entries, nominal account closure, final statements, and statutory deadlines. Miss any one area and your P&L or tax liability will be wrong.
Key takeaways
- The Indian financial year ends on 31 March; closing work happens in April, but deadlines run through October–November.
- Bank reconciliation and debtors/creditors ageing must be done as at the exact date of 31 March, not an approximation.
- Section 43B(h) of the Income Tax Act disallows amounts payable to Micro/Small Udyam-registered suppliers if unpaid beyond 15/45 days at 31 March.
- GST slabs in effect from 22 September 2025 are Nil / 5% / 18% / 40% — the 12% and 28% slabs have been abolished.
- Companies must prepare financial statements in Schedule III format and file AOC-4 and MGT-7 with the MCA after the AGM.
- A physical stock count as at or close to 31 March is mandatory for accurate COGS and balance sheet presentation.
- Run an adjusted trial balance after all journal entries before generating final statements.
What does year-end closing actually mean?
Year-end closing (also called "accounts closing" or "book closure") is the process of finalising all transactions for the year, passing adjusting entries, transferring income and expense balances to the Profit and Loss account, and producing auditable financial statements. For Indian businesses, this happens once a year after 31 March.
Closing is not just a formality. It ensures:
- Your tax liability is correctly computed.
- Statutory filings (ITR, audit report, MCA forms) are based on accurate numbers.
- The new year starts with clean opening balances.
The complete closing checklist
Work through the sections in order. Tick each step only after completing the corresponding Excel action.
Section 1: Bank and cash reconciliation
| Step | Task | Excel Action | Done ✓ |
|---|---|---|---|
| 1.1 | Reconcile each bank account (cash book bank column vs bank statement) as at 31 March | On your bank reconciliation sheet, paste the closing bank statement balance and tick off all matching entries | ☐ |
| 1.2 | Reconcile petty cash (float + vouchers must equal opening float) | Total vouchers in your petty cash log; difference = unrecorded expense | ☐ |
| 1.3 | Identify bank charges, interest credits, and dishonoured cheques not yet in books | Add a column for "unrecorded items"; pass journal entries for each | ☐ |
Section 2: Debtors and creditors verification
| Step | Task | Excel Action | Done ✓ |
|---|---|---|---|
| 2.1 | Print ageing report of all trade debtors; match each balance against invoices | Use SUMIFS to bucket outstanding invoices into 0–30, 31–60, 61–90, 90+ day columns | ☐ |
| 2.2 | Identify bad debts and doubtful debtors; pass provision entry | Debit Bad Debts A/c / Provision for Doubtful Debts A/c, Credit Debtors | ☐ |
| 2.3 | Print ageing report of trade creditors; verify MSME payment compliance (see Fact box 1) | Filter creditors by Udyam registration status; flag any balance outstanding beyond 45 days | ☐ |
| 2.4 | Send balance confirmation letters to major debtors and creditors | Best practice: email a statement and request written confirmation | ☐ |
Fact box. Section 43B(h) of the Income Tax Act — amounts payable to Micro or Small Udyam-registered suppliers (non-traders) that remain unpaid at 31 March are disallowed as a deduction for that year if the payment exceeded 15 days (where no written agreement exists) or 45 days (where a written agreement specifies the credit period). The disallowance reverses only when the payment is actually made. Check every creditor's Udyam certificate before finalising your creditors list.
Section 3: Inventory
| Step | Task | Excel Action | Done ✓ |
|---|---|---|---|
| 3.1 | Conduct physical stock count as at 31 March (or as close to it as possible) | Use a stock count sheet with columns: Item, Unit, Book Qty, Physical Qty, Difference | ☐ |
| 3.2 | Reconcile book stock vs physical count; investigate significant variances | Highlight variances in red; pass shortage/excess entry with narration | ☐ |
| 3.3 | Write off obsolete or damaged stock with proper narration | Debit Loss on Write-off A/c, Credit Stock A/c | ☐ |
| 3.4 | Confirm closing stock figure for balance sheet and COGS calculation | Formula: Opening Stock + Purchases − Closing Stock = Cost of Goods Sold | ☐ |
Section 4: Fixed assets and depreciation
| Step | Task | Excel Action | Done ✓ |
|---|---|---|---|
| 4.1 | Update the fixed asset register for FY additions and disposals | Add rows for new assets; mark disposed assets and calculate days held | ☐ |
| 4.2 | Compute depreciation — IT Act (WDV rates) and Companies Act (Schedule II) if applicable | Use your depreciation calculator with separate columns for each basis | ☐ |
| 4.3 | Pass the depreciation journal entry | Debit Depreciation A/c, Credit Accumulated Depreciation A/c | ☐ |
| 4.4 | For disposals: derecognise the asset and compute capital gain or loss | Remove cost + accumulated depreciation; difference vs. sale proceeds = gain/loss | ☐ |
Section 5: Accruals and prepayments
| Step | Task | Excel Action | Done ✓ |
|---|---|---|---|
| 5.1 | Accrue salary payable for March (if March salary is paid in April) | Debit Salary A/c, Credit Salary Payable A/c | ☐ |
| 5.2 | Accrue audit fee, professional fees, and other year-end costs | Debit respective expense A/c, Credit Accrued Liabilities A/c | ☐ |
| 5.3 | Identify prepaid expenses (insurance, advance rent) | Calculate unexpired portion; Debit Prepaid Expense A/c, Credit Expense A/c | ☐ |
| 5.4 | Adjust deferred revenue (advances received but not yet earned) | Debit Revenue A/c, Credit Deferred Revenue A/c for unearned portion | ☐ |
Section 6: GST reconciliation
| Step | Task | Excel Action | Done ✓ |
|---|---|---|---|
| 6.1 | Reconcile GSTR-1 (sales reported) with sales as per books | SUMIF sales by rate (Nil / 5% / 18% / 40%); compare to GSTR-1 table | ☐ |
| 6.2 | Reconcile GSTR-2B (ITC available) with ITC claimed in books; reverse any excess | Highlight excess ITC rows; pass reversal entry | ☐ |
| 6.3 | Verify GST payable account balance matches the last GSTR-3B filed | Closing balance in GST Payable ledger should be nil or match the March liability | ☐ |
Section 7: TDS reconciliation
| Step | Task | Excel Action | Done ✓ |
|---|---|---|---|
| 7.1 | Verify TDS deducted and deposited for the full year against Form 26AS | Pull 26AS data; match month-by-month against your TDS payable ledger | ☐ |
| 7.2 | Ensure Q4 TDS return (Form 26Q) is filed; due date is 31 May 2026 | Confirm acknowledgement number and update your compliance tracker | ☐ |
| 7.3 | Verify advance tax: final instalment was due 15 March; shortfall attracts Section 234B/234C interest | Compare actual advance tax paid to estimated liability; compute interest if any | ☐ |
Section 8: Adjusting journal entries
| Step | Task | Excel Action | Done ✓ |
|---|---|---|---|
| 8.1 | Pass all accrual, prepayment, depreciation, and provision entries | Enter each in your journal with date 31 March and clear narration | ☐ |
| 8.2 | Run the adjusted trial balance after all entries | Pivot or SUMIFS by account code; debits must equal credits | ☐ |
Section 9: Close nominal accounts
| Step | Task | Excel Action | Done ✓ |
|---|---|---|---|
| 9.1 | Transfer all income and expense account balances to the P&L summary / Profit and Loss A/c | Closing entry: Debit each income A/c, Credit P&L A/c; Debit P&L A/c, Credit each expense A/c | ☐ |
| 9.2 | Transfer net profit (or loss) to Retained Earnings (companies) or Partner's Capital (firms/LLPs) | Debit P&L A/c, Credit Retained Earnings / Capital A/c | ☐ |
| 9.3 | Reset all income and expense account balances to zero for the new year | Verify opening balances for 1 April show nil in all nominal accounts | ☐ |
Section 10: Prepare final statements
| Step | Task | Excel Action | Done ✓ |
|---|---|---|---|
| 10.1 | Generate the P&L statement for FY 2025-26 | Pull from adjusted trial balance; group into gross profit, operating profit, net profit | ☐ |
| 10.2 | Generate the Balance Sheet as at 31 March 2026 | Assets must equal Liabilities + Equity | ☐ |
| 10.3 | Companies: format statements per Schedule III; send to statutory auditor | Cross-check all Schedule III line items; attach notes to accounts | ☐ |
| 10.4 | Sole proprietors/partnerships: prepare statements to support tax audit if triggered (turnover > ₹1 crore for business — ₹10 crore if 95%+ digital — or > ₹50 lakh for profession) | Keep supporting workbooks for each schedule | ☐ |
Section 11: Statutory deadlines — FY 2025-26
Fact box. Key statutory deadlines for FY 2025-26: Tax audit report (Form 3CA/3CB-3CD) — 30 September 2026. ITR for audit cases (ITR-3/5/6) — 31 October 2026. ITR for non-audit cases — 31 July 2026. AOC-4 (financial statements to MCA) — within 30 days of AGM, approximately 30 October 2026. MGT-7 (annual return to MCA) — within 60 days of AGM, approximately 29 November 2026. Mark all five in your compliance calendar now.
| Deadline | Form / Filing | Who | Due Date |
|---|---|---|---|
| Tax audit report | Form 3CA / 3CB-3CD | Businesses/professionals above audit threshold | 30 Sep 2026 |
| Income tax return (audit cases) | ITR-3 / ITR-5 / ITR-6 | Proprietors, firms, companies requiring audit | 31 Oct 2026 |
| Income tax return (non-audit) | ITR-1 / ITR-3 / ITR-4 | Individuals, small proprietors | 31 Jul 2026 |
| Financial statements to MCA | AOC-4 | All registered companies | ~30 Oct 2026 (30 days after AGM) |
| Annual return to MCA | MGT-7 | All registered companies | ~29 Nov 2026 (60 days after AGM) |
| Q4 TDS return | Form 26Q | All TDS deductors | 31 May 2026 |
Frequently asked questions
When does the Indian financial year close? The Indian financial year runs from 1 April to 31 March. The books close on 31 March — this is the balance sheet date. Actual closing work (reconciliations, adjustments, audit) is done in April and the months that follow, with statutory filings due between July and November.
Can I complete closing procedures after 31 March? Yes, and in practice almost all businesses do. The balance sheet date is 31 March, but journal entries, reconciliations, and audit fieldwork are completed after that date. What matters is that all transactions are dated on or before 31 March in the books — backdating entries after filing is not permitted.
Do sole proprietors need to formally close accounts? There is no Companies Act requirement for sole proprietors, but closing accounts properly is essential for accurate ITR filing and, if the tax audit threshold is crossed, for the statutory audit. A clean closing also gives the proprietor a reliable picture of business performance and net worth.
What is the penalty for late filing of the tax audit report? Under Section 271B of the Income Tax Act, the penalty for failure to get accounts audited or furnish the audit report by the due date is 0.5% of total sales/turnover, subject to a maximum of ₹1.5 lakh. The due date for FY 2025-26 is 30 September 2026.
What happens if I miss the MSME payment deadline under Section 43B(h)? The amount payable to the Micro or Small Udyam-registered supplier is disallowed as a business deduction in the year of default. It becomes deductible only in the year the payment is actually made. There is no direct MSMED Act penalty administered through the income tax return, but the disallowance increases taxable income for that year.
Do I need to reconcile GST every year even if I file returns regularly? Yes. Monthly GSTR-3B filings are provisional; GSTR-1 and GSTR-2B are the authoritative records. Year-end reconciliation catches mismatches that accumulate over twelve months — excess ITC claimed, sales underreported in GSTR-1, or rate differences — before they become the basis for a GST audit or notice.
Sources and disclaimer
Sources consulted: Income Tax Act 1961 (Section 43B, 234B, 234C, 271B); MSMED Act 2006 as amended; GST Council notifications (rate changes effective 22 September 2025); Companies Act 2013 (Schedule III, Schedule II); MCA filing deadlines for FY 2025-26; CBDT circular on TDS return due dates.
Disclaimer: This article is for general information only and does not constitute legal, tax, or accounting advice. Statutory deadlines, thresholds, and disallowance rules can change; always verify current provisions with a qualified Chartered Accountant or tax advisor before filing.
How Ankeshan helps
Ankeshan's Excel-based accounting workbooks include a pre-built year-end checklist tracker, bank reconciliation sheet, fixed asset register with WDV depreciation, and a GST reconciliation template — all linked so that ticking off each step automatically updates your closing trial balance. If you want early access, join the waitlist at ankeshan.com/waitlist.