ENK connector

Use your ENK data for reporting, automation and AI.

Data Panda brings your ENK 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
ENK logo
About ENK

The ERP that runs installation and construction SMEs in the Netherlands.

ENK Software has built business software for installation and construction companies since the mid-1990s, from Uitgeest. The platform now sits under more than 1,200 firms with around 11,000 active users, covering calculation, quoting, planning, work orders, service, invoicing and a refrigerant balance for HVAC operators. The mobile app puts the same work orders, hours and material lines in the hands of the technician on site.

The reason to pull ENK out into a warehouse is that the office, the field and the bookkeeper each live in a different slice of it. Realised hours per project, material margin, service-contract profitability and the gap between calculated and actual cost all sit inside ENK in pieces. In a warehouse, ENK becomes the operational source of truth for the project economy, and the accounting numbers in Exact Online, Snelstart or Twinfield line up against it without a monthly export.

What your ENK data is for

What you get once ENK is connected.

Project economy on one screen

Calculated against realised, per project and per crew, while the project still runs.

  • Realised hours and materials versus calculated
  • Margin per project, customer and project type
  • Service-contract profitability per contract

Field-to-back-office automation

Let work orders, hours and materials flow without retyping.

  • Work orders billed automatically once closed and signed
  • Material consumption posted as purchase commitments
  • Hours pushed straight into payroll exports

AI workflows on project history

Use years of work orders to estimate, schedule and price better.

  • Calculation suggestions from comparable past projects
  • Service-call duration prediction per asset type
  • Anomaly flags on hours or material lines per work order

Custom apps on your data

Tools for the field, planning and finance without giving everyone an ENK seat.

  • Project-margin board for the project leader
  • Customer portal showing open work orders and contracts
  • Foreman dashboard with today's planning and last week's hours
Use cases

Use cases we deliver with ENK data.

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

Calculated vs realisedHours and materials per project, calculation against work order.
Margin per projectRevenue minus realised hours and materials, per project and customer.
Service-contract marginRecurring revenue against intervention cost per contract.
Crew loadBillable hours against available hours per technician and crew.
Material spend per projectPurchase commitments and consumption tied to the work order.
Refrigerant balanceCharged versus recovered refrigerant per asset and per technician.
Quote-to-invoice lagDays from quote accepted to first invoice sent.
Service-call response timeHours between service call logged and technician on site.
Recurring vs project mixShare of revenue from contracts versus one-off project work.
Customer concentrationRevenue and outstanding work orders per top customer.
Late work-order closingWork orders open beyond expected end date, by crew.
Travel time per jobLogged travel against billed travel, per project and per technician.
Real business questions

Answers you will finally get.

Which projects are quietly losing money before they close?

Realised hours and material lines from work orders pulled per project, ranked against the original calculation. Shows the project where the third week of overrun is already there in the data, before the closing invoice surfaces it as a margin miss.

Are our service contracts profitable, contract by contract?

Recurring contract revenue tied to every service intervention booked against it, including hours, travel and parts. Replaces the gut feeling about service work with a per-contract P&L the renewal conversation can lean on.

Where is the gap between hours we billed and hours the crew wrote down?

Hours from ENKMobile compared with hours invoiced on the work order, per technician and per project. Surfaces the unbilled hour leak and the over-budget project where the foreman covered for a slow week.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Project margin and service-contract profitability based on actual hours and materials from ENK, lining up cleanly against the ledger in Exact Online, Snelstart or Twinfield. Month-end stops being a reconciliation between the field and the books.

For sales leaders

Open work orders, last calculation versus realised cost and outstanding receivables visible per customer before the next quote goes out. The next price reflects what the last project really cost to deliver.

For operations

Calculated versus realised, crew load and service-contract intervention cost in one place. Where the project leader and the planner have been arguing from two different spreadsheets, they argue from the same table.

Ideas

What you can automate with ENK.

Pair with Exact Online

Push ENK invoices into Exact Online

Closed work orders and project invoices in ENK post into Exact Online as sales journal entries with VAT, customer and ledger coding resolved. The accounting team stops re-typing what the project leader already signed off on, and the books close on the same project totals the field saw.

Pair with SnelStart

Sync ENK invoices into SnelStart

Outgoing project invoices and credit notes flow from ENK into SnelStart with VAT and project reference attached. SMEs running ENK on the operational side and SnelStart on the books get a single chain from quote to bookkeeping without weekly CSV exports.

Pair with Ponto

Match Ponto bank data to ENK invoices

Ponto transactions match against open ENK invoices on amount and structured reference. Daily collection becomes an exception list of mismatches instead of a manual hunt through bank statements per project leader.

Pair with Power BI

Build project-margin reporting in Power BI

ENK projects, work orders, hours and material lines land in a warehouse and drive Power BI reports on calculated versus realised margin per project type and per crew. The project leaders see the same numbers as the owner, refreshed daily.

Pair with Microsoft Outlook Calendar

Push ENK planning into Outlook Calendar

Scheduled work orders from ENK appear as calendar entries on the technician's Outlook with customer, address and job notes. The crew stops checking two systems for what they're doing tomorrow, and last-minute changes propagate without a phone call.

Pair with HubSpot

Sync ENK customers and projects to HubSpot

Active ENK customers, the projects in flight and last-invoice dates land on the HubSpot company record. Sales calls a customer with the open service contract and last project margin in front of them, not five tabs away.

Data model

Tables we make available.

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

  • Bestellingen
  • Bewakingscodes
  • Calc Onderdelen
  • Calc Regels
  • Calculatie Hoofdstukken
  • Calculaties
  • Dagboeken
  • E N K Data Relaties
  • Facturen
  • Faktuurregels
  • Grootboekrekeningen
  • Ink Fact Regels
  • Inkfacturen
  • Kostenplaatsen
  • Montagegangen
  • Offertes
  • Opdrachtbon Regels
  • Opdrachtbonnen
  • Personeel
  • S Y N C D E L E T E D R E C S
  • Termijnstaat Regels
  • Termijnstaten
  • Uursoorten
  • Uurtariefcodes
  • Werkbon
  • Werkbonregels
  • Werken
  • Werksoorten

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 ENK 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 ENK 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.

  • ENK 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 the sync include data from the ENKMobile app?

Yes. Hours, travel time, material lines, checklists and signatures captured by technicians on ENKMobile are part of the same project and work-order data model in the warehouse. The mobile capture is exactly where calculated-versus-realised reporting becomes meaningful, so it lands first-class, not as an afterthought.

How does this fit if we already push ENK invoices to Exact Online or Twinfield?

It does not replace the ENK-to-bookkeeping link. The warehouse sits next to it: ENK provides the operational layer (projects, hours, materials, work orders) and the accounting tool stays the source of truth for the ledger. We line up the two so a project P&L matches the ledger, instead of being a separate spreadsheet.

What about the refrigerant balance HVAC operators have to maintain?

Charged and recovered refrigerant captured per intervention in ENK lands in the warehouse alongside asset and technician dimensions. F-gas reporting and the per-asset balance can be produced as a query against actual interventions, not as a year-end pull from the operations team.

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

A first deliverable live in four to six weeks.

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