ArchX connector

Use your ArchX data for reporting, automation and AI.

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

Data Panda Reporting Automation AI Apps
ArchX logo
About ArchX

The platform Belgian architecture and engineering studios run on.

ArchX is a Belgian cloud ERP built for architecture and engineering firms, covering project administration, time registration, planning, document workflows, fee and contract management, and invoicing through Peppol. Where AutoCAD or Revit handle the drawing side, ArchX runs the practice: who works on which project phase, against which fee, with which deliverables and at what realisation.

The point of pulling ArchX into a warehouse is that fee realisation in a studio leaks the same way it does in any project-based business, only it hides inside per-project files. The Monday morning run-through sees the invoice that went out. The warehouse sees the hours behind it, the phases that ran past their fee, the contract types where realisation drifts every year, and the projects that quietly stopped being profitable two phases ago. Next to Exact Online, Microsoft Dynamics 365 Business Central or HubSpot, ArchX becomes the studio's own P&L signal in real time.

What your ArchX data is for

What you get once ArchX is connected.

Studio-wide realisation reporting

Hours, fees and realisation per project, phase and partner.

  • Realisation per project phase against contracted fee
  • Partner and team load against target
  • Fee drift per contract type and project size

Studio automation

Let ArchX events fire the rest of the firm's stack.

  • Approved invoices flow into Exact Online with VAT and ledger coding
  • New projects in ArchX open the matching CRM record in HubSpot
  • Phase completion in ArchX posts a status update into Slack

AI workflows

Use studio history to forecast risk and workload.

  • Realisation-risk scoring per project and phase
  • Workload forecast per discipline and quarter
  • Fee-bid scoring on new project types based on past realisation

Custom apps on your data

Internal tools on ArchX data for partners and project leaders.

  • Partner workbench with loss-making projects this quarter
  • Project-leader dashboard with hours, fee burn and deliverables
  • Studio-manager load board across disciplines
Use cases

Use cases we deliver with ArchX data.

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

Realisation per projectContracted fee versus hours at internal rate, per phase.
Phase overrunHours booked beyond the budgeted fee, per phase and project type.
Partner loadBillable hours per partner and team, rolling twelve weeks.
Fee drift over yearsRealisation trend per contract type, year on year.
Hours not yet invoicedBillable hours outside any invoice, per project and partner.
Project profitabilityMargin per project, after hours at cost.
Workload forecastCommitted phases versus planned capacity per discipline.
Deliverable statusDocuments per phase, owner and due date across the studio.
Timesheet completenessCompletion rate per staff member and week.
Multi-office consolidationOne view across studios within a firm group.
Real business questions

Answers you will finally get.

Which projects have quietly stopped being profitable?

Hours at cost against contracted fee per project and phase, across the last twelve and twenty-four months. Ranks the projects whose phases keep eating hours while the fee was set at the start, which is where most studio margin disappears.

Where is fee realisation leaking, and on whose projects?

Realisation pattern per partner, contract type and project size. Exposes the pattern that nobody at the Monday review wants to name, because the data makes it visible regardless of who runs the room.

Does next quarter's project pipeline match the capacity we have?

Committed phase hours against planned capacity per discipline and quarter, with delivery dates on the same view. Hire-or-reassign conversations happen the quarter before overtime starts, not after a deadline slips.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Realisation, fee health and studio P&L tied to timesheet, invoice and contract data. Fee setting on new projects moves from gut feel to the contract-by-contract view of where margin is leaking on the existing book.

For sales leaders

New-project pipeline, proposal-to-signed conversion and contract-type performance. Growth conversations stop leaning on which partner remembers which proposal is still out.

For operations

Utilisation, timesheet completeness and workload forecast across disciplines on one board. Resourcing and planning decisions are made against data, not against the loudest project leader at the meeting.

Ideas

What you can automate with ArchX.

Pair with Exact Online

Flow ArchX invoices into Exact Online

Approved invoices in ArchX post to Exact Online with customer, VAT and ledger coding aligned. Partners see realisation against the contracted fee and the ledger view stays consistent for the year-end audit, without re-keying figures into the bookkeeping.

Pair with MS Dynamics 365 Business Central

Connect ArchX projects to Business Central

Studios on Microsoft Dynamics 365 Business Central keep their ArchX projects, contracts and invoices aligned with the group ledger. Project-level realisation rolls into the same financial dimension as the rest of the group, so the consolidation no longer waits on per-studio exports.

Pair with HubSpot

Connect ArchX projects with the HubSpot CRM record

New projects opened in ArchX create or update the matching company and deal in HubSpot, with contract value, project type and partner owner carried over. Sales and partner conversations happen on one customer record, not on a CRM that lost track of the project the moment it was signed.

Pair with monday.com

Connect ArchX phases to monday.com boards

Project phases in ArchX appear as items on the studio's monday.com board, with deliverables, owner and due date in sync. Project leaders work in the planning tool the team already uses, while ArchX stays the system of record for fee, hours and contract.

Pair with Slack

Push ArchX phase events into Slack

Phase completion, fee threshold reached, deliverable overdue and new contract signed events from ArchX post into the right Slack channel for the studio. The team reacts the same day, instead of catching the signal on the next Monday review.

Pair with Salesforce

Align ArchX contracts with Salesforce opportunities

Larger studios running Salesforce as the group CRM keep ArchX contracts and the originating Salesforce opportunity linked, so won-revenue, fee value and project type are reported on the same record. Sales operations and studio operations stop arguing about which number is the real one.

Data model

Tables we make available.

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

  • Companies
  • Contracts
  • Invoices
  • Project Plots
  • Project Statuses
  • Projects
  • Tasks
  • Users
  • Users Disabled

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

  • ArchX 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 cover multi-studio firms and partner-level reporting?

Yes. Each studio lands with the right dimension and partner identity is preserved. Firm groups get per-studio and per-partner realisation plus a group-level view, without merging timesheet and invoice data by hand.

Are fixed-fee contracts, hourly work and add-on work kept apart?

Yes. Fixed-fee project agreements, hourly engagements and add-on work come across as distinct constructs so realisation can be measured the way each project was sold. Mixing them in one studio average, which is where realisation conversations usually go wrong, stops happening.

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

A first deliverable live in four to six weeks.

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