FROM DATA TO INSIGHT

Financial expertise.Smart data solutions.Personal service.

Clearer insights. Less time searching through numbers. Lemmens Analytics & Dashboarding combines financial experience with practical data expertise. I help organisations with Power BI and support Dutch investment companies and other business investors with their investment administration, preparing comprehensive portfolio reports — including across multiple brokers.

Power BI & data Investment Administration
DEMO REPORTSAMPLE
Actual Dutch demo summary with portfolio value, performance, income, asset allocation and cash-flow bridge
DATA & ANALYTICSPOWER BI CONSULTANCYINVESTMENT ADMINISTRATION
POWER BI & INVESTMENT ADMINISTRATION

Useful insights, made practical.

From practical Power BI questions to the preparation of investment portfolio records. I combine financial experience with technical expertise to create something that is genuinely useful for you.

01 / DATA & BI

Power BI & consultancy

Have plenty of data but not the overview you need? I help with dashboards, data models and practical Power BI advice. My accountancy and financial advisory background makes financial information a natural fit, but I also work on data challenges in many other areas.

  • Power BI dashboards tailored to your questions
  • Connecting data sources and reducing repetitive work
  • Power Query, DAX and data modelling
  • Improving, extending and troubleshooting existing reports
DATA → INSIGHT
Discuss your Power BI needs
02 / SPECIALIST SERVICE

Investment Administration

For Dutch companies and other business investors: processing broker transactions and holdings, checking reconciliations and preparing investment reports with supporting tax schedules — including across several brokers.

  • Holdings and returns by account and on a consolidated basis
  • Dividends, interest, other income and withholding tax
  • Tax-oriented securities schedules, reconciliation and proposed journal entries
  • A complete full-year report or cumulative quarterly or monthly reports, with the final report covering the full year
See what a report looks like
SPECIALIST SERVICE

Professional investment administration and reporting.

Specialist securities administration for Dutch companies and other business investors, with verifiable holdings, performance, income and supporting tax schedules for every reporting period — including multiple brokerage accounts.

Discover Investment Administration ↗
  • Multiple brokers in one coherent view
  • Consistent periodic reports
  • Insight into holdings, returns and income
MULTIPLE BROKERS / ONE CONSOLIDATED VIEW

One coherent report, across multiple broker accounts.

Individual broker portals only show part of the picture. Lemmens Analytics & Dashboarding combines records from multiple brokers into a consolidated view of holdings, assets, performance and income. We place as much emphasis on transactions, completeness and reconciliations as on presentation.

Discuss your broker accounts
THE SERVICE

More than a dashboard: administration, verification and reporting.

Professional investment administration, financial reconciliations and periodic investment reports with supporting tax schedules for Dutch companies and other business investors.

01 / 04

Securities records & holdings

Processing and structuring broker transactions, positions and portfolio movements.

02 / 04

Performance & returns

Reports on investment results, returns and changes in portfolio value.

03 / 04

Income & withholding tax

Breakdowns of dividends, interest, other income and withholding tax.

04 / 04

Tax support & reconciliation

Securities schedules, potential tax treatment of investment results and accounting reconciliations to support accountants and tax advisers.

WHO I WORK WITH

Built for professional portfolio reporting needs.

For Dutch companies and other business investors with securities portfolios, and the professionals who support them.

01 / COMPANIES & BUSINESS INVESTORS

Companies and other business investors

For Dutch companies, foundations and other business investors with one or more brokerage accounts: verifiable securities records, performance insights and support for financial reporting.

Discuss your requirements
02 / ACCOUNTANTS & FAMILY OFFICES

Accountants & family offices

For accounting firms, administration offices and family offices supporting business clients. Clear records per client, with options for ongoing cooperation and — by arrangement — reporting under your own brand.

Discuss your requirements
03 / WEALTH ADVISERS

Investment & wealth advisers

For investment and wealth advisers who want to provide business clients with professional periodic reports on holdings, performance and income. White-label reporting can be discussed individually.

Discuss your requirements
SAMPLE REPORT

The details behind the numbers.

Explore sample investment reports, from consolidated holdings and performance to investment income, Dutch tax schedules and portfolio reconciliations.

Please note: the downloadable sample report is currently available in Dutch only. The tax-related information reflects the Dutch context and may not apply in other jurisdictions.

View the full PDF
DEMO HOLDING B.V. / SAMPLE REPORTPDF • DEMO
Summary of portfolio value, returns, income, allocation and performance (Dutch report)
EXAMPLES FROM THE DEMONSTRATION PORTFOLIOComplete report: 10 pages
WHY LEMMENS ANALYTICS & DASHBOARDING

Where financial insight meets Power BI technology.

Information needs to be technically correct as well as relevant to the decisions it supports. My background in accountancy and financial advisory work connects both perspectives.

01

Understanding the numbers

Looking beyond the request to definitions, logic and what the outcomes mean.

02

Reliable data

Attention to source data, checks, reconciliations and a maintainable data model.

03

Direct contact

Clear agreements, short lines of communication and a personal approach.

HOW IT WORKS

A clear approach, built around your needs.

A Power BI project follows a different process from investment portfolio processing and reporting. In both cases we agree the scope and expected deliverables in advance.

01 / DATA & BI

Power BI & consultancy

For new dashboards, improvements to existing reports and practical help with data-related questions.

  1. 01

    Discuss your goals

    We explore what you want to understand or improve and what a useful outcome would look like.

  2. 02

    Review data and scope

    I review the available sources, and we agree on the right solution or type of support.

  3. 03

    Develop and refine

    I build or improve your dashboard or data model. We review the results and refine them where needed.

  4. 04

    Deliver and support

    You receive a practical solution with an explanation. Any follow-up support is agreed together.

Discuss your Power BI needs
02 / INVESTMENT ADMINISTRATION

Investment Administration

For Dutch companies and other business investors with one or more investment accounts.

  1. 01

    Requirements and frequency

    We define the accounts, reporting periods and deliverables and agree the scope.

  2. 02

    Providing your account information

    You share statements from your broker(s), your investments and cash balances at the start, and what you paid for those investments. This helps us set up accurate records.

  3. 03

    Processing and checks

    I process transactions, holdings and income and investigate any material discrepancies or reconciliation items.

  4. 04

    Reports and explanation

    Depending on your package, you receive a complete full-year report or cumulative quarterly or monthly reports, including the standard analyses and supporting tax schedules. The final report covers the full financial year and is delivered after the annual broker statements have been checked.

More about Investment Administration

Reporting frequency and the number of investment accounts determine the fixed annual price. Standard setup of the investment administration is included when all required opening records are provided.

ABOUT LEMMENS ANALYTICS & DASHBOARDING

Financial background.
Technical expertise.
Personal contact.

My background combines many years of accountancy, tax and financial advisory work with Power BI, data analysis and processing investment data. This combination forms the basis for specialist, verifiable financial reporting with direct personal contact.

You deal directly with me, from our first conversation through to the finished work. I believe a solution should not only be technically sound but also practical, understandable and useful for the person working with it.

Let’s talk
LEMMENS ANALYTICS & DASHBOARDING

Looking for a clearer picture?

Looking to develop or improve a Power BI solution? Or do you need professional investment administration and reporting for your company, foundation or other business organisation? Tell me a little about your needs and we can explore the right approach.

Prefer to email directly? info@lemmens.eu

Your details are sent via Formspree so I can respond to your enquiry. Please do not include confidential financial information or broker files. Read the privacy statement (in Dutch).