Cash Flow Statement Tutorial in Ratals ERP: Indirect Method Explained

Rob Cuppett Author: Rob Cuppett

The Cash Flow Statement is one of the most important financial reports for understanding your business's liquidity. It shows how cash moves in and out of your organization during a specific period. In Ratals ERP, the report uses the Indirect Method, reconciling net income with changes in cash from operating, investing, and financing activities.

In this tutorial, we will cover:

What is the Indirect Method?

The Indirect Method starts with net income from the Income Statement and adjusts for non-cash transactions, changes in working capital, and other adjustments to arrive at net cash provided by or used in operating activities. This method helps users understand the relationship between profit and actual cash movement.

Accessing the Cash Flow Statement

To access the Cash Flow Statement in Ratals ERP:

  1. Navigate to: Admin > Accounting > Financial Statements > Cash Flow Statement.
  2. Choose a reporting period by entering a From Date and To Date.
  3. Click Search to populate the report.

Understanding the Report Layout

The report is divided into three main sections, reflecting the types of cash flows:

  • Operating Activities - Cash generated or used by core business operations.
  • Investing Activities - Cash used to acquire or received from selling long-term assets.
  • Financing Activities - Cash related to owner contributions, loans, repayments, and distributions.

Each section lists line items for individual accounts along with the associated cash impact. At the bottom, the report summarizes:

  • Net Increase/Decrease in Cash
  • Beginning Cash Balance
  • Ending Cash Balance

Account Cash Flow Category Importance

The report determines which accounts belong to each section based on the Cash Flow Category assigned to each account. Make sure each account is categorized correctly:

  • Cash Activities → Cash Flow Category = Cash
  • Operating Activities → Cash Flow Category = Operating
  • Investing Activities → Cash Flow Category = Investing
  • Financing Activities → Cash Flow Category = Financing

Correct Account Type by Cash Flow Category

Accounts must have the correct Account Type for the Cash Flow calculation to work properly. Here's the full mapping:

  • If Cash Flow Category = Cash → Account Type = Assets (including Contra Accounts)
  • If Cash Flow Category = Operating → Account Type = Revenue or Expenses (including Contra Accounts)
  • If Cash Flow Category = Investing → Account Type = Assets (including Contra Accounts)
  • If Cash Flow Category = Financing → Account Type = Liabilities or Equity (including Contra Accounts)

Because Ratals calculates cash flow in real time, any changes to Cash Flow Category or Account Type will be reflected immediately when the report is refreshed.

To Ensure Your Cash Flow Report is Accurate

  1. Navigate to Admin > Accounting > Bookkeeping > All Chart of Accounts.
  2. Expand each main account by clicking "Sub Item(s)" to view all accounts under categories like Assets, Liabilities, Equity, etc.
  3. Click "Edit" on each account and verify that the Cash Flow Category correctly reflects the type of activity it represents.
  4. Ensure accounts that affect cash balances (such as bank or cash accounts) are assigned the Cash category.
  5. Confirm that the Account Type matches the proper section logic (Operating, Investing, Financing) as outlined above.

Step-by-Step Calculation: Operating Activities

Operating Activities begin with Net Income from the Income Statement. Since net income includes non-cash items, the system adjusts for changes in asset and liability accounts:

  • Asset increases reduce cash (e.g., inventory purchases, accounts receivable increases).
  • Liability or equity increases increase cash (e.g., accounts payable increases).
  • Non-cash items like depreciation or amortization are included in Net Income but do not affect cash directly; they remain part of net income.

Ratals ERP calculates Operating Activities by:

  1. Summing Net Income from revenue and expense accounts.
  2. Adjusting for asset and liability account changes based on "Account Type" and "Period Date Range Searched".
  3. Summing all adjustments to produce Net Cash from Operating Activities.

Important: Only accounts with Cash Flow Category = Operating and Account Type = Revenue or Expenses (including Contra Accounts) are included in the calculation.

Step-by-Step Calculation: Investing Activities

Investing Activities reflect cash movements related to long-term assets:

  • Cash outflows for asset purchases are recorded as negative amounts.
  • Cash inflows from asset sales are recorded as positive amounts.
  • Each account within the Investing section is summed to produce Net Cash from Investing Activities.

Important: Only accounts with Cash Flow Category = Investing and Account Type = Assets (including Contra Accounts) are included in the calculation.

Step-by-Step Calculation: Financing Activities

Financing Activities track cash flows related to company financing:

  • Increases in equity or liabilities are treated as inflows.
  • Decreases in equity or liabilities are treated as outflows.
  • The system sums these movements to produce Net Cash from Financing Activities.

Important: Only accounts with Cash Flow Category = Financing and Account Type = Liabilities or Equity (including Contra Accounts) are included in the calculation.

Calculating Beginning and Ending Cash Balance

Ratals ERP determines the starting point for cash as the sum of all Cash accounts before the selected reporting period. This becomes the Beginning Cash Balance:

The report then adds the net changes from Operating, Investing, and Financing Activities to calculate the Ending Cash Balance:

  • Net Increase/Decrease in Cash = Operating + Investing + Financing cash flows
  • Ending Cash Balance = Beginning Cash Balance + Net Increase/Decrease in Cash

Example Calculation

Suppose your company has the following:

  • Net Income: $10,000
  • Depreciation: $2,000
  • Inventory increased by $1,500
  • Accounts Payable increased by $1,200
  • Purchased equipment for $3,000
  • Owner contributed $5,000 in cash

Using Ratals ERP's indirect method and assuming Beginning Cash Balance = $5,000:

  1. Net Cash from Operating Activities = 10,000 + 2,000 - 1,500 + 1,200 = $11,700
  2. Net Cash from Investing Activities = -$3,000
  3. Net Cash from Financing Activities = +$5,000
  4. Net Increase in Cash = 11,700 - 3,000 + 5,000 = $13,700
  5. Ending Cash Balance = 5,000 + 13,700 = $18,700

How to Interpret the Cash Flow Statement

  • Compare Net Cash from Operating Activities to Net Income to assess quality of earnings.
  • Monitor cash used for investing to understand asset acquisition trends.
  • Evaluate financing activities to see how capital structure changes impact cash.
  • Use the Ending Cash Balance to assess liquidity and plan for short-term obligations.

Tips for Users

  • Ensure all accounts are categorized correctly with Cash Flow Category and Account Type.
  • Regularly reconcile Cash accounts to bank statements to ensure accuracy.
  • When entering transactions, ensure dates are correct; Cash Flow calculations depend on From Date and To Date.
  • Use consistent rounding and decimal precision (Ratals defaults to 6 decimals for internal calculations).

By following these steps, your Cash Flow Statement in Ratals ERP will accurately reflect your company's cash movements for the selected period.

Frequently Asked Questions

What is the Cash Flow Statement?

The Cash Flow Statement is a financial report that shows how cash enters and leaves your business over a specific period. It helps you understand liquidity, cash management, and the impact of business activities on cash balances.

What is the Indirect Method?

The Indirect Method starts with net income from the Income Statement and adjusts for non-cash transactions, changes in working capital, and other adjustments to calculate net cash from operating activities. This method helps link reported profit to actual cash movements.

How do I access the Cash Flow Statement in Ratals ERP?

Navigate to Admin > Accounting > Financial Statements > Cash Flow Statement, select your reporting period using From Date and To Date, and click Search to generate the report.

Why are Cash Flow Categories important?

Cash Flow Categories determine which section of the report an account appears in (Operating, Investing, Financing, or Cash). Correct categorization ensures that cash inflows and outflows are reported accurately.

Should contra accounts be included in the Cash Flow Statement?

Yes. Contra accounts are included in the Cash Flow Statement because they affect the net cash movement and are part of the Account Type mapping for Operating, Investing, and Financing activities.

How does Ratals ERP calculate Operating Activities?

Operating Activities calculation starts with Net Income, adjusts for changes in asset and liability accounts, and includes non-cash items such as depreciation and amortization. Only accounts with Cash Flow Category = Operating and correct Account Type (Revenue, Expenses, or their contra accounts) are included.

How are Investing Activities calculated?

Investing Activities sum cash inflows from asset sales and outflows from asset purchases for accounts categorized under Investing. Only accounts with Cash Flow Category = Investing and Account Type = Assets (including contra accounts) are included.

How are Financing Activities calculated?

Financing Activities sum cash inflows from equity or liability increases and outflows from equity or liability decreases for accounts categorized under Financing. Only accounts with Cash Flow Category = Financing and Account Type = Liabilities or Equity (including contra accounts) are included.

How is the Beginning and Ending Cash Balance determined?

Beginning Cash Balance is the sum of all Cash accounts before the reporting period. Ending Cash Balance is calculated as Beginning Cash + Net Cash from Operating, Investing, and Financing Activities.

Can I update account categories or add journal entries and see immediate changes?

Yes. Ratals ERP calculates cash flow in real-time, so any changes to Cash Flow Category, Account Type, or Journal Entries are reflected immediately when the report is refreshed.

What is a good way to interpret the Cash Flow Statement?

Compare Net Cash from Operating Activities to Net Income to assess quality of earnings, review investing and financing trends to understand cash use, and use the Ending Cash Balance to evaluate liquidity and plan for short-term obligations.

Rob Cuppett
About the Author
Rob Cuppett is the founder and lead engineer behind Ratals, bringing over 20 years of experience in digital marketing, software development, and business automation. He shares expert tutorials, practical guides, and insights to help business owners optimize, customize, and fully leverage software solutions to grow their businesses efficiently.
0 Comments
Post a New Comment
This site uses cookies to deliver its services and to analyze traffic. Learn more on our Cookie Policy and Privacy Policy.