Cashflow reporting – Procountor

Cashflow reporting is an updated version of the old cashflow reporting. Unlike in the old cashflow reporting, the new reporting offers the information in real time from Procountor's database and improves usability. Both the old and the new cashflow report will function side by side for a while.

Cashflow report can be used to observe the balances of bank accounts from the perspectives of past, present and future. The report is also able to forecast the future cash flows from Procountor’s future transactions that have not yet created actual cash processes.

The Cashflow report is found in Reports > Cashflow reporting.

Creating a report

First, define the search criteria for the report.
Click Apply.
The program generates cashflow reports in line with the search criteria.

Reset to default: clears your selections and resets the default search criteria.

View details: From the View details -button on the top row, you can view the content of the graph at the row level.

From the details view the user can view individual bank statement events from the bank accounts chosen as well as open receipts by due date.
Table can be exported to Excel by pressing Export to Excel button.
The Back button returns you to the main view of the report.

Search criteria

It is possible to filter the graph by:

Time period

2+1 months: two previous months and the following month
2+2 weeks: two previous weeks and two following weeks
10+2 months: 10 previous months and two following months
Current year
Custom period: Free date definition either by filling values in the fields or by using the calendar icon.

Bank accounts

Listing of accounts: The account or accounts to be included in the report can also be chosen from the listing of accounts below the Search field. A single account is activated by clicking it. Choosing multiple accounts is possible only when the accounts are in the same currency.
- If you have accounts in different currencies, they are separated into their own tabs.
With the Select all button, you select all the information on the tab. Use the Clear selection button to clear all selections.
Search field: You can filter the list by entering any part of the account.

Transactions

All transactions: searches for both business transactions and other transactions.
Business transactions: this selection includes business transactions to the report: business transactions are receipts that are in statuses Not sent, Sent, Paid, Approved, Partly paid, Marked paid or Invoiced.
Other transactions: this selection includes transactions, that are not business transactions, to the report.

Receipt type

This selection determines the receipt types to be included in the report. If there are no receipts of a specific receipt type in the environment, the receipt type in question is not listed in this menu. The available receipt types are:

Expense invoices
Purchase invoices
Purchase orders
Salaries
Sales invoices
Sales orders
Tax returns for self-assessed taxes
Travel invoices

Scope

All invoices, overdue (past due) and/or due (future due) invoices can be selected separately into report.

The available graphs

Cash flow history and future

CashflowReport.UpperGraph.jpg

The topmost graph in the Cash flow report view depicts the development of the balance of the selected account and estimated development of its balance (deposits, withdrawals, future deposits and future withdrawals for the selected account) during the selected time interval.

The Balance graph indicates the actual balance of the bank account.

The Future Balance graph shows a forecast of the future balance of the bank account.

The graph can be saved as a PNG-format image file by clicking on the Export to PNG button.

Cashflow report

CashflowReport.Graph.jpg

The graph in the middle illustrates the actual cash flow and forecast divided into deposits and withdrawals. Purple bars illustrate deposits, light purple bars correspondingly withdrawals. Grey bars are forecasts of the future withdrawals and the blue bars are future deposits.