How to get your bank's CSV and turn it into a Sankey diagram
The income to spending flow charts people share are usually typed in by hand, one line per flow. Your bank already has every transaction in a file you can download.
1. Download the transactions as CSV
Sign in on the bank's or card's website (phone apps often have no export). Open the account's transaction list and look for Download, Export or a download icon. Pick the date range, then the format:
- CSV (sometimes "Comma delimited", "Spreadsheet" or "Excel (CSV)"): this is the one.
- QFX, OFX ("Quicken", "Microsoft Money", "Web Connect") or QIF work too: Money Flow reads them the same way, and a CSV and a QFX of the same month count each transaction once. QBO (QuickBooks Web Connect) files are OFX inside and open the same way. To open one of these as a spreadsheet instead, use the Bank File Converter.
- A real Excel file (.xlsx): open it in Excel, Numbers or Google Sheets and save it as CSV first.
- Only PDF statements? Most banks also offer a CSV of recent activity on the transactions page, separate from the statements.
Do this for every account money comes into or goes out of: checking, savings, each credit card. Open them all together; card payments and transfers between your own accounts are recognised and left out, so nothing is counted twice.
2. Pick a period that tells the story
One month is noisy (rent lands once, a car repair looks like a lifestyle). Three months is a good first look; a full year is what most shared charts use, and evens out insurance, travel and annual subscriptions. You can open a year and click single months afterwards.
3. Check the columns and the signs
Money Flow reads the header names and, when they are missing or odd, the contents. Typical headers it recognises:
| File looks like | Typical header | Money out is |
|---|---|---|
| Most US checking accounts | Date, Description, Amount (often with Balance, Type) | negative |
| Chase checking | Details, Posting Date, Description, Amount, Type, Balance | negative |
| Bank of America | a summary block, then Date, Description, Amount, Running Bal. | negative |
| No header row at all | "08/01/2026","-45.10","*","","SHELL OIL" | negative |
| Cards with charges as positive numbers | Date, Description, Amount (Amex, Discover, Apple Card style) | positive: flipped for you |
| Debit and credit columns | Transaction Date, Posted Date, Description, Category, Debit, Credit | the Debit column |
| Mint-style exports | Date, Description, Amount, Transaction Type, Category | Type = debit |
| UK / European banks | Datum;Buchungstext;Betrag with 1.234,56 and 31.08.2026 | negative |
Each file shows what was decided ("amounts flipped", "day first"); open it to change a column or the sign. If a bank file still won't read, write to hello@tomorrowish.dev with its header line only (never send transactions).
4. Fix the categories once
About 360 built-in keyword rules sort the usual suspects (payroll, rent, groceries, fuel, streaming, card payments). Anything they miss lands in Other. Click Other in the diagram, then pick the right category in each row: that makes a rule for every transaction from the same merchant, now and next time. Rules stay in your browser; export them as a file to use on another computer.
- Refunds lower the category they came back to, instead of looking like income.
- Savings and investing (transfers to savings, brokerages) show as their own outflow, so "Left over" is only what stayed in the account.
- Venmo, Zelle, PayPal: money in is "From people", money out is "Sent to people"; give the regulars their own rule (for example the friend you split rent with).
5. Save it, or share it without the amounts
Switch labels to % only before sharing: the picture then shows where each dollar of income went without showing how many dollars there were. Save as PNG for posting, SVG for print or editing, or SankeyMATIC text to paste into SankeyMATIC if you want to restyle it there. Check the descriptions in the categorised CSV before you share that file: they can contain names and account numbers.
Looking for subscriptions rather than a diagram? Open the same files in Subscription Finder: every recurring charge, price rises, trials that turned paid and the next charge dates.
Money Flow reads files in your browser; the tool page is not allowed to make network requests, so your transactions are never uploaded. This guide page counts anonymous page views.