Skip to main content
Home
The Online Resource for Modern FP&A Professionals
Please register to receive the latest FP&A news, updates and tips Login

Main menu

  • Home
  • FP&A Insights
    • FP&A Trends Digest
    • FP&A Trends Research
    • FP&A Trends Insight Paper
    • FP&A Trends Survey
    • Short Videos
    • Our Contributors
  • FP&A Events
    • International FP&A Board
    • FP&A Trends Webinars
    • Digital FP&A Circles
  • AI/ML Committee
    • Introduction
    • Members
    • Resources
    • Meetings
  • FP&A Tools
    • FP&A Trends Maturity Model
  • About Us
    • Company Policy
    • Privacy Policy
    • Editorial Guidelines
    • Our Ambassadors
    • Our Sponsors & Partners
    • Contact Us
image
3 Vital Tips for a Better Reporting System
January 7, 2020

By Irina Steenbeek, Founder of 'Data Crossroads'

FP&A Tags
Data-Driven FP&A
Data Visualisation

After discussing the importance of data in your daily business planning activities and your main questions about the ‘right’ data, you are ready to take steps ahead in managing your data properly.

‘Getting the right data to the right people at the right place and time’ is the essence of the whole concept of data management. You can plan big steps for the long-term while making small steps to improve the situation in the short-term perspective.

Take big steps in improving data management in the whole company

Finance and business planning top professionals are probably the most powerful and influential data stakeholders. The situation with data in your company can be improved by setting up a proper data management framework.

You can find a brief overview in my book The Data Management Cookbook. I did my first implementation of data management framework working in a finance and control department. The main job - building this framework still needs to be done by dedicated professionals, but finance executives can decide to place the data management function under your responsibilities. There are a few things that you can start doing right now.

Small steps towards report optimization

Very often information is still delivered in the form of reports, either on paper or in digital format. I knew specialists from companies that produced between 200 and 11000 reports. Do you know how many reports circulate in your company?

Once, doing an analysis of existing reports in one large company, I discovered that only 40 % of reports were extracted from application databases. These reports were serving as a foundation for the rest of the 60% of Excel reports. 

There are several challenges I would associate with this situation:

  • high operational risk due to a huge amount of manual work and possibilities to make errors;
  • low efficiency of work as too much time spent on data collection and validation, reconciliation, manual operations, error correction.

So where do you start when you want to start optimizing your reporting flow? We believe that the following 3 steps will help you make your life a bit easier:

1. Create a catalogue of your reports. 

Depending on your company’s size it might take several weeks or even months. Be prepared: the number of reports can astonish you, we can be talking hundreds, thousands, maybe even more.

When you create a list of your reports, make an additional analysis of frequency, report owners and recipients, and the format of the reports. Consider that some reports might be simple, while others will include dozens of sheets. Even such a simple overview of the existing reports might already highlight some duplicates in information delivery. For example, I remember one situation, where finance, risk and commercial departments delivered similar information on customers to the same stakeholder. And the worst thing was that their information did not match! 

You can continue with further analysis by choosing several most important reports.

2. Describe the report flow for the most important reports.

Under ‘report flow’ I mean links between reports, the way one report delivers information to the next one, etc. Such a flow can become another Pandora’s box. Once I was documenting a report flow for one report and this flow turned out to be a closed-loop. A report was delivering information to itself through a series of other reports.

Such an analysis is an important step that provides possibilities for further optimization and minimization of reports.

3. Discover the most critical data elements in your reports.

Each report might include a huge number of metrics, KPIs, information elements. There are only a few that really bring value to the readers. Concentrate only on the most significant ones. Continue your adventure on data improvement with this limited scope. 

Hopefully, you now know what steps you can take towards managing your data properly in long- and short-term perspective. The long-term perspective requires efforts of the whole company to set up a data management framework. In a short-term perspective, you are able to enhance information delivery by optimizing a number of reports and KPIs.

Notes

[1] The DAMA Dictionary of Data Management, 2nd Edition 2011, p.78.

[2] ‘Defining the Evolution of FP&A: Benchmarks, Challenges and Opportunities‘, by Prophix and FP&A Trends, p.12.
 

The article was first published in Unit 4 Prevero Blog

The full text is available for registered users. Please register to view the rest of the article.
  • Log In
  • or
  • Register

Related articles

Why All FP&A Roads Go to Data Management
October 25, 2018

Even if last six years I have been specialized in Data management,  I still follow (thanks...

Read more
3 Reasons Why Data Driven Businesses Win
September 22, 2017

We live in a modern, technological world where data, or more accurately insights from data, can...

Read more
Address the 6 Key Challenges in Creating Value from Your Data
September 19, 2017

To create value from data, you do need a big data strategy – right? Well, actually...

Read more
+

Subscribe to
FP&A Trends Digest

We will regularly update you on the latest trends and developments in FP&A. Take the opportunity to have articles written by finance thought leaders delivered directly to your inbox; watch compelling webinars; connect with like-minded professionals; and become a part of our global community.

Create new account

image

Event Calendar

Pagination

  • Previous
  • June 2025
  • Next
Su Mo Tu We Th Fr Sa
1
2
3
4
5
6
7
The Unseen Cultural Shifts: Practical AI Case Study
 
Data Mastery in FP&A: Sharper Analytics, Smarter Decisions
 
8
9
10
11
12
13
14
Making FP&A Teams Fit for the Future
 
15
16
17
18
19
20
21
From Insight to Impact: FP&A Business Partnering in Action
 
Unlocking FP&A Analytical Transformation
 
22
23
24
25
26
27
28
Transforming FP&A with AI: Maturity, Impact, and Future Roles
 
Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments
 
29
30
1
2
3
4
5
 
 
 
 
 
All events for the year

Future Meetings

The Face-to-Face New York FP&A Board
The Face-to-Face New York FP&A Board From Insight to Impact: FP&A Business Partnering in Action

June 17, 2025

FP&A Trends Webinar Practical Steps for FP&A Analytical Transformation.
The FP&A Trends Webinar Unlocking FP&A Analytical Transformation

June 18, 2025

The FP&A Trends Webinar How AI is shaping the future of Financial Planning & Analysis (FP&A)
The FP&A Trends Webinar Transforming FP&A with AI: Maturity, Impact, and Future Roles

June 25, 2025

The Face-to-Face Sydney FP&A Board
The Face-to-Face Sydney FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments

June 26, 2025

The Face-to-Face Singapore FP&A Board: Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments
The Face-to-Face Singapore FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments

July 8, 2025

Webinar: FP&A Trends Survey 2025
The FP&A Trends Webinar 2025 FP&A Trends Survey: Benchmarks, Priorities, and Best Practices

July 9, 2025

Face-to-Face Oslo FP&A Board
The Launch of the Face-to-Face Oslo FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments

September 16, 2025

AI/ML FP&A
AI/ML FP&A
Data and Analytics
Data & Analytics
FP&A Case Studies
FP&A Case Studies
FP&A Research
FP&A Research
General
General
Integrated FP&A
Integrated FP&A
People and Culture
People and Culture
Process
Process
Technology
Technology

Please register to receive the latest FP&A news, updates and tips.

info@fpa-trends.com​

              

Foot menu

  • FP&A Insights
  • FP&A Board
  • FP&A Videos

Footer countries

  • Amsterdam
  • Austin
  • Boston
  • Brisbane
  • Brussels
  • Chicago
  • Copenhagen
  • Dubai
  • Frankfurt
  • Geneva
  • Helsinki
  • Hong Kong
  • Houston
  • Kuala Lumpur
  • London Board
  • London (Circle)
  • Melbourne
  • Miami
  • Milan
  • Munich
  • New York
  • Paris
  • Perth
  • Riyadh
  • San Francisco
  • Seattle
  • Shanghai
  • Singapore
  • Stockholm
  • Sydney
  • Tokyo
  • Toronto
  • Washington D.C.
  • Zurich

Copyright © 2025 fpa-trends.com. All rights reserved.

0