The connection
| Info |
|---|
To register directly for this connection please use this link (currently only available in Dutch) Registration form PayPal connection |
1. Information
With the connection between PayPal and Exact Online, the PayPal transactions are automatically processed as bank entries in an Exact Online bank journal. Invoices from the webshop can easily be matched with the bank entries. The transaction fees are sent to a different general ledger account for further processing. In this tutorial, we will describe the steps to set up and activate the PayPal - Exact Online connection.
...
| Table of Contents |
|---|
2. Fees
For this connection you pay:
...
One-time: € 100,- for purchasing the connection (per connection)
...
The costs for this connection consist of one-time feest and monthly recurring fees. All fees are calculated by connection.
One time costs:
Subject | Explanation | Fee |
|---|---|---|
Initial fee | Initial fee when purchasing the connection | € 110,- |
Onboardingsservice | We offer an onboarding service for this connection. Do you need help setting up the connection? |
...
€ 125,-* |
Recurring monthly fee:
fee depends on the number of transactions of the given month. These are calculated by us at the end of each month.
Tier | Number of transactions per month | Price per month |
|---|---|---|
XS | 0 - 49 | € |
10,95 | ||
S | 50 - 99 | € |
16, |
45 | ||
M | 100 - 299 | € |
21,95 | ||
L | 300 - 499 | € |
32,95 | ||
XL | 500 - 999 | € |
65,95 | ||
XXL | 1000 - 1999 | € |
87,95 | ||
Enterprise 1 | 2000 - 4999 | € |
109,95 | ||
Enterprise 2 | 5000 - 9999 | € |
164,95 | ||
Enterprise 3 | 10000+ | € |
219,95 |
You don't have to choose the tier. The number of processed transactions per month determines the monthly fee. We will send you an invoice each month.
3. Sign up for the connection
Please fill in this registration form and we will start preparing the connection for you for the initial setup. Once we receive the completed form, we will contact you by email with further instructions and information.
By applying for this connection, you agree to our terms and conditions and privacy policy.
The contract will last for one year. After the first year it can be cancelled monthly.
3. Sign up for the connection
To sign up for this connection please use this link (currently only available in Dutch) Registration form PayPal connection
Setting up the connection:
| Info |
|---|
Before you start setting up this connection it is important that the following conditions are met:
|
...
4. Setup up the connection
...
Field name | Value |
|---|---|
Code | 1100-PAYPALEUR |
Description | PayPal Euro Bank Account |
Type | Bank |
Blocked | Unchecked |
General ledger account 2: for the unallocated amounts
Field name | Value |
|---|---|
Code | 1100-PAYPALEUR_UA |
Description | PayPal Euro Bank Account, unallocated |
Type | General |
Blocked | Unchecked |
General ledger account 3: voor de PayPal transactiekosten
Field name | Value |
|---|---|
Code | 4800 |
Description | PayPal transaction fees |
Type | General |
B/S / Profit & Loss | Profit & Loss |
Blocked | Unchecked |
...
Field name | Value |
|---|---|
Bank account number | PAYPALEURO (depends on currency USD = PAYPALUSD) |
Description | PayPal Euro Account (depends on currency USD is PayPal USD account) |
Main | Unchecked |
BIC code | Empty |
Blocked | Unchecked |
Currency | EUR - Euro (depends on currency that you are configuring - USD=USD) |
Variable: Exchange rate | Unchecked |
Journal code | PAYPALEUR (depends on currency USD = PAYPALUSD) |
G/L Account | See the created general ledger account in the previous step |
G/L Account: Unallocated | See the created general ledger account in the previous step |
Automatisch verlaten | Unchecked |
6. Settings in Databrydge
...
Please enter the following information here, please follow this order:
Connection name: Enter the name of the link e.g. YOUR ORGANIZATION - PayPal - Exact Online,
Synchronization Start Date: Enter the date from when you would like the connection to synchronize the transactions from PayPal to Exact Online (up to a maximum of 3 years back). Make sure you use the correct date, as change afterworths is only possible by manual change in the backend by a developer (cost of change € 75,-).
Reseller: Select Databrydge,
Organisation: Select YOUR ORGANIZATION,
Package to connect: select first PayPal en then Exact Online
Click on:
...
You will get to the following screen:
...
Fill in the following:
PayPal:
Name: use your organization name, if it is too long (max 30 characters), feel free to use a shortened name. We only use this information so you can recognize your credential later.
Client Id: Enter your PayPal client id here (which was generated in step 4 of this manuall),
Client Secret: Enter your PayPal client secret here (which was generated in step 4 of this guide),
Go to:
Exact Online - Credentials and select: Create New credentials
...
Name: Use your Exact Online email address
...
Country: Select the environment of your Exact Online (the country of exact online account)
...
You will now be redirected to your Exact Online environment:
...
This section explains the accounting process for processing the PayPal transactions in the accounting system. The accounting process takes place entirely in Exact Online. Therefore it is not necessary to log into PayPal or Databrydge.
Every morning PayPal transactions, the PayPal transactions will be available automatically in Exact Online.
You can find the transactions in Exact Online via the menu: Financial → Banking and Cash → Statements → To be completed. In case you don't see the transactions, check the filters at the top of the page and press refresh.
By using the "Automatically" button, you can start the automatic matching process in Exact Online. Exact Online will compare the PayPal transactions with the open sales invoices and allocation rules.
Check any unassigned lines and assign them to the correct general ledger account.
| Info |
|---|
Tip: Create Exact Online allocation rules to automatically allocate these transactions. |
...