Tripletex connector

Use your Tripletex data for reporting, automation and AI.

Data Panda brings your Tripletex data together with the data from the rest of your business. From one place, we turn it into dashboards, automations, AI workflows and custom apps your team uses every day.

Data Panda Reporting Automation AI Apps
Tripletex logo
About Tripletex

Where Norwegian SMBs keep their books.

Tripletex started in Oslo in 2002 as a cloud time-tracking and project tool, added bookkeeping and invoicing in 2006, and grew into one of the dominant accounting platforms for Norwegian SMBs. Visma bought the company in 2016, ran it as a standalone brand within the Visma group and saw the customer base grow past 150,000 since the acquisition. The product covers bookkeeping (bokforing), invoicing (faktura), payroll (lonn), time tracking (timeregistrering), expense reports, project accounting and inventory.

The localisation is the reason a Norwegian entity uses Tripletex instead of Exact Online or Yuki: Norwegian VAT (MVA), the A-melding payroll reporting flow to Skatteetaten, automatic bank reconciliation against Norwegian bank feeds and project accounting tuned to how Norwegian firms run hourly work. For a Belgian group with a Norwegian subsidiary, that depth is exactly what makes Tripletex hard to consolidate by hand. The books close cleanly in Oslo, but group reporting in Brussels waits on a monthly export, FX is handled twice and intercompany lines drift. The warehouse is where Tripletex sits next to the Benelux books and the commercial stack, and the group P&L stops being a manual merge.

What your Tripletex data is for

What you get once Tripletex is connected.

Group reporting with a Norwegian subsidiary

Consolidated P&L across the Norwegian Tripletex entity and the Benelux books, with FX, MVA and project margin handled.

  • Group P&L across Tripletex and Exact Online or Yuki entities
  • Per-entity AR aging and DSO on the same timeline
  • Working capital with NOK exposure visible

Cross-border ledger automation

Let the commercial stack post into the right Tripletex ledger without keying twice.

  • Shopify orders into Tripletex with Norwegian MVA
  • Stripe payouts reconciled per Tripletex entity
  • HubSpot deals creating Tripletex customers and invoices

AI workflows on Norwegian books

Use Tripletex history to score risk, classify project hours and forecast cash across entities.

  • Late-payer scoring across NOK and EUR customers
  • AI-assisted MVA coding on supplier invoices
  • Cash forecasting across Tripletex and Benelux ledgers

Custom apps on your Nordic data

Internal tools on Tripletex data for group finance and the Norwegian entity manager.

  • Group CFO view with Tripletex and Exact Online in one consolidation
  • Project-margin dashboard tied to Tripletex timeregistrering
  • AR workbench with intercompany NOK and EUR balances visible
Use cases

Use cases we deliver with Tripletex data.

A list of concrete reports, automations and AI features we have built on Tripletex data. Pick the one that matches your situation.

Group consolidated P&LAcross the Tripletex entity, Exact Online and Yuki.
AR aging per entityOpen receivables across the Norwegian and Benelux books.
FX exposureBalances and commitments by NOK and EUR, live rate.
MVA preparationNorwegian VAT period totals ready for Skatteetaten review.
Project profitabilityTripletex hours and costs per project, margin per quarter.
Intercompany balance checkMismatches between Tripletex and Benelux entities, flagged.
Bank reconciliationMatch rate per Tripletex entity, on Norwegian bank feeds.
Payroll cost per cost centreNorwegian lonn data tied to project and department.
Late-payer trendRolling DSO across Norwegian and Benelux customers.
Cash-flow forecastBooked invoices plus recurring patterns, thirteen-week view.
Real business questions

Answers you will finally get.

How does the Norwegian entity look on the same group P&L as Belgium?

Tripletex lands in the warehouse next to Exact Online or Yuki, with FX translated and the chart of accounts mapped. Consolidation becomes a view that is ready the day the local books close, not a monthly export from Oslo that the Brussels controller has to re-key.

Are MVA codes consistent between Tripletex and the Benelux books?

Norwegian VAT codes from Tripletex are mapped against the Belgian and Dutch btw codes used in Exact Online or Yuki. Drift between entities (a Norwegian reverse-charge that lands as standard btw in the group view, for instance) is flagged before it becomes a year-end correction.

Can we see Tripletex project hours next to project revenue?

Tripletex timeregistrering, project costs and project invoices come into the warehouse with the same project ID, so margin per project shows up in one view across the Norwegian entity and the rest of the group, instead of three exports stitched together at month-end.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Group consolidation across Tripletex, Exact Online and Yuki updated daily, with intercompany, FX and MVA handled. Month-end becomes a review, not a merge with an Oslo export.

For sales leaders

AR visibility per entity and per account before offering new credit cross-border. A deal in the Norwegian entity is judged on the same customer-payment behaviour visible in the Benelux books.

For operations

Norwegian payroll, project hours and cost-centre data on the same timeline as the Benelux operations. Shared-services finance stops guessing why the Nordic numbers drift.

Ideas

What you can automate with Tripletex.

Pair with Shopify

Post Shopify orders into the Norwegian Tripletex entity

Shopify orders shipping to Norway land in Tripletex as sales journal entries with MVA handled per rate, while orders shipping to Benelux post to Exact Online or Yuki. Refunds flow back as credit notes in the right book. The Nordic webshop revenue stops needing a weekly export to the Oslo accountant.

Pair with Stripe

Reconcile Stripe payouts per Tripletex entity

Stripe payouts in NOK and EUR are booked per Tripletex entity, fees split out and the underlying charges matched to the Tripletex invoices they paid. The bank reconciliation screen stops showing multi-currency Stripe lumps that the Norwegian controller has to split by hand.

Pair with HubSpot

Turn HubSpot deals into Tripletex customers and invoices

Closed-won HubSpot deals create or update customers in the Norwegian Tripletex entity and prepare draft invoices with the right MVA coding. Sales sees Tripletex payment history on the HubSpot record before offering net-30 to a Norwegian account that already pays late.

Pair with SendCloud

Match Sendcloud shipments to Tripletex costs

Sendcloud shipping labels and carrier invoices for Norwegian deliveries land in Tripletex as supplier entries, allocated to the order or project they belong to. Logistics cost per Norwegian order shows up in the same view as the gross margin on that order, instead of arriving as a quarterly carrier-statement surprise.

Data model

Tables we make available.

These are the 17 tables we currently pull from Tripletex into your warehouse. Query them directly in SQL, join them to the rest of your stack, or build reports on top.

  • Activities
  • Balance Sheet
  • Contacts
  • Customers
  • Departments
  • Divisions
  • Employees
  • Inventory
  • Invoices
  • Ledger
  • Order
  • Pension
  • Products
  • Projects
  • Supplier
  • Supplier Invoice
  • Travel Expense

Missing a table you need? We can extend the sync. Tell us what is missing and we will build it for you.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your Tripletex data lives.

Power BI logo
Power BI Microsoft
Microsoft Fabric logo
Fabric Microsoft
Snowflake logo
Snowflake Data warehouse
Google BigQuery logo
BigQuery Google
Tableau logo
Tableau Visualisation
Microsoft Excel logo
Excel Sheets & pivots
Three steps

From Tripletex to answers in three steps.

01

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

02

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

03

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

  • Tripletex connector configured and running
  • Warehouse set up in your cloud account
  • Clean access for your Power BI, Fabric or Tableau team
  • Documentation on what's in the data model
  • Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

  • Everything in Self-serve
  • Dashboards built to the questions your team actually asks
  • Automations between your systems
  • AI workflows scoped to real tasks your team runs
  • Custom apps where a dashboard does not cut it
  • Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

Does Tripletex expose an API the warehouse can read from?

Yes. Tripletex publishes a REST API covering customers, invoices, vouchers, accounts, projects, hours and payroll. We connect per Tripletex company with a token and pull each domain on a schedule, so the warehouse has yesterday's books available the moment finance walks in.

Is Norwegian MVA handled in the warehouse?

Yes. MVA codes, rates and reverse-charge indicators come across on every voucher, so input and output VAT can be totalled per period and per rate. That makes the Skatteetaten return preparation a report instead of a re-coding exercise, and lets the group view spot drift between Norwegian and Benelux btw treatment.

Do Tripletex projects and timeregistrering come across?

Yes. Project headers, project hours and project-tagged invoices arrive in the warehouse with the same project ID, which is what makes margin per project visible alongside the booked revenue and cost rather than as a separate Tripletex report.

GDPR-compliant
Data stays in the EU
You own the warehouse

A first deliverable live in four to six weeks.

We review your Tripletex setup and the systems around it. Together we pick the first thing worth building.