Accounting app bank transaction guides

Choose the accounting app or output you need. Each group explains the destination and links directly to the published bank-statement conversion guides for it.

QuickBooks Desktop

Choose between QBO and IIF, prepare account and transaction details, and avoid missing or duplicate transactions in QuickBooks Desktop. Read more about QuickBooks Desktop.

Bank-specific conversion guides

QuickBooks Online

Prepare QBO, QFX, OFX, or CSV files for QuickBooks Online and review account, date, amount, and duplicate-handling settings. Read more about QuickBooks Online.

Bank-specific conversion guides

Quicken

Select QFX, QIF, or CSV Mint for the appropriate Quicken platform and prepare dates, accounts, amounts, and transaction IDs. Read more about Quicken.

Bank-specific conversion guides

Xero

Xero imports bank transactions through Accounting, Bank accounts, Import a Statement (also reached as Manage Account, Import a Statement). The file goes into the bank account's reconcile list, where Xero matches each line to invoices, bills and bank rules, or creates a spend or receive money transaction.

Bank-specific conversion guides

Sage Pastel

Prepare OFX or CSV bank transactions for Sage Pastel Bank Manager with suitable dates, signs, descriptions, and transaction IDs. Read more about Sage Pastel.

Bank-specific conversion guides

CSV/Excel

CSV is useful for review in a spreadsheet and for imports that accept a simple transaction table. A general-purpose layout uses Date, Memo, and Amount. Some destinations instead require separate Debit and Credit columns, so choose the column arrangement before saving.

Bank-specific conversion guides