Month-end finance
Revenue and expenses by month, net P&L movement, balance-sheet sections and account-level Trial Balance summaries.
Xero API reporting
Prepare Xero data for finance dashboards and Power BI—locally
Authorise a Xero organisation, pull reporting data through the Windows app, then use documented finance grains for local dashboards or BI-ready exports.
Choose the grain first
Xero reporting tables matched to the finance question
Datplan keeps invoice, payment and accounting-summary views separate so each report uses the right measure for the question being asked.
| Reporting grain | One row represents | Use it for | Do not use it for |
|---|---|---|---|
| Financial Summary | One Trial Balance-derived account and reporting-date summary | P&L, balance sheet, revenue, expenses and month-end account movement | Customer, item, invoice or payment drill-down |
| Financial Activity | One reconstructed accounting activity line | Account movement, source type, line role and tracking analysis | Reported P&L or balance-sheet totals |
| Invoice Summary | One live invoice or bill | Totals, due dates, paid amounts, outstanding balances and contact value | P&L or balance-sheet reporting |
| Invoice Lines | One live invoice or bill line | Item, product, tracking, net, tax and gross analysis | Ageing or payment settlement |
| Payments | One authorised payment | Receipts, supplier payments, settlement timing and payment accounts | Revenue or expense recognition |
First-hand product evidence
Choose the Xero organisation, then review the completed pull
Datplan keeps the connection choice and endpoint result visible so the reporting dataset is not treated as a black box.
Reporting examples
Questions Datplan prepares Xero data to answer
Invoice and debtor review
Sales invoices by month, outstanding value by due month, customer totals, supplier bill analysis and paid versus outstanding amounts.
Product and tracking analysis
Sales by item, invoice-line net value, tax and gross amounts, tracking option 1 and tracking option 2.
Payment timing
Receipts and supplier payments by date, account and contact without treating settlement movement as recognised revenue.
Xero Audit Analytics
Apply seven repeatable audit analyses and inspect the records behind each result
Review Benford patterns, exceptional and round values, period-end activity, possible duplicates, post-period reversals and rare high-value counterparties using the same conceptual test set as QuickBooks.
Local Xero reporting
Keep the last successful reporting dataset available on the Windows PC
Use it for dashboards, Excel analysis and prepared BI files without routing the source dataset through a Datplan reporting warehouse.
Offline dashboard access
Open saved Datplan dashboards from the latest successful local sync. New Xero data still requires an online refresh.
Understand offline reporting →Scheduled refreshes
On supported plans, schedule the selected workspace, source and organisation once, daily, weekly or monthly and write exports to a stable folder.
Schedule Xero exports →Independent reporting copy
Keep authorised reporting data and user-created exports locally for analysis, reconciliation and continuity. A reporting copy is separate from a tested restore backup.
Compare copy and backup →What “Xero to a local database” means here: Xero remains the cloud system of record. Datplan does not connect to or expose Xero's private backend database. After authorisation, the Windows app requests supported data through Xero's public API and stores the resulting reporting copy in local app data. That database supports the Datplan workflow; it is not a real-time mirror, complete restore backup or supported general-purpose SQL, ODBC or DirectQuery endpoint.
Xero data warehouse
Need a prepared Xero accounting data warehouse?
Datplan can build the reporting layer in your Windows environment: separate financial-summary, activity, invoice, line and payment grains, with validation and reporting exports. The output can remain local or be deliberately published to a location you control.
This is a prepared reporting warehouse, not a Datplan-hosted SQL/ODBC/DirectQuery service. See how the Xero reporting warehouse is structured →
Xero source plans
Choose capacity for the reporting workload
Purchase inside the signed-in app. The free download and demo do not require a Xero plan.
Xero Solo
£49/month
£530/year when billed annually
- 250 MB/month
- 5/day pull credits
- 1 connected client
- 5 dashboards
- Scheduler: No
- CSV, JSON, Fact + Dim star-schema
Most flexible start
Xero Growth
£89/month
£965/year when billed annually
- 1 GB/month
- 15/day pull credits
- 3 connected clients
- 15 dashboards
- Scheduler: Yes
- CSV, JSON, Fact + Dim star-schema
Xero Pro
£179/month
£1,935/year when billed annually
- 2 GB/month
- 50/day pull credits
- 10 connected clients
- 50 dashboards
- Scheduler: Yes
- CSV, JSON, Fact + Dim star-schema
Xero Heavy
£399/month
£4,310/year when billed annually
- 5 GB/month
- 150/day pull credits
- 50 connected clients
- 250 dashboards
- Scheduler: Yes
- CSV, JSON, Fact + Dim star-schema
| Plan | Monthly | Annual | Allowance | Pulls | Clients | Dashboards | Scheduler |
|---|---|---|---|---|---|---|---|
| Xero Solo | £49/month | £530/year | 250 MB/month | 5/day | 1 | 5 | No |
| Xero Growth | £89/month | £965/year | 1 GB/month | 15/day | 3 | 15 | Yes |
| Xero Pro | £179/month | £1,935/year | 2 GB/month | 50/day | 10 | 50 | Yes |
| Xero Heavy | £399/month | £4,310/year | 5 GB/month | 150/day | 50 | 250 | Yes |
Datplan is not currently VAT registered, so no VAT is added to the prices shown. Prices and allowances shown in the signed-in app apply at purchase. Allowances do not roll over. Provider API limits and activity from other integrations can also affect available pulls. Xero supports full and incremental sync; incremental behaviour follows supported endpoints and remains subject to the current source catalogue, permissions and Xero API limits.
Xero questions
Know the data and plan boundaries
Is Xero live-source access included with the free app?
No. The app and Datplan Demo are free. Choose and purchase a Xero source plan inside Datplan DataPull when you are ready to connect a live account.
Do unused allowances roll over?
No. Monthly data allowances and daily pull credits do not roll over.
Can provider limits stop a pull?
Yes. Datplan allowances remain subject to provider API limits, source permissions, service availability and quota already consumed by other apps, integrations or users.
Does Xero support incremental sync in Datplan?
Yes. Xero supports full and incremental sync. Incremental behaviour follows supported Xero endpoints and remains subject to Datplan allowances, Xero API limits, permissions and service availability.
Can I use Xero data in Power BI?
Yes. Datplan can export stable local files, fact-and-dimension tables and BI setup guidance for Power BI. The initial model setup is manual; Datplan is not a native real-time Power BI connector.
Can I view my last synced Xero reporting dashboard offline?
Yes. Once a successful Xero sync has prepared the local reporting data, saved Datplan dashboards can be opened without an internet connection. Internet access is required to connect or reauthorise Xero and retrieve newer data.
Is the local Xero reporting copy a complete Xero backup?
No. It is an independent local reporting dataset and export workflow for analysis, continuity and BI use. A full Xero restore backup requires broader source coverage and a tested recovery process.
Does Xero provide a local database that Datplan connects to?
No. Xero remains cloud-hosted, and Datplan does not access Xero's private backend database. After the user authorises an organisation, Datplan requests supported records and reports through Xero's public API and stores the resulting reporting copy in the Windows app's local data.
Can reporting tools query Datplan's local Xero data through SQL or ODBC?
Not through a supported Datplan SQL, ODBC or DirectQuery interface. The local app database supports Datplan's desktop workflow. Power BI and other downstream tools should use the prepared CSV, JSON and fact-and-dimension exports.
See Datplan with real reporting data—without connecting a live account
The Windows app is free to download and includes Datplan Demo data, so you can test sync, dashboards, reporting grains and exports first.