Make your transaction files importable with the ProperConvert app
ProperSoft makes conversion software for accountants, bookkeepers, small businesses and everyone else trying to import their file into accounting 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 Intuit QuickBooks 2020-2023 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 Quicken friendly
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
Conversion Options for Different File Types
The ProperConvert app creates files with transactions in CSV, QIF, QFX, OFX, QBO, IIF, QBJ, MT940 format. It works with bank statement files or bank files (CSV, PDF), online bank or financial institutions accounting downloads (CSV, QFX, OFX, QBO, QIF, IIF, QBJ, 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 Transactions 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.
Convert PDF statements to QBO, QFX, OFX, QIF, IIF, CSV/Excel, MT940
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 to QBO, QFX, OFX, QIF, IIF, MT940
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.