Bank Reconciliation workpaper (BRC)

Data extraction

Sourced from the Trial Balance plus one or more uploaded bank statement PDFs. Two kinds of statement are expected: one confirming the balance as at a date, and one listing transactions for the period.

●        Header (Bank Statement Reconciliation, [GL Account name]): the GL account name is picked from the Trial Balance where the account is mapped as Bank Account.

●        Bank Name, Bank BSB (Bank-State-Branch, the Australian six-digit bank and branch identifier), and Bank Account Number: all extracted directly from the uploaded statement PDF.

●        Closing Balance per [GL account name]: picked from the statement only where the statement's period end matches the job's Balance Date. If the statement's period doesn't reach the Balance Date, the balance is not pulled from it.

●        Each additional bank account mapped to this workpaper repeats the same block and the same checks.

Matching statements to GL accounts

●        One GL account, one statement: matched directly on account name and balance.

●        More GL accounts than statements: the system matches what it can and leaves the rest unmatched, with the user able to reassign documents manually.

●        More statements than GL accounts: two accounts sharing one statement can be consolidated into a single section (names combined with a comma, amounts summed).

●        Irrelevant documents, anything that isn't a bank statement, or a bank statement that doesn't cover the Balance Date, are ignored rather than forced into a match.

Client name check

Where the statement shows an account holder name, it's fuzzy-matched against the entity name from Job Setup. Minor differences (Ltd, Pty Ltd, Inc endings) are treated as the same entity. Anything else, a materially different name, a partial match, or a mismatch, is flagged for human review rather than assumed.

Balance per GL

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

How to access

●        Go to Jobs and open the relevant job.

●        Click the Workpapers icon or navigate to Job Results then Workpapers.

●        Select BRC on the Workpapers Dashboard.