Exact Online is an online accounting package used by many Dutch firms and their accountants. If your firm books through Exact Online, you can connect it to Legalsense so debtor, matter, and invoice information flows between the two systems automatically. This article explains how to set up the integration.
Note: After setup, see the article ↪ Managing the integration with accounting software to monitor the synchronization, review the sync queue, and change the ledger and trust account configuration.
In this article
How the integration works
The integration between Legalsense and Exact Online works both ways:
- Legalsense sends debtors, matters, invoices, and credit invoices to Exact Online. Debtors become customer accounts, matters become cost units, and invoices become sales entries, with the invoice PDF attached if you choose.
- Legalsense retrieves the payment status of invoices, creditors, purchase invoices booked on a disbursement ledger account (which become disbursements on the matter), and trust accounting transactions.
This means you don't have to enter information twice. For example, if you book purchase invoices in Exact Online, Legalsense imports the disbursements on them, so you don't have to enter them again in Legalsense.
Legalsense synchronizes automatically every 12 minutes. Changes to debtors and matters are sent on the next sync, and an invoice is sent as soon as you finalize it.
Important: Legalsense sends an invoice to Exact Online only once. If you need to correct an invoice after it has been synchronized, create a credit invoice. See the article ↪ Creating a credit invoice.
Before you start
The Exact Online integration has to be activated for your environment by Legalsense. If Settings → Exact Online isn't available, contact Legalsense support.
In general, users linked to the sync accounting group in Legalsense (with the manage_sync_accounting permission) can set up and manage the integration. We advise involving your bookkeeper or accountant in this process, so the data ends up correctly in Exact Online.
To set up the integration, you need:
- An Exact Online user account with access to the administrations (divisions) you want to connect. The connection runs through this account, so choose an account that won't disappear when a colleague leaves.
- The Exact Online administration for your regular bookkeeping, and the administration for trust accounting. These can be the same administration, but they must use the same currency.
- The email address of the person who should be notified when the synchronization fails.
- Your chart of accounts, VAT codes, journals, and cost centers in Exact Online, so you can map them in Legalsense.
Check the numbering of your debtors and matters before you start:
- Legalsense uses the matter number as the cost unit code in Exact Online. Exact Online allows a maximum of 8 characters, so longer matter numbers can't be synchronized.
- If you use Legalsense's debtor numbers, Legalsense removes every character that isn't a digit and uses the result as the account code in Exact Online (maximum 18 characters). That code must not already exist in Exact Online.
Important: Once you start setting up the integration, complete all the steps in one go. Some settings can't be changed after the synchronization has started.
Set up the integration
Go to Settings → Exact Online → Overview and click Set up Exact Online now.
Exact Online overview page showing that Exact Online isn't set up yet, with the Set up Exact Online now button.
You are redirected to Exact Online. Log in with the Exact Online account the integration should use. Legalsense then returns you to the setup.
- In the Administration step, select the Division for your bookkeeping and the Trust accounting division, then click Next. Each administration is shown with its currency.
Exact Online setup, Administration step, showing the Division and Trust accounting division dropdowns.
- Enter the Email of the Administrator*: the address that receives a notification when the synchronization fails. Separate multiple addresses with a comma. Click Next.
Exact Online setup, Email of the Administrator step.
- In the Import and export step, choose which data Legalsense sends and retrieves, then click Next. See Import and export options below.
Exact Online setup, Import and export step, showing the options for matters and debtors, payment status, and expenses and creditors.
- In the Ledger accounts step, choose Customize the ledger accounts and enter the Exact Online ledger account, VAT code, journal, or cost center for each row. The rows are grouped in sections: Ledger accounts, Ledger accounts for custom invoice lines, Office expenses, VAT, Journals, Cost centers, and Other. While you type, Legalsense suggests the accounts from your Exact Online administration. Click Next.
Important: The Legalsense default ledger accounts are generic suggestions and usually don't match your chart of accounts in Exact Online. Check every row with your bookkeeper. See the article ↪ Managing the integration with accounting software for what each section is for.
- In the Revenue accounts per user step, choose No accounts per lawyer, or Specific ledger accounts or cost centers per lawyer to book each timekeeper's revenue to their own ledger accounts or cost center. Click Next.
- In the Accounts for disbursement types step, choose No overrides, or Specific accounts per expense type to book a disbursement type to its own ledger account. Click Next.
- In the Initial synchronization step, choose which existing data Legalsense sends to Exact Online on the first synchronization:
- Synchronize all past transactions
- Synchronize transactions starting from a date you enter in the From date field (by default, 1 January of the current year)
- Don't synchronize past transactions
Below the form, Legalsense shows how many invoices and expenses it will export.
Exact Online setup, Initial synchronization step, with Synchronize transactions starting from selected.
Click Done, commence syncing, then click Yes to confirm.
Legalsense now sends your active debtors and matters, and the invoices in the period you chose, to Exact Online. Go to Settings → Exact Online → Overview to follow the progress.
Exact Online overview page after setup, showing the status, Exact Online user, and number of elements in the queue.
Import and export options
The field marked with an asterisk (*) is required when you choose to import expenses.
Troubleshooting
The synchronization stopped with an error about a debtor or matter.
Exact Online rejects debtors and matters that don't meet its requirements. The most common messages are:
After fixing the cause, click Error fixed on the error page. Legalsense then tries again. See the article ↪ Managing the integration with accounting software for the other errors and for reconnecting when the connection has expired.
Currencies between division and trust accounting division don't match.
The two administrations you selected use different currencies. Select administrations with the same currency.
Something went wrong obtaining a list of divisions from Exact Online.
Legalsense couldn't retrieve your administrations. Try again later. If the problem continues, check that your Exact Online account has access to the administrations, or contact Legalsense support.
It seems that your Exact Online user account has insufficient permissions.
The Exact Online account you logged in with doesn't have enough rights in the administration. Ask your Exact Online administrator to extend the rights, or connect with a different account by clicking (change) next to Exact Online user on the overview page.
Comments
0 comments
Please sign in to leave a comment.