Paper 3 Annex 1 Internal Audit Review New Finance System
Paper 3 Annex 1 13 March 2026
Paper 3 Annex 1
Cairngorms National Park Authority
Internal Audit
2025 – 26
New Finance System November 2025
Overall Conclusion Substantial
Table of contents
Cairngorms National Park Authority
New Finance System
Section
1 EXECUTIVE SUMMARY (2) 2 BENCHMARKING (11) 3 DETAILED RECOMMENDATIONS (12) 4 OBSERVATIONS (16) 5 AUDIT ARRANGEMENTS (17) 6 KEY PERSONNEL (18)
Appendix
A GRADING STRUCTURE (20) B ASSIGNMENT PLAN (22)
The matters raised in this report came to our attention during the course of our audit and are not necessarily a comprehensive statement of all weaknesses that exist or all improvements that might be made.
This report has been prepared solely for Cairngorms National Park Authority’s individual use and should not be quoted in whole or in part without prior written consent. No responsibility to any third party is accepted as the report has not been prepared, and is not intended, for any third party.
We emphasise that the responsibility for a sound system of internal control rests with management and work performed by internal audit should not be relied upon to identify all system weaknesses that may exist. Neither should internal audit be relied upon to identify all circumstances of fraud or irregularity should there be any although our audit procedures are designed so that any material irregularity has a reasonable probability of discovery. Every sound system of control may not be proof against collusive fraud. Internal audit procedures are designed to focus on areas that are considered to be of greatest risk and significance.
1 Executive summary
Overview
Purpose of review
The purpose of this assignment was to review the implementation of the new finance system to assess whether the system is working as anticipated. We also reviewed the implementation process to assess whether deadlines and costs were met, and that staff have received sufficient training on the system.
This review forms part of our 2025⁄26 Internal Audit Annual Plan.
Scope of review
Our objectives for this review were to assess whether:
- The new Finance System is fit for purpose and operating in line with good practice.
- Data has been accurately transferred from the previous Finance System.
- Sufficient training has been given to those staff who will be using the new Finance System.
- Appropriate controls have been put in place over the new Finance System, and these are being adhered to by staff.
Our approach to this assignment took the form of discussion with relevant staff, review of documentation and where appropriate sample testing.
Limitation of scope
There was no limitation of scope.
1 Executive summary
Background
Previous Finance System
Cairngorms National Park Authority (the Organisation) previously used Sage200 as their Finance System. However, the Organisation believed that the system was no longer fit for purpose. Replacing the previous system had been considered by the Finance Team before the current Head of Finance and Corporate Operations first came into post at the end of 2022.
Replacing the Old System
The Organisation had an internal audit (by the previous internal auditors) carried out in October 2023 to review the position for replacing the system. The internal audit report included recommendations to improve the ‘Business Case for Replacement of Finance System’. Considering the recommendations made within the audit report, the Business Case was adjusted and presented to the Audit & Risk Committee in June 2024. The conclusion of the presented Business Case was a recommendation to the Committee to purchase Access Financials.
Timeline
A timeline for implementation was prepared:
| Stage | Implementation |
|---|---|
| System design | August 2025 |
| Data Preparation | September 2025 |
| Installation | October / November 2025 |
| System set-up | December / January 2025 |
| Training | February / March 2025 |
| Go Live | 1 April 2025 |
1 Executive summary
Data Transfer
The target for fully transitioning to the new system on 1 April 2025 was planned to give enough time for staff to be properly trained ahead of the go live date. The 1 April 2025 date would fall in the middle of the Organisation’s pay run processing, so to avoid issues caused by moving to the new system at this time, the go live date was moved to 3 April 2025, with all finances being put through the new system entirely from 7 April 2025.
To perform the transfer of data from the Sage200 to Access, the data was first extracted from Sage200 into excel format. The Head of Finance and Corporate Operations then mapped this data to the new coding structure used within the Access Financials system. The new system uses more complex coding than the previous system, allowing for costs to be allocated to specific project streams. This includes codes made of three ‘parts’:
- Service — which relate to Running Costs, Operational Plan delivery and the Cairngorms 2030 programme (C2030)
- Project — Where the code will be assigned to a specific project within an aim of the Operational Plan, or a project within the C2030 programme. .
- Budget code — a code aligned to a specific line item – for example 50000 is Software, 70000 is Grant award capital, and 70130 is Consultancy. Once mapped to coding, the data was uploaded to a test environment within the Access Financial system. Reconciliations were then performed on the data held within the test environment to ensure that the migration was correct.
After the reconciliation of data within the test environment was completed, the data was then uploaded to the live environment of Access Financials. Reconciliations were then performed again, so that the Head of Finance and Corporate Operations was satisfied that the upload to the live environment was accurate. Some issues were found at this stage when, on reconciliation between the purchase ledger control account in the Nominal ledger and the supplier accounts in the Creditors sub-ledger, it was found that some open transactions had not been transferred to the Creditors sub-ledger. The Head of Finance and Corporate Operations found the exact entries that were not correctly uploaded to the new system and sent a list of these to Access for investigation. Access then resolved these issues which meant that final reconciliations could be balanced, confirming that the upload was accurate.
1 Executive summary
Training
The Organisation’s Finance Team were provided with training by Access on the new system prior to its implementation. This consisted of live walkthrough sessions with a representative from Access where there were open dialogue and specific discussions on how to tailor the capabilities of the system to the needs of the Organisation. These were all recorded sessions which the Finance Team can rewatch at any time.
The Senior Management Team also received dedicated training, focused on the coding structure and approval workflow; the financial operations module; and the analytics module within the new system.
Staff who are required to raise purchase requests through the finance system received training sessions on how to use each area of the purchasing function within the system, led by the Management Accountant. Additionally, ‘how to’ documents have been prepared covering each type of purchase request, allowing staff to review the procedures where they are unsure.
New System Benefits
From our discussions with staff and review of the new Finance System, we found that it is fit for purpose. The new system is more efficient and has reduced the overall workload of individual staff. The Organisation wanted the systems to enhance budgeting information available. We held discussions with the Financial Accountant, to discuss the enhanced budgeting features of the new system.
All budgets are loaded into the system using an excel template upload. We noted that the system allows for limited budget reporting, whereby project Budget Holders can view reports showing their total budget, their spend each period, their total commitments, and budget remaining. There is no budget reporting currently available for Running Costs, but this is in development. The reports are interactive and allow users to expand the report and view the individual transactions within. Reports show budget codes relevant to the budget holder. The Financial Accountant delivered training and user guides and has confirmed that project Budget Holders can currently run these reports themselves using the ‘self-service’ function.
1 Executive summary
The system includes an ‘Analysis’ reporting module, which allows authorised users to view information, such as income, expenditure, profit and loss, and current bank balance. This information can be filtered and sorted, looking at specific areas or periods. It also provides wide scope for the development of custom reporting. The finance team are gradually developing the skills to allow them to create their own reports and dashboards.
The Head of Finance and corporate Operations and the Financial Accountant are working with Access to custom design budget reports that are fit for purpose. This is a customised functionality. When these developments have been implemented the aim as envisaged, to enhance the budgeting information available to the wider staff group, will be met.
Approval Workflows
The new system includes an authority approval chain mechanism. The users who hold authority for approving purchases through the finance system are clearly defined in the Organisation’s Authorisation Workflow. This document shows the full chain of authority relating to each budget code in the system. It details the relevant Budget Holder, head of service, and director for each code, as well as the Deputy Chief Executive Officer and the Chief Executive Officer, showing these would be the end of the approval hierarchy.
The Organisation has an Out of Office procedure where staff in a position to authorise purchase requests are expected to add to the system when they will be absent and to delegate their approval rights. This helps to ensure that purchase requests are passed on to the next person in the chain of authority. We found that staff must select who they delegate the responsibility to when they are out of office, but that the system allows them to delegate to any individual related to that project. See Section 3: Detailed Recommendations for further information.
1 Executive summary
Work Undertaken
In line with our objectives, our work undertaken for this review included the following:
Objective 1: The new Finance System is fit for purpose and operating in line with good practice.
- We reviewed the steps undertaken to assess whether the new finance system would be fit for purpose and address the needs of the Organisation.
- We reviewed the Business Case for Replacing Financial System presented to the Audit and Risk Committee to assess whether all available options were properly explored before reaching a conclusion.
- We discussed the use new finance system with the Head of Finance and Corporate Operations to assess whether it is fit for purpose.
Objective 2: Data has been accurately transferred from the previous finance system.
- We discussed the Organisation’s process for data transfer from the old system to Access financials with the Head of Finance and Corporate Operations.
- We assessed the data transfer process which the Organisation followed through transition to assess whether there was correct transfer of data.
- We reviewed evidence of the data reconciliations performed to confirm these were appropriate.
Objective 3: Sufficient training has been given to those staff who will be using the new finance system.
- We reviewed the training conducted by the Organisation surrounding the new finance system to assess whether this was sufficient.
- We reviewed the “How To” guidance documents prepared for staff using the purchases function of the system.
Objective 4: Appropriate controls have been put in place over the new finance system, and these are being adhered to by staff.
- We reviewed the controls in place over the new finance system to assess whether there is a clear segregation of duties in place.
- We reviewed the access rights in place within the new finance system to assess whether these were appropriate.
1 Executive summary
Conclusion
Overall conclusion
Overall Conclusion: Substantial
Following our review, we can provide Substantial assurance surrounding the implementation of the new Finance System at the time of the review. We reviewed the process prior to the new system being implemented, the transition of data, the training, and the current use of the system. While we have raised several good practice points, we have raised one medium grade recommendation for improvement and two observations for consideration. Please see Section 3: Detailed Recommendation and Section 4: Observations respectively for further information.
Summary of recommendations
Grading of recommendations
| High | Medium | Low | Total | |
|---|---|---|---|---|
| New Finance System | 0 | 1 | 0 | 1 |
As can be seen from the above table there were no recommendations made which we have given a grading of high.
1 Executive summary
Areas of good practice
The following is a list of areas where the Organisation is operating effectively and following good practice.
- We completed a walkthrough of the Purchase Request process and compared this process to the steps shown in the ‘how-to’ guidance documents provided to staff. We found that the guidance documents clearly detail the process for raising purchases within the system.
- The Organisation has clearly defined responsibilities for all its projects, with dedicated approval workflows for each within the system.
- Training on the use of the new system was presented to the Finance Team, Senior Management and all staff with a purchasing responsibility, with training sessions tailored to the needs of each group.
- Reconciliations were performed throughout the data transfer process, allowing the Organisation to ensure data uploaded to the new system was accurate.
- The SMT received targeted training ahead of the new finance system’s go-live through documentation and live-walkthroughs. The sessions helped to ensure that SMT understood approval workflows, reporting, and budget management.
- Training and guidance have been provided to help ensure staff can raise purchase requests. Multiple training sessions were delivered to staff on the different types of purchase request they might need, supported by step-by-step ‘How to’ guides available on the Organisation intranet for all purchase types.
1 Executive summary
The following is a list of areas where the Organisation is operating effectively and following good practice.
- In 2023, the Organisation had an internal audit performed on the replacement of their finance system. Recommendations made within the report were then implemented by the Organisation into its Business Case for switching suppliers. This updated Business Case was then provided to the Audit & Risk Committee in 2024.
- Training and engagement took place between the finance team and the system provider, with recorded sessions covering a wide range of finance system functions. Queries were resolved in real time and discussions focused on tailoring the systems features to the needs of the Organisation. There were specific sessions planning for the go-live and any challenges that may need preparation for in advance. Additionally, there are also further training resources available on Access for the Finance Team to use at any time.
- From our assessment of the finance system, and our review of the Business Case developed for its implementation, we can confirm that the new system is fit for purpose.
2 Benchmarking
We include for your reference comparative benchmarking data of the number and ranking of recommendations made for audits of a similar nature in the most recently finished internal audit year.
New Finance System
Benchmarking
| High | Medium | Low | Total | |
|---|---|---|---|---|
| Average number of recommendations in similar audits | 0 | 0 | 1 | 1 |
| Number of recommendations at Cairngorms National Park Authority | 0 | 1 | 0 | 1 |
From the table above it can be seen that the Organisation has the same number of recommendations compared to those organisations it has been benchmarked against, although the distribution differs, with a greater proportion of medium grade recommendations.