Difference between revisions of "Quicken"
(→data file extensions) |
|||
(5 intermediate revisions by one user not shown) | |||
Line 17: | Line 17: | ||
* .qfx - Quicken Financial Exchange Data | * .qfx - Quicken Financial Exchange Data | ||
* .qif - Quicken Interchange Format Data | * .qif - Quicken Interchange Format Data | ||
+ | |||
+ | == legacy version support == | ||
+ | New versions of Quicken will not directly open data from older Quicken versions. | ||
+ | |||
+ | [[File:convertyourquickenfile.jpg]] | ||
+ | |||
+ | === convert old format to new Quicken format === | ||
+ | If you need 2004 as an intermediate to perform conversion of a very old version, then see [http://www.quicken.com/how-and-when-use-intermediate-version-convert-older-versions-quicken How and When to Use an Intermediate Version To Convert Older Versions of Quicken] | ||
+ | |||
+ | If, for example, you are using Quicken for Windows 2001 and want to upgrade to Quicken for Windows 2014. You will want to install Quicken 2004 first (the intermediate version) so your file can convert properly to the newer format. Once your file has been properly converted, then you can install Quicken 2014 and convert your file again. | ||
+ | |||
+ | The first 6 versions of Quicken for Windows were called Quicken 1, Quicken 2, etc. After Quicken 6, Intuit started using the year as a convention for naming our software. That started with Quicken 98. | ||
+ | |||
+ | === print from Quicken 2000 === | ||
+ | * Old Quicken + new PC = can't print | ||
+ | When running Quicken 2000 on Microsoft Windows 7, you will not be able to access the printers. The old Quicken was not programmed correctly and therefore cannot recognize the printers via the correct Windows API. | ||
+ | |||
+ | You can choose to print to a [[Microsoft XPS Document]]. | ||
+ | |||
+ | According to Microsoft, "''After printing to the .xps file format, you can view an XPS document by browsing to it and opening it. You can print a paper copy, share the XPS document, or send it to a commercial printer or to other people in any way that you prefer.''" | ||
== convert Quicken data to Excel format == | == convert Quicken data to Excel format == | ||
Line 32: | Line 52: | ||
#Switch to Excel. | #Switch to Excel. | ||
#Use Excel's Open command, and navigate to the file containing your report data | #Use Excel's Open command, and navigate to the file containing your report data | ||
+ | |||
+ | [[Category:Computer_Technology]] | ||
+ | [[Category:Software]] |
Latest revision as of 16:48, 1 April 2016
Quicken is a personal finance management tool by the company Intuit.
Contents
data file extensions
- .qdf -
- .qdt - Intuit Quicken v4 Data File
- .qel - Quicken Electronic Library
- .qsd - Intuit Quicken Data file
- .qph - Quicken Price History
- .cat - Quicken IntelliCharge Categorization
- .zix - Quicken Data
- .hif - Quicken Online Data
- .kmy - Money Data
- .ofx - Open Financial Exchange Document
- .ofc - Open Financial Connectivity Document
- .qfx - Quicken Financial Exchange Data
- .qif - Quicken Interchange Format Data
legacy version support
New versions of Quicken will not directly open data from older Quicken versions.
convert old format to new Quicken format
If you need 2004 as an intermediate to perform conversion of a very old version, then see How and When to Use an Intermediate Version To Convert Older Versions of Quicken
If, for example, you are using Quicken for Windows 2001 and want to upgrade to Quicken for Windows 2014. You will want to install Quicken 2004 first (the intermediate version) so your file can convert properly to the newer format. Once your file has been properly converted, then you can install Quicken 2014 and convert your file again.
The first 6 versions of Quicken for Windows were called Quicken 1, Quicken 2, etc. After Quicken 6, Intuit started using the year as a convention for naming our software. That started with Quicken 98.
print from Quicken 2000
- Old Quicken + new PC = can't print
When running Quicken 2000 on Microsoft Windows 7, you will not be able to access the printers. The old Quicken was not programmed correctly and therefore cannot recognize the printers via the correct Windows API.
You can choose to print to a Microsoft XPS Document.
According to Microsoft, "After printing to the .xps file format, you can view an XPS document by browsing to it and opening it. You can print a paper copy, share the XPS document, or send it to a commercial printer or to other people in any way that you prefer."
convert Quicken data to Excel format
- Go to the "Reports" menu in Quicken and run the report you wish to export to Excel. If needed, change the date range of the displayed data using the drop-down menu to access the information you need.
- Copy the data using the "Copy" button at the top of the report.
- Open MS Excel. Create a new spreadsheet by choosing "New" under the "File" menu.
- Go to the "Edit" menu and choose "Paste." The data you copied from your Quicken report should appear on the spreadsheet.
- Save the spreadsheet using the file name of your choice by clicking "Save" under the "File" menu.
Another Method:
- In Quicken, display the report you want to export.
- On the toolbar, click Export Data.
- Choose To Excel Compatible Format.
- In the File name field, enter a name for the file.
- Switch to Excel.
- Use Excel's Open command, and navigate to the file containing your report data