With TRESIO, you can record all your incoming and outgoing invoices precisely, giving you clear control over your liquidity.
TRESIO gives you three ways to record invoices:
- Manual – enter individual invoices directly under Invoices.
- Bulk upload via Excel file – upload many invoices at once with a simple Excel upload (incl. column matching); for exports from common systems (incl. Abacus, Sage, Messerli, bexio, sevDesk, lexoffice, PROFFIX, Datev), TRESIO recognizes a known column standard and makes column matching easier for you.
- Automatic integration – an ongoing connection to your accounting or invoicing software (e.g. bexio, exxas, Run my Accounts, Small Invoice, MOCO, or a URL import from Google Sheets/shared drives) that continuously syncs invoices without you having to upload anything manually.
All three ways lead to the same result: your invoices are managed centrally under Invoices and automatically flow into the forecast. More on the individual processes for recording invoices below.
Invoices
Under Invoices, you’ll find a list of all recorded invoices with the key details – Project Number, Invoice No, Invoice Amount, Currency, Category, Status, Name, Issue and Due Date, as well as Upload Date. The toolbar lets you create, edit, duplicate, delete, upload via Excel file, and export invoices (Excel, CSV, PDF, clipboard, print).

Way 1: Enter an invoice manually
Click New. The Create a new entry window opens with the following fields: Project Number, Invoice No, Invoice Amount, Currency, Category, Status, Name, Issue Date, and Due Date.
The debtor’s or creditor’s name can be selected from the Name list of previously configured debtors/creditors. If the debtor/creditor you need doesn’t exist yet, you can add them directly via the Add Debtor/Creditor button, without leaving the window.
Choose the Category from a searchable list based on your chart of accounts (e.g. Inflows (open invoices), Outflows (open invoices)). Every invoice must be assigned a category – without one, it won’t be included in the forecast later.
Finally, click Create.

Important: When duplicating an invoice, make sure to enter a unique invoice number.
Way 2: Upload invoices via Excel file
To upload invoices in bulk, click Upload. The process consists of three steps:
1. Determine the type of invoice – Choose whether the invoices in your file are Debtor or Creditor invoices.
2. Settings – Specify how existing invoices that are no longer included in the new file should be handled:
- Existing invoices not included in the file are marked as paid, or
- Existing invoice data for a category is deleted
3. Select file – Upload your file via drag & drop or Browse files. Download sample Excel gives you a template with system-defined headers and sample data to help you create your own file.

Supported formats
Below the upload area you’ll see a list of supported formats: Abacus, Sage, Messerli, bexio, sevDesk, lexoffice, PROFFIX, Datev, plus the Your Format option. This means: if you export an invoice list directly from one of these systems and upload it without further changes, TRESIO automatically recognizes the typical column structure and makes column matching easier for you (see below). If your system isn’t on the list and you’d like us to add it, click Your Format and fill out our Google form so we can review it.
Not to be confused with automatic integrations: These supported formats are purely Excel export templates – you still upload the file manually. For an ongoing, automatic sync without a manual upload, see the section Way 3: Automatic integration below. For some systems, e.g. bexio, you can freely choose which approach to use: automatic nightly sync via the integration, or manual Excel upload under Invoices.
Column matching
Since Excel lists are structured differently from company to company, the system can’t always assign the content correctly on its own. After uploading the file, you’ll therefore go to Invoice column matching, where you assign the right TRESIO field name to each column in your file:
- Field name in TRESIO – the details that will then appear under Invoices (Project Number, Invoice no, Invoice amount, Currency, Issue date, Due date, Name, Category).
- Mode – choose the mode that matches your Excel file (e.g. “Each row contains a project number” or “The file does not contain any project number”; “All bills are in the same currency”, etc.).
- Column name in your file – open the list of all column names from your file and assign each column individually.
- Sample data of your file – for verification, the first values of the selected column are shown so you can check whether the right column was chosen.

Note on checking column assignment: Please check carefully before saving that all columns are assigned correctly. If discrepancies or unexpected values appear, this is usually due to a column that wasn’t assigned correctly. Correct assignment is essential so that invoices are processed correctly and displayed properly under Invoices afterward.
Once all settings are adjusted and matched, click Save – you’ll now see Invoice data.
Review before final import
Here you can check the uploaded invoices once more: remove individual invoices you don’t need (Remove) or edit them again individually (Edit). Once everything is correct, click Save.
Important: Invoice numbers must be unique for bulk imports too – please check your file accordingly before uploading.

Way 3: Automatic integration (ongoing sync)
Instead of repeatedly uploading invoices manually, you can also connect TRESIO once to your accounting or invoicing software. This connection then automatically takes over new and updated invoices on an ongoing basis.
To do this, go to COMPANIES → Integrations and switch to the Invoices and accounting category. The following connections are currently available:
- bexio – automatically imports open debtor and creditor invoices as well as the chart of accounts (importing the accounting journal, including balance sheet and income statement, also requires the “Journal” integration to be activated)
- exxas – automatically downloads debtor and creditor invoices; complete balance sheet information is planned for the future
- Run my Accounts – Swiss accounting solution; imports debtor and creditor invoices as well as your bank account balance overview
- Small Invoice – automatically imports debtor invoices via the Small Invoice interface
- MOCO – ERP solution for agencies; automatic download of debtor and creditor invoices
- Import data from URL – automatically imports debtor and creditor invoices via Google Sheets or shared drives; useful if your system doesn’t have a direct interface with TRESIO
Click Connect on the integration you want to set up. For some integrations (e.g. bexio), you can then specify in detail which invoice statuses should be imported automatically – for example, whether only open debtor invoices or also draft creditor invoices are downloaded. Also enable Automatic updates so TRESIO continuously retrieves new invoices on its own, or trigger a manual fetch via Update via API.


Where invoices appear under TRENDS
Regardless of which of the three methods above was used to record an invoice, it automatically flows into your liquidity planning – provided it has been assigned a category. You’ll find it under TRENDS, broken down by category (e.g. 110 – Accounts receivable trade and services or 200 – Suppliers or creditors).
For more on this – including the settings for how invoices are factored in – see the article on TRENDS.

Where invoices appear under Analytics
You’ll also see your invoices under Analytics: under Debtors and Creditors as the total of open invoices including overdue amounts, and in the planning chart in the “Open Invoices” area. Under Overdue, clicking the (i) icon shows you the individual overdue invoices in detail.

