Description
A Cash Flow Report is an essential financial document that provides a detailed overview of the cash inflows and outflows within a business over a specific period. This report is crucial for understanding how a company generates and utilizes its cash, offering insights into its operating, investing, and financing activities. Select the Cash Flow report type in the Reports section and adjust report configurations and layouts to produce cash flow reports.
Table of Contents
Report Configurations
Column Format - Standard or Comparative, meaning you can compare two distinct periods or just one period from Start Date to End Date.
Edit Layout - Open the Report Edit Layout section to control naming conventions, and account groupings for your custom Cash Flow report.
Location - Location to include journal lines from (pulls from the Location Picker by default).
Start Date - Journal line data after and including this date (defaults to start of the fiscal year based on
End Dateset).End Date - Journal lines data up to and including this date (defaults to date picker date if not set).
Journal Status - Include
all,posted, ordraftonly journal lines for balances in report.Column Type - For Comparative formats, choose Month, Quarter, or Year.
Report Structure
Layout
The Cash Flow report in SoftLedger is broken down by the high level sections of operating, investing, and financing activities that impact cash positions.
Cash Flow reports have three types of columns:
Headers - Text titles only and don't contain balances.
Account balances - A list of one or more Ledger Accounts with each account balance displayed.
Summary Rows - A summation of the account balances within the section.
The Ending Cash Balance row is custom to the Cash Flow report and is the summation of the varying cash activity (operating, investing, and financing summations above).
For Comparative reports, Column balances are NOT cumulative. Each column's balance includes journal lines for that month only, with the exception of the Starting Cash Balance (this is the balance of accounts up until and exclusive of the start date).
Calculations within Report Structure
The Cash Flow Report contains the following sections and subsections that have specific calculations inherent to cash flow reporting:
Net Cash Change
This calculation includes Operating Activities, Investing Activities, and Financing Activities. All balances in this section are the SUM of activity for the accounts specified between and inclusive of the start and end date from those activity sections.
Operating Activities - Net Operating Income(LOSS)
This calculation includes Current Period Income, which is a calculated value of all Revenue and Expense Type Ledger Account journal lines between and inclusive of the start and end date.
Starting Cash
This calculation should include all Ledger Accounts under the Cash Report Group. The balance is determined as the SUM of all Ledger Account balances before the start date.
Exports
Cash Flow report can be exported as a Detailed view (with all Ledger Account balances) or as a Summary view (with only the total section balances).
Detailed view:
Summary view:
