Posted by & filed under Uncategorized.

ProperSoft offers several PDF converters for bank and credit card statements in PDF format:

PDF2QBO – this PDF file converter converts PDF files to QBO (Web Connect) format ready to import into Quickbooks PC or Mac (up to three years old version), and Quickbooks Online
PDF2QFX -this PDF file converter converts PDF files to QFX (Web Connect) format compatible with Quicken PC or Mac (up to three years old version)

PDF2OFX -this PDF file converter converts PDF files to OFX format ready to import into various personal finance and accounting software such as Quickbooks Online, Sage 50, Sage 300, ACCPAC, YNAB, iBank, Wave Accounting, Less Accounting, AccountEdge and others

PDF2QIF -this PDF file converter converts PDF files to QIF file format for Quicken for Mac 2007, Quicken 2014 or earlier (Quicken 2015 for cash accounts, but you you cut and paste transactions after into other account), and other software support QIF import.

 

Posted by & filed under Tools For Quicken.

ProperSoft is proud to announce PDF2QFX, a brand new, easy to use program that seamlessly converts your bank and credit card statements into importable Web Connect (.QFX) files. Do you use Quicken or other personal finance software to manage your money? Can you imagine how quickly you much faster transporting your bank and credit card statements into your chosen program would be if the actions were somewhat automated? While we don’t actually transport the files for you, we do the hard part by converting your financial statements to .QFX.

Instead of taking the time to enter data manually, use PDF2QFX to better manage your time. Think of the what you could do with an extra hour….Instead of manually inputting your bank and credit card transactions into Quicken or other software, you could be watching tv, going on a date, or otherwise having fun!

The trusted ProperSoft team invites you to explore PDF2QFX and try our new program for free today!

Posted by & filed under Tools For Quicken.

Quicken 2015 was released for PC and Mac, and there is some changes: good and bad.

Good:

Quicken for Mac 2015 now imports CSV from Mint. CSV file has date, amount, CATEGORY(!), and memo.

Bank2CSV was updated and now creates “Minted” CSV files ready to import into Quicken for Mac 2015. Your source file could be QIF, QFX, OFX, QBO.

Bad:

Quicken 2015 (for pc) no longer imports “correct” QIF files into bank and credit card accounts. The QIF file is actually imported, and even dialog shows up that transactions are imported, but transactions are not seen under the account.

The workaround for this is to import into a Cash account first (call it “IMPORT”) and then cut and paste transactions under correct account.

Quicken for Mac 2015 imports QFX files, but not OFX. Quicken Essentials for Mac was importing both QFX and OFX, but not CSV.

Posted by & filed under Tools For Quicken, Tools for Quicken for Mac 2007.

If you have your transactions downloaded or entered in CSV, TSV, TXT, XLS, XLSX (Excel) format, convert them the QIF to import into Quicken 2014.

Quicken 2014 imports QIF files for all account types. There are some messages that QIF format is discontinued and only Cash account can import QIF, but just tried it yesterday with freshly purchased Quicken Deluxe 2014 download and it imported QIF file created by CSV2QIF at http://www.propersoft.net/csv2qif/ just fine.

So to convert CSV (or Excel or Text) file to QIF, use CSV2QIF at http://www.propersoft.net/csv2qif/

Posted by & filed under Converters, Tools For Quicken.

QIF to PDF in three clicks

To convert QIF to PDF, use QIF2CSV at http://www.propersoft.net/qif2csv/

In QIF2CSV use print button, and then export to PDF.

Another option is to export to CSV and work on the file in Excel and print to PDF from Excel.

QIF2CSV creates spreadsheet for your QIF transactions. QIF2CSV also understands QIF files exported from Quicken including category list and Memorized transactions.

qif2csv_256x256

Posted by & filed under Tools For Quicken.

Quicken 2014 does not provide import for CSV, TXT, XLS, XLSX (Excel) files. How to import Excel into Quicken 2014? you can easily convert Excel files into one of the following formats and then import converted files.

How to import an Excel file into Quicken

  • Convert to QIF and import
  • Convert to QFX and import

Convert Excel to QIF

CSV2QIF converts CSV to QIF, import Excel into Quicken 2014
Convert Excel to QIF using CSV2QIF. CSV2QIF is capable to create different QIF variants (for Quicken, for MS Money, or for other finance applications), so you need to make sure to select Quicken as the QIF target (Quicken is selected by default when you start the program for the first time).
CSV2QIF supports direct import from Excel (XLS or XLSX) files.

But Quicken 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014 does not allow QIF files to be imported under checking, savings, credit card, broker and investment accounts, right? Not exactly. There is different QIF file variations. QIF created for MS Money, or provided for download by your bank are not accepted by Quicken unless you import them under a cash account.

However, CSV2QIF creates QIF files for Quicken, and Quicken does accept these files. In fact all Quicken versions for Windows (up to Quicken 2012) import QIF files just fine under checking, savings, credit card, broker, and investment accounts.

Where is the catch then? The catch is that you need to enter the account name in CSV2QIF exactly as you have it Quicken, otherwise during QIF import, Quicken will try to create a new account with that name. For example, if your checking account in Quicken is called “Checking” or “Bank checking” or other name, you need to enter this name exactly in CSV2QIF (as well as select correct account type) before saving a QIF file.

What is the advantage of using QIF files? Quicken does not require “online call home” during the import. You do not need to have internet connection active and firewall enabled for Quicken to go through to import a QIF file. This can come quite handy when you work and travel and do not have internet always on, but need to complete your finance report on time.

Another advantage? Creating investment transactions becomes quite easy, when you comfortably working in Excel, then copy and paste them in CSV2QIF and import QIF into Quicken.

So when QIF is not good? For Quicken Essentials for Mac. This Quicken variant does not allow QIF files at all. Please see the next paragraph on how to import your CSV into Quicken including Quicken Essentials for Mac.

Convert Excel to QFX (Web Connect)

CSV2QFX converts CSV to QFX (Web Connect)
Convert Excel to QFX (Web Connect) using CSV2QFX. CSV2QFX creates QFX files acceptable by Quicken. CSV2QFX covers bank (checking and savings, credit line and credit card accounts. During QFX import, Quicken ‘calls home’ using internet connection (so please make sure your firewall allows it to go through), and assigns bank details supplied in QFX file with selected account in Quicken. Even more, if Quicken find the match for bank details in the QFX to details with an account, it imports data there automatically. Otherwise, if offers you the import dialog to select existing “unlinked” account, or create new one.

CSV2QIF supports direct import from Excel (XLS or XLSX) files.

QFX format supplies unique id for each transaction, and Quicken uses it to avoid import for the same transaction next time. However, when you prepare your CSV file, it is common you may notice some transactions mistakes, so you need to fix them and import the file again. Even if you deleted the transaction in Quicken, it still refuses to import it the second time.

To deal with your need to import corrected transactions again, CSV2QFX allows to create unique transaction IDs every time you save the QFX file (this option is turned on by default), as well as keep transaction IDs consistent if you need them to be this way.

Posted by & filed under Converters, Tools for Excel, Tools For Quicken.

Import bank transactions into Excel (or convert to CSV and open either in Excel or other spreadsheet software). Online banking sites (as well online credit card sites or investment brokers) provide “accounting downloads” in QIF, OFX, QFX, QBO formats. To open these files in Excel (or convert to CSV), use the converters listed below. Bank2CSV and QIF2CSV converters support extended QIF format to convert data exported from Quicken as QIF format (for transactions, memorized transactions and categories).

Import bank transactions into Excel (convert to CSV).

  • Use Bank2CSV to convert QIF, QBO, OFX, QFX, QBX, OFX, ASO files to CSV format
  • Use QIF2CSV to convert QIF files to CSV format
  • Use OFX2CSV to convert OFX, ASO files to CSV format
  • Use QFX2CSV to convert QFX files to CSV format
  • Use QBO2CSV to convert QBO, QBX files to CSV format

Import transactions directly into Excel without saving to CSV file

  • Select the converter above, install and start it
  • Open your bank statement file
  • Click “Copy to clipboard” button and switch to Excel (start Excel or press CTRL+TAB)
  • Click Edit then Paste to paste your transactions

Convert bank transactions to a PDF file

  • Select the converter above, install and start it
  • Open your bank statement file
  • Click “Print” button and switch to Excel (start Excel or press CTRL+TAB)
  • Click “Export to PDF” (acrobat icon) button

Posted by & filed under Converters, Tools for Excel, Tools for Microsoft Money.

Import into Microsoft Money through QIF or OFX format (all Microsoft Money versions are supported).
There are some differences with QIF and OFX import (see below), but overall either QIF or OFX are fine to use for import.Import into Microsoft Money

Import into MS Money through QIF format.

  • Use CSV2QIF to convert CSV, Excel (XLS, XLSX), TXT to QIF and import  into all Quicken versions
  • Use Bank2QIF to convert OFX, QFX, QBO, QIF, QBX, OFX to QIF
  • Use QBO2QIF to convert QBO to QIF
  • Use FixMyQIF to make QIF file importable (select QIF target as “MS Money or others”)
  • Use OFX2QIF to convert OFX to QIF
  • Use QFX2QIF to convert QFX (Web connect) to QIF

Import into Microsoft Money through OFX format

  • Use CSV2OFX to convert CSV, Excel (XLS, XLSX), TXT to OFX and import into Microsoft Money
  • Use Bank2QFX to convert QFX, QBO, QIF, QBX to OFX (also fix OFX)

What are main differences between QIF and OFX import into Microsoft Money?

  • QIF format supports categories (and subcateogries) and tags, and OFX does not
  • QIF import somewhat better when using “Recover accounts” instead of “Downloaded statements”.
  • OFX format has the reference ID, when QIF does not. Reference ID (when supplied by your bank) allows to skip already imported transactions. ProperSoft converters support reference ID and if not supplied, generate it to be unique to guarantee the import for all transactions.
  • OFX files should be created differently for different software (Microsoft Money for Us, non-US, old Microsoft Money 99, 2000, and also other software like Sage).

Posted by & filed under Converters, Tools for Excel, Tools for QuickBooks.

Import into QuickBooks through QBO format (all QuickBooks versions are supported until they are three years old) or IIF format (all QuickBooks versions are supported). QBO and IIF format are different: QBO (Web Connect) is to import bank transactions, and IIF is more ‘low level’ import allowing to create various transactions between Quickbooks account. Both formats have limitations – read below to choose the most suitable format for you. Import into Quickbooks by ocnverting to QBO or IIF

Import into QuickBooks through QBO format.

 

  • Use CSV2QBO to convert CSV, Excel (XLS, XLSX), TXT to QBO and import  into QuickBooks 2013, 2012, 2011
  • Use OFX2QBO to convert OFX to QBO
  • Use Bank2QBO to convert OFX, QFX, QBO, QIF, QBX, OFX to QBO
  • Use QIF2QBO to convert QIF to QBO

Import into QuickBooks through IIF format

  • Use CSV2IIF to convert CSV, Excel (XLS, XLSX), TXT to QFX and import  into Quicken
  • Use Bank2IIF to convert OFX, QFX, QBO, QIF, QBX, OFX to IIF

What are main differences between QBO and IIF import into QuickBooks?

  • QBO import requires internet connection with Quickbooks allowed to access internet, IIF import is completely offline
  • QBO import allows to apply renaming rules to assign payee or vendor even if it is different on supplied QBO file from the record in Quickbooks, and assign the expense account during import. IIF must have expense accounts supplied as you have them in Quickbooks. CSV2IIF allows to do that through the category column or provide default expense account.
  • Imported QBO transactions go first into the Online Banking Center, where you can review, delete, match and finally include into the register. QuickBooks provides two Online Banking Center modes, completely be their user interface and actually how transactions are imported. IIF import is done directly into QuickBooks transaction register.
  • QBO import requires QuickBooks to be no older than three years. IIF keeps importing without asking you to upgrade.
  • QuickBooks Online imports QBO files only.

 

wpid-wpid-qif-import-successful-under-quicken-2011-2012-03-27-14-54-2012-03-27-14-54.png

Posted by & filed under Converters, Tools For Quicken.

Import into Quicken through QIF format (all Quicken versions are supported) or QFX format (all Quicken versions are supported until they are three years old). There are some differences with QIF and QFX import (see below).

import into quicken converting to QIF or QFX

Import into Quicken through QIF format.

  • Use CSV2QIF to convert CSV, Excel (XLS, XLSX), TXT to QIF and import into all Quicken versions
  • Use OFX2QIF to convert OFX to QIF
  • Use QFX2QIF to convert QFX (Web connect) to QIF
  • Use Bank2QIF to convert OFX, QFX, QBO, QIF, QBX, OFX to QIF
  • Use QBO2QIF to convert QBO to QIF
  • Use FixMyQIF to make QIF file importable

Import into Quicken through QFX format (Quicken versions 2013,2012,2011 are supported)

  • Use CSV2QFX to convert CSV, Excel (XLS, XLSX), TXT to QFX and import into Quicken
  • Use OFX2QFX to convert OFX to QFX
  • Use Bank2QFX to convert OFX, QFX, QBO, QIF, QBX, OFX to QFX

What are main differences between QIF and QFX import into Quicken?

  • QIF format supports categories (and subcateogries) and tags, and QFX does not (Quicken offers the renaming rules feature to assign the category during import
  • QIF formats for Quicken, Microsoft Money and other software are different by their structure. ProperSoft converters allow to create different QIF variants by selecting the QIF target value.
  • QIF import into Quicken is not “officially supported” by Quicken support. Regardless of the support, QIF files import quite well for all account types. Simply follow the instructions provided on the converter help page, and your data will be imported.
  • QFX format creates “online services link” to account ID values provided on the QFX files. Make sure to enter different account IDs when converting QFX files for different accounts.
  • QFX files stop importing once your Quicken version becomes three years old. You have to either buy the upgrade or start using QIF format.
  • Overall, QIF format is somewhat easier to import than QFX (truly based on our experience).
  • QFX format can be imported by Quicken Essentials for Mac
  • QIF format can be imported by Quicken for MAc 2007 (which is support OS X Lion and which the users still using over Quicken Esssentials for Mac).