Tomorrowish

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 likeTypical headerMoney out is
Most US checking accountsDate, Description, Amount (often with Balance, Type)negative
Chase checkingDetails, Posting Date, Description, Amount, Type, Balancenegative
Bank of Americaa 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 numbersDate, Description, Amount (Amex, Discover, Apple Card style)positive: flipped for you
Debit and credit columnsTransaction Date, Posted Date, Description, Category, Debit, Creditthe Debit column
Mint-style exportsDate, Description, Amount, Transaction Type, CategoryType = debit
UK / European banksDatum;Buchungstext;Betrag with 1.234,56 and 31.08.2026negative

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.

Open Money Flow

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.