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.
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).
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:
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”.
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.
Call the account “IMPORT” or something else standing out for as special account for imports.
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).
Now you have IMPORT account created.
Import the QIF file into the IMPORT account
Select File, then Import, then, QIF file under the main menu.
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”.
Once the QIF file is imported, go to the IMPORT account register.
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”).
The final step is to select an account to move transactions into (your checking or credit card account).
You are done!
Now switch to checking or credit account used above and review imported transactions with the categories there.
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
When you import a .QBO file into Quickbooks, you may receive the following message “quickbooks is unable to verify the financial institution information for this download”.
Why would QuickBooks give such message? Possible reasons are below
if your Quickbooks copy is three years old (for example, for current 2015, QuickBooks 2012 or earlier (or Quickbooks enterprise 12 or earlier), it will not import .QBO files. You must either update to the newer version or use Bank2IIF or CSV2IIF converters depending on the file you have and import as IIF file instead of QBO.
Your bank or credit card company is no longer “allowed” by Quickbooks. Use Bank2QBO to make your QBO file from “allowed” financial institution.
Your .QBO file was not created correctly or “not ready” for your Quickbooks version. Banks and credit card companies create .QBO files differently. QBO files are extended OFX files (QBO is also called Quickbooks OFX), but there some small but important differences between QBO and OFX files. QBO file may follow OFX specification, but is not acceptable for QuickBooks. In addition, different Quickbooks versions have slightly different requirements for “good” QBO files.Use Bank2QBO to make your QBO file ready for your Quickbooks version.
Your .QBO file is from US bank, and you are trying to import it on QuickBooks Canadian edition. Or your .QBO file is from Canadian bank and you are trying to import into QuickBooks US edition. Use Bank2QBO to make your .QBO file importable into Quickbooks.
Your .QBO file was created from CSV or Excel file by third-party software. Use CSV2QBO to recreate QBO (Web Connect) file importable by Quickbooks.
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.
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!
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.
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.
