The web interface lets you display a Cash flow chart or table on your dashboard, for both past and future periods. In this guide, we'll show you how. The report is available only in the Premium edition of the program.
📋 To use Cash flow, the user's role must have access to user queries (Tools -> User Queries). The report is calculated from a user query that the application creates automatically the first time you add the Cash flow widget.
Adding the Cash flow widget to the dashboard
To add Cash flow to your dashboard, click the arrow next to the New button in the upper right and select Dashboard widget:
In the Dashboard widgets panel, select Cash flow. The widget is added to the dashboard as soon as you click it.
A widget showing your Cash flow now appears on the dashboard:
Configuring the Cash flow chart
You can customize the Cash flow chart to suit your needs. Click the three dots in the upper right corner of the widget and select Settings:
The report settings panel opens:
Name: the name of the widget, which you can change as you like.
Include invoices from the last … months: the number of months into the past that you want to include in the Cash flow report.
Show … future months: the number of months into the future that you want to include in the Cash flow report.
Use companies' average payment term: applies to the future period. The due date of a document is shifted by the average difference between the payment date and the due date of the same company's documents. The Over the past … months field determines how many months back the average is calculated.
Include liabilities and receivables: in addition to issued and received invoices, includes other receivables and other liabilities in the report.
Include VAT and Include payroll: includes VAT payments and payroll payments in the report (shown in the chart as separate series, VAT and Payroll).
Include overdue expenses: also includes in the balance expenses from received invoices that are not yet paid and are already overdue.
Include overdue income: also includes in the balance income from issued invoices that are not yet paid and are already overdue.
Only in currency: limits the report to documents in the selected currency.
Bank balance source: here you choose where the bank balance comes from:
Expression: the balance is calculated from accounting, from the account entered in the Bank balance account field (for example, synthetic account 221 or its analytical account).
Selection: the balance is calculated from bank documents (the Bank module). In the Only accounts section, select specific bank accounts or the all option.
Display: here you choose whether you want the Cash flow output as a chart or as a table.
Show both income and expenses as positive numbers: you can choose whether to show only positive numbers, or to show income as positive and expenses as negative. In that case, the chart might look like this:
Show income, expenses, and balance on the same axis: when you select this option, you will see all of these values together on a single axis.
Confirm your settings by clicking Save.
ℹ️ How the report is calculated: Cash flow adds up the Total [CZK] amounts from issued and received invoices (optionally also from other receivables and liabilities) that are not canceled, are due in the selected period, and have not been paid. If a document is included in a payment order, the payment order's due date is used. Amounts of documents from the past are summed and displayed as of tomorrow's date. The balance from bank documents assumes that the selected accounts are in the local currency.
You can also have several views set up: add the widget to your dashboard multiple times and configure each one differently according to your needs.
💡 Need help? Email us at podporaflexi@abra.eu or use the chat in the lower right corner.