Posted by & filed under April 1.

ProperSoft almost released a new technology “Direct Bookkeeper Connect” (DBC) for bookkeepers, accountants, and everyone else looking to import transactions into Quickbooks, Quicken, and other accounting software just by using their eyes.

ProperSoft almost provided a demo when a bookkeeper could quietly read bank statements from their clients, and transactions would be automatically imported into Quickbooks (PC/Mac/Online), Quicken, MS Money, XERO, LessAccounting, Sage One and others. The bookkeeper may optionally categorize/classify transactions when reading them by announcing category or class like “Oh, that is an office expense” or “or that is not taxable” or “yes, that is not a billable adjustment,” etc.

ProperSoft did not check their voicemail box yet, but expected companies behind accounting software to contact about API details, as this would be for “bookkeepers eyes only”.

The new DBC technology is still in early phase of development but already has shown promises for some of the great features:

  • a bookkeeper can read paper statements away from their computers, tablets, phones, sitting calmly on a beach or other peaceful and beautiful place and depending on the bookkeeper’s short memory hold up to 100 pages of statements before “offloading” transactions when close to a computer or a tablet connected to the internet
  • for automatically recognized clients, a bookkeeper can reuse previously read statements, so new statements are not required except total balance pages
  • listening is supported as well when an assistant can read statements to the bookkeeper when her eyes are tired

ProperSoft says that bookkeepers and accountants would be supported first and the general public is considered to be added later, starting from small business owners.

Until the technology is released or if bookkeepers or accountants have their transactions in CSV/Excel format, ProperSoft suggests to use CSV2QBO (CSV to QBO converter) or for PDF statements use PDF2QBO (PDF to QBO converter).

 

Posted by & filed under Uncategorized.

Quicken for Windows up to the latest 2017 (and 2016, 2015, 2014) version, supports import for QIF and QFX (Web Connect) files.

Here are the major differences between QIF and QFX (Web Connect) format when you try to import them under Quicken:

Vendor Support

Quicken claims that the QIF format is outdated, and not supported anymore, however still allows importing a QIF file. On the QIF import screen Quicken tells, then you can import a QIF file only under cash account, offering in the drop down choice for account selection only cash accounts, but also “<All Accounts>” as well. Guess what, unless you have Quicken Essentials for Mac, QIF files are fully supported, but not the ones your bank offers you for download. There slightly different, “Quicken only”, QIF files that Quicken 2012 imports just fine under any account. CSV2QIF (CSV to QIF converter) and Bank2QIF (OFX, QFX, QIF, QBO, OFX to QIF converter) will help you create those files.

“Call Home” Required

Quicken does not do any “home calls” during QIF imports, but it does every time you are trying to import a QFX file (yes, you need the internet connection, your firewall must allow Quicken to go through just to import a QFX file that you have locally on your computer). Quicken checks if the bank code supplied in the QFX file is ‘allowed’ by Quicken for a specific bank and even more bank account type. Some banks come and go, so your bank may drop QFX support tomorrow.

“Online linking”

Once a QFX file is imported under an account in Quicken you choose during the import, it “online links” that account to bank settings supplied in that QFX file. If you have other QFX file with different settings then your currently for the account in “online link”, Quicken will not allow you to import that other QFX file under “occupied” account. The cure for that is simple: edit account, click on “Online Services” tab and select “deactivate online link”.

Categories and Tag

QFX format as extended OFX format with additional Quicken only details, but the OFX specification does not provide category or tag attribute for transactions (or anything else similar) That’s it; you cannot import categories and tags assigned to your transactions using the QFX (Web Connect) format. On the other hand, QIF format still imports categories and tags just fine. There is a workaround (no great, but some) this limitation for categories: you can set “rename rules” in Quicken to have categories assigned to specific payee names. Should be ok for most payees, but not retailer stores, like Walmart.

Investment transactions

QIF format simplifies investment transactions by limiting the security identification to just security name. That’s it, no ticker symbol, no CUSIP numbers, just full Security name. When you import a QIF file with investment transactions under Quicken (or MS Money), Quicken will look up the security by its full name. You need to make sure your securities names do match the ones on the QIF file, but nothing more. For QFX (OFX) case, each transaction must be accompanied by the security record with CUSIP supplied. You do need to have CUSIP number for every security to create proper QFX file that Quicken can import.

Available converters to convert your existing transaction file to QIF or QFX:

To convert your existing transaction file to QIF format, use the following converters:

Posted by & filed under Tools For Quicken PC.

Quicken 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2017 does not provide import for CSV, TXT, XLS, XLSX (Excel) files. How to import Excel into Quicken? 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 supports direct import from Excel (XLS or XLSX) files.

But Quicken 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2017 does not allow QIF files to be imported under checking, savings, credit card, broker, and investment accounts, right? Not exactly. There are 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 another 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 an 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 the internet always on, but need to complete your finance report on time.

Another advantage? Creating investment transactions becomes quite easy when you are 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)

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 finds 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 a 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 errors, 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 creating 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 Tools For Quicken PC.

Quicken 2017 (deluxe, premier, home and business) imports the following formats:

  • “regular” QIF for cash accounts
  • “correct” QIF for all accounts including checking, savings and credit card. Quicken tells it is not possible, but it does import anyway as long as QIF if prepared correctly. Use CSV2QIF or Bank2QIF to create “correct” QIF files
  • QFX (Web connect), extended OFX format with Quicken attributes to import under all accounts. If your QFX file is not importing under specific account, edit that account, click “Online services” and delete online services link there before importing. Use OFX2QFX to convert your OFX files to QFX format
  • QXF – new Quicken format used to move data between Quicken applications. I may be wrong, but last time I checked banks do not offer QXF downloads or third party software creates QXF files.

Posted by & filed under Tools For Quicken PC.

To import QIF into Quicken (to import a QIF file into Quicken 2005-2014, 2017), you need to create a correct QIF file and follow the instructions below.

QIF and QFX format

Quicken imports QIF and QFX (Web Connect) files with transactions. Once Quicken becomes three years old, it stops import QFX (Web Connect) files. Investing in a converter that creates QIF files from your CSV or OFX or QFX or QBO files is a good idea because you keep using your Quicken version until you see features worthy upgrade to new Quicken version.

QXF format

There is also QXF files that you do not want. Unlike QFX (Web Connect) and QIF files, QXF replace whole data file and can create only from another Quicken that is the same year and the same platform (PC/Mac) as you have. QIF and QFX (web connect) files add transactions to your Quicken file, not replace them.

Yes, Quicken says QIF files are not supported, but yes, QIF files correctly prepared are importable directly into bank or credit account in Quicken. Import QIF into Quicken gives you ability to supply transactions, as QFX (Web Connect) format does not provide them.

QIF files should be created either by CSV2QIF (CSV to QIF converter) or Bank2QIF (Bank to QIF Converter) (you can use Bank2QIF to ‘fix’ your QIF as well).

Quicken 2005-2014, 2017? You are fine

Quicken 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2017 import QIF files fine for account types. Your QIF file must be correctly created to import directly into an account you need it to imported, and CSV2QIF helps you create such QIF files.

When you convert a CSV file to QIF using CSV2QIF, enter the account name exactly as you have in Quicken and select the account type (Bank for checking and saving accounts, CCard for credit card accounts, Invst for investment accounts).

When you convert a bank file (OFX, QFX, QIF, QBO) to QIF using Bank2QIF (Bank to QIF Converter), load the file and click on the Account Mapping tab and enter the account name as you have in Quicken for each listed account.

Once you saved the QIF file, do the following:

  • Start Quicken and click File, then File Import, then QIF file.
  • On the import screen, select from the account drop-down list. Ignore the Quicken message about QIF limitations.
  • Review your imported transactions (Done!).

 

Posted by & filed under Tools For Quicken PC.

Short answer for OFX or QFX: 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.
  • To convert PDF files to QFX format, use the PDF2QFX converter.
  • Use the QIF2QFX converter, when you need to convert QIF to QFX format.
  • Quicken does not import OFX, and to convert OFX to QFX, use the OFX2QFX converter.
  • For multiple formats conversion (QBO, QFX, OFX, QIF or to correct non-importable QFX file) to QFX format, 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, and

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

If you are using 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.

If you happened to be a Quicken for Mac (2015-2017) user, 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.

What about QXF format?

QXF format adds to this confusion, as it looks very similar to QFX. Even more, your autocorrect may switch QXF to QFX or QFX to QXF as you type, so if you ask a support question, you may get an unexcepted answer. QXF format is not for transaction import, but for data transfer: you will replace your whole dataset in Quicken when you get a QXF file successfully imported.

Backup before any import

Safety first: make sure to backup your Quicken file before any import: QFX, QIF, QXF or even OFX.

 

 

Posted by & filed under Tools for QuickBooks (PC or Mac).

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 Tools For Quicken PC.

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 Tools for QuickBooks (PC or Mac).

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 Tools For Quicken PC.

Error during Quicken 2014 update

Quicken 2014 for PC may give an error during the 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

 

Options to import into Quicken 2014 after the update

Once you have Quicken 2014 for PC updated, use one of the listed converters to convert to QIF or QFX (Web Connect) format and import your transactions:

  • CSV2QIF to convert CSV or Excel or TXT files to QIF format. Quicken 2014 imports correct QIF files for bank (checking, savings) or credit card or investment accounts (or cash accounts)
  • CSV2QFX to convert CSV/Excel/TXT files to QFX (Web Connect) format. Quicken 2014 will stop importing QFX files on April 30, 2017 (see Quicken discontinuation policy).
  • OFX2QIF to convert OFX files to QIF (make sure to select the QIF target as Quicken 2014 or earlier)
  • PDF2QIF to convert PDF files to QIF
  • QFX2QIF to convert QFX files to QIF (this should be handy after April 30, 2017 if you decide to keep existing Quicken version)
  • QBO2QIF to convert QBO files to QIF
  • Bank2QIF to convert various formats to QIF (OFX, QFX, QBO, and correct incorrect QIF files)

If you have to complete your 2016 taxes before the end of April 2017, use both QIF and QFX format, whichever you find easier. We do suggest to choose QIF over QFX if you decide to keep using Quicken 2014. If you upgrade Quicken to newer version, if you have both QIF and QFX choices, but read below:

  • Quicken 2015, Quicken 2016 for PC have a bug for QIF import and have to use a workaround with a cash proxy account
  • Quicken 2017 for PC imports QIF files fine as Quicken 2014 does
  • Quicken 2015, Quicken 2016, Quicken 2017 for Mac do not import QIF files at all, only QFX files

So if you are planning to complete your taxes and switch to Mac, QFX format is a great choice as well. There CSV2QFX, PDF2QFX, Bank2QFX, QIF2QFX, OFX2QFX converters to help you.