FastBill connector

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

Written By Lauri Raivio

Last updated 16 days ago

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.

What is the FastBill connector

Sync your FastBill data into BigQuery with Kaivo to analyse invoices, revenue, and customers in one place.

Category	Finance & Payments
Authentication	API key
Setup	Self-service

Getting started with the FastBill connector

Sign up for Kaivo and create a workspace.
Connect your FastBill account.
Choose which tables to sync.
Wait for the initial sync to finish.
Query your data in BigQuery or your favourite AI or BI tool.

Authenticating FastBill

Authenticate with your API Key.

Field	Description
API Key	Fastbill API key

Configuring the FastBill connector

When you set up the connector, you provide:

Field	Description
Username	Username for Fastbill account

Tables and columns synced from FastBill

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.

Subtable: invoices__items

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.

Subtable: invoicesitemscategory

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: invoicesitemscategory_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.

Subtable: invoices__payments

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.

Subtable: invoices__vat_items

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.

Subtable: recurring_invoices__items

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_invoicesitemscategory

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

Subtable: recurring_invoices__vat_items

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.

Subtable: revenues__items

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.

Subtable: revenuesitemscategory

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: revenuesitemscategory_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.

Subtable: revenues__payments

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: revenues__vat_items

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.

How the FastBill sync works

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.

Frequently asked questions

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.

Can I sync only some tables or columns?

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?

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.

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.

Common use cases for FastBill data

Revenue reporting

Use invoices and revenues to track income over time.

Recurring billing

Use recurring_invoices to monitor subscription revenue.

Customer view

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

Use FastBill data in your AI and BI tools

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.

Claude

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

Power BI

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

Data Studio

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

Tableau

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

Google Sheets

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

Excel

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

Metabase

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

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

Chargebee: Sync Chargebee to BigQuery.
ChartMogul: Sync ChartMogul to BigQuery.
Fennoa: Sync Fennoa to BigQuery.
Fortnox: Sync Fortnox to BigQuery.
FreshBooks: Sync FreshBooks to BigQuery.
PayPal Enterprise Payments: Sync PayPal Enterprise Payments to BigQuery.

Was this helpful?

Still need help? Share an idea