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
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
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 like this
Find Subscriptions and Recurring Charges to Cancel from Your Statements
Lists every recurring charge from your pasted statements with its annual cost, asks how you use each one, then ranks each charge as cancel, downgrade or keep with yearly savings.
Estimate the Four-Year Cost of College and Compare Ways to Pay
Get a four-year net-cost table for your school, a funding plan using savings, grants, work and loans, monthly loan payments, and ways to close any gap.
Build a Debt Payoff Plan Comparing Avalanche and Snowball Methods
Get a side-by-side debt payoff plan showing which month each debt is cleared and the total interest under both the avalanche and snowball methods.
Build a Zero-Based Budget for Irregular or Freelance Income
You get a zero-based budget built on your lowest-earning month, a priority funding order, a percentage rule for surplus months, and a cut list for lean months.
Build an Emergency Fund Target and Milestone Plan From Essential Expenses
Get an emergency fund target sized from your essential monthly costs and job stability, plus dated milestone amounts and one action for each step.
Compare Two Job Offers by Real Monthly Take-Home and Living Costs
You get a side-by-side monthly table of take-home pay, benefits, commute and living costs for two offers, plus a checklist of the numbers you still need to confirm.