M
DownloadReleasesGuidesChatbotAccountantsForumCloud Edition

Import bank statement

Most banks allow you to download transaction data for import into accounting systems.

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.

Bank and Cash Accounts

Click the Import Bank Statement button in the bottom-right corner.

Import bank statement

Select the bank account and choose your bank statement file, then click Next.

Next

Review the import summary showing balances and transaction counts, then click Import to proceed.

Import

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

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.