📊 Data Processing Community

Finance App Backup Transaction Summary

Extract 14 months of transactions from a finance app backup and generate a summary table and report

★★☆ Intermediate 15-30 min January 20, 2026
📋

Scenario

I exported a local finance app backup and want the transactions organized into an analyzable table with monthly summaries.

💬

Prompt

Parse the finance app backup in ~/Finance/AppBackup.
- Extract all transactions
- Output a CSV with Date, Amount, Category, Merchant, Account
- Create a monthly summary report (totals and top categories)

Expected Result

Claude extracted 14 months of transactions, produced a structured CSV, and generated monthly totals and category summaries.

💡

Tips

  • Specify currency and date range to avoid mixing
  • Ask for dedup rules if duplicates exist
📝

Original Post

· 2026-01-20

A tutorial example extracted 14 months of transactions from a finance app backup and produced a summary report.