Is there a way to convert data to a generic (known) format
My reason is that I have subsequently written (nearly finished) my own personal accounts program and would like to import my existing data.
Comments
-
Hi Steven,
From what I understand, exporting data is not possible, you can however generate reports and export them in .csv formatℹ️ Stay up to date with important news & announcements for your Reckon software! Click HERE for more info.
1 -
When in Reckon Personal, if you click on CTRL + SHIFT + Z you will then have a new menu in FILE > EXPORT where you can export a QIF file.
Regards, Robyn Kelly
2 -
Thank's Robyn, I try this when I get home.0
-
In Accounts personal plus 2015 that item is already in the FILE > EXPORT menu I think.
0 -
But it won't give you price histories.
0 -
Again, thanks Robyn, that did the trick. For me to further manipulate the data, it requires a bit of fiddling as you can only export to QIF per account. At least now I can manipulate the data.
As regards Price Histories, it appears they're included as well, as I clearly saw past dates of stocks and their prices. What it didn't include was the associated volume, open, high and low price.
In my copy of Reckon 2016 (personal) the only options under Export were Addresses and Desktop Super. Ctrl Shift Z added the QIF menu item.1 -
Chris I think you'll find this changed from version 2008 onwards that the QIF export doesn't appear automatically.
ALSO, if you go to the price history for each share - you can then print and click on the EXPORT TO: tab-delimited (Excel compatible) disk file.
This will then export price history for that share to .txt format. You can then right click once saving the file & open in excel.
You will need to repeat for each share.
Hope that helps?
Regards, Robyn Kelly
0 -
Steven - not sure if you saw above reply we must have been typing at the same time :-)
0 -
Robyn, yes, I hit the submit button 10 seconds before you. Read your reply and makes sense.
1 -
For those interested, I googled, "Anatomy of QIF" and came across this site: https://goo.gl/9yzplg. It's what I'll be referring to in order to manipulate the data (I'll have to match up all the transactions from many separate QIF files) before importing into my system.1
-
Steven and Robyn,
Thanks for your CTRL + SHIFT + Z and https://goo.gl/9yzplg information. I now have a possible escape - having used Quicken/Reckon since 1992.
I look forward to reading more of your journey Steven, if you are willing and/or able to share it.
1 -
No problems and I'm more than willing to share my experience as conversion progresses but, I am mindful that this is probably not the right forum to delve into the nitty gritty of the details. Check my profile if you want to touch base.0
-
I too am trying to export to a QIF file, I have upgraded from 2009 to 2015, but the CTRL+SHIFT+Z isn't working for me. Any suggestions?0
-
Hi Lish, I'm not sure if Reckon would pick up on your comment in this thread. It may be better to create a new thread purposely asking Reckon why CTRL-SHIFT-Z doesn't work.
0 -
What product are you using please Lish?0
Categories
- All Categories
- 6.4K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 5.9K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.3K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 3K Reckon One
- 7 📢 Reckon One - Announcements
- 10 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 307 Point of Sale
- 1.9K Personal Plus and Home & Business
- 63 About Reckon Community