All templates

Automated Trovata Intercompany Funding Tracker

Every morning, WebRun checks Trovata for intercompany funding requests that were expected to settle by now but have not, logs each overdue item in a Google Sheet with the entities involved and the amount, and pings the responsible person in Slack to chase the transfer.

Runs on WebRun · Strict Lockdown policy
Every day at 8:30 AM WebRunorchestrates each step
1 Trovata identify overdue intercompany funding requests
2 Google Sheets log overdue items with entity and amount details
3 Slack alert responsible team member to follow up
In short

How do I automatically track and chase overdue intercompany funding requests?

WebRun checks Trovata every morning for intercompany funding requests that were due to settle but have not, logs each overdue item in a Google Sheet with the sending and receiving entities and expected amount, and posts a Slack alert to the responsible treasury team member so funding gaps are chased before they delay subsidiary operations or payments.

  • Overdue intercompany transfers flagged every morning before they stall operations
  • Responsible owners alerted in Slack with full context to act immediately
  • Historical log in Google Sheets tracks resolution and aging over time

Built for group treasury teams · CFOs · finance controllers · shared service centers

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 - identify overdue intercompany funding requests
    trovata.io
    WebRun in Trovata: identify overdue intercompany funding requests
    WebRun opens Trovata to identify overdue intercompany funding requests.
    • Open Trovata and navigate to intercompany transaction activity
    • Identify funding requests that were due to settle on or before today and have not yet appeared as confirmed receipts
    • Capture the sending entity, receiving entity, expected amount, and due date for each overdue item

    Done when All overdue intercompany funding requests are identified with full details.

  3. 2
    Google Sheets - log overdue items with entity and amount details
    google.com
    WebRun in Google Sheets: log overdue items with entity and amount details
    WebRun opens Google Sheets to log overdue items with entity and amount details.
    • Open the Intercompany Funding Tracker spreadsheet
    • Add a row for each overdue item not already present, with status set to Overdue
    • Update the last-checked date for items already in the log

    Done when Every overdue funding request is recorded in the tracker.

  4. 3
    Slack - alert responsible team member to follow up
    slack.com
    WebRun in Slack: alert responsible team member to follow up
    WebRun opens Slack to alert responsible team member to follow up.
    • Post a Slack message to the treasury channel listing the overdue items by entity pair and amount
    • Tag the responsible owner if defined in the tracker, or post to the general treasury channel

    Done when The team is alerted and has all the context needed to chase the funding.

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 8:30 AM
DeliveryHow each run's result reaches you
Overdue funding list · Google Sheets · Slack
OutputWhat each run produces - A Google Sheet log of overdue intercompany funding requests with entity details, plus a daily Slack alert to responsible owners.
Worklist
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 initiate the transfer if funding is overdue?

No. Moving money between entities is a financial action that requires human approval. WebRun identifies the overdue items and alerts the responsible person; the transfer itself is always initiated by a human.

How does it know which requests are expected?

WebRun uses the intercompany transaction history and expected settlement dates visible in Trovata. You can also provide a schedule of recurring funding amounts and dates during setup to improve detection accuracy.

What if a transfer settled but Trovata has not yet updated?

WebRun checks the confirmed receipt in Trovata. If a settlement appears later in the day, you can mark the item as Resolved in the Google Sheet and it will not re-alert tomorrow.

Put this on autopilot.

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