BRS Workbench

1

Account & period

Account

Agency

Fund

Month

Year

Bank name

Branch

Account no.

Prepared by

Certified correct by

Unadjusted book balance (per general ledger)

Unadjusted bank balance (auto-fills from statement)

2

Prior period outstanding items

Optional — carries forward last month's still-outstanding checks and deposits so they're recognized when they finally clear, not misread as bank memos

Checks & deposits still outstanding as of last month's reconciliation

Upload last month's BR/Schedule workbook — the most recent "S_" schedule sheet is auto-detected — or enter the carryover items by hand. Leave this empty for a first-time reconciliation.

Click to upload last month's BR workbook (.xlsx)

none

3

Bank statement

Upload the bank export for this account and this month

Bank statement

Columns expected: Date, Description, Debit, Credit, Balance, Cheque Number — the format your bank export already uses.

Click to upload or drag an .xlsx / .csv file here

example

4

Book records

Upload or enter this account's ledger for this month

Book records

Your account ledger export (TransDate / TransType / ReferenceNumber / Payee / Debit / Credit), a WP working paper, or a simple register.

Click to upload your ledger export, WP working paper, or register (.xlsx / .csv)

example

5

Reconciling items

Auto-matched by reference no., batched ADA/deposit groups, then amount clusters · edit, exclude, or add items freely

Adjusted book balance

Adjusted bank balance

Variance —

6

Export

Generates three sheets — BR_ (statement), S_ (schedules), and Reconciled Balances (every matched item — book date, bank date, reference no., amount per book, amount per bank, and the proof between them) — in the layout of your existing workbook, ready to paste in or send as-is.