Reconciliation

The Reconciliation tab checks each balance sheet account against the schedule that supports it, and shows any difference as an exception.

Mac appAvailable
Windows appAvailable

Reconciling an account means checking that the balance in the books agrees with the paperwork behind it. The paperwork is a schedule: a list of prepaid contracts, a register of fixed assets, or the accruals for the month. Where the two do not agree, there is an exception.

The Reconciliation tab with a table of accounts, the balance per the ledger and per the schedule, the difference, and a status chip per account — Seven accounts of a demo company. One shows an exception.

The table

The first card is Balance sheet reconciliations. It compares Per GL (the general ledger, the company's own record) with Per schedule.

Column	What it shows
Ledger account	The account
Kind	What kind of schedule backs it, such as prepaid, roll-forward, fixed assets or accrual
Per GL	The balance in the ledger
Per schedule	The balance the schedule adds up to
Difference	The gap
Status	reconciled, or exception

An exception chip opens the account's schedule below it.

The schedules

Under the table, Schedules holds one section per account. Each is worked out again from its own rows. A warning triangle marks a row that disagrees with the balance it states. A schedule with an exception opens by itself.

Where a company has balances that no reconciliation covers, a line names them.

A company with nothing reconciled says so: No reconciliations at this close.

How a company gets reconciliations

Reconciliations come from files. On the Files tab you can add:

a reconciliation binder in Excel;
QuickBooks reconciliation report PDFs. For a company whose books come from QuickBooks, the Files tab has an Add reconciliation reports box for them. Drop the PDFs there. Haruno copies them and leaves your originals alone.

To reconcile a month that was closed without, add the binder or the reports, reopen the month and close it again. See Closing a month.

A reconciliation exception also appears as a finding. See Findings and questions.

Exporting

The reconciliation is one of the company's three reports. It exports as a PDF and a web page, from the same data and in the same order as the tab. See Reports and exports.

What to tell a customer

Reconciliation is the check that the books are right. Haruno does it for every account that has a schedule, and shows the exceptions first.