Community Homepage
Discussions
Categories
Quicken for Mac
Quicken Lifehub
Quicken Mobile
Quicken on the Web
Quicken for Windows
Support
Quicken Classic
Quicken Simplifi
Getting Started
Community Training FAQs
Using and Improving the Community
Announcements & Alerts
Announcements
Alerts, Online Banking & Known Product Issues
Product Ideas
Connect and Engage
The Community Meetup
The Water Cooler
The Lounge
Beta
Home
Quicken Classic for Windows
Investing (Windows)
How to move an investment account to a new quicken file
Scott M
Hi -- what are the steps to export and then import a quicken investment account from one quicken file to another Quicken file? Thank you.
I have Quicken Premier for Windows R44.28.
Find more posts tagged with
Accepted answers
BK
@Scott M
I successfully imported 10 years worth of data into a new Quicken file since my old one got corrupted a year ago. I tried it multiple times and learned the preferred sequence of steps for me. Then I prototyped it twice before my final one. This is the cheat sheet I created for myself in case I have to do it again or share with others. I hope this helps you a bit.
ADVANCE READING:
https://community.quicken.com/discussion/7903165/qif-file-export-and-import-question-from-old-to-new-data-file-qwin
https://community.quicken.com/discussion/7450045/i-just-succeeded-in-recreating-my-data-file-using-a-qif-export-import/p1
REQUIREMENTS:
* Have two computers (or VM) so that you can have the old and new files open side-by-side (This is KEY)
(Remember if you re-import something, you will have duplicates)
* Create systematic backups with meaningful names at every step
OLD FILE DATA EXPORT:
* Export data in QIF format, preferably in multiple chunks.
NEW FILE SETUP:
* Start with a new test file
* Setup tax filing (single, married, ...)
* Preferences: Edit investment Prefs > Complete & Enable transfer detection
* Import Categories & memorized payees
* Fix Categories (duplicates and add tax line items)
* Fix Memorized payees
* Import Security list
* Review security list for accuracy
* Create custom Fund Types if you had them before
* Create category groups if you had them before
* Create your renaming rules
* Validate File
ACCOUNT CREATION:
* Create your accounts manually first
* Setup paycheck
* Edit "Acc Type" as needed
* Validate File
TRANSACTION IMPORT:
* Import transactions
* Check for and cleanup duplicates, specially in investment accounts
* Correct investment account action (Deposits switched to Misc Income!)
* Fix Assets (cars & house)
* Double check for security list duplicates and cleanup
* Validate File
FINAL OPTIONAL ADD-ONS:
* Recreate Reports
* Add Flags as needed
* Add Attachments as needed
All comments
Chris_QPW
Oops. I misread the question. If it is all the transactions in one investment account, you can use a QIF export/import. Note that the transfers might be messed up in the new data file and have to be fixed.
q_lurker
@Chris_QPW
- I didn’t see a qualifier about a single security. Appears to be an entire account to transfer. Seems like a QIF export and import should be effective with caveats about transfers, security names and info, and other cautions you know more about than me.
Scott M
"...and other cautions you know more about than me?" Yes it is an entire account. My hope is that Quicken or a Quicken expert has documented the steps including any cautions or caveats, that I can then follow. Ideas?
BK
@Scott M
I successfully imported 10 years worth of data into a new Quicken file since my old one got corrupted a year ago. I tried it multiple times and learned the preferred sequence of steps for me. Then I prototyped it twice before my final one. This is the cheat sheet I created for myself in case I have to do it again or share with others. I hope this helps you a bit.
ADVANCE READING:
https://community.quicken.com/discussion/7903165/qif-file-export-and-import-question-from-old-to-new-data-file-qwin
https://community.quicken.com/discussion/7450045/i-just-succeeded-in-recreating-my-data-file-using-a-qif-export-import/p1
REQUIREMENTS:
* Have two computers (or VM) so that you can have the old and new files open side-by-side (This is KEY)
(Remember if you re-import something, you will have duplicates)
* Create systematic backups with meaningful names at every step
OLD FILE DATA EXPORT:
* Export data in QIF format, preferably in multiple chunks.
NEW FILE SETUP:
* Start with a new test file
* Setup tax filing (single, married, ...)
* Preferences: Edit investment Prefs > Complete & Enable transfer detection
* Import Categories & memorized payees
* Fix Categories (duplicates and add tax line items)
* Fix Memorized payees
* Import Security list
* Review security list for accuracy
* Create custom Fund Types if you had them before
* Create category groups if you had them before
* Create your renaming rules
* Validate File
ACCOUNT CREATION:
* Create your accounts manually first
* Setup paycheck
* Edit "Acc Type" as needed
* Validate File
TRANSACTION IMPORT:
* Import transactions
* Check for and cleanup duplicates, specially in investment accounts
* Correct investment account action (Deposits switched to Misc Income!)
* Fix Assets (cars & house)
* Double check for security list duplicates and cleanup
* Validate File
FINAL OPTIONAL ADD-ONS:
* Recreate Reports
* Add Flags as needed
* Add Attachments as needed
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Best Of
