Skip to main content

How to export a bank transaction report in TaxTank

Learn how to export a bank transaction report in TaxTank to Excel, including transaction details, tax allocations, exchange rates, and foreign currency conversions.

TaxTank's Bank Transaction Report lets you export your bank transactions to Excel, including transaction details, tax allocations, transfers, exchange rates, and foreign currency conversions. It's an easy way to review your transactions, reconcile your accounts, or share information with your accountant.

How do I export bank transactions?

  1. Open the required Bank.

  2. Select the Account Transactions tab.

  3. Click Export.

The report will download as an Excel spreadsheet containing your transaction details.

FAQs

Q: What information is included in the export?

A:

  • Transaction type, including:

    • Allocation

    • Transfer

    • Find & Match

  • Transaction date

  • Transaction description

  • Allocation category

  • Original transaction amount

  • Account currency

  • Exchange rate, where applicable

  • Converted AUD transaction amount

Q: How can I see foreign exchange rates?

A: You can export the Bank Transaction Report if you want an Excel report of all allocated bank transactions for a specific bank account. You can also view exchange rate details directly within a Tank. Simply open the relevant Income or Expense tab, locate the transaction, and hover over the currency label to view the exchange rate and conversion details.

Did this answer your question?