How to Prepare Schedule III Financial Statements from Tally: Import, Mapping and Review

The books are in Tally. The financial statements still need grouping, comparative figures, notes, disclosures and a reviewable final format.

The practical question is how to move from the accounting records to the financial statements without repeatedly copying the same amounts into disconnected spreadsheets.

This article explains a preparation workflow for Schedule III Division I companies. It also shows where assureFinancials at https://assureoffice.in supports direct Tally connection, existing-financials imports, automatic grouping and mapping, cloud collaboration and formatted Excel and PDF exports.

1. Decide what the import should achieve

The import should bring a complete and identifiable set of accounting balances into the preparation process. It should preserve enough information to review the period, signs, ledger classifications and comparative amounts.

A trial balance is an accounting input. A final financial-statement set also needs the relevant adjustments, classifications, accounting policies, notes and additional disclosures.

Keep those stages distinct. If the financial statements differ from the first imported trial balance, the difference should be explained by reviewed adjustments or presentation workings rather than become an unexplained mismatch.

2. Confirm the company and financial year

Before connecting or uploading, confirm the legal entity and the exact period. Similar company names, multiple Tally companies or backup copies can lead to the wrong data being selected.

Record whether you are using full-year closing balances, an interim period or another reporting basis. Confirm the previous-year period separately.

Also identify the accounting framework and whether the preparation is standalone or consolidated. This guide addresses standalone Division I statements; group reporting requires further work.

When starting in assureFinancials, select the intended client and reporting period before using the relevant Tally or import workflow. A correct company-year selection is the first control over every later output.

3. Reconcile the source records before relying on them

Confirm that the source trial balance is the intended version. Check debit-credit equality, bank reconciliations, ledger completeness and the status of year-end entries.

Review whether stock, depreciation, tax and accrual entries have already been recorded. Importing before all adjustments is possible as part of a draft workflow, but the subsequent adjustments must remain identifiable.

If someone sends a fresh Tally export later, understand what changed. Replacing an earlier dataset without checking the movement can overwrite preparation work or cause an adjustment to be counted twice.

Keep the source export or another appropriate record of the information used for that preparation version.

4. Connect directly or use a supported import

assureFinancials supports direct Tally connection as well as supported trial-balance imports. Use the available connection workflow and confirm the intended accounting company and period.

If using a file, follow the import layout accepted for that workflow. Retain ledger names, balances and useful grouping information. Identify subtotal and heading rows so they are not imported as additional balances.

After import, reconcile totals and investigate missing or unexpected accounts. A connection that completed successfully does not, by itself, establish that the selected data was the correct reporting dataset.

Direct connection is useful because it can reduce manual transfer. The review goal remains the same: a complete, correct-period population that can be traced into the financial statements.

5. Bring in comparative figures separately and deliberately

Previous-year information can come from the relevant accounting records or existing financial statements, depending on the preparation method and supported import format.

A prior signed financial statement may already include adjustments or presentation changes absent from an old Tally backup. Agree the comparative figures to the relevant final records rather than assuming every earlier export is authoritative.

assureFinancials supports uploading existing financial information through supported formats. Review extracted amounts, classifications, note detail and presentation units before using them as comparatives.

If the previous workbook is in lakhs and the current import is in rupees, resolve the unit conversion explicitly. An unexplained scale difference can distort both the statements and the ratios.

6. Review automatic grouping and mapping

Automatic grouping can make routine preparation faster. It can identify likely destinations from ledger names, source groups and other available information.

Review the proposed classifications before treating them as final. Give particular attention to:

• Related-party accounts.
• Customer and supplier opposite balances.
• Loans, deposits and advances.
• Current maturities of borrowings.
• Fixed assets and accumulated depreciation.
• Restricted or longer-term bank deposits.
• Unusual income and significant expense balances.
• New or unmapped ledgers.

assureFinancials provides grouping and mapping assistance within the preparation process. The preparer’s job is to resolve the cases that require information beyond a ledger name.

7. Understand why Tally groups may need reclassification

A company may use one group for all advances, even though it contains an employee advance, a payment for machinery and an advance for trading goods. Those balances do not necessarily share a financial-statement destination.

Likewise, a group called “Loans” can contain amounts receivable and amounts payable, different maturities and different relationships. Classify the underlying balances from their nature and terms.

Current and non-current decisions need the applicable criteria and evidence. Under amended Division I, current maturities of long-term borrowings are separately disclosed under short-term borrowings.

Retain the explanation for significant reclassifications. This makes the preparation easier to review and helps the next year’s work start from an understood basis.

8. Use an example to distinguish import totals from presentation

Assume the imported customer group contains debit balances of ₹8 lakh and credit balances of ₹1 lakh. The net group is ₹7 lakh.

The supporting details establish that the credits are customer advances for future supplies, unrelated to the debit balances. The presentation working should consider trade receivables of ₹8 lakh and the separate liability of ₹1 lakh rather than automatically present net receivables of ₹7 lakh.

Now assume a term loan has a closing balance of ₹10 lakh. The reviewed repayment working identifies current maturities of ₹2 lakh and a non-current portion of ₹8 lakh. The total borrowing remains ₹10 lakh; its presentation is split.

These are presentation examples. They do not create profit or cash. A reviewer should be able to distinguish those reclassifications from entries that change income, expenses, asset values or liabilities.

9. Complete year-end accounting adjustments

Review expenses incurred but unpaid, prepaid amounts, revenue cut-off, inventory, depreciation, impairment, provisions, foreign-currency balances and taxes as applicable.

Suppose professional services costing ₹0.40 lakh were received before year end but were not recorded. Recognising the expense and the corresponding liability affects both profit and the Balance Sheet. This is different from moving an existing borrowing between current and non-current categories.

Identify whether each adjustment will be recorded in the accounting books, maintained in the financial-statement preparation working, or incorporated through an agreed process. Reconcile the final position so the same adjustment is not included twice.

assureFinancials supports editing and preparation after import. Use that workflow with a clear supporting basis for every final figure.

10. Reconcile PPE and closing stock

PPE often needs an asset-register working containing opening cost, additions, disposals, accumulated depreciation and the current charge. Compare it with both the imported asset balances and the P&L depreciation figure.

For example, gross cost of ₹25 lakh less accumulated depreciation of ₹7 lakh gives carrying value of ₹18 lakh. If the asset register shows a different amount, identify the additions, disposals, charge or opening-balance difference causing it.

For inventory, establish whether the imported accounts already reflect closing stock. A separate closing-stock working should not recognise the same asset and expense effect again.

An automated import can transfer a balance. The supporting inventory and asset workings establish whether that balance is appropriate for the financial statements.

11. Obtain disclosure information beyond the books

Shareholding, promoter information, contractual due dates, disputes, relevant title-deed matters, lender information and several other disclosures may not be available from a trial balance.

Use an information request alongside the import. Complete the relevant ageing, ratio and other disclosure workings. Keep a distinction between information confirmed as nil, a matter that is not applicable and an item still awaiting a response.

Accounting policies also need review. An imported previous-year note can be a useful starting point, but it should describe the methods and transactions relevant to the current financial statements.

12. Review the complete statements in one sequence

Check the adjusted trial balance, grouped totals, Balance Sheet, P&L, supporting notes and cash flow where applicable.

Confirm that:

• Every imported ledger is included once.
• All adjustments have a clear explanation.
• Assets and equity plus liabilities agree.
• Profit reconciles with reserves and surplus.
• PPE and depreciation agree with the asset working.
• Trade balances reconcile with their supporting detail.
• Tax and borrowing movements are explained.
• Cash flow agrees with the relevant cash balances.
• Current-year and comparative figures use consistent units and classifications.

Resolve exceptions through evidence. A temporary draft difference should remain visible until it is explained rather than disappear into a balancing figure.

13. Export and share the reviewed version

assureFinancials provides formatted Excel and PDF exports. Review the actual files for note references, headings, comparative columns, units, page breaks and signature placement.

Cloud access and authorised multi-user working can help a firm organise preparation and review before export. Keep one clearly identified approved output rather than several files with ambiguous names such as “final”, “final revised” and “final latest”.

If changes are made after export, incorporate them into the preparation process and regenerate the relevant outputs so the versions remain consistent.

14. Use assureFinancials for a repeatable Tally-to-financials workflow

At https://assureoffice.in, assureFinancials connects data collection with financial-statement preparation: direct Tally connection, existing-financials imports, automatic grouping and mapping, editing, cloud teamwork and formatted outputs.

Start with one reporting period and complete the process from import to final review. The benefit is a repeatable workflow that reduces manual copying while keeping accounting decisions visible to the preparer and reviewer.

Explore assureFinancials: https://assureoffice.in

Frequently asked questions

1. Does importing Tally automatically complete the financial statements?

No. Complete the relevant adjustments, classification review, notes and disclosures. The import supplies accounting information for preparation.

2. Should I use the current Tally company or an old backup?

Use the dataset appropriate to the reporting period and intended preparation version. Check what adjustments are included and reconcile it with the final relevant records.

3. Can I import before the accounts are fully finalised?

It can form part of a draft workflow. Keep later adjustments and unresolved items identifiable, and reconcile any refreshed import with work already completed.

4. Why can imported group totals differ from financial-statement headings?

One source group can contain several transaction types or maturity categories. Reviewed reclassification can split the amount without changing its overall total.

5. Does a successful connection establish that the correct year was imported?

No. Confirm the chosen company, period and resulting totals. Technical completion and accounting selection are separate checks.

6. Can I use last year’s financial statements for comparatives?

Yes, through a suitable supported process. Review extraction, units and classification, and agree the amounts to the relevant final records.

7. Why should customer credit balances be investigated?

They can represent advances, refunds, allocation issues or other items. Their nature determines the treatment; automatic netting may be inappropriate.

8. Will reclassifying a loan change profit?

A pure current/non-current reclassification does not create an expense or income. A separate accounting adjustment may have a profit effect, depending on its nature.

9. Can the asset register override Tally without explanation?

Reconcile the difference and record the appropriate adjustment or correction. The final figure needs a clear supporting basis.

10. Why can closing stock be counted twice?

The imported accounts may already include it, while a separate working adds it again. Understand the source bookkeeping method before applying the closing adjustment.

11. Are all disclosures available from Tally?

No. Several need contracts, registers, transaction detail or management information. Plan those information requests alongside the import.

12. What should happen to unmapped ledgers?

Keep them visible, investigate their nature and map them appropriately. Do not exclude them to make the output appear complete.

13. How does assureFinancials help after import?

It provides grouping and mapping assistance, editing and financial-statement preparation, along with cloud teamwork and formatted outputs.

14. Can I share the statements as Excel and PDF?

assureFinancials supports both formats. Check the exported version for completeness, readability and agreement with the reviewed figures.

15. Where can I explore the workflow?

Visit https://assureoffice.in and explore assureFinancials. Use a reviewed client dataset to assess the import, mapping, editing and final output process.