How to Automate FinQuery

FinQuery automates the lease subledger itself. Automated abstracts pull terms out of an agreement, journal entries and amortisation schedules follow under ASC 842 or IFRS 16, and disclosure reports come out of the same record. Getting the documents and the sales figures in, from the people holding them, is still manual.

Every signed lease becomes a schedule somebody has to defend

FinQuery, known for years as LeaseQuery, is the subledger that sits between a company's contracts and its general ledger. A lease gets signed by somebody in property or procurement, and from that moment it is an accounting object: a right-of-use asset, a liability, a payment schedule, a set of disclosures that will appear in the financial statements.

The people using it are accountants at companies with more contracts than a spreadsheet can honestly carry, and the firms that audit them. Alongside lease accounting the company sells modules for debt, for accruals and prepaids, for financial contract management and for GASB 96 in the public sector.

What makes this different from most finance software is who reads the output. Not a manager looking for a trend. An auditor, working through a sample, asking why this lease was classified this way and where the evidence for it is.

The schedule has to be right, and it has to still be defensible eighteen months later.

Close week is spent chasing paper other people hold

The accountant responsible for leases rarely has a lease problem. They have a document problem.

A store signs a five-year lease and the executed copy sits in a property manager's inbox for a month. A percentage-rent clause needs this quarter's gross sales, which live in the point-of-sale system somebody else runs. A landlord sends a common-area maintenance reconciliation that does not match the schedule, as a PDF, in the post. A vendor agreement for warehouse space contains an embedded lease nobody flagged, because operations signed it as a service contract.

So the close involves a run of emails asking people to send things, then a run of follow-ups because they did not.

Meanwhile the notice window on a lease the company wants out of is counting down inside a folder nobody has opened since the day it was abstracted.

The finquery.com homepage, the app these three jobs run in. FinQuery
Notice windows that do not slip Options, terminations and rent steps counted down daily, so a renewal is a decision rather than an accident.
Percentage rent checked against sales The landlord's calculation compared with the figures from your own till system before any payment is approved.
The close watched before it locks Entries posted, disclosures generated and anything still outstanding named on the day, not in the review afterwards.

FinQuery builds the schedules and generates the disclosures

Inside its own four walls the platform is thorough, and a team that has not configured all of it should start there.

Automated lease abstracts pull the terms out of an uploaded agreement, so the record does not begin with manual typing. From that record come journal entries and amortisation schedules under ASC 842, IFRS 16, GASB 87 and the rest, with dual-standard reporting where a company reports under two. Quantitative disclosure reports are generated from the same data, so the note in the statements is not built by hand. Critical date reminders fire on options, terminations and rent steps. A document repository holds the agreements, and read-only auditor access lets the audit team look without anyone exporting anything.

Every one of those acts on a lease that is already in FinQuery. That is the wall.

The lease that has not been abstracted is invisible to it. So is the sales figure a variable payment needs, the landlord's reconciliation statement, the procurement contract with a right-of-use element buried in clause nine, and the fact that the store closed in March. A critical date reminder only fires for a date somebody remembered to enter.

Critical dates can arrive with their evidence attached

A date that fires on its own is worth less than a date somebody went out and confirmed.

Every lease with a notice window inside ninety days, listed each morning with the option, the deadline and the person who has to decide, so an automatic five-year renewal is a choice rather than an accident.

The percentage-rent charge worked out against real sales figures read from the till system, before the payment is approved rather than after the landlord's version has been paid. Landlord reconciliation statements collected from the property portal and lined up against what the schedule assumes, with the difference named.

Newly executed agreements in the shared drive checked against what has actually been abstracted, so a signed lease is not sitting unrecorded through a reporting period. Vendor contracts read for right-of-use language and routed to the lease team when they look like an embedded lease, which is exactly the thing that turns up in an audit.

The line here is firm. Assembling evidence and flagging an exception is clerical. Deciding that a lease is finance rather than operating, or that an asset is impaired, is an accounting judgement with a person's name against it.

The accountant keeps the judgement, not the legwork

The sales figures, the statements and the signed copies all have to be fetched before any of that judgement can be exercised. Fetching is most of the week, and it is the part nobody trained for.

WebRun is an AI agent that works a real Chrome browser, signed in as you. It opens FinQuery, the property portal, the till system and the drive where executed leases land, reads what each says, and brings back the comparison with the exceptions at the top.

It runs on your schedule in your own private environment, and you can watch a run and stop it. Nothing is reclassified, no journal entry is posted, and no message goes to a landlord without a person approving it.

The workflows below are already built, and each one names what it opens.

Questions people ask

Will it post journal entries or change a lease classification?

No. It reads and prepares. Classification, impairment and anything that posts to the ledger stay with the accountant who signs off, because those are the judgements an auditor asks about by name.

Is this useful if we already run FinQuery properly?

Yes, because the work it does sits outside FinQuery. The gap is rarely the schedules. It is the executed lease still in somebody's inbox and the sales figure a variable payment needs.

Our landlord portal needs a one-time code. Does that break it?

No. A login needing a code needs a person the first time, and the session is reused afterwards, so the interruption is occasional rather than part of every run.

13 ready-made FinQuery workflows

Each one names the apps it touches and the exact steps it takes. Open one to read what it will do, then turn it on.

FinQuery Automated Percentage Rent Reconciliation
WebRun pulls your variable percentage rent charges from FinQuery, compares them to the gross sales figures in your tracking sheet, recalculates the amounts due, flags any discrepancy, and queues a reconciliation summary for your controller to review before any payment is approved.
FinQueryGoogle SheetsSlack
FinQuery Automated Payment Schedule Change Alerts
WebRun monitors FinQuery for any modification to a lease payment schedule, compares the new amounts to the previous plan, and alerts your accounting team in Slack before the next journal entry run.
FinQuerySlack
FinQuery Automated New Lease Abstraction Kickoff
WebRun reads a newly executed lease agreement, extracts the key accounting terms, pre-fills the FinQuery lease abstraction form with commencement date, lease term, payment schedule, and options, and creates a draft record for your accountant to review and finalize.
FinQueryGoogle SheetsSlack
FinQuery Automated Lease Accounting Month-End Close
WebRun works through your FinQuery month-end checklist each close, verifies journal entries are posted, disclosures are generated, and flags any incomplete step to your team in Slack before the books lock.
FinQuerySlack
FinQuery Automated Lease Modification Review Queue
WebRun scans FinQuery for lease modifications that have been entered but not yet reviewed and approved, surfaces the queue in a Google Sheet ranked by impact, and sends your team a weekly digest.
FinQueryGoogle SheetsSlack
FinQuery Automated Missing Lease Document Chaser
WebRun reviews your FinQuery portfolio for leases with incomplete document attachments, drafts a polite follow-up to the responsible contact for each gap, and queues every draft for your review before sending.
FinQueryGmailSlack
Automated FinQuery Lease Renewal Tracking
WebRun scans your FinQuery portfolio each week, flags leases whose renewal windows are approaching, and posts a prioritized deadline list to Slack so your team never misses a critical notice date.
FinQuerySlack
FinQuery Automated ROU Asset Impairment Review Flags
WebRun scans your FinQuery portfolio each quarter for ROU assets that have experienced triggering events such as early termination notices, unused space, or significant lease modifications, and posts a prioritized impairment review flag list to Slack.
FinQuerySlack
FinQuery Automated Lease Expense Variance Digest
WebRun pulls the current period lease expense totals from FinQuery, compares them to the prior period and budget, flags any significant variance, and sends your finance team a weekly digest in Slack.
FinQuerySlack
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.
FinQueryGoogle SheetsSlack
FinQuery Automated ASC 842 Disclosure Prep Report
WebRun pulls the required quantitative and qualitative disclosure data from FinQuery each quarter, assembles a structured disclosure prep report in Google Sheets, and notifies your team so the external reporting package is ready ahead of the filing deadline.
FinQueryGoogle SheetsSlack
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.
FinQuerySlack
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.
FinQueryGoogle SheetsGmail

Want one of these running on your own FinQuery?

Show WebRun the process once and it will run it on schedule, in your own private browser environment.