Bank statement import and reconciliation
Bank reconciliation is the check that everything else is true. If your book balance and your bank balance agree, the cash side of your accounts is sound; if they do not, something has happened that your books do not know about.
| Count | Amount | |
|---|---|---|
| Matched automatically | 284 | 48,62,400.00 |
| In books, not on statement | 6 | 2,18,600.00 |
| On statement, not in books | 11 | 84,200.00 |
| Matched with a difference | 2 | 1,400.00 |
What reconciliation does
Import the statement
From a CSV or Excel download from your bank. No credentials are shared and no third party is given access to your account.
Match on the obvious
Amount, date and reference matched automatically, which usually clears the large majority of lines and leaves you the ones that matter.
Both directions listed
Entries in your books not on the statement, and entries on the statement not in your books. The second list is where the surprises are.
Differences, not just gaps
Same transaction, different amount — bank charges, a partial payment, a wrong figure — flagged rather than left unmatched.
Post the missing entries
Charges, interest and direct credits can be posted from the reconciliation screen rather than noted and forgotten.
Fast on real volumes
Matching is done as a join in the database rather than by comparing every entry against every line, which is what makes a busy account reconcile in seconds.
How to reconcile a month
- Download the statement. CSV or Excel from your bank’s own portal.
- Import and match. The obvious matches clear themselves; what remains is the actual work.
- Resolve both lists. Post what is missing, correct what differs, and query what neither side can explain.
- Agree the balance. Book balance plus unpresented items equals bank balance. If it does not, do not move on.
Bank reconciliation questions
Does tBiz connect directly to my bank?
No, and deliberately so. You import a statement you downloaded yourself, which means no third party holds credentials to your bank account. Direct connections are convenient and they are also a standing access grant to your money.
Which statement formats work?
CSV and Excel downloads, with a column mapping you set up once per bank and account. Bank formats differ and change, so mapping is more robust than assuming a fixed layout.
What about entries on the statement I have never seen?
They are listed separately, and they are the important list — bank charges, direct debits, a customer payment nobody told accounts about. They can be posted straight from the reconciliation screen.
Will it be slow on a busy account?
No. Matching is performed as a database join rather than by comparing every book entry against every statement line, which is the difference between seconds and a screen that never finishes.
Related
Reconcile last month properly
Start free, import a statement, and find out what your books do not know about.