Can you import specific Chart of accounts from Excel to new company file?
We are creating two new Company files in Accounts hosted and want to import a specific chart of account from Excel. We also want to import a customer, supplier and item lists.
The Reckon Help says "About importing data from an Excel or CSV file:
Note: This feature is not supported by Reckon and is recommended for advanced users only
What does this mean? Does it mean it won't work or it works, but we'll encounter problems or issues that Reckon support wouldn't help us with?
if you can't import chart of accounts, customers, suppliers, items to new file using excel, how else are we supposed to do this? Its there a better or easier way to do this?
thanks
Debbie
Best Answer
-
You must first export a file template from Reckon then enter your exel details into it making sure that you maintain the top header lines as this dictates what Reckon need to import correctly. Then import it back into Reckon.
Gerry id 6376
Gerhard Winter
Ph. +61 0418907140
Reckon Store Next Door
"Always at your Service"
Email: gwinter0808@gmail.com
0
Answers
-
Export an iif file. Go to utilities - export - select whatever lists you need, tick all options and then import the file into the new company
i just reread your question and is it correct that you don’t have the required chart of accounts in a reckon file? Only a spreadsheet? I can’t advise anymore if that’s the case but I’m sure someone else will.
1 -
Thank you everyone for your feedback & comments. Very helpful in pointing us in the right direction from the start.
Debbie
1 -
Hi
We have tried to export our current ‘Chart of accounts’ to an IIF file and it’s saved on one peron’s desktop in Q drive. But we can’t seem to open it.
I’ve read the notes about exporting & importing list to IIF files but am still confused about how this works.
My understanding of the process is:
1 export a list (eg chart of accounts) to IIF file in Reckon. (file/Utilities/export/lists to IIF files.). have saved in Q drive on desktop
2 then open or view the IIF file in excel. However we can't seem to open this file in excel.
3 then update or make the changes to match reckon requirements. Ie the right format.
4. Then once finished, import to new company file.
I read a comment in a Reckon Community post that said: "The IIF file is a plain-text tab delimited file. You can open it in Excel"
How do we open the IIF file in excel?
thanks for any advice.
Debbie
0 -
Hi Zappy
How much would it cost to talk to you about this?
thanks
Debbie
0 -
hello,
I would really love to know the outcome of this scenario as I too have found it confusing as to how to get the information back into reckon hosted once changes have been made.
0 -
Did you download the file to your computer and then open it in Excel? You then save the new file in its original iif format, upload to Qdrive and go to file utilities and import it
0
Categories
- All Categories
- 6.6K Accounts Hosted
- 15 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 6 📢 Reckon Accounts Desktop - Announcements
- 1.4K Reckon Payroll 🚀
- 32 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 24 Reckon Mate App
- 2.6K Reckon One
- 8 📢 Reckon One - Announcements
- 12 Reckon Invoices App
- 15 Reckon Insights
- 99 Reckon API
- 308 Point of Sale
- 1.9K Personal Plus and Home & Business
- 66 About Reckon Community