How to Prepare Company Financial Statements: Schedule III Format, Excel Guide and FAQs

You have the trial balance, last year’s financial statements and a deadline. The next task is to turn those records into a complete set of company financial statements: statements that agree with the accounts, use the appropriate presentation, explain the figures and include the disclosures relevant to the business.

The most useful starting point is to understand the finished document. Once you know what belongs in the Balance Sheet, Statement of Profit and Loss, Cash Flow Statement, accounting policies and notes, the preparation process becomes easier to organise.

This guide explains that structure, then follows the preparation process through a worked example. Its main focus is standalone financial statements under Division I of Schedule III for companies following Accounting Standards. Ind AS companies, regulated industries, consolidated accounts and non-corporate entities require their respective frameworks and additional considerations.

This guide also shows where assureFinancials, the cloud-based financial statement builder available through https://assureoffice.in, can simplify the work: connect with Tally, upload existing financial statements, review automatic grouping and mapping, edit the financials and share formatted Excel and PDF outputs.

1. Understand what a complete set of financial statements contains

A Balance Sheet answers a question about a date: what does the company own, what does it owe and what is attributable to its shareholders at the reporting date? The Statement of Profit and Loss answers a question about a period: what income and expenses arose during the year, and what profit or loss resulted?

Neither statement can explain every accounting choice or provide every supporting detail. That is why the accompanying policies and notes matter. Read the financial statements as one connected document.

Balance Sheet

Assets, liabilities and shareholders’ funds at the reporting date. Each relevant figure refers to a supporting note.

Statement of Profit and Loss

Income, expenses and profit or loss for the year. The year’s result feeds into reserves and surplus, subject to other movements.

Cash Flow Statement where applicable

Movements in cash and cash equivalents during the year. Its closing balance reconciles with the corresponding Balance Sheet amount.

Significant accounting policies

The accounting principles and methods applied. They explain how figures in the statements and notes were recognised and measured.

Notes to accounts

Breakdowns, reconciliations and explanations of statement figures. Note numbers allow the reader to move between a main statement and its detail.

Other applicable disclosures

Relevant information that may not be apparent from ledger balances. Usually presented within the notes rather than as a universally separate statement.

Under section 2(40) of the Companies Act, financial statements also include a statement of changes in equity where applicable. This is particularly relevant to Ind AS presentation; a separate statement of changes in equity is not the standard Division I format used in this guide. The statutory definition and applicable exemptions should be read together.

Accounting policies may form an early section of the notes. Additional disclosures may appear later in the same notes. The outline above explains their functions; it does not prescribe six separate files or require every business to use identical note numbering.

The auditor’s report and Board’s report belong to the wider annual reporting package. They have separate purposes and responsibilities. Preparing a financial statement does not itself produce an audit opinion.

2. Identify the applicable Schedule III format

Section 129 links company financial reporting to a true and fair view, notified accounting standards and the applicable Schedule III presentation. Certain sectors have financial-statement formats under their governing legislation, so determine the framework before choosing a template.

Division I

Companies following Accounting Standards rather than Ind AS. Use the non-Ind AS presentation and applicable AS disclosures.

Division II

Companies following Ind AS, other than those using Division III. Use the Ind AS presentation, including its equity and other comprehensive income requirements.

Division III

NBFCs required to comply with Ind AS. Use the specific NBFC presentation.

Schedule III supplies the presentation structure. Accounting standards address recognition, measurement and further disclosures. A correct heading cannot fix an incorrectly recognised expense or an incorrectly valued asset. The relevant division and the accounting standards must work together.

Before preparation, record the company name, financial year, standalone or consolidated status, applicable framework, reporting unit and cash-flow applicability. This prevents a previous client’s or previous year’s format from silently becoming the basis of the current accounts.

Corporate and non corporate financial statements

A proprietorship or partnership should not automatically be described as preparing statutory Schedule III company accounts. Its financial reporting follows the relevant non-company Accounting Standards framework and applicable ICAI guidance. LLPs also have specific guidance and legal requirements.

The financial-statement Guidance Notes for non-corporate entities and LLPs apply in phases. Phase I covers accounting periods beginning on or after 1 April 2025 for entities whose turnover exceeds ₹5 crore. Phase II covers accounting periods beginning on or after 1 April 2026 for all entities within the scope of those Guidance Notes. Assess the entity’s circumstances and any relevant sector-specific requirements.

The preparation principles in this article remain useful, but share capital, partners’ capital, drawings, presentation and applicability decisions should follow the appropriate entity framework.

3. Learn to read the format before filling it

A typical main-statement table has particulars, a note-reference column, current-year figures and comparative figures. The Balance Sheet is headed “as at” a date. The P&L and Cash Flow Statement cover “the year ended” that date.

For a 31 March 2026 reporting date, the Balance Sheet usually compares that date with 31 March 2025. The P&L compares the year ended 31 March 2026 with the year ended 31 March 2025. A new company’s first reporting period needs presentation appropriate to its actual circumstances; do not invent a preceding year.

Comparatives help readers assess movements and consistency. They also expose preparation errors. A receivable balance rising substantially while revenue remains stable deserves explanation, even if the total assets agree with total equity and liabilities.

Note references are navigation aids. If trade receivables refer to Note 10, Note 10 must describe and reconcile those receivables. There is no universal requirement for every company’s trade-receivables note to have the same number.

Reporting units and rounding

Display the reporting unit prominently and apply it consistently. A workbook that mixes actual rupees, thousands and lakhs can appear balanced while containing serious errors.

The 2021 amendment made rounding under the relevant Schedule III instruction mandatory and linked the permitted rounding scale to total income. For total income below ₹100 crore, the stated scales include hundreds, thousands, lakhs or millions; at ₹100 crore or above, lakhs, millions or crores. Select a permitted scale and use it consistently.

Maintain source amounts at appropriate precision. Round presentation values through a controlled method. Investigate genuine differences before dealing with a small presentation-rounding difference.

4. Collect the information needed for preparation

An organised input pack reduces repeated requests and prevents disclosures from becoming a last-minute exercise.

Current trial balance and ledgers

Starting balances and transaction analysis. Supporting records include final export, opening balances and adjustment log.

Previous signed financial statements

Comparative figures, presentation and opening reconciliations. Supporting records include signed statements and relevant workings.

Property plant and equipment records

Additions, disposals, depreciation and carrying values. Supporting records include asset register, invoices and disposal documents.

Inventory working

Quantity, ownership, cost and valuation review. Supporting records include stock records, physical verification and valuation sheets.

Customer and supplier details

Classification, ageing, disputes and balances. Supporting records include invoice dates, due dates, confirmations and MSME information.

Borrowing information

Current and non-current portions, security and other disclosures. Supporting records include loan agreements, confirmations and repayment schedules.

Share capital records

Authorised, issued, subscribed and paid-up information. Supporting records include statutory registers and relevant corporate records.

Tax working

Current tax, tax payments and deferred-tax assessment. Supporting records include computation, challans and temporary or timing-difference workings as applicable.

Management disclosure responses

Information absent from the trial balance. Supporting records include registers, agreements, legal updates and documented responses.

Also reconcile bank balances, statutory dues, related-party balances, employee obligations and inter-company balances where relevant. If a working replaces a trial-balance amount, record the reconciling adjustment and its reason. Preserve a clear route from the source records to the final number.

For users of assureFinancials at https://assureoffice.in, preparation can begin with a direct Tally connection, a supported trial-balance import or existing financial statements. Confirm the selected client and year at the start so the subsequent review follows the correct records.

5. Finalise the accounts before formatting them

A trial balance establishes whether posted debits equal posted credits. It cannot establish whether every transaction has been recognised, the accounting treatment is appropriate or the disclosures are complete.

Consider a professional-fee invoice received after year end for services completed before year end. The receipt date of the invoice does not, by itself, determine the expense period. Review the service period and the obligation at the reporting date. Similarly, an advance payment for next year’s insurance should not automatically remain a current-year expense.

Review revenue cut-off, expenses incurred but unpaid, prepaid amounts, inventory, depreciation, impairment indicators, provisions, foreign-currency balances and income taxes as relevant to the business. Examine subsequent information that provides evidence about conditions at the reporting date.

Keep book depreciation and income-tax depreciation separate. A tax depreciation schedule does not automatically provide the correct charge for company financial statements. Assess deferred tax under the applicable framework rather than assuming that the current-tax charge completes the tax accounting.

A worked example with consistent figures

The fictional company in this guide is Example Components Private Limited, a trading company following Division I. All example amounts are in ₹ lakh. The figures are deliberately simplified to teach the links between records and statements. These extracts do not represent a complete statutory financial-statement set or all disclosures for a real company.

For this example, assume that the comparative figures are final; inventories consist of stock-in-trade; all customer balances shown are trade receivables considered good; interest income is received in cash; and no dividends, deferred-tax balance, disposals, impairment, foreign-exchange effects or non-cash borrowings arise. The tax amounts are supplied accounting workings, not an assumed company tax rate. Asset and tax bases are assumed not to produce a deferred-tax balance.

The current-year trial balance before the four adjustments below is:

Debit balances in ₹ lakh

• PPE at gross cost: 50.
• Inventory carried at opening value: 15.
• Trade receivables: 25.
• Cash and bank balances: 12.
• Supplier advances: 5.
• Purchases of stock-in-trade: 80.
• Employee benefits expense: 15.
• Finance costs: 3.
• Other expenses before accrual: 11.

Credit balances in ₹ lakh

• Accumulated depreciation before current charge: 10.
• Equity share capital: 20.
• Opening surplus in P&L: 18.
• Non-current portion of borrowings: 20.
• Current maturities of borrowings: 5.
• Trade payables: 15.
• Accrued expenses before adjustment: 4.
• Current-tax liability before adjustment: 2.
• Revenue from operations: 120.
• Interest income: 2.

Total debits: 216. Total credits: 216.

The trial balance already balances. Four closing adjustments are still required:

Bring inventory from 15 to the closing value of 18

Debit: Inventory 3. Credit: Change in inventories 3. Asset increases and the inventory-change expense is negative.

Recognise current-year book depreciation

Debit: Depreciation expense 5. Credit: Accumulated depreciation 5. PPE carrying amount decreases and expense increases.

Accrue professional fees for services received

Debit: Other expenses 1. Credit: Accrued expenses 1. Expense and liability each increase.

Recognise the supplied current-tax charge

Debit: Tax expense 3. Credit: Current-tax liability 3. Tax expense and liability each increase.

The resulting adjusted trial balance totals are 228 on each side. The inventory entry shown is an incremental adjustment because this example’s inventory ledger already contains the opening balance. Where software uses separate opening-stock, closing-stock or inventory-control entries, follow that system’s method and avoid counting stock twice.

6. Understand grouping mapping and line items

Grouping places an account in the appropriate financial-statement category. Mapping records the connection between a source ledger and that category. A line item is a separately presented row within a statement or note.

For example, several salary ledgers can feed one employee-benefits working. That working supports the employee-benefits line in the P&L. Different customers can feed the trade-receivables note, while that note’s total supports the Balance Sheet.

Machinery cost and accumulated depreciation

PPE movement working supports presentation under non-current assets under PPE.

Customer invoice balances

Trade-receivables detail and ageing supports presentation under trade receivables.

Advance for future goods

Supplier-advance detail supports presentation under short-term loans and advances in this example.

Term loan

Repayment and security working supports presentation under long-term and short-term borrowings as applicable.

Accrued professional fees

Accrued-expense detail supports presentation under other current liabilities in this example.

Professional and other operating costs

Expense breakdown supports presentation under other expenses.

Which headings are prescribed and what can be modified

Treat the applicable Schedule III structure and required disclosures as the presentation framework. Add relevant subdivisions or additional information where needed for understanding and compliance. An internal preference for a shorter label is not a reason to conceal required classifications.

Within that structure, meaningful detail can reflect the business. An other-expenses note may separately show rent, professional fees, repairs and other relevant expenses. A service company’s revenue detail will differ from a trader’s. Note numbering can be organised consistently for the particular financial statements.

Use judgment about nature, amount, materiality and explicit disclosure requirements. Avoid both a note containing every trivial ledger and an unexplained “Others” balance that conceals significant information.

Why automatic mapping needs review

A Tally group is useful source information. It may have been created for bookkeeping convenience and may not capture maturity, legal nature or disclosure requirements.

A debit balance in a supplier account may represent an advance or a recoverable amount. A credit in a customer account may represent a customer advance or an amount repayable. Investigate the transaction before reclassification; the balance sign alone is not a complete accounting conclusion. Also check whether an apparent opposite balance comes from an allocation error or missing entry.

Do not offset different customers, suppliers, assets or liabilities merely to reduce the number of rows. Apply the relevant presentation and accounting rules, using gross presentation unless a valid basis permits netting.

For borrowings, examine repayment terms and the company’s rights at the reporting date. Current/non-current analysis requires more than the words “long-term loan” in the ledger. Under amended Division I, current maturities of long-term borrowings are disclosed separately under short-term borrowings. An old template placing them under other current liabilities can therefore need correction.

This is where assureFinancials can save repeated work. Its automatic grouping and mapping assistance gives the preparer a starting classification to review and refine. Instead of rebuilding the mapping for every output, the reviewed structure supports the financial-statement preparation workflow on https://assureoffice.in.

7. Prepare the Balance Sheet and Statement of Profit and Loss

The Balance Sheet first organises shareholders’ funds and liabilities, followed by assets. Within the relevant sections, distinguish current and non-current balances. Consider the normal operating cycle as well as the applicable twelve-month criteria. A receivable does not become non-current solely because it is old; review its nature, operating-cycle relationship, recoverability and the applicable criteria.

The full Balance Sheet structure before inserting figures

The following outline shows the Division I headings to understand before adapting the presentation to the company. It explains where an item belongs even when the simplified example below has no such balance. Apply the required details and materiality considerations when preparing the actual statements.

Shareholders’ funds

Share capital; reserves and surplus; money received against share warrants.

Share application money pending allotment

Separate prescribed presentation, with relevant assessment and disclosures.

Non-current liabilities

Long-term borrowings; deferred tax liabilities net; other long-term liabilities; long-term provisions.

Current liabilities

Short-term borrowings; trade payables with the prescribed micro and small enterprise and other-creditor distinction; other current liabilities; short-term provisions.

Non-current assets under PPE and intangible assets

Property plant and equipment; intangible assets; capital work-in-progress; intangible assets under development.

Other non-current asset headings

Non-current investments; deferred tax assets net; long-term loans and advances; other non-current assets.

Current assets

Current investments; inventories; trade receivables; cash and cash equivalents; short-term loans and advances; other current assets.

Use the required nature-based detail within these headings. A refundable long-term security deposit, an advance for goods and an advance for a capital asset are not interchangeable merely because they are all debit balances. Apply the relevant instructions, including the amended security-deposit presentation, rather than placing them in a single convenient advance account.

The example Balance Sheet

Example Components Private Limited — condensed Balance Sheet extract. Amounts in ₹ lakh. Note numbers are illustrative. Relevant additional headings and detailed disclosures must be included for an actual company.

Each line below shows the 31 March 2026 amount first and the 31 March 2025 comparative second. All amounts are in ₹ lakh.

• Equity share capital — Note 1: 20 / 20.
• Reserves and surplus — Note 2: 25 / 18.
• Long-term borrowings — Note 3: 20 / 18.
• Short-term borrowings consisting of current maturities — Note 3: 5 / 4.
• Trade payables — Note 4: 15 / 10.
• Other current liabilities — Note 5: 5 / 4.
• Short-term provisions consisting of current tax — Note 6: 5 / 4.
• TOTAL: 95 / 78.
• Non-current assets consisting of PPE — Note 7: 35 / 32.
• Inventories — Note 8: 18 / 15.
• Trade receivables — Note 9: 25 / 20.
• Cash and cash equivalents — Note 10: 12 / 8.
• Short-term loans and advances — Note 11: 5 / 3.
• TOTAL: 95 / 78.

In a complete format, trade payables include the required distinction between dues to micro and small enterprises and other creditors. The condensed total above is used only to keep the worked example readable. A real note also requires the relevant ageing and other disclosures.

The company has assets of 95, liabilities of 50 and shareholders’ funds of 45. The prior-year figures are 78, 40 and 38 respectively. The equality confirms arithmetic consistency; it does not replace valuation and disclosure review.

The example Statement of Profit and Loss

The P&L classifies income and expenses by their relevant nature. The example uses purchases and changes in stock-in-trade because the company is a trader. A manufacturer would need its applicable material-consumption and inventory-change presentation; a service business will have a different cost profile.

The Division I expense structure includes cost of materials consumed, purchases of stock-in-trade, changes in inventories of finished goods, work-in-progress and stock-in-trade, employee benefits, finance costs, depreciation and amortisation, and other expenses. Follow the relevant subtotals and presentation for exceptional or extraordinary items where applicable under this framework, current and deferred tax, continuing and discontinuing operations, profit or loss for the period and earnings per share. Distinguish this from the Ind AS presentation rather than mixing the two formats.

Each line below shows 2025–26 first and 2024–25 second. Amounts are in ₹ lakh except earnings per share. Parentheses indicate a negative amount; a dash indicates nil.

• Revenue from operations: 120 / 100.
• Other income consisting of interest: 2 / 1.
• Total income: 122 / 101.
• Purchases of stock-in-trade: 80 / 67.
• Changes in inventories of stock-in-trade: (3) / (3).
• Employee benefits expense: 15 / 12.
• Finance costs: 3 / 2.
• Depreciation and amortisation expense: 5 / 4.
• Other expenses: 12 / 11.
• Total expenses: 112 / 93.
• Profit before tax: 10 / 8.
• Current tax expense: 3 / 2.
• Deferred tax expense: — / —.
• Profit for the year: 7 / 6.
• Basic and diluted earnings per equity share in ₹: 3.50 / 3.00.

For earnings per share, assume 2,00,000 fully paid equity shares of ₹10 each were outstanding throughout both years and there were no potentially dilutive equity shares. Actual EPS calculations follow AS 20 and the company’s share movements.

Inventory increased from 15 to 18. Opening inventory minus closing inventory is therefore negative 3. Purchases of 80 plus this negative expense gives an effective stock cost of 77. Entering the inventory increase as a positive expense would reverse the intended effect.

The closing surplus of 25 equals opening surplus of 18 plus current-year profit of 7. For the comparative year, opening surplus was 12 and profit was 6, producing 18. This simple reconciliation assumes no dividends or other movements.

For a company with exceptional items, discontinued operations, relevant tax components or other required rows, the P&L needs the corresponding presentation. Do not remove required information merely because it does not appear in a simplified example.

In assureFinancials, the practical benefit is bringing imported data, reviewed classifications and editable financial-statement details into one preparation process. Formatted outputs make the statements easier to circulate for review and share as Excel or PDF files.

8. Prepare the Cash Flow Statement where applicable

Profit and cash movement answer different questions. Credit sales can increase profit before customers pay. Depreciation reduces profit without being a current cash payment. An asset purchase uses cash without normally becoming an immediate expense for its full cost.

AS 3 classifies cash flows into operating, investing and financing activities. Cash equivalents require an assessment of liquidity, conversion into known cash amounts and insignificant value-change risk. Not every bank deposit qualifies.

Section 2(40) permits omission of the Cash Flow Statement for specified categories including OPCs, small companies and dormant companies. Relevant exemption notifications can also affect eligible private startup companies. Check the legal eligibility and conditions for the reporting period rather than assuming that every private company is exempt.

The following indirect-method example assumes preparation of a Cash Flow Statement is required or voluntarily undertaken. It treats interest paid as financing and interest received as investing for this non-financial company.

Each line below shows 2025–26 first and 2024–25 second. Amounts are in ₹ lakh except earnings per share. Parentheses indicate a negative amount; a dash indicates nil.

• Profit before tax: 10 / 8.
• Add depreciation: 5 / 4.
• Add finance costs: 3 / 2.
• Deduct interest income: (2) / (1).
• Operating profit before working-capital changes: 16 / 13.
• Increase in inventories: (3) / (3).
• Increase in trade receivables: (5) / (5).
• Increase in supplier advances: (2) / —.
• Increase in trade payables: 5 / 2.
• Increase in accrued operating expenses: 1 / 1.
• Cash generated from operations: 12 / 8.
• Income taxes paid: (2) / (1).
• Net cash from operating activities: 10 / 7.
• Purchase of PPE: (8) / (6).
• Interest received: 2 / 1.
• Net cash used in investing activities: (6) / (5).
• Net cash proceeds from borrowings: 3 / 2.
• Interest paid: (3) / (2).
• Net cash from financing activities: — / —.
• Net increase in cash and cash equivalents: 4 / 2.
• Opening cash and cash equivalents: 8 / 6.
• Closing cash and cash equivalents: 12 / 8.

The borrowing proceeds are a single cash inflow in each year for this simplified example, with no principal repayments. In real statements, do not casually net separate receipts and repayments; use the gross presentation unless the standard permits net reporting.

The comparative cash flow uses these supporting opening balances at 1 April 2024: inventory 12, receivables 15, supplier advances 3, trade payables 8, accrued expenses 3, tax liability 3, borrowings 20 and cash 6. PPE gross cost was 36 and accumulated depreciation was 6. These inputs allow the comparative movements to be checked.

Current tax also reconciles. For 2025–26, opening tax liability 4 plus charge 3 less payments 2 equals closing liability 5. For 2024–25, 3 plus 2 less 1 equals 4. A real computation must additionally account for advance tax, TDS, refunds, prior-year adjustments and any other applicable movements.

9. Write the accounting policies and supporting notes

Accounting policies explain how the accounts were prepared. They should describe the methods actually applied to the company’s transactions. Copying a long policy list from another company can introduce methods that the company does not use.

Under AS 1, significant accounting policies form part of the financial statements. Going concern, consistency and accrual are fundamental accounting assumptions; departures need appropriate consideration and disclosure. A policy note does not correct a recognition or measurement error in the numbers.

Relevant policies commonly address the basis of preparation, use of estimates, revenue, inventories, PPE and depreciation, employee benefits, foreign currencies, income taxes and provisions. Select the content based on applicability. Explain important judgments or estimation matters where the relevant framework requires them.

A PPE note that agrees with the accounts

The example has one PPE class for simplicity. The company applies its assessed book depreciation to produce the charges below. These charges illustrate assessed book depreciation rather than a prescribed rate.

PPE movement for 2025–26

• Opening balance: gross cost 42; accumulated depreciation 10.
• Additions or current charge: gross cost 8; accumulated depreciation 5.
• Disposals or deductions: gross cost —; accumulated depreciation —.
• Closing balance: gross cost 50; accumulated depreciation 15.

PPE movement for 2024–25

• Opening balance: gross cost 36; accumulated depreciation 6.
• Additions or current charge: gross cost 6; accumulated depreciation 4.
• Disposals or deductions: gross cost —; accumulated depreciation —.
• Closing balance: gross cost 42; accumulated depreciation 10.

Closing carrying value is 35 for 2025–26 and 32 for 2024–25. The current-year depreciation of 5 agrees with the P&L. In an actual PPE note, provide the relevant class-wise reconciliation and other required information, including impairment or revaluation movements where applicable.

Other examples of useful notes

Share capital needs information that a single ledger cannot supply. In this example, paid-up capital of 20 represents 2,00,000 fully paid equity shares of ₹10 each. Authorised capital, share reconciliation, rights, qualifying shareholders and promoter information require the relevant records; they cannot be inferred from the paid-up total.

The other-expenses total of 12 can be supported by rent of 4, professional fees of 2, repairs of 1, utilities of 1, auditor remuneration of 0.50 and remaining operating expenses of 3.50. These amounts total 12. The professional-fee figure includes the closing accrual of 1.

Disclose auditor remuneration by its required categories. Its presentation within other expenses and related note detail should remain consistent. Depreciation is already a separately presented P&L expense and is supported by asset workings; a separate standalone expense note should not be created automatically just because a software template has a spare note slot.

Likewise, decide the need for a separate tax note from the applicable disclosures and the company’s tax circumstances. A fixed note sequence is a convenience, not an independent legal requirement.

assureFinancials supports editing the financial-statement details and line items during preparation. This helps the accountant adapt the presentation to the client’s business and keep the final statements and supporting information organised.

10. Obtain disclosures that the trial balance cannot supply

A trial balance can show a trade-receivables total. It usually cannot tell you every contractual due date, dispute, promoter relationship, title-deed issue or ultimate beneficiary of funds. Disclosure preparation needs a structured information request and supporting documents.

Use the following as a collection checklist. It summarises important areas, not every possible disclosure for every company. Verify the detailed wording, prescribed tables and applicability against the relevant division and standards.

Promoter shareholding

Promoter identity, shares, holding percentage and changes.

Receivable and payable ageing

Invoice and due dates, unbilled amounts, disputes, relevant credit-quality and MSME categories.

PPE and intangible assets

Movement reconciliations, relevant title-deed information and revaluation details.

Capital work in progress and intangible assets under development

Ageing and completion information where applicable.

Loans or advances to specified persons

Relevant relationships, terms and amounts repayable on demand or without specified repayment terms.

Borrowings and lender reporting

Security, defaults, specified working-capital statement reconciliations and utilisation information.

Regulatory matters

Benami proceedings, wilful-defaulter status, struck-off-company relationships and charge-registration matters where applicable.

Group structures and schemes

Relevant layer restrictions and approved scheme information.

Fund routing and undisclosed income

Relevant arrangements, ultimate beneficiaries and income surrendered or disclosed in tax proceedings.

Financial ratios

Required ratios, numerator and denominator definitions and explanations of relevant changes.

CSR and crypto or virtual currency

Applicable activity, expenditure, balances and transaction information.

Accounting Standard disclosures

Related parties, leases, employee benefits, contingencies, commitments and other applicable matters.

Ageing needs transaction level data

An ageing based on ledger creation dates will often be unreliable. Build it from the relevant transaction-level information. The amended schedules use due-date-based ageing; where a due date is not specified, follow the stipulated transaction-date basis. Unbilled amounts require separate consideration. Receivables and payables do not use identical buckets and categories, so do not reuse one table indiscriminately.

Reconcile the detailed ageing to the corresponding financial-statement balance and explain reconciling items. A correct ageing calculation attached to the wrong total remains a reporting error.

Ratios need consistent definitions

The specified ratio set includes current ratio, debt-equity ratio, debt-service coverage, return on equity, inventory turnover, trade-receivables turnover, trade-payables turnover, net capital turnover, net profit ratio, return on capital employed and return on investment. Explain the items used in numerator and denominator and the reasons for changes exceeding 25% compared with the preceding year as required by the Schedule.

For the worked example, current assets are 60 and current liabilities are 30, giving a current ratio of 2.00. The comparative ratio is 46 divided by 22, or approximately 2.09. This calculation is useful only because both years use the same classification basis.

Assess applicability before using a nil statement

For each disclosure, distinguish an actual reportable matter, a confirmed nil position, non-applicability and information still awaited. These are different conclusions. A blank field or an unanswered management questionnaire should not automatically become a confident “not applicable” statement. Apply the relevant requirement when deciding whether an explicit negative statement is needed.

11. Use current requirements rather than an old template

Important Schedule III changes took effect from 1 April 2021. Their continuing relevance does not make them a fresh amendment every financial year.

An Excel file labelled “new financials format” or “latest Schedule III format” should therefore be tested against the actual reporting requirements. Check its division, classifications, rounding instruction, ageing tables, ratio workings and additional disclosures. The important test is whether the format reflects the requirements applicable to your reporting period.

For a subsequent reporting period, check official notifications and relevant ICAI guidance again. Record what changed, its effective date and the affected workbook sections. A revised template version should identify its changes rather than merely change the year printed on the cover.

12. Prepare financial statements in Excel with controlled links

Excel can support preparation when the workbook has a clear data flow. Separate source information, adjustments, calculations and presentation. This makes errors easier to locate and review.

Company details and settings

Name, period, framework, unit and signatories. Control: one source for repeated particulars.

Trial balance

Imported ledger balances for both years. Control: debit-credit and opening-balance checks.

Mapping

Ledger-to-heading and note connections. Control: unmapped and multiply mapped ledger checks.

Adjustments

Supported year-end entries. Control: entry balance, explanation and review status.

Supporting workings

PPE, inventory, debt, taxes and ageing. Control: reconcile each working to the adjusted figures.

Notes

Required detail and explanations. Control: note totals agree with the main statements.

Balance Sheet and P&L

Final financial-statement presentation. Control: controlled links and comparative agreement.

Cash flow

Cash movement calculation where applicable. Control: closing cash reconciliation.

Policies and disclosures

Relevant narrative and additional information. Control: applicability and completeness review.

Review checks

Exceptions across the workbook. Control: every unresolved exception remains visible.

Use stable ledger identifiers or a reviewed mapping register. A formula that assumes the rent ledger always remains in row 43 is vulnerable when a new ledger is inserted. Structured references and carefully designed lookup or SUMIFS formulas can reduce this risk.

For example, if signed debit-positive balances and classifications sit in an Excel table called AdjustedTB, a grouped debit balance can be calculated with =SUMIFS(AdjustedTB[Amount],AdjustedTB[Group],A2). Liability and income presentation must then follow the workbook’s documented sign convention; do not indiscriminately convert every figure to an absolute value.

Keep formulas visible to reviewers and protect presentation cells where appropriate. Avoid unexplained hard-coded totals. If a figure changes following review, update its underlying working or supported adjustment so the correction flows to every connected statement.

At minimum, include checks for trial-balance equality, unmapped balances, mapping totals, Balance Sheet agreement, statement-to-note agreement, PPE movement, reserve movement, tax reconciliation and cash-flow agreement. Test that comparative columns point to comparative data.

Before printing or exporting, check repeating headings, page breaks, note numbers, units, readable widths, wrapped descriptions and signature placement. Excel totals can be correct while a PDF hides a column or splits an important heading from its table.

An Excel export is also useful as a review and sharing format. Keep version control clear so an emailed workbook does not silently become a separate, untracked set of accounts.

For firms preparing several clients’ financial statements, assureFinancials offers a cloud-based alternative to maintaining a separate working copy on every computer. Authorised multi-user access supports preparation and review, while Excel and PDF exports provide familiar formats for sharing. Explore the workflow at https://assureoffice.in.

13. Review the complete set before approval and signing

Review the statements in layers. First confirm the records and adjustments. Then confirm classification and calculations. Finally assess disclosures and presentation as one document.

Records and calculations

• Confirm that the correct company, reporting period and final trial balance were used.
• Agree opening figures with the relevant previous-year records and financial statements.
• Review each adjustment and preserve its supporting working.
• Reconcile bank, customer, supplier, statutory and related-party balances as relevant.
• Agree PPE, inventory, borrowings and tax workings with the final figures.
• Confirm that P&L profit reaches reserves and surplus through an explained movement.
• Reconcile cash flow with the cash and cash-equivalent figures used in the Balance Sheet.

Classification and disclosures

• Review current and non-current treatment, including current maturities of borrowings.
• Investigate opposite balances and inappropriate netting.
• Agree every main-statement figure with its note and each note with its supporting detail.
• Review accounting policies against the methods actually applied.
• Complete the applicable Schedule III and Accounting Standard disclosure checks.
• Review comparative consistency and explain relevant regrouping or reclassification.
• Assess subsequent events, contingencies, commitments and consolidation requirements where relevant.

Presentation and completion

• Check the reporting date, company particulars, unit, note references and page sequence.
• Review the actual exported document for truncation, awkward breaks and missing information.
• Resolve differences through evidence and appropriate adjustments rather than an unexplained balancing figure.
• Confirm that required approval and signatory arrangements are complete.
• Preserve the final approved version and its supporting records.

Section 134 governs Board approval and signing arrangements. Apply the relevant chairperson or director requirements and the CEO, CFO and company-secretary requirements wherever appointed, including the specific OPC provision. The management signatures and the auditor’s reporting responsibilities should be handled in their proper sequence.

Cloud access is particularly useful when preparation and review are handled by different team members. With assureFinancials, authorised users can work within the client preparation process, while the firm keeps responsibility for reviewing and approving the final financial statements.

14. How assureFinancials supports this preparation process

The recurring work in financial-statement preparation includes bringing data together, connecting ledgers to the presentation, carrying comparatives consistently, updating notes and producing readable outputs. assureFinancials, available through assureOffice, is designed to support that workflow.

Instead of rebuilding a separate spreadsheet for every client, users can work through data import, grouping and mapping, editing and review in a cloud-based environment. The useful question is how each function fits the preparation task.

Bring accounting data into the preparation process

Direct Tally connection and supported trial-balance imports. Confirm company, period and imported balances.

Start with existing financial information

Upload existing financial statements through supported import formats. Review extracted figures, classifications and comparatives.

Connect ledgers with the presentation

Automatic grouping and mapping assistance. Review unusual transactions, maturity and opposite balances.

Finalise statements and notes

Edit figures, line items and relevant details in the preparation workflow. Preserve the supporting basis and resolve differences.

Work across a firm

Cloud access and authorised multi-user working. Assign the appropriate client access and review responsibility.

Review and share outputs

Formatted Excel and PDF exports. Check the final exported file and version being shared.

Automatic mapping can reduce repeated classification work. Previous financials can provide a useful starting point. Multi-user access can help preparation and review happen within an organised client workflow. The accountant still makes the applicable accounting and disclosure decisions described in this guide.

Explore assureFinancials at https://assureoffice.in. Start with one client’s trial balance or existing financial statements, review the imported information and mapping, complete the relevant workings and disclosures, and then review the generated outputs.

15. Frequently asked questions

1. Are a Balance Sheet and financial statements the same thing?

No. The Balance Sheet is one component. The complete set also includes the P&L, cash flow where applicable, relevant equity presentation, accounting policies and explanatory notes. The opening sections explain how these fit together.

2. What is the difference between notes schedules and accounting policies?

Notes explain and break down the figures or provide other required information. “Schedule” is often used informally for a supporting breakdown, although Schedule III itself is the statutory presentation schedule. Accounting policies explain the principles and methods used to prepare the figures.

3. Why do financial statements show previous year figures?

Comparatives help readers assess movements and consistency. They also give the preparer a reference for opening balances and changes. Use actual comparative information and appropriate presentation for a first reporting period rather than inventing a preceding year.

4. Which division of Schedule III should a company use?

Determine the accounting framework and entity category first. Division I addresses non-Ind AS company presentation, Division II covers relevant Ind AS companies, and Division III addresses Ind AS NBFCs. Also check whether sector-specific legislation supplies a different format.

5. Does Schedule III apply to proprietorships and partnership firms?

It is the company presentation framework and should not automatically be imposed on those entities as a statutory company requirement. Assess the relevant non-company Accounting Standards framework and ICAI guidance. Similar-looking statement layouts do not make the underlying applicability identical.

6. Is the new non corporate financial statement guidance relevant to FY 2025–26?

Yes, where the entity meets the applicable scope. Entities with turnover exceeding ₹5 crore fall within Phase I for periods beginning on or after 1 April 2025, subject to the relevant scope. Phase II covers all in-scope entities for periods beginning on or after 1 April 2026.

7. Must every company prepare a Cash Flow Statement?

Check the statutory definition and exemptions. Specified categories can omit it, and relevant private-startup exemptions have conditions. Ordinary private-company status alone is not sufficient reason to omit a cash flow. See section 8 for the preparation approach.

8. Is there one official Excel workbook for every company?

Schedule III prescribes presentation and disclosure requirements rather than a single universally suitable workbook. An Excel template must reflect the applicable division, business, reporting period and accounting requirements. A download labelled “standard format” still needs review.

9. Does the phrase latest format mean there is a new amendment this year?

No. It can describe an updated template rather than a legislative change. Identify the actual notification, effective date and affected requirements before describing a format as newly mandated. The continuing 2021 amendments should not be presented as a fresh 2026 notification.

10. Can additional line items be added?

Yes, where relevant to the applicable presentation and proper understanding. Additional detail should make the statements clearer and meet disclosure requirements. It should not erase prescribed classifications or scatter the same balance across inconsistent headings.

11. Can note numbers be changed?

They can be organised for the particular financial-statement set. Update all references consistently. A note-number change is a navigation change; it does not change the accounting treatment or excuse a missing disclosure.

12. Should every ledger appear as a separate line item?

No. Group similar items meaningfully, while providing separate disclosure required by nature, materiality or an explicit rule. Keep a detailed internal working so a reviewer can trace the grouped figure to the ledger accounts.

13. Must the financial statements follow Tally groups exactly?

No. Tally groups are input information. Review the underlying transactions and the reporting framework. A bookkeeping group may combine balances requiring different financial-statement classifications or additional disclosures.

14. Can a credit balance in a debtor account remain in trade receivables?

Investigate it. It may reflect a customer advance, refund obligation, allocation issue or another item. Determine the correct treatment from the facts and avoid automatically netting it against unrelated customer debit balances.

15. Are all old receivables non current?

Age alone does not settle classification. Consider the normal operating cycle and applicable current-asset criteria. Separately assess recoverability, impairment or provision and ageing disclosure. Classification and valuation are different decisions.

16. Where should current maturities of long term borrowings be shown?

For amended Division I, disclose them separately under short-term borrowings. Use the repayment working and the applicable classification criteria. An older template showing these maturities under other current liabilities needs review.

17. Can financial statements be prepared directly from a trial balance?

The trial balance is a starting point. Complete adjustments, supporting workings, classifications and information requests before finalising. Shareholding, contractual due dates and several other disclosure matters usually require records beyond the trial balance.

18. Why can a balanced trial balance still produce incorrect accounts?

Equal debits and credits do not reveal every omission or wrong treatment. A missing accrual, an expense capitalised incorrectly or an unsupported inventory value can leave the trial balance balanced. Review the economic substance and period of the transactions.

19. Should company book depreciation equal income tax depreciation?

Do not assume equality. Company book depreciation follows its applicable accounting and company-law requirements; tax depreciation serves the tax computation. Evaluate any resulting tax-accounting implications under the applicable framework.

20. Why is an increase in closing stock shown as a negative expense?

For the stock-in-trade example, the inventory-change expense is opening stock minus closing stock. An increase from 15 to 18 therefore produces negative 3. Ensure the bookkeeping entries and presentation do not recognise the same closing-stock benefit twice.

21. Can last year financial statements be reused?

They can supply comparative information and a preparation starting point. Review current-year applicability, transactions, classifications and disclosures. Preserve the previous signed figures and explain presentation changes instead of silently overwriting the prior-year record.

22. How should comparative regrouping be handled?

Retain a reconciliation between the previous reported presentation and the regrouped comparative presentation. Explain relevant changes as required. A presentation regrouping should not be used to conceal an accounting error; assess errors under the applicable requirements.

23. Can every disclosure be generated automatically from ledger balances?

No. Some need contracts, registers, legal updates or management information. Automation can organise requests and calculations, but missing evidence cannot reliably establish a nil position or non-applicability.

24. Should every possible disclosure appear with nil values?

Decide this from the relevant disclosure requirement and the company’s facts. Some requirements call for explicit information or statements. Others are not applicable. Avoid a blanket policy of deleting every nil item or retaining every possible boilerplate note.

25. What if the ageing does not agree with the trade balance?

Reconcile invoices, unallocated receipts, debit or credit notes, unbilled amounts, provisions and classification adjustments. Check both the population and the date basis. Record the reconciliation so the reviewer can understand the final total.

26. Is a separate depreciation or tax expense note always mandatory?

A standalone note title is not automatically required simply because that expense exists. Provide the relevant expense presentation, asset or tax workings and applicable disclosures. Use a separate note where needed to communicate the required information clearly.

27. Can financial statements be prepared entirely in Excel?

Yes, with an appropriate workbook and review process. Use controlled inputs, mapping, linked notes, reconciliation checks and version control. Review the exported document too; spreadsheet accuracy does not guarantee readable or complete output.

28. What should I check before using a free financial statement format?

Check the division, effective requirements, headings, comparative layout, rounding, disclosures, formulas, print settings and sample data. Remove another company’s particulars and policies. Review the source and date rather than trusting the filename.

29. What should I do when supporting information is missing?

Record the missing item, request the evidence and assess its effect on the draft. A draft can identify unresolved matters clearly. Do not convert missing information into an unsupported final figure, nil disclosure or balancing entry.

30. What is the difference between standalone and consolidated financial statements?

Standalone statements report the company itself. Consolidated statements bring together the relevant group information under the applicable consolidation requirements. Investments, intra-group balances, eliminations and other group matters need additional workings; combining trial balances alone is insufficient.

31. Can assureFinancials start from Tally or existing financial statements?

It supports direct Tally connection and importing existing financial information through supported formats. Review the selected company and period, extracted figures, mapping and comparatives before proceeding. The source quality and import format affect what can be brought in reliably. You can explore assureFinancials through https://assureoffice.in.

32. What still needs review after using automatic grouping?

Review unusual items, opposite balances, maturity, the operating cycle, tax treatment and disclosure requirements. Confirm that notes and supporting workings agree. Automatic grouping assists preparation; the final classification remains an accounting decision.

33. Can team members work on the same client preparation process?

assureFinancials provides cloud-based access and authorised multi-user working. Assign client access and review responsibilities appropriately. Keep the final approved output identifiable when files are downloaded or shared outside the preparation workspace.

34. Who approves and signs company financial statements?

Apply section 134’s Board approval and signing requirements to the company’s circumstances, including the relevant directors and appointed officers. Confirm the actual appointments and authorisation. The auditor reports on the financial statements through the separate audit process.

35. Does preparing the statements complete the annual filing?

No. Approval, audit where applicable, adoption and statutory filing have their own requirements and timelines. A financial-statement builder supports preparation and outputs; the wider annual compliance process must still be completed.

Prepare your next set of financial statements with assureFinancials

If your current process involves copying balances between spreadsheets, rebuilding groupings and repeatedly adjusting final formats, start by exploring assureFinancials on https://assureoffice.in.

Connect with Tally or upload supported accounting data and existing financials. Review the automatic grouping and mapping, update the relevant figures and disclosures, work with authorised team members in the cloud, and export formatted Excel and PDF statements for review and sharing.

Use the preparation steps in this article as your checklist, and use assureFinancials to make the recurring preparation work easier to manage.

Explore assureFinancials: https://assureoffice.in