Data Analysis in Accountancy - Victa Business Intelligence
2
news on
LinkedIn
Open the menu
close the menu
More information about Accountancy in BI?
We are happy to help you with questions and information about Accountancy in BI. Fill in the questions below and we will be happy to answer them. Our Business Intelligence experts are happy to help you.
I am happy to help you
If you would like a personal conversation about Accountancy in the BI, you can call 074 - 2915208.

Anne-Mechteld Ulkeman
Account Manager
074 – 2915208
au@victa.nl
Please contact Anne-Mechteld Ulkeman
Request advice from Victa information
Webinar - BI Trends in Accountancy (April 14, 2020)
During this Webinar we will update you on the digital transformation of the accountancy firm. An interesting insight into how you as an accountant can use various analysis tools to expand the services and create new insights for the customer.
Small to medium-sized accounting firms
For this category of accountancy firms, it is of primary importance to keep investments in digitization to a minimum, but to further optimize the returns. These offices are mainly located in Horizon 1.
  • Data is fragmented in the organization and stored in different applications. BI tooling is used to report on this, which ensures that data from different applications is brought together in BI dashboards (visualization).
  • Due to the frequent use of Excel within accountancy organizations, Microsoft Power BI as a visualization tool has great adoption capacity. This, in combination with the low purchase costs (often already part of the purchased Office365 suite) and the high self-service character, makes it a good fit for offices in this category.
Medium to large accounting firms
For this category of accountancy firms, aspects of digitization at a central level play a major role. These offices are usually located in Horizon 2.
  • Employees must be data literate, that is, be provided with data that must be analyzed by the customer owner, with the aim of helping the office's customer make better decisions now and in the future. But it goes much further than that in this category of offices.
  • Clear objectives must be formulated for the technological solutions that are chosen. Short-term profit is important, but long-term value creation should not be forgotten. Investment and innovation must go hand in hand at a strategic level.
"Interested in the accountancy industry?"
Contact us
Artificial Intelligence / Machine Learning
Artificial Intelligence / Machine Learning
It is then no longer just about bringing data together and visualizing it, but also about data storage, data management, data connectivity, big data, advanced data analytics and Artificial Intelligence / Machine Learning.

Data must be brought to the information layer in the broadest sense of the word in order to make better data-driven decisions for both the internal and external playing field. And of course, all of this must be done centrally, in a coordinated, safe and manageable manner within the applicable laws and regulations.

To achieve this, it is important to think about information strategy and provision. Who should have what information available at what time and for what purpose? This is of course accompanied by the right IT strategy and IT system choice and a solid data management strategy.
Interesting KPIs in the accountancy industry
Divided into different levels, such as financial, productivity and quality, relationship management, new business, personnel & organization, and marketing.
Financial
  • Number of customer groups (families, shareholders, managers / decision makers)
  • Percentage of customers with recurring revenues (hourly * rate) versus transactional revenues (subscription)
  • Customer value (expected duration of relationship with expected financial value)
  • Customer revenue (revenue versus costs incurred for a customer in a specific period, revenue by segment, revenue by department, etc.)
  • Turnover per period compared to the same period in previous years
  • Turnover per employee (productivity)
  • Outstanding items (parental sum analysis / periodicity / debtor assessment, etc.)
  • Profit & Loss analysis

Productivity
  • Employee-customer ratio
  • Burners & urners, billable / non-billable hours including accrual
  • Average number of consultancy hours or annual accounts per customer, employee
  • Average processing time for receipts and invoices
  • Turnover by function
  • Hours per work type and work types per hour category
  • Under Hands Work (WIP) age, mutations, etc.
  • Top customers based on invoiced turnover
  • Progress overview

Quality
  • Relationship production activities / consultancy activities
  • Ratio of automated entries versus manual entries
Relationship Management
  • Number of contact moments per year per type
  • Customer satisfaction (Net Promotor Score)
  • Cross selling / Client share
  • Churn

New Business
  • Number of new customers per period, relationship manager, etc.
  • Conversion rate from leads, quotation, etc.
  • Lead analysis

Staff and organization
  • Number of employees and distribution of gender, age, contract hours, years of service, position, etc.
  • Default
  • Employee mobility (new, retired, advanced employees)
  • Employee card

Marketing
  • Top branches divided by turnover and number of clients
  • Client mobility
  • Client and their network
  • Clients by office, province, city, etc.
  • Client size and priority
  • Product portfolio
  • Detailed geographic information
  • The number of newsletters that are opened, click-rate and click-through rate
  • Website: number of unique visitors, average time on the website and conversion rate
  • Penetration rate product line
Frequently used data sources in the accountancy industry
AE
account view
ADP
afas
Akkermans & Partners
Asperion
BCS
CaseWare IDEA
Cash
cashr
Change to Comm
Comm'ant
davilex
The pass
DGA
Digital Office
easyflex
E-Accounting
Effect
Effective
Exactly (online)
Expansion
FP
faqto
fenna
Fiscus.nl
Gecko
gravitas
Infinev Infor
InvoiceHippo
KBinfo.nl
KingSoftware
Clay stone
Loon
Meijer Tax Advice Systems
Minox
moneybird
MoneyMonk
Mouse Software
MyFinance
number
official
Plotter
ProManagement
QY
Qics
Radar
Reed Business
Reeleezee
Rodeo
rompslomp.nl
Silvasoft
SmileSoftware
QuickStart
Dot-T
technology
Tellow
Thinq
Thomson Reuters
TimeWriter
Twinfield
Unit 4
Visma
vixum
yoursminc
Yuki
Download Victa advice

Advice Victa

Would you like more information about the possibilities of Advice Victa? Download the free Advice Victa whitepaper now and get started right away.
Download the Victa whitepaper advice
Advice Victa
You can view the free Advice Victa PDF file, using the Adobe Acrobat Reader DC program. This program is free to download and suitable for Windows and Mac. This is the only PDF viewer that allows you to open and edit all types of PDF content, including forms and multimedia.
Download Advice Victa
Qlik Elite Solutions Provider
Victa is an experienced and certified Qlik Elite Solution Provider. We offer you a complete range of Qlik professional services: Qlik-software, Qlik Cloud Hosting, Qlik consultancy, Qlik educations en Qlik helpdesk. This gives you as a customer all disciplines and services related to Qlik from one supplier.
Victa Qlik Authorized Training Partner Victa Qlik Expertise partner Victa Qlik Elite Managed Services partner Victa Qlik OEM partners Victa Qlik Elite Solutions partner
Support
Firm / company
ISO certification
ISO 27001 and ISO 9001 certifications
Victa has been officially allowed to register since the beginning of 2019 ISO 27001. call certified. With this certification we can demonstrate that the information security processes are in good order. Victa has also been officially allowed to register since the beginning of 2019 ISO 9001. call certified. With this certification we have developed a management system for quality.
Copyright © 2009 - Victoria | Disclaimer | Privacy | Software ULA | Sitemap | Working at Victa
Victoria facebook Victoria Linkedin Victoria twitter Victoria youtube Victoria youtube victa pinterest Victoria google maps Victoria email