When to use CSV import
Use CSV import when:- Your bank or credit union isn’t available in Plaid or Teller.
- You want to import historical transactions from before you linked a Plaid or Teller connection.
- You’re migrating data from another personal finance tool.
- You have a one-time export you want to add to your history.
CSV import doesn’t support automatic syncing. You need to manually download and re-import a new file each time you want to add transactions. If your bank is available on Plaid or Teller, those providers are a better choice for ongoing use.
Download a CSV from your bank
Most banks let you export transactions from their website or mobile app. Look for an Export, Download, or Statement option in your transaction history or account activity section. Choose CSV or Spreadsheet format where available. The specific steps vary by institution. Common locations include:- Chase: Account activity → Download account activity
- Bank of America: Activity → Download
- Wells Fargo: Account activity → Download transactions
- Capital One: Transactions → Download
- Amex: Statements & Activity → Download
Import wizard
Start a CSV import from Connections → Connect New Bank → CSV Import in the admin dashboard.Select a family member and upload your file
Choose the family member this account belongs to from the dropdown. Then upload your CSV file. Breadbox accepts
.csv, .tsv, and .txt files up to 10 MB. It automatically detects the delimiter (comma, tab, semicolon, or pipe) and handles encoding and byte-order marks.Files must contain at least one data row in addition to a header row. Files with more than 50,000 rows are rejected.Map columns and preview
Breadbox reads the column headers from your file and asks you to map them to the required fields. If your bank matches one of the pre-built templates (Chase, Bank of America, Wells Fargo, Capital One, or Amex), the mapping is filled in automatically.Set the amount sign convention to match how your bank exports amounts:
- Positive = debit (money out) — matches Plaid’s convention and is the default.
- Positive = credit (money in) — Breadbox negates the amounts automatically so they’re stored consistently.
Review the summary and confirm
Breadbox shows a summary: total row count, date range, account name, and family member. Click Import to start the import.
Required and optional fields
Breadbox requires three fields to import a transaction. All other fields are optional. Required fields| Field | What it maps to | Notes |
|---|---|---|
| Date | Transaction date | See supported date formats below |
| Amount | Transaction amount | See amount handling below |
| Description | Transaction name | Trimmed; max 500 characters |
| Field | What it maps to | Notes |
|---|---|---|
| Category | Primary category | Stored as-is; not mapped to Plaid categories |
| Merchant name | Merchant name | Trimmed; max 200 characters |
Pre-built bank templates
Breadbox includes templates for the following banks. When your column headers match a template, Breadbox auto-fills the column mapping for you.- Chase (credit card)
- Chase (checking/savings)
- Bank of America
- Wells Fargo
- Capital One
- Amex
Date column: Transaction Date
Amount column: Amount
Description column: Description
Category column: Category
Sign convention: Negative = debit (charges), Positive = credit (payments)
Date format: MM/DD/YYYY
Amount column: Amount
Description column: Description
Category column: Category
Sign convention: Negative = debit (charges), Positive = credit (payments)
Date format: MM/DD/YYYY
Supported date formats
Breadbox tries to detect the date format in your file automatically by sampling the first 20 date values. It picks the format that successfully parses at least 90% of them. If no format succeeds, you’ll see an error asking you to check the date column mapping. Supported formats (in order of priority):MM/DD/YYYY— e.g.,01/15/2024YYYY-MM-DD— e.g.,2024-01-15M/D/YYYY— e.g.,1/5/2024MM-DD-YYYY— e.g.,01-15-2024DD/MM/YYYY— e.g.,15/01/2024YYYY/MM/DD— e.g.,2024/01/15Mon DD, YYYY— e.g.,Jan 15, 2024Month DD, YYYY— e.g.,January 15, 2024
Amount sign conventions
When you upload a file, you set the sign convention to match how your bank exports amounts:- Positive = debit (default): amounts are stored as-is. Positive values mean money going out.
- Positive = credit: Breadbox negates the amounts. Positive CSV values become negative in the database, representing money coming in.
Deduplication
Re-importing the same file is safe. Breadbox generates a unique identity for each transaction from its date, amount, and description. If a row with the same identity already exists, it’s updated rather than inserted as a duplicate. This means you can re-import a file multiple times without worrying about duplicate transactions. However, if two transactions on the same day share the same amount and description — for example, two identical $5.00 charges at the same merchant — they’ll be treated as one transaction.Limitations compared to Plaid and Teller
| Feature | Plaid / Teller | CSV |
|---|---|---|
| Automatic sync | Yes | No — manual upload only |
| Balance tracking | Yes | No — balances are not imported |
| Webhook support | Yes | No |
| Re-authentication flow | Yes | Not applicable |
| Deduplication precision | Exact (provider transaction ID) | Hash-based (date + amount + description) |