Agents, PlainlyBlackcircuit LabsEspañol

Rung 1 · Ready-to-use tool

Sort your monthly spending with an AI assistant

Draft · not tested yetThis material is a draft. The steps are written, but nobody has run them yet from a brand-new account, so a button may be named differently. If something doesn't match, tell us.

Costs and accounts

Cost: $0. Accounts: nothing new; use the AI assistant you already have and Excel, Google Sheets or Numbers. Time: 10 minutes the first time.

What it does: reads the transactions you download from your credit card or bank, sorts them by category, and shows where your money goes against your budget. What it doesn't do: it doesn't connect to your bank, pay anything or move money. You check and approve every category.

Files

Direct downloads. Sample data is made up.

Steps

  1. Download this month's statement from your card or bank (CSV, Excel or PDF). Remove account numbers and other people's names.
  2. Open expense-tracker.xlsx in Excel, Google Sheets or Numbers.
  3. Paste the prompt-for-your-assistant into your AI assistant and attach the file from step 1.
  4. Check the table it gives you, especially the notes ("possible duplicate?", "merchant name unclear"). Fix anything that's off.
  5. Copy the table and paste it into the Transactions tab at the first empty row. Type your budget in Categories (yellow cells) and look at Summary.

How to know it worked

Summary shows how much you spent in each category, how much budget is left, and the ones over budget in red. The total matches the sum of charges on your statement.

If it doesn't work, check this

  • Everything landed in one column: ask for "the same table, tab-separated".
  • Summary shows zero: the date in Summary is from another month, or the dates pasted as text. Type them as month/day/year.
  • It can't read your PDF: copy and paste the transactions as text.

Limits

  • It's for reviewing, not deciding: the assistant can pick the wrong category. Anything marked "check with your bank" gets checked with your bank.
  • Only your own transactions. No statements from clients or family members without their permission.

Templates

Prompt for your assistant

Copy everything inside the box and paste it into your AI assistant (Claude, ChatGPT, Gemini or another). Then attach your statement or paste the transactions.

You're going to read my credit card or bank transactions and sort them into my expense tracker.
You only read and suggest. Don't recommend investments, loans or moving money, and don't ask me
for passwords, card numbers or account numbers.

From the transactions I give you:
1. Leave out anything that isn't spending (card payments, deposits, refunds, credits) and
   list them separately in one line so I know you saw them.
2. Build a table with these columns, in this order, separated by tabs, with no header row and
   no extra text inside the table, so I can paste it directly:
   Date (mm/dd/yyyy) | Description (as written) | Amount (no $ sign, no thousands separator)
   | Category | Payment method | Recurring or installment? (Yes or No) | Assistant note
3. Category: use only one of these: Groceries, Transportation, Home and utilities, Health,
   Subscriptions, Shopping, Eating out, Installments, Other. If you're unsure, use Other and
   say why in the note.
4. Payment method: Credit card, Debit card, Cash, Bank transfer, or Zelle / Venmo. If it's a
   credit card statement, everything is Credit card.
5. Mark Yes for recurring or installment when you see "3/24", "Pay in 4", "installment", or a
   charge that looks monthly (streaming, apps, gym). In the note write "Payment 3 of 24" or
   "Charges every month".
6. If two charges are identical on the same day, keep both and write in the note
   "Possible duplicate? Check with your bank." Don't decide whether it's a mistake.
7. If you can't tell the merchant (codes like SQ *1234), write "Merchant name unclear".

After the table, in three lines at most: total spending, total recurring charges and
installments, and which transactions I should check myself. No advice or judgment.

Before you upload your statement: remove account and card numbers and other people's names. Don't upload statements that belong to other people or to clients.

Did it work?

Once it works, reply DONE to the message this came in.

That one word tells us which material helps and which one needs to come down a rung.

Sample template with made-up data by Blackcircuit Labs. Last full test: (pending).