The Scenario
It's end-of-quarter reconciliation and your crypto treasury report is due to the CFO by noon. You have 20 company wallet addresses in your 'Wallets' worksheet — address in column A, network in column B, last known balance in column C from three weeks ago, and the current balance column D is blank. The CFO wants current balances grouped by network and flagged empties before approving the quarter-end report.
The bad version:
- Copy the first address from column A, open a block explorer for the right network, paste the address, read the balance, flip back to the workbook, type the number into D2.
- Repeat for all 20 addresses across three different networks, switching block explorers between rows when the network changes.
- Finish row 20 and realize you weren't consistent about units — some balances are in ETH, some in Wei — and now you need to normalize them before the CFO can read the report.
Reconciling 20 wallets across multiple networks is a morning of context-switching that produces a report the CFO needed two hours ago.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the 'Wallets' worksheet, understands the addresses and networks, and through the Poof integration it fetches the current balance for each row, writes it into column D, and flags the empty ones — without you touching a block explorer.
Read the 20 wallet addresses in my Excel sheet and fetch the balance for each one via Poof, flagging any wallet with a zero balance in column D with the word 'Empty'.
What You Get
- Column D filled with the current balance for each wallet address.
- Any address that returns a zero balance flagged with 'Empty' in column D.
- A summary section at the bottom totaling balances grouped by the network values in column B.
- Any address that Poof cannot resolve flagged with an error note in column D.
What If the Data Is Not Quite Ready
Some addresses have formatting issues — extra spaces or mixed case
A few rows in column A have trailing spaces or inconsistent capitalization that could cause the balance lookup to fail.
For each row in my 'Wallets' worksheet, normalize the wallet address in column A by trimming whitespace and converting to lowercase, then use Poof to fetch the current balance and write it into column D. Flag any address that still fails after normalization with 'Invalid address' in column D.
Balances come back in token units but you need USD equivalent
You want column D in USD, not raw token amounts, so the CFO can read the totals directly.
For each wallet in column A of my 'Wallets' worksheet, fetch the current balance from Poof and convert it to USD using the current token price. Write the USD equivalent into column D and the raw token balance into column E. Sum the USD totals by network in a summary section below the data.
Wallets are split across two worksheets — main treasury and a reserve sheet
Your workbook has a 'Main Treasury' worksheet and a 'Reserve Wallets' worksheet with the same column layout.
For every wallet address in both my 'Main Treasury' and 'Reserve Wallets' worksheets, fetch the current balance via Poof and write it into column D of each respective sheet. Flag zero-balance wallets with 'Empty' in column E of each sheet.
The full reconciliation-plus-variance kill chain
You have last quarter's balances in column C, and the CFO wants to see both current balances and the change, with any wallet that dropped more than 50% since last quarter highlighted.
For each wallet in column A of my 'Wallets' worksheet, fetch the current balance from Poof and write it into column D. Calculate the change from the last known balance in column C and write the percentage change into column E. Flag any wallet where the balance dropped more than 50% with 'Variance alert' in column F, and flag zero-balance wallets with 'Empty' in column F as well. Add a network-level summary at the bottom.
Running the fetch, the comparison, and the flagging in one prompt gives the CFO a complete reconciliation without a separate analysis pass.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a list of blockchain wallet addresses — even if they span multiple networks or need a variance comparison against last quarter — and ask it to fetch balances and surface the empties in one pass. You can also see how SheetXAI handles looking up gas prices before batch payouts in Excel or return to the full Poof integration overview for Excel.