Importing Transactions
Last updated 2026-02-20
Importing transactions
Finance Frank lets you import transactions from your bank to track spending, income, and cash flow.
Supported file formats
- CSV — comma-separated values, exported from most Australian banks
- OFX — Open Financial Exchange, supported by many banking platforms
How to import
1. Export from your bank
Log in to your bank's online banking and download a transaction export. Most banks offer CSV or OFX under "Export" or "Download transactions".
2. Upload to Finance Frank
Go to Transactions and click Import. Select your file and Finance Frank will parse it automatically.
3. Review and confirm
Finance Frank previews your transactions before importing. You'll see:
- Date, description, and amount for each transaction
- AI-suggested categories
- Any potential duplicates flagged
Review the list and click Confirm Import to add them to your entity.
AI categorisation
When you import transactions, Frank automatically categorises each one based on the description, amount, and your previous categorisation history. You can change any category by clicking on the transaction.
Notes
Every transaction has a Notes field where you can add context — e.g. "client lunch with Acme Corp", "quarterly software licence", or "reimbursed by employer". Notes appear in the transaction list and are included in exports and tax reports, so your accountant gets the full picture.
Tax deductible toggle
Each transaction has a Tax Deductible toggle. Finance Frank automatically determines deductibility based on the category (e.g. work-related transport is deductible, groceries are not), but you can override this for individual transactions. This is useful for edge cases like a client dinner categorised as "Dining Out". When a transaction is marked as deductible, the notes field is especially useful for recording the justification.
Attach receipts
You can attach a receipt (PDF, PNG, or JPG, up to 10 MB) to any transaction. This keeps your supporting documentation linked directly to the expense — invaluable at tax time.
Avoiding duplicates
Finance Frank checks for duplicate transactions based on date, amount, and description. If a potential duplicate is found, it will be flagged during the import preview so you can decide whether to include or skip it.
Tips
- Import transactions regularly (weekly or monthly) to keep your data current
- Correct any miscategorised transactions — this helps the AI learn your patterns
- Toggle tax deductible on work-related expenses as you review them
- Attach receipts for deductible expenses straight away
- Add notes to transactions for context — especially useful for deductions
- Use the date range filter to focus on specific periods