TRESIO enables you to accurately record all incoming and outgoing transactions, ensuring easy oversight of your budget. Incoming payments that are received in from your customers as payment for supplies or services rendered, while outgoing payments are to send out to vendors for supplies or services that were provided to you, among other payments. TRESIO offers convenient invoicing and expense management at your fingertips. Instantly visualize your cash flow through the TRESIO dashboard and seamlessly import invoices, automatically gathered from invoice management solutions like Sage, Bexio, and Proffix.
Invoices screen
The invoices screen lets you add new invoices manually or upload them via Excel spreadsheet. You can also Edit, Duplicate, Upload or Delete invoices.
The ‘Invoices‘ screen shows:
- Project number – if available, the project’s reference number
- Invoice number – unique sequential code
- Invoice amount – the net amount due
- Currency – payment currency
- Category – financial inflow/outflow category to which the invoice is assigned
- Status – unpaid or paid
- Name – name of the debtor/creditor
- Issue date – when the invoice was issued
- Due date – when the invoice is due
- Uploaded date – when the invoice was uploaded
How to add an invoice
Click on the ‘New’ button and fill in all required information. Debtor name can be selected from the ‘Name’ list of previously configured debtors, or the ‘Add New’ option can be used to set up a new debtor.
If you wish to Duplicate an invoice, make sure you enter a unique Invoice No.
How to upload invoices
In order to upload Invoices in bulk, click on the ‘Upload’ button.
On the following screen, you have the option to upload invoices via an Excel file or select one of the supported integrations.
For integration via a supported format, please switch to the integrations screen. You can find more information about this here. If you do not find your system in the list of supported systems and would like us to add it, you can click on the link “Your format” and fill out our Google form so that we can review it.
Upload via Excel File
In the next step, you will learn how to upload invoices via Excel.
- Select invoice type – choose whether the invoices are receivables (debtors) or payables (creditors).
- Settings – select how previously uploaded invoices should be handled:
- Existing invoices that are not included in the file will be marked as paid
- Existing invoice data of a category will be deleted
- Select file – the file can be uploaded either via file selection or by drag & drop. If you choose the option “Download sample Excel file”, you will receive a pre-filled template with system-approved headers and sample data. This template is intended to help you create your own file.
Please note that you can upload both receivables and payables in the same file. The system automatically determines the invoice type based on the “Category” field contained in the file as well as the existing list of categories stored in the system. If no categories have been set up, the system generates one based on the category specified in the file. This category is then assigned to the inflow or outflow type depending on the selected option (debtors/creditors) before the file is uploaded. We strongly recommend defining categories before uploading the invoice file in order to avoid potential issues with your data.
After the file has been uploaded, the following screen will be displayed.
Since Excel invoice lists can be structured differently depending on the company, the system cannot always automatically assign the contents correctly.
In this step, you have the option to manually configure your Excel file by assigning the appropriate content to each column (e.g. invoice number, date, amount, etc.).
This assignment is necessary to ensure that the invoices are subsequently correctly recognized, processed, and displayed—regardless of how your original Excel file is structured.
1 Field name in Tresio
These are the fields that will be displayed later on the invoice screen.
2 Mode
Here you can select the appropriate mode individually according to your Excel file.
3 Column name in your file
When you click on “Please select column”, a list of all column names from your file opens. This allows you to assign each column individually and define the position in which it will later be displayed on the invoice screen.
4 Sample data from your file This preview is used to verify that the correct column has been selected. As an example, the first three values of the selected column are displayed.
Once all settings have been adjusted and verified, you can click on Save and the review screen will appear.
Here you have the option to review the uploaded invoices. You can remove individual invoices that are not needed or edit them again individually.
In addition, you can adjust the mode again and define how existing invoices should be handled.
If everything is correct, click Save. The uploaded invoices will then be displayed on the invoice screen.
Note on reviewing column assignments Before saving, please carefully check that all columns are correctly assigned. If discrepancies or unexpected values are displayed, this is usually due to an incorrectly assigned column. In this case, please review the column assignment again and adjust it if necessary. Correct assignment is essential to ensure that invoices are processed correctly and displayed properly on the invoice screen.
Where to view Invoices on the Forecast and Dashboard screens
The Forecast screen displays your invoices within tabs: Forecast and IS-Data. Invoices will be taken into account when displaying the chart, and can be viewed in the ‘Forecast Details’ section if the ‘Show all’ categories option is selected. To view a breakdown of the total amount within the respective category, simply click on the total amount itself. This action will open a new pop-up window displaying the list of invoices that contribute to the overall total.
Dashboard screen will show all entered invoices in the respective charts.
Hover your cursor over the specific chart area to see expected and overdue amounts.