Skip to content
Book a demoStart free
Connectors

Fortnox connector

Set up the Fortnox connector in Kaivo: authentication, configuration, the 64 BigQuery tables it syncs, and answers to common questions.

Fortnox connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Fortnox data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your payment and finance data instead of moving it.

Sync your Fortnox accounting data into BigQuery with Kaivo to report on invoices, orders, and financials alongside the rest of your business.

CategoryFinance & Payments
AuthenticationOAuth
SetupSelf-service

Getting started with the Fortnox connector

Section titled “Getting started with the Fortnox connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Fortnox account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Connect by signing in to your Fortnox account. Kaivo runs the connection for you, so you never share a password.

Kaivo syncs 64 tables from Fortnox into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

absence_transactions (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
cause_code STRING
cost_center STRING
date DATE
employee_id STRING
extent FLOAT64
holiday_entitling BOOL
hours FLOAT64
project STRING
id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
account_charts (3 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
accounts_detailed (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
active BOOL
balance_brought_forward FLOAT64
balance_carried_forward FLOAT64
cost_center STRING
cost_center_settings STRING
description STRING
number INT64
project STRING
project_settings STRING
quantity_settings STRING
quantity_unit STRING
sru INT64
transaction_information STRING
transaction_information_settings STRING
vat_code STRING
year INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • accounts_detailed__opening_quantities (5 columns)
archives (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
email STRING
id STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • archives__files (10 columns)
  • archives__folders (6 columns)
article_file_connections (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
article_number STRING
file_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
article_registrations (47 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
cost_center__active STRING
cost_center__id STRING
cost_center__name STRING
created_time DATE
customer__account_manager STRING
customer__active BOOL
customer__default_project_id STRING
customer__deleted BOOL
customer__id STRING
customer__invoice_city STRING
customer__invoice_zip_code STRING
customer__is_business INT64
customer__name STRING
customer__number STRING
customer__price_list STRING
customer__property_designation STRING
id STRING
owner_id STRING
project__description STRING
project__end_date DATE
project__id STRING
project__invoiced_amount FLOAT64
project__order_amount FLOAT64
project__order_time FLOAT64
project__project_leader STRING
project__start_date DATE
project__status INT64
project__total_amount_in_invoices FLOAT64
purchase_date DATE
registered_article__created_by STRING
registered_article__created_time DATE
registered_article__document_id INT64
registered_article__document_type STRING
registered_article__id STRING
registered_article__invoice_basis_id INT64
registered_article__invoice_text STRING
registered_article__item__active BOOL
registered_article__item__description STRING
registered_article__item__id STRING
registered_article__item__is_stock BOOL
registered_article__item__purchase_price INT64
registered_article__item__type STRING
registered_article__item__unit STRING
registration_type STRING
version INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • article_registrations__article_registrations (4 columns)
  • article_registrations__registered_article__item__sales_prices (5 columns)
article_url_connections (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
article_number STRING
id INT64
url_connection STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
articles (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
article_number STRING
description STRING
disposable_quantity STRING
ean STRING
housework BOOL
purchase_price STRING
quantity_in_stock FLOAT64
reserved_quantity STRING
sales_price STRING
stock_price STRING
stock_value STRING
unit STRING
vat STRING
webshop_article BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
asset_file_connections (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
asset_id STRING
file_id STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
asset_types (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
account_asset INT64
account_asset_id INT64
account_depreciation INT64
account_depreciation_id INT64
account_revaluation INT64
account_revaluation_id INT64
account_sale_loss INT64
account_sale_loss_id INT64
account_sale_win INT64
account_sale_win_id INT64
account_value_loss INT64
account_value_loss_id INT64
account_write_down INT64
account_write_down_ack INT64
account_write_down_ack_id INT64
account_write_down_id INT64
description STRING
id INT64
in_use BOOL
notes STRING
number STRING
type INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
assets (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
acquisition_date STRING
acquisition_value INT64
depreciated_to STRING
depreciation_final STRING
description STRING
id INT64
number STRING
status STRING
status_id STRING
type STRING
type_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
attendance_transactions (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
cause_code STRING
cost_center STRING
date DATE
employee_id STRING
hours STRING
project STRING
id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
company_information (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address STRING
city STRING
company_name STRING
country_code STRING
database_number INT64
organization_number STRING
visit_address STRING
visit_city STRING
visit_country_code STRING
visit_zip_code STRING
zip_code STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
company_settings (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address STRING
bg STRING
bic STRING
branch_code STRING
city STRING
contact_first_name STRING
contact_last_name STRING
country STRING
country_code STRING
database_number STRING
domicile STRING
email STRING
fax STRING
iban STRING
name STRING
organization_number STRING
pg STRING
phone1 STRING
phone2 STRING
tax_enabled BOOL
vat_number STRING
visit_address STRING
visit_city STRING
visit_country STRING
visit_country_code STRING
visit_name STRING
visit_zip_code STRING
www STRING
zip_code STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
contract_accruals (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
description STRING
document_number INT64
period STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
contract_templates (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
contract_length INT64
contract_template INT64
contract_template_name STRING
invoice_interval INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
contracts (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
continuous BOOL
contract_length INT64
currency STRING
customer_name STRING
customer_number STRING
document_number STRING
invoiceinterval INT64
invoices_remaining INT64
last_invoice_date STRING
period_end DATE
period_start DATE
status STRING
template_number INT64
total FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
cost_centers (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
active BOOL
code STRING
description STRING
note STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
currencies (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
buy_rate FLOAT64
code STRING
date DATE
description STRING
is_automatic BOOL
sell_rate FLOAT64
unit FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
custom_document_types (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
category STRING
reference_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customer_references (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_number STRING
id INT64
reference STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customers (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
address1 STRING
address2 STRING
city STRING
customer_number STRING
email STRING
name STRING
organisation_number STRING
phone STRING
zip_code STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
employees (74 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
address1 STRING
address2 STRING
auto_non_recurring_tax BOOL
average_hourly_wage STRING
average_weekly_hours STRING
bank_account_no STRING
city STRING
clearing_no STRING
cost_center STRING
country STRING
email STRING
employed_to DATE
employee_id STRING
employment_date DATE
employment_form STRING
first_name STRING
fora_type STRING
full_name STRING
hourly_pay STRING
inactive BOOL
job_title STRING
last_name STRING
monthly_salary STRING
non_recurring_tax STRING
personal_identity_number STRING
personel_type STRING
phone1 STRING
phone2 STRING
post_code STRING
project STRING
salary_form STRING
schedule_id STRING
tax_allowance STRING
tax_column INT64
tax_table STRING
vacation_days_paid FLOAT64
vacation_days_pending_paid FLOAT64
vacation_days_pending_prepaid FLOAT64
vacation_days_pending_saved FLOAT64
vacation_days_pending_saved_year1 FLOAT64
vacation_days_pending_saved_year2 FLOAT64
vacation_days_pending_saved_year3 FLOAT64
vacation_days_pending_saved_year4 FLOAT64
vacation_days_pending_saved_year5 FLOAT64
vacation_days_pending_saved_year6_plus FLOAT64
vacation_days_pending_unpaid FLOAT64
vacation_days_prepaid FLOAT64
vacation_days_registered_paid FLOAT64
vacation_days_registered_prepaid FLOAT64
vacation_days_registered_saved FLOAT64
vacation_days_registered_saved_year1 FLOAT64
vacation_days_registered_saved_year2 FLOAT64
vacation_days_registered_saved_year3 FLOAT64
vacation_days_registered_saved_year4 FLOAT64
vacation_days_registered_saved_year5 FLOAT64
vacation_days_registered_saved_year6_plus FLOAT64
vacation_days_registered_unpaid FLOAT64
vacation_days_saved FLOAT64
vacation_days_saved_employment_rate_year1 FLOAT64
vacation_days_saved_employment_rate_year2 FLOAT64
vacation_days_saved_employment_rate_year3 FLOAT64
vacation_days_saved_employment_rate_year4 FLOAT64
vacation_days_saved_employment_rate_year5 FLOAT64
vacation_days_saved_employment_rate_year6_plus FLOAT64
vacation_days_saved_year1 FLOAT64
vacation_days_saved_year2 FLOAT64
vacation_days_saved_year3 FLOAT64
vacation_days_saved_year4 FLOAT64
vacation_days_saved_year5 FLOAT64
vacation_days_saved_year6_plus FLOAT64
vacation_days_unpaid FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • employees__dated_schedules (6 columns)
  • employees__dated_wages (7 columns)
  • employees__employee_children (4 columns)
eu_vat_limit_regulation (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
is_over_limit BOOL
limit INT64
total_excl_vat FLOAT64
year STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
expenses (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
account INT64
code STRING
text STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
financial_years (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
account_chart_type STRING
accounting_method STRING
from_date DATE
id INT64
to_date DATE
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
inbox (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
email STRING
id STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • inbox__files (10 columns)
  • inbox__folders (6 columns)
incoming_goods_documents (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
completed BOOL
date DATE
delivery_note_id STRING
has_delivery_note BOOL
id INT64
note STRING
released BOOL
stock_point_id STRING
supplier_name STRING
supplier_number STRING
unmatched_value INT64
voided BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoice_accruals (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
description STRING
invoice_number INT64
period STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoice_payments (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
amount FLOAT64
booked BOOL
currency STRING
currency_rate FLOAT64
currency_unit FLOAT64
invoice_number INT64
number STRING
payment_date DATE
source STRING
write_off_exist BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoices (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
balance FLOAT64
booked BOOL
cancelled BOOL
cost_center STRING
currency STRING
currency_rate FLOAT64
currency_unit FLOAT64
customer_name STRING
customer_number STRING
document_number STRING
due_date DATE
external_invoice_reference1 STRING
external_invoice_reference2 STRING
final_pay_date DATE
invoice_date DATE
invoice_type STRING
nox_finans BOOL
ocr STRING
project STRING
sent BOOL
terms_of_payment STRING
total FLOAT64
voucher_number INT64
voucher_series STRING
voucher_year INT64
way_of_delivery STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
labels (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
locked_period (3 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
end_date DATE
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
manual_documents (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date DATE
delivery_id INT64
entity_id STRING
note STRING
released BOOL
type STRING
voided BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
modes_of_payments (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
account_number STRING
code STRING
description STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
offers (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
cancelled BOOL
currency STRING
customer_name STRING
customer_number STRING
document_number STRING
offer_date DATE
project STRING
sent BOOL
total FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
orders (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
cancelled BOOL
currency STRING
customer_name STRING
customer_number STRING
delivery_date DATE
document_number STRING
external_invoice_reference1 STRING
external_invoice_reference2 STRING
order_date DATE
order_type STRING
project STRING
sent BOOL
total FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
pre_defined_accounts (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
account INT64
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
pre_defined_voucher_series (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
name STRING
voucher_series STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
price_lists (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
code STRING
comments STRING
description STRING
pre_selected BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
print_templates (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
template STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
production_orders (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
batch STRING
cost_center_code STRING
document_state STRING
id INT64
inbound_stock_location_id STRING
inbound_stock_point_id STRING
item_description STRING
item_id STRING
item_unit STRING
note STRING
outbound_stock_point_id STRING
production_date DATE
production_state STRING
project_id STRING
quantity FLOAT64
start_date DATE
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • production_orders__package_items (9 columns)
projects (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
description STRING
end_date DATE
project_leader STRING
project_number STRING
start_date DATE
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
purchase_orders (50 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
confirmation_email STRING
cost_center_code STRING
currency_code STRING
currency_rate INT64
currency_unit INT64
customer_id STRING
customer_name STRING
customer_number STRING
delivery_address STRING
delivery_address2 STRING
delivery_city STRING
delivery_country_code STRING
delivery_date DATE
delivery_name STRING
delivery_zip_code STRING
dropship BOOL
id INT64
internal_reference STRING
language_code STRING
manually_completed BOOL
message_to_supplier STRING
note STRING
order_date DATE
order_value INT64
order_value_in_sek INT64
our_reference STRING
outbound_document_reference__id STRING
outbound_document_reference__type STRING
payment_terms_code STRING
project_id STRING
purchase_order_state STRING
purchase_type STRING
response_state STRING
stock_point_code STRING
stock_point_id STRING
supplier STRING
supplier_address STRING
supplier_address2 STRING
supplier_city STRING
supplier_country_code STRING
supplier_email STRING
supplier_name STRING
supplier_number STRING
supplier_post_code STRING
total_received_quantity INT64
translated_response_state STRING
voided BOOL
your_reference STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • purchase_orders__rows (24 columns)
  • purchase_orders__rows__notes (7 columns)
rejected_senders (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
email STRING
id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
salary_transactions (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
amount STRING
cost_center STRING
date DATE
employee_id STRING
expense STRING
number STRING
project STRING
salary_code STRING
salary_row INT64
text_row STRING
total STRING
vat STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
stock_balance (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
available_stock INT64
in_stock INT64
item_id STRING
stock_point_code STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
stock_points (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL
code STRING
delivery_address STRING
delivery_address2 STRING
delivery_city STRING
delivery_country_code STRING
delivery_name STRING
delivery_phone STRING
delivery_zip_code STRING
id STRING
name STRING
using_company_address BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • stock_points__stock_locations (7 columns)
stock_taking (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
cost_center_code STRING
date DATE
id INT64
name STRING
project_id STRING
responsible STRING
sorting_id INT64
state STRING
using_stock_points BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • stock_taking__rows (14 columns)
  • stock_taking__sort_params (7 columns)
supplier_invoice_accruals (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
description STRING
period STRING
supplier_invoice_number INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
supplier_invoice_file_connections (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
file_id STRING
name STRING
supplier_invoice_number STRING
supplier_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
supplier_invoice_payments (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
amount FLOAT64
booked BOOL
currency STRING
currency_rate FLOAT64
currency_unit FLOAT64
invoice_number STRING
number INT64
payment_date DATE
source STRING
write_off_exist BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
supplier_invoices (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
authorizer_name STRING
balance STRING
booked BOOL
cancel BOOL
cost_center STRING
credit BOOL
currency STRING
currency_rate STRING
currency_unit FLOAT64
due_date DATE
external_invoice_number STRING
external_invoice_series STRING
final_pay_date DATE
given_number STRING
invoice_date DATE
invoice_number STRING
project STRING
supplier_name STRING
supplier_number STRING
total STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • supplier_invoices__vouchers (7 columns)
suppliers (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
active BOOL
address1 STRING
address2 STRING
bg STRING
bic STRING
bank_account_number STRING
city STRING
cost_center STRING
country_code STRING
currency STRING
disable_payment_file BOOL
email STRING
iban STRING
name STRING
organisation_number STRING
pg STRING
phone STRING
pre_defined_account STRING
project STRING
supplier_number STRING
terms_of_payment STRING
zip_code STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tax_reductions (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
approved_amount FLOAT64
customer_name STRING
id INT64
reference_document_type STRING
reference_number INT64
social_security_number STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
terms_of_deliveries (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
code STRING
description STRING
description_english STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
terms_of_payments (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
code STRING
description STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
time_registrations (60 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
charge_hours FLOAT64
child_id STRING
cost_center__active STRING
cost_center__id STRING
cost_center__name STRING
created_by STRING
created_time DATE
customer__account_manager STRING
customer__active BOOL
customer__default_project_id STRING
customer__deleted BOOL
customer__id STRING
customer__invoice_city STRING
customer__invoice_zip_code STRING
customer__is_business INT64
customer__name STRING
customer__number STRING
customer__price_list STRING
customer__property_designation STRING
document_id INT64
document_type STRING
id STRING
invoice_basis_id INT64
invoice_text STRING
non_invoiceable BOOL
note STRING
project__description STRING
project__end_date DATE
project__id STRING
project__invoiced_amount FLOAT64
project__order_amount FLOAT64
project__order_time FLOAT64
project__project_leader STRING
project__start_date DATE
project__status INT64
project__total_amount_in_invoices FLOAT64
registration_code__active BOOL
registration_code__code STRING
registration_code__cost_multiplier FLOAT64
registration_code__id STRING
registration_code__name STRING
registration_code__price_multiplier FLOAT64
registration_code__type STRING
service__active BOOL
service__description STRING
service__id STRING
service__is_stock BOOL
service__purchase_price INT64
service__type STRING
service__unit STRING
start_time DATE
stop_time DATE
unit_cost INT64
unit_price INT64
updated_by STRING
user_id STRING
worked_date DATE
worked_hours FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • time_registrations__service__sales_prices (5 columns)
trusted_senders (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
email STRING
id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
units (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
code STRING
code_english STRING
description STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
voucher_file_connections (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
file_id STRING
voucher_description STRING
voucher_number STRING
voucher_series STRING
voucher_year INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
voucher_series (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
approver__id INT64
approver__name STRING
code STRING
description STRING
manual BOOL
year INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
vouchers (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
approval_state INT64
comments STRING
description STRING
reference_number STRING
reference_type STRING
transaction_date DATE
voucher_number INT64
voucher_series STRING
year INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
way_of_deliveries (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
aurl STRING
code STRING
description STRING
description_english STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Fortnox supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Fortnox?

Section titled “How long does the initial sync take for Fortnox?”

It depends on how much history is in your Fortnox account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Fortnox’s schema changes?

Section titled “What happens when Fortnox’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Fortnox, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Fortnox instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Fortnox connector in Kaivo and all of its synced data is deleted with it.

Build revenue, profit, and balance reporting from your Fortnox data.

Track customer and supplier invoices to monitor receivables, payables, and cash flow.

Report on orders to see what is selling and forecast revenue.

Join Fortnox financials with sales or e-commerce data in BigQuery for a complete view.

Once Fortnox data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Fortnox data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Fortnox connector pricing and plan details.