Skip to content
Book a demoStart free
Connectors

FastBill connector

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

FastBill connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your FastBill 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 FastBill data into BigQuery with Kaivo to analyse invoices, revenue, and customers in one place.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service

Getting started with the FastBill connector

Section titled “Getting started with the FastBill connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your FastBill 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.

Authenticate with your API Key.

Field Description
API Key
Fastbill API key

|

When you set up the connector, you provide:

Field Description
Username
Username for Fastbill account

|

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

customers (42 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
academic_degree STRING Academic degree of the customer
address STRING Primary address of the customer
address_2 STRING Secondary address of the customer
bank_account_mandate_reference STRING Reference for the bank account mandate
bank_account_number STRING Bank account number
bank_account_owner STRING Owner of the bank account
bank_bic STRING Bank Identification Code
bank_code STRING Bank code associated with the bank account
bank_iban STRING International Bank Account Number
bank_name STRING Name of the bank
city STRING City of the customer
country_code STRING Country code of the customer
created TIMESTAMP Date and time when the customer record was created
currency_code STRING Currency code used for transactions
customer_account STRING Customer account details
customer_id STRING Unique identifier for the customer
customer_number STRING Customer number for identification
customer_type STRING Type of customer
days_for_payment STRING Number of days allowed for payment
document_history_url STRING URL for customer’s document history
email STRING Email address of the customer
fax STRING Fax number of the customer
first_name STRING First name of the customer
lastupdate STRING Last update timestamp for the customer record
last_name STRING Last name of the customer
mobile STRING Mobile phone number of the customer
newsletter_optin STRING Opt-in status for receiving newsletters
organization STRING Organization or company name
payment_type STRING Payment type preferred by the customer
phone STRING Primary phone number of the customer
phone_2 STRING Secondary phone number of the customer
position STRING Position or job title of the customer
salutation STRING Salutation used when addressing the customer
secondary_address STRING Secondary address details
show_payment_notice STRING Flag indicating whether payment notice should be displayed
tags STRING Tags or labels associated with the customer
top STRING Top level customer identifier
vat_id STRING Value Added Tax (VAT) identification number
website STRING Website URL of the customer
zipcode STRING ZIP or postal code of the customer
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoices (48 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address STRING Customer address
address_2 STRING Additional address information
bank_account_number STRING Customer’s bank account number
bank_account_owner STRING Name of the bank account owner
bank_bic STRING Bank Identifier Code
bank_code STRING Bank code
bank_iban STRING International Bank Account Number
bank_name STRING Name of the bank
cash_discount_days STRING Number of days to avail cash discount
cash_discount_percent STRING Percentage of cash discount offered
city STRING Customer’s city
contact_id STRING Contact ID
country_code STRING Customer’s country code
currency_code STRING Currency code
customer_costcenter_id STRING Customer’s cost center ID
customer_id STRING Customer ID
customer_number STRING Customer number
delivery_date STRING Date of delivery
document_url STRING URL to access the document
due_date STRING Due date for payment
first_name STRING Customer’s first name
introtext STRING Introductory text
invoice_date STRING Date of the invoice
invoice_id STRING Invoice ID
invoice_number STRING Invoice number
invoice_title STRING Title of the invoice
is_canceled STRING Flag indicating if the invoice is canceled
lastupdate STRING Last update date
last_name STRING Customer’s last name
note STRING Additional note
organization STRING Customer’s organization
paid_date STRING Date when the invoice was paid
payment_info STRING Payment information
payment_type STRING Type of payment
project_id STRING Project ID
salutation STRING Salutation for the customer
service_period_end STRING End date of the service period
service_period_start STRING Start date of the service period
sub_total FLOAT64 Subtotal amount
template_id STRING Template ID
total FLOAT64 Total amount
type STRING Type of the invoice
vat_case STRING VAT case
vat_id STRING VAT ID
vat_total FLOAT64 Total VAT amount
zipcode STRING Customer’s ZIP code
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
article_number STRING Article number
complete_gross FLOAT64 Total gross amount for the item
complete_net FLOAT64 Total net amount for the item
description STRING Description of the item
invoice_item_id INT64 Invoice item ID
quantity INT64 Quantity of the item
sort_order INT64 Order in which the item appears
unit_price FLOAT64 Unit price of the item
vat_percent INT64 VAT percentage for the item
vat_value FLOAT64 VAT value for the item
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON Individual payment details
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
complete_net FLOAT64 Total net amount for VAT
vat_percent INT64 VAT percentage
vat_value FLOAT64 VAT value
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
products (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
article_id STRING Unique identifier for the product article.
article_number STRING Identification number for the product article.
currency_code STRING The currency code used for the price of the product article.
description STRING Detailed description of the product article.
is_gross FLOAT64 Indicates whether the price is gross or net (inclusive of tax).
tags STRING Tags associated with the product article.
title STRING Title or name of the product article.
unit STRING Unit of measurement for the product article (e.g., piece, kg).
unit_price STRING Price per unit of the product article.
vat_percent STRING The percentage of Value Added Tax applied to the product article price.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
recurring_invoices (43 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address STRING Customer’s street address
address_2 STRING Additional address information
bank_account_number STRING Customer’s bank account number
bank_account_owner STRING Owner’s name of the bank account
bank_bic STRING Bank Identifier Code
bank_code STRING Bank code or routing number
bank_iban STRING International Bank Account Number
bank_name STRING Name of the customer’s bank
cash_discount_days STRING Number of days for cash discount
cash_discount_percent STRING Percentage of cash discount
city STRING Customer’s city
contact_id STRING Contact ID of the customer
currency_code STRING Currency code used for the invoice
customer_costcenter_id STRING Customer’s cost center ID
customer_id STRING Unique ID of the customer
customer_number STRING Customer’s unique identification number
delivery_date STRING Date of delivery
email_notify STRING Flag to indicate if customer was notified via email
first_name STRING Customer’s first name
frequency STRING Frequency of the recurring invoice
introtext STRING Introduction text for the invoice
invoice_id STRING Unique ID of the invoice
invoice_title STRING Title of the invoice
last_name STRING Customer’s last name
note STRING Additional notes or comments
occurences STRING Number of occurrences for the recurring invoice
organization STRING Customer’s organization
output_type STRING Output format type
payment_type STRING Payment method type
project_id STRING ID of the associated project
salutation STRING Customer’s salutation
service_period_end STRING End date of the service period
service_period_start STRING Start date of the service period
start_date STRING Start date of the recurring invoice
sub_total FLOAT64 Total amount before tax
template_id STRING Unique ID of the template used for the invoice
total FLOAT64 Total amount including tax
type STRING Type of the recurring invoice
vat_case STRING VAT case type
vat_total FLOAT64 Total VAT amount
zipcode STRING Customer’s ZIP code
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
article_number STRING Article number of the item
complete_gross FLOAT64 Total gross amount of the item
complete_net FLOAT64 Total net amount of the item
description STRING Description of the item
invoice_item_id FLOAT64 Unique ID of the invoice item
quantity FLOAT64 Quantity of the item
sort_order FLOAT64 Order in which the item appears
unit_price FLOAT64 Price per unit of the item
vat_percent FLOAT64 VAT percentage applied to the item
vat_value FLOAT64 VAT value of the item
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: recurring_invoices__items__category

Section titled “Subtable: recurring_invoices__items__category”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: recurring_invoices__items__category_id

Section titled “Subtable: recurring_invoices__items__category_id”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
complete_net FLOAT64 Total net amount of the VAT item
vat_percent FLOAT64 VAT percentage for the VAT item
vat_value FLOAT64 VAT value of the VAT item
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
revenues (48 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address STRING Customer’s street address
address_2 STRING Additional address information (e.g., apartment number)
bank_account_number STRING Customer’s bank account number
bank_account_owner STRING The name of the bank account owner
bank_bic STRING Bank Identifier Code for the customer’s bank
bank_code STRING Bank code for the customer’s bank
bank_iban STRING International Bank Account Number (IBAN)
bank_name STRING Name of the customer’s bank
cash_discount_days STRING Number of days within which cash discount can be availed
cash_discount_percent STRING Percentage of cash discount available on the invoice
city STRING City where the customer is located
contact_id STRING ID of the contact associated with the invoice
country_code STRING Country code of the customer’s location
currency_code STRING Currency code used for the invoice
customer_costcenter_id STRING ID of the cost center associated with the customer
customer_id STRING Unique ID of the customer
customer_number STRING Customer’s identification number
delivery_date STRING Date when the invoice delivery is scheduled
document_url STRING URL link to access the invoice document
due_date STRING Due date for payment of the invoice
first_name STRING Customer’s first name
introtext STRING Introduction text for the invoice
invoice_date STRING Date when the invoice was issued
invoice_id STRING Unique ID of the invoice
invoice_number STRING Unique number assigned to the invoice
invoice_title STRING Title or subject of the invoice
is_canceled STRING Indicates if the invoice is canceled
lastupdate STRING Date of the last update made to the invoice
last_name STRING Customer’s last name
note STRING Additional notes or comments related to the invoice
organization STRING Name of the customer’s organization
paid_date STRING Date when the invoice was paid
payment_info STRING Information related to the payment
payment_type STRING Type of payment (e.g., partial, full)
project_id STRING ID of the project associated with the invoice
salutation STRING Salutation used for addressing the customer (Mr., Ms.)
service_period_end STRING End date of the service period covered by the invoice
service_period_start STRING Start date of the service period covered by the invoice
sub_total INT64 Subtotal amount before applying taxes or discounts
template_id STRING ID of the template used for generating the invoice
total FLOAT64 Total amount including all taxes and discounts
type STRING Type of the invoice (e.g., sales, service)
vat_case STRING VAT case type (e.g., domestic, intra-community)
vat_id STRING VAT identification number
vat_total FLOAT64 Total VAT amount for the invoice
zipcode STRING Zip code of the customer’s location
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
article_number STRING Unique number assigned to the item
complete_gross FLOAT64 Total gross amount for the item
complete_net INT64 Total net amount for the item
description STRING Description of the item
invoice_item_id INT64 Unique ID of the invoice item
quantity INT64 Quantity of the item
sort_order INT64 Order in which the item appears in the invoice
unit_price INT64 Price per unit of the item
vat_percent INT64 VAT percentage applicable to the item
vat_value FLOAT64 VAT amount for the item
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
complete_net INT64 Total net amount for the VAT item
vat_percent INT64 VAT percentage for the VAT item
vat_value FLOAT64 VAT value for the VAT item
_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 FastBill 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 FastBill?

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

It depends on how much history is in your FastBill 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 FastBill’s schema changes?

Section titled “What happens when FastBill’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 FastBill, 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 FastBill 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 FastBill connector in Kaivo and all of its synced data is deleted with it.

Use invoices and revenues to track income over time.

Use recurring_invoices to monitor subscription revenue.

Join customers with invoices to measure lifetime value and outstanding balances.

Once FastBill 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 FastBill 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 FastBill connector pricing and plan details.