Yuki Power BI dashboard
We retrieve general ledger and transaction data from Yuki’s web services and use it to build a single Power BI model. For Athlon, we made data accessible for dashboards.
With accessible data and dashboards, Athlon’s asset management team could make data-driven decisions
For Athlon, we developed a solution that provides detailed insight into tyre usage across its fleet. Dedicated dashboards help the team spot irregularities in tyre wear and address them.
How can we compare figures from dozens of Yuki domains without opening them one by one?
Yuki provides the reports you know for each domain and accounting entity. To compare clients, consolidate a group or bring in budgets and other sources, you can pull the data through its web services into your own model.
We bring together the general ledger, transactions and business contacts from each Yuki domain in one model
General ledger and transactions
Accounts and entries for each set of accounts via the AccountingInfo web service, with a single chart of accounts that allows comparisons across domains.
Debtors and creditors
Outstanding balances and payment behaviour for each business contact, alongside the contact details Yuki records for each set of accounts.
By client or as a group
An accounting firm sees all its client domains side by side; a group sees its operating companies separately and together.
Data made accessible for dashboards
Just as we made data accessible for dashboards used by Athlon’s asset management team, we prepare Yuki data for Power BI.
First, keys and permissions for each domain; then the first report
-
Set up access
A web service key at the right level, set up by someone with the Portal administrator or Management role.
-
One domain validated
A first set of accounts in the model, with the balance for each account compared against the reports in Yuki.
-
Add more domains
Additional domains in the same model, a fixed refresh time and permissions for each client or company.
Are Yuki’s reports enough, or is our own Power BI model worth it?
A good fit if
Your firm manages many client domains and you want to compare them, you consolidate a group, or you want to view Yuki data alongside budgets, hours worked or data from another system.
Not a good fit if
You have one set of accounts and Yuki’s reports answer your questions. In that case, the work of managing your own model outweighs what it adds.
What determines the scope
The number of domains and sets of accounts, how different the charts of accounts are, which other sources you need to include and who will manage the model.
Is there a limit on the number of calls?
Yes. Yuki sets a daily limit on calls per domain, which a portal administrator can increase with an add-on. That’s why we only load what has changed.
Reports by domain, an Excel export or your own model built on web services?
Reports in Yuki
Choose this if you look at each client or set of accounts separately and the standard reports meet your needs. You won’t need a second place for your figures.
An Excel export
Choose this if you have a few sets of accounts and one person puts together the overview. Each new period will still require manual work.
A model built on web services
Choose this if you need to bring together many domains or sources. Our advice: use one shared chart of accounts and load only the changes.
We’ve been making parcel data accessible so teams can make decisions based on it for years
Data Science Lab has built data platforms, models and dashboards since 2016, as a Microsoft Partner and Databricks Partner. For Athlon, we made data accessible for the asset management team’s dashboards.

The first conversation starts with your Yuki domains and the reports you’re currently missing
Stef Stoelwinder
Business DevelopmentStef is your point of contact. In the first conversation, we’ll discuss how many domains you have in Yuki, who manages the web services and which reports you’re missing.
E-mail info@datasciencelab.nl
Phone +31 (0)20 3636 724
How many Yuki domains or sets of accounts would you like to see in one overview?
Tell us whether you use Yuki as an accounting firm or a company, and what other data sources you have. We’ll reply by email or arrange an initial conversation.
Message sent
Thanks for your message. We’ll be in touch as soon as possible.
Frequently asked questions
Through Yuki’s webservices. According to Yuki, these are SOAP webservices, each covering a different area: Accounting for financial reports, AccountingInfo for general ledger accounts and transactions, and others including Contact, Archive and Projects. A loading step retrieves the data, which we use to build the Yuki Power BI model.
To decide which questions a dashboard should answer first, read about Power BI dashboards.
With a webservice API key and an administration ID. Yuki grants access at portal, domain or administration level. Only a user with the Portal administrator or Management role can set the permissions, and the permissions in the domain or administration take precedence.
We request a key with access only to the webservices the model needs.
Each domain and administration has its own key in the model, so clients’ figures never get mixed up. We map accounts to one shared chart of accounts, allowing you to compare clients or group companies.
A portal-level key makes management easier, but also grants broader access. We weigh that trade-off with the firm.
Yuki provides a daily number of calls per domain, which a portal administrator can increase with an add-on. That is why, after the initial load, we retrieve only what has changed and spread the loading across domains.
This leaves capacity for other integrations that use the same domain.
Firms compare revenue, margins and costs across clients and see which clients deviate from the norm. Business owners and groups look at results by company, outstanding receivables, payables and performance against budget.
If you mainly want revenue, margins and cash flow for management, read about the financial dashboard in Power BI.
We manage this with row-level permissions in the model: a client or group company sees only its own figures, while the firm or holding company sees everything. Yuki’s own permissions also continue to apply to the webservices.
We set up refresh, the gateway and security as described under Power BI consultant.
Yes, with a different loading step. Read about the Twinfield Power BI dashboard or the Exact Online Power BI dashboard.
If a firm has clients using different software packages, their data goes into the same model with one chart of accounts.
When you have one administration and the reports in Yuki are sufficient. Or when clients’ charts of accounts differ so much that comparisons are meaningless: in that case, data quality is the first step.
If an export or the reports in Yuki are enough, we’ll say so.
What belongs alongside your Yuki figures in your firm or group model?
- Power BI dashboardsWhy every dashboard starts with the decision someone needs to make using it.
- Financial dashboard in Power BIRevenue, margin, cash flow and budget versus actuals, in one model for finance and management.
- Twinfield Power BI dashboardMultiple sets of accounts, by client or consolidated, for firms and groups.