Last Updated: December 06 2023
Use the Exact Accounting Link - NL Only
Overview
Integrate Simpro Premium with your Exact accounting package to post transactions and card file information directly from Simpro Premium into Exact through the accounting link.
Before you begin posting your Simpro Premium transactions to Exact, you need to set up your Simpro Premium data and enable the Exact accounting link. Learn more in Set Up Simpro Premium for the Accounting Link.
In order to view content or perform actions referred to in this article you need to have the appropriate permissions enabled in your security group. Go to System > Setup > Security Groups and access your security group to update your permissions. The relevant security group tab and specific permissions for this article can be found here:
Before performing the steps detailed below, ensure that this part of your build is set up correctly. The relevant steps to set up the features and workflows detailed in this article can be found here:
To view and search for Simpro Premium transactions to be exported to Exact, go to Utilities > Exact > Transfer. Your transactions are then organised according to their transaction type.
To collapse the transaction type tables and view only the headings, number of transactions per type, and footer options, click Collapse All. To view all transactions within each transaction type table, click Expand All.
You can also filter your transactions by selecting from the following Search Types, then clicking Search:
Transaction Name / Number | Filter transactions by the Transaction Name / Number and the Transaction Type. You can enter an invoice or payment number, or customer, vendor, or contractor name in the Transaction Name / Number field. |
Date Range | Filter transactions according to the Date Range in which they were created, as well as the Transaction Type. |
Transaction Type | Filter transactions by their type, such as Customers, Customer Invoices / Credits, Customer Payments, Vendor and Contractors, or Vendor Invoices, Vendor Credits and Contractor Invoices. |
If a transaction has not yet been exported to Exact, it has a red N in the Exported column.
If it has successfully posted to Exact, it has a green Y in the column, and only appears if you search them using the filter options.
New transactions that you create in Simpro Premium appear in the accounting link if they are able to be transferred to Exact.
To transfer data to Exact:
- Go to Utilities > Exact.
- If you are not connected to your Exact account, click Connect to Exact and log in / click Authorise. You are directed to Simpro Premium and the Transfer tab appears.
- In the Transfer tab, select the transactions that you need to send to Exact.
- To send all transactions, select the Select All check box at the bottom of the page.
- Click Process Selected.
The data then transfers in the background, so you can exit the page and continue with other work in Simpro Premium. To return to the tab, go to Utilities > Exact.
When the transfer is complete, the Connection tab lists the status of each transaction as Successful or Failed.
If an item has failed to transfer:
- An error message appears explaining why the item failed to transfer.
- The item is not marked as exported.
- The item remains available to export from the Transfer tab until the error is fixed and it has transferred successfully.
You may need to mark specific transactions as exported without actually sending them to Exact, for example, to prevent creating duplicate transactions in Exact.
To mark transactions as exported:
- Go to Utilities > Exact > Transfer.
- If you are not connected to your Exact account, click Connect to Exact and log in / click Authorise. You are directed to Simpro Premium and the Transfer tab appears.
- In the Transfer tab, select the transactions that you need to mark as exported without sending to Exact.
- To mark all transactions, select the Select All check box at the bottom of the page.
- Click Mark as exported > OK.
If you have integrated your new Simpro Premium build with Exact and all of your contacts are set up in Exact, you can use the accounting link to perform an initial import of your Exact customers and suppliers into Simpro Premium.
To import customers and vendors from Exact:
- Go to Utilities > Exact > Import.
- If you are not connected to your Exact account, click Connect to Exact and log in / Authorise. You are brought back to Simpro Premium and the Transfer tab appears.
- Click the IMPORT CUSTOMERS or IMPORT VENDOR button.
- Once the relevant card files are imported the buttons are greyed out.
AU, NZ, UK, DK, IE only: If you use Simpro Premium outside of the United States, the term 'supplier' is used instead of 'vendor'.
The initial import does not import any archived cards or cards marked as inactive.
To access the Exact accounting link history, go to Utilities > Exact > History.
A log entry is created here when you:
- Open the accounting link connection
- Send card files or transactions to Exact
- Import payments from Exact
- Mark transactions as exported.
The log entry then details the Subject, Transaction Type, Transaction Name / Number, Status, the Employee who performed the action, and the Date and Time.
You can then filter results by entering the Transaction Name / Number, or selecting the Transaction Type, Log Status, or Log Date, then clicking Search.
The following errors can occur when posting contacts, including customers, vendors, and contractors to Exact:
First Name and Last Name are mandatory fields | If the card is an individual, then you must have both the First Name and Last Name fields completed before you can transfer the card into Exact. |
Company Name is a mandatory field | If the customer is a company, you need to complete the Company Name field. |
Customer / Vendor / Contractor status response from Exact is invalid |
Although it is possible a customer, vendor, or contractor transfer was successful, there was no valid response from Exact. You can verify whether or not the contact has posted successfully by accessing Exact. If it has, you can mark data as exported. If it has not, try to post the transactions again. If the problem persists then please contact Simpro Support. |
Duplicate found. Customer Invoice could not be posted to Exact |
There is already an invoice in Exact with the same invoice number. You can verify whether the invoice was already posted from Simpro Premium previously, or manually entered into Exact using the same numbering as Simpro Premium. |
AU, NZ, UK, DK, IE only: If you use Simpro Premium outside of the United States, the term 'supplier' is used instead of 'vendor'.
The following errors can occur when posting invoices, credits, vendor invoices, vendor credits, or contractor invoices to Exact:
The Tax Type field is mandatory | You may need to verify whether the account code is correct in Simpro Premium, that is, whether it is specified in System > Setup > Defaults > Financial, or if the wrong account type is entered. Learn more in How to Use Tax Codes. |
Account code '####' is not a valid code for this document | Either an account specified for the transaction does not exist, has been entered incorrectly, or is the wrong account type. For example, posting a sales invoice to an expense account as opposed to an income account. |
AU, NZ, UK, DK, IE only: If you use Simpro Premium outside of the United States, the term 'supplier' is used instead of 'vendor'.