All templates
For lease accountants, real estate finance teams & corporate controllers

Abstract a new lease into FinQuery without the data entry slog

When a new executed lease agreement is added to your intake tracker in Google Sheets, WebRun reads the document, extracts key accounting terms including commencement date, lease term, base rent schedule, renewal options, and incremental borrowing rate, pre-fills the FinQuery new lease record with those values as a draft, and posts a Slack notification so your accountant can review and finalize the abstraction.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
When triggered by a new entry in the intake tracker WebRun
1 Google Sheets detect new lease in intake tracker
2 FinQuery pre-fill new lease abstraction as draft
3 Slack notify accountant to review and finalize
Run a sample
In short

How do I automatically abstract a new lease into FinQuery from an executed agreement?

WebRun detects new lease agreements in your Google Sheets intake tracker, extracts commencement date, lease term, payment schedule, and options from each, pre-fills a draft lease abstraction record in FinQuery, and notifies the responsible accountant in Slack with a direct link to review and finalize before any journal entries are generated.

  • New lease in FinQuery as a draft within minutes of execution
  • Accountant notified with a direct link for same-day review
  • Unusual terms flagged automatically so nothing is missed in abstraction

Built for lease accountants · real estate finance teams · corporate controllers · lease administrators

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
    Google Sheets - detect new lease in intake tracker
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: detect new lease in intake tracker
    WebRun opens Google Sheets to detect new lease in intake tracker.
    • Open the lease intake tracker in Google Sheets
    • Identify any new lease agreements added since the last run
    • Extract the document link and key data fields: property name, lessee, lessor, commencement date, lease term, base rent schedule, renewal options, and termination options

    Done when New lease agreements are identified and key accounting terms are extracted from the intake record.

  3. 2
    FinQuery - pre-fill new lease abstraction as draft
    finquery.com How to Automate FinQuery
    WebRun in FinQuery: pre-fill new lease abstraction as draft
    WebRun opens FinQuery to pre-fill new lease abstraction as draft.
    • Open FinQuery and start a new lease abstraction record
    • Enter the extracted commencement date, lease term, and payment schedule into the relevant fields
    • Enter renewal and termination options, lease classification inputs, and incremental borrowing rate if provided
    • Save the record as a draft. Do not finalize or generate journal entries without accountant review

    Done when A draft lease record is saved in FinQuery with all extracted fields populated, awaiting accountant review.

  4. 3
    Slack - notify accountant to review and finalize
    slack.com How to Automate Slack
    WebRun in Slack: notify accountant to review and finalize
    WebRun opens Slack to notify accountant to review and finalize.
    • Post a notification to the lease-accounting channel that a new draft lease record is ready in FinQuery
    • Include the property name, commencement date, and a direct link to the draft record
    • Tag the accountant responsible for final review and abstraction sign-off

    Done when The responsible accountant is notified in Slack with a link to the draft FinQuery record.

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
When triggered by a new entry in the intake tracker
DeliveryHow each run's result reaches you
Draft lease record · FinQuery · Slack notification
OutputWhat each run produces - A draft FinQuery lease abstraction record with pre-filled accounting terms, plus a Slack notification to the responsible accountant for final review.
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 it finalize the lease record or generate journal entries automatically?

No. WebRun creates the record as a draft and stops. Your accountant reviews the pre-filled values, makes any corrections, and finalizes the abstraction in FinQuery before any journal entries are generated.

What if the lease has unusual terms like variable rent or subleases?

WebRun extracts the standard fields and flags any unusual term it detects, such as variable payments or sublease provisions, in the Slack notification so the accountant knows to pay close attention during review.

Does it set the incremental borrowing rate automatically?

It enters the rate provided in the intake tracker if one is specified. If no rate is given, it leaves the field blank and flags it in the Slack message so the accountant can apply the correct rate before finalizing.

Put this on autopilot.

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