Make your transaction files importable with the ProperConvert app

Need to import transaction files into accounting software, but the format is not supported? Use our ProperConvert app to convert your transaction files into a compatible format and import into your accounting or personal finance software.

The ProperConvert app combines all our knowledge and efforts to make your transaction files importable into your accounting software. When you have a file downloaded from your online banking or exported from production system, the app will help you make it importable into your accounting software.

Extract transactions from many financial formats

Convert from many formats with transactions

Convert from CSV, Excel, TXT, PDF (text and scan), OFX, QFX, QBO, QIF/QMTF, MT940/STA:

• Downloaded from your online banking.
• Exported from your existing accounting software.
• Received from your clients (downloaded from their online banking or printed and scanned).
• Use the ProperConvert app to view and convert from and to multiple formats.
• Export as CSV and work on your transactions in Excel before converting to a final format
• Converting one or multiple statements (combine or keep separate).
• Use advance renaming rules to adjust payee names, categories (expense/income accounts) or assign categories based on payee names.
• Automatically determine your document setting for number and date formats.
• Exclude or edit any transaction during conversion.

---

Convert to formats ready for import into Quickbooks (Desktop and Online)

Import into QuickBooks 2022-2025 and Quickbooks Online through the QBO format or all QuickBooks Desktop versions through the IIF format. For general journal entries, convert to QBJ or IIF format (General Journal Entries mode).

• When your bank does not support (or no longer supports) Quickbooks, convert to QBO format and import as regular direct transaction download with Bank Feeds features, existing renaming rules and your existing bookkeeping workflow.
• When your Quickbooks version is discontinued, convert to IIF format and import directly into register using advanced renaming features right in the converter.
• Enter your Journal Entries quickly in Excel or export from the database handling your business, and convert to General Entry files (QBJ) and import into Quickbooks with full audit trial.
• Make incorrect transaction files from your bank importable into Quickbooks.

Read more about Quickbooks formats

---

Make your files importable by Quicken

Import into Quicken for Windows as QIF format and Quicken for Windows and macOS as QFX (Web Connect). Keep using your Quicken version by converting to QIF format.

• Use the ProperConvert app for all required formats.
• Prepare checks to print in Excel and quickly convert and import into Quicken and print.
• Make incorrect bank or credit card transaction files importable into Quicken.
• Using Quicken for 2007 for Mac? Make your files importable into this personal finance software.

Read more about Quicken formats

---

Convert to formats compatible with Xero, Sage, Wave and others

Many cloud apps import directly from bank accounts, but not every bank. Use the converter and make your file importable. Most of accounting and personal finance cloud apps import OFX. Some imports CSV as well. See below or check the cloud app you use which format they prefer to import. Search your accounting software documentation for things like "how to import a bank statement in [Xero, FreeAgent, etc]" to confirm which file format these services import.

Your accounting or personal finance software (like Banktivity, MYOB, Sage 50, Sage 300, NetSuite) should import transactions using one of the following files formats: CSV, OFX, QFX, QBO, QIF, IIF, MT940. The ProperConvert app converts to all these listed formats.

Read more about formats supported by accounting apps

---

Extract transactions into formats compatible with Excel, Google Sheets

Need to work with transactions in Excel, but the file cannot be opened by Excel? Use the ProperConvert app. It extracts transactions from the following formats:

• QBO to CSV
• QFX to CSV
• OFX to CSV
• QIF to CSV
• MT940 to CSV
• PDF to CSV
• Excel/CSV to CSV (reformat files for XERO or Quickbooks Online)

Export transactions to CSV, Excel (XLSX, XLS), copy to clipboard.

---

Conversion Options for Different File Types

For bank and credit card transactions, the ProperConvert app converts from the following formats:

• CSV/XLS/XLSX/TXT (and copy/paste from any spreadsheet desktop or online software)
• PDF (downloaded from online banking, image based, protected, scanned)
• QFX/OFX/QBO
• QIF/QMTF
• MT940/STA

The ProperConvert app converts into a file format compatible with your accounting or personal finance or spreadshhet software:

• QuickBooks Desktop (all versions), convert to QBO or IIF format
• Quicken (convert to QFX, QIF, CSV Mint)
• Xero (convert to OFX, CSV)
• Sage (convert to OFX)
• Wave Accounting (convert to OFX)
• FreeAgent (convert to OFX)
• Banktivity (convert to QIF)
• Kashoo (convert to OFX)
• ZARMoney (convert to OFX)
• Excel, Numbers, Google Sheets (convert to CSV, Excel, clipboard)
• YNAB or You Need a Budget (convert to OFX, QFX, QBO, QIF, CSV)
• and many others importing standard financial file formats like OFX, QBO, QFX, QIF, IIF, CSV, MT940

Both bank account transactions and credit card transactions are supported. Check which file types your accounting software imports and convert to a file with expected file extension.

Types of Transactions to convert

The ProperConvert app converts bank and credit card transactions. Depending on your accounting software, each type of transaction could have slightly different definition (for example, when compering QuickBooks and Quicken), but overall supported transaction types are deposit, check, payment, credit card charge, credit card payment, credit card refund.

---

Extract transactions from PDF statements

Credit card and bank statements are supported. Scanned, image based, excypted and llocked PDFs are supported (password is required for statements locked for viewing).

---

Convert CSV/Excel files with transactions

When downloaded from online banking, exported from a production system, PayPal, Stripe, Square and other, the converter allows to map the columns in the CSV file. Splits are supported for QIF and IIF files. CSV files with splits can be converted to formats not supporting splits by separating splits into standalone transactions.