Fortnox + Google Sheets
Your Fortnox data in Google Sheets, kept up to date.
Enhanza syncs every Fortnox table, structures it into one finance model and connects it to Google Sheets through Connected Sheets, Google's own BigQuery connector. No exports, no API code and no data pipeline to maintain.
How it works
From Fortnox to Google Sheets in three steps.
Our team sets the connection up with you, and your Google Sheets files keep working when Fortnox changes its API.
- 1
Connect Fortnox
Sign in to Fortnox from Enhanza and choose the companies to sync. Each company is one data source. - 2
Enhanza organizes it
Every table is synced and structured into one finance model: profit and loss, balance sheet, accounts, invoices and the rest, for every company. - 3
Connect Google Sheets
In a Google Sheet, choose Data, Data connectors, Connect to BigQuery, pick the project enhanza and start from a prepared Fortnox view, or let our team write the query with you.
Data we sync
Every table, not a summary.
Structured down to the line level, so you can report on anything Fortnox holds and combine it with the rest of your systems.
Accounting
Chart of accounts, vouchers, voucher series, financial years, cost centres, projects, invoice accruals, supplier invoice accruals
Sales
Invoices, orders, offers, contracts, invoice payments, customers, price lists, prices
Purchasing
Supplier invoices, supplier invoice payments, suppliers, purchase orders, expenses
Articles & inventory
Articles, stock points, stock balances, incoming goods, stocktakings, production orders
Payroll
Employees, salary transactions, absence transactions, attendance transactions
Time reporting
Time registrations, time reporting articles
Assets
Assets, asset types
Reference data
Currencies, units, terms of payment, terms of delivery, delivery methods, payment methods, labels
Your options
Three ways to get Fortnox data into Google Sheets.
Exports and home-built integrations both work. The difference is who keeps them working next month, and the month after.
| Export to a file | Build on the Fortnox API | Enhanza | |
|---|---|---|---|
| Refreshes on its own | No | Once it's built | Yes |
| Several companies in one model | Merged by hand | If you build it | Yes |
| Other systems alongside | Merged by hand | One more integration each | Same model, same connection |
| Keeping it working | Redone every month | Yours, when the API changes | Ours |
What you build in Google Sheets
Google Sheets on top of every Fortnox table.
Pivot tables and charts on every synced table, without a download
Shared sheets for the management team, as easy to share as any Drive file
Quick checks on vouchers, invoices and balances in the browser
FAQ
Questions people ask.
Which Google account can connect?
One that is a user in your Enhanza workspace or has been given data access there. Access is managed in the workspace, not by sharing files.
How up to date is the data?
Enhanza syncs Fortnox automatically, as often as your plan includes, and Google Sheets reads the latest figures each time it refreshes.
Can I report on several Fortnox companies together?
Yes. Each company is its own data source in Enhanza, and they all land in the same finance model, so Google Sheets sees one set of tables for the whole group.
Which Enhanza plan do I need?
Every plan connects to Google Sheets. Enhanza Connect (€195 a month) is made for teams that report in their own tool; Standard and Professional add Enhanza's own dashboards and AI.
Dive into your data.
See Enhanza working on your own numbers in a personal demo.