For accountants and company secretaries
How do I reconcile my bank account from a PDF statement?
Check that the statement's opening balance plus its lines equals the closing balance. Then match each line to an invoice, bill, transfer or charge in your books, and explain anything left over. Keep the signed reconciliation with your records: companies must keep accounting records that correctly record and explain their transactions, and tax records are kept for at least five years.
The problem and the fix
The problem
Sri Lankan banks send statements as PDFs in different layouts, and most accounting software expects a bank feed.
The fix
rupibooks reads PDF, Excel and CSV statements from any Sri Lankan bank, checks the balance to the cent, and proposes the matches for you to approve.
Reconciling a statement
- Step 1: Check that the opening balance plus the lines equals the closing balance.
- Step 2: Match receipts to invoices by amount and reference, and payments to bills.
- Step 3: Record bank charges, interest and WHT deducted at source.
- Step 4: List outstanding items (uncleared cheques, deposits in transit).
- Step 5: Sign off the reconciliation and keep it with the records.
How rupibooks helps
- The Bank matcher agent does the matching and leaves only the exceptions for you. See bank reconciliation.
Free plan, no card needed. AI is included on every plan, with nothing to set up.
Frequently asked questions
What about post-dated cheques?
Keep a cheque register. rupibooks lists post-dated cheques and shows them in the cash forecast on their deposit date.
General information, not tax or legal advice. We read every source on this page on the date shown. Rules change, so check the source or ask your accountant before you file or pay.
See how rupibooks fits your business
Start free in minutes, or get a demo instantly. It opens right away with sample books for a business like yours.