Fortnox connector

Use your Fortnox data for reporting, automation and AI.

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

Where Swedish SMBs keep their books.

Fortnox is a cloud accounting and ERP platform out of Vaxjo, Sweden, founded in 2001 and listed on Nasdaq Stockholm since 2023 after starting on Nasdaq First North in 2007. It is the dominant SMB accounting tool in Sweden, covering bookkeeping (bokforing), invoicing (fakturering), payroll (lon), time tracking and project administration. The localisation runs deep: Swedish VAT (MOMS), Skatteverket reporting, the K-regelverk accounting framework and Swedish payroll rules are baked in, which is exactly why a Nordic subsidiary uses Fortnox instead of Exact Online or Yuki.

The point of pulling Fortnox into a warehouse is that a Benelux group with a Swedish entity ends up running two accounting platforms that never line up on the same day. Group reporting waits on a monthly export from Sweden, FX is handled twice, and the questions that cross entities get answered with a spreadsheet. In a warehouse, Fortnox sits as a first-class source next to the Benelux books and the commercial stack, and the group P&L stops being a manual merge.

What your Fortnox data is for

What you get once Fortnox is connected.

Group reporting with a Nordic subsidiary

Consolidated P&L across the Swedish Fortnox entity and the Benelux books, with FX and MOMS handled.

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

Cross-border automation

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

  • Shopify orders into Fortnox with Swedish VAT
  • Stripe payouts reconciled per Fortnox entity
  • HubSpot deals creating Fortnox customers and invoices

AI workflows

Use Fortnox history to score risk and classify invoices across entities.

  • Late-payer scoring across SEK and EUR customers
  • AI-assisted coding on supplier invoices, per country
  • Cash forecasting across Fortnox and Benelux ledgers

Custom apps on your data

Internal tools on Fortnox data for group finance and the Swedish entity manager.

  • Group CFO view with Fortnox and Exact Online in one consolidation
  • Subsidiary-manager dashboard tied to Swedish KPIs
  • AR workbench with intercompany SEK and EUR balances visible
Use cases

Use cases we deliver with Fortnox data.

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

Group consolidated P&LAcross the Fortnox entity, Exact Online and Yuki.
AR aging per entityOpen receivables across the Swedish and Benelux books.
FX exposureBalances and commitments by SEK and EUR, live rate.
MOMS preparationSwedish VAT period totals ready for Skatteverket review.
Margin per customerNet of credit notes and discounts, per entity.
Intercompany balance checkMismatches between Fortnox and Benelux entities, flagged.
Bank reconciliationMatch rate per Fortnox entity, on Swedish bank feeds.
Payroll cost per cost centreSwedish lon data tied to project and department.
Late-payer trendRolling DSO across Swedish and Benelux customers.
Cash-flow forecastBooked invoices plus recurring patterns, thirteen-week view.
Real business questions

Answers you will finally get.

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

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

Are MOMS codes consistent between Fortnox and the Benelux books?

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

Can we see Swedish payroll cost in the same place as Benelux payroll?

Lon data from Fortnox feeds into the warehouse with cost centre and project tagging. The group sees Swedish staff cost per department and per project on the same timeline as the Benelux payroll, without waiting for a quarterly consolidation.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Group consolidation across Fortnox, Exact Online and Yuki updated daily, with intercompany, FX and MOMS handled. Month-end becomes a review, not a merge with a Stockholm export.

For sales leaders

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

For operations

Swedish payroll, project 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 Fortnox.

Pair with Shopify

Post Shopify orders into the Swedish Fortnox entity

Shopify orders shipping to Sweden land in Fortnox as sales journal entries with MOMS 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 Stockholm accountant.

Pair with Stripe

Reconcile Stripe payouts per Fortnox entity

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

Pair with HubSpot

Turn HubSpot deals into Fortnox customers and invoices

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

Pair with Klarna

Reconcile Klarna settlements with Fortnox invoices

Klarna order and settlement data lands in Fortnox tied to the original sales invoice, with fees and reserves split out per payout. The Swedish webshop gets clean BNPL revenue per period in the books, instead of a Klarna lump that someone reconstructs from the Klarna merchant portal.

Data model

Tables we make available.

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

  • Absencetransactions
  • Account Charts
  • Accounts
  • Article Details
  • Articles
  • Attendancetransactions
  • Company Information
  • Contracts
  • Costcenters
  • Currencies
  • Customer Details
  • Customers
  • Employees
  • Expenses
  • Financialyears
  • Incominggoods
  • Invoice Details
  • Invoiceaccruals
  • Invoicepayments
  • Invoices
  • Labels
  • Locked Period
  • Modesofpayments
  • Offers
  • Orders
  • Pricelists
  • Prices
  • Productionorders
  • Projects
  • Purchaseorders
  • Salarytransactions
  • Stockbalance
  • Stockpoints
  • Stocktaking
  • Supplierinvoiceaccruals
  • Supplierinvoicefileconnections
  • Supplierinvoices
  • Suppliers
  • Voucher Rows
  • Vouchers
  • Voucherseries
  • Wayofdeliveries

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

  • Fortnox 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 Fortnox expose an API the warehouse can read from?

Yes. Fortnox publishes a REST API covering customers, invoices, vouchers, accounts, articles and payroll. We connect per Fortnox 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 Swedish MOMS handled in the warehouse?

Yes. MOMS 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 Skatteverket return preparation a report instead of a re-coding exercise, and lets the group view spot drift between Swedish and Benelux VAT treatment.

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

A first deliverable live in four to six weeks.

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