The CSV Transaction Import feature enables you to bulk upload bank statements and transaction data from comma-separated value files, dramatically reducing data entry time whilst maintaining accuracy when processing large transaction volumes. CSV imports are essential for banks without direct feed connectivity, historical data migration when establishing new accounts, supplementing automatic feeds with additional transaction sources, or processing exported statements from credit cards, loan accounts, or investment platforms.
Exacc's import interface provides intelligent column mapping capabilities automatically detecting common CSV formats from major Australian banks whilst allowing customisation for non-standard file structures. The system validates imported data checking for date format consistency, numeric amount values, required field completeness, and potential duplicate detection comparing against existing transactions to prevent double-counting. Flexible mapping options accommodate various CSV structures including single amount columns with positive/negative indicators, separate debit/credit columns, optional balance columns for verification, and supplementary fields for references, payees, or categories.
The import process supports saved column mapping templates enabling efficient repeat imports from the same bank or source without reconfiguring mappings each time. Error handling provides detailed feedback on validation failures with downloadable error reports facilitating correction of source data before re-import. Post-import processing includes automatic bank rule application for categorisation, optional invoice/bill matching for payment reconciliation, and duplicate handling workflows ensuring data integrity whilst maintaining flexibility to override system suggestions when legitimate duplicate transactions exist.
Want to learn the exact steps to efficiently import transactions from CSV files? Follow our guide below for a detailed walkthrough of the CSV import process.
Bulk upload bank transactions from CSV files for efficient data entry
Your CSV file has been processed and transactions are now in Exacc - bulk data entry is complete, bank account balances are updated, automatic categorisation rules have been applied, and you can now review and reconcile the imported transactions.