Bexio Web receivable interface

The Bexio Web receivable interface allows you to post and cancel invoices, transfer addresses and import payments with Bexio Online Accounting.

Installing the extension

In Vertec, navigate to the Settings > Interfaces > Extensions folder and open the Bexio Web receivables interface. Click Installieren.

Set up Bexio

Generate API token

Under Settings > All settings > Apps & API select the API keys. Here an API token for Vertec can be generated or copied:

Turn off automatic invoice number

In order for Vertec to write the invoice number in Bexio, the check mark for Assign number automatically must be removed under settings > All settings > Features and modules > Invoice:

Create an advance account

In Bexio, invoice lines cannot be posted to asset or liability accounts. To avoid this problem, an imprest account is defined as an income or expenditure account:

Tax method Client

If the tax method on the client is set to balance taxation in Bexio, it cannot be posted because Bexio does not return VAT rates that have been parameterized for balance taxation via the extension.

Set up Vertec

System settings Vertec

Some system settings are installed for all accounts receivable interfaces. These are listed in System settings > Accounting.

The following system settings are specific to the Bexio Web receivable interface:

Configure VAT types

For the Types of vat , the corresponding code from Bexio must be entered, e.g. UN81:

payment terms

The Payment Terms stored in Vertec will result in a due date on the invoice. This due date will be transferred to Bexio when posting.

Setting up multiple clients (Line Expert only)

The Vertec Bexio Web receivable interface is multi-tenant. To set up multiple tenants, create a Project Type in Vertec for each additional tenant.

On the project type, page More info, you can define the Api token of the Bexio client:

Make sure that the accounts on the Accounting page are set up correctly.

All projects assigned to this project type are posted to this client.    

Note: Since the personal account number is located on the address (see next section), all projects of a customer must be posted in the same client.

Personal accounts (PK numbers)

Personal account numbers for Bexio are located in Vertec at the address (customer of the project) under settings.

If the address already exists in Bexio, enter the corresponding PK-number here. The address data will be updated each time you book.

If the address does not yet exist in Bexio, it is automatically created when posting and the personal account number is entered on the address in Vertec.

Only the personal identification numbers on the addresses are taken into account. Possible overruns on projects are ignored.

Post

In order for invoices to be posted , they must be charged in Vertec.

Charging and posting can be done in one step if the system setting Beleg direkt buchen (System settings > Accounting) is set to Ja.

Posting is done on a single invoice or a list of invoices via the Actions menu or right-click > Post.

On individual invoices, the booking process can also be done via the button Stornieren on the Accounting page.

When posting, the addresses or address changes are transferred (see section Person Accounts ).

 The invoice number from Vertec is transferred as the invoice number (see section
Turn off automatic invoice number ).

Cancel

For invoices to be cancelled, they must already be posted.

The cancellation is done on a single invoice or a list of invoices via the Actions menu or right-click > Cancel.

On individual invoices, the booking process can also be done via the button Stornieren on the Accounting page.

Depending on the Cancellation Method set, the invoice will be processed in Bexio on cancelled set or removed from the invoice list (see method description).

payment import

The payment is imported as described in the article Payment reconciliation with vertec .