Skip to content
Book a demoStart free
Connectors

Zoho Billing connector

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

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

Kaivo is a fully managed data platform that syncs your Zoho Billing 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 Billing data into BigQuery with Kaivo to analyse subscriptions, invoices, and recurring revenue.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service

Getting started with the Zoho Billing connector

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

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

| | Refresh Token |

The refresh token obtained after completing the OAuth authorization flow.

|

Prerequisites

Zoho Billing 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 ZohoBilling.fullaccess.all scope, then exchange it for a Refresh Token (see Zoho Billing’s 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
OAuth Client ID
The Client ID of your Zoho Billing developer application.

| | Region |

The region where your Zoho Billing account is hosted.

|

Tables and columns synced from Zoho Billing

Section titled “Tables and columns synced from Zoho Billing”

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

addons (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
addon_code STRING
addon_id STRING
applicable_to_all_plans BOOL
created_at STRING
created_time STRING
image_id STRING
interval_unit STRING
interval_unit_formatted STRING
is_proration_disabled BOOL
name STRING
pricing_scheme STRING
pricing_scheme_formatted STRING
product_id STRING
product_name STRING
product_type STRING
show_in_widget BOOL
status STRING
status_formatted STRING
store_description STRING
store_markup_description STRING
tax_id STRING
tax_name STRING
tax_percentage FLOAT64
tax_type STRING
type_formatted STRING
unit_name STRING
updated_time 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.
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.
price FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
coupons (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
apply_on STRING
coupon_code STRING
coupon_id STRING
created_at STRING
created_time STRING
discount_by STRING
discount_value FLOAT64
duration FLOAT64
expiry_at STRING
max_redemption FLOAT64
name STRING
product_id STRING
product_name STRING
redemption_count FLOAT64
status STRING
updated_time STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customers (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
company_name STRING
contact_id STRING
created_by STRING
created_time STRING
currency_code STRING
currency_symbol STRING
customer_id STRING
customer_name STRING
display_name STRING
email STRING
first_name STRING
has_attachment BOOL
is_backup_associated BOOL
is_gapps_customer BOOL
is_portal_invitation_accepted BOOL
is_primary_associated BOOL
last_name STRING
mobile STRING
outstanding FLOAT64
outstanding_receivable_amount FLOAT64
outstanding_receivable_amount_bcy FLOAT64
payment_terms FLOAT64
payment_terms_label STRING
phone STRING
status STRING
unused_credits FLOAT64
unused_credits_receivable_amount_bcy FLOAT64
updated_time STRING
website STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
expenses (34 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
reference_number STRING
report_id STRING
report_name STRING
report_number STRING
start_reading STRING
status STRING
total FLOAT64
total_without_tax FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoices (65 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ach_payment_initiated BOOL
balance FLOAT64
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__street STRING
billing_address__street2 STRING
billing_address__zipcode STRING
billing_city STRING
billing_country STRING
billing_phone STRING
billing_state STRING
billing_street STRING
billing_street2 STRING
billing_zipcode STRING
client_viewed_time STRING
country STRING
created_by STRING
created_time STRING
currency_code STRING
currency_symbol STRING
customer_id STRING
customer_name STRING
due_date STRING
email STRING
has_attachment BOOL
invoice_date STRING
invoice_id STRING
invoice_number STRING
is_viewed_by_client BOOL
is_viewed_in_mail BOOL
mail_first_viewed_time STRING
mail_last_viewed_time STRING
number STRING
payment_expected_date STRING
phone STRING
project_name STRING
reference_number STRING
salesperson STRING
salesperson_name 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__street STRING
shipping_address__street2 STRING
shipping_address__zipcode STRING
shipping_city STRING
shipping_country STRING
shipping_phone STRING
shipping_state STRING
shipping_street STRING
shipping_street2 STRING
shipping_zipcode STRING
status STRING
total FLOAT64
transaction_type STRING
updated_time STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
plans (37 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
account STRING
account_id STRING
billing_cycles FLOAT64
billing_mode STRING
created_time STRING
created_time_formatted STRING
interval FLOAT64
interval_unit STRING
name STRING
plan_code STRING
plan_id STRING
pricing_scheme STRING
pricing_scheme_formatted STRING
product_id STRING
product_type STRING
recurring_price FLOAT64
setup_fee FLOAT64
setup_fee_account_id STRING
setup_fee_account_name STRING
shipping_interval FLOAT64
shipping_interval_unit STRING
show_in_widget BOOL
status STRING
store_description STRING
store_markup_description STRING
tax_id STRING
tax_name STRING
tax_percentage FLOAT64
tax_type STRING
trial_period FLOAT64
unit STRING
updated_time STRING
updated_time_formatted STRING
url 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.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
price FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Products (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
addons_count FLOAT64
coupons_count FLOAT64
created_at STRING
created_time STRING
email_ids STRING
name STRING
plans_count FLOAT64
product_id STRING
redirect_url STRING
status STRING
updated_time STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Quotes (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.
recurring expenses (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
account_name STRING
created_time STRING
currency_code STRING
currency_id STRING
customer_name STRING
is_billable BOOL
last_created_date STRING
last_modified_time STRING
next_expense_date STRING
paid_through_account_name STRING
recurrence_frequency STRING
recurrence_name STRING
recurring_expense_id STRING
repeat_every FLOAT64
status STRING
total FLOAT64
vendor_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
subscriptions (51 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
activated_at STRING
amount FLOAT64
auto_collect BOOL
billing_mode STRING
coupon_duration STRING
created_at STRING
created_by STRING
created_time STRING
crm_owner_id STRING
currency_code STRING
currency_symbol STRING
current_term_ends_at STRING
current_term_starts_at STRING
customer_id STRING
customer_name STRING
email STRING
expires_at STRING
interval FLOAT64
interval_unit STRING
is_metered_billing BOOL
mobile_phone STRING
name STRING
next_billing_at STRING
next_shipment_at STRING
next_shipment_day STRING
orders_created STRING
orders_remaining STRING
payment_terms FLOAT64
payment_terms_label STRING
phone STRING
plan_code STRING
plan_name STRING
reference_id STRING
salesperson_id STRING
salesperson_name STRING
scheduled_cancellation_date STRING
shipping_interval FLOAT64
shipping_interval_unit STRING
status STRING
sub_total FLOAT64
subscription_id STRING
subscription_number STRING
total_orders STRING
trial_ends_at STRING
trial_remaining_days FLOAT64
trial_starts_at STRING
updated_time STRING
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.
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 (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
ach_payment_initiated BOOL
amount FLOAT64
date STRING
reference_id STRING
status STRING
transaction_id 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 Billing 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 Billing?

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

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

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

Use subscriptions and invoices to track recurring revenue and churn over time.

Join transactions with invoices to reconcile billing.

Use plans and addons to see which plans drive revenue.

Use Zoho Billing data in your AI and BI tools

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

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