Skip to main content

Connecting your accounting package via an online API connection

Written by Maxime

Billtobox offers a straightforward integration for many of our supported third-party options. Here, you can directly select and configure the service you want to integrate with. This method is ideal for those looking for a seamless and direct way to connect their systems.

Here's how to use it:

  • Go to the Apps menu.
    ​

    Image_1585.png
  • Activate the Accounting App.
    ​

    Image_145.png
  • Set Online connection to ON then click on Next.
    ​

    BTX-117.png
  • You are redirected to the Online Connection page. Select the type of document for which you want to create the integration.
    ​
    ​

  • In the list of integrations, select the service to which you want to connect.

Count-e

  • Fill in all the information in the next screen
    ​

    Informatie_invullen.png


    Username: the Count-e username
    Password: the Count-e password
    API URL: the URL where the Count-e API instance for this account is accessible
    Database: the Count-e database applicable to this account
    Customer number: the Billtobox "customer number" found on the Billtobox web interface under the company name in the top left corner:
    ​

    2023-04-25_15_42_11.png


    Or by going to "Settings" - "Company settings" - "Company profile" - "Customer number":
    ​

    2023-04-27_13_22_06.png
  • Click on "Connect" after checking the box to agree to the Terms of Service.
    ​

    2023-04-27_13_31_54.png

D.velop

  • In the list, choose D.velop then click on Next. D.velop has a single service, so the service selection step is skipped.

  • Fill in all the required information:

    • Base URL: the address of your D.velop environment.

    • API key: the API key of your D.velop environment.

    • Batch ID - sales invoices: the batch your sales invoices should be filed under.

    • Batch ID - purchase invoices: the batch your purchase invoices should be filed under.

  • Tick the checkbox under Consent for data sharing.

  • Click on Connect. Your connection should then be confirmed.

Note

All four values come from D.velop, not from Billtobox. Ask your D.velop administrator for them.

Dropbox

  • In the list, choose Dropbox then click on Next.
    ​

  • Select the service you want to connect with, then click on Next. Dropbox - UBL: eFFF 3.0 delivers the invoice in the eFFF 3.0 format, Dropbox - UBL: Peppol Bis 3.0 in the Peppol BIS 3.0 format.
    ​

  • To link your Dropbox, you must first sign in to your account. Click on Sign in with Dropbox.
    ​

    • After logging in, you may see the following screen first, click on Continue.

    • After which you will be shown the Dropbox consent screen, click on Allow.
      ​

  • After successfully authenticating with Dropbox, finalize the connection by clicking Connect after ticking the checkbox to consent to the Terms of Service. Your connection should then be confirmed.

Email delivery

In the list, choose Bank statements export for accounting or Invoice export for accounting according to what you want to sync. Then press Next.
​

In the next step, select Email and press Next.
​

Image 2074.png

In the next screen, fill in all required information and press Connect.
​

Image 2075.png

Exact Online

  • In the list, choose Exact Online then click on Next.
    ​

    Image_1602.png
  • You will be redirected to the Exact Online connection page, where you can log in.
    ​
    ​

  • After logging in, choose the Administrations you want to share with your Billtobox account.
    ​

    Image 2056.png

    Important: It's best to select the current AND future administrations. There is a limitation with the Exact Online API that only the latest connection will remain valid. Therefore, it’s important to re-use the connection you’re creating for other Exact Online integrations as well.

Select the right administration to connect with.
​

Image 2055.png

Finalize the connection by clicking Connect after ticking the checkbox to consent to the Terms of Service. Your connection should then be confirmed.

Google Drive

  • In the list, choose Google then click on Next. The application is listed as Google, not as Google Drive.

  • Select the service you want to connect with, then click on Next:

    • Google Drive - UBL: eFFF 3.0 converts your purchase or sales invoice to the eFFF 3.0 format and delivers it to your Google Drive.

    • Google Drive - UBL: Peppol Bis 3.0 converts the same invoice to the Peppol BIS 3.0 format instead.

    • If you selected Bank statements export for accounting at the start, Google Drive - Statements Delivery is the only service available and this step is skipped.

  • Click on Sign in with Google, then sign in to the Google account that holds the Drive you want to use and allow the access Google asks for.

  • Back in Billtobox, tick the checkbox under Consent for data sharing.

  • Click on Connect. Your connection should then be confirmed.

Lyanthe

  • Select Lyanthe from the list and click Next

lyanthe.png
  • In the next screen, fill in the requested login details to authenticate with Lyanthe. The details you enter here are the same as your login details in Lyanthe.

lyanthe login.png
  • After successful authentication, select the correct administration.

  • Finally, accept the terms and conditions and click "Connect".

Octopus

  • In the list, choose Octopus
    ​

  • In the next screen, fill in all the information
    ​

  • Open your client application "Octopus Accounting" from your computer and log in.

  • In the top menu of the application, go to "Manage" → "Folders":
    ​

  • Select the folder to which you want to submit the documents.

  • The window containing the details of the selected folder opens. Look for the "Mailbox" field and copy the value:
    ​

  • Paste the value of the email address into the appropriate field of the integration portal interface.

Click "Connect" after checking the box to accept the terms of service.

Onea

  • In the list choose Onea then click on Next.

  • Insert the API key of the account you wish to send invoices to and click "Connect" after checking the box to accept the terms of service:


​​

  • The connection is validated and should now be set up.
    ​
    ​

To find the API key you must connect to the Onea platform corresponding to your accounting software:

  1. In the upper right corner, select the folder for which you want to get the API key

  2. Click on the wrench icon, you will be redirected to the company settings

  3. The API key will be displayed as one of the company fields and it can be copied.

perk

  • In the list, choose perk then click on Next. perk has a single service, so the service selection step is skipped.

  • Fill in all the required information:

    • Client ID

    • Client secret

    • Organization ID

  • Click on Sign in with perk and sign in to your perk account.

  • Tick the checkbox under Consent for data sharing.

  • Click on Connect. Your connection should then be confirmed.

PingWin

  • In the list, choose Pingwin and click Next.
    ​

    Pingwin NL.png
  • Then fill in the login details of your file
    ​

    Login details.png
  • These values ​​can be found in the PingWin desktop client. Log in to your PingWin desktop client and go to your file settings:
    ​

    Desktop client.png
  • Then go to your 'File parameters'
    ​

    file parameters.png


    ​ API key: In these parameters you will find the API key:
    ​

    API key.png


    ​ CLID: You request this ID from Pingwin support: [email protected]
    ​File ID: You can find the file ID under “File Parameters” → “File Information” in the upper right corner:
    ​

    file ID.png
  • Finally, click on Connect after checking the box to accept the Terms of Service.

2023-04-27_13_31_54.png

SFTP

Prerequisites

Only applicable if you use IP allow-listing.

Before we can send data to your SFTP server, our IP addresses have to be allowed in your network or firewall settings. This step is necessary so that our system can establish a secure connection to your SFTP server.
Please add the following IP addresses, from which we send the data, to your SFTP server's allow list:
18.156.159.72
18.157.141.1
3.127.17.114
35.195.141.176
34.79.110.246
34.140.228.15
35.187.32.127

If these addresses are not allowed, we cannot connect to your server and send the data. Once these IP addresses are allowed, you can set up the connection as described below.

  • Choose SFTP.
    ​

    Image 1985.png
  • If available, select the UBL format you want to use. Otherwise, go to the next step.
    ​
    ​

  • Enter the details of your receiving SFTP server:
    ​

    Image 1986.png
    • Username: the username of your SSH account.

    • Password: the password of your SSH account.

    • Host: the hostname or IP address of the SFTP server.

    • Port: the port to which the server listens for SFTP connections. The default value is 22 but another port can be used if your SFTP server has a custom setup.
      ​

    • Upload Path: specify on which location you wish to upload invoices. If not specified, the default path Invoice_import/ is used.

  • Read and agree to the terms of service to continue, then click on Connect.
    ​

  • The app should now be active.

Wings Online

  • In the next screen choose Wings Online and press Next.

    Activate_img_3EN.png

  • In the next screen fill in all required information and pressConnect.

  • Finding the information in Wings Online.

    Activate_img_4EN.png

Field

Information

Responsible

Username / Password

API credentials (+ setup)
​Note:the username should always begin with Wings8 (for example Wings8123).

Wings

Internal number

Wings configuration (see screenshot below)

Client

  • Enter the information in Billtobox: username, password, intern number, accounts receivable diary, accounts payable diary.

    Image

Yuki

  • In the next screen choose Yuki then click on Next.
    ​

    yuki1.png
  • Enter your Yuki API key.
    ​
    ​ How to get your API key from your Yuki account:

      • Go to yukiworks.be.

        yuki3.png
      • Click More on the left menu and select Settings.

        yuki4.png
      • On the Settings page, in the Integrations card, click Web Services.

        Image_1629.png
      • The Web services page lists your API Keys and the Administration Name (listed under Company). Be sure that the API Key you use is a Domain type.

        Image_1630.png
  • After entering your API key, click on Sign in with Yuki.
    ​

    Image 1896.png
  • A dropdown list of administrations appears, select the one you want to work with.
    ​

    Image 1895.png
  • Click the Connect button. You'll get a confirmation that the connection is successful.

Zenvoices

  • Select Zenvoices from the list and click Next

    zenvoices.png
  • In the next screen, fill in all the required information to authenticate with Zenvoices. The data you enter here is the same as your login data in zenvoices.

  • Finally, accept the terms and conditions and click "Connect".

    Login zenvoices.png
    Credentials zenvoices.png
Did this answer your question?