Skip to content
Book a demoStart free
Connectors

Finago Procountor connector

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

Finago Procountor connector pricing, tier and credits on kaivo.io

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.

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

CategoryFinance & Payments, ERP
AuthenticationOAuth or API key
SetupSelf-service

Getting started with the Finago Procountor connector

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

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.

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):
  1. Go to Procountor’s Users and privileges settings
  2. Click “Create new user”
  3. 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
  4. 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:

  1. Go to API client keys settings
  2. Click “New API key”
  3. Select the newly created user “API, Kaivo” and write “kaivoAPIClient” to Client ID field (asiakasohjelmiston tunniste)

|

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

Section titled “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.
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

Section titled “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

Section titled “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.
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

Section titled “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

Section titled “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

Section titled “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.
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.
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

Section titled “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

Section titled “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.
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

Section titled “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

Section titled “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

Section titled “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.
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.
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

Section titled “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

Section titled “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.
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_receipts__transactions__allocations

Section titled “Subtable: ledger_receipts__transactions__allocations”
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_receipts__transactions__dimension_item_values

Section titled “Subtable: ledger_receipts__transactions__dimension_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.
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.
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.

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.

How long does the initial sync take for Finago Procountor?

Section titled “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.

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?

Section titled “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.

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

Section titled “Common use cases for Finago Procountor data”

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

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

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

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

Use Finago Procountor data in your AI and BI tools

Section titled “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.

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 Finago Procountor connector pricing and plan details.