All toolkits

Accounting / Toolkit

Account Reconciliation Working Paper

A practical account reconciliation working paper to identify reconciling items, investigate differences, assess related risks, and document clear conclusions.

4 min read · supporting textApplicationLearning stage: Apply Editorial policy
LinkedIn
Return to your library results
Account Reconciliation Working Paper
Account Reconciliation Working Paper

Scroll to explore the full visual.

Inside the working resource

How to use this toolkit.

FileInside_Assurance_Toolkit_04_Account_Reconciliation_Working_Paper.xlsx
Edition / versionToolkit #04 · version not declared in the workbook

Workflow

  1. Read the Read Me and Guidance sheets; keep a working copy.
  2. Enter the account, GL balance and supporting balance in Reconciliation. Difference is GL minus supporting balance.
  3. Investigate items in Reconciling Items, retaining evidence, root cause, proposed adjustment and follow-up.
  4. Assess likelihood and impact in Risk Assessment, then document the result in Conclusion.
  5. Review Dashboard against the detail sheets. The supplied scenario uses fixed ranges; extend formulas when adding rows.

Assumptions & limitations

Illustrative IDR scenario for 31 December 2026; eight balance-sheet accounts. Risk Score is Likelihood × Impact, with illustrative bands High ≥15, Medium ≥8 and Low below 8. The example is not a prescribed risk methodology. Check formulas and ranges before adapting the workbook.
The original Dashboard contains formula errors in some summary cards. Use the detail worksheets for review and check the Dashboard formulas before relying on those totals.

Example scenario

The scenario includes timing differences, omitted amortisation, estimate changes, bank clearing, inventory cutoff, asset disposal and classification items. The worksheet preview below shows the actual field structure.

Illustrative worksheet preview
AccountGL balanceSupporting balanceDifferenceStatus
Trade Receivables2,500,000,0002,430,000,00070,000,000Open
Trade Payables-1,875,000,000-1,875,000,0000Closed

Sample data from the downloadable file; values are illustrative.

Usage & attribution

Account reconciliation is often treated as a simple accounting routine:

Compare two balances. Find the difference. Make them match.

But a good reconciliation should do much more than that.

A difference between the General Ledger and its supporting records can reveal timing issues, unrecorded transactions, cut-off errors, incorrect classifications, calculation problems, weak closing controls, or even unauthorized transactions.

The objective is not simply to make the difference become zero.

The objective is to understand:

Why does the difference exist — and what risk does it represent?

That is where account reconciliation becomes an assurance tool.

Understand the Account

Before reconciling anything, understand what the account represents.

Ask:

  • What transactions normally flow through this account?
  • What should the balance represent?
  • Which system or subledger supports it?
  • Who owns the account?
  • How frequently should it be reconciled?
  • What could cause the balance to be misstated?

Without understanding the account, reconciliation can easily become a mechanical matching exercise.

Obtain and Compare the Balances

Start with the General Ledger balance and compare it against an appropriate independent or supporting record.

Depending on the account, this could include:

  • Accounts receivable subledger
  • Accounts payable subledger
  • Bank statement
  • Fixed asset register
  • Inventory records
  • Accrual schedule
  • Prepayment schedule
  • Payroll records
  • Intercompany confirmation
  • Other supporting schedules

Calculate the difference and identify which accounts require further investigation.

But remember:

A difference is only the starting point.

Identify the Reconciling Items

Break the difference into individual reconciling items.

Common examples include:

  • Timing differences
  • Unrecorded transactions
  • Cut-off differences
  • Classification errors
  • Calculation errors
  • Foreign exchange differences
  • Outstanding transactions
  • Accrual or estimate differences
  • System interface issues

Each reconciling item should explain part of the gap between the two balances.

If the reconciliation still contains an unexplained amount, the account is not fully reconciled.

Investigate the Root Cause

An explanation alone is not sufficient.

If management says:

“It is only a timing difference.”

The next question should be:

What evidence demonstrates that?

Validate reconciling items using relevant supporting evidence such as invoices, bank statements, transaction logs, system records, contracts, calculations, subledger extracts, or subsequent clearing.

Then go one level deeper.

Ask why the reconciling item occurred.

Was it normal processing timing?

Or was it caused by:

  • A missed journal entry?
  • Weak month-end closing procedures?
  • Incorrect system configuration?
  • Poor account mapping?
  • Manual processing errors?
  • Inadequate review?
  • A control breakdown?

This distinction matters.

Because two identical differences can represent very different risks.

Once the cause is understood, assess the potential impact.

Consider financial statement assertions such as:

  • Existence
  • Completeness
  • Accuracy
  • Valuation
  • Classification
  • Cut-off

But also consider the underlying control implications.

A small recurring difference caused by a broken process may deserve more attention than a larger legitimate timing difference.

Risk assessment should therefore consider both:

Magnitude + Nature of the Difference

This helps determine whether an item requires adjustment, additional testing, process improvement, or escalation.

Document and Conclude

A strong reconciliation should clearly demonstrate:

  • What account was reconciled
  • What records were compared
  • What differences were identified
  • What caused those differences
  • What evidence was obtained
  • Whether an adjustment is required
  • What risks were identified
  • Who owns the follow-up
  • When open items should be resolved
  • Whether the account can ultimately be considered reconciled

An account should not be marked “reconciled” simply because someone prepared a spreadsheet.

It should be considered reconciled when the balance is understood, differences are supported, material exceptions are resolved, and remaining items are appropriately assessed.

Inside Assurance Toolkit #04 — Account Reconciliation Working Paper

This toolkit provides a practical working paper covering:

  • Account reconciliation
  • Reconciling item investigation
  • Supporting evidence
  • Root cause analysis
  • Proposed adjustments
  • Risk assessment
  • Reconciliation conclusion
  • Management dashboard
  • Open-item monitoring

It also includes a practical scenario covering timing differences, unrecorded transactions, cut-off issues, classification differences, and accounting estimates.

The objective is to move reconciliation from:

Balance Matching → Difference Identification → Investigation → Risk Assessment → Conclusion

Because reconciliation should not only answer:

“Do these two numbers match?”

It should help us understand:

“Can we explain and support the balance — and what does it tell us about the underlying process?”

That is the difference between performing a reconciliation and obtaining assurance from it.

Beyond the numbers. Inside the business.

Inside Assurance

The Inside Assurance lens

Put the perspective to work.

Use these questions to connect the resource to your own business context.

01 / Business question

What should this transaction or balance represent?

02 / Inside the process

Which recognition, measurement or cutoff decision is involved?

03 / Risk & evidence

What records support the amount and its treatment?

04 / Practical application

What judgment or reconciliation should be documented?

Explore the connected pillar
Sources & related guidance

References & context.

PCAOB AS 1105 — Audit Evidence

The IIA — Global Internal Audit Standards, 2024

These are supporting evidence and documentation references. The workbook is an Inside Assurance template, not an official standard-setter form.

Use the framework and jurisdiction applicable to your work. Original examples and templates do not imply endorsement by the referenced organisations.

Improve the conversation

A question, correction or missing source?

The resource link will be included in your message form.

Contact the editorial team

Explore more toolkits

Inside Assurance

Leave us a message.

We review messages and reply by email. Your text stays in this window until you send it.

Please avoid confidential company information or sensitive personal data.

Reply by email · No live chat
Search the full library