Skip to content
Book a demoStart free
Connectors

Zoho Books connector

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

Zoho Books connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Zoho Books 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 Zoho Books accounting data into BigQuery with Kaivo to analyse invoices, expenses, and the ledger in one place.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service

Getting started with the Zoho Books connector

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

Authenticate with your Zoho Books credentials. You provide:

Field Description
OAuth Client Secret
The Client Secret of your Zoho Books developer application.

| | OAuth Refresh Token |

The refresh token obtained after completing the OAuth authorization flow.

|

Prerequisites

Zoho Books only supports OAuth, so you need your own Zoho developer application:

  1. Go to the Zoho API Console, create a Self Client (the simplest option for a data sync), and note your Client ID and Client Secret.
  2. Generate a grant token for the ZohoBooks.fullaccess.all scope, then exchange it for a Refresh Token (see Zoho Books OAuth docs). Use the accounts URL for your account’s region, e.g. accounts.zoho.com (US) or accounts.zoho.eu (EU).

Then enter those values below.

Need help, or want an easier way to connect? Reach our team via the chat in the bottom-right corner.

When you set up the connector, you provide:

Field Description
Region
The region where your Zoho Books account is hosted.

| | OAuth Client ID |

The Client ID of your Zoho Books developer application.

| | Start Date |

Any data before this date will not be fetched.

|

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

banking (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_code STRING
account_id STRING
account_name STRING
account_number STRING
account_type STRING
balance FLOAT64
bank_balance FLOAT64
bank_name STRING
bcy_balance FLOAT64
consent_info__consent_remaining_days STRING
consent_info__is_consent_expired STRING
currency_code STRING
currency_id STRING
feed_status STRING
feeds_last_refresh_date STRING
is_active BOOL
is_beta_feed BOOL
is_direct_paypal BOOL
is_paypal_account BOOL
is_primary_account BOOL
partner_bank_source STRING
partner_bank_source_formatted STRING
routing_number STRING
statement_suggestion_count FLOAT64
total_unprinted_checks FLOAT64
uncategorized_transactions FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
bills (32 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
attachment_name STRING
balance FLOAT64
bill_id STRING
bill_number STRING
client_viewed_time STRING
color_code STRING
created_time STRING
currency_code STRING
currency_id STRING
current_sub_status STRING
current_sub_status_id STRING
date STRING
due_date STRING
due_days STRING
entity_type STRING
exchange_rate FLOAT64
has_attachment BOOL
is_bill_reconciliation_violated BOOL
is_tally_bill BOOL
is_uber_bill BOOL
is_viewed_by_client BOOL
last_modified_time STRING
price_precision FLOAT64
reference_number STRING
status STRING
tds_total FLOAT64
total FLOAT64
unprocessed_payment_amount FLOAT64
vendor_id STRING
vendor_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
contacts (44 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ach_supported BOOL
company_name STRING
contact_id STRING
contact_name STRING
contact_type STRING
contact_type_formatted STRING
created_time STRING
created_time_formatted STRING
currency_code STRING
currency_id STRING
customer_name STRING
customer_sub_type STRING
email STRING
facebook STRING
first_name STRING
has_attachment BOOL
is_linked_with_zohocrm BOOL
language_code STRING
language_code_formatted STRING
last_modified_time STRING
last_modified_time_formatted STRING
last_name STRING
mobile STRING
outstanding_payable_amount FLOAT64
outstanding_payable_amount_bcy FLOAT64
outstanding_receivable_amount FLOAT64
outstanding_receivable_amount_bcy FLOAT64
pan_no STRING
payment_terms FLOAT64
payment_terms_label STRING
phone STRING
portal_status STRING
portal_status_formatted STRING
source STRING
status STRING
twitter STRING
unused_credits_payable_amount FLOAT64
unused_credits_payable_amount_bcy FLOAT64
unused_credits_receivable_amount FLOAT64
unused_credits_receivable_amount_bcy FLOAT64
vendor_name STRING
website 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.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
creditnotes (34 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
applied_invoices STRING
balance FLOAT64
client_viewed_time STRING
color_code STRING
created_time STRING
creditnote_id STRING
creditnote_number STRING
currency_code STRING
currency_id STRING
current_sub_status STRING
current_sub_status_id STRING
customer_id STRING
customer_name STRING
date STRING
exchange_rate FLOAT64
has_attachment BOOL
is_emailed BOOL
is_viewed_by_client BOOL
item_price FLOAT64
item_quantity FLOAT64
item_total FLOAT64
item_total_price FLOAT64
item_total_without_tax FLOAT64
last_modified_time STRING
price_precision FLOAT64
reference_number STRING
salesperson_id STRING
salesperson_name STRING
status STRING
template_id STRING
template_type STRING
total FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customer_payments (34 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
account_id STRING
account_name STRING
amount FLOAT64
bcy_amount FLOAT64
bcy_refunded_amount FLOAT64
bcy_unused_amount FLOAT64
created_time STRING
custom_fields_list STRING
customer_id STRING
customer_name STRING
date STRING
documents STRING
gateway_transaction_id STRING
has_attachment BOOL
invoice_numbers STRING
last_four_digits STRING
last_modified_time STRING
payment_gateway STRING
payment_id STRING
payment_mode STRING
payment_mode_formatted STRING
payment_number STRING
payment_status STRING
payment_type STRING
product_description STRING
reference_number STRING
settlement_status STRING
tax_account_id STRING
tax_account_name STRING
tax_amount_withheld FLOAT64
unused_amount FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customer_payments__applied_invoices

Section titled “Subtable: customer_payments__applied_invoices”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
estimates (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
accepted_date STRING
client_viewed_time STRING
color_code STRING
company_name STRING
created_time STRING
currency_code STRING
currency_id STRING
current_sub_status STRING
current_sub_status_id STRING
customer_id STRING
customer_name STRING
date STRING
declined_date STRING
estimate_id STRING
estimate_number STRING
expiry_date STRING
has_attachment BOOL
is_emailed BOOL
is_viewed_by_client BOOL
last_modified_time STRING
reference_number STRING
salesperson_id STRING
salesperson_name STRING
status STRING
template_id STRING
template_type STRING
total FLOAT64
zcrm_potential_id STRING
zcrm_potential_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
expenses (38 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
account_name STRING
bcy_total FLOAT64
bcy_total_without_tax FLOAT64
created_time STRING
currency_code STRING
currency_id STRING
custom_fields_list STRING
customer_id STRING
customer_name STRING
date STRING
distance FLOAT64
end_reading STRING
exchange_rate FLOAT64
expense_id STRING
expense_receipt_name STRING
expense_type STRING
has_attachment BOOL
is_billable BOOL
is_personal BOOL
last_modified_time STRING
mileage_rate FLOAT64
mileage_type STRING
mileage_unit STRING
paid_through_account_name STRING
reference_number STRING
report_id STRING
report_name STRING
report_number STRING
start_reading STRING
status STRING
total FLOAT64
total_without_tax FLOAT64
user_name STRING
vendor_id STRING
vendor_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoices (74 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
ach_payment_initiated BOOL
adjustment FLOAT64
balance FLOAT64
billing_address__address STRING
billing_address__attention STRING
billing_address__city STRING
billing_address__country STRING
billing_address__fax STRING
billing_address__phone STRING
billing_address__state STRING
billing_address__street2 STRING
billing_address__zipcode STRING
client_viewed_time STRING
color_code STRING
company_name STRING
country STRING
created_by STRING
created_time STRING
currency_code STRING
currency_id STRING
currency_symbol STRING
current_sub_status STRING
current_sub_status_id STRING
customer_id STRING
customer_name STRING
date STRING
documents STRING
due_date STRING
due_days STRING
email STRING
exchange_rate FLOAT64
has_attachment BOOL
invoice_id STRING
invoice_number STRING
invoice_url STRING
is_emailed BOOL
is_pre_gst BOOL
is_viewed_by_client BOOL
last_modified_time STRING
last_payment_date STRING
last_reminder_sent_date STRING
no_of_copies FLOAT64
payment_expected_date STRING
phone STRING
project_name STRING
reference_number STRING
reminders_sent FLOAT64
salesperson_id STRING
salesperson_name STRING
schedule_time STRING
shipping_address__address STRING
shipping_address__attention STRING
shipping_address__city STRING
shipping_address__country STRING
shipping_address__fax STRING
shipping_address__phone STRING
shipping_address__state STRING
shipping_address__street2 STRING
shipping_address__zipcode STRING
shipping_charge FLOAT64
show_no_of_copies BOOL
status STRING
template_id STRING
template_type STRING
total FLOAT64
transaction_type STRING
unprocessed_payment_amount FLOAT64
updated_time STRING
write_off_amount FLOAT64
zcrm_potential_id STRING
zcrm_potential_name 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.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
items (34 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
account_id STRING
account_name STRING
actual_available_stock FLOAT64
available_stock FLOAT64
created_time STRING
has_attachment BOOL
image_document_id STRING
image_name STRING
image_type STRING
is_linked_with_zohocrm BOOL
item_id STRING
item_name STRING
item_type STRING
last_modified_time STRING
name STRING
product_type STRING
purchase_account_id STRING
purchase_account_name STRING
purchase_description STRING
purchase_rate FLOAT64
rate FLOAT64
reorder_level STRING
sku STRING
source STRING
status STRING
stock_on_hand FLOAT64
tax_id STRING
tax_name STRING
tax_percentage FLOAT64
unit STRING
zcrm_product_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
journals (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
bcy_total FLOAT64
created_by_id STRING
created_by_name STRING
currency_id STRING
entity_type STRING
entry_number STRING
journal_date STRING
journal_id STRING
journal_type STRING
notes STRING
reference_number STRING
status STRING
total FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
organizations (76 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version STRING
account_created_date STRING
account_created_date_formatted STRING
can_change_timezone BOOL
can_show_document_tab BOOL
can_sign_invoice BOOL
contact_name STRING
country STRING
country_code STRING
currency_code STRING
currency_format STRING
currency_id STRING
currency_symbol STRING
custom_field_type FLOAT64
digital_signature_mode STRING
email STRING
field_separator STRING
fiscal_year_start_month FLOAT64
is_org_active BOOL
is_org_not_supported BOOL
is_default_org BOOL
is_designated_zone BOOL
is_dsign_required BOOL
is_export_with_payment_enabled BOOL
is_free_zone BOOL
is_gst_india_version BOOL
is_hsn_or_sac_enabled BOOL
is_international_trade_enabled BOOL
is_invoice_pmt_tds_allowed BOOL
is_org_active BOOL
is_quick_setup_completed BOOL
is_registered_for_composite_scheme BOOL
is_registered_for_gst BOOL
is_registered_for_tax BOOL
is_sales_inclusive_tax_enabled BOOL
is_sales_reverse_charge_enabled BOOL
is_scan_preference_enabled BOOL
is_search360_enabled STRING
is_sku_enabled BOOL
is_solo_org BOOL
is_tax_registered BOOL
is_trial_expired BOOL
is_trial_period_extended BOOL
is_user_accountant BOOL
is_user_dsign_mandatory BOOL
is_ziedition BOOL
is_zpayroll_grid BOOL
language_code STRING
mode STRING
name STRING
org_action STRING
org_created_app_source FLOAT64
org_settings BOOL
org_type STRING
organization_id STRING
partners_domain STRING
phone STRING
plan_name STRING
plan_period STRING
plan_type FLOAT64
price_precision FLOAT64
sales_tax_type STRING
source FLOAT64
state STRING
state_code STRING
tax_group_enabled BOOL
time_zone STRING
time_zone_formatted STRING
user_status FLOAT64
user_status_formatted STRING
version_formatted STRING
zi_zb_client FLOAT64
zi_zb_edition FLOAT64
zoho_one_org 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.
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.
index FLOAT64
label STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: organizations__org_joined_app_list

Section titled “Subtable: organizations__org_joined_app_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.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
purchase_orders (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billed_status STRING
client_viewed_time STRING
color_code STRING
company_name STRING
created_time STRING
currency_code STRING
currency_id STRING
current_sub_status STRING
current_sub_status_id STRING
date STRING
delivery_date STRING
delivery_days STRING
due_by_days STRING
due_in_days STRING
has_attachment BOOL
is_viewed_by_client BOOL
last_modified_time STRING
order_status STRING
price_precision STRING
purchaseorder_id STRING
purchaseorder_number STRING
quantity_marked_as_received FLOAT64
quantity_yet_to_receive FLOAT64
reference_number STRING
status STRING
total FLOAT64
vendor_id STRING
vendor_name 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.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
sales_orders (41 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
bcy_total FLOAT64
color_code STRING
company_name STRING
created_time STRING
currency_code STRING
currency_id STRING
current_sub_status STRING
current_sub_status_id STRING
custom_fields_list STRING
customer_id STRING
customer_name STRING
date STRING
delivery_date STRING
delivery_method STRING
delivery_method_id STRING
due_by_days STRING
due_in_days STRING
email STRING
has_attachment BOOL
invoiced_status STRING
is_emailed BOOL
last_modified_time STRING
order_fulfillment_type STRING
order_status STRING
paid_status STRING
pickup_location_id STRING
quantity_invoiced FLOAT64
reference_number STRING
salesorder_id STRING
salesorder_number STRING
salesperson_name STRING
shipment_date STRING
shipment_days STRING
source STRING
status STRING
total FLOAT64
total_invoiced_amount FLOAT64
zcrm_potential_id STRING
zcrm_potential_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
taxes (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
diff_rate_reason STRING
end_date STRING
is_default_tax BOOL
is_editable BOOL
is_inactive BOOL
last_modified_time STRING
output_tax_account_name STRING
start_date STRING
status STRING
tax_account_id STRING
tax_id STRING
tax_name STRING
tax_percentage FLOAT64
tax_specific_type STRING
tax_specification STRING
tax_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
transactions (35 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
account_id STRING
account_name STRING
account_type STRING
amount FLOAT64
currency_code STRING
currency_id STRING
currency_symbol STRING
customer_id STRING
date STRING
debit_or_credit STRING
exclude_description STRING
imported_transaction_id STRING
is_auto_categorized BOOL
is_excluded_by_system BOOL
is_offsetaccount_matched BOOL
is_paid_via_print_check BOOL
is_rule_exist BOOL
offset_account_code STRING
offset_account_name STRING
payee STRING
payroll_tax_group_formatted STRING
price_precision FLOAT64
reconcile_status STRING
reference_number STRING
rule_id STRING
rule_name STRING
running_balance STRING
running_balance_formatted STRING
source STRING
status STRING
transaction_id STRING
transaction_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
email STRING
invitation_type STRING
is_current_user BOOL
is_customer_segmented BOOL
is_employee BOOL
is_super_admin BOOL
is_vendor_segmented BOOL
mobile STRING
name STRING
photo_url STRING
role_id STRING
status STRING
user_id STRING
user_role STRING
user_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

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

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

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

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

Use invoices and customer_payments to track billed and collected revenue over time.

Join bills with purchase_orders to monitor what you owe.

Use banking and journals to track money in and out.

Use Zoho Books data in your AI and BI tools

Section titled “Use Zoho Books data in your AI and BI tools”

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