CORAA
University · Internal control

Control Deficiency Aggregation Worksheet.

List the control deficiencies you found, tag each to an account, and see the combined exposure by account against a threshold you set. Deficiencies that are individually small can matter together.

Deficiencies
Result
Threshold (₹)25,00,000
Combined exposure counted (₹)30,00,000
IndicatorEvaluate as significant together
By account (counted items)
Trade payables30,00,000

Deficiencies rated Remote, or where a compensating control works, are left out of the total. This is a screening aid. Whether deficiencies together are significant or a material weakness is a judgement under your framework, such as SA 265 or the guidance for internal financial controls. Check the current definitions.

Why deficiencies are looked at together.

One weak control may not matter much. Several weak controls over the same account or assertion can let a material error through, because a compensating control for one gap may not cover the next. Grouping deficiencies by account shows where the combined exposure builds up. Estimate exposure as the amount that could be misstated, not the amount that probably is.

SOX deficiency severity evaluatorControl design gap register

How the worksheet aggregates

Each deficiency carries an account, a potential exposure in rupees, a likelihood and a flag for a working compensating control. Remote items and items covered by a working compensating control are left out. The rest are added up by account and overall.

You set the materiality and a percentage of it as the aggregation threshold. Any account at or above the threshold, or a combined total at or above materiality, is flagged for evaluation as significant together.

The output is an indicator to support your judgement. It does not classify a deficiency as a significant deficiency or a material weakness.

Worked example — payables controls

Materiality ₹50,00,000 and threshold 50%, so the threshold is ₹25,00,000. Two payables deficiencies of ₹12,00,000 and ₹18,00,000 are counted. A remote bank item is not.

Inputs
Vendor master changes unreviewed₹12,00,000, reasonably possible
Three-way match overridden₹18,00,000, probable
Late bank reconciliation review₹4,00,000, remote, compensating
Output
Trade payables combined₹30,00,000
Against threshold ₹25,00,000At or above
IndicatorEvaluate as significant together
Neither payables item alone reaches the threshold, but together they do.

Common mistakes

Netting exposures across accounts
Overstatement in one account does not cancel understatement in another for this test. Keep accounts separate.
Counting a compensating control that is untested
Tick it only when you have tested that it operates and is precise enough.
Using the screen as the conclusion
The threshold is your own. The classification is a judgement made under your framework.

Frequently asked questions

Does this decide material weakness?+
No. It flags where deficiencies together deserve evaluation. The conclusion is a judgement under SA 265 or your applicable framework.
What percentage should I use?+
There is no prescribed figure. Use the one in your firm methodology and record the reason.
Does my data leave the browser?+
No. Everything is calculated in your browser.

Authoritative sources

ICAI — Standards on Auditing (SA 265) — Communicating deficiencies in internal control. Check the current text.
Always confirm against the latest version of the source. Regulations evolve and amendments are common.
Related calculators
SOX control deficiency severity evaluator →Control design gap register →COSO 2013 self-assessment →
Share this tool
Last reviewed: 2026-10-17 · For informational purposes only — not professional advice.