All templates

FinQuery Automated Lease Modification Review Queue

Every Monday, WebRun opens FinQuery and pulls every lease modification in a pending or draft state, captures the modification type, affected lease, remeasurement impact, and age, writes the queue to a Google Sheet ranked by dollar impact, and posts a digest link to Slack so accountants know exactly what needs review this week.

Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 FinQuery pull pending modification queue
2 Google Sheets log queue ranked by impact
3 Slack post weekly digest link
In short

How do I automatically track and surface pending lease modifications in FinQuery?

WebRun opens FinQuery every Monday, pulls all pending lease modifications, captures the type, remeasurement impact, and days in queue for each, then writes the ranked list to a Google Sheet and posts a count-and-impact digest to Slack. Your team starts each week knowing exactly which modifications need review and approval.

  • Pending modifications ranked by dollar impact every Monday morning
  • Stale modifications older than 14 days flagged automatically
  • Zero modification surprises at month-end close

Built for lease accountants · accounting managers · corporate controllers · real estate finance teams

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

  2. 1
    FinQuery - pull pending modification queue
    finquery.com
    WebRun in FinQuery: pull pending modification queue
    WebRun opens FinQuery to pull pending modification queue.
    • Open FinQuery and navigate to the modifications section
    • Filter for all modifications in a pending or draft state
    • Capture lease name, modification type, effective date, remeasurement impact on liability, and days in queue for each

    Done when Every pending modification is captured with its impact and age.

  3. 2
    Google Sheets - log queue ranked by impact
    google.com
    WebRun in Google Sheets: log queue ranked by impact
    WebRun opens Google Sheets to log queue ranked by impact.
    • Open the Lease Modification Review tracker sheet
    • Clear the prior week's data and paste the current queue
    • Sort rows by absolute remeasurement impact, largest first
    • Add a column flagging any modification older than 14 days

    Done when The sheet is updated with this week's pending modification queue, ranked by impact.

  4. 3
    Slack - post weekly digest link
    slack.com
    WebRun in Slack: post weekly digest link
    WebRun opens Slack to post weekly digest link.
    • Post a short digest to the lease-accounting channel with the total count, total dollar impact, and a link to the sheet
    • Call out any modification older than 14 days by name

    Done when The team has a weekly digest with counts, impact, and a link to the full queue.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.finquery.com
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Modification queue · Google Sheets · Slack digest
OutputWhat each run produces - A Google Sheet with every pending FinQuery lease modification ranked by remeasurement impact, plus a Slack digest with totals and aging flags.
Spreadsheet
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 approve or finalize any modifications in FinQuery?

No. WebRun only reads the pending queue and surfaces it for your review. Approving or finalizing a modification is always a human action inside FinQuery.

What counts as a stale modification?

By default, any modification sitting in a pending state for more than 14 days is flagged. You can adjust this aging threshold during setup.

Does it cover all modification types, like terminations and extensions?

Yes. It captures all modification types recorded in FinQuery, including extensions, terminations, partial terminations, and scope changes, so the full queue is always visible.

Put this on autopilot.

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