Cash flow
Cash flow report can be used to forecast and observe the cash situation based on the balance sheet and balance changes.
Cash flow report is found in Reports > Accounting reports.
By default, the report includes the following account groups and their accounts:
190, 191, 170, 175, 287, 292.
Accounts shown in Cash flow report can be edited with Report formulas.
Buttons in the upper section of the view
Run report button forms the report according to the search criteria.
Clear button removes given search criteria. It is also possible to choose Restore default search conditions from the arrow icon next to the Clear button.
Report formulas button is used to go to Report formulas view that is used to edit the accounts shown on the report. More information about report formulas here.
Search criteria
Accounting report type: Cash flow is chosen from this drop-down menu.
Receipt date: these fields are used to set the time interval of the report. By default, Procountor proposes the first day of the open financial year as the start date.
Report length: this drop-down menu is used to choose report length among four different options: Default, Brief, All account groups, All accounts.
Presentation type: this drop-down menu has several options that can be used to change the presentation type. Default option is Total sum for selected period.
Show percentage of the cash revenue: this option includes a percentage of cash receipts and cash disbursements in relation to the funds in the search results.
Receipt status: this drop-down menu is used to choose Business transactions or Non-business transactions to be included in the report. It is also possible to choose both or just one specific status.
Presentation options:
Show rows with zero values: this selection includes possible rows with zero values to the results.
Hide creator in exports : this selection removes the creator’s information from the report.
Hide company ID in exports
Hide search options in exports
Comparison data to be shown:
Budget: only an option, if the budget has been imported to Procountor
Comparison period: when this selection is activated, a new section becomes visible in the search criteria. The new section includes settings about the comparison period.
More Options menu gives a list of additional search criteria. For cash flow, the available search criteria are:
Receipt type
This search criterion defines the type(s) of receipt(s) to be included on the report.
Receipt currency
This search criterion narrows the search results to invoices in the specified currency.
Receipt Name
This criterion narrows the search only to receipts that are named with the content given in the Name field. The search can be done with the entire name or only with a part of it.
Customer's Company ID
This option narrows the search to a specific company ID. The company ID can be filled out in its entirety or only partly, either with the country code and hyphen or without them.
Entry period (yyyy-mm)
This search criterion narrows down the entry period of receipts according to the month. If both the date and the entry period have been given, the report searches for receipts according to the shorter time period: for example, if the Receipt date field has the dates 01.10.2019-30.11.2019 and the Entry period is set as 2019-11 – 2019-12, the search results will include receipts from Nov 1 to Nov 30 2019 on the report.
Transaction value
This narrows down the search according to the accounting value. The search is conducted in the accounting value column. Multiple values can be searched using <and> between them.
Report language
This defines the report language. The language selected by default is the language chosen in Management > Company info > Basic info as Company’s language.
If English or Swedish is chosen as a report's language, Procountor retrieves the translated version of the default account chart.
The selected report language defines the reports language.
Report currency
This selection defines the currency on the report.
Number format
This defines the rounding of the numbers on the report.
By default, the values are rounded to two decimal places.
Dimensions
Adding this search criterion brings only entries allocated to a certain item or items of a specific dimension.
Dimensions drop-down has a list of all the dimensions. Only one dimension can be selected for the report, meaning that several different dimensions cannot be selected on the same report.
Items field shows all the items belonging to the selected dimension. One or more of these can be selected on the report. To select multiple items, hold down the Ctrl button when clicking the item names. If there are a lot of items, click the magnifying glass icon next to the search field to open a new window for selecting the items.
If several items have been selected for the report and you want a more detailed list of the values of each item, choose Every dimension code and total sum in the Presentation type menu.
Allocated part: (dimension name)
All dimensions that are in use can be selected as their separate Allocated part search criterion.
Enables several different items under different dimensions to be selected on the same report and shows the percentage values of each item.
When choosing Allocated part search criterion or criteria for a report, a section Allocated part (dimension name) is shown in the search criteria listing all the items under that dimension. Items to be included on the report are selected either by holding down the Ctrl button or by clicking the magnifying glass icon and selecting the items to be included.
Allocated part search criterion means the report is computational only, and the report will not allow drilling down to the transactions.
More on this search criterion and how to use it is found here.
Search results:
Excel, HTML, PDF buttons: with these buttons, the search results can be transferred into various different file formats.