Need to import bank or credit card transactions, but your accounting software doesn’t support the file format? ProperConvert by ProperSoft makes file conversion easy, allowing you to import data directly into QuickBooks, Quicken, Xero, Sage, and more.
ProperConvert makes your transaction files ready for accounting software. Whether you’ve downloaded a file from online banking or exported it from another system, the app makes it easy to prepare for import into your accounting software.
Convert from CSV, Excel, TXT, PDF (text and scan), OFX, QFX, QBO, QIF/QMTF, MT940/STA:
Import into Quickbooks Desktop 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).
For QuickBooks Online, convert to OFX,QFX,QBO (web connect) formats or CSV format (set target as "Quickbooks Online").
Read more about Quickbooks formats
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.
Read more about Quicken formats
Many cloud apps import directly from bank accounts, but not every bank. Online accounting services like Xero, FreeAgent, LessAccounting, MYOB, Wave, and others, usually imports OFX or QFX or QBO files and optionally CSV files.
Use the converter and make your file importable.
Read more about formats supported by accounting apps
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:
Export transactions to CSV, Excel (XLSX, XLS), copy to clipboard.
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.
For bank and credit card transactions, the ProperConvert app converts from the following formats:
The ProperConvert app converts into a file format compatible with your accounting or personal finance or spreadshhet software:
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.
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.
Credit card and bank statements are supported. Scanned, image based, excypted and llocked PDFs are supported (password is required for statements locked for viewing).
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.
For QuickBooks desktop, convert to IIF format almost any available QuickBooks version or QBJ format if you have QuickBooks Desktop 2013 or later, QuickBooks Enterprise 13 or later, QuickBooks Desktop for Mac 2013 or later.
ProperConvert converts multiple journal entries in your CSV or Excel in one IIF or QBJ file.
To help you work fast and efficient with one CSV or Excel, the app supports processing of multiple journal entries.
Your ecommerce, production or other purpose system may export general journal entries as CSV or TXT format. The GJE app understands different date formats, numeric formats, decimal and other separators, encodings, so you can use exported CSV file with minimal or no changes required.
The IIF and QBJ formats have their advantages and disadvantages compared to each other in different situations. With the GJE app you have a choice to utilize each format effectively.
Before importing any files into your accounting software, make sure to backup your company data file. Apps like QuickBooks or Quicken provide easy to use and fast backup options that will take few seconds and save you lots of lost time in case of incorrect import. Import data with confidence you can easily rollback to previous state. Do backups for major changes like disabling online services as well.
Many accounting software packages like QuickBooks Desktop (any edition like QuickBooks Pro or QuickBooks Premier or QuickBooks Accountant) provide a buffer zone (bank feeds center) to review imported transactions and delete (ignore) or add to the register. Online solutions like Xero or QuickBooks Online have similar interface to review and match imported transactions.