Download transactions from banks, credit cards, and digital wallets in CSV or spreadsheet form. Keep original files archived to fix mistakes quickly. Use consistent column headers for date, description, amount, account, and category so you can refresh your Sankey diagram with minimal rework. A simple directory structure saves hours when reconstructing timelines.
Write a short classification guide you can actually follow. If dining out splits into social, travel, and convenience, document those distinctions. Use rules or spreadsheet formulas to auto-tag recurring merchants. When a new merchant appears, decide once, add it to your guide, and move on. Intentional consistency makes every future diagram easier and more revealing.