Please use this identifier to cite or link to this item: http://hdl.handle.net/1893/35527
Full metadata record
DC FieldValueLanguage
dc.contributor.advisorShankland, Carron-
dc.contributor.advisorBrownlee, Alexander-
dc.contributor.authorRichardson, Vikki-
dc.date.accessioned2023-11-08T11:10:28Z-
dc.date.issued2022-12-
dc.identifier.urihttp://hdl.handle.net/1893/35527-
dc.description.abstractAudit Scotland is appointed by the Auditor General for Scotland and the Accounts Commission to perform audit services for most of Scotland's public organisations. An auditor must determine if the accounts presented by an organisation represent a true and fair view of their financial position. A detailed, methodical exploration of the audit client's general ledger will assist the auditor in coming to this conclusion. Advances in the private audit sector in general ledger analysis have been made possible thanks to the streamlined nature of many small/medium enterprise (SME) accounts packages and the accounting frameworks that apply. Public audit financial management systems are more diverse in nature, as are the accounting frameworks that apply across the sectors, therefore no commercially available ledger analysis tools have been successfully adapted for use in public audit. Audit Scotland had introduced a rudimentary ledger analysis tool, in the form of a Microsoft Excel add-in, which was struggling to cope with the volume of data to be processed for effective analysis. It also failed to meet standards for reproducibility and documentation required by data analytics tools used in an audit. The introduction of an ETL (extract, transform and load) data pipeline using data engineering principles during this project has increased Audit Scotland's capacity to ingest and prepare general ledger data from public organisations, ready for analysis. Additionally, a web application for general ledger analysis (Asc) has been created to enable Audit Scotland financial auditors transparent, efficient access to the general ledger data of their clients. An important aspect of audit work is journal risk assessment. Each journal in the ledger should be assessed and classified as 'risky' or 'non-risky' in terms of causing a material misstatement in the accounts. With some public organisations creating upwards of a million journals per year this is an impossible manual task for an Audit Scotland audit team. Attempts at producing unsupervised machine learning classification models for this task by the author, thus far, have proved unsuccessful in accurately classifying journals thanks, in no small part, to an ineffective evaluation method caused by a lack of labelled data and a lack of resources needed to evaluate the model’s output. Within Asc, a journal risk assessment module has been developed which allows an auditor to manually classify all journals more efficiently through the lens of optional risk factors. This human expert classification has been captured to produce a data labeller for public audit ledger data, opening future possibilities to train and test supervised classification models, using labelled data, whilst providing a useful journal risk assessment tool for use in Audit Scotland now. Using data visualisation tools and automated reporting within Asc, the general ledger can be examined to a significantly higher level of transparency. Auditors are reporting more confidence in their audit decisions, and the evidence they can provide to support those decisions, using Asc. Increased confidence, backed up by documented decisions lead to a higher quality audit which is the motivation for this work.en_GB
dc.language.isoenen_GB
dc.publisherUniversity of Stirlingen_GB
dc.subjectauditen_GB
dc.subjectdata engineeringen_GB
dc.subjectETLen_GB
dc.subjectledger analysisen_GB
dc.titleAudit Scotland: Improving audit quality with data scienceen_GB
dc.typeThesis or Dissertationen_GB
dc.type.qualificationlevelDoctoralen_GB
dc.type.qualificationnameProfessional Doctorateen_GB
dc.rights.embargodate2027-11-01-
dc.rights.embargoreasonThis thesis contains sensitive information and keeping it confidential is imperative to enabling Audit Scotland to ensuring that they can fulfil their duties as financial watchdogs of public sector bodies.en_GB
dc.contributor.funderAudit Scotlanden_GB
dc.author.emailvikkirichardson@hotmail.co.uken_GB
dc.rights.embargoterms2027-11-02en_GB
dc.rights.embargoliftdate2027-11-02-
Appears in Collections:Computing Science and Mathematics eTheses

Files in This Item:
File Description SizeFormat 
vikki_richardson_thesis.pdfAudit Scotland: Improving audit quality with data science11.6 MBAdobe PDFUnder Embargo until 2027-11-02    Request a copy


This item is protected by original copyright



Items in the Repository are protected by copyright, with all rights reserved, unless otherwise indicated.

The metadata of the records in the Repository are available under the CC0 public domain dedication: No Rights Reserved https://creativecommons.org/publicdomain/zero/1.0/

If you believe that any material held in STORRE infringes copyright, please contact library@stir.ac.uk providing details and we will remove the Work from public display in STORRE and investigate your claim.