Bank Reconciliation workpaper (BRC)

How the BRC workpaper is populated from bank statements, how to navigate between multiple bank accounts, and how to filter the view.

The Bank Reconciliation (BRC) workpaper reconciles the bank balance shown in the General Ledger (GL) against the bank statement or Xero bank reconciliation summary at year end. Each bank account is reconciled separately.

Data extraction

Automatically populated based on the Bank Statement or Xero Reconciliation Summary Page uploaded under Data Sources (Source Docs).

Only the summary page of the Xero Reconciliation Report is required, not the full report. This keeps the supporting documentation concise.

Section structure

Each account code mapped to Bank in Chart of Accounts (CoA) mapping will have a separate section. Use the toggle in the workpaper to switch between:

  • Viewing all banks
  • Viewing only unreconciled banks

Balance per GL

Balance of each account code mapped to Bank in CoA mapping.

How to access

  1. Go to Jobs and open the relevant job.
  2. Click the Workpapers Icon or navigate to Results then Workpapers.
  3. Select BRC on the Workpapers Dashboard.