The CA's Guide to Cash Flow Statement Preparation Under Schedule III

Why Cash Flow Is the Most Error-Prone Statement

Among the four primary financial statements (Balance Sheet, Profit & Loss, Cash Flow, and Statement of Changes in Equity), the Cash Flow Statement consistently generates the highest error rate in Indian statutory filings. In our survey of 40 mid-size CA firms, Cash Flow was cited as the primary cause of auditor queries and restatement requests by 68% of respondents.

The reasons are structural, not a reflection of professional capability:

1. It requires two Trial Balances — current and prior year. Many firms discover data gaps only when they attempt the Cash Flow computation.
2. The indirect method is inherently complex — it reconstructs cash movements from accrual-basis financial statements, requiring multiple adjustment layers.
3. Classification judgement is required — the same transaction (e.g., repayment of a vehicle loan) can be classified as operating, investing, or financing depending on its nature.
4. Sign conventions are counterintuitive — an increase in trade receivables (a debit balance increasing) is a cash outflow, which is expressed as a negative number in the working capital section.

This guide provides a systematic walkthrough of the indirect method under AS-3 and Ind AS 7, with specific attention to the error-prone areas.

Prerequisites: What You Need Before Starting

The Cash Flow Statement cannot be prepared from a single Trial Balance. You need:

1. Current period Trial Balance — the same TB used to generate the Balance Sheet and P&L
2. Prior period Trial Balance — to compute working capital changes and identify asset/liability movements
3. Profit Before Tax — from the current period P&L (the starting point for the indirect method)
4. Supplementary data (optional but recommended):

- Fixed asset register (for accurate investing activity detail) - Loan register (for accurate financing activity detail) - Tax payment details (for actual tax paid vs tax expense) Without the prior period TB, Cash Flow cannot be prepared. This is a hard prerequisite. If the prior year data is in a different accounting system or format, it must be normalised before Cash Flow computation begins.

The Indirect Method: Step by Step

Step 1: Start with Profit Before Tax

The indirect method begins with Profit Before Tax (PBT) from the Profit & Loss Statement. Not profit after tax — the tax adjustment is handled separately in the operating activities section.

Common error: Starting with Profit After Tax and then adding back tax expense separately. While mathematically equivalent, this is not the prescribed format under AS-3/Ind AS 7 and may trigger auditor comments.

Step 2: Operating Adjustments (Non-Cash Items)

Add back or subtract non-cash items that were included in PBT but did not involve cash movement:

Add back (increase cash from operations):

• Depreciation and amortisation
• Impairment losses
• Provisions (increase in provisions)
• Unrealised foreign exchange losses
• Loss on sale/disposal of fixed assets
• Bad debts written off
• Interest expense (if classified as financing activity)

Subtract (decrease cash from operations):

• Gain on sale/disposal of fixed assets
• Unrealised foreign exchange gains
• Interest income (if classified as investing activity)
• Dividend income (if classified as investing activity)

Common error: Forgetting to reverse interest income and interest expense. Under AS-3, there is flexibility in classifying interest — it can be operating, investing, or financing. But whichever classification is chosen, the item must be reversed from operating activities and shown in the appropriate section. Under Ind AS 7, interest paid is typically financing and interest received is typically investing.

Step 3: Working Capital Changes

This is the section where most errors occur. Working capital changes represent the cash effect of movements in current assets and current liabilities.

The computation logic:

For current assets (trade receivables, inventories, other current assets, prepaid expenses):

• Increase in current asset = cash outflow (negative)
• Decrease in current asset = cash inflow (positive)

For current liabilities (trade payables, other current liabilities, provisions):

• Increase in current liability = cash inflow (positive)
• Decrease in current liability = cash outflow (negative)

The sign convention trap: The most common Cash Flow error is getting the sign wrong on working capital changes. The intuition is straightforward — if you sold goods on credit (increasing receivables), you did not receive cash, so it is an outflow. But in practice, when computing from two Balance Sheets, the sign can be confusing.

The formula:

• Change in current asset: Prior year balance MINUS Current year balance (a positive result means the asset decreased, which is a cash inflow)
• Change in current liability: Current year balance MINUS Prior year balance (a positive result means the liability increased, which is a cash inflow)

Step 4: Tax Paid

Cash paid for income tax is shown as a separate line item under operating activities. This is:

• Not the same as tax expense in the P&L (which includes deferred tax)
• Ideally sourced from actual tax payment records (advance tax + TDS)
• If actual data is unavailable, estimated as: Opening tax liability + Tax expense (current year) - Closing tax liability

Common error: Using tax expense from the P&L instead of actual tax paid. Deferred tax is a non-cash item and must not be included in Cash Flow.

Step 5: Operating Cash Flow

Operating Cash Flow = PBT + Operating Adjustments + Working Capital Changes - Tax Paid

This subtotal is the first major checkpoint. Compare it against expectations — a profitable company with stable working capital should generally have positive operating cash flow.

Step 6: Investing Activities

Investing activities capture cash flows from the purchase and sale of long-term assets:

• Purchase of property, plant & equipment
• Sale proceeds from disposal of fixed assets
• Purchase of investments
• Sale/redemption of investments
• Interest received (if classified as investing)
• Dividend received (if classified as investing)

With supplementary data (fixed asset register, investment register): Use the actual purchase and sale amounts from the registers. This gives accurate, auditable figures. Without supplementary data: Estimate from Balance Sheet movement. Change in gross block = net purchases. This is less accurate because it does not distinguish between purchases, sales, revaluations, and transfers. The Cash Flow Statement should annotate estimated figures with a note.

Step 7: Financing Activities

Financing activities capture cash flows from changes in the company's capital structure:

• Proceeds from issue of shares
• Proceeds from long-term borrowings
• Repayment of long-term borrowings
• Proceeds from/repayment of short-term borrowings (net)
• Interest paid (if classified as financing)
• Dividend paid

With supplementary data (loan register, share capital records): Use actual drawdown and repayment amounts. Without supplementary data: Estimate from Balance Sheet movement. Change in borrowings = net proceeds/repayments. Again, this conflates new borrowings with repayments and should be annotated.

Step 8: Net Cash Flow and Reconciliation

Net Cash Flow = Operating + Investing + Financing

The reconciliation check: Opening Cash and Cash Equivalents + Net Cash Flow = Closing Cash and Cash Equivalents

This reconciliation must tie to the Balance Sheet. The tolerance is minimal — under Indian practice, a difference of up to Rs. 1 (due to rounding) is acceptable. Any larger difference indicates an error in the computation.

Common error: Including fixed deposits with maturity greater than 3 months in "Cash and Cash Equivalents". Only deposits with original maturity of 3 months or less qualify as cash equivalents under both AS-3 and Ind AS 7.

Supplementary Disclosure Requirements

Beyond the three-section format, the Cash Flow Statement requires supplementary disclosures:

1. Components of cash and cash equivalents — Reconcile to Balance Sheet line items
2. Restricted cash — Bank balances held as margin money, under lien, or in dividend accounts
3. Non-cash transactions — Significant investing/financing transactions that did not involve cash (e.g., conversion of debt to equity, acquisition via share exchange)
4. Bank overdrafts — If included in cash equivalents (must be repayable on demand and form an integral part of cash management)

How Automation Addresses Cash Flow Complexity

The Cash Flow Statement's complexity arises from three sources: data dependency (two TBs required), computational logic (multi-layered adjustments), and classification judgement (operating vs investing vs financing).

ThynkFile addresses each layer. When both current and prior period Trial Balances are uploaded, the system computes working capital changes automatically with correct sign conventions. Each taxonomy node carries a pre-assigned cash flow category (operating adjustment, working capital, investing, or financing), ensuring consistent classification. When supplementary data like fixed asset registers or loan schedules is available, the system uses itemised data; when it is not, it falls back to Balance Sheet movement estimates with clear annotations.

The reconciliation check (opening cash + net cash flow = closing cash) runs automatically, flagging any variance beyond Rs. 1. For most companies, the Cash Flow Statement generates in seconds rather than the 2-4 hours typical of manual preparation.