5 Problems Solved by a Common Database

Firms that use integrated technology have reported being able to serve more clients, requiring fewer staff, or needing less time to complete a return. The accounting profession has long recognized that technology can have positive effects on the bottom line of accounting firms. However, some so-called “integrated” technology is actually not as integrated as many people believe.

Point-to-point integration relies on syncing multiple databases, which  means firms still have multiple sources of data. These multiple data sources increase the likelihood of duplicate, inconsistent and out-of-date information.

On the other hand, having a single database for client and staff data can provide efficiencies throughout your firm. With a common database, data is more accessible and you can more easily add new functionality. In addition, your total cost of ownership will also be lower.

A common database solves a number of problems in a firm, including:

Redundant data entry

Point-to-point integration usually involves entering the same information into different applications. Conversely, a system with a common database stores client and staff data in a central location. Multiple modules access the same data instead of maintaining their own versions of the data. This way, staff doesn’t need to enter information multiple times, and the information in the system is more accurate.

Immobile work environment

Traditionally integrated systems typically require firms to install all software on the same servers, usually in the office. That means staff needs to perform most of the work in the office as well.  Centralized data in a common database is more easily accessible from anywhere, so firms can more easily offer mobile and flexible work arrangements.

Limited options

Because point-to-point software typically needs to be installed on the same server, integrating with third parties is difficult or impossible. Since common data is more accessible, third-party integrations are straightforward and reliable. More open systems give firms more choices for adding functionality to the system.

Fragmented view of the firm

When data is spread throughout many different systems, it’s difficult to get a complete picture of your client relationships. Transitioning to a client-centric model is difficult because you don’t have a client-centric system. When data is centralized in a common database, you can provide the kind of service your clients expect because their information is at the center of your entire system.

High cost of ownership

Point-to-point integration often requires a firm to continue investing more and unpredictable amounts of money into the system with each passing year. Consulting costs to fix integration problems or maintain out of date software and expensive infrastructure costs like bigger and faster servers can wreak havoc on a firm’s budget. On the other hand, a system with a common database, based in the cloud, boasts a steady and predictable cost of ownership.

Firms with truly integrated solutions have fewer struggles with data entry, fewer client communication issues, and better client service. See the infographic. 


Wolters Kluwer Tax and Accounting

Wolters Kluwer Tax and Accounting is a leading provider of software solutions and local expertise that helps tax, accounting, and audit professionals research and navigate complex regulations, comply with legislation, manage their businesses and advise clients with speed, accuracy and efficiency. Wolters Kluwer Tax and Accounting is part of Wolters Kluwer N.V. (AEX: WKL), a global leader in information services and solutions for professionals in the health, tax and accounting, risk and compliance, finance and legal sectors. We help our customers make critical decisions every day by providing expert solutions that combine deep domain knowledge with specialized technology and services. Wolters Kluwer reported 2016 annual revenues of €4.3 billion. The company, headquartered in Alphen aan den Rijn, the Netherlands, serves customers in over 180 countries, maintains operations in over 40 countries and employs 19,000 people worldwide. Wolters Kluwer shares are listed on Euronext Amsterdam (WKL) and are included in the AEX and Euronext 100 indices. Wolters Kluwer has a sponsored Level 1 American Depositary Receipt program. The ADRs are traded on the over-the-counter market in the U.S. (WTKWY).

All stories by: Wolters Kluwer Tax and Accounting

Leave a Reply

Your email address will not be published.