import budgets

Maria_8697178
Maria_8697178 Member Posts: 7
edited August 2019 in Accounts Hosted
Hi does anybody know how to import budgets into Reckon Accounts Hosted from Excel file?

Comments

  • Maria_8697178
    Maria_8697178 Member Posts: 7
    edited August 2019

    Of course.  They tell you how to create budgets but not how to import already populated Excel spreadsheet.  I also phoned Reckon Technical Help, who told me you cannot import budgets created in Excel into Reckon at all.  I was dubious of that answer so thought I'd check with the community.


  • Pam_9173848
    Pam_9173848 Member Posts: 34
    edited November 2017
    Hello Kevin as I have a vested in this subject too, I am also with Maria to think that it could be done in this day and age..  Your answer of looks like youre in trouble would make me want to change softwares. 
  • Pam_9173848
    Pam_9173848 Member Posts: 34
    edited November 2017
    Hello Kevin, and I am well and truly with you on that one, changing softwares is for marketers not for real life as the general business owners have no idea what can and does go wrong in the background.  I would like to see Reckon back at the top of the pack again.   However that comment wasnt at all necessary especially to someone who is trying to achieve something -  and I didnt say I would change I said a comment like that would make me want to change softwares. 
  • John G
    John G Reckon Staff Posts: 1,570 Reckon Staff
    edited August 2019
    Hello Maria, Pam.

    There is no direct way to import a Budget from Excel to Reckon Accounts.  However, you can export a budget template from Reckon Accounts to an IIF file (File > Utilities > Exports > files to IIF > Budgets), open it in Excel, replace the values with your values from Excel, save the file as an IIF file and import it back into Reckon Accounts (File > Utilities > Import > IIF files).

    Hope this helps.

    regards,
    John
  • Pam_9173848
    Pam_9173848 Member Posts: 34
    edited November 2017
    Thanks John!
  • Pam_9173848
    Pam_9173848 Member Posts: 34
    edited November 2017
    This leads to another query as iif files arent that common - how do you save the file as an iif file when bringing it back into the data file.  I have tried this before and gave up.

  • John G
    John G Reckon Staff Posts: 1,570 Reckon Staff
    edited November 2017
    Hi Pam,

    In Excel, always choose to save the file in its original format - TXT .  Then in Windows Explorer rename the TXT file extension to IIF.  

    regards,
    Johon
  • Pam_9173848
    Pam_9173848 Member Posts: 34
    edited November 2017
    Aha, thankyou!! 
  • Brad_9389892
    Brad_9389892 Member Posts: 2
    edited August 2019
    Kevin, something troubling about your comments this week. Rather negative, possibly reflecting something troubling you generally. Take a break from the forum and reflect upon how best to contribute and assist.  
  • Brad_9389892
    Brad_9389892 Member Posts: 2
    edited November 2017
    John, thank you for your valued input.
  • Caroline Plowman
    Caroline Plowman Member Posts: 10
    edited February 2018
    Hello John
    I am trying to do the same thing. However my budget file has 10 years of data and exports / imports all of that; is there a way to amend the file (either in Reckon or in the IIF file) so that I can make it smaller.

    Also I have noticed that the export start date is always 1 January so that for a 1 April balance date, 2 lines are required (ie one starting 1 Jan 2018 for Apr-Dec 18 and one line starting 1 Jan 19 for Jan-Mar 190. Can you manipulate the file to say start date 1 April 2018? (this does not seem to work for me neither).

    Appreciate your input please.
    Regards
    Caroline
  • Dianne Hawkes
    Dianne Hawkes Member Posts: 1
    edited June 2019
    Hi,
    i am doing exactly as you say and Reckon says - Your data has been imported, but when i check the budget, the figures are still the old figures.
    I only wish to import some of hte budgets - some have already been entered manually.
    Do i have to delete the entire budget before importing?
    thanks
    Dianne
  • Brijesh Panchal
    Brijesh Panchal Member Posts: 1
    edited August 2019
    Hello John,
    I am trying to export Budget from Reckon, but I cannot see the option in File>Utilities>Export>Files to IIF. where else can I export the budget from. can you please assist?
  • glendaveale
    glendaveale Member Posts: 176 ✭✭
    edited August 2019
    If you open the budget report, you can export from there to excel.