WeFact connector

Use your WeFact data for reporting, automation and AI.

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

Where Dutch SMEs send the invoice.

WeFact is a Dutch invoicing and light-CRM platform out of Eersel, running for ondernemers since 2005. The product wraps quotes, sales invoices, purchase invoices, subscriptions, products, payments and a contact-moment log around an account that an owner-operator can run without a bookkeeper sitting next to them. It hands off cleanly to the actual ledger via direct connections to Exact Online, Yuki, SnelStart, Twinfield and a handful of others, and it pairs natively with Mollie for payment links and PSD2 banks for reconciliation.

That makes WeFact the place where the money story of a Dutch SME starts: the quote that became an order, the recurring subscription that bills tomorrow, the customer whose last invoice is two weeks overdue. Pulling it into a warehouse turns those rows into something the rest of the business can use. Recurring revenue, churn on subscriptions, average days to payment per customer and quote-to-invoice conversion all live across WeFact and whatever sales or operational system feeds it. WeFact is great at sending the invoice. It is not built to answer the questions a board asks the morning after.

What your WeFact data is for

What you get once WeFact is connected.

Invoice-backed reporting

Recurring revenue, debtor aging and quote conversion tied to WeFact rows, without a weekly export.

  • Monthly recurring revenue per subscription product
  • Days sales outstanding per customer and segment
  • Quote-to-invoice conversion per salesperson

Billing automation

Let the invoicing tool react to what sales and operations already know.

  • Won deals in HubSpot become WeFact quotes or invoices
  • Failed Mollie payments raise a sales follow-up task
  • Subscription cancellations sync back to the CRM record

AI workflows

Use WeFact history to score payment risk, predict churn and forecast cash.

  • Late-payer scoring per customer and per segment
  • Churn-risk score on subscriptions with failing or shrinking invoices
  • Cash forecast from receivables and the recurring book

Custom apps on your data

Internal tools on WeFact data for people who should not have a WeFact login.

  • Open-receivables lookup for account managers before a renewal call
  • Subscription dashboard for the owner without giving full WeFact access
  • Quote-pipeline board tied to deal stage in the CRM
Use cases

Use cases we deliver with WeFact data.

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

MRR per productMonthly recurring revenue per subscription product, in and out of contract.
Subscription churnCancellations and downgrades per cohort, with the reason if recorded.
DSO per customerAverage days sales outstanding per account, twelve months back.
Quote conversionShare of quotes that became invoices, per rep and per segment.
Failed-payment trendMollie or bank failures per subscription, surfaced before churn.
Late-payer watchlistCustomers whose own DSO has worsened over the last two quarters.
Cash forecastReceivables aging plus the recurring book, thirteen weeks out.
Product-mix revenueRevenue per product line, with VAT split out.
Customer concentrationShare of revenue from the top ten accounts, by quarter.
Renewal pipelineSubscriptions due for renewal in the next ninety days.
Real business questions

Answers you will finally get.

Which subscriptions are about to churn?

Subscriptions ranked by failed Mollie or bank payments over the last three cycles, combined with downgrades on the same account. Surfaces the customer whose recurring invoice keeps bouncing weeks before the cancellation email lands.

What is our real DSO per customer, including credit notes and partial payments?

Days sales outstanding per account computed on invoice date against payment date, with credit notes and partial payments handled, rolled up per segment and per salesperson. Replaces the average that hides the two accounts dragging the whole portfolio.

How much of next month's revenue is already on the WeFact subscription book?

Sum of recurring invoices scheduled to bill in the next thirty days from active WeFact subscriptions, split by product and by customer segment. Tells the owner what is committed before the new-business pipeline is even consulted.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Recurring revenue, debtor aging and cash forecast tied to WeFact invoice and subscription rows. Month-end reporting closes on numbers that already exist in the billing tool, not on a spreadsheet rebuilt from a CSV.

For sales leaders

Open receivables and payment history visible on the customer record before you offer new terms or a renewal price. A renewal won at a discount on an account that pays sixty days late is not won.

For operations

Subscription health, failed-payment trend and quote-to-invoice conversion in one place. Operations sees which products carry the recurring revenue and which ones cause the support ticket spike that follows a price change.

Ideas

What you can automate with WeFact.

Pair with Exact Online

Flow WeFact invoices into Exact Online

WeFact invoices and credit notes land in Exact Online as journal entries with VAT, GL coding and customer set, and payment status flows back. The Dutch SME closes the month on numbers already booked, instead of reconciling the billing tool against the ledger by hand.

Pair with Yuki

Post WeFact invoices into Yuki

Sent invoices, credit notes and bank-matched payments from WeFact land in Yuki as sales journal entries with VAT codes and customer references intact. The accountant works in Yuki, the owner works in WeFact, and neither has to ask the other for a CSV at month end.

Pair with HubSpot

Sync HubSpot deals with WeFact quotes and invoices

A won HubSpot deal raises a WeFact quote or invoice with the right product, price and contact pre-filled. Invoice and payment status flow back onto the HubSpot company record so the next sales conversation starts with the customer's actual payment behaviour, not yesterday's pipeline number.

Pair with Mailchimp

Segment Mailchimp lists on WeFact subscription state

Customers in WeFact with active, lapsed or failing subscriptions land in their own Mailchimp segments, kept in sync. Renewal nudges, win-back campaigns and product-news mails go to the right list, and customers in arrears stop being asked to upgrade.

Pair with Slack

Alert Slack on failed subscription payments

A failed Mollie or bank payment on a WeFact subscription posts to a Slack channel with the customer, the product and the payment history attached. Customer success picks up the call before the third failure tips the customer into cancelling.

Pair with WooCommerce

Bring WooCommerce orders into WeFact

WooCommerce orders post into WeFact as invoices with line items, VAT and shipping split out, and refunds raise credit notes. The webshop owner stops keeping a separate spreadsheet to map shop orders against the invoicing tool.

Data model

Tables we make available.

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

  • Creditinvoices
  • Creditors
  • Debtors
  • Invoices
  • Pricequotes
  • Products
  • Subscriptions
  • Tasks
  • Transactions

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

  • WeFact 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.

How are WeFact subscriptions and periodic invoices represented in the warehouse?

WeFact subscriptions land as their own table with billing frequency, next-invoice date, product and customer keys, joined to the actual invoice rows they generate. That lets you compute monthly recurring revenue, churn and renewal pipeline directly, instead of inferring them from a stream of invoices.

Does Mollie and PSD2 payment status come across alongside the invoices?

Yes. Payment events from WeFact's Mollie and bank reconciliation arrive as their own rows joined to invoices, so paid, partially paid, failed and open are first-class states. That makes failed-payment trend, true DSO and cash-flow timing reportable without exporting from each tool separately.

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

A first deliverable live in four to six weeks.

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