The Scenario
It's Monday and the board packet goes out Wednesday. The CFO needs a liquidity table: every Mercury account, its current balance, and the total across all accounts. Last time, someone opened Mercury, wrote down seven numbers, opened the board deck Excel template, typed the numbers in, realized two accounts were missing, went back to Mercury, and updated. Two of the seven numbers were from the prior business day because Mercury updates balances overnight and the pull happened at the wrong time.
The bad version:
- Open Mercury, navigate to each account one at a time, note the current balance
- Switch to Excel, find the liquidity tab, type each balance into the corresponding row
- Write a SUM formula manually, then verify you haven't missed a treasury account
The board meeting is Wednesday. The deck gets printed Tuesday afternoon. A balance that is off by $14,000 because someone pulled from the wrong account is not an acceptable variance.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your workbook and connects to Mercury, pulling all accounts — checking, savings, treasury — with current balances into the workbook in one call.
Fetch all Mercury accounts and all treasury accounts, write them into Sheet1 (checking/savings) and Sheet2 (treasury) respectively with name and balance, then write the combined total into cell A1 of Sheet3
What You Get
- Sheet1: checking and savings accounts — one row per account with name and current balance
- Sheet2: treasury accounts — same structure
- Sheet3, cell A1: sum of all balances across both sheets, ready to reference in the board deck
What If the Data Is Not Quite Ready
The board wants balances as of a specific date, timestamped
Pull all Mercury accounts and write their current balances into column B alongside account names in column A, then write today's date formatted as 'Balances as of YYYY-MM-DD' into cell D1 for the deck timestamp
I want to append this week's balances as a new row for trend tracking
Fetch all Mercury account balances, find the first empty row in this workbook, and write today's date in column A and the total balance across all accounts in column B — preserve all previous rows above
Flag accounts where the balance has dropped below a threshold
Pull all Mercury accounts and write account name and current balance into columns A and B, then in column C write 'LOW BALANCE' for any account where the current balance is below the threshold I'll enter in cell D1
Full board prep in one pass: accounts by type, totals, week-over-week comparison
Pull all Mercury checking, savings, and treasury accounts into separate worksheets with name and balance, write a combined total in Sheet3 cell A1, and in column C of each worksheet calculate the difference between the current balance in column B and the prior-week balance I'll type in column D
One prompt produces the board-ready workbook structure without building it tab by tab.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook you use for board liquidity reporting, then ask it to pull your Mercury account balances. For the full Mercury integration picture, see the hub overview.