Tripletex integration

3 min. readlast update: 10.18.2023

With Tripletex you can continue receiving supplier invoices directly to Tripletex. CostTracker only read data such as suppliers, nominal codes, projects, and departments and read accounting transactions from Tripletex and match these with Purchase orders in CostTracker based on pre-defined rules.

undefined

How to set up the integration

To enable the integration you need to activate CostTracker as an extension in Tripletex and use the key you receive to link the two systems. 

In Tripletex you first need to activate API 2.0 within Company (Selskap) --> Customer portal (Vår kundeside) and approve the agreement. Once agreed you can get the API key/client token from Tripletex. This can be done as displayed below. Choose "Tilpasset oppsett" and "Alle tilganger". Write "CostTracker" as application provide the client token a name. Select "Opprett nøkkel" and save the token.

undefined

In CostTracker go to Settings --> Integrations and choose Tripletex 

Add the key to the client token field and select "Connect"

undefined

Integration filter

After connecting, you will have the ability to set up a filter for which data you want to ready from Tripletex. 

undefined

Start date - only transactions after this date will be transferred to CostTracker. 

G/L code - here you can set intervals of G/L accounts (for example 4000-4999), individual accounts or combinations (as displayed above)

Project - select one or multiple Project(s) 

Department - select one or multiple Department(s)

Automatic matching criteria

In order to automate as much as possible, you can set criteria for when accounting transactions should be automatically matched with a purchase order. This can also be set later under Accounting --> Accounting Transactions (grey symbol in the top right corner)

undefined

When setting the automatic matching criteria you can choose between the following. Each activated criteria will be run in sequence. 

undefined

  

The matching criterias run in sequence, meaning that if more than one is enabled it will test the one on the top first, then the next, and so on until it has a match. 

PO number on invoice - Match if the purchase order number is entered in the "Purchase order no / Bestillingsnr" field in the accounting system.

PO number in description field - Match if the PO number is part of the description field in the accounting system

Same supplier and project (1:1) - Match if there is only one open purchase order on the same supplier and project

Same supplier and value is +/- x % - Match if there is a 1:1 match within the same percentage rate, for example, if set to 10% and the PO value is 100 and the invoice value is between 90 and 110.

Same supplier and value is +/- x - Match if there is a 1:1 match within the same percentage rate, for example, if set to 10 and the PO value is 100 and the invoice value is between 90 and 110. 

After setting the matching criteria, save changes or refresh (if you want to synchronize data)

In the Accounting transaction view, you can see what has been matched automatically ("Auto-matched") and what has been matched manually ("Matched") and you also have the link to the relevant purchase order and invoice.

undefined

  Synchronizing data

Data is automatically synchronized every night, but you can also perform a manual synchronization by selecting the refresh symbol in the top right section under "Suppliers" or under "Accounting transactions". See the example from the Supplier section below:

undefined

  

Was this article helpful?