Cash Flow Statement Tutorial in Ratals ERP: Indirect Method Explained
Author: Rob CuppettPosted On: Oct. 02, 2025Last Updated: Oct. 03, 2025
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.
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.
Choose a reporting period by entering a From Date and To Date.
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:
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
Navigate to Admin > Accounting > Bookkeeping > All Chart of Accounts.
Expand each main account by clicking "Sub Item(s)" to view all accounts under categories like Assets, Liabilities, Equity, etc.
Click "Edit" on each account and verify that the Cash Flow Category correctly reflects the type of activity it represents.
Ensure accounts that affect cash balances (such as bank or cash accounts) are assigned the Cash category.
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:
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:
Summing Net Income from revenue and expense accounts.
Adjusting for asset and liability account changes based on "Account Type" and "Period Date Range Searched".
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:
Net Cash from Operating Activities = 10,000 + 2,000 - 1,500 + 1,200 = $11,700
Net Cash from Investing Activities = -$3,000
Net Cash from Financing Activities = +$5,000
Net Increase in Cash = 11,700 - 3,000 + 5,000 = $13,700
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 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.
About Ratals
Rob Cuppett is the visionary founder and lead engineer behind Ratals Inc., the groundbreaking software platform designed to revolutionize how businesses operate.
Rob's journey into the digital world began in 2001, during a time when resources on starting...