Build a Monthly Budget from Your Pasted Bank and Card Transactions

Turns one month of pasted transactions into a categorized budget table with actual vs. suggested amounts that total your take-home pay, plus recurring charges and leaks.

You getBudget table, recurring charges and leaks

Prompt

Prompt
You are a practical budgeting coach who builds monthly budgets from real spending data.

I will paste one month of bank or card transactions right after this message. Before building anything, ask me in one numbered message: 1) my monthly take-home pay after tax, 2) any savings or debt payoff goal, 3) which transactions were one-offs. Wait for my answers.

Then build my budget with these rules:
- Put every transaction into exactly one category. List any you cannot identify instead of guessing.
- Flag recurring charges (same merchant, similar amount, regular interval) and give the next expected date.
- Call out leaks: duplicate subscriptions, bank fees, interest, and any non-housing category above 10% of take-home pay.
- Suggested amounts must sum exactly to my take-home pay, with savings as its own line.
- Every suggested cut names the specific merchant or habit and the monthly dollar change.

Output format:
1. Budget table: Category | Actual | Suggested | Difference | Notes, with a total row.
2. Recurring charges: Merchant | Amount | Frequency | Next date | Keep, Review or Cancel.
3. Leaks: numbered list, biggest monthly saving first.
4. Three actions for this week.

End with one line listing your assumptions and any missing data. This is not financial advice; see a certified financial planner or nonprofit credit counselor for debt, tax or investment decisions.

Example output

At a glanceBiggest gaps: actual vs. suggested spendingMonthly cuts suggested from $4,200 take-home pay
  • Unallocated: -$369
  • Dining & delivery: -$220
  • Shopping: -$130
  • Fees & interest: -$68
  • Groceries: -$50
  • Subscriptions: -$31
  • Phone: -$25

Example for: a single renter with $4,200 monthly take-home pay, goal to save $900/month, one $120 birthday gift as a one-off.

1. Budget Table

CategoryActualSuggestedDifferenceNotes
Rent$1,450$1,450$0Fixed
Utilities$165$165$0Electric + internet
Groceries$610$560-$509 trips; plan 4 larger shops
Dining & delivery$480$260-$22014 QuickBite orders = $312
Transport$260$240-$20Daily parking; use $85 monthly pass
Car insurance$142$142$0Fixed
Phone$85$60-$25Switch to prepaid plan
Subscriptions$96$65-$31See recurring list
Shopping$310$180-$1306 online orders under $40
Health & pharmacy$45$45$0
Fees & interest$68$0-$68Overdraft + card interest
Gifts & irregular$120$100-$20Monthly buffer
Savings$0$933+$933Auto-transfer on payday
Unallocated$369$0-$369Sat idle in checking
Total$4,200$4,200$0

2. Recurring Charges

MerchantAmountFrequencyNext dateAction
FitZone Gym$34.99MonthlyJun 3Review (2 visits)
ViewPlus$17.99MonthlyJun 8Cancel
StreamMax$15.49MonthlyJun 12Keep
AudioBook Club$12.55MonthlyJun 15Cancel
TuneBox Music$11.99MonthlyJun 20Keep
CloudSave$2.99MonthlyJun 22Keep

3. Leaks

  1. Food delivery: 14 QuickBite orders, $312 incl. $68 in fees. Cap at 4/month: saves ~$220.
  2. Unallocated cash: $369 left unassigned. Move to savings on payday.
  3. Small online orders: 6 orders under $40 ($188). Use a 48-hour cart rule: saves ~$130.
  4. Fees: $35 overdraft (May 9) + $33 card interest. Set low-balance alert: saves $68.
  5. Overlapping streaming + audiobooks: cancel ViewPlus and AudioBook Club: saves $31.

4. Actions This Week

  1. Set a $933 auto-transfer to savings for payday.
  2. Cancel ViewPlus and AudioBook Club before Jun 8.
  3. Turn on a $200 low-balance alert and pay the card balance in full.

Assumptions: two Venmo transfers ($60 total) counted as dining; no annual charges appeared in this month's data.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Asking for take-home pay first lets the suggested column sum exactly to real income instead of a guess.
  • Requiring each cut to name a merchant and dollar amount turns vague advice into specific, checkable actions.
  • The 10% threshold and duplicate-subscription check give the model clear rules for spotting leaks.

Use at month end with ChatGPT, Claude or Gemini. Export or copy 30 days of bank and card transactions (date, merchant, amount) and know your monthly take-home pay. Remove account numbers before pasting.

Common edits

  • Paste three months of transactions and ask for monthly averages to smooth out one-off spikes.
  • Change the savings line to a 50/30/20 split or a specific debt payoff amount.

Prompt details

By
Prompts-GPT editors
Published

Did this prompt work?

Keep exploring

More in Personal Finance