Twinfield connector · Bookkeeping
Twinfield connector for Power BI and Excel
Use DigiData as your Twinfield connector for Power BI, Excel, and AI. Connect selected offices through OAuth2 and automatically sync transactions, relations, ledger accounts, projects, cost centers, and VAT codes through OData.
Here you will find the supported data, operation and availability of the connection. Follow the practical guide Twinfield Power BI setup guide for the steps in Power BI.
Want to learn DigiData on your Twinfield data? Take the Twinfield training: build dashboards, automate reports and work with the AI agent in one day.
Last reviewed:
The reason
Why connect Twinfield to DigiData?
DigiData connects Twinfield through OAuth2 and synchronizes the offices you select. The Twinfield connector provides structured tables for transaction headers, transaction lines, debtors, creditors, general ledger accounts, cost centers, projects, offices, and VAT codes. Use the same synchronized data through a stable OData feed in Power BI and Excel, as a CSV export, or for AI analysis within DigiData. Build financial dashboards across multiple offices without manual exports or custom API scripts.
Connecting Twinfield to Power BI in short
The Twinfield connector is available and synchronizes supported tables such as Transaction Headers, Transaction lines (Lines), Transaction types and Customers (Debtors). DigiData offers these source records via OData for Power BI and Excel and via CSV for separate exports. The connector only supplies the entities listed on this page; source permissions, the source API, and your sync schedule determine which records and updates are available. You set up relationships, calculations and dashboards in the reporting tool.
Twinfield connector for finance, Excel and Power Query
The Twinfield connector synchronizes financial entities per selected office. Power BI and Excel read the same OData tables for recurring reports and checks.
Twinfield offices and transactions
Select the Twinfield offices and work with transaction headers, transaction lines, debtors, creditors and general ledger accounts.
Twinfield Power Query and Excel
Load the same OData tables into Power Query, Power BI, or Excel without manual XML or CSV exports.
Consolidation and checks
Use office codes as a stable dimension, schedule report refresh after synchronization, and reconcile totals by office and period.
Twinfield product information and guides
This product page lists which Twinfield data DigiData synchronizes and how the OData connection works. Use the guides below for setting up Power BI, working with Power Query and comparing different connection methods.
Conditions
Availability, setup and conditions
- Availability
- Status: Available. The connector provides the entities listed on this page under "Available data".
- Setup
- Via a secure OAuth2 connection. You log in to Twinfield, authorize DigiData and select the offices you want to synchronize. No passwords are stored.
- Refresh
- Automatic synchronization based on the integration schedule. New source data will not appear until the source sync and then the Power BI refresh are complete.
- Security
- Secure OAuth2 connection via Twinfield OpenID Connect
- Limitations
- Only the listed entities are supported. Availability and timeliness depend in part on the source API and your rights in Twinfield. DigiData supplies source data via OData and CSV; you set up relationships, measures and dashboards in the reporting tool.
- Price and trial period
- €50 per month for the Twinfield connector, plus a €95 monthly DigiData platform fee, without start-up costs. You can test DigiData 14 days for free. View current prices.
What you get
What do you get with the Twinfield link?
An overview of what DigiData does with your Twinfield data:
Which data
Available Twinfield data in DigiData
The following entities are automatically synchronized and available via OData or CSV export:
Use cases
What can you do with Twinfield data?
Multi-office reporting across multiple Twinfield administrations in one dashboard
Detailed VAT reports for all offices
Cash flow analyses with transaction data in Power BI
Comparison of project budgets with actual costs
How it works
How does the Twinfield link work?
Connect Twinfield
Link your Twinfield account via the DigiData dashboard. Safe and fast.
Select your dates
Check which accounts, environments, and entities are available for this resource. The options differ per connector.
Analyze in Power BI
Use the OData feed in Power BI, Excel or download CSV exports.
Twinfield in Power BI
Load Twinfield transactions, debtors, creditors, general ledger accounts, projects, and VAT codes into Power BI with the DigiData OData feed. Combine selected offices in a clean multi-office reporting model and schedule report refresh after DigiData synchronization.
Using Twinfield data with DigiData AI or Claude
The same pre-synchronized Twinfield tables can be analyzed within DigiData AI or bounded per connection to an external MCP client. The administrator chooses the allowed sources, tables and columns.
Using Twinfield with Claude via read-only MCP
Practical explanation for a limited Twinfield dataset in Claude.
Link Claude to company data
Plan conditions, connector steps, verification prompt, and troubleshooting.
Security of DigiData MCP
OAuth, tenant isolation, data minimization, audit and external processing.
Frequently asked questions
Questions about the Twinfield integration
How do I connect Twinfield to Power BI?
With DigiData you automatically synchronize Twinfield data to an OData feed. In Power BI Desktop, choose 'Get Data', select OData feed and paste the DigiData URL. You can then load, combine and refresh the tables without building a Twinfield API connection yourself.
How often is Twinfield data refreshed?
DigiData synchronizes Twinfield according to your integration schedule. The exact frequency and availability of new records depend on your settings and the source API.
What does the Twinfield connection cost?
DigiData charges platform costs plus an amount per active integration. There are no start-up costs and you can test for 14 days for free. View the current price on the prices page.
How do I report across Twinfield offices?
Load transaction lines, ledger accounts and offices through OData. Keep office identifiers in your keys and align currencies and account mappings. Fictional example: €100,000 revenue in office A and €80,000 in B totals €180,000 before eliminations. Filter by office or compare matching periods. DigiData supplies the source data; consolidation rules belong in your report model.
How do I connect Twinfield to DigiData?
Via a secure OAuth2 connection. You log in to Twinfield, authorize DigiData and select the offices you want to synchronize. No passwords are stored.
Can I link multiple Twinfield offices?
Yes, after connecting you can choose per office which data is synchronized to DigiData. Records include the corresponding office identifier for multi-administration dashboards.
Can DigiData sync PrestaShop or Magento with Twinfield?
No. DigiData reads data from Twinfield for reporting and AI analysis and does not write orders, invoices or journal entries back to Twinfield. To post web shop orders into Twinfield automatically, use an accounting integration from your web shop platform. You can, however, put Twinfield figures next to data from other connected sources in DigiData and compare them in one report or AI analysis.
Combine
Other integrations that may interest you
Most companies do not run on one package. Place Twinfield next to your other sources, so that you have one report.
14 days free · no start-up costs
Ready to connect Twinfield to DigiData?
Use the trial period to validate the available tables, synchronization and your reporting model with your own data.
