Twinfield connector · Bookkeeping
Twinfield connector
The DigiData Twinfield connector synchronizes transactions, relationships, general ledger accounts, projects, cost centers and VAT codes from selected offices to OData and CSV.
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.
Last reviewed:
The reason
Why connect Twinfield to DigiData?
DigiData connects Twinfield via OAuth2 and lets you select the offices you want to synchronize. Transaction headers, transaction lines, debtors, creditors, general ledger accounts, cost centers, projects and VAT codes are presented as tables. OData is available for Power BI and Excel; CSV is available for individual exports. Webshop, payment provider and bank data outside Twinfield is not part of this connector.
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; webshop and banking sources are not part of this connector.
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.
Demarcation of the connector
Webshops such as Bol, PrestaShop, WooCommerce and Magento are not retrieved by the Twinfield connector. A separate source is required for this.
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
- From €145 per month for the platform and one Twinfield link, 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?
Consolidation of 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
Use the DigiData OData feed to load Twinfield transactions, debtors, creditors, general ledger accounts, projects and VAT codes into Power BI. Multiple selected offices can be processed in the same reporting model.
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 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.
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.
