Overview
This section of the Dashboard provides a clear view of your company’s cash position.
The Pending Collections and Pending Payments indicators show, separately, the amounts not yet due and the amounts already past their due date.
This information is essential for anticipating liquidity needs and making timely decisions regarding cash-flow management.
Both indicators are based on forecasts generated from registered invoices or from the Sage 50 Accounting module, and are automatically updated according to the period selected in the Dashboard.
Pending Collections
What does this indicator show?
This indicator displays two values related to outstanding amounts to be collected from customers:
The amount of collection forecasts not yet due.
The amount of collection forecasts past their due date.
Where does its data come from?
The data originates from collection forecasts generated in Sage 50 through different options:
Forecasts generated from sales invoice documents in the Sales module.
Forecasts generated from sales invoice records in the Accounting module.
Manual forecasts created in the Accounting module.
Consolidated forecasts generated in the Accounting module.
How is it calculated?
Pending collections not yet due
Forecasts with a due date equal to or later than the Dashboard update date are retrieved.
The taxable base of all records is consolidated.
Pending collections already due
Forecasts with a due date earlier than the Dashboard update date are retrieved.
The taxable base of all records is consolidated.
Key points to consider
Values displayed include taxes.
The value depends on the selected time filter: Current week / Current month / Current year.
The time filter is applied to the due date to determine the amount that is due or overdue within the selected period.
Why is it relevant for my business?
This indicator is crucial for cash-flow planning and liquidity management, as it provides:
An estimate of future incoming cash,
An alert on the risk associated with the volume of overdue debt,
Insight into when it may be necessary to take action to recover outstanding amounts.
Where can I view the details of the included forecasts?
You can view the list of collection forecasts considered for this indicator by navigating to:
“Accounting module > Reports > Collection Forecasts > Treasury Forecasts (Autocartera)”
Below is an example of how to configure the report to display pending collection forecasts.
Remember to adjust the “From Date – To Date” range to filter the information by the relevant period.
Keep in mind:
The time filter for this indicator is based on the forecast due date.
The Sage 50 report displays pending and overdue forecasts together.
Pending Payments
What does this indicator show?
This indicator displays two values related to outstanding amounts your company must pay to suppliers:
The amount of payment forecasts not yet due.
The amount of payment forecasts past their due date.
Where does its data come from?
The data originates from payment forecasts generated in Sage 50 through several options:
Forecasts generated from purchase invoice documents in the Purchases module.
Forecasts generated from purchase invoice records in the Accounting module.
Manual forecasts created in the Accounting module.
Consolidated forecasts generated in the Accounting module.
How is it calculated?
Pending payments not yet due
Forecasts with a due date equal to or later than the Dashboard update date are retrieved.
The taxable base of all records is consolidated.
Pending payments already due
Forecasts with a due date earlier than the Dashboard update date are retrieved.
The taxable base of all records is consolidated.
Key points to consider
Values displayed include taxes.
The value depends on the selected time filter: Current week / Current month / Current year.
The time filter is applied to the due date to determine the amount that is due or overdue within the selected period.
Why is it relevant for my business?
This indicator is essential for cash-flow planning and liquidity control, as it provides:
A clear view of your company’s future payment obligations,
A direct comparison with the Pending Collections indicator to detect possible liquidity issues in specific periods,
Alerts regarding overdue payments not yet settled, which may result in additional costs and/or impact supplier relationships.
Where can I view the details of the included forecasts?
You can view the list of payment forecasts considered for this indicator by navigating to:
“Accounting module > Reports > Payment Forecasts > Due Dates (Vencimientos)”
Below is an example of how to configure the report to display pending payment forecasts.
Remember to adjust the “From Date – To Date” range to filter the information by the relevant period.
Keep in mind:
The time filter for this indicator is based on the forecast due date.
The Sage 50 report displays pending and overdue forecasts together.