Finance and payments
Connect Zoho Books to DataxLand
The Zoho Books connector reads invoices, bills, customer payments, expenses, credit notes, purchase orders, sales orders, estimates, journals and contacts from a Zoho Books organization. Si maps the data to the finance and operations models, giving you booked revenue, gross profit, expenses, receivables and payables, average days to collect and purchase order value, next to sales data from marketplaces or your website in the same workspace.
Free plan with no time limit · No card required · Sample workspace ready in minutes
What you can do with Zoho Books
- Track overdue receivables and average days to collect by customer.
- Compare monthly booked expenses with budget.
- Track vendor purchase order value next to cost of goods sold.
What data you get
Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.
| Stream (table) | Contents |
|---|---|
| invoices | Sales invoices, due dates and balance outstanding. |
| customer_payments | Customer payments. |
| bills | Vendor bills. |
| expenses | Recorded expenses. |
| creditnotes | Credit notes. |
| purchase_orders | Purchase orders. |
| journals | Journal entries. |
| contacts | Customers and vendors (personal-data columns are hashed on load). |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Fields to fill in | OAuth Client ID, OAuth Client Secret, OAuth Refresh Token, Region, Start date |
| Developer | Airbyte (community), run inside DataxLand |
| License | ELv2 |
Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.
Metrics computed from this source
Real definitions from the analytics packs; dashboards and Si share them.
| Metric | Definition | Unit |
|---|---|---|
| Booked revenue | General ledger revenue: credit postings minus debit postings on revenue accounts (account 511), net of revenue deductions (account 521). Excludes financial income and other income. | Currency |
| Gross profit | Booked revenue minus cost of goods sold.= Booked revenue - Cost of goods sold (ledger) | Currency |
| Selling and administrative expenses | Debit postings minus credit postings on selling expense (account 641) and general administrative expense (account 642) accounts; under Circular 133 these are accounts 6421, 6422. | Currency |
| Operating profit | Gross profit minus selling and administrative expenses. Excludes financial income and expenses and other income and expenses.= Booked revenue - Cost of goods sold (ledger) - Selling and administrative expenses | Currency |
| Credit sales | Total value of credit sales invoices (creating accounts receivable) by invoice date. | Currency |
| Receivables collected | Total value of receivable invoices collected, by collection date. | Currency |
| Overdue receivables | Total value of invoices due in the period that remain uncollected as of the data date. | Currency |
| Average days to collect | Average days from invoice date to collection date for invoices collected in the period.= fin_collect_days_total / fin_ar_collected_count | Number |
| Vendor payments | Total value of payable invoices paid, by payment date. | Currency |
| Purchase order value | Total ordered value (ordered quantity times unit price) of purchase orders placed in the period, excluding cancelled orders. | Currency |
Connect Zoho Books in 3 steps
- 1
Create an OAuth client
In the Zoho API Console, create a Self Client, generate a refresh token with Zoho Books read scope, and copy the client ID and client secret.
- 2
Add the source
In the workspace choose Add source, find Zoho Books in the connector library, choose the data region, enter the client ID, client secret, refresh token and start date, then click Test connection.
- 3
Choose streams and review
Pick invoices, customer payments, bills and expenses (loaded incrementally); Si proposes a mapping to the accounting model, and you approve before the build.
Limits and caveats
- This is a community connector from the Airbyte library (ELv2 license) run inside DataxLand; test on a short date range first.
- Choose the Zoho data region your account is in; with the wrong region, Test connection reports an authentication error.
- DataxLand does not run the Zoho sign-in for you; you paste the Self Client refresh token.
Frequently asked questions
Does DataxLand write to Zoho Books?
No. DataxLand only reads data.
Can I use Zoho Inventory or Zoho CRM?
They have their own connectors in the library; each Zoho product is a separate source.
How fresh is the data?
It follows the workspace refresh schedule; streams with an update timestamp load incrementally.
Dashboard templates that use this source
Connect Zoho Books and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes