Skip to content

Free Accounting & Audit Template

Free Account Reconciliation Template

Download a free account reconciliation template in Word, PDF, or Markdown. Or turn any video into account reconciliation template with Docsie AI — auto-fills every required field.

Account Info Balance Tie-Out Reconciling Items Aging Support Review Certification

Account Reconciliation Template

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

Template Metadata

Field Details
Category Accounting & Audit
Owner [Team or owner]
Version [Version number]
Effective Date [Date]
Review Cycle [Monthly / Quarterly / Annual / Event-based]
Status [Draft / In Review / Approved]

Account Information

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

Item Details Owner Status
[Item or requirement] [Describe the relevant detail, evidence, or decision] [Owner] [Open / Complete]
[Item or requirement] [Describe the relevant detail, evidence, or decision] [Owner] [Open / Complete]

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.

Item Details Owner Status
[Item or requirement] [Describe the relevant detail, evidence, or decision] [Owner] [Open / Complete]
[Item or requirement] [Describe the relevant detail, evidence, or decision] [Owner] [Open / Complete]

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.

Item Details Owner Status
[Item or requirement] [Describe the relevant detail, evidence, or decision] [Owner] [Open / Complete]
[Item or requirement] [Describe the relevant detail, evidence, or decision] [Owner] [Open / Complete]

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.

Item Details Owner Status
[Item or requirement] [Describe the relevant detail, evidence, or decision] [Owner] [Open / Complete]
[Item or requirement] [Describe the relevant detail, evidence, or decision] [Owner] [Open / Complete]

Notes

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

Supporting Documentation

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

Item Details Owner Status
[Item or requirement] [Describe the relevant detail, evidence, or decision] [Owner] [Open / Complete]
[Item or requirement] [Describe the relevant detail, evidence, or decision] [Owner] [Open / Complete]

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.

Item Details Owner Status
[Item or requirement] [Describe the relevant detail, evidence, or decision] [Owner] [Open / Complete]
[Item or requirement] [Describe the relevant detail, evidence, or decision] [Owner] [Open / Complete]

Notes

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

Certification

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

Item Details Owner Status
[Item or requirement] [Describe the relevant detail, evidence, or decision] [Owner] [Open / Complete]
[Item or requirement] [Describe the relevant detail, evidence, or decision] [Owner] [Open / Complete]

Notes

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

Template Guide

How to Use the Account Reconciliation Template

When to Use This Template

Deploy this template during monthly close cycles, year-end audits, or when preparing for SOX compliance reviews.

  • Month-end and quarter-end financial close processes across all accounts
  • External audit preparation requiring documented balance sheet substantiation procedures
  • Internal control testing under Sarbanes-Oxley Section 404 or COSO framework

What This Template Covers

This template produces a complete audit trail documenting account balances, discrepancies, and resolution with management signoff.

  • Account identification with GL ties, risk ratings, and reconciliation frequency
  • Reconciling items breakdown including timing differences, errors, and outstanding transactions
  • Aging analysis with assigned owners, resolution deadlines, and reviewer certification

Common Pitfalls to Avoid

Teams often fail by skipping documentation steps, leaving reconciling items unresolved, or missing reviewer signoff entirely.

  • Incomplete supporting documentation causes audit deficiencies and control failures
  • Aging items beyond 90 days without escalation triggers material weakness
  • Missing dual signoff invalidates reconciliation under SOX or GAAP requirements

Template Structure

What the Account Reconciliation Template Includes

Use this accounting & audit template as a starting point, then customize each section to match your internal workflow, evidence, and signoff needs.

1

Account Information

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

2

Balance Tie-Out

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

3

Reconciling Items

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

4

Aging and Resolution Plan

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

5

Supporting Documentation

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

6

Review Procedures

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

7

Certification

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

Recommended Structure

Write an account reconciliation template. Structure with these Markdown sections:

Account Information

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

Balance Tie-Out

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

Reconciling Items

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

Aging and Resolution Plan

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

Supporting Documentation

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

Review Procedures

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

Certification

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

Example Filled Template

Account Reconciliation: Prepaid Insurance

Balance Tie-Out

Source Amount
GL balance $186,000
Prepaid schedule $186,000

Reconciling Items

No unreconciled differences noted.

Certification

Prepared by senior accountant on May 3 and reviewed by controller on May 5.

Video to Document

Turn Video Into Account Reconciliation Template

Already have a walkthrough or training video covering this process? Skip manual drafting. Upload the video and Docsie AI generates account reconciliation template with every required field populated — ready for review, signoff, or export.

Use the template manually, or let Docsie generate the first draft from source footage.

DOCX, PDF, and Markdown downloads
Works with process and training videos

Template FAQ

Account Reconciliation Template FAQ

Common questions about downloading and generating a account reconciliation template.

Using This Template

Q: What is a account reconciliation template?

A: A account reconciliation template is a structured document for prepare balance sheet reconciliations with support, reconciling items, aging, and review signoff.

Q: Is the account reconciliation template really free?

A: Yes. The account reconciliation template is completely free to download in Word (DOCX), PDF, and Markdown formats. No signup or credit card required to download.

Q: How do I turn a video into a account Reconciliation Template?

A: Upload a process walkthrough, training recording, or screen capture to Docsie. The AI analyzes the video and generates a complete account Reconciliation Template using this template's structure — every required field auto-filled from the footage.

Q: Can I edit the account reconciliation template after downloading?

A: Yes. The DOCX format opens in Microsoft Word or Google Docs. The Markdown format imports into Notion, Confluence, Docsie, or any markdown editor. Customize fields, add your branding, and adapt to your internal workflow.