All templates

Automated ING Invoice Payment Reconciliation

Every morning, WebRun opens ING, pulls the latest incoming payments, matches each against your open invoice list in Google Sheets, and logs any invoice still unmatched as a task in Notion so late payers surface fast.

Runs on WebRun · Strict Lockdown policy
Every day at 7:30 AM WebRunorchestrates each step
1 ING pull incoming payments
2 Google Sheets match against open invoices
3 Notion log unmatched invoices
In short

How do I reconcile ING payments against my open invoices?

WebRun reconciles your ING account every morning by matching incoming payments against your open invoice list in Google Sheets and logging any still unmatched past their due date as a task in Notion. It never chases the customer or moves money itself, so late payers surface the same day instead of at month end.

  • Unpaid invoices surface the same morning, not at month end
  • Every incoming payment is matched or explained, not left ambiguous
  • Late payers get a Notion task before they're forgotten

Built for finance teams · bookkeepers · small business owners · accounts receivable

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.ing.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    ING - pull incoming payments
    • Open ING online banking and pull the latest incoming payments
    • Capture the amount, sender, and reference for each
    • Note the date each payment landed

    Done when Every incoming payment is captured with its reference.

  3. 2
    Google Sheets - match against open invoices
    google.com
    WebRun in Google Sheets: match against open invoices
    WebRun opens Google Sheets to match against open invoices.
    • Open the invoice tracker and match each payment to an invoice
    • Mark invoices as paid once matched
    • Leave unmatched invoices highlighted

    Done when Every payment is matched or the invoice is flagged unpaid.

  4. 3
    Notion - log unmatched invoices
    notion.so
    WebRun in Notion: log unmatched invoices
    WebRun opens Notion to log unmatched invoices.
    • Log a task for every invoice still unmatched past its due date
    • Include the customer and amount owed
    • Leave the follow up to your team

    Done when Every unmatched overdue invoice has a task in Notion.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.ing.com
ScheduleRuns automatically on this cadence
Every day at 7:30 AM
DeliveryHow each run's result reaches you
Reconciliation log · Google Sheets
OutputWhat each run produces - A reconciled invoice list with unmatched, overdue invoices logged as tasks in Notion.
Report
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 it chase the customer or send a payment reminder itself?

No. WebRun never sends a payment, issues a refund, or transfers funds on its own. It only matches records and flags unpaid invoices, leaving any customer contact to your team.

How does it match a payment to an invoice?

It compares the amount and reference on each incoming ING payment against your open invoice list, so a match only happens when both line up.

What happens once an invoice is paid?

The next run reads the live payment data from ING and marks the invoice as matched, so it drops off the unmatched list automatically.

Put this on autopilot.

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