Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO
Experience Working in Quicken 2020 with large files?

Experience Working in Quicken 2020 with large files?
Our clients uses Quicken files on behalf of their financial management clients. We would like to connect with a consultant that has relevant experience with using using large Quicken files, benefits of using 'year-end' copy, managing files via a network, etc. Any referrals would be appreciated.
Our clients uses Quicken files on behalf of their financial management clients. We would like to connect with a consultant that has relevant experience with using using large Quicken files, benefits of using 'year-end' copy, managing files via a network, etc. Any referrals would be appreciated.
0
Best Answer
-
Chris_QPW Member ✭✭✭✭
I think there use to be one person here that did financial consulting using Quicken, but advertising on here is not allowed any more so I don't know if he is still available or will see this.
After that all of the questions you have asked have been answered numerous times on here.
But I will summarize here.
"Large file size" is meaningless for Quicken like it it is for most database programs. The size of the file doesn't tell you anything about the performance. For non investment accounts until you get to around 32,000 transactions in a register there is very little difference. And then after that you should break up the account, not the data file. For investment accounts the number of transactions, securities, security lots, greatly affect the performance of that account, and there needs to be a lot less transactions in a given account. Note the use of attachments greatly increases the size of the data file, just because those files tend to be large, but do not affect performance.
Year end copy tends to be a useless function for people that feel the need to break up their data file so that they can't search all of their history and can't put it back into one data file if they change their minds. Year end copy removes reconciled non investment transactions, which don't usually affect the performance. It will not tough the investment transactions.
Storing your data file on the network is ill advised, because Quicken was never designed for it, and as such you have a higher risk of corrupting your data file, not to mention slower performance in Quicken for things like startup/loading of the data file or a given account.
And I will answer a question you didn't ask based this being used for multiple clients.
Again something that Quicken wasn't designed for.
Each Quicken data file is tied to a Quicken Id, which is tied to a subscription.
Any syncing of data to the associated Quicken Cloud account has the possibility of "cross communication" in both the sense of one data file getting the wrong transactions (when data files are copied instead of using a new data file), to possible "security concerns" since the one Quicken Id/password would have access to all the data files.(I'm using the latest Quicken subscription version)5
Answers
I would not recommend using the Year end copy or storing your working data file anywhere other than a local hard drive.
-also older versions as needed for testing
-Questions? Check out the Quicken Windows FAQ list
After that all of the questions you have asked have been answered numerous times on here.
But I will summarize here.
"Large file size" is meaningless for Quicken like it it is for most database programs. The size of the file doesn't tell you anything about the performance. For non investment accounts until you get to around 32,000 transactions in a register there is very little difference. And then after that you should break up the account, not the data file. For investment accounts the number of transactions, securities, security lots, greatly affect the performance of that account, and there needs to be a lot less transactions in a given account. Note the use of attachments greatly increases the size of the data file, just because those files tend to be large, but do not affect performance.
Year end copy tends to be a useless function for people that feel the need to break up their data file so that they can't search all of their history and can't put it back into one data file if they change their minds. Year end copy removes reconciled non investment transactions, which don't usually affect the performance. It will not tough the investment transactions.
Storing your data file on the network is ill advised, because Quicken was never designed for it, and as such you have a higher risk of corrupting your data file, not to mention slower performance in Quicken for things like startup/loading of the data file or a given account.
And I will answer a question you didn't ask based this being used for multiple clients.
Again something that Quicken wasn't designed for.
Each Quicken data file is tied to a Quicken Id, which is tied to a subscription.
Any syncing of data to the associated Quicken Cloud account has the possibility of "cross communication" in both the sense of one data file getting the wrong transactions (when data files are copied instead of using a new data file), to possible "security concerns" since the one Quicken Id/password would have access to all the data files.
Thanks for this thoughtful response which confirms some of what we knew and offers a bit of new useful insight too. If you would be wiling to talk by phone please let me know? [email removed] .
> First off, how about NOT posting the same question multiple times. On some forums, you would have been banned as a spammer.
Hello Splasher,
Please be assured that I feel sufficiently shamed for my crime of 'posting twice' there is apparently no excuse for begin both new and un-sure. A friendly forum member might suggest deleting one and how to do that, or even pointed me to the clearly not yet understood relevant guideline.
However, If the objective is to keep the forum as clean as possible of anyone with less experience, I don't think I could improve on your response.
Twice in the same category is an "oops"/mouse stutter, three times in different categories is spamming.
-also older versions as needed for testing
-Questions? Check out the Quicken Windows FAQ list
Windows 10 Pro 32 & 64-Bit Build 21296.1000
also Windows 10 Pro 64-Bit Build 19042.746
Note: Product What's New in Quicken is grayed out.. Also Year is stuck on 2020 and Copyright Date is stuck 2018 in About Quicken.
View: https://community.quicken.com/discussion/7859218/work-with-copies-of-your-actual-quicken-data-files/p1?new=1