With our "Import invoices" module on app.rombro.ch you can now easily import invoices into bexio via Excel, CSV and other table formats. This is particularly useful for companies or associations that do their invoicing in another software but want to import the invoices as a list via our app in order to keep the open item list in bexio, carry out bank reconciliation or manage accounting. The special thing about this module is that if a contact does not yet exist in bexio, we create the contact automatically, which further simplifies and automates the import process.
Register for free
If you don't have an account yet, register on app.rombro.ch with your email address and choose a password. You are now ready for the next step.
Connect your bexio account with app.rombro.ch
Connect your bexio account with us by connecting to an accounting department. You can connect as many bexio accounts as you like to app.rombro.ch .
Create a table for invoices
Are you ready to import? Now create a table in the "Import invoices" module using the "New invoice import" button. Give the table a name and select the bexio account into which you want to import the invoices.
Copy invoices into the table
Contact assignment
The contact is preferably assigned using the bexio contact number. Otherwise, the contact can also be assigned using the contact information. To do this, use exactly the same information from "contact type" to "Email" as in the bexio contact management. If the contact does not yet exist in bexio, enter at least one value in the "contact type" and "Name_1" cells (specification below). The contact is then created in bexio. Check the lines randomly to ensure they are correct.
Import invoices with only one invoice position
Copy your invoices into the prepared table. Make sure that a new sales invoice is created in bexio for each line.
Example with only one invoice position
Import invoices with multiple positions
Copy your invoices into the prepared table. So that the app can recognize which invoice items are attached to a parent row, the cells from "contact no." to "date" must be left empty; the invoice items are then attached to the parent row.
Example with multiple invoice items
Specification and meaning of the columns:
Field | Example | Notice | Duty |
bexio Contact no | 1 | Zeros before the ID do not need to be included | NO |
Contact type | 1 | 1 = Company 2 = Person | YES, if Bexio contact ID not defined |
Name_1 | above the fold GmbH | Is the company name (If “Contact Type” 1) otherwise the first name | YES, if Bexio contact ID not defined |
Name_2 | Haag | Last name | NO |
Address | Hochgrütstrasse 16 | NO | |
Postal Code | 8742 | NO | |
City | Seuzach | NO | |
NO | |||
Invoice Date | 12.12.2023 | Must be in an active accounting year | YES |
Position Description | Repairs of: - Door - Window | Can be multi-line. No formatting (bold/italic etc.) supported. | YES |
Individual price | 1500 | YES | |
Position Quantity | 1 | YES | |
Account | 3400 | Must be an income account | YES |
Tax rate | UN77 | May only have the following type: sales_tax not_taxable_turnover non_consideration_sales_tax opted_sales_tax Code UEX if no VAT obligation | YES |
Start importing 🚀
You start the import process by clicking the "start import" button. Each row in your table is imported into bexio as a separate sales invoice. If you want to start the import process later, you can leave the table at any time by clicking the "save" button.
⚠️ Important information / limits
Existing contacts will not be updated.
If the rows Contact Type, Name_1, Name_2, Address, PC, City and Email are identical, the contact will not be created twice in the same table.
A maximum of 200 invoices can be created per table.
Not subject to VAT? The "VAT Code" column is still a mandatory field. Use the VAT code "UEX" if you are not subject to VAT.
By following these steps, you can complete the invoice import process smoothly and make your accounting processes in bexio more efficient.
Used software:
app.rombro.ch (bexio Addon) www.bexio.ch (Cloud-based accounting software)
Comments