All templates

Automated Trovata Covenant Liquidity Monitoring

Every morning, WebRun opens Trovata, reads current cash and available liquidity data, calculates each covenant liquidity ratio your agreements require, compares the results against covenant thresholds, and updates a Google Sheet watchlist flagging any ratio within your warning buffer or in breach.

Deploy this workflow Browse all templates
Runs on WebRun · Strict Lockdown policy
Every day at 7:30 AM WebRunorchestrates each step
1 Trovata pull cash and liquidity data for ratio calculation
2 Google Sheets update covenant watchlist with current ratios and status
In short

How do I automatically monitor debt covenant liquidity ratios every day?

WebRun opens Trovata every morning, pulls cash and available liquidity across all connected entities, calculates each debt covenant liquidity ratio using your configured formulas, and updates a Google Sheet watchlist with current ratios, headroom, and a traffic-light status, so your team sees any approaching breach before it becomes a default event.

  • Covenant liquidity ratios refreshed every morning without manual calculation
  • Amber and Red status flags visible in Google Sheets before the team starts work
  • Historical ratio log helps identify trends toward covenant stress early

Built for corporate treasury teams · CFOs · finance directors · debt capital market 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.trovata.io in a real browser with your saved login - no setup, no API keys.

  2. 1
    Trovata - pull cash and liquidity data for ratio calculation
    trovata.io
    WebRun in Trovata: pull cash and liquidity data for ratio calculation
    WebRun opens Trovata to pull cash and liquidity data for ratio calculation.
    • Open Trovata and read available cash, restricted cash, and credit facility availability for all connected entities
    • Pull the relevant balance totals required to compute each covenant ratio defined in your setup
    • Calculate each ratio using the formula configured for that covenant

    Done when All covenant liquidity ratios are calculated using today's Trovata data.

  3. 2
    Google Sheets - update covenant watchlist with current ratios and status
    google.com
    WebRun in Google Sheets: update covenant watchlist with current ratios and status
    WebRun opens Google Sheets to update covenant watchlist with current ratios and status.
    • Open the Covenant Liquidity Watchlist spreadsheet
    • Update each covenant row with today's calculated ratio, threshold, and headroom
    • Set status to Green, Amber (within 10% of threshold), or Red (at or below threshold)
    • Add a timestamp and note for any status change from the prior day

    Done when The watchlist reflects today's ratios with current traffic-light statuses.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.trovata.io
ScheduleRuns automatically on this cadence
Every day at 7:30 AM
DeliveryHow each run's result reaches you
Covenant watchlist · Google Sheets
OutputWhat each run produces - A daily-updated Google Sheet covenant liquidity watchlist with current ratios, thresholds, headroom, and traffic-light status for each covenant.
Watchlist
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 notify anyone when a ratio goes Amber or Red?

You can optionally add a Slack or Telegram notification step during setup. By default WebRun updates the Google Sheet only, so your team reviews it as part of the morning routine. Add an alert channel if you need an immediate ping on status changes.

What if my covenant formula is complex, such as a net debt to EBITDA ratio?

During setup, tell WebRun your exact covenant formula and which Trovata data fields map to each input. It will apply the formula faithfully on every run. More complex ratios that require ERP data outside Trovata may need an additional data connection.

Does it file any compliance reports or notify the lender?

No. Notifying a lender or filing a compliance certificate is an external communication requiring human review. WebRun tracks ratios internally only. Any lender communication must be prepared and sent by your team.

Keep going

Related templates

Automated Trovata Account Signatory Review Tracker
Every month, WebRun cross-references your Trovata account list against your signatory register in Google Sheets and flags any account whose authorized signers have not been reviewed in the past year, or where a signer no longer matches your current roster.
Trovata›Google Sheets
Automated Trovata Bank Fee Anomaly Detection
Every week, WebRun scans your Trovata transaction data for bank fees that are higher than usual or appear on accounts that rarely incur charges, logs the anomalies in Google Sheets, and pings your team to review.
Trovata›Google Sheets›Slack
Automated Trovata Cash Forecast Variance Digest
Every Monday, WebRun compares last week's Trovata cash forecast against actual bank movements, summarizes the variances by entity and category, and drops a digest into your treasury Slack channel so you can refine the model.
Trovata›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