AI & EVERYDAY MONEY
How to review a spending list with AI without connecting your bank
Use a small sanitized table, three prompts and spreadsheet checks to turn spending data into a useful review.
An AI money review starts with a small table. You supply the transactions, the spreadsheet adds them up, and the AI helps organize the list and suggest questions. You check the result before deciding what to do.
Here is a complete first exercise using fictional data from Your First AI Money Review, Compound Your Day's free starter kit.
1. Choose what you're reviewing
Use one period and one currency. Include spending as positive amounts and refunds as negative amounts. Exclude income, transfers between your own accounts, and credit-card repayments that would count the same purchases twice.
Keep a unique row ID for every transaction. If two charges look alike, keep both until you have checked them. Similar descriptions do not prove an error.
The example in the kit has 12 rows in USD. It is a small selected spending list, not a complete household budget.
2. Make a separate sanitized table
Keep your original statement private. Remove names, contact details, account/card/routing numbers, transaction reference IDs, identity/tax numbers, logins, passwords, security codes, statement headers, barcodes and QR codes.
Use consistent merchant aliases. Generalize sensitive descriptions and dates where needed. Keep only a new row ID, a useful date, an alias, a signed amount, a currency and a short non-identifying note.
Prefer a small typed table to a statement upload. A PDF can retain information you do not see. Review your AI provider's current privacy and retention controls before pasting. Sanitizing reduces exposure but does not guarantee anonymity. You can use the fictional data for the entire exercise.
Two of its rows look like this:
| ID | Description alias | Amount USD | What is known |
|---|---|---|---|
| T03 | Stream A | 12.99 | Billing cadence not checked |
| T10 | Stream A | 12.99 | Reason for second charge unknown |
3. Let formulas establish your control totals
Open the workbook's Fictional example tab. Its formula totals are:
| Measure | USD |
|---|---|
| Positive spending | 1,536.21 |
| Refunds, signed | -8.50 |
| Net spending | 1,527.71 |
| Food, after refund | 181.00 |
For your own copy, compare the workbook total with the same selected rows in your private source. A matching total helps, but you also need to check that the period and row coverage match. A spreadsheet can faithfully add up the wrong list.
4. Organize, flag, then act on verified facts
The kit contains three connected prompts.
First, organize the spending. Preserve every row ID and signed amount. Ask for a row table, category totals and missing-data questions. Compare the output with the spreadsheet before continuing.
Second, flag patterns as questions. Stream A appears twice at the same amount. That observation does not establish a duplicate payment, an unwanted subscription or fraud. The useful next check is to compare the invoices and billing periods. Merchant Q, another example row, stays unknown until the user identifies it.
Third, create an action list from what you personally verified. Keep unknown facts marked Check first. If no date is set, the AI should not invent one. An action remains incomplete until you record evidence that it happened.
The prompts cannot guarantee that a model follows every instruction. If it labels an unresolved question Ready, repeats a resolved issue or lists evidence to collect as if it already exists, correct the table. The original facts and your verification take precedence.
5. Save a checked result
Before closing the review, check:
- Every row ID and signed amount matches the input.
- Category totals and net spending match the spreadsheet to the cent.
- Observations, confirmed facts and open questions are clearly separated.
- Proposed actions reflect your needs and verified terms.
- Completed actions have actual evidence.
Save a dated private copy and choose your own next review date. No bank connection or automatic cancellation is needed to finish this exercise.
Get the free kit
Get Your First AI Money Review for the seven-page guide, blank/example workbook, three copyable prompts and checking checklist.
You need a PDF reader, an XLSX editor and your own AI chat that accepts pasted text. Spreadsheet calculations were checked in LibreOffice 26.8; other editors and named cloud AI services were not independently tested. The instructions do not require a paid AI feature, coding or account connections.
The review supports organization and checking. It does not promise savings or provide personalized financial, tax or investment advice.