Opening Balances: Moving Last Year's Balance Sheet Into New Software

Title: Opening Balances: Moving Last Year's Balance Sheet Into New Software

Updated for FY 2026-27 (AY 2027-28).

Changing accounting software is easy. Carrying your closing balances across without quietly losing a debtor, a TDS credit or ₹43,000 of unclaimed input tax is the hard part. Most migration problems are not software problems — they are the result of posting one lump-sum opening entry that balances on paper but hides details you will need in September when a client disputes an invoice or your CA asks which assessment year a refund belongs to.

Here is the method, step by step, with the checks that catch errors before they become a year-long nuisance.

Freeze the source before you copy anything

You cannot migrate a moving target. Pick the closing balance sheet as at 31 March 2026 that you actually intend to stand behind — the one your CA used for the return or the audit, not the version you were still editing in May.

Three things to do:

1. Print or export the trial balance as at 31 March 2026 from the old system, with every ledger listed, including those with nil balances if they still have sub-ledger detail.
2. Note the date you took the export and the name of the file. If the old books change later, you need to know what you copied.
3. Lock the old books, or at minimum stop entering into them. Two live sets of books for the same period is the single most expensive mistake in a migration.

If the old "system" is a spreadsheet or a shoebox, the same rule applies: agree the closing figures first, then migrate. Do not try to fix FY 2025-26 inside the new software while also starting FY 2026-27 in it.

Write the opening trial balance on paper before you touch the software

Rewrite the closing balance sheet as a two-column list: every asset and expense-type balance in the debit column, every liability, reserve and capital balance in the credit column. The two totals must agree to the rupee. If they do not, the problem is in your old books, not in the new software, and no amount of clever data entry will fix it.

A typical list for a small services business looks like this:

• Bank accounts, one line per account, matching the bank's 31 March closing statement balance
• Cash in hand and petty cash
• Sundry debtors (total, with a party-wise list behind it)
• TDS receivable, split by assessment year
• GST input credit carried forward and GST payable, separately
• Advance tax and self-assessment tax paid
• Fixed assets at cost, with accumulated depreciation as a separate credit balance
• Loans — party, bank and director/proprietor loans each on their own line
• Sundry creditors (total, with a party-wise list behind it)
• Statutory dues: TDS payable, PF, ESI, professional tax
• Capital account and drawings for a proprietorship; share capital and reserves for a company

Round nothing. If the bank balance is ₹6,42,310.47, enter the paise if your books carry paise, or round consistently and absorb the difference in a single rounding ledger — never silently.

Post one opening journal entry that balances to the rupee

Create a ledger called "Opening balance equity" or use the capital account directly, then post a single dated entry on 1 April 2026. One entry, dated the first day of the year, is far easier to audit than forty separate "opening balance" fields scattered across ledgers.

Worked example. Priya runs a consultancy as a proprietor. Her 31 March 2026 balance sheet, agreed with her CA, carries into FY 2026-27 like this:

The capital figure is not invented — it is the balancing number from last year's signed balance sheet. If your capital account has to be plugged to make the entry balance, stop and find out why. A plug of ₹8,740 is usually an uncleared cheque or a depreciation entry that never got posted.

Break the control accounts into their parts

"Sundry debtors ₹4,80,000" is useless on 12 June when a client asks why you are chasing them. Opening balances must go in party-wise, invoice-wise where possible.

For Priya, the ₹4,80,000 is three invoices:

• Invoice 2025-26/41, Acme Pvt Ltd, ₹2,36,000 (including GST), raised 18 February 2026
• Invoice 2025-26/44, Bluewave LLP, ₹1,77,000, raised 9 March 2026
• Invoice 2025-26/46, Cresta Retail, ₹67,000, raised 27 March 2026

Enter these as opening invoices against each party so that the ageing report works from day one and receipts can be matched to a specific bill. The same applies to creditors: ₹1,12,000 owed is really ₹74,000 to a subcontractor and ₹38,000 to a laptop vendor, with different due dates.

Fixed assets deserve the same treatment. Enter each asset with its date of purchase, cost and accumulated depreciation, not a single "Fixed assets ₹68,000" line. Depreciation for FY 2026-27 and any future capital-gains working both depend on the detail, and reconstructing it three years later is painful.

Mind the balances that carry tax with them

Some opening balances are not just accounting entries — they are claims against the tax department, and burying them in capital means losing real money.

TDS receivable. Priya's ₹1,20,000 relates to AY 2026-27. If the refund lands in her bank in October 2026 and the opening TDS asset was never recorded, the credit will be booked as income and taxed a second time. Keep TDS receivable split by assessment year, and tick off each refund against the year it belongs to.

GST. Input credit carried forward and output liability must be carried separately, never netted into one "GST" ledger, and the input figure should agree with what your GSTR-2B and electronic credit ledger actually show. Credit you believe you have but which never appeared in GSTR-2B is not an asset. More on this in the GST accounting guide.

Advance tax. The opening position tells you what to pay next. Priya expects receipts of ₹48,00,000 in FY 2026-27 and files under section 44ADA, so her presumptive income is 50%, ₹24,00,000. Under the new regime that is ₹20,000 + ₹40,000 + ₹60,000 + ₹80,000 + ₹1,00,000 = ₹3,00,000, plus 4% cess, so ₹3,12,000. Her clients deduct TDS under section 194J at 10% on professional fees, roughly ₹4,80,000 across the year — more than the tax due, so she is heading for a refund rather than an advance-tax payment. Under 44ADA the advance tax, if any, is payable in full by 15 March. Getting this visible in the opening books is the difference between planning cash and being surprised.

Prove it: three checks before you raise the first new invoice

1. Trial balance test. Run the trial balance as at 1 April 2026 in the new software. Debits and credits must agree, and every line must match the old closing balance sheet figure exactly. Compare line by line, not just the total.
2. Bank test. Each bank opening balance must equal the 31 March statement balance plus or minus genuinely uncleared items, listed individually. Then reconcile April's statement; if April reconciles cleanly, the opening bank balance is right. The reconciliation guide covers the mechanics.
3. Sub-ledger test. The debtors control account must equal the sum of the party-wise opening invoices — ₹2,36,000 + ₹1,77,000 + ₹67,000 = ₹4,80,000. Same for creditors, same for fixed assets against the asset register.

If a difference of, say, ₹14,230 refuses to go away, park it in a clearly named suspense ledger and chase it down within the month:

A suspense balance that survives past the first quarter becomes permanent. Put a date on it.

Doing this in FlipAccounts

Create the company with 1 April 2026 as the start of the financial year, then post the opening entry as a single journal dated 1 April so it sits in one place in the general ledger. Enter opening debtors and creditors as invoices and bills against each party rather than as one control-account figure, so ageing and payment matching work from the first receipt. Use the statements pack — trial balance, balance sheet and general ledger — to compare your new opening trial balance against last year's closing figures line by line, and the bank reconciliation screen to prove the opening bank balance against the April statement. Every opening journal is recorded in the tamper-evident audit log, and if your CA is reviewing the migration you can add them with the read-only auditor role; firms handling several migrations at once may find the CA firms guide useful.

What to do this week

1. Export the final trial balance as at 31 March 2026 from your old system, save it with the date in the filename, and stop entering into the old books.
2. Write the opening trial balance as a two-column list and get it to agree to the rupee, with party-wise schedules behind debtors, creditors and fixed assets.
3. Post the single opening journal dated 1 April 2026 and run the three checks — trial balance, bank, sub-ledger — before raising your first new invoice.

Frequently asked questions

Can I start mid-year instead of on 1 April?

You can, but it costs more work. A mid-year cutover means your P&L for the year sits in two places, so you must either enter opening balances as at the cutover date including year-to-date income and expenses, or re-enter transactions from 1 April. If you are switching in, say, October, re-entering six months of transactions is often faster and gives you a clean full-year P&L for the return.

My old trial balance doesn't tally. What now?

Fix it in the old books first, or agree a corrected closing balance sheet with your CA and migrate that. Do not carry an imbalance into the new system and hope it resolves. If the difference is small and genuinely untraceable, write it off through the capital or reserves account with a note explaining the adjustment, so the entry is visible rather than hidden.

Do I need to enter every old invoice, or only the closing balances?

Only the open items. Paid invoices from earlier years do not need to be re-entered — their effect is already inside the closing bank and capital figures. Enter only unpaid sales invoices, unpaid purchase bills, open advances and unreconciled bank items, each with its original date and number.

What about a brand-new business with no prior balance sheet?

There are no opening balances, only the founder's first contribution. Post capital introduced on the date the money actually entered the bank, record any assets brought in personally at a reasonable value with a note, and keep personal and business bank accounts separate from day one. That single habit saves more reconciliation time than anything else in the first year.

More guides