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