All templates

FinQuery Automated ASC 842 Disclosure Prep Report

Each quarter, WebRun opens FinQuery and pulls the quantitative disclosure tables required under ASC 842: lease cost summary, maturity analysis, weighted-average rate and term, and variable lease payments. It writes the data to a structured Google Sheet, flags any missing or incomplete cell, and notifies your reporting team in Slack that the disclosure prep package is ready for review.

Deploy this workflow Browse all templates
Runs on WebRun · Strict Lockdown policy
On the 5th business day after each quarter ends WebRunorchestrates each step
1 FinQuery pull disclosure tables and quantitative data
2 Google Sheets assemble structured disclosure prep report
3 Slack notify reporting team the package is ready
In short

How do I automatically prepare the ASC 842 lease disclosure package from FinQuery?

WebRun opens FinQuery each quarter, pulls all required ASC 842 quantitative disclosure tables including lease cost, maturity analysis, weighted-average rates, and cash flow disclosures, writes them to a structured Google Sheet workbook with gap flags, and notifies your reporting team in Slack with the package link and filing deadline.

  • Quarterly disclosure package assembled in hours, not days
  • Data gaps flagged before they become last-minute audit findings
  • Reporting team notified with package link and filing deadline on the same run

Built for external reporting teams · lease accountants · corporate controllers · public company 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 disclosure tables and quantitative data
    finquery.com
    WebRun in FinQuery: pull disclosure tables and quantitative data
    WebRun opens FinQuery to pull disclosure tables and quantitative data.
    • Open FinQuery and navigate to the disclosure report for the current quarter
    • Export the lease cost table: operating, finance interest, finance amortization, short-term, and variable
    • Export the maturity analysis table for operating and finance leases
    • Capture weighted-average remaining lease term and discount rate for each lease type
    • Note any supplemental cash flow disclosure amounts: cash paid for operating leases and ROU assets obtained

    Done when All required quantitative ASC 842 disclosure data is captured for the quarter.

  3. 2
    Google Sheets - assemble structured disclosure prep report
    google.com
    WebRun in Google Sheets: assemble structured disclosure prep report
    WebRun opens Google Sheets to assemble structured disclosure prep report.
    • Open the quarterly disclosure prep workbook
    • Paste each disclosure table into the relevant labeled tab
    • Flag any cell that is blank or shows a formula error
    • Add a cover tab with the period, preparer name placeholder, and a completion checklist

    Done when The disclosure prep workbook is populated, flagged for gaps, and ready for accountant review.

  4. 3
    Slack - notify reporting team the package is ready
    slack.com
    WebRun in Slack: notify reporting team the package is ready
    WebRun opens Slack to notify reporting team the package is ready.
    • Post a notification to the reporting channel that the disclosure prep package is ready
    • Include a link to the Google Sheet and a count of any flagged cells needing attention
    • Note the upcoming filing deadline date

    Done when The reporting team is notified with the package link and deadline reminder.

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
On the 5th business day after each quarter ends
DeliveryHow each run's result reaches you
Disclosure prep package · Google Sheets · Slack notification
OutputWhat each run produces - A populated Google Sheet disclosure prep workbook with all ASC 842 quantitative tables, flagged gaps, and a completion checklist, plus a Slack notification with the deadline.
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 file any disclosure or submit anything to the SEC or auditors?

No. WebRun assembles the data in a Google Sheet for your team to review and format for the final filing. Nothing is filed or submitted externally without your approval.

Does it cover IFRS 16 disclosures as well as ASC 842?

Yes. If your portfolio includes IFRS 16 leases, WebRun pulls the IFRS 16 disclosure tables from FinQuery in the same run and adds them to separate tabs in the workbook.

What if some disclosure data is missing from FinQuery?

It flags every blank cell and missing table in the workbook and counts the gaps in the Slack notification, so your team knows exactly what needs manual input before the package is complete.

Keep going

Related templates

FinQuery Automated Lease Audit Evidence Packets
WebRun pulls the journal entries, amortization schedules, and disclosure reports from FinQuery for each selected lease, organizes them into a structured Google Sheet evidence packet, and queues a delivery email to your audit team for review before sending.
FinQuery›Google Sheets›Gmail
FinQuery Automated Lease Critical Date Reminders
WebRun scans FinQuery each morning for upcoming lease critical dates including options, terminations, rent steps, and notice deadlines, and sends timely reminders to the right owner via Slack so no date slips through.
FinQuery›Slack
Automated Embedded Lease Identification for ASC 842
WebRun scans newly uploaded vendor agreements and service contracts for embedded lease language, flags any that appear to contain a right-of-use element, and routes them to your lease accounting team in FinQuery for formal assessment.
FinQuery›Google Sheets›Slack

Put this on autopilot.

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

Deploy this workflow Talk to us