Posted by & filed under Uncategorized.

Short answer: “.QFX”

Why? Short answer: Quicken does not import “.OFX” files (even if it says it does).

  • If you are looking to convert CSV or Excel files to QFX format, use the CSV2QFX converter.
  • If you are looking to convert PDF files to QFX format, use the PDF2QFX converter.
  • If you are looking to convert QIF to QFX format, use the QIF2QFX converter.
  • If you are looking to convert OFX to QFX format, use the OFX2QFX converter.
  • If you are looking to convert QBO, QFX, OFX, QIF to QFX format or correct non-importable QFX file, use the Bank2QFX converter.

Explanation

Quicken imports “.QFX” files (not .OFX) and calls them “Quicken OFX files.” From Quicken point of view, Quicken should import “.OFX” as it calls .”QFX” files “Quicken OFX files.” In reality, Quicken imports QFX files only.

QFX files are EXTENDED OFX files. It means QFX files follow OFX specification and have ADDITIONAL ATTRIBUTES that Quicken looks for when it imports a QFX or an OFX file.

Alternatives

 

For Quicken for PC, a great and working alternative is the QIF format. Quicken for PC imports correctly prepared QIF files fine. Quicken 2017 imports QIF files fine, Quicken versions from 2005 to 2014 import QIF files fine.

For Quicken for Mac (2015-2017), there is a possibility to import CSV Mint files (files similar to CSV files exported from Mint). CSV2CSV converts your Excel or CSV files to “CSV Mint” files.

 

Posted by & filed under Uncategorized.

If you have an Excel or CSV file with transactions from your bank (checking,l, savings or credit line) account or credit card statement and need to import into Quickbooks 2017, the best would be to convert to a QBO (Web Connect) file.

Use CSV2QBO as your one-stop solution for all your Excel, CSV or TXT files to convert to The QBO format ready to import into Quickbooks 2017.

QBO format provides advantages for a bookkeeper or an accountant in Quickbooks:

  • Imported QBO files are stored separately under Bank Feeds and Quickbooks provides an interface to review imported transactions, match to vendor records, assign Expense/Income accounts and add to the register.
  • Unwanted, duplicate or incorrectly converted transactions can be easily ignored under the Bank Feeds as well
  • When matched to a vendor record, Quickbooks remembers yourbchoice for the next QBO import
  • Expense/Income account assogned to a Vendor/Customer record is used to prefill account for the matched transaction

CSV2QBO provides abolity to paste table data copied from Excel or other spreadsheet software directly into the application without need to to save the CSV/Excel file.

Posted by & filed under Uncategorized.

Quicken 2017 for PC imports QIF files with categories. Quicken 2015 and Quicken 2016 had issues with a direct QIF import, but Quicken 2017 for PC does not have this issue anymore. Quick video below shows the full process using CSV2QIF.

QIF files are a great format to import transactions with categories and tags. CSV2QIF converts CSV and Excel files to QIF format ready to import into Quicken 2017 for PC, as well as Quicken 2016, Quicken 2015, Quicken 2014 and earlier versions. Also, you can create QIF files for Quicken 2007 for Mac, and other personal finance applications like MS Money, You need a Budget (YNAB), NetSuite, etc.

 

Important details for successful conversion from CSV to QIF and import into Quicken or other accounting software are the following:

  • Check that expenses are negative and payments to the account are positive. Some credit card companies supply amounts on CSV files in opposite way (expenses are positive, and credit card payments are negative). Use “Change +/-” button on the sidebar to reverse the amount signs for the whole file in a single click
  • Make sure to select correct QIF target (which accounting or personal finance software are you importing into)
  • Make sure to select correct account type (BANK vs CCARD vs INVST)
  • Make sure to enter the account NAME exactly as you have in Quicken for direct import into that account. Quicken reads the account name from the QIF file and locates the account before importing. If the account name is not found, Quicken prompts to create new account
  • Date format is ignored if QIF target is Quicken – Quicken expects only one date format and CSV2QIF uses expected format
  • Quicken 2015, 2016 do not import QIF files directly into bank or credit card account. Use proxy cash account to import your transactions and then move transactions to another account.

If you have PDF file from your bank or converted PDF file to CSV file, try PDF2QIF.

Posted by & filed under Uncategorized.

To import a PDF file to Quickbooks, use PDF2QBO (PDF to QBO Converter). PDF2QBO reads your PDF bank or credit card statement, finds transactions there, shows them for your review and creates a QBO (web connect) file ready to import into Quickbooks Desktop or Quickbooks online.

Quickbooks desktop has to be not older than three years old to import QBO (web Connect) files. If the current year is 2017, Quickbooks 2015, 2016, 2017 import QBO files. Quickbooks 2014 imports QBO files as well until April 2017 when Quickbooks 2014 stops importing QBO files.

PDF files have to be text-based (you can select text when you open a PDF file in a Pdf viewer or browser. PDF2QBO reads PDF files, find transactions there and converts them to a QBO file.

PDF2QBO cleans the description to be used for payee and keep full description as bank memo.

QBO files are Web connect files and they are imported in Quickbooks under the Bank Feeds Center. Under the Bank Feeds center, once imported, transactions are matched to vendor records and assigned expense/income accounts and then added to the register.

Posted by & filed under Uncategorized.

Quicken 2014 may give an error during update:

C:\ProgramData\Intuit\Quicken\INET\COMMON\Patch\Update\patchw32.dll is either not designed to run on Windows or it contains an error. Try installing the program again using the original installation media or contact your system administrator or the software vendor for support.

if this happens, download the manual update and install it over the existing version from the following page:

https://www.quicken.com/support/quicken-2014-windows-release-notes-updates-and-mondo-patch

Posted by & filed under Business Solutions.

As a home internet user and as an internet business user, you need to use a VPN service. Not because you have something to hide, but because you have to protect yourself when you are using the internet. You may use non-transparent tape to cover your webcam and microphone when you are not using them, or you can use a VPN service.

As a home user, I would like to protect my computer, my home network with a VPN service. Also, I do not want any slowdowns by using an additional layer of protection when accessing the internet. And I would like to configure my home dd-wrt router to work a VPN service.

As a business user, and based in Canada, I need few things for myself when I use the internet:

  • do a marketing research for US market, check search results as a US user
  • visit file-sharing web sites hosting cracks to my software without endangering my work computer

I was doing my VPN research and gave CactusVPN a try. Looks good! Their setup is simple (download Mac or PC app and it will the rest of setup). They provide tutorials for all kinds of devices like Apple TV, DD-WRT, etc.

Posted by & filed under Tools For Quicken.

Quicken 2016 R8 still changes the currency to USD when importing a QFX file on non-USD account. If you are using non-USD accounts, please do not use QFX (Web Connect) files to import into non-USD account, and use QIF format instead. You have to use a proxy account to import (with a proxy account, you can use either QIF or QFX, but with QIF your transactions can have categories).

Quicken 2016 R7 is changing account currency on QFX import

Posted by & filed under Tools For Quicken.

As reported on the Quicken community forum when Quicken 2016 R7 US edition (only this release) a QFX file with USD currency is imported on non-USD account (Quicken allows to choose non-USD account during QFX import), the account currency is changed to USD currency. User cannot change the account currency back, so this is considered an issue that hopefully will be changed in next release.

Quicken users face the issue with importing QFX files on non-USD accounts (again, this is about the US edition of Quicken 2016 R7) that could be resolved by changing the currency of the QFX file from non-USD to USD and import the QFX file successfully. With Release 7, importing QFX files with USD currency on non-USD accounts makes the account currency USD.

It is strongly advised to make backup before importing any file into Quicken.

With release R7, Quicken 2016 US edition users have only one option to import transactions into non-USD account: convert to QIF file, import into a proxy CASH account and then move transactions under non-USD account.

The following converters should help with the conversion to QIF format:

CSV2QIF

Bank2QIF

OFX2QIF

QFX2QIF

QBO2QIF

FixMyQIF (make various QIF files to follow expected QIF variant)

PDF2QIF

 

Posted by & filed under Tools For Quicken.

Video is at the bottom of the post.
Quicken 2015 changed QIF import process into non-cash accounts. Before Quicken 2015, Quicken 2014 and earlier versions imported “correctly” prepared QIF files even if Quicken “stopped” officially importing QIF files for non-cash accounts since Quicken 2005.

When you import a “correct” QIF file (with the account header part) that imports fine into Quicken 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, you will a message that transactions are imported, but you will not see the transactions when you open the account. There are a trick to see those transactions and get them into the register, but it is much more time consuming than a simple way to convert and import CSV into Quicken 2015 with categories shown below.

(Note: As another option, you can switch from QIF to QFX, but you won’t be able to import categories as QFX format does not support them.)

Three easy steps to Import CSV into Quicken 2015

  • use the latest CSV2QIF to create expected QIF
  • create IMPORT cash account in Quicken as place to import
  • move transactions under bank or credit card account

 

Get the latest CSV2QIF

Make sure you are using the latest version of CSV2QIF. Download it from the CSV2QIF download page.

Start CSV2QIF and load a CSV/Excel/TXT file. Select QIF target as “Quicken 2015”.

Load a CSV file into CSV2QIF, select QIF target as Quicken 2015

Click the Convert button to create a QIF file.

Create IMPORT cash account in Quicken

Many our users use “buffer” or “import” account approach to import transactions:

  • Import transactions into a “buffer” or “import” account to review imported transactions in isolated place.
  • Select all transactions and cut and paste them under other “final” account

For Quicken 2015, you must create a CASH IMPORT account, since the cash type is only account type that will import QIF files.

Do it in three easy steps.
in Quicken 2015 add cash account

Call the account “IMPORT” or something else standing out for as special account for imports.

In Quicken 2015 call added cash account IMPORT

Enter the account balance (the screenshot below shows just click “next”, but as I’m writing this I realized that BY ENTERING ACCOUNT BALANCE, YOU WILL NOT HAVE EXTRA BALANCE TRANSACTION CREATED that you see below on screenshots).

In Quicken 2015 add account next step click next

Now you have IMPORT account created.

In Quicken 2015 add account next step click finish

Import the QIF file into the IMPORT account

Select File, then Import, then, QIF file under the main menu.

In Quicken 2015 select File, Import, QIF file

IMPORTANT: Select “IMPORT” account. The MAIN difference from the guide for Quicken 2014 or earlier is to select “All accounts” from the dropdown list. In this case the account NAME is entered in CSV2QIF. For Quicken 2015, you must select the “IMPORT” account, not “All accounts”.

select IMPORT account

Once the QIF file is imported, go to the IMPORT account register.

once imported, go to register for the IMPORT account

Review and move transactions to bank or credit card account

Select the transactions there. You may spend little time to review transactions, amounts, payees, descriptions, categories. If you see the amounts are reversed (deposits and withdrawals), go back to CSV2QIF and click “Change +/-” and create new QIF file. In this case, delete already imported transactions and import new QIF file. The buffer account approach also proves to be effective as you can import several times without messing with your main account register.

Now click the first transaction once, and press Shift key and click the last transaction to select all transactions. Then right click on any select transaction and select “Move Transactions” (not “Cut transactions”, but “Move Transactions”).

select imported transactions, right right and select Move transactions

The final step is to select an account to move transactions into (your checking or credit card account).

select final account where to move transactions

You are done!

Now switch to checking or credit account used above and review imported transactions with the categories there.

select final account for imported transactions

How about Quicken 2015 for Mac?

Another painful topic is to how to import a CSV/Excel/TXT file into Quicken 2015 for Mac as the Mac version of Quicken does not support QIF import at all. There is a way as well:

  • Quicken for Mac 2015 imports “CSV Mint” files that carry the category
  • Your CSV file layout may not match expected CSV Mint layout, you have Excel or TXT file
  • use CSV2CSV to make your CSV/Excel/TXT file a “CSV Mint” file