The Scenario
The bookkeeper sent a message at 8 AM: she needs all Q1 transactions from Mercury before the reconciliation call at 10. Not a summary — every transaction, with date, description, amount, category, and status. Last quarter you exported a CSV from Mercury, opened it in Excel, deleted the extra header row, reformatted the date column from text to date, and pasted it into the master workbook. It took 45 minutes and you still missed 12 transactions from the secondary account because you forgot to switch accounts before exporting.
The bad version:
- Log into Mercury, set the date filter to January 1 through March 31, export CSV from the primary account, repeat for the savings account
- Open both CSVs in Excel, reconcile the column headers, stack the rows, reformat the dates from the Mercury export format to Excel date format
- Paste into the master workbook, manually verify the row count against Mercury's transaction badge to confirm nothing got cut off
The reconciliation call is in two hours. Rebuilding this export sequence every quarter is not a sustainable use of a morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects directly to Mercury and pulls transaction data into your workbook — paginating through every page automatically, across all your accounts, without you managing a single CSV.
Get all Mercury transactions with status 'sent' from the last 90 days across all accounts and load them into this Excel sheet sorted by date ascending — include account name, transaction ID, description, and amount
What You Get
- Column A: transaction date as an Excel date value
- Column B: Mercury account name so you know which account each transaction belongs to
- Column C: Mercury transaction ID for reference
- Column D: transaction description (payee name or memo)
- Column E: amount as a number, negative for debits
- Sorted by date ascending — oldest first — so the bookkeeper can reconcile chronologically
What If the Data Is Not Quite Ready
The date column imports as text and breaks Excel sorting
Pull all Mercury transactions from Q1 2025 into columns A through E, then in column F apply a date conversion so column A values become proper Excel date serial numbers for sorting and filtering
I need only sent transactions, not pending or failed
Pull all Mercury transactions from January through March 2025, filter to only transactions with status 'sent', and write account name, transaction ID, description, and amount into columns A through D
I need transactions from two separate Mercury accounts in separate worksheets
Fetch all Q1 2025 transactions from Mercury account named 'Operations Checking' and write them into Sheet1, then fetch all Q1 2025 transactions from the account named 'Tax Reserve' and write them into Sheet2 — same columns: date, description, amount, status
Clean, filter, and summarize in one shot
Pull all Mercury transactions from Q1 2025 with status 'sent', write raw data into Sheet1 with date, description, amount, and category, then in Sheet2 write a unique list of categories with total spend per category sorted largest to smallest — exclude failed transactions
The underlying pattern: describe the cleanup filter and the summary structure together rather than running them as separate steps.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook you use for quarterly reconciliation, then ask it to pull your Mercury transactions for the period. Once the data is in, see the treasury dashboard spoke for pulling account balances into the same workbook.