Features

Bank Import

Import transactions from bank statements or CSV files. AI handles categorization, and you review before importing.

Import ReviewLive Demo

Two Import Modes

Retrospend supports two ways to import transactions:

Bank Statement (AI)

Upload a PDF or XLSX bank statement. Retrospend's AI extracts transactions, parses amounts and dates, and assigns categories automatically. Best for statements with complex formatting.

Retrospend CSV

Import a CSV file matching Retrospend's format (or exported from another Retrospend instance). Column mapping is automatic, so just upload and review.

Review Before Importing

Both import modes show a review table before anything is saved. In the review table you can:

  • Edit inline: click any cell to change the title, amount, date, or category
  • Check/uncheck rows: only checked rows will be imported
  • See duplicates: transactions that match existing expenses are flagged and auto-unchecked
  • Set bulk currency: override the currency for all rows at once

Duplicate Detection

Retrospend generates a fingerprint for each transaction based on the date, title, amount, and currency. If a matching expense already exists in your account, the row is marked as "Duplicate" with a badge and automatically unchecked. You can still check it manually if you want to import it anyway.

AI Categorization

When importing bank statements, the AI assigns a category to each transaction based on the merchant name and description. Categories use your existing category list, so everything stays consistent. You can always change the category in the review table before importing.

Tips

Uncheck unwanted rows

Bank statements often include transfers between your own accounts, ATM withdrawals, or other non-expense transactions. Uncheck these in the review table to keep your expense log clean.

CSV vs PDF quality

CSV files import faster and more accurately because the data is already structured. PDF parsing depends on the statement's formatting. If a PDF import looks off, try downloading a CSV from your bank instead.

Self-hosted AI

Bank statement parsing requires an LLM. Self-hosted users can use a local Ollama instance or configure an OpenRouter API key. See the AI Import configuration guide for setup details.