Liquidity Planning

This app provides a report named "Cash Flow Forecast" that can be used for liquidity planning in ERPNext.

Installation

Note

This app targets ERPNext version 14.

You can install this app on you ERPNext instance using the bench CLI:

bench get-app https://github.com/alyf-de/liquidity_planning.git
bench --site $MY_SITE install-app liquidity_planning

Description

The "Cash Flow Forecast" report offers a detailed forecast of an organization's cash flow, providing insights into its financial health. This section explains the data sources and methodology behind the report.

Data Sources

The report derives its data from various ERPNext modules, as outlined below.

Income

• Submitted Sales Orders, as well as scheduled Sales Orders using the "Auto Repeat" feature. Any billed orders are subtracted from the total to avoid double-counting.
• Submitted Sales Invoices.

Expenses

• Outstanding submitted Purchase Orders, as well as scheduled Purchase Orders using the "Auto Repeat" feature. Any billed orders are subtracted from the total to avoid double-counting.
• Submitted Sales Invoices.
• Employee Salaries, calculated based on the Cost To Company (ctc) field from the Employee DocType, considering joining and relieving dates. The average salary is calculated on a daily basis for the selected period, hence the total might not add up to the exact amount (salary = number_of_days * ctc / 30.438).
• Approved Expense Claims.

Calculation Methods

• The report calculates total income and expenses by aggregating values from sales and purchase orders, invoices, salaries, and expense claims.
• Net cash flow is determined by subtracting total expenses from total income.
• Currency conversions are applied where necessary, based on the presentation currency selected by the user.

Note

In order to see any "forecast", you first need to setup the "Auto Repeat" feature for your orders and enter employee salary data.

Report Filters

Users can customize the report using various filters:

• Company: To select the specific company for the report.
• Filter Based On: Choose between 'Date Range' or 'Fiscal Year'.
• Periodicity: Select the frequency of the report (Monthly, Quarterly, Half-Yearly, Yearly).
• Currency: Choose the presentation currency (e.g. EUR, USD).

License

Copyright (C) 2023 ALYF GmbH and contributors

This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program. If not, see https://www.gnu.org/licenses/.