Tracking expected cash movements
Generally, to get an estimate of your banking position in Akuiteo, you just have to use the Dashboard module. This module takes into account the dates of management objects (order, billing table, invoice, miscellaneous transaction entry, and so on) to forecast cash movements in order to get a precise estimate of your banking situation.
However, you cannot track objects other than traditional management objects, such as wage movements, social security contributions, loans, etc. - all these items being outside of the management flows processed in Akuiteo.
This is why using the Expected cash movements tool will enable you to include these items that are outside of the traditional cash movements.
This tool will therefore forecast both invoices based on the due date and the expected cash movements.
This tool gives you the possibility to determine when you are likely to have cash-flow issues and when preventive actions should be taken (date or bank change).
You will be able to update due dates from the invoice or the expected cash movements once, as modifications will be applied everywhere.


- Make sure you know which bank to use in order to pay an invoice.
- Make sure you know which bank to use in order to receive payments.
- A bank account must be specified on a project, a customer or a supplier.

Management rules
1 | Go to Tools > Setup > Management rules. |
2 | Add the TRESO_PREVISIONNELLE management rule. |
3 | Fill in the following fields: |
- Info 1: the default bank journal set up for sales invoices (due dates)
- Info 2: the default bank journal set up for purchase invoices (due dates)
Automatic numbering of objects
1 | Go to Tools > Setup > Automatic management objects numbering. |
2 | Create an MTPR type (Forecasted cash flow) to be able to create movement record sheets outside of the Purchase/Sales modules. |
Types of expected cash movements
1 | Go to Tools > Setup > General setup > Banking > Types of expected movement. |
2 | You must set up cash movement types. E.g.: loan, wage bill, social entity, etc. |
3 | Enter a code and a label. |

The expected cash journal must have been added to the payment due date of purchase and sales invoices.
When an invoice is created, this journal is automatically determined.
However, you can still manually modify the bank journal on each due date, or on multiple due dates at once from the search results for invoices due dates.
How the journal is determined on sales invoices:
- Single-project invoice: the project's bank journal (if specified)
- If not found: the customer's bank journal
- If not found: the bank journal set up in Info1 in the management rule
How the journal is determined on purchase invoices:
- Single-project invoice: the project's bank journal (if specified)
- If not found: the supplier's bank journal
- If not found: the bank journal set up in Info2 in the management rule

Prerequisites: make sure you know the relevant dates and amounts.
Cash movements can be created manually or via an import. In this last case, please refer to your Akuiteo contact.
1 | Go to Banking > Expected cash movements. |
2 | Fill in the following fields: |
- Code: automatically assigned
- Journal (required)
- Expected date for the cash movement
- Amounts: in positive or negative numbers
Note
- The currency used is the one specified in the journal.
- The tool only retrieves entries from the cash journals.

1 | Go to Dashboard > Banking > Expected cash position tracking. |
2 | Fill in the following fields: |
- Relevant company
- Journal
- Status date (the current date by default)
3 | Start the search. |
A table displays daily columns as well as lines per movement types, over 30 days.
- Only unmatched entries are retrieved.
- Before column: enables you to see an expected payment that was not settled for a line (ex: sales invoice). An adjustment should therefore be made.
- The orange color indicates potential cash-flow issues.

1 | In the Before column, click on the amount in the line (hyperlink). |
2 | In the list of management objects, click on a line to open it. |
3 | Open the Due dates tab from the invoice that just opened. |
4 | Manually update all necessary information (the due date). |
Note
You can also make corrections from the list by right-clicking on the desired line(s), then clicking on "postpone the dates" or "modify by batch".

When an expected cash movement is done, it should be marked as "done" from the tracking screen (right-click in a list).
This action must be performed. Otherwise, the movement will be considered as not done "before the indicated period".
This step will enable you to check whether there are missing data to reschedule.

From the list of expected cash movements, you can Duplicate and modify by batch from a search results and Break down a movement.