All templates

Automated Kotak Bank Invoice Reconciliation

Every morning, WebRun opens Kotak Mahindra Bank net banking, reads every transaction since the last check, matches each one against the open invoice records in Airtable, marks matched invoices as paid, and logs any transaction or invoice it cannot match to Notion for your review.

Runs on WebRun · Strict Lockdown policy
Every day at 8:00 AM WebRunorchestrates each step
1 Kotak Mahindra Bank pull the latest transactions
2 Airtable match transactions to invoices
3 Notion log the mismatches
In short

How do I reconcile Kotak Mahindra Bank transactions against invoices?

WebRun reads your Kotak Mahindra Bank transactions each morning and matches every one against the open invoice records in Airtable. Matched invoices get marked paid automatically, while any transaction or invoice it cannot match gets logged to Notion for your finance team to review, so reconciliation stops being a manual, end of month scramble.

  • Matched invoices get marked paid without manual entry
  • Every unmatched transaction is flagged the same morning
  • A running reconciliation log builds itself in Notion

Built for small business owners in India · bookkeepers · finance teams · Kotak business banking customers

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens www.kotak.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Kotak Mahindra Bank - pull the latest transactions
    kotak.com
    WebRun in Kotak Mahindra Bank: pull the latest transactions
    WebRun opens Kotak Mahindra Bank to pull the latest transactions.
    • Open Kotak net banking and go to the account statement
    • Read every transaction since the last reconciliation
    • Capture the amount, date, and reference for each

    Done when Every new transaction is captured with its reference.

  3. 2
    Airtable - match transactions to invoices
    airtable.com
    WebRun in Airtable: match transactions to invoices
    WebRun opens Airtable to match transactions to invoices.
    • Match each transaction against the open invoice records
    • Mark matched invoices as paid
    • List any transaction with no matching invoice

    Done when Every transaction is matched or flagged as unmatched.

  4. 3
    Notion - log the mismatches
    notion.so
    WebRun in Notion: log the mismatches
    WebRun opens Notion to log the mismatches.
    • Log a mismatch entry for any transaction with no matching invoice
    • Log any invoice that is still unpaid with no matching transaction
    • Leave both for your finance review

    Done when Every mismatch from the run has a logged Notion entry.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.kotak.com
ScheduleRuns automatically on this cadence
Every day at 8:00 AM
DeliveryHow each run's result reaches you
Reconciliation log · Notion
OutputWhat each run produces - A list of matched invoices and any transaction or invoice that could not be reconciled.
Text
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will WebRun pay an invoice or move funds to fix a mismatch?

No. WebRun only compares records and reports what does not match. Paying an invoice or transferring money stays a step a human takes.

How does it decide two records match?

It matches on amount, date, and any reference number it can find, so a same day, same amount payment with a matching reference counts as reconciled.

What happens to invoices that are genuinely still unpaid?

They stay logged in Notion as unmatched until a matching Kotak transaction appears, so nothing gets marked paid by mistake.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.