Reconcile bank, card and payment-app statements into a family budget with ChatGPT

Posted

Aug 19, 2026 by Yaacov Jacob (LinkedIn)

·

Last checked

Oct 17, 2026

·

Method:

How we verify

Evidence: Described by posterThe person describes what happened in words, without screenshots or video.

Outcome

A father of six gave ChatGPT three months of bank transactions, credit-card statements and payment-app exports, which don't reconcile easily in Israel. He says it removed duplicates, broke spending down by vendor and category, separated one-time and business expenses and built a realistic monthly budget, which he then went through with his three oldest kids to decide together where to cut.

Agent

ChatGPT

The source didn't share its exact prompt, so we wrote this from what it describes.

Let's work this out together. I'll tell you what I know, you suggest options and ask what you need, and we'll narrow it down step by step. Nothing gets booked, bought or sent until I say so.

Goal: Let's turn our scattered statements into one clear picture of family spending and a realistic budget.

What I'll share as we go:
- Three months of bank, card and payment-app exports (account numbers hidden)
- Household income
- Known one-off or business expenses

Rules:
- Remove duplicates where a card payment also appears on the bank statement.
- Group spending by category and vendor; separate one-off and business items.
- Build a monthly budget from the real averages.
- Make a simple version I can show my kids.
- If a site asks for a login, a CAPTCHA or payment details, stop and hand control back to me.
- Ask for my OK before you pay, book, send, submit or cancel anything.
- Check facts that can change (prices, opening hours, dates, availability, rules) against the official source, and tell me anything you couldn't verify.

Output: A spending summary, a monthly budget, and a kid-friendly one-page view.

You'll know it worked when: every transaction is counted once and the budget matches our real spending.

Let's work this out together. I'll tell you what I know, you suggest options and ask what you need, and we'll narrow it down step by step. Nothing gets booked, bought or sent until I say so.

Goal: Let's turn our scattered statements into one clear picture of family spending and a realistic budget.

What I'll share as we go:
- Three months of bank, card and payment-app exports (account numbers hidden)
- Household income
- Known one-off or business expenses

Rules:
- Remove duplicates where a card payment also appears on the bank statement.
- Group spending by category and vendor; separate one-off and business items.
- Build a monthly budget from the real averages.
- Make a simple version I can show my kids.
- If a site asks for a login, a CAPTCHA or payment details, stop and hand control back to me.
- Ask for my OK before you pay, book, send, submit or cancel anything.
- Check facts that can change (prices, opening hours, dates, availability, rules) against the official source, and tell me anything you couldn't verify.
- List any transactions you couldn't categorize so I can check them.

Output: A spending summary, a monthly budget, and a kid-friendly one-page view.

You'll know it worked when: every transaction is counted once and the budget matches our real spending.

Before you finish: re-read my goal and constraints, check your answer against each one, and list anything you assumed or couldn't confirm.

Source

https://www.linkedin.com/posts/yaacovjacob_budgeting-for-a-family-with-six-kids-three-activity-7495721237931864065-vCzz