26TALLYReports

Year-End Process in Tally Prime

Closing FY 2025-26, splitting data, carrying forward balances, and Sunrise Retail's year-end checklist

Module 26 of 31 — Tally Prime. Close FY 2025-26 for Sunrise Retail Pvt Ltd, carry forward all balances to FY 2026-27, split the company data file, and execute the year-end closing journal entries. Duration: 45 min.

Learning Objectives

  • Understand Tally's automatic year-end carry-forward (no manual closure required)
  • Execute the year-end checklist for Sunrise Retail (March 31, 2026)
  • Enter closing journal entries (depreciation, provisions, accruals)
  • Split company data at March 31, 2026

Prerequisites: Final Accounts and Reports — tally-23


Tally's Year-End — What You Don't Need to Do

One of Tally's most important features: you do not need to manually close the financial year. Tally is a perpetual system.

What Tally Does AutomaticallyHow It Appears
All ledger balances carry forwardOpen Balance Sheet on Apr 1, 2026 — all balances intact
Net Profit/Loss transfers to ReservesP&L balance appears under "Profit & Loss A/c" in Equity
Closing stock on Mar 31 → Opening stock on Apr 1Stock value carries forward as opening stock value
Sundry debtors/creditors carry with bill-wise detailOutstanding reports show the same invoices in the new year

You simply start entering FY 2026-27 vouchers with April 1, 2026 dates.


What You Must Do Before Year-End

The human work that Tally cannot automate:

Year-End Preparation Checklist — Sunrise Retail (31-Mar-2026)
═══════════════════════════════════════════════════════════════
ACCOUNTS
  [ ] All March sales invoices entered
  [ ] All March purchase invoices entered
  [ ] All credit notes and debit notes entered
  [ ] March salary processed (Payroll Voucher — 31-Mar-2026)
  [ ] Bank reconciliation for March completed

OUTSTANDING MANAGEMENT
  [ ] All suppliers — confirm outstanding or settle before Mar 31
  [ ] All customers — send reminders; acknowledge confirmed outstandings

GST COMPLIANCE
  [ ] GSTR-1 for March filed (deadline: April 11, 2026)
  [ ] GSTR-3B for March filed + tax paid (deadline: April 20, 2026)
  [ ] GSTR-9 (annual return) filed if applicable (December 31, 2026)

YEAR-END ACCOUNTING ENTRIES (enter before or just after Mar 31)
  [ ] Full-year depreciation calculated and entered
  [ ] Provision for gratuity / leave encashment (if applicable)
  [ ] Prepaid expenses adjusted
  [ ] Accrued income and accrued expenses entered
  [ ] Fixed assets register reconciled

CLOSURE
  [ ] Trial balance checked — Difference: ₹0
  [ ] Final Balance Sheet and P&L printed and signed by directors
  [ ] Complete Tally backup taken (Ctrl+Alt+B) — label: FY2526_Final
  [ ] Split company data (optional — see below)
═══════════════════════════════════════════════════════════════

Year-End Closing Journal Entries

These entries must be passed before the final accounts are presented. Path:

F7 (Journal) → Date: 31-Mar-2026

1. Full-Year Depreciation

Sunrise Retail assets purchased April 1, 2025 — depreciation for 12 months:

F7 → Journal
Date: 31-Mar-2026
Narration: Depreciation for FY 2025-26

Dr: Depreciation on Furniture & Fixtures   ₹15,000
Dr: Depreciation on Computer & Equipment   ₹32,000
  Cr: Furniture & Fixtures                 ₹15,000
  Cr: Computer & Equipment                 ₹32,000
→ Ctrl+A

(Furniture: ₹1,50,000 × 10% SLM = ₹15,000/year; Computer: ₹80,000 × 40% SLM = ₹32,000/year — Companies Act Schedule II rates)

2. Provision for Outstanding Salary (if March salary not yet paid)

Dr: Salaries — March                       ₹1,50,000
  Cr: Salary Payable (Current Liabilities) ₹1,50,000
Narration: March 2026 salary accrual — payable April 2, 2026
→ Ctrl+A

3. Prepaid Expense Adjustment (if rent paid in advance)

Dr: Prepaid Rent (Current Assets)          ₹30,000
  Cr: Office Rent                          ₹30,000
Narration: April 2026 rent paid in advance — defer to next year
→ Ctrl+A

4. P&L Appropriation

Tally handles this automatically in the Balance Sheet. If needed manually:

Dr: Profit & Loss A/c (current year profit)
  Cr: Profit & Loss A/c Balance (Reserves)
(Only needed if you want to explicitly show appropriation — Tally does this implicitly)

Splitting Company Data

Splitting creates two separate Tally company files: a historical archive and a fresh active file.

When to split:

  • After 2–3 years of data accumulation (file grows large, Tally slows down)
  • When you want a clean separation between FY archives
  • Never split before all year-end adjustments and returns are finalised

How to split:

Gateway → Company → Split Company Data
→ Select: Sunrise Retail Pvt Ltd
→ Split at: 01-Apr-2026

Tally creates two companies:
  "Sunrise Retail Pvt Ltd (Till 31-Mar-2026)"  ← archived FY 2025-26
  "Sunrise Retail Pvt Ltd (From 01-Apr-2026)"  ← active FY 2026-27

What carries forward to the new company automatically:

ItemCarries Forward?
All ledger balances (assets, liabilities)Yes
Net Profit → Profit & Loss Balance A/cYes (shown in Equity)
Closing stock → Opening stockYes (same value, same rate)
Sundry Debtors with bill-wise detailsYes
Sundry Creditors with bill-wise detailsYes
Masters (ledgers, stock items, pay heads)Yes
Vouchers from old yearNo (stay in the archive file)

Year-End Q&A Flow

Sneha's year-end decision tree:

  Is it after March 31, 2026?

  ├── All GST returns filed?
  │   └── No → File GSTR-1, GSTR-3B first

  ├── All year-end entries passed?
  │   └── No → Enter depreciation, provisions, accruals

  ├── Trial Balance difference = ₹0?
  │   └── No → Find and fix the discrepancy

  ├── Backup taken? (FY2526_Final.tbk)
  │   └── No → Ctrl+Alt+B NOW

  └── Split needed now?
      ├── Yes (>2 years data or performance slow)
      │   └── Gateway → Company → Split Company Data → 01-Apr-2026
      └── No (data size small, audit still in progress)
          └── Continue with the same company file
              (new FY vouchers go in with 2026 dates — Tally handles it)

Sunrise Retail Year-End Financial Summary (FY 2025-26 Projection)

Based on April 2025 run-rate (₹8,90,000/month net sales):

MetricFY 2025-26 Estimate
Annual Revenue~₹1,07,00,000
Annual Gross Profit (26%)~₹27,80,000
Operating Expenses~₹22,00,000
Annual Net Profit~₹5,80,000
Closing Stock (Mar 31)~₹12,00,000
Net Debtors~₹8,00,000
Net Creditors~₹6,00,000
Total ITC Carry Forward~₹2,50,000

Electronics trading margin: ~26% gross, ~5% net on stabilised monthly run-rate.


Practice Exercise

Exercise: Why might Sneha choose NOT to split company data immediately after March 31?

Show Solution

Reasons to delay splitting:

  1. Pending year-end adjustments: The CA typically takes 1–3 months after year-end to finalise depreciation, provisions, and audit entries. Splitting before these are entered means adjustments must go into the archive file, which gets confusing.

  2. GSTR-9 filing: The annual GST return is due by December 31, 2026. Any GST adjustments (ITC reconciliation, amendments) need to be in the FY 2025-26 data file. Splitting prematurely makes this harder.

  3. Tax audit in progress: Auditors working on FY 2025-26 prefer the full year in a single file for easier navigation.

  4. Outstanding bills: March bills being settled in April/May are cleaner to manage in the same company file.

Best practice: Split 3–4 months after year-end — July or August 2026 — once GSTR-9 adjustments are done and audit is complete.


Key Terms

TermMeaning
Year-EndMarch 31 — last day of the Indian financial year
Carry ForwardTally's automatic transfer of all ledger balances to the next period
Split Company DataSeparates the Tally file into two at a cutoff date
P&L AppropriationTransfer of net profit to Reserves — happens automatically in Tally's Balance Sheet
Closing EntriesJournal entries for depreciation, provisions, and accruals at year-end
ProvisionsEstimated future liabilities set aside at year-end (gratuity, bad debts)

Module Summary

  • Tally is perpetual — just start entering April 1, 2026 vouchers; balances carry forward automatically
  • Year-end checklist: all vouchers entered, bank reconciled, GST returns filed, backup taken
  • Closing entries: depreciation (F7 on Mar 31), provisions, accruals — must be entered before final accounts
  • Split company data: optional; recommended after 2–3 years; best done 3–4 months post year-end
  • Net profit of FY 2025-26 flows into "Profit & Loss Balance A/c" in Equity in the new year

Quick Quiz

1. To start FY 2026-27 in Tally, Sneha must:

  • a) Run the "Year End Closing" wizard
  • b) Create a new company file for FY 2026-27
  • c) Simply start entering vouchers with April 1, 2026 dates
  • d) Enter a closing entry: Dr P&L A/c, Cr Capital
Answer

c) Simply start entering April 1, 2026 vouchers — Tally handles year-end automatically. No closing entry, no new file, no wizard. The perpetual system carries all balances forward.

2. After splitting company data at April 1, 2026, the opening stock in the new company file is:

  • a) Zero — stock must be re-entered manually
  • b) Carried from March 31, 2026 closing stock automatically
  • c) Entered via Physical Stock Voucher
  • d) Copied from last year's purchase invoices
Answer

b) Carried automatically from March 31, 2026 — the Split function preserves all asset and liability balances at the cutoff date as opening balances in the new company, including stock at its closing value.