Import bank statements to save time and reduce manual data entry errors.
How to Import Bank Statements
Navigate to the Bank and Cash Accounts tab.
Click the Import Bank Statement button in the bottom-right corner.
Select the bank account and choose your bank statement file, then click Next.
Review the import summary showing balances and transaction counts, then click Import to proceed.
After Import
Imported transactions are automatically created as Receipts or Payments.
Use Bank Rules to automatically categorize imported transactions and save time.
Learn more about automatic categorization: Bank Rules
To undo an import, use the History screen to reverse the changes.
Learn more about reversing transactions: History
Supported File Formats
Manager supports these bank statement formats:
• Most reliable: QIF, OFX, QFX, QBO, STA, SWI, 940, IIF, CAMT053, CAMT052
• Less reliable: XML, CSV (due to non-standard formats)
• Not supported: PDF (designed for human reading, not data processing)
Manager automatically interprets various CSV column layouts despite the lack of standardization.
Common Issues
Duplicate transactions - Usually occur when banks change transaction dates between exports. Regular bank reconciliations help identify duplicates.
Learn more about bank reconciliations: Bank Reconciliations
Date format confusion - Dates like 01-02-2024 could mean January 2nd or February 1st depending on format.
Manager analyzes your file to determine the most likely date format. Import files with many transactions for better accuracy.