Skip to main content
Pay less than Zoho Books, with Sri Lankan tax built in. Growth is LKR 3,390 a month.See pricing →

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.

Last reviewed: Reviewed by: rupibooks compliance team (CA review pending)

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

  1. Step 1: Check that the opening balance plus the lines equals the closing balance.
  2. Step 2: Match receipts to invoices by amount and reference, and payments to bills.
  3. Step 3: Record bank charges, interest and WHT deducted at source.
  4. Step 4: List outstanding items (uncleared cheques, deposits in transit).
  5. 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.