Finago Procountor connector

Set up the Finago Procountor connector in Kaivo: authentication, configuration, the 15 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 Finago Procountor 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 Finago Procountor connector

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

Category	Finance & Payments, ERP
Authentication	OAuth or API key
Setup	Self-service

Getting started with the Finago Procountor connector

Sign up for Kaivo and create a workspace.
Connect your Finago Procountor 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 Finago Procountor

The Finago Procountor connector supports 2 ways to connect. Pick the one that fits how you work.

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

API key of technical API user account

Authenticate with your API key.

Field	Description
API key	An API key is attached to a Procountor user. A good practice is to create a separate technical API user account for this. To create a user (if it doesn't already exist): Go to Procountor's Users and privileges settings Click "Create new user" Set First name = "Kaivo", Last name = "API", Email address = any email that doesn't exist, User name = any user name that doesn't exist, Username and password = "Deliver to user personally", Role = "Manager / Auditor", Person register = "Do not add or link user to person register", Email from procountor = uncheck all checkboxes When the user has been created, there's no need to save user name or password anywhere as the user will never need to log in. To create an API key: Go to API client keys settings Click "New API key" Select the newly created user "API, Kaivo" and write "kaivoAPIClient" to Client ID field (asiakasohjelmiston tunniste)

Field

Description

API key

An API key is attached to a Procountor user. A good practice is to create a separate technical API user account for this. To create a user (if it doesn't already exist):

Go to Procountor's Users and privileges settings
Click "Create new user"
Set First name = "Kaivo", Last name = "API", Email address = any email that doesn't exist, User name = any user name that doesn't exist, Username and password = "Deliver to user personally", Role = "Manager / Auditor", Person register = "Do not add or link user to person register", Email from procountor = uncheck all checkboxes
When the user has been created, there's no need to save user name or password anywhere as the user will never need to log in.

To create an API key:

Go to API client keys settings
Click "New API key"
Select the newly created user "API, Kaivo" and write "kaivoAPIClient" to Client ID field (asiakasohjelmiston tunniste)

Prerequisites

To be able to use this connector, first make sure "Allow the usage of invoiceable API clients" setting is enabled in Procountor's Usage settings.

Tables and columns synced from Finago Procountor

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

accounts (5 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`ledger_account_code`	`STRING`	Ledger account code.
`name`	`STRING`	Ledger account name.
`active`	`BOOL`	Indicates whether the ledger account is active or not.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: accounts__translations

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.
`language_code`	`STRING`	Language code in ISO 639-1 format.
`translation`	`STRING`	Ledger account name translation for the given language code.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

bank_accounts (13 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`id`	`INT64`	Unique identifier of the bank account.
`account_number`	`STRING`	Unique bank account number in BBAN format. Generated from IBAN.
`iban`	`STRING`	IBAN number for the bank account. Cannot be changed once created.
`bic`	`STRING`	BIC code for the bank account. Not mandatory while creation, can be generated from IBAN.
`bank_name`	`STRING`	The name of the bank.
`currency`	`STRING`	The currency of the bank account. Cannot be changed once created.
`default_for_invoice`	`BOOL`	Information if the bank account is used as default bank account for invoice in the given environment.
`default_for_payment`	`BOOL`	Information if the bank account is used as default bank account for payment in the given environment.
`status`	`STRING`	Information if the bank account is active or not. If set to INACTIVE then all properties will be set to false
`order_no`	`INT64`	Order number. Can be used for display ordering instead of ID.
`version`	`TIMESTAMP`	Company bank account version timestamp. Automatically generated by Procountor and updated every time the partner is modified. When using PUT /bankaccounts, it is required to include the latest version timestamp of the partner to the request. This prevents conflicts if the partner is being modified from several sources.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: bank_accounts__associated_accounts

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.
`type`	`STRING`	Type of associated account number.
`account_number`	`STRING`	Associated account number.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

bank_statements (14 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`id`	`INT64`	Unique identifier of the bank statement.
`account_number`	`STRING`	Account number for which the statement is generated.
`start_date`	`DATE`	Start date of the bank statement.
`end_date`	`DATE`	End date of the bank statement.
`currency`	`STRING`	Currency of the bank statement in ISO 4217 format.
`number_of_deposits`	`INT64`	Number of deposits during the bank statement period.
`deposit_sum`	`FLOAT64`	Sum of the deposits.
`number_of_withdrawals`	`INT64`	Number of withdrawals during the bank statement period.
`withdrawal_sum`	`FLOAT64`	Sum of the withdrawals.
`start_balance`	`FLOAT64`	Start balance of the account before this bank statement.
`end_balance`	`FLOAT64`	End balance of the account after this bank statement.
`statement_number`	`INT64`	Number of bank statement.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

business_partner_groups (6 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`id`	`INT64`	Id of the partner group.
`name`	`STRING`	Name of the partner group.
`type`	`STRING`	Type of the partner group.
`active`	`BOOL`	Is partner group active? NOTE: If the business partner group is in use in the debt collection settings for the Maksuvahti service, Ropo service or is set as the automatic distraint authority group, then it can't be set to inactive
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

business_partners (81 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`id`	`INT64`	Unique identifier of the partner.
`name`	`STRING`	Name of the partner.
`type`	`STRING`	Type of the partner.
`address__name`	`STRING`	Name ("first line") in the address.
`address__specifier`	`STRING`	Specifier, such as c/o address.
`address__street`	`STRING`	Street.
`address__zip`	`STRING`	Zip code.
`address__city`	`STRING`	City.
`address__country`	`STRING`	Country.
`address__subdivision`	`STRING`	Subdivision of the city
`billing_address__name`	`STRING`	Name ("first line") in the address.
`billing_address__specifier`	`STRING`	Specifier, such as c/o address.
`billing_address__street`	`STRING`	Street.
`billing_address__zip`	`STRING`	Zip code.
`billing_address__city`	`STRING`	City.
`billing_address__country`	`STRING`	Country.
`billing_address__subdivision`	`STRING`	Subdivision of the city
`delivery_address__name`	`STRING`	Name ("first line") in the address.
`delivery_address__specifier`	`STRING`	Specifier, such as c/o address.
`delivery_address__street`	`STRING`	Street.
`delivery_address__zip`	`STRING`	Zip code.
`delivery_address__city`	`STRING`	City.
`delivery_address__country`	`STRING`	Country.
`delivery_address__subdivision`	`STRING`	Subdivision of the city
`invoicing_info__customer_number`	`STRING`	Customer number of the partner.
`invoicing_info__identifier`	`STRING`	Identifier of the partner.
`invoicing_info__identifier_type`	`STRING`	Identifier type of the partner.
`invoicing_info__ovt`	`STRING`	OVT of the partner.
`invoicing_info__invoice_channel`	`STRING`	Invoice channel of the partner.
`invoicing_info__contact_person`	`STRING`	Contact person of the partner.
`invoicing_info__language`	`STRING`	Language of the partner.
`invoicing_info__email`	`STRING`	Email of the partner.
`invoicing_info__deny_einvoice_reminders`	`BOOL`	Does the customer deny Procountors sending of payment reminders as e-invoice
`invoicing_info__order_reference`	`STRING`	Order reference
`invoicing_info__seller_reference_identifier`	`STRING`	Seller reference identifier. Supported only in Finnish environments.
`invoicing_info__buyer_reference_identifier`	`STRING`	Buyer reference identifier. Supported only in Finnish environments.
`invoicing_info__order_number`	`STRING`	Order number. Supported only in Finnish environments.
`invoicing_info__agreement_number`	`STRING`	Agreement number. Supported only in Finnish environments.
`invoicing_info__accounting_code`	`STRING`	Accounting code. Supported only in Finnish environments.
`invoicing_info__delivery_site`	`STRING`	Delivery site. Supported only in Finnish environments.
`invoicing_info__tender_reference`	`STRING`	Tender reference. Supported only in Finnish environments.
`invoicing_info__einvoice_address`	`STRING`
`invoicing_info__einvoice_operator`	`STRING`
`additional_info__default_additional_information`	`STRING`	Default additional information of the partner.
`additional_info__default_reference`	`STRING`	Default reference of the partner.
`additional_info__group`	`STRING`	Group.
`additional_info__parent_company_id_type`	`STRING`	Company ID of the partner. If provided partnerCompanyId will be validated according to the type.
`additional_info__parent_company_id`	`STRING`	Parent company ID of the partner.
`additional_info__auxiliary_company_name`	`STRING`	Auxiliary company name.
`additional_info__former_company_name`	`STRING`	Former company name of the partner.
`additional_info__sector`	`STRING`	Sector of the partner.
`additional_info__web_address`	`STRING`	Web address of the partner.
`additional_info__comments1`	`STRING`	First comment
`additional_info__comments2`	`STRING`	Second comment
`additional_info__invoice_period`	`STRING`	Invoice period of the partner.
`additional_info__withholding_register_marking`	`STRING`	Withholding register marking of the partner.
`additional_info__invoice_ledger`	`STRING`	Invoice ledger of the partner. If not provided, it will be automatically set to INVOICE_LEDGER.
`payment_info__factoring_contract_id`	`INT64`	Factoring contract ID of the partner.
`payment_info__payment_method`	`STRING`	Payment method of the partner. The DKLMPKRE method is deprecated and read only, DOMESTIC_PAYMENT_CREDITOR should be used instead.
`payment_info__bank_account`	`STRING`	Bank account ID of the partner.
`payment_info__payment_term_days`	`STRING`	Payment term days of the partner.
`payment_info__payment_term_percentage`	`FLOAT64`	Payment term percentage of the partner.
`payment_info__penal_interest_rate`	`FLOAT64`	Penal interest rate of the partner.
`payment_info__discount_percentage`	`FLOAT64`	Discount percentage of the partner.
`payment_info__cash_discount__cash_discounts_term_type`	`STRING`	The payment term type indicates the start point for payment due date calculation.On Danish environment, may select between two options: FROM_INV_DATE or FROM_END_OF_MONTH.For other environments, the only selectable term type is FROM_INV_DATE,which is also the default value across all environments.
`payment_info__currency`	`STRING`	Currency of the partner.
`payment_info__delivery_method`	`STRING`	Delivery method of the partner.
`payment_info__clearing_code`	`STRING`	Clearing code of the bank account.
`payment_info__bic`	`STRING`	BIC of the bank account.
`payment_info__customer_account_number`	`STRING`	Customer account number used only for NETS payments
`registry_info__active`	`BOOL`	Status of the partner.
`registry_info__phone`	`STRING`	Phone number of the partner.
`registry_info__mobile_phone`	`STRING`	Mobile phone number of the partner.
`registry_info__fax`	`STRING`	Fax number of the partner.
`registry_info__section`	`STRING`	Section of the partner.
`registry_info__home_municipality`	`STRING`	Home municipality of the partner.
`registry_info__report_group`	`STRING`	Report group name of the partner.
`registry_info__report_group_id`	`INT64`	Report group id of the partner.
`version`	`TIMESTAMP`	Business partner version timestamp. Automatically generated by Procountor and updated every time the partner is modified. When using PATCH /businesspartners, it is required to include the latest version timestamp of the partner to the request. This prevents conflicts if the partner is being modified from several sources.It is not required for POST and will be omitted
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: business_partners__invoicing_info__bcc_addresses

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`	`STRING`
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: business_partners__attachments

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.
`id`	`INT64`	Unique identifier of the attachment. Generated by Procountor and present in the object returned.
`name`	`STRING`	Attachment name. Include a correct file extension to the value.
`reference_type`	`STRING`	Reference type of the attachment. Indicates what object is the owner of the attachment. Exception: for JOURNAL type ledger receipts, use type INVOICE.
`reference_id`	`INT64`	Unique identifier of the referenced object. Exception: for JOURNAL type ledger receipts, use the value of invoiceId referring to the associated invoice.
`mime_type`	`STRING`	Mime type of the attachment. Determined from the file extension.
`send_with_invoice`	`BOOL`	Indicator if attachment has to be send with the invoice. 'sendWithInvoice' can be set only for receipt types: SALES_INVOICE, SALES_ORDER, PURCHASE_ORDER
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: business_partners__contact_persons

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.
`id`	`INT64`	Contact person ID.
`name`	`STRING`	Name of contact person.
`email`	`STRING`	Email of contact person.
`phone`	`STRING`	Phone of contact person.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: business_partners__payment_info__cash_discount__option_list

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.
`number_of_days`	`INT64`	Days specified in cash discount
`discount_percentage`	`FLOAT64`	Discount percentage specified in cash discount
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: business_partners__registry_info__partner_groups

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.
`id`	`INT64`	Id of the partner group.
`name`	`STRING`	Name of the partner group.
`type`	`STRING`	Type of the partner group.
`active`	`BOOL`	Is partner group active? NOTE: If the business partner group is in use in the debt collection settings for the Maksuvahti service, Ropo service or is set as the automatic distraint authority group, then it can't be set to inactive
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

dimensions (4 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`id`	`INT64`	Dimension ID. Required in PUT
`name`	`STRING`	Dimension name.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: dimensions__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.
`id`	`INT64`	Dimension item ID. Required in PUT
`code_name`	`STRING`	Dimension item code name.
`status`	`STRING`	Dimension item status. If the dimension item is marked as active, this property is not present. If the dimension item is inactive, the value of this is property is "P".
`description`	`STRING`	Dimension item description.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

fiscal_years (7 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`id`	`INT64`	Unique identifier of the fiscal year.
`start_date`	`DATE`	Start date of the fiscal year.
`end_date`	`DATE`	End date of the fiscal year
`modified`	`TIMESTAMP`	Time of last edition of fiscal year.
`is_open`	`BOOL`	Whether the fiscal year is open (true) or closed (false).
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: fiscal_years__tracking_periods

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.
`id`	`INT64`	Unique identifier of the tracking period.
`start_date`	`DATE`	Start date of the tracking period.
`end_date`	`DATE`	End date of the tracking period.
`status`	`STRING`	Status of the tracking period.
`modified`	`TIMESTAMP`	Time of last edition of tracking period.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

invoices (90 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`id`	`INT64`	Unique identifier of the invoice. Generated by Procountor and present in the object returned.
`partner_id`	`INT64`	Technical ID for the business partner. Used to link the invoice to a customer or supplier in the business partner register. If supplied, the company must have this partner ID in the corresponding register. This field is not editable in PUT /invoices endpoint.
`type`	`STRING`	Invoice type. Note that this affects validation requirements. PERIODIC_TAX_RETURN is supported only by GET /invoices endpoint. It's not supported by PUT and POST /invoices endpoints.
`status`	`STRING`	Invoice status. A new invoice created through the API will have its status set as UNFINISHED. Updating invoice is possible when its status is UNFINISHED. Updating expense claim, purchase, purchase order and travel invoice is possible when the status is UNFINISHED or RECEIVED. PUT /invoices endpoint is not able to change invoice status.
`date`	`DATE`	Invoice date. This is synonymous to billing date.
`due_date`	`DATE`	Invoice payment due date.
`new_due_date`	`DATE`	Invoice payment new due date.
`payment_date`	`DATE`	Date of the latest payment transaction related to the invoice. Set automatically when payments are made and can't be modified directly.
`counter_party__contact_person_name`	`STRING`	Name of the contact person.
`counter_party__identifier`	`STRING`	SALES_INVOICE, SALES_ORDER, PURCHASE_INVOICE and PURCHASE_ORDER only. Business ID or national identification number.
`counter_party__tax_code`	`STRING`	SALES_INVOICE and SALES_ORDER, PURCHASE_INVOICE and PURCHASE_ORDER only. Tax code of the customer.
`counter_party__customer_number`	`STRING`	SALES_INVOICE, SALES_ORDER, PURCHASE_INVOICE and PURCHASE_ORDER only. Customer number.
`counter_party__email`	`STRING`	SALES_INVOICE, SALES_ORDER and PURCHASE_ORDER only. Email address of the buyer. Required to be correct if supported.
`counter_party__counter_party_address__name`	`STRING`	Name ("first line") in the address.
`counter_party__counter_party_address__specifier`	`STRING`	Specifier, such as c/o address.
`counter_party__counter_party_address__street`	`STRING`	Street.Required for SALES_INVOICE and SALES_ORDER if invoicing channel is MAIL.In that case, must be specified in counterPartyAddress if not specified in billingAddress.Required for SALES_INVOICE if invoicing channel is ELECTRONIC_INVOICE. In that case,must be specified in billingAddress and counterPartyAddress.
`counter_party__counter_party_address__zip`	`STRING`	Zip code.Required for SALES_INVOICE and SALES_ORDER if invoicing channel is MAIL.In that case, must be specified in counterPartyAddress if not specified in billingAddress.Required for SALES_INVOICE if invoicing channel is ELECTRONIC_INVOICE. In that case,must be specified in billingAddress and counterPartyAddress.
`counter_party__counter_party_address__city`	`STRING`	City.Required for SALES_INVOICE and SALES_ORDER if invoicing channel is MAIL.In that case, must be specified in counterPartyAddress if not specified in billingAddress.Required for SALES_INVOICE if invoicing channel is ELECTRONIC_INVOICE. In that case,must be specified in billingAddress and counterPartyAddress.
`counter_party__counter_party_address__country`	`STRING`	Country.
`counter_party__counter_party_address__subdivision`	`STRING`	Subdivision of the city
`counter_party__bank_account__account_number`	`STRING`	Bank account IBAN. If using a financing agreement, the account number must match the account of the specified financing agreement. The account number must be valid for the specified country, include country code and exclude any spaces.
`counter_party__bank_account__bic`	`STRING`	Bank account BIC/SWIFT. Not supported for SALES_INVOICE and SALES_ORDER.
`counter_party__einvoice_address__operator`	`STRING`	SALES_INVOICE Only. Operator code. Required if the invoiceChannel is ELECTRONIC_INVOICE and country is FINLAND.
`counter_party__einvoice_address__address`	`STRING`	SALES_INVOICE Only. EInvoice Address. Required if the invoiceChannel is ELECTRONIC_INVOICE, format must be valid for the specified country.
`counter_party__einvoice_address__edi_id`	`STRING`	SALES_INVOICE Only. EDI identifier. Used if the invoiceChannel is ELECTRONIC_INVOICE and country is FINLAND.
`billing_address__name`	`STRING`	Name ("first line") in the address.
`billing_address__specifier`	`STRING`	Specifier, such as c/o address.
`billing_address__street`	`STRING`	Street.Required for SALES_INVOICE and SALES_ORDER if invoicing channel is MAIL.In that case, must be specified in counterPartyAddress if not specified in billingAddress.Required for SALES_INVOICE if invoicing channel is ELECTRONIC_INVOICE. In that case,must be specified in billingAddress and counterPartyAddress.
`billing_address__zip`	`STRING`	Zip code.Required for SALES_INVOICE and SALES_ORDER if invoicing channel is MAIL.In that case, must be specified in counterPartyAddress if not specified in billingAddress.Required for SALES_INVOICE if invoicing channel is ELECTRONIC_INVOICE. In that case,must be specified in billingAddress and counterPartyAddress.
`billing_address__city`	`STRING`	City.Required for SALES_INVOICE and SALES_ORDER if invoicing channel is MAIL.In that case, must be specified in counterPartyAddress if not specified in billingAddress.Required for SALES_INVOICE if invoicing channel is ELECTRONIC_INVOICE. In that case,must be specified in billingAddress and counterPartyAddress.
`billing_address__country`	`STRING`	Country.
`billing_address__subdivision`	`STRING`	Subdivision of the city
`delivery_address__name`	`STRING`	Name ("first line") in the address.
`delivery_address__specifier`	`STRING`	Specifier, such as c/o address.
`delivery_address__street`	`STRING`	Street.
`delivery_address__zip`	`STRING`	Zip code.
`delivery_address__city`	`STRING`	City.
`delivery_address__country`	`STRING`	Country.
`delivery_address__subdivision`	`STRING`	Subdivision of the city
`payment_info__payment_method`	`STRING`	Payment method. Methods other than BANK_TRANSFER, CASH, CLEARING may require fields not supported by the API. The DIRECT_DEBIT method is not supported by POST /invoices and PUT /invoices endpoints. The DKLMPKRE method is deprecated and read only, DOMESTIC_PAYMENT_CREDITOR should be used instead.
`payment_info__currency`	`STRING`	Currency of the payment in ISO 4217 format.
`payment_info__bank_account__account_number`	`STRING`	Bank account IBAN. If using a financing agreement, the account number must match the account of the specified financing agreement. The account number must be valid for the specified country, include country code and exclude any spaces.
`payment_info__bank_account__bic`	`STRING`	Bank account BIC/SWIFT. Not supported for SALES_INVOICE and SALES_ORDER.
`payment_info__due_date`	`DATE`	Payment due date. The payment term can be 0-999 days.
`payment_info__new_due_date`	`DATE`	Payment new due date.
`payment_info__currency_rate`	`FLOAT64`	Currency exchange rate. Calculated as the amount of one unit of domestic currency in foreign currency. Only foreign currency payments should have a value other than 1.
`payment_info__payment_term_percentage`	`FLOAT64`	Discount percentage set in term of payment. Determines the discount if the invoice is paid before due date.
`payment_info__cash_discount__cash_discounts_term_type`	`STRING`	The payment term type indicates the start point for payment due date calculation.On Danish environment, may select between two options: FROM_INV_DATE or FROM_END_OF_MONTH.For other environments, the only selectable term type is FROM_INV_DATE,which is also the default value across all environments.
`payment_info__bank_reference_code`	`STRING`	Payment reference code. If specified, must be a valid reference code where the last digit is a check digit. If the field is given an empty string value, a reference code is automatically generated by Procountor. If the field is not provided at all, no reference code will be assigned to the invoice.
`payment_info__bank_reference_code_type`	`STRING`	Reference code generation type. If type not allowed for a user country will be given, then 400 is returned
`payment_info__clearing_code`	`STRING`	Receiver bank's clearing code for foreign payments.
`delivery_terms_info__name`	`STRING`	Name for terms of delivery.
`delivery_terms_info__municipality`	`STRING`	Delivery place
`extra_info__accounting_by_row`	`BOOL`	Indicates if accounting by row is used (true) or not (false). Accounting by row means that a separate ledger transaction is created for each invoice row.
`extra_info__unit_prices_include_vat`	`BOOL`	Indicates if the unit prices on invoice rows include VAT (true) or not (false).
`discount_percent`	`FLOAT64`	Invoice discount percentage. Scale: 4.
`order_reference`	`STRING`	Order reference of the invoice. This will be copied to the payment as message if no reference code is specified.
`invoice_number`	`INT64`	Invoice number generated by Procountor. For custom invoice numbers, see the originalInvoiceNumber property.
`vat_status`	`INT64`	Invoice VAT status. Required for all invoices except travel invoices and expense claims.
`original_invoice_number`	`STRING`	Invoice number from the biller in an external system.
`delivery_start_date`	`DATE`	First day of the delivery period.
`delivery_end_date`	`DATE`	Last day of the delivery period.
`delivery_method`	`STRING`	Delivery method for the goods. SALES_INVOICE and SALES_ORDER do not support type OTHER.
`delivery_instructions`	`STRING`	Delivery instructions.
`invoice_channel`	`STRING`	Channel of distribution for the invoice. Values EDIFACT and PAPER_INVOICE are not allowed for POST /invoices and PUT /invoices endpoints.
`invoice_operator_info__operator`	`STRING`	Invoice operator.
`invoice_operator_info__receiving_address`	`STRING`	Receiving address of operator.
`penalty_percent`	`FLOAT64`	Penal interest rate. Scale: 2.
`language`	`STRING`	Language of the invoice. Required for sales invoices and sales orders, otherwise ignored.
`invoice_template_id`	`INT64`	SALES_INVOICE and SALES_ORDER only. ID of invoice template.
`additional_information`	`STRING`	Invoice notes containing additional information. Visible on the invoice. Use \n as line break.
`vat_country`	`STRING`	Country code describing which country's VAT standards are being used. Usage of foreign VAT settings must be agreed on separately with Procountor. Required if the company uses foreign VATs. Example value: SWEDEN.See Address.country in POST/PUT /invoices for a list of allowable values
`ledger_receipt_id`	`INT64`	ID of the ledger receipt linked to this invoice. A ledger receipt is linked to every invoice for holding its accounting information. For defining ledger accounts, dimensions or VAT status regarding the invoice, modify the ledger receipt. See PUT /ledgerreceipts for more info.
`notes`	`STRING`	Invoice notes (seller's/buyer's notes). Not visible on the invoice. Use \n as line break.
`factoring_contract_id`	`INT64`	SALES_INVOICE and SALES_ORDER only. ID for external financing agreement. The bankAccount.accountNumber specified must match the one used by the specified financing agreement. Financing agreements cannot be used with cash payments.
`factoring_text`	`STRING`	SALES_INVOICE and SALES_ORDER only. Additional notes about external financing agreement.
`sum`	`FLOAT64`	Only for invoice type PERIODIC_TAX_RETURN. Ignored for other types. Contains the total sum of invoice. POST and PUT operation cannot assign/modify value of this property.
`order_number`	`STRING`	Order number. Valid only in Finnish environments for SALES_INVOICE and PURCHASE_INVOICE.
`agreement_number`	`STRING`	Agreement number. Valid only in Finnish environments for SALES_INVOICE and PURCHASE_INVOICE.
`accounting_code`	`STRING`	Accounting code. Valid only in Finnish environments for SALES_INVOICE and PURCHASE_INVOICE.
`delivery_site`	`STRING`	Delivery site. Valid only in Finnish environments for SALES_INVOICE and PURCHASE_INVOICE.
`tender_reference`	`STRING`	Tender reference. Valid only in Finnish environments for SALES_INVOICE and PURCHASE_INVOICE.
`buyer_reference_identifier`	`STRING`	Buyer reference. Valid only in Finnish environments for SALES_INVOICE and PURCHASE_INVOICE.
`seller_reference_identifier`	`STRING`	Seller reference. Valid only in Finnish environments for SALES_INVOICE and PURCHASE_INVOICE.
`created`	`TIMESTAMP`	Creation timestamp of the invoice. Automatically generated by Procountor.
`version`	`TIMESTAMP`	Invoice version. This field is required in the PUT /invoices/{invoiceId} endpoint.
`creator_id`	`INT64`	Invoice owner's user ID.
`is_offer`	`BOOL`	It marks invoice as an offer. It is applicable only to SALES_ORDER type of invoices.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: invoices__counter_party__bcc_addresses

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`	`STRING`
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: invoices__payment_info__cash_discount__option_list

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.
`number_of_days`	`INT64`	Days specified in cash discount
`discount_percentage`	`FLOAT64`	Discount percentage specified in cash discount
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: invoices__invoice_rows

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.
`id`	`INT64`	Unique identifier for a invoice row.
`product_id`	`INT64`	Unique identifier for a product. Links the invoice row to a product in the product register. Note that all other fields (name, price, ...) of an invoice row can be modified independently of the information in the product register. If one wants to use accounts from product register, accountingByRow must be true.
`product`	`STRING`	Product name.
`product_code`	`STRING`	Product code.
`quantity`	`FLOAT64`	Product quantity.
`unit`	`STRING`	Product unit.
`unit_price`	`FLOAT64`	Product unit price. This value is affected by the "unit prices include VAT" setting on the invoice.
`discount_percent`	`FLOAT64`	Product discount percentage.
`vat_percent`	`FLOAT64`	Product VAT percentage. Must be a percentage currently in use for the company.
`vat_status`	`INT64`	Product VAT status.
`comment`	`STRING`	Invoice row comment. Visible on the invoice. Use \ as line break.
`start_date`	`DATE`	Start date of accrual/delivery periods of invoice row.
`end_date`	`DATE`	End date of accrual/delivery periods of invoice row.
`header_text`	`STRING`	Header text of the content row associated with invoice row. Supported in sales offer, sales order and sales invoice.
`explanation_text`	`STRING`	Explanation text of the content row associated with invoice row. Supported in sales offer, sales order and sales invoice.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: invoices__travel_information_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.
`departure`	`STRING`	Travel departure date. Free text.
`arrival`	`STRING`	Travel return date. Free text.
`places`	`STRING`	Travel destinations. Free text.
`purpose`	`STRING`	Travel purpose. Free text.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: invoices__invoice_approval_information__acceptors

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.
`user_id`	`INT64`	User ID of the given checker. If invoice checker is given then this field is required
`event_performed`	`DATE`	Time when event was performed. Not present if event has not been performed.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: invoices__invoice_approval_information__verifiers

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.
`user_id`	`INT64`	User ID of the given checker. If invoice checker is given then this field is required
`event_performed`	`DATE`	Time when event was performed. Not present if event has not been performed.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: invoices__attachments

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.
`id`	`INT64`	Unique identifier of the attachment. Generated by Procountor and present in the object returned.
`name`	`STRING`	Attachment name. Include a correct file extension to the value.
`reference_type`	`STRING`	Reference type of the attachment. Indicates what object is the owner of the attachment. Exception: for JOURNAL type ledger receipts, use type INVOICE.
`reference_id`	`INT64`	Unique identifier of the referenced object. Exception: for JOURNAL type ledger receipts, use the value of invoiceId referring to the associated invoice.
`mime_type`	`STRING`	Mime type of the attachment. Determined from the file extension.
`send_with_invoice`	`BOOL`	Indicator if attachment has to be send with the invoice. 'sendWithInvoice' can be set only for receipt types: SALES_INVOICE, SALES_ORDER, PURCHASE_ORDER
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: invoices__invoice_sum_info

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.
`currency`	`STRING`	Accounting currency set for the environment or some other currency set in the invoice in ISO 4217 format.
`in_accounting_currency`	`BOOL`	True if the sum is in accounting currency.
`excluding_vat_total`	`FLOAT64`	Total Excluding VAT for all invoice rows.
`vat_sum_total`	`FLOAT64`	Total VAT sum for all invoice rows.
`invoice_sum_total`	`FLOAT64`	Sum of excludingVatTotal and vatSumTotal in accounting currency or invoice currency.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

invoices_basic (33 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`id`	`INT64`	Unique identifier of the invoice.
`partner_id`	`INT64`	Business partner id. Used to link the invoice to a customer or supplier in the business partner register.
`type`	`STRING`	Invoice type.
`status`	`STRING`	Invoice status.
`invoice_number`	`INT64`	Invoice number generated by Procountor.
`original_invoice_number`	`STRING`	Invoice number from the biller in an external system.
`invoice_channel`	`STRING`	Channel of distribution for the invoice.
`date`	`DATE`	Invoice date. This is synonymous to billing date.
`due_date`	`DATE`	Invoice payment due date.
`new_due_date`	`DATE`	Invoice payment new due date.
`created`	`TIMESTAMP`	Creation timestamp of the invoice. Automatically generated by Procountor.
`version`	`TIMESTAMP`	Invoice version timestamp. Automatically generated by Procountor and updated every time the invoice is modified.
`creator_id`	`INT64`	Invoice owner's user ID.
`counter_party__contact_person_name`	`STRING`	Name of the contact person.
`counter_party__identifier`	`STRING`	SALES_INVOICE, SALES_ORDER, PURCHASE_INVOICE and PURCHASE_ORDER only. Business ID or national identification number.
`counter_party__tax_code`	`STRING`	SALES_INVOICE and SALES_ORDER, PURCHASE_INVOICE and PURCHASE_ORDER only. Tax code of the customer.
`counter_party__customer_number`	`STRING`	SALES_INVOICE, SALES_ORDER, PURCHASE_INVOICE and PURCHASE_ORDER only. Customer number.
`counter_party__email`	`STRING`	SALES_INVOICE, SALES_ORDER and PURCHASE_ORDER only. Email address of the buyer. Required to be correct if supported.
`counter_party__counter_party_address__name`	`STRING`	Name ("first line") in the address.
`counter_party__counter_party_address__specifier`	`STRING`	Specifier, such as c/o address.
`counter_party__counter_party_address__street`	`STRING`	Street.Required for SALES_INVOICE and SALES_ORDER if invoicing channel is MAIL.In that case, must be specified in counterPartyAddress if not specified in billingAddress.Required for SALES_INVOICE if invoicing channel is ELECTRONIC_INVOICE. In that case,must be specified in billingAddress and counterPartyAddress.
`counter_party__counter_party_address__zip`	`STRING`	Zip code.Required for SALES_INVOICE and SALES_ORDER if invoicing channel is MAIL.In that case, must be specified in counterPartyAddress if not specified in billingAddress.Required for SALES_INVOICE if invoicing channel is ELECTRONIC_INVOICE. In that case,must be specified in billingAddress and counterPartyAddress.
`counter_party__counter_party_address__city`	`STRING`	City.Required for SALES_INVOICE and SALES_ORDER if invoicing channel is MAIL.In that case, must be specified in counterPartyAddress if not specified in billingAddress.Required for SALES_INVOICE if invoicing channel is ELECTRONIC_INVOICE. In that case,must be specified in billingAddress and counterPartyAddress.
`counter_party__counter_party_address__country`	`STRING`	Country.
`counter_party__counter_party_address__subdivision`	`STRING`	Subdivision of the city
`counter_party__bank_account__account_number`	`STRING`	Bank account IBAN. If using a financing agreement, the account number must match the account of the specified financing agreement. The account number must be valid for the specified country, include country code and exclude any spaces.
`counter_party__bank_account__bic`	`STRING`	Bank account BIC/SWIFT. Not supported for SALES_INVOICE and SALES_ORDER.
`counter_party__einvoice_address__operator`	`STRING`	SALES_INVOICE Only. Operator code. Required if the invoiceChannel is ELECTRONIC_INVOICE and country is FINLAND.
`counter_party__einvoice_address__address`	`STRING`	SALES_INVOICE Only. EInvoice Address. Required if the invoiceChannel is ELECTRONIC_INVOICE, format must be valid for the specified country.
`counter_party__einvoice_address__edi_id`	`STRING`	SALES_INVOICE Only. EDI identifier. Used if the invoiceChannel is ELECTRONIC_INVOICE and country is FINLAND.
`is_offer`	`BOOL`	Indicates whether the invoice is an offer.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: invoices_basic__invoice_sum_info

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.
`currency`	`STRING`	Accounting currency set for the environment or some other currency set in the invoice in ISO 4217 format.
`in_accounting_currency`	`BOOL`	True if the sum is in accounting currency.
`excluding_vat_total`	`FLOAT64`	Total Excluding VAT for all invoice rows.
`vat_sum_total`	`FLOAT64`	Total VAT sum for all invoice rows.
`invoice_sum_total`	`FLOAT64`	Sum of excludingVatTotal and vatSumTotal in accounting currency or invoice currency.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: invoices_basic__counter_party__bcc_addresses

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`	`STRING`
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

ledger_receipts (27 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`id`	`INT64`	Unique identifier of the ledger receipt. Generated by Procountor and present in the object returned.
`type`	`STRING`	Ledger receipt type. Use JOURNAL for creating ledger receipts (vouchers) containing ledger transactions without linkage to pre-existing resources. Other types are automatically generated by Procountor for holding accounting information for e.g. invoices. Types allowed for POST = JOURNAL. Types allowed for PUT = JOURNAL, SALES_INVOICE, PURCHASE_INVOICE, TRAVEL_INVOICE, BILL_OF_CHARGES Types allowed for GET listed below
`status`	`STRING`	Ledger receipt status. Status of a ledger receipt equals the status of the linked invoice. All ledger receipts are initially created with status UNFINISHED. For journals, possible statuses are UNFINISHED, APPROVED and INVALIDATED. Ledger receipt statuses cannot be directly modified through the API.
`name`	`STRING`	Ledger receipt name.
`receipt_date`	`DATE`	Ledger receipt date. Must not be in a closed fiscal period. See GET /fiscalyears for a list of fiscal years.
`vat_type`	`STRING`	Ledger receipt VAT type.
`vat_status`	`INT64`	Ledger receipt VAT status. This can be overridden on transaction level. Use here the numeric parts of VAT status codes listed in "VAT defaults" in Procountor. For example, for VAT status code "vat_12", use value 12. The VAT status used must be enabled for the current receipt type (sales/purchase).
`vat_processing`	`STRING`	Ledger receipt VAT country. Only for JOURNAL types of ledger receipts. Requires a special right for foreign VATs. See Address.country in POST /invoices for a list of allowable values.
`invoice_id`	`INT64`	ID of the linked invoice. For sales and purchase invoice ledger receipts, this refers to the invoice the receipt holds accounting data for. For journal receipts, an invoice is automatically generated to store certain data fields. Use this ID in POST /attachments endpoint.
`receipt_number`	`INT64`	Number of the ledger receipt.
`invoice_notes`	`STRING`	Invoice notes. Linked to Invoice.notes. Not visible on ledger receipt printouts. Use \n as line break. Max length 10000.
`invoice_number`	`INT64`	Number of the linked invoice. Automatically generated by Procountor.
`accountants_notes`	`STRING`	Notes made by the accountant. Visible on ledger receipt printouts.
`transaction_description`	`STRING`	Transaction description. This is a summary description for any transactions belonging to the ledger receipt.
`receipt_validity`	`STRING`	Receipt validity time.
`period_start_date`	`DATE`	Start date of the receipt period. If set, must precede the end date of the period.
`period_end_date`	`DATE`	End date of the receipt period. If this and the start date are set, this must be after the start date.
`partner_id`	`INT64`	Technical ID for the business partner. Link the related invoice to a customer or supplier in the business partner register. If supplied, the company must have this partner ID in the corresponding register.
`partner_code`	`STRING`	Partner code. Identifier for the related company or person. May represent a business ID, national identification number (HETU in Finland) or an account number, depending on the receipt type.
`serial_number__series`	`STRING`	Ledger receipt series.
`serial_number__number`	`INT64`	Ledger receipt serial number.
`created`	`TIMESTAMP`	Creation timestamp of the ledger receipt. Automatically generated by Procountor.
`version`	`TIMESTAMP`	Ledger receipt version timestamp. Automatically generated by Procountor and updated every time the receipt is modified. When using PUT /ledgerreceipts, it is required to include the latest version timestamp of the receipt to the request. This prevents conflicts if the receipt is being modified from several sources.
`depreciation`	`STRING`	Accounting depreciation method for the receipt.
`vat_date`	`DATE`	VAT date to be used if payment based VAT is enabled
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: ledger_receipts__transactions

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.
`id`	`INT64`	Unique identifier for the ledger transaction. Automatically generated by Procountor and present in the object returned.
`transaction_type`	`STRING`	Transaction type. Depends on the transaction and the ledger account in question. Type REVERSING_ENTRY is used to indicate the first row of a ledger receipt for a specific logic on the UI. Typically, it represents a transaction for a balance sheet account. Note that ledger receipts with no transactions marked as reversing entries are possible. Type ENTRY is the general type for transactions. It can be used even on the first rows of ledger receipts. Type RECONCILIATION_ENTRY is used for getting the sum of transactions on a receipt to reconcile (to equal zero). Generally, all ledger receipts should reconcile. Procountor can create reconciliation entries automatically for ledger receipts when "createReconciliation=true" query parameter is specified. If VAT is used, a reconciliation row might be necessary due to remainders and rounding. For both REVERSING_ENTRY and RECONCILIATION_ENTRY transactions, vatStatus cannot be defined and vatPercent must be 0. Additionally, a ledger can have maximum of one REVERSING_ENTRY and maximum of one RECONCILIATION_ENTRY transaction. Transactions of these types cannot be removed from a ledger receipt using UI once created.
`account`	`STRING`	Ledger account number for the transaction. Must be valid for the current Procountor environment. Use GET /coa to obtain the chart of accounts.
`accounting_value`	`FLOAT64`	Transaction accounting value. This value is net. It will be automatically rounded up to scale 2.
`vat_percent`	`FLOAT64`	Transaction VAT percentage. Must be a percentage currently in use for the company.
`vat_type`	`STRING`	Transaction VAT type.
`vat_status`	`INT64`	Transaction VAT status. This overrides the VAT status set for the parent ledger receipt. Use here the numeric parts of VAT status codes listed in "VAT defaults" in Procountor. For example, for VAT status code "vat_12", use value 12. The VAT status used must be enabled for the current receipt type (sales/purchase).
`description`	`STRING`	Transaction description. Visible on ledger receipt printouts.
`balance_code`	`STRING`	Transaction balance code. Only available if the use balance sheet setting is enabled.
`partner_id`	`INT64`	Technical ID for the partner. Can be provided in Norwegian environments only. The given partner id must match a partner of type different than PERSON, existing in the current Procountor environment.
`vat_deduction_percent`	`FLOAT64`	VAT deduction percentage for the transaction.
`start_date`	`DATE`	Start date of accrual/delivery periods of transaction.
`end_date`	`DATE`	End date of accrual/delivery periods of transaction.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: ledger_receiptstransactionsallocations

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`	`INT64`
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: ledger_receiptstransactionsdimension_item_values

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.
`dimension_id`	`INT64`	Dimension ID. Must exist in the current environment. For a list of available dimensions, see the GET /dimensions endpoint.
`item_id`	`INT64`	Dimension item ID. Must exist in the current environment. For a list of available dimensions, see the GET /dimensions endpoint.
`value`	`FLOAT64`	Dimension item value with maximum two decimal places. Use absolute values instead of percentages. The sum of dimension item values on a dimension must equal the accounting value of the parent transaction.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: ledger_receipts__attachments

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.
`id`	`INT64`	Unique identifier of the attachment. Generated by Procountor and present in the object returned.
`name`	`STRING`	Attachment name. Include a correct file extension to the value.
`reference_type`	`STRING`	Reference type of the attachment. Indicates what object is the owner of the attachment. Exception: for JOURNAL type ledger receipts, use type INVOICE.
`reference_id`	`INT64`	Unique identifier of the referenced object. Exception: for JOURNAL type ledger receipts, use the value of invoiceId referring to the associated invoice.
`mime_type`	`STRING`	Mime type of the attachment. Determined from the file extension.
`send_with_invoice`	`BOOL`	Indicator if attachment has to be send with the invoice. 'sendWithInvoice' can be set only for receipt types: SALES_INVOICE, SALES_ORDER, PURCHASE_ORDER
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

ledger_receipts_basic (13 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`id`	`INT64`	Unique identifier for the ledger receipt.
`type`	`STRING`	Ledger receipt type.
`status`	`STRING`	Ledger receipt status.
`name`	`STRING`	Ledger receipt name.
`receipt_date`	`DATE`	Ledger receipt date.
`receipt_number`	`INT64`	Number of the ledger receipt.
`invoice_number`	`INT64`	Number of the linked invoice. Automatically generated by Procountor.
`serial_number__series`	`STRING`	Ledger receipt series.
`serial_number__number`	`INT64`	Ledger receipt serial number.
`created`	`TIMESTAMP`	Creation timestamp of the ledger receipt. Automatically generated by Procountor.
`version`	`TIMESTAMP`	Ledger receipt version timestamp. Automatically generated by Procountor and updated every time the ledger receipt is modified.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

payments (11 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`id`	`INT64`	Unique payment identifier.
`invoice_id`	`INT64`	Unique invoice identifier.
`payment_date`	`DATE`	Date specifying when the payment transaction has to be performed.
`amount`	`FLOAT64`	The amount of the payment in the given currency. Currency is defined within the invoice.
`receiver_name`	`STRING`	Recipient name.
`status`	`STRING`	Payment status.
`service_charge`	`STRING`	If not provided, for Finnish foreign payment it will be automatically set to BOTH_PAY_OWN_FEES.
`paid_amount`	`FLOAT64`	Payment amount in paid currency.
`paid_currency`	`STRING`	Currency of the payment in paid currency in ISO 4217 format.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

product_groups (5 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`id`	`INT64`	Product group id.
`name`	`STRING`	Product group name.
`type`	`STRING`	Product type.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

products (19 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`id`	`INT64`	Unique identifier of the product. Generated by Procountor.
`type`	`STRING`	Product type: to which kind of invoices the product can be assigned.
`name`	`STRING`	Product name.
`code`	`STRING`	Custom code assigned by the owner of the product.
`unit`	`STRING`	Product unit.
`discount`	`FLOAT64`	Product discount percentage.
`price`	`FLOAT64`	Product price.
`vat`	`FLOAT64`	Product VAT percentage.
`active`	`BOOL`	Product status.
`default_account`	`STRING`	Default ledger account for the product.
`vat_status`	`INT64`	Product VAT status. Allowed VAT statuses are available under GET /vats/default
`currency`	`STRING`	Currency for the product in ISO 4217 format.
`product_group_id`	`INT64`	Product group ID.
`start_date`	`DATE`	Get start date for the product. Used by TRAVEL type only.
`end_date`	`DATE`	Get end date for the product. Used by TRAVEL type only.
`bookkeeping_account`	`STRING`	Get bookkeeping account code for the product. Used by TRAVEL type only.
`version`	`TIMESTAMP`	Product version timestamp. Automatically generated by Procountor and updated every time the product is updated.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: products__product_localizations

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.
`language`	`STRING`	Product language
`product_name`	`STRING`	Product name
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

vat_statuses (6 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`vat_status`	`INT64`	VAT status ID
`description`	`STRING`	VAT status description
`sales`	`BOOL`	Is VAT status allowed for sales
`purchase`	`BOOL`	Is VAT status allowed for purchase
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

How the Finago Procountor sync works

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Finago Procountor 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 Finago Procountor?

It depends on how much history is in your Finago Procountor 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 Finago Procountor'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 Finago Procountor, 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 Finago Procountor 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 Finago Procountor connector in Kaivo and all of its synced data is deleted with it.

Common use cases for Finago Procountor data

Financial reporting

Build profit and loss and balance reporting from your Procountor ledger data.

Invoicing and cash flow

Track sales and purchase invoices to monitor receivables, payables, and cash flow.

Combine with sales

Join Procountor financials with sales or CRM data in BigQuery for a full picture.

Period comparisons

Report on financials over time to compare months, quarters, and years.

Use Finago Procountor data in your AI and BI tools

Once Finago Procountor 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 Finago Procountor 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 Finago Procountor 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