Finance and payments
Connect Xero to DataxLand
The Xero connector reads the chart of accounts, sales and purchase invoices, payments, bank transactions, credit notes, manual journals, contacts and items of your Xero organisation. Si maps the data to the finance and accounting model, giving booked revenue, cost of goods sold, gross profit and gross margin, operating expenses, operating profit, overdue receivables, average days to collect and payments to suppliers, with one definition on dashboards and in Si's answers.
Free plan with no time limit · No card required · Sample workspace ready in minutes
What you can do with Xero
- Monthly P&L and receivables reports without exporting files from Xero.
- Get a Telegram or Slack alert when overdue receivables cross a threshold.
- Put expenses from the books next to the budget you keep in Google Sheets.
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 |
|---|---|
| accounts | Chart of accounts. |
| invoices | Sales invoices (ACCREC) and bills (ACCPAY), due dates and balances outstanding. |
| payments | Payments linked to invoices. |
| bank_transactions | Bank receipts and spend. |
| credit_notes | Credit notes. |
| manual_journals | Manual journals. |
| contacts | Customers and suppliers (personal columns 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 | Authentication Method, Start Date, Tenant ID |
| 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 |
| Cost of goods sold (ledger) | Debit postings minus credit postings on the cost of goods sold account (account 632). | Currency |
| Gross profit | Booked revenue minus cost of goods sold.= Booked revenue - Cost of goods sold (ledger) | Currency |
| Gross margin % | Gross profit divided by booked revenue.= (Booked revenue - Cost of goods sold (ledger)) / Booked revenue | Ratio (%) |
| 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 |
Connect Xero in 3 steps
- 1
Create a Custom Connection
In Xero Developer, create a Custom Connection with read-only accounting scopes and authorise it for your organisation; copy the client ID, client secret and Tenant ID.
- 2
Add the source
In the workspace choose Add source, find Xero in the connector library, choose OAuth Custom Connection, enter the client ID, client secret, Tenant ID and start date, then click Test connection.
- 3
Choose streams and review
Pick accounts, invoices, payments and journals (loaded incrementally); Si proposes how to classify accounts, and you approve before the build.
Limits and caveats
- Custom Connections are a paid Xero feature in some countries; check your Xero subscription first.
- This is a community connector from the Airbyte library (ELv2 licence) run inside DataxLand.
- Classifying accounts is a step you approve; the numbers are only as right as the organisation's books.
Frequently asked questions
Does DataxLand write to Xero?
No. DataxLand only reads accounting data.
What about several Xero organisations?
Each organisation (Tenant ID) is a separate source and counts towards your plan's source limit.
Can I ask Si about receivables per customer?
Yes, within your permissions in the workspace; contacts' personal columns (email, phone) are hashed on load.
Dashboard templates that use this source
Connect Xero and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes