Report Inconsistencies are Frustrating

One of the biggest frustrations found in most credit unions is the numbers between two or more departments don’t jive. The conversation almost always leans toward trying to figure out which data set is correct, which one to believe.

The ultimate goal for these organizations is to find that elusive “one source of truth.”

So, why don’t our numbers balance between reports?

When we talk with credit unions, we find they have different definitions for common data terms and fields. Anytime the definition varies the count of that field will also vary. Having one consistent definition for these common terms is essential to getting to one source of truth. Establishing one common definition is complicated by the reality that different third-party software systems often use different definitions for these common terms. To get to one common definition will require a process to “normalize” the extracts from each of these systems and this is best done during the implementation and integration process.

To achieve consistent numbers the data must be reporting at the same time and date stamp. Any variation in the time stamp will result in data inconsistencies. This is often complicated when different systems generate updates and append the data at different times. The way to standardize this is to collect the data with the same timestamp. This may be impossible with some systems, so reporting the time stamps of each data source will help management understand the reason for the data inconsistencies.

Query Logic
We all know statistics can be used to tell lies as well as truth. The easiest way to manipulate data is to change the query logic. Often, query logic is a primary cause of report imbalances. Standardizing the queries on common reports can mitigate the risk of queries being used to “abridge” the story. To help management understand the differences in reports, a footnote with any query logic variances should be noted.

Getting to “one source of truth” should be an objective of any data strategy. But, like most strategies, this does not happen overnight and it is not an objective that can be solved with a software program. It takes a dedicated effort to find uniformity in queries, definitions, and report timing.

To research a virtual Data Governance Course, follow this link:


Rich Jones is the Founder/Principal of Leading2Leadership LLC. Before starting his strategic planning agency, he spent over 20 years in leadership roles in the financial services sector. Before becoming an executive in the financial services sector, Rich was an entrepreneur, building and selling two businesses and working for early-stage start-up companies in executive roles in marketing, business development, and seeking investment partners. With more than three decades of experience, he brings innovative thought to companies and executives. Rich published “Leading2Leadership, a Situational Primer to Leadership Excellence.” The book is available on and was designed to be used as a book study for leadership development programs; it breaks leadership skills into manageable situations for discussion and reflection. Rich works with credit unions, CUSOs, and vendors, designing digital, data, culture, marketing, and branding transformation strategies. In 2014, Chosen as a Credit Union Rock Star by CU Magazine, and in 2018, Rich received the Lifetime Achievement Award from CUNA Marketing and Business Development Council. A Marine and graduate of Colorado State University, Jones shares his expertise at

Leave a Comment