Cash book or ledger
Required: date; amount (one column with + and −, or debit and credit); description, or a payee or customer name. Recommended: reference (cheque, invoice or document number).
Help centre / Files
The right columns,
first time.
Required and recommended columns for every file you upload.
Open BrillrecRequired and recommended
Headings do not have to match these names exactly, and they need not be on the first row.
Bank statement
Required: date; amount (debit and credit, or one column); narration. Recommended: reference; running balance, which proves no lines are missing.
Processor or POS report
Required: date; amount (gross or net); transaction reference (reference, transaction ID, RRN or STAN). Recommended: fees; settlement or payout ID.
Holdings
Required: security (name, ISIN or ticker); quantity (units, or face value for bills and bonds). Recommended: ISIN; price; market value; maturity date for treasury bills and bonds. A fund manager’s or custodian’s valuation statement works as it is.
Trades
Required: trade date; security; buy or sell (or sales shown as negative quantities); quantity. Recommended: price; consideration; contract note number.
Client money
Required: client ID or name; balance (or debit and credit). Recommended: both the client ID and the name.
Common questions
Quick answers.
My references are inside the description. Is that all right?
Yes. References written inside the description or narration, such as “NIP/TRF/INV101/Ada”, are fine. Brillrec reads them from there.
Is there a template?
Yes. On the Files step of a new reconciliation, open What does this file need? under the upload and choose Download a template.
Why is the description required?
Matching by name and reference, the AI review and the explanations in the sign-off pack all depend on knowing what each line was. A payee or customer name column does the same job.
Brillrec says a required column is missing.
After upload, a checklist shows each column it found and names any that is missing. Choose it on the Columns step if it is there under another heading; otherwise export the file again with it.
Which formats and sizes can I use?
CSV, Excel and PDF, up to 25 MB each. A NIBSS NIP session report is recognised as downloaded. These checks apply to files you upload by hand.
Keep reading
Related guides.
Getting started
From a new account to a signed-off statement.
Read the guideThe Statement inbox
Bank statements and valuation statements, filed to the right account and period.
Read the guideAccounts: bank, POS and investments
Bank, POS and payments, and investment accounts, each reconciled period by period.
Read the guideStill stuck?
Ask us.
Email hello@brillrec.com with what you were doing and what you saw, and we will help.
Email Brillrec