← Home
Veritas Legal Sansar logo

Financial Maker: Balance Sheet from Tally, Excel or ITR

Veritas Legal Sansar and Associates LLP

About the Financial Maker: Balance Sheet from Tally, Excel or ITR JSON

The Financial Maker (Financial Reckoner) is a free tool that makes a complete set of financial statements: balance sheet, profit and loss account, notes to accounts, fixed asset schedule with depreciation, cash flow, capital accounts and key ratios. Bring your figures from Tally (trial balance, or ledger masters and day book, in XML or JSON), from a trial balance in Excel or CSV (Busy, Marg or any software), from the ITR JSON you filed (ITR-3, ITR-4, ITR-5 or ITR-6), or type them yourself. Every Tally ledger is placed under the right head by its group, and you can change any head. The reverse engine turns the finished statements back into a valid JSON file, a trial balance and a Tally XML of next year's opening balances. Choose the ICAI format for proprietors and firms, Schedule III under AS, or Ind AS for companies.

At a glance

What it does
Makes a balance sheet, profit and loss account, notes to accounts, fixed asset schedule, cash flow statement, capital accounts and ratios from Tally data (XML or JSON), a trial balance in Excel or CSV, your filed ITR JSON or typed figures, and exports them back as JSON, a trial balance and Tally XML.
Who it is for
Proprietors, partnership firms, LLPs, companies and their accountants who need financial statements for a bank, a loan, an ITR or their records.
What you get
A PDF set of financial statements; a financial statements JSON (re-importable); a trial balance CSV; a Tally XML of next year's opening balances.
Your data
Your entries are read inside your browser and are not uploaded to our server.
Limits
The statements are only as correct as the figures in your books, your ITR or what you type. Closing stock must be typed when the Tally trial balance does not carry it. They are not audited; an audit, where the law needs one, must be done by a Chartered Accountant.

How to use it

  1. Pick the entity: proprietor, partnership firm, LLP or company, and the format.
  2. Upload a Tally XML or JSON export, a trial balance in Excel or CSV, or your filed ITR JSON. Or type the figures.
  3. In Imported ledgers, check where each ledger goes and type the closing stock. The statements update at once.
  4. Download the PDF free, or export the statements as JSON, a trial balance or Tally XML.

Frequently asked questions

Is the Financial Maker free?

Yes. Making the statements, the PDF download and the JSON, trial balance and Tally XML exports are all free. No login is needed.

Can I make a balance sheet from Tally data?

Yes. In Tally open Display More Reports › Trial Balance (press F5 or Alt+F5 for ledger-wise), press Alt+E and export in XML (Data Interchange) or Excel format, then upload the file. For the most detail export All Masters and the Day Book in XML and upload both. Each ledger goes to the right head by its Tally group: Sundry Debtors to trade receivables, Sundry Creditors to trade payables, Duties and Taxes to other current liabilities, Fixed Assets to the fixed asset schedule, and so on.

Can I make a balance sheet from a trial balance in Excel?

Yes. Upload an Excel (.xlsx or .xls) or CSV file with the columns Ledger, Group, Debit and Credit, or Ledger with a Closing balance and Dr or Cr. Tally's Excel export with two header rows works as it is. Download our trial balance format from the tool if you need one.

Why do I have to type the closing stock?

Tally's trial balance shows the opening stock, not the closing stock, because the closing stock goes only into the trading account and the balance sheet. Type the value of stock at the year end in the Imported ledgers step and the trading account and balance sheet are completed.

What is the reverse engine (financials to JSON)?

It turns the finished statements back into files: a financial statements JSON with every figure, schedule, fixed asset row, the trial balance and checks (upload it here again to continue, or use it in other software), a trial balance in CSV worked back from the statements, and a Tally XML with each balance sheet ledger and its closing balance as next year's opening balance.

Can I make a balance sheet from my ITR JSON?

Yes. Download the JSON of your filed return from the income tax portal and upload it. The balance sheet and P&L schedules in ITR-3, ITR-5 and ITR-6 fill the statements; for ITR-4 the presumptive figures are used.

Which formats are supported?

The ICAI format for non-corporate entities (proprietors, firms, LLPs), Schedule III of the Companies Act under Accounting Standards, and Ind AS. The vertical format or the traditional T-format can be chosen for non-corporate entities.

Is a balance sheet needed for a bank loan?

Usually yes. Banks ask for two or three years of balance sheets and P&L with the ITR. You can make each year here from that year's Tally data or ITR JSON, and show the previous year alongside.

Is my data uploaded to your server?

No. Tally files, Excel sheets and JSON are read inside your browser and are not uploaded.

Related tools and services

Related guides

Official sources

Last updated: 18 November 2026. How this tool works · Disclaimer

🌐 Language · भाषा