Cash Flow Statement or Computerised Accounts - II

A Cash Flow Statement (CFS) is a periodic financial statement that exhibits the inflows (receipts) and outflows (payments) of cash and cash equivalents of an enterprise during a given accounting period, classified into Operating, Investing, and Financing activities. In India, preparation and presentation of Cash Flow Statements are governed by Accounting Standard 3 (AS-3 Revised) issued by the ICAI and Section 2(40) of the Companies Act, 2013, which includes the Cash Flow Statement as an integral part of a company's financial statements (exempting only One Person Companies, Small Companies, and Dormant Companies).

• Assessment of Cash Generation Ability: To provide objective insight into the firm's capacity to generate net positive cash flows from its core operating activities to sustain and expand business operations.
• Evaluating Liquidity and Solvency: To appraise the enterprise's ability to meet immediate short-term obligations (creditors, bills payable) and service long-term debt (debentures, bank loans) without asset distress sales.
• Analyzing Causes of Divergence: To explain why net profit reported in the Statement of Profit and Loss differs substantially from the net change in cash and cash equivalents during the year.
• Facilitating Financial Planning & Budgeting: To assist corporate management in drafting realistic cash budgets, planning capital expenditures, and determining sound dividend distribution policies.
• Verification of Prior Projections: To evaluate the accuracy of previous cash flow forecasts and benchmark cash performance against industry competitors.

• Cannot Substitute Profit & Loss: Cash flow ignores non-cash revenues and expenses; hence, it cannot measure true business profitability or long-term financial health.
• Historical Nature: Being drafted from past financial statements, it reports historical cash movements rather than projected liquidity unless accompanied by a cash budget.
• Potential for Window Dressing: Management may deliberately postpone supplier payments or capital asset purchases at year-end to project an artificially inflated operating cash balance.

Under AS-3 (Revised), cash flows comprise inflows and outflows of Cash and Cash Equivalents. Movements between items that constitute cash or cash equivalents are part of cash management rather than operating, investing, or financing activities (e.g., cash deposited into bank, cash withdrawn from bank, purchase of treasury bills with cash).

• Cash: Comprises cash in hand and demand deposits with banks (e.g., current account and savings account balances).
• Cash Equivalents: Highly liquid short-term investments that satisfy three mandatory criteria:
  1. Readily convertible into known amounts of cash.
  2. Subject to an insignificant risk of changes in value.
  3. Possess a short maturity of three months (90 days) or less from the date of acquisition.
  Examples: Treasury Bills, Commercial Paper, Short-term Government Securities, Call/Notice Money, Short-term Mutual Fund Liquid Schemes.

Under the Indirect Method (the sole method prescribed in Class 12 curricula), Net Profit before Tax and Extraordinary Items is adjusted for the effects of transactions of a non-cash nature, any deferrals or accruals of past or future operating cash receipts or payments, and items of income or expense associated with investing or financing cash flows.

Working capital changes isolate cash trapped or released in current operational assets and liabilities (excluding Cash and Cash Equivalents, and Bank Overdraft/Short-term loans which belong to Financing):

• ADD (+): Decrease in Current Assets (e.g., decrease in Trade Receivables, Inventories, Prepaid Expenses) ➔ Cash inflow / liquidation.
• ADD (+): Increase in Current Liabilities (e.g., increase in Trade Payables, Outstanding Expenses) ➔ Cash saved by postponing payment.
• LESS (-): Increase in Current Assets (e.g., increase in Trade Receivables, Inventories) ➔ Cash blocked in operations.
• LESS (-): Decrease in Current Liabilities (e.g., decrease in Trade Payables, Outstanding Expenses) ➔ Cash paid to clear liabilities.

Sections B and C of the Cash Flow Statement record the movement of funds related to capital expenditure, asset realization, equity capital changes, and corporate borrowing contracts.

Investing activities represent expenditures made for resources intended to generate future income and cash flows.

Financing activities are activities that result in changes in the size and composition of the owner's capital (including preference share capital) and borrowings of the enterprise.

In Class 12 board examinations, students are required to draft subsidiary ledger accounts to uncover hidden cash flows for fixed asset purchases, tax payments, and depreciation charges.

When assets are maintained at original cost and a separate Provision for Depreciation (Accumulated Depreciation) Account is maintained:

Under AS-4 (Revised) 'Contingencies and Events Occurring After the Balance Sheet Date':

• Dividend proposed for the current financial year is not a liability until approved by shareholders in the Annual General Meeting (AGM). Hence, current year proposed dividend is a contingent liability disclosed only in Notes to Accounts; it has zero impact on the current year's Cash Flow Statement.
• Dividend proposed for the previous financial year (which was approved in the current year's AGM) is:
  1. Added to Net Profit to determine Net Profit Before Tax and Extraordinary Items in Operating Activities.
  2. Deducted as a Cash Outflow under Financing Activities.

In modern business environments, manual preparation of cash flow statements has been superseded by Computerised Accounting Systems (CAS - II), combining Relational Database Management Systems (RDBMS) for transaction storage and Electronic Spreadsheets for dynamic modeling.

• Entities and Tables: Fundamental accounting components are modeled as database tables (e.g., Chart_of_Accounts, Voucher_Header, Voucher_Details).
• Keys in Accounting Databases:
  • Primary Key (PK): A unique identifier for every record in a table (e.g., Voucher_Number, Account_Code).
  • Foreign Key (FK): A field in one table that links to the primary key in another table (e.g., Account_Code in the voucher line items referencing the chart of accounts).
• SQL Queries for Financial Reports:

  SELECT Account_Name, SUM(Debit_Amount - Credit_Amount) AS Net_Balance
  FROM Voucher_Details
  JOIN Chart_of_Accounts ON Voucher_Details.Account_Code = Chart_of_Accounts.Account_Code
  WHERE Activity_Type = 'Operating'
  GROUP BY Account_Name;

• Role-Based Access Control (RBAC): Restricting voucher creation, authorization, and report generation to designated personnel via unique biometric/password credentials.
• Audit Trail (Edit Log): Under the revised Companies (Accounts) Rules 2014, accounting software must maintain an indelible edit log recording every change made to books of accounts with timestamps and user IDs.
• Automated Data Validation: Input masks and logical validation rules (e.g., Total Debits must equal Total Credits before voucher posting) preventing human entry errors.