Data planning with TRESIO helps you make smarter decisions based on your own situation, goals, and how much risk you’re comfortable with. It’s like having a roadmap for your money. Plus, TRESIO’s tools can show you clear pictures of how your finances are doing, spotting trends and patterns that make your planning even more accurate. This kind of planning helps businesses predict different scenarios, avoid financial surprises, and coordinate their various operations effectively.
How to set up planning data
Planning Data represents the income structure of your company with expected revenue and all incoming and outgoing financial activities. The Planning Data screen allows you to set up an unlimited amount of planning elements per selected scenario. You can also duplicate elements and export selected elements of data to Excel or PDF.
What the Planning Data screen shows:
- Category – Category type of the financial activity: inflow, outflow or financing. If the required category is not listed, it can be added on the “Categories” screen
- Name – Name of the planning data element
- Planning type – The planning type can be selected from a predefined list of payment or growth types, or as a percentage of another element or category
- Amount – Amount of the planning element
- Currency – Currency of the planning element
- Next payment – Next payment date for recurring events, or “Expired” if no longer active
- End date – Last payment date or not specified / unlimited
- Description – An extended view of the setup options, which varies depending on the selected planning type. Warnings are also displayed here
- Periodicity – Defines the interval at which a payment is repeated, for example monthly or yearly
- Start date – Defines the date from which the payment is first taken into account
- End date – Specifies the date until which the payment runs or when it ends
- Comment – Optional field for additional notes or internal remarks related to the payment
How to set up a planning element
To set up a new planning element click on the ‘New’ button and provide all required details. Depending on the ‘Planning type’ you will be asked to provide different details.
Modifying, duplicating or deleting elements
You have several options for editing elements.
You can edit or delete individual elements using the pencil and trash icons, or select multiple elements by ticking the checkboxes and then edit, duplicate or delete them in bulk.
The “Comment” field does not support special characters such as apostrophes, semicolons or line breaks (Enter key), as these may cause display issues. We recommend avoiding these characters when entering comments. If a display error occurs, it can be resolved by removing the special characters.
Please note: In instances of a “child” scenario, all planning elements set up for the “parent” scenario are inherited. Users cannot modify, duplicate or delete these elements, but can only adjust them in percentiles using the “Adjust” option. If additional elements are required for a child scenario, they can be added using the “New” option.
How to View your elements on the Forecast and Dashboard screens
The Forecast screen – will show planning data on the chart, together with invoices. Please note that invoices will be shown only in the gray ‘Open Invoices’ (actuals) area which is s set to display a period of 30-days by default. Unless payments are created for the ‘Is fixed’ category, that is not assuming invoices for cash flows such as: permanent order leasing, wage payments or rent. These type of cash flows will be taken into account in both the plan and actual data.
The ‘Open Invoices’ period can be changed in ‘Additional settings’ > ‘Forecast – comparison plan / is data’ if required.
A detailed breakdown per category type can be viewed if the ‘show all’ option under ‘Forecast Details’ is selected.
Click on the total amount to see the breakdown details splitting planning data and invoices.
Creating and managing custom views using filters
The “Planning Data” screen currently offers three data views: “Display all”, “Sales” and “Personnel cost”. Each view displays a different set of columns to focus on the most relevant information for that view.
If you require a different data view, you can create a new one by selecting “Add new view”. More information on creating filters can be found here.
How to troubleshoot planning data
Let’s look at a situation where your planning data for the first month does not appear on the forecast screen. In the following example, you have set up a planning element as a recurring monthly salary payment starting on 6 September 2023.
Go to the forecast screen, select the “Forecast” tab and set the “Reporting date” to 1 September 2023.
Now expand the view and look at the forecast details. As you can see, the planning data for the first month has not been taken into account. This is because the system only displays actual data for the first month, while all planning elements are shown starting from the following month.
Tutorial video (06:24)
If you’re interested in learning more you can watch our tutorial video.