Start typing to search the whole website.

Summit Consulting Ltd
Home
Password Strength Checker Cyber Risk Quick Check Are You Safe Online? Are You Cyber Secure? AML Compliance Quiz Data Privacy and Protection Act Quiz Financial IQ Quiz Culture Audit MS Office & Excel Skills Quiz Risk Management Self-Assessment IFRS 9 Adoption Questionnaire 10-Minute Leadership Presence Self-Assessment Board Diversity Assessment Tool MFA Authentication Quiz Benford Analysis Tool Internal Audit Survey BCP / DR Survey Insurance Fraud Policy Questionnaire Fraud Management Survey Strategy Implementation Effectiveness Survey Boardtool Resources 7 Tools Board Book iShield 360 Project FRONTLINE Report Summit Weekly Newsletters Uganda Banking Report The Human Rights Enforcement Act 2019: A Guide Managing Board Affairs in a New Era Barriers to Effective Strategy Execution 8 Strategies to Overcome Sales Rejections Board Evaluation Tool SummitEthical Board Assessment Tool Board Effectiveness Template Executive Ownership Matrix Chair-CEO Gap Framework The 5-Fit Test for Directors The Promotion Readiness Grid The Accountability Chain The Alignment Grid The Trench Leadership Index The Secretary Power Grid Future Director Matrix Mr Strategy's Compass Card Template Mr Strategy's Culture Health Check Tool The Chair Navigation Compass The Fear Filter Tool Leadership Readiness Assessment Scorecard ERM Accountability Map Template Key Risk Indicator (KRI) Template ICT Asset Register Template Digital Risk Oversight Radar Template Enterprise Risk Management Framework and Internal Audit Program Audit Committee Briefing Report Template Internal Audit Board Briefing Template Fraud Reporting Register Template AI and Machine Learning Risk Governance Assessment Tool Strategic Foresight Audit Tool EXCO Execution Grid SIEM Tool Assessment Criteria Cybersecurity Assessment Tool (ISO 27001 and NIST) iShield 360: Multi-Factor Authentication Tools iShield 360 Cybersecurity Risk Assessment Template iShield 360: DLP System Tool Phishing Awareness Guide Password Security Checklist Black Box Penetration Testing Checklist Penetration Testing Scoping Questionnaire Cyberattack Incident Response Plan (CIRP) Template End-of-session Leadership Transition Evaluation SOC Assessment Survey Cybersecurity Survey Questionnaire IFRS9 Adoption Questionnaire
Insights
Talk to us
+256 782 610333 support@summitcl.com

How much do you spend on your audit solution? How many of your staff know how to use your audit solution capably? Are you aware of missing invoices in your accounts payable department?

In September 2017 we were contacted by one of our top clients from Kenya about an audit solution. The audit solution in use in his company was implemented by some specialists from South Africa and this cost about 30M per month. The solution had convolutions and therefore majority of his staff couldn’t deftly use it. They relied on the few staff who could run the solution, thus led to inefficiency.

We had a conversation with the top team and informed them about how they can use their available tools to run an audit solution without having to purchase any additional software. Using Microsoft office applications that are cost effective and quite easy to use.

In November, our team connected the audit solution to the financial data management system. We run the solution and our client was able to make all the required financial reports on time

How the audit solution works

The solution connects to any data management system; from web, relational databases like MS Access, SQL, MySQL. Our Business Intelligence team works with the IT department to access these data systems with the required credentials provided to install it onto the machines

After establishing a connection with your core system, it lets you make all your reports for instance financial reports like financial statements, gap analysis report, duplicates report, Benford’s rate analysis report.

A read-on copy can be created that can be accessed when there’s no connection to the database. This means that one can access the reports made by the solution but can’t tamper with the data.

Figure 1; The core system of the data

Why summitBI Audit solution

Our client was using audit systems that are too complex to understand hence delay in service delivery as well as inefficiency as compared to our solution which has an easy user interface. It is also referred to as self service system since once installed everything is at your disposal.

He was amazed by the ability of the audit solution to automate data cleaning, data structuring once connected to the data system. Given that auditing requires clean well-structured data. Therefore, one needs to work at it before auditing.

What is gap Analysis? Why Gap analysis.

As revealed by our client, missing invoices are one of the most frustrating issues in the accounts department. Invoice numbers are sequentially generated for example if you have an invoice numbered 1, the next time you generate an invoice it will be numbered 2.

In spite of the sequential generation of the invoice numbers, some accounting officers maliciously or accidentally tamper with the invoices. Therefore, identifying and tracking down missing invoices keeps most of the top financial officials up in the night.

READ:>> Insurance Analytics: How Insurance Companies can monetize their vast amounts of data

Using gap analysis however helps identify these missing invoices as you will see later on. Our client’s Financial system had a database that contained a couple of tables and among the tables was the accounts table that had the invoice data like invoice numbers, date posted, date raised, amount and others as shown in figure 2

When you look closely at figure 2 you realise that invoice number 23956 is missing from the list in spite of the sequential generation of the invoice numbers, After running our audit solution, we identified the missing items in the system which were over 1723 invoices yet it cost just a pinch of our client’s petty cash purchasing it.

Figure 2 List of the invoice numbers in the data system (Notice that a ROW is missing)

The red rectangle shows a missing invoice since the invoice numbers aren’t following the expected pattern.

After extracting the first and last invoice numbers, the solution tracks down the missing invoices.

Figure 4; Missing invoices in the system

Below are the identified missing invoice numbers in the system. Furthermore, with our solution it’s possible to identify the dates with missing items.

READ:>> Business Intelligence and Analytics Using MS Beyond Excel, Tableau, and #summitBI SOLUTIONS

With this report its therefore easier to track down when and why invoices are missing. With our self-service business intelligence, we can work with you to effectively and efficiently find the gaps in your data. Don’t let your data lie to you. Know what’s hidden behind it. Then action can be taken accordingly

Would you like to learn more about our audit solution?

Make an appointment for a demo with us about our audit solution. You can as well let us know about any feed back in relation to this article. We look forward to working with you.

0 comments

Leave a comment

Keep reading

More from Summit Consulting.