Binarysoft is Authorised Tally Sales & Implementation Partner in India
+91 742 877 9101 or E-mail: tally@binarysoft.com 10:00 am – 6: 00 pm , Mon-Fri
Call CA Tally HelpDesk +91 9205471661, 7428779101
In 2026, companies preparing financial statements under Schedule III Division I are under growing pressure to turn detailed accounting records into properly classified Balance Sheets, Statements of Profit and Loss, and Notes to Accounts without spending days manually rearranging figures in Excel. For companies in Rajouri Garden and Janakpuri, the challenge often appears at year-end: books may be maintained correctly in TallyPrime, yet statutory presentation requires additional grouping, current/non-current classification, note references, comparative figures and disclosures. When this process depends heavily on manual copying and spreadsheet formulas, one late ledger adjustment can force changes across several schedules. A structured TallyPrime-to-Excel reporting workflow can reduce repetitive work by mapping accounting ledgers to Schedule III reporting heads and linking financial statements with supporting notes. The benefit is faster finalisation, stronger consistency, easier review and a clearer audit trail from the books to the final financial statements.
Schedule III to the Companies Act, 2013 prescribes presentation and disclosure requirements for financial statements of companies covered by the relevant division.
Division I broadly applies to companies whose financial statements are prepared in accordance with the Accounting Standards framework applicable to them rather than Ind AS.
For such companies, financial reporting is not simply about producing a trial balance.
The final financial statements need an appropriate structure and presentation.
This can involve:
Balance Sheet
Statement of Profit and Loss
Notes to Accounts
Comparative figures
Accounting policies and other disclosures, as applicable
Supporting schedules
Cross-references between statements and notes
Proper classification of assets and liabilities
Presentation of material items
The exact disclosures applicable to a company depend on its facts, circumstances and prevailing statutory requirements.
TallyPrime is used by many businesses to maintain day-to-day accounting records.
The statutory financial statements, however, may require information to be presented differently from the operational ledger structure.
For example, the accounts team may maintain separate ledgers for:
HDFC Bank
ICICI Bank
Axis Bank
Petty Cash
Security Deposit
Trade Receivables
Advance to Supplier
GST balances
Employee advances
Various loans
Expenses payable
Audit fees payable
Salary payable
These ledger names make sense for accounting.
But statutory reporting requires them to be grouped and presented under the appropriate Schedule III heads and notes.
This creates the need for a mapping layer between the accounting system and the final financial statements.
Rajouri Garden has a broad mix of commercial activities, including retail, distribution, services, trading and corporate offices.
A private limited company operating in the area may maintain its complete books in TallyPrime throughout the year.
At year-end, the finance team may need to convert those books into a statutory reporting package.
The challenge becomes greater when the company has:
Large numbers of ledgers
Multiple bank accounts
Many customers
Numerous suppliers
Loans
Fixed assets
Employee-related liabilities
GST balances
Advance payments
Provisions
Related-party transactions
Other disclosures
Manually analysing every ledger can take considerable time.
Janakpuri is another major West Delhi commercial and professional hub.
Companies operating there may include:
Trading companies
Service companies
Consulting businesses
IT companies
Distributors
Healthcare-related enterprises
Education-related businesses
Professional organizations
Construction-related businesses
Small manufacturing companies
Regardless of industry, incorporated entities that fall within the applicable statutory framework need financial statements presented according to the relevant requirements.
A properly designed TallyPrime-to-Excel process can make the financial-statement preparation workflow much more manageable.
Consider the story of a growing private limited company in Janakpuri.
Its accounts were maintained in TallyPrime.
Throughout the year, everything appeared organized.
Sales were entered.
Purchases were recorded.
Banks were reconciled.
Expenses were booked.
Customer and supplier ledgers were maintained.
Then financial-statement finalisation began.
The accountant exported the trial balance to Excel.
Another workbook contained the Balance Sheet.
Another contained the Profit and Loss statement.
Several more sheets contained notes.
A ledger adjustment was made after the auditor's review.
The accountant changed the trial balance.
Then he changed the Balance Sheet.
Then one note.
Then another schedule.
But one formula still referred to the old figure.
Friday evening became Friday night.
The finance manager was waiting.
The auditor was waiting.
The director wanted the accounts finalised.
The accountant kept checking the same numbers.
He was not struggling because he did not understand accounting.
He was struggling because the same accounting figure existed in too many manually maintained places.
The company later created a structured mapping between its TallyPrime trial balance and Schedule III Excel reporting workbook.
Ledger balances flowed into mapped reporting heads, notes were linked with primary statements, and control checks highlighted differences.
Year-end finalisation still required professional judgement.
But it no longer required repeatedly typing the same number into five different sheets.
That change brought something accountants value enormously during finalisation:
Control.
TallyPrime can serve as the primary accounting environment in which transactions and ledger balances are maintained.
Excel can then be used as a flexible reporting and financial-statement preparation layer.
This combination can be effective when properly controlled.
TallyPrime provides the accounting base.
Excel provides flexibility for:
Schedule III presentation
Ledger mapping
Note preparation
Comparative reporting
Supporting calculations
Cross-references
Disclosure schedules
Review checks
Custom formatting
The objective should not be to maintain two independent sets of accounts.
Excel should derive information from the finalized accounting records rather than becoming a separate uncontrolled bookkeeping system.
The trial balance is one of the most important starting points for financial-statement preparation.
It contains ledger balances that eventually need to be mapped into the Balance Sheet, Statement of Profit and Loss and supporting notes.
A structured workflow may begin by obtaining relevant information such as:
Ledger name
Parent group
Opening balance where needed
Debit movement
Credit movement
Closing balance
Comparative information
Additional classification or mapping fields
The exact export structure will depend on the reporting process.
One of the most useful tools in financial-statement automation is a mapping master.
Instead of manually deciding every year where a ledger belongs, maintain a controlled mapping table.
For example:
Ledger: HDFC Current Account
Mapped Head: Cash and Cash Equivalents or other appropriate cash/bank classification
Ledger: ABC Suppliers Pvt. Ltd.
Mapped Head: Trade Payables
Ledger: XYZ Customer Pvt. Ltd.
Mapped Head: Trade Receivables
Ledger: Office Rent
Mapped Head: Other Expenses
Ledger: Sales – Finished Goods
Mapped Head: Revenue from Operations
These examples are illustrative. Actual classification should be determined according to the company's facts and applicable accounting requirements.
Imagine a company has 800 ledgers.
Without mapping, the accountant may review hundreds of balances each year.
With a mapping master, most recurring ledgers can retain their reporting classification.
The finance team then focuses on:
New ledgers
Unmapped ledgers
Unusual balances
Reclassified balances
Material items
Changes in accounting treatment
Disclosure-sensitive accounts
This turns year-end preparation from repetitive classification into exception-based review.
The Balance Sheet is generally organized around equity and liabilities on one side and assets on the other, with the applicable Schedule III presentation.
Depending on the company's circumstances, major areas may include:
Equity
Share capital
Other equity/reserves and surplus as applicable
Non-current liabilities
Current liabilities
Non-current assets
Current assets
Supporting notes provide the detailed composition of these headings.
The applicable terminology and disclosures should always be checked against the prevailing statutory requirements.
The share capital note can require information beyond the closing ledger balance.
Depending on applicability, disclosures may involve matters such as:
Authorized share capital
Issued capital
Subscribed capital
Paid-up capital
Number of shares
Face value
Reconciliation of number of shares
Rights and restrictions
Shareholding information
Other prescribed disclosures
Not all of this information necessarily comes directly from the accounting ledger.
Some data may need to be maintained separately as part of the statutory reporting process.
Depending on the applicable reporting framework and presentation requirements, companies may need to provide details relating to reserves and accumulated results.
This may involve:
Opening balance
Current-year movement
Profit or loss for the year
Appropriations where applicable
Other adjustments
Closing balance
The financial-statement workbook should be designed so that movements reconcile properly with the Statement of Profit and Loss and other relevant information.
Borrowings often require detailed classification.
A company may have:
Bank term loans
Vehicle loans
Loans from directors
Other loans
Working-capital facilities
Secured borrowings
Unsecured borrowings
The accounting ledger tells you the amount.
Financial reporting may require additional information such as nature, classification and relevant disclosures.
Therefore, the mapping process may require metadata beyond the ledger name.
One of the most important Schedule III exercises is classifying assets and liabilities appropriately between current and non-current categories where required.
A ledger cannot always be classified correctly based solely on its name.
For example, a loan may have both:
An amount payable within the relevant current period
A longer-term outstanding portion
Similarly, advances, deposits and other balances may require assessment based on their nature and expected realization or settlement.
Automation can assist classification.
Professional judgement determines whether that classification is correct.
Trade payables generally arise from amounts due in respect of goods purchased or services received in the normal course of business.
But statutory reporting may require more than simply showing one total supplier balance.
Depending on the applicable requirements, companies may need further classifications and disclosures.
This is another reason why a simple trial-balance export is not necessarily sufficient for statutory financial statements.
Companies should pay particular attention to information required in relation to suppliers covered under applicable MSME provisions.
The accounts team may need to maintain appropriate vendor classification and supporting information.
If MSME status is not maintained correctly in the vendor master or supporting records, year-end disclosure preparation becomes much more difficult.
Good financial reporting begins with good master data.
Businesses may have balances such as:
Statutory dues payable
Employee-related liabilities
Expenses payable
Advances from customers
Other contractual liabilities
Current maturities or other items where applicable
Each balance should be reviewed according to its actual nature.
A generic ledger group should not automatically determine statutory classification.
Fixed assets are a significant reporting area for many companies.
Depending on the applicable requirements, supporting schedules may include information relating to:
Opening gross carrying amount
Additions
Disposals
Other adjustments
Depreciation
Accumulated depreciation
Closing carrying amount
Different asset classes
Examples of asset classes may include:
Land
Buildings
Plant and machinery
Furniture and fixtures
Vehicles
Office equipment
Computers
Electrical installations
The fixed-asset schedule should reconcile with the relevant general ledger balances.
Depreciation is a common source of differences between books and supporting schedules.
For example:
Fixed asset register shows one figure.
TallyPrime ledger shows another.
Excel schedule shows a third.
The finalisation process should contain control checks so these differences are identified before financial statements are issued.
A well-designed workbook can flag:
Fixed asset closing balance mismatch
Depreciation mismatch
Addition mismatch
Disposal mismatch
This is far safer than visually checking hundreds of cells.
Companies may hold:
Deposits
Investments
Loans and advances
Other financial or non-financial assets
The correct presentation depends on the applicable accounting framework, nature of the balance and Schedule III requirements.
These balances should be mapped after understanding what they represent rather than relying only on their ledger group in TallyPrime.
Trading and manufacturing companies may carry inventories such as:
Raw materials
Work-in-progress
Finished goods
Stock-in-trade
Stores and spares
Other inventory categories
The inventory figure appearing in the Balance Sheet should reconcile with supporting inventory records and the accounting treatment adopted by the company.
TallyPrime can provide inventory-related information where inventory is properly maintained.
Excel may then be used for statutory presentation and supporting reconciliation.
Trade receivables are often one of the largest Balance Sheet items for trading and service companies.
TallyPrime can maintain customer ledger balances and outstanding information.
However, statutory reporting may require additional analysis.
Depending on applicable requirements, the reporting process may need classifications based on factors such as:
Ageing
Disputed or undisputed status
Credit impairment or doubtful status where relevant
Other prescribed categories
This means the company needs more than a single "Sundry Debtors" number.
Ageing analysis can become particularly challenging when hundreds or thousands of customer invoices are outstanding.
A structured workflow should use invoice-level outstanding information where required rather than attempting to manually classify balances from a summary trial balance.
The Excel reporting layer can then organize the information into the required ageing categories.
The totals should reconcile back to the relevant ledger balances.
This reporting area may include applicable cash and bank balances according to the relevant classification.
Possible underlying ledgers may include:
Cash
Current bank accounts
Other eligible bank balances
The accounting records should reconcile with bank reconciliation processes and other supporting information.
Not every bank-related balance should automatically be treated identically; classification should follow applicable requirements.
Companies may have balances such as:
Prepaid expenses
Advances
Receivables other than trade receivables
Recoverable statutory balances
Employee advances
Other short-term assets
Again, the nature of the balance determines the presentation.
The mapping master should therefore contain meaningful classifications.
The Statement of Profit and Loss brings together income and expenditure for the reporting period.
Typical major areas may include:
Revenue from operations
Other income
Cost-related expenses
Employee benefits expense
Finance costs
Depreciation and amortisation
Other expenses
Tax expense
Profit or loss
The actual presentation depends on the company's operations and applicable requirements.
Revenue may arise from:
Sale of products
Sale of services
Other operating activities
A business may maintain dozens of sales ledgers in TallyPrime.
For example:
Local Sales 18%
Interstate Sales 18%
Local Sales 12%
Export Sales
Service Income
Installation Income
Maintenance Revenue
From an operational perspective, these ledgers may be useful.
For statutory reporting, they may need to roll up into the relevant revenue heads and supporting notes.
A mapping layer makes this possible without manually adding the same ledgers every year.
Other income may contain items such as:
Interest income
Discount received
Rental income
Profit on sale of assets
Other non-operating income
The correct classification depends on the nature of the transaction and applicable accounting requirements.
Do not simply map every credit-balance income ledger into revenue from operations.
For manufacturing and trading companies, the Statement of Profit and Loss may require appropriate presentation of:
Cost of materials consumed
Purchases of stock-in-trade
Changes in inventories
Other relevant cost categories
The accounting structure should allow these figures to be identified reliably.
If all purchases are posted into one generic ledger despite materially different business activities, financial-statement preparation becomes more difficult.
Employee-related expenses may include:
Salaries
Wages
Bonus
Employer contributions
Staff welfare
Other employee benefits
A mapping structure can consolidate multiple operational ledgers into the required reporting category while preserving detailed schedules for review.
Finance-related expenses may include applicable:
Interest expense
Borrowing-related costs
Bank finance charges
Other finance costs
Correct classification requires understanding the nature of each ledger.
For example, not every bank charge necessarily has the same financial-statement treatment as borrowing interest.
This note can contain a large number of ledgers.
Examples may include:
Rent
Electricity
Legal and professional charges
Audit fees
Repairs
Insurance
Printing and stationery
Travelling
Communication expenses
Software expenses
Office expenses
Selling expenses
Marketing expenses
Freight
Security expenses
The challenge is ensuring that every relevant expense ledger is included exactly once.
A controlled mapping table is particularly useful here.
The primary statements show summarized figures.
The Notes to Accounts provide the underlying detail and disclosures.
A financial statement may show:
Trade Receivables – ₹1.75 crore
The related note may explain how that amount is composed and provide required classifications.
This relationship is critical.
The primary statement and note must agree.
If the Balance Sheet says ₹1.75 crore while the supporting note totals ₹1.72 crore, the financial statements contain an internal inconsistency.
A strong Excel workbook should minimize repeated manual entry.
If Note 12 totals ₹1,75,00,000, the Balance Sheet should ideally reference the calculated note total rather than having somebody type ₹1,75,00,000 again.
Likewise, the Statement of Profit and Loss should draw values from the corresponding supporting notes where appropriate.
This creates a controlled chain:
TallyPrime Data
to
Mapping
to
Notes
to
Balance Sheet / Statement of Profit and Loss
This is much safer than manually entering the same number at each stage.
Financial statements generally include comparative information according to applicable requirements.
This means the workbook should be capable of maintaining:
Current year
Previous year
A structured design allows management and auditors to compare changes easily.
For example:
Trade Receivables
Current Year: ₹1.75 crore
Previous Year: ₹1.20 crore
Increase: ₹55 lakh
Such changes can also become useful analytical signals during review.
Suppose office expenses were ₹8 lakh last year and suddenly appear as ₹80 lakh this year.
Perhaps business activity changed dramatically.
Or perhaps an incorrect ledger was mapped.
Comparative analysis helps identify unusual movements that deserve investigation.
A financial-statement workbook can therefore include analytical checks such as:
Percentage change
Absolute movement
Unusual debit or credit balances
New ledgers
Missing prior-year ledgers
Unmapped accounts
A common automation risk occurs when a new ledger is created during the year.
Suppose the company creates:
Cloud Hosting Charges
If this ledger does not exist in the mapping master, the financial-statement workbook should not silently ignore it.
Instead, it should flag:
UNMAPPED LEDGER
This forces the finance team to review and classify the account.
Exception-based reporting is much safer than silent omission.
Not every ledger needs the same reporting attention.
Some accounts may have zero closing balances but relevant movements.
Others may be dormant.
The reporting workflow should determine whether information is required based on applicable disclosure rules and materiality rather than merely hiding every zero balance.
Financial statements may be presented using an appropriate unit of measurement based on applicable requirements and company circumstances.
For example, reporting may involve:
Rupees
Thousands
Lakhs
Crores
The selected presentation should be applied consistently.
Excel formulas can automate rounding and display while retaining detailed underlying numbers for reconciliation.
Rounding can create small apparent differences.
Suppose several note components individually round to the nearest lakh.
Their displayed total may differ slightly from a separately rounded underlying total.
The workbook should be designed to manage these differences consistently rather than manually adjusting random cells.
A robust reporting workbook should include automated controls.
Important checks can include:
Balance Sheet tally check
Trial balance mapping check
Unmapped ledger check
Duplicate mapping check
Note-to-primary-statement check
Current-year total check
Previous-year total check
Profit reconciliation
Fixed asset reconciliation
Receivables reconciliation
Payables reconciliation
Cash and bank reconciliation
Inventory reconciliation where relevant
Control checks transform Excel from a formatting tool into a financial-reporting control environment.
One of the most important controls is simple:
Every relevant trial-balance ledger should be mapped.
The workbook should calculate:
Total trial balance
Mapped total
Unmapped total
Difference
Ideally, unexplained differences should be zero before finalisation.
If a ledger has not been mapped, the system should identify it by name.
The profit reported in the Statement of Profit and Loss should reconcile with the accounting records after considering approved finalisation entries and the applicable reporting process.
If TallyPrime reflects one profit figure and the financial-statement workbook shows another, the difference needs to be explained.
Never hide the difference using a balancing figure.
Auditors may propose year-end adjustments relating to areas such as:
Depreciation
Provisions
Accruals
Prepayments
Tax
Expenses
Revenue recognition
Classification
Prior-period matters where applicable
The preferred workflow is generally to ensure approved accounting adjustments are properly reflected in the books or otherwise handled through a clearly controlled finalisation process.
The final TallyPrime data and statutory financial statements should not develop unexplained differences.
This is one of the most important controls.
Suppose TallyPrime shows:
Professional Fees: ₹12 lakh
But somebody manually changes the Excel note to:
Professional Fees: ₹10 lakh
Now the financial statements no longer reflect the accounting system.
If there is a valid adjustment, it should follow the company's approved accounting and finalisation process.
Uncontrolled manual overrides weaken the audit trail.
Financial-statement workbooks often contain hundreds of formulas.
An employee can accidentally overwrite one formula with a hardcoded number.
The workbook may still look correct.
But next year, or after another adjustment, the error becomes visible.
Where appropriate, formula cells can be protected while controlled input areas remain editable.
This helps reduce accidental changes.
Ledger mapping should not be treated as permanent without review.
Businesses change.
A ledger classified one way last year may require reassessment if its nature changes.
Therefore, before annual financial-statement preparation:
Review new ledgers.
Review material balances.
Review unusual balances.
Review current/non-current classification.
Review statutory disclosure requirements.
Review previous-year mappings.
Automation accelerates the process.
Professional review validates it.
A practical process can be structured as follows:
Finalize the accounting period in TallyPrime.
Review ledger balances.
Complete necessary reconciliations.
Obtain the trial balance and required detailed reports.
Load or transfer data into the controlled Excel reporting workbook.
Apply the Schedule III mapping master.
Review unmapped and exception ledgers.
Prepare supporting schedules.
Review current/non-current classifications.
Update applicable disclosures.
Link note totals to primary statements.
Perform comparative analysis.
Run control checks.
Review with management and auditors.
Post approved adjustments appropriately.
Refresh or update the reporting workbook.
Complete final validation.
This approach reduces repetitive work while maintaining control.
Some business owners operate multiple private limited companies.
If each entity maintains a similar chart of accounts, a standardized mapping framework can reduce financial-statement preparation time significantly.
However, each company must still be reviewed independently.
Different companies may have:
Different loans
Different shareholders
Different related parties
Different assets
Different disclosures
Different accounting policies
Different material balances
Templates create consistency.
They do not remove entity-specific judgement.
A structured TallyPrime-to-Excel Schedule III workflow can benefit:
Company accountants
Finance managers
Chartered accountants
Auditors
Directors
Management
Potential improvements include:
Faster financial-statement preparation
Reduced manual copying
Better traceability
Fewer formula errors
Consistent classifications
Faster audit queries
Simpler comparative reporting
Better exception identification
Stronger reconciliation
Reusable year-to-year mapping
When every financial-statement figure can be traced through a clear chain, audit review becomes easier.
For example:
Balance Sheet
Trade Receivables ₹1.75 crore
links to
Note 14
which links to
Mapped customer balances
which reconcile to
TallyPrime
This is much easier to review than a workbook containing manually entered totals with no clear source.
Financial-statement automation does not eliminate supporting documentation.
Companies may still require records such as:
Bank statements
Loan statements
Fixed asset register
Inventory records
Customer confirmations
Supplier confirmations
Tax records
Statutory filings
Agreements
Board records
Share capital records
Related-party information
Other supporting schedules
Accounting data provides the numbers.
Supporting documents help establish their validity.
Schedule III reporting is primarily a statutory financial-reporting exercise, but the underlying structured data can also support management analysis.
For example:
Revenue growth
Gross margin movement
Employee cost trends
Finance cost trends
Receivable growth
Inventory movement
Borrowing levels
Working-capital changes
Expense ratios
Once financial data is structured properly, management can obtain more value from it.
A common misunderstanding is that Schedule III compliance means taking an ordinary Balance Sheet and changing the headings.
It is more than formatting.
Proper reporting can involve:
Classification
Presentation
Disclosures
Comparatives
Ageing information where applicable
Supporting notes
Cross-references
Materiality assessment
Accounting-policy considerations
Statutory requirements
This is why professional review remains essential even when much of the workbook is automated.
A small company with 50 ledgers may prepare statements manually without major difficulty.
A growing company may have:
500 ledgers
2,000 customers
1,000 suppliers
Multiple banks
Several loans
Hundreds of fixed assets
Large inventories
Multiple branches
Manual financial-statement preparation becomes increasingly difficult at this scale.
Automation provides scalability.
The finance team spends less time copying figures and more time reviewing their meaning.
For many accountants, year-end financial-statement preparation is stressful because every late adjustment can create a chain reaction.
One number changes in TallyPrime.
Then the trial balance changes.
Then the note changes.
Then the Balance Sheet changes.
Then the comparative analysis changes.
When these files are manually maintained, every adjustment creates another opportunity for error.
A properly linked reporting workflow changes that experience.
One approved accounting adjustment can flow through the mapped reporting structure, while controls identify anything that no longer reconciles.
The result is not just speed.
It is confidence.
Preparing Schedule III Division I financial statements requires much more than exporting a Balance Sheet from accounting software and changing a few headings in Excel.
Companies in Rajouri Garden, Janakpuri and other business centres need a controlled process that connects their underlying books with the statutory presentation of the Balance Sheet, Statement of Profit and Loss and Notes to Accounts.
TallyPrime can provide the accounting foundation, while Excel can serve as a flexible statutory reporting layer for mapping, schedules, disclosures, comparisons and control checks.
The most effective workflow creates a clear chain from ledger balances to reporting heads, from reporting heads to Notes to Accounts, and from those notes to the primary financial statements.
This reduces repeated data entry and makes late adjustments easier to manage.
However, automation does not replace professional judgement. Current and non-current classification, disclosure requirements, ageing, borrowings, related-party information, MSME-related information and other statutory matters must be reviewed according to applicable requirements and the company's circumstances.
The goal is not simply to produce a Balance Sheet faster.
The goal is to produce financial statements that are structured, traceable, internally consistent and easier to review.
For companies and finance teams preparing year-end accounts in 2026, combining disciplined TallyPrime accounting with a controlled Excel Schedule III reporting process can turn a stressful manual exercise into a far more systematic financial-close workflow.
Continue Here >>
Continue Here >>
Continue Here >>
