Reconcile percentage rent charges against your FinQuery records automatically
Each month, WebRun opens FinQuery and pulls the variable percentage rent recorded for each qualifying lease, retrieves the corresponding gross sales figures from your tracking sheet in Google Sheets, recalculates the contractual percentage rent amounts, compares them to what FinQuery has recorded, and posts any discrepancies to Slack with a reconciliation summary for your controller to review before approving any payment.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically reconcile percentage rent charges against FinQuery records each month?
WebRun pulls the variable percentage rent amounts recorded in FinQuery each month, retrieves gross sales figures from your Google Sheets tracking log, recalculates each lease's contractual amount using the rate and breakpoint, compares recorded to recalculated, and posts a reconciliation summary to Slack with any material discrepancies flagged for controller review before any payment is approved.
- Percentage rent discrepancies caught before any payment is remitted
- Recalculation from contractual terms done automatically each month
- Controller reviews a clear comparison before approving any variable rent payment
Built for retail lease accountants · corporate controllers · real estate finance teams · lease administrators
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.finquery.comin a real browser with your saved login - no setup, no API keys. -
1
FinQuery - pull recorded percentage rent amounts
finquery.com How to Automate FinQuery
WebRun opens FinQuery to pull recorded percentage rent amounts. - Open FinQuery and navigate to the variable lease payment report
- Pull the percentage rent amounts recorded for each lease in the current period
- Capture the lease name, location, contractual percentage rate, and the breakpoint amount for each
Done when All recorded percentage rent amounts and contract terms are captured from FinQuery.
-
2
Google Sheets - compare to gross sales and recalculate
google.com How to Automate Google Sheets
WebRun opens Google Sheets to compare to gross sales and recalculate. - Open the monthly gross sales tracking sheet
- Pull the gross sales figure for each location in the current period
- Recalculate the percentage rent due for each lease using the contract rate and breakpoint
- Compare the recalculated amount to the FinQuery recorded amount
- Flag any variance above your tolerance threshold
Done when Every lease has a recalculated amount, a recorded amount, and a variance calculation in the sheet.
-
3
Slack - post reconciliation summary and flag discrepancies
slack.com How to Automate Slack
WebRun opens Slack to post reconciliation summary and flag discrepancies. - Post a reconciliation summary to the lease-accounting channel with total percentage rent recorded, total recalculated, and net variance
- List each lease with a material discrepancy by name, with recorded and recalculated amounts
- Note that payment approval is required before any variable rent is remitted
Done when The controller has a Slack summary of the reconciliation with any discrepancies flagged.
How is each run configured?
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.
Every action is checked against this policy before it runs.
Questions, answered
Will it approve or submit any percentage rent payment automatically?
No. WebRun reconciles and flags discrepancies for your controller to review. Any payment approval or remittance is a human step and nothing is paid without explicit sign-off.
Where does it get the gross sales figures?
It reads the gross sales figures from your Google Sheets tracking log, which your team or store managers update each month. The reconciliation runs once those figures are in the sheet.
What if the lease has a natural breakpoint rather than an artificial one?
You configure the breakpoint type and amount for each lease during setup. WebRun applies the correct calculation whether the breakpoint is natural, artificial, or tiered.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.