ප්‍රධාන අන්තර්ගතයට යන්න
Zoho Books වලට වඩා අඩුවෙන් ගෙවන්න, ශ්‍රී ලංකා බදු ඇතුළත්ව. Growth මසකට LKR 3,390යි.මිල ගණන් බලන්න →
මෙම පිටුව තවමත් සිංහලට පරිවර්තනය කර නැත. පහත දැක්වෙන්නේ ඉංග්‍රීසි අනුවාදයයි.

Bank reconciliation

Bank reconciliation from the statements you already get

rupibooks works from the statement your bank already gives you, so you don't need a bank feed or open banking. Upload or forward a PDF, CSV, Excel or MT940 file, or even a photo. The AI reads it and matches each line to your invoices, bills and rules. Nothing posts until the balances agree to the cent.

  • Comes with examples for the main Sri Lankan banks
  • Every statement must balance to the cent before anything posts
  • Simple cards for owners, a two-pane view for accountants

How do statements get into rupibooks?

  • Upload on the web or your phone, or drag and drop several files at once.
  • Every bank account gets its own forwarding email address, so e-statements arrive on their own.
  • Send a statement, or a screenshot of internet banking, by WhatsApp.
  • rupibooks comes with examples for Bank of Ceylon, People's Bank, Commercial Bank, Sampath, HNB, NSB, Seylan, NDB, DFCC and Pan Asia, and for PayHere and Genie settlement reports.
  • A layout rupibooks hasn't seen before needs no setup. The AI reads it, and the balance check decides whether to trust it.

How does rupibooks know the statement was read correctly?

  1. Step 1: Read. The AI reads each statement (Excel, CSV or PDF, digital or scanned) into a fixed format: bank, account number, currency, period, opening and closing balances, and one row per line.
  2. Step 2: Check. rupibooks checks the dates and amounts, and the account number must match the account you uploaded it to.
  3. Step 3: Balance. The opening balance plus the lines must equal the closing balance to the cent, and each running balance must follow from the line before. If anything breaks, rupibooks flags the exact rows, re-reads them once with a stronger model, then shows them beside the original page for you to fix. Nothing posts until the statement balances.
  4. Step 4: Skip duplicates. rupibooks spots overlapping statements by date, amount, reference and running balance, so it's safe to upload the same period twice.
  5. Step 5: Tidy up. Payee names are cleaned up ("CEB" and "CEYLON ELECTRICITY" both become Ceylon Electricity Board), and rupibooks picks out cheque numbers, LankaPay and CEFT references and card settlements.
  6. Step 6: Learn. After rupibooks has read and checked a bank's layout three times, it saves the column mapping, so later imports from that bank are cheaper and more consistent.

How are statement lines matched?

  • Exact matches first: the amount plus a reference or invoice number.
  • Then close matches: the amount give or take bank fees, a similar payee name and a nearby date.
  • One receipt that pays several invoices, and payment gateway settlements net of fees, which rupibooks splits into sales and the fee expense for you.
  • Rules you make, such as "Dialog → Telephone expense, VAT 18%", or ones the AI suggests after it sees the same pattern three times.
  • Every suggestion shows how confident it is. Lines above your threshold reconcile on their own. The rest wait in a queue sorted by amount.

What do owners and accountants see?

Owners see cards such as "We matched 142 of 150. 8 need you", each with a one-tap suggestion. Accountants get a two-pane statement and ledger view with filters, bulk actions, a reconciliation report and a lock.

Both end with a signed reconciliation statement (book balance against bank balance, with outstanding items), which rupibooks keeps as evidence for your audit.

What else can I reconcile?

  • Cash accounts and petty cash, with a count of notes and coins.
  • Credit cards, read from the card statement.
  • A cheque register with post-dated cheques, which appear in the cash forecast on their deposit date.
  • Foreign-currency accounts, which reconcile in their own currency. See multi-currency.

How many lines will match automatically?

We aim for 80% or more of statement lines to match on their own after your first three months. That's our target, not a guarantee. How fast you get there depends on your banks and on how often your customers quote invoice numbers.

නිතර අසන ප්‍රශ්න

Do I need to connect my bank to rupibooks?

No. rupibooks works from the statements you already download or get by email. There's no bank feed to set up and no banking password to share.

What if the AI misreads a statement line?

Nothing posts until the statement balances to the cent. If it doesn't, rupibooks flags the rows that break the balance, re-reads them and shows them beside the original page so you can fix them.

Is it safe to upload the same statement twice?

Yes. rupibooks spots overlaps by date, amount, reference and running balance, and skips the duplicates.

අවසන් වරට සමාලෝචනය කළේ:

rupibooks ක්‍රියාත්මකව බලන්න

විනාඩි කිහිපයකින් නොමිලේ අරඹන්න, නැතහොත් සජීවී ආදර්ශනය දැන්ම විවෘත කරන්න. එහි ඔබේ වැනි ව්‍යාපාරයක සාම්පල ගිණුම් ඇති අතර, ලියාපදිංචි වීමට අවශ්‍ය නැත.