Start every week knowing your cash and runway
Every Monday, one email with your Mercury cash, monthly burn and months of runway, last week's money in and out, and where it went.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1MercuryList accountsReads your Mercury checking and savings accounts, their settled balances and how far back your Mercury history goes.
- 2MercuryList treasury accountsReads your Mercury Treasury balance, so cash includes money held there.
Repeats while
morePagesis true- 3MercuryList transactionsReads every completed and pending transaction from the last three full months to today, page by page, so burn counts every payment.
- 3
- 4GmailSendEmails the report: cash, runway and burn in the subject line, then last week, where the money went, the largest payment in and balances.
How it works
What happens on each run, in plain English.
Cash, burn and runway usually get checked only when someone logs into the bank and builds a spreadsheet, so it happens rarely and surprises arrive late. Every Monday at 07:00 this reads your Mercury accounts and sends one email that leads with the numbers that matter: cash, months of runway and monthly burn. Under them come last week's money in and money out against the average of the four weeks before, the five places most money went, the largest payment in, and the balance of every account, Treasury included.
Burn is money out minus money in, averaged over the last three full months, and runway is cash divided by burn, rounded down. A company bringing in more than it spends is told it is cash-flow positive instead. Moves between your own Mercury accounts and failed, cancelled or reversed payments are left out, and payments still pending are taken off cash straight away. With less than a full month of history the email says so rather than guessing. If Mercury cannot be read, no email is sent and the run is marked as failed, so a partial figure never reaches your inbox.
You need Mercury and Gmail connected, and the email address the report should go to.
You may also be interested in
Email last month's profit and loss for each departmentOn the 3rd of each month, emails you last month's profit and loss for each department, or for the whole business, with AI commentary.Weekly revenue up-or-down emailEvery Monday, totals last week's revenue from your sheet, says if it is up or down on the week before, and explains a rise.
Never miss a filing or renewal deadlineChecks your deadline sheet each morning and emails you as each licence, permit, tax filing or renewal comes due, with a calendar event.
Chase overdue QuickBooks invoicesEmails customers a polite reminder with the invoice attached at 3, 14 and 30 days overdue, and sends you a morning summary of what's owed.Start from a workflow that already works.
Add "Start every week knowing your cash and runway" to your workspace, connect its apps, and make it yours.
Free plan, no credit card