Exact Financials is Exact's accounting software that runs on a server managed by your firm or your IT partner, rather than in the Exact Online cloud. If your firm books through Exact Financials, 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: If your firm uses Exact Online, see the article ↪ Exact Online instead. 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 Financials works both ways:
- Legalsense sends debtors, matters, invoices, and credit invoices to Exact Financials. Debtors become debtors, matters become projects, and invoices are booked as entries in your sales journal. Legalsense sends the bookings only, not the invoice PDF.
- Legalsense retrieves payments on invoices, creditors, purchase invoices booked on a disbursement ledger account (which become disbursements on the matter), and trust accounting transactions.
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 Financials 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 Financials integration has to be activated for your environment by Legalsense. If Settings → Exact Financials 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 and the IT partner who manages your Exact server, because the connection has to be prepared on the Exact side first.
To set up the integration, you need:
-
The base URL of the Exact REST web services on your Exact server, for example
https://exact.yourfirm.nl:8443/. Legalsense must be able to reach this address over the internet. - An authorization token for the Exact REST web services.
- The administration numbers for your regular bookkeeping and for trust accounting. These can be the same administration.
- The email address of the person who should be notified when the synchronization fails.
- Your chart of accounts, VAT codes, journal numbers, cost centers, project group, and project cost category in Exact Financials, so you can map them in Legalsense.
Note: Exact Financials uses numeric debtor numbers. If you use Legalsense's debtor or client numbers, they must consist of digits only. A number in the format D00001 also works: Legalsense removes the D.
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 Financials → Overview and click Set up Exact Financials now.
Exact Financials overview page showing that Exact Financials isn't set up yet, with the Set up Exact Financials now button.
- In the Connection step, fill in the Base URL and the Authorization token, then click Next. Make sure the base URL ends with a forward slash (/). Legalsense checks the connection when you continue. If something is wrong, an error appears below the field. See Troubleshooting below.
Exact Financials setup, Connection step, showing the Base URL and Authorization token fields.
- In the Administration step, select the Administration* for your bookkeeping and the Trust accounting administration*, then click Next. Each administration is shown with its number and description.
Exact Financials setup, Administration step, showing the Administration and Trust accounting administration 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.
- In the Import and export step, choose which data Legalsense sends and retrieves, then click Next. See Import and export options below.
Exact Financials 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 select the Exact Financials ledger account, VAT code, or cost center for each row. The lists show the data from your Exact administration. Click Next.
Exact Financials setup, Ledger accounts step, with Customize the ledger accounts selected and the Journals and Cost centers sections visible.
Important: The Legalsense default ledger accounts are generic suggestions and don't match your administration in Exact Financials. Check every row with your bookkeeper. In particular:
- Under Journals, enter the journal numbers of your Sales journal, Purchase journal, and Memorial journal in Exact Financials.
- Under Other, enter your Project group code and Project cost category code. Legalsense uses these for the projects it creates for your matters.
See the article ↪ Managing the integration with accounting software for what each section is for.
-
In the Revenue accounts per user step, choose whether to book revenue for each timekeeper to a different ledger or cost center, then click Next.
-
In the Accounts for disbursement types step, choose whether to book each disbursement type to its own ledger account, then click Next.
-
In the Initial synchronization step, choose which existing data Legalsense sends to Exact Financials 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
Exact Financials setup, Initial synchronization step, with Synchronize transactions starting from selected.
- Click Done, commence syncing, then click Yes to confirm.
Legalsense now sends your debtors and active matters, and the invoices in the period you chose, to Exact Financials. Go to Settings → Exact Financials → Overview to follow the progress.
Exact Financials overview page after setup, showing the status, last successful sync, and number of elements in the queue.
Import and export options
Fields marked with an asterisk (*) are required when you choose to import expenses.
Troubleshooting
Base url is not reachable
Legalsense can't reach your Exact server at this address. Check the base URL with your IT partner, including the port number and the forward slash at the end, and make sure the server accepts connections from the internet.
Invalid bearer token. Please check the token is valid.
The Exact server rejected the authorization token. Check that you copied the complete token, or request a new one.
Possible changes to the Exact REST API detected, please contact with Legalsense support. Legalsense reached the address, but didn't get the response it expects from the Exact REST web services. Check that the base URL points to the REST web services and ends with a forward slash. If it does, contact Legalsense support for further guidance.
Unable to match project code … to Matter
A purchase invoice line in Exact Financials refers to a project that doesn't match a matter in Legalsense. Correct the project on the purchase invoice in Exact Financials. If the matter exists in Legalsense, make sure it has been synchronized to Exact Financials, or contact Legalsense support.
The synchronization stopped with an error in Dutch, such as Bestaat niet or Ongeldige waarde.
These messages come from Exact Financials itself. "Bestaat niet" means that a debtor, ledger account, journal, or code Legalsense refers to doesn't exist in your administration. "Ongeldige waarde" means that a value isn't accepted. Check the mapping on the Ledger accounts page, then click Sync now on the overview page, or wait for the next automatic synchronization. See the article ↪ Managing the integration with accounting software for the other errors.
Comments
0 comments
Please sign in to leave a comment.