Skip to content
BankReconciler

Monthly reconciliation report your auditor can sign off

Every reconciliation in BankReconciler ends with a report that stands on its own. A reviewer who never saw your files can read it and see that the account is reconciled, and why.

A clipped stack of monthly statements on a desk

What is in a bank reconciliation report

Summary

Account, period, statement opening and closing balance, book balance, adjusted balances on both sides and the remaining difference.

Adjusted bank balance

Statement closing balance, plus deposits in transit, minus outstanding checks, plus or minus bank errors.

Adjusted book balance

Book balance, plus interest and collections the bank recorded, minus bank fees, NSF checks and charges, plus or minus book errors.

Item lists

Matched pairs, outstanding checks, deposits in transit, items in the bank only, items in the books only, duplicates and differences, each with date, description and amount.

Adjusting entries

The journal lines proposed to bring the books in line, with the account and the amount for each.

Sign off

Preparer, time of preparation and, on the Firm plan, the reviewer who signed the period off.

PDF for the file, XLSX for the work

The PDF is the record you attach to the month end close or the audit work papers. The XLSX has the same content in sheets, ready for filtering, notes and your own checks. On the Firm plan both carry your firm logo instead of ours.

A look at the report

  • Page one with the summary and adjusted balances
  • Item lists by category with totals
  • Adjusting entries ready to import

These pages come from our own report generated on fictional data and carry a watermark.

Why a written report matters every month

Reconciliation is one of the basic internal controls. A dated report for each account and each month shows lenders, auditors and tax preparers that the books were checked against the bank, and it gives the next person a clear starting point with the outstanding items already listed.

Get your first reconciliation report

Upload a statement and a ledger. The report is ready as soon as the matching finishes.