jagomart
digital resources
picture1_Excel Sample Sheet 33697 | Financial Statement Preparation Maturity Self Assessment Tool


 232x       Filetype XLSX       File size 0.11 MB       Source: www.qao.qld.gov.au


File: Excel Sample Sheet 33697 | Financial Statement Preparation Maturity Self Assessment Tool
sheet 1 instructions instructions for each of the four components there is an input sheet1 input mdash month end processes2 input mdash fin statement close3 input mdash fin statement prep4 ...

icon picture XLSX Filetype Excel XLSX | Posted on 10 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Instructions
Instructions

For each of the four components, there is an input sheet:
1. Input—month end processes
2. Input—fin. statement close
3. Input—fin. statement prep.
4. Input—fin. reporting matters.

Each input sheet has a series of questions/prompts for each of the elements of the model.

For each of the questions, select a level of maturity from 1 to 4, with 4 being the strongest.


Results:
Results are provided in two pages:
1. Summary of values—provides the level of maturity at a detailed level for each component and sub-component. Lower levels of maturity at a sub-component level provides areas of focus for entities.
2. Overview—provides benchmarking to expectation of maturity for the three entity types.

Sheet 2: Overview
Benchmarking results
Your entity's results are included for each component, together with the expected results for the three entity types.
Component
Developing Established Integrated Optimised
Quality month end processes Larger or established


Newly established


Small


Your entity
Early financial statement close process Larger or established .

Newly established
Small
Your entity
Skilled financial statement preparation and use of technology Larger or established

Newly established
Small
Your entity
Resolution of financial reporting matters Larger or established

Newly established
Small
Your entity

























































































































































































Sheet 3: Summary of values
Summary sheet
Result range






Component Average maturity
Developing Established Integrated Optimised
Quality month end processes 2.4

Reconciliations 3.5 1
Reporting 2.0 1
Internal quality controls 2.0 1
Early financial statement close processes 3.7

Early close 3.0 1
Audit and audit committee relationships 4.0 1
Asset valuation 4.0 1
Stocktakes 4.0 1
Skilled financial statement preparation processes and use of appropriate technology 1.7

System 1.0 1
Staff skills 1.7 1
Integration and data quality 2.0 1
Internal controls 1.3 1
Tailored disclosure 2.5 1
Timely identification and resolution of financial reporting matters 3.6 1.0
Matters are identified 4.0 1
Analysis performed 4.0 1
Consultation 3.0 1
Overall maturity 2.8

End of summary sheet


The words contained in this file might help you see if this file matches what you are looking for:

...Sheet instructions for each of the four components there is an input mdash month end processes fin statement close prep reporting matterseach has a series questionsprompts elements model questions select level maturity from to with being strongest resultsresults are provided in two pages summary values provides at detailed component and subcomponent lower levels areas focus entities overview benchmarking expectation three entity types results your s included together expected developing established integrated optimised quality larger or newly small early financial process skilled preparation use technology resolution matters result range average reconciliations internal controls audit committee relationships asset valuation stocktakes appropriate system staff skills integration data tailored disclosure timely identification identified analysis performed consultation overall...

no reviews yet
Please Login to review.