Account Reconciliation Template

Use this template to prepare balance sheet reconciliations with support, reconciling items, aging, and review signoff.

Template Metadata

Account Information

Identify account number, name, preparer, reviewer, period, risk rating, and reconciliation frequency.

Notes

[Add context, assumptions, exceptions, evidence links, screenshots, calculations, or reviewer comments.]

Balance Tie-Out

Tie general ledger balance to subledger, bank statement, aging report, or supporting schedule.

Notes

[Add context, assumptions, exceptions, evidence links, screenshots, calculations, or reviewer comments.]

Reconciling Items

List timing differences, errors, accruals, outstanding checks, deposits in transit, and required adjustments.

Notes

[Add context, assumptions, exceptions, evidence links, screenshots, calculations, or reviewer comments.]

Aging and Resolution Plan

Age reconciling items, assign owners, due dates, and escalation for stale items.

Notes

[Add context, assumptions, exceptions, evidence links, screenshots, calculations, or reviewer comments.]

Supporting Documentation

Reference reports, statements, invoices, calculations, and evidence retained.

Notes

[Add context, assumptions, exceptions, evidence links, screenshots, calculations, or reviewer comments.]

Review Procedures

Document reviewer checks for completeness, accuracy, unusual items, and compliance with policy.

Notes

[Add context, assumptions, exceptions, evidence links, screenshots, calculations, or reviewer comments.]

Certification

Capture preparer and reviewer signoff, completion date, and open items.

Notes

[Add context, assumptions, exceptions, evidence links, screenshots, calculations, or reviewer comments.]