Can you import specific Chart of accounts from Excel to new company file?

DebADebA Member Posts: 12

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

  • GerryWinterGerryWinter Accredited Partner Posts: 658 ✭✭✭
    Accepted 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.

Answers

  • Kris_WilliamsKris_Williams Member Posts: 1,958 ✭✭✭✭
    edited September 7

    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.

  • ZappyZappy Accredited Partner Posts: 4,764 ✭✭✭

    Did you look in the help files? Yes you can. Its not easy.

  • DebADebA Member Posts: 12

    Thank you everyone for your feedback & comments. Very helpful in pointing us in the right direction from the start.

    Debbie

  • DebADebA Member Posts: 12

    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

  • ZappyZappy Accredited Partner Posts: 4,764 ✭✭✭

    Yeah Deb. Call me 0407744914


    Its a piece of cake


    Zappy

  • DebADebA Member Posts: 12

    Hi Zappy

    How much would it cost to talk to you about this?

    thanks

    Debbie

  • ZappyZappy Accredited Partner Posts: 4,764 ✭✭✭

    Nuthin. Call me any time.

    Zappy 0407744914

Sign In or Register to comment.