The Scenario
A financial advisor you work with has a client annual review in three hours. The client has accounts at four different institutions, all connected via MX: a checking account, two savings accounts, a brokerage, and two credit cards. Your Excel workbook has the client's MX user GUID in cell A1. Everything else is blank.
The presentation needs a net worth figure on the first slide. Your firm's template pulls it from cell B2 of this workbook. Right now cell B2 is empty.
The bad version:
- Call the MX API for the user's member connections, record four member GUIDs, then call list-accounts for each member separately.
- Flatten the responses manually — checking and savings go in the asset section, credit cards in the liability section, brokerage in a third category with its own subtotal logic.
- Type in formulas for total assets, total liabilities, and net worth, knowing that if the advisor adds another account next quarter, the ranges will be wrong.
Three hours is enough time if nothing goes wrong. Nothing ever goes exactly right.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that runs inside your Excel workbook. It reads the user GUID already in your workbook, connects to MX Technologies, and writes the full account list with a net worth calculation in one operation.
Fetch all MX accounts for user USR-abc123 and write account name, account type, institution, and balance to columns A through D — then in row 1 of a Summary worksheet show net worth as assets minus liabilities.
What You Get
- One row per account across all member connections.
- Column A: account name.
- Column B: account type (checking, savings, credit card, investment, loan).
- Column C: institution name.
- Column D: current balance.
- Summary worksheet, row 1: total assets, total liabilities, and net worth as a single calculated value.
What If the Data Is Not Quite Ready
Some accounts returned with a null balance
Fetch all accounts for MX user USR-abc123 and write account name, type, institution, and balance to columns A through D — for any account where balance is null, write 0 and flag the row in column E with "Balance unavailable".
You need accounts grouped by type with subtotals for the presentation
Fetch all accounts for MX user USR-abc123 and write to Sheet1 grouped by account type — include account name, institution, and balance per row, then add a subtotal row for each type group. In the Summary worksheet show total assets, total liabilities, and net worth.
You need to compare current balances to a prior-quarter snapshot in a separate worksheet
Fetch all accounts for MX user USR-abc123 and write account name, type, and current balance to columns A, B, C in Sheet1 — in column D look up the account name in the Q4 Snapshot worksheet using account name as the key and write the prior balance — in column E show the change.
You want to pull all accounts, calculate net worth, flag stale balances, and write the full comparison against last quarter in one pass
Fetch all accounts for MX user USR-abc123 and write account name, type, institution, balance, and last-updated date to columns A through E — flag any account with a last-updated date older than 3 days in column F — in column G look up last quarter's balance from the Prior Quarter tab and show the change — in a Summary worksheet show total assets, total liabilities, net worth, and number of stale accounts.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook containing a client's MX user GUID, then ask it to pull all account balances and calculate net worth for the review. For pulling the transaction history behind those balances, see the transaction pull article.