Reconciling means agreeing two records of the same money: what your bank says happened, and what your books say happened. When the two agree, your bank balance is right. When they do not, the difference tells you what is missing — usually a cheque nobody has presented yet, or a bank charge nobody has keyed.
In Vertex ERP this is two screens, and they run in order.
Before you start
You need two things: the statement file from your bank, and the bank ledger set up in Vertex ERP.
The statement can be an Excel file, a CSV, the bank’s own PDF, or a photograph of it — Vertex ERP reads all four, including a PDF your bank has password-protected, if you have the password. A photograph is read by character recognition on your own PC, so the picture never leaves your premises.
If the bank account is not in your books yet, add it first on 1→V Bank Account Master, with the account number, IFSC and branch.
Step one — bring the statement in
- Open 2→D Bank Import and choose the bank account the statement belongs to.
- Choose the file. Vertex ERP reads the headings rather than expecting a fixed layout, so a statement from any bank should come in without being rearranged first.
- Check the dates and the opening balance it shows you against the top of the statement. If they do not match, you have the wrong month or the wrong account.
- Tell it which ledger each line belongs to. Every line starts against Suspense.
- Post. The lines become ordinary ledger entries, and you can see them in the Cash-Book like anything else.
Step two — reconcile
- Open 2→E Bank Reconciliation, pick the account, and pick the date you are reconciling to — normally the last day of the month.
- Tick every line that appears on both sides. Entries the bank shows and your books also show are cleared, and drop out of the working list.
- What is left is the difference, and each leftover line is a real thing: a cheque you have written that has not been presented, a deposit not yet credited, or a bank charge you have not keyed.
- Key anything genuinely missing — charges, interest, direct debits — as ordinary entries. Leave un-presented cheques alone; they are supposed to be there.
- The statement figure and the book figure now agree, and the difference is explained line by line rather than being one number nobody can account for.
Checking your work
| What to check | Where |
|---|---|
| The closing balance | Cash & Bank Balances — 3→T |
| Every movement, in order | Cash-Book — 3→H |
| Anything still unexplained | A/c Statement, on the Suspense head |
If anything is still sitting in Suspense at the end of the month, that is the one thing worth clearing before you close the books.
If you get stuck
Open 9→E Contact Support inside the software. It already knows which screen you were on, so you do not have to explain that part.