Budget import file question

Caroline Plowman
Caroline Plowman Member Posts: 10
edited February 2018 in Accounts Hosted
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 2 days ago
Photo of Caroline Plowman

Caroline Plowman

  • 82 Points 75 badge 2x thumb




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

Comments

  • John G
    John G Reckon Staff Posts: 1,570 Reckon Staff
    edited February 2018
    Hello Caroline,

    Thanks for asking but I'm only able to make a few more comments.   

    You can't make any modifications to the output in Reckon Accounts.

    Inside the Excel file, the StartDate refers to the calendar year and the Amount columns refer to the months from January to December.  The configuration within your Company File will modify how this is presented on screen.  I believe there is no need to worry about this date.  

    You should be able to re-sort the rows to make more sense of it and delete what you don't want (eg past years budgets), and then return the rows to their original relative order.  You might have to devise a system to help you get the rows back to this order.  Perhaps it won't matter.

    Hope this helps.


    regards,
    John