Convert Old Financials Format to New Financial Statements

Powered by assureFinancials by assureOffice. Convert existing Excel financials or Tally data into Schedule 3 / Schedule III financial statements for companies or the applicable ICAI-format financial statements for non-corporate entities.

Choose how you want to convert

Start with your existing financial statements or prepare new-format financial statements directly from Tally.

Tally Port
From Date
To Date

Start connector, keep Tally open, then click Check Connector.

Download Local Connector Setup

Required Tally exports

1. All Accounting Masters — XML (Required)

2. Trial Balance — Excel — Ledger-wise (Required for Current Year)

Do not upload the normal Group-wise Trial Balance. In Tally, change Type of Grouping to Ledger-wise before export.

What to export from Tally? Step-by-step guide

All Accounting Masters: export all accounting masters together as one XML file. This gives assureFinancials the ledger/group structure used for mapping.
Current Year Trial Balance: open Trial Balance, change Type of Grouping to Ledger-wise, keep the required financial-year period, and export to Excel.
Previous Year: if required, export the previous year's Trial Balance in the same Ledger-wise Excel format and upload it separately.
Closing Stock: review/enter the year-end stock values below because a Ledger-wise Trial Balance may not contain the closing inventory valuation needed for financial statement preparation.

All Accounting Masters XML — RequiredNo file selected

Current Year Ledger-wise Trial Balance Excel — RequiredNo file selected

Previous Year Ledger-wise Trial Balance Excel (optional)No file selected

Closing Stock — please enter/review separately

Ledger-wise Trial Balance may not contain the year-end Closing Stock required for financial statement preparation. Values entered here feed the same common stock working used inside assureFinancials; no separate stock calculation is created.

Current Year Closing Stock

Raw Materials Work-in-Progress Finished Goods Stock-in-Trade Stores & Spares

Previous Year Closing Stock Use when PY Trial Balance is uploaded

Raw Materials Work-in-Progress Finished Goods Stock-in-Trade Stores & Spares

Leave all fields blank only when you do not want to override the stock value from the imported data. To explicitly record nil Closing Stock, enter 0 in any one field.

Old Format Financials Excel — Current Year / Both YearsNo file selected

Add a separate previous-year file Optional

Previous Year Financials Excel (optional — only if it is in a separate file)No file selected

Your files & privacy

Your financial data is not stored during normal conversion. The file is processed and the result is returned. It is stored only if you choose to save it into your account, or if after an error you explicitly choose “Share workbook with support” for temporary troubleshooting.

For Traditional Financials, ITR and Tax Audit downloads, save/open the financials inside the app.

Sign in to save this conversion as a client and continue editing it in assureFinancials. Your current conversion will be carried forward after sign-in.

Normal generation does not retain the uploaded financial data. Saving into the app stores it in your own account; a failed workbook is retained only if you explicitly choose to share it with support.

History

Kept in this browser only — nothing here is sent to us. Downloads are regenerated when you open an entry again.

assureFinancials: Financial Statement Preparation, Review & Reporting

assureFinancials (Assure Financials) by assureOffice helps Chartered Accountants, accountants and finance teams convert supported Tally data or existing Excel financials into reviewable financial statements. For companies it works as a Schedule 3 Financial Statements Builder (the common search spelling of Schedule III), preparing the Schedule III Balance Sheet, Statement of Profit and Loss, Notes to Accounts and applicable disclosures. Non-corporate entities remain on their separate applicable presentation.

See the Tally import and financial statement walkthroughs or browse financial reporting guides and articles.

Excel to Schedule 3Import supported old-format financial statements in Excel, review recognised figures and convert them into a structured statement set.

Tally to Schedule 3Connect Tally or use supported Tally exports, review grouping, and prepare the Balance Sheet, P&L, Notes and comparative schedules.

OutputsSchedule III Balance Sheet, Statement of Profit & Loss, Notes to Accounts, PPE and other applicable schedules, with Excel and PDF output.

Professional reviewReview automatic grouping, change ledgers, edit notes and control the final presentation before use.

Excel or Tally to Schedule 3 Balance Sheet Format

Use the online Schedule 3 Financial Statements Builder when you already have old-format Excel financials or Tally accounting data and want a reviewable statement set rather than another manually maintained Schedule 3 Excel format. The same workflow covers the technically correct Schedule III wording, including the Balance Sheet, Statement of Profit & Loss, Notes to Accounts and comparative figures for supported company cases.

Schedule 3 Financials BuilderRead supported source data, review recognition and grouping, and keep the figures traceable before generation.

Schedule III Financial Statements SoftwareUse a web-based workflow for Balance Sheet, P&L, Notes and applicable schedules instead of formatting the entire set manually.

Balance Sheet Preparation SoftwareReview the proposed company or non-corporate presentation and generate Excel/PDF only after checking the source and workings.

How it works

1 · Bring in your data Import Old Format Financials Excel, connect Tally on your own machine, or import Tally exported files.

2 · Generate Grouping, notes, disclosures and the comparative year are prepared for you.

3 · Take the output Download the Schedule 3 / Schedule III-style Excel or PDF, or open it inside the app to review, edit and access traditional financials and other outputs.

Schedule 3 for companies, separate financial statement presentation for non-corporate entities

Both entity types, one tool Companies in Schedule 3 / Schedule III presentation; firms, LLPs and proprietors in the non-corporate financial statement format. The comparative year is handled alongside.

Auto intelligent mapping Ledger names are read and mapped to the right head on their own — statutory dues, GST, advance tax, depreciation and the rest. Unmapped ledgers are listed, never silently dropped.

Full freedom to modify Grouping, note text, order, disclosures, wording, units, decimals — all of it is yours to set. The app suggests; you decide.

Draft JSON for ITR and Tax Audit

The figures prepared for the financials are handed on rather than re-entered — a draft JSON ready to import into CompuTax, Webetax, Genius and similar software, so the same numbers are not typed a second time. Available inside the app.

Coming soon

The rest of the assureOffice suite, being built for the same login. assureFinancials is the one you can use today.

assurePDFassureTaxassureTaxAudit assureAuditassurePracticeassureNotices assureGSTassureBooksassureTP

Frequently asked questions

What is assureFinancials / Assure Financials?assureFinancials (also searched as Assure Financials) by assureOffice is a web-based financial statement preparation, review and reporting application for Indian CAs, accountants and finance teams. It prepares reviewable Schedule III-style Balance Sheet, Profit and Loss, Notes to Accounts and comparative outputs from supported Excel or Tally data.

Can I convert Excel financials to Schedule 3 format?Yes. Upload supported old-format financial statements in Excel, select the relevant statement sheets, review the recognised figures and groupings, and generate Schedule III-style Excel or PDF output.

Can I convert Tally data to Schedule 3 financial statements?Yes. You can connect Tally through the local connector or use supported Tally exports, review the proposed grouping and workings, and generate the financial statements.

Does the builder prepare a Schedule 3 Balance Sheet and P&L?Yes. The financial statement output includes the Balance Sheet, Statement of Profit and Loss, Notes to Accounts, comparative figures and applicable supporting schedules.

Is Schedule 3 the same as Schedule III?Schedule III is the statutory name. Schedule 3 is a common way users type the same term in search. assureFinancials uses Schedule III in technical references while supporting both wordings on this page.

Can I review and change the automatic grouping?Yes. Automatic mapping is a starting point. You can review ledgers, change grouping, edit notes and control the final presentation before using the output.

Is this online Schedule 3 financial statements software?Yes. assureFinancials is web-based and this conversion workflow is designed for supported Excel or Tally inputs, with review before Schedule III-style Excel or PDF output.

Can it create a Schedule 3 Balance Sheet format from old Excel financials?For supported formats, yes. The importer reads the selected financial statement sheets, proposes figures and groupings for review, and generates a structured Balance Sheet, Profit and Loss and Notes to Accounts rather than simply copying the old layout.

Can I import existing corporate Schedule III financial statements?Where the corporate existing-financials workflow is enabled, you can import a supported Schedule III Division I workbook with its notes and disclosures, review the selected report content and export the edited report.

Try 2 generations without login. Sign in to continue.

Create free account Log in Watch App Videos

Convert Old Financials Format to New Financial Statements

Choose how you want to convert

Select financial statement sheets

Last year's file

Review your details

Check the figures before generating

Capital account

Fixed assets

Stock

Imported accounting data