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.
Unlock transactions from incompatible formats and save time on reentering data you already have
Import transactions into QuickBooks (PC/Mac/Online), Quicken, Xero, Excel/CSV, Sage (50/300/One), Wave Accounting, ZarMoney, MS Money, REACT, MYOB, NetSuite and others
Full control for date and numeric formats world-wide for input, view and output
Easy to use Desktop software for Windows and macOS to review, sort and edit transactions and keep your data confidential data on your computer
Used by many accountants, accounting professionals, CPAs, QuickBooks Pro Advisors, bookkeepers (see the testimonials)
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 2021-2024 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.
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.
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)
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.