Reckon Accounts Hosted - How can I import journals from excel?

  • 1
  • Question
  • Updated 6 days ago
Can i create my journal in excel and import it in Reckon Accounts Hosted?
Photo of Mike

Mike

  • 330 Points 250 badge 2x thumb

Posted 5 months ago

  • 1
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 37,062 Points 20k badge 2x thumb
I have a template for this kevin@zappy.com.au
Photo of Mike

Mike

  • 330 Points 250 badge 2x thumb
Great, can you also explain how this is imported into Reckon Hosted?
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 37,062 Points 20k badge 2x thumb
Precisely the same way it is imported to desktop.
Photo of Mike

Mike

  • 330 Points 250 badge 2x thumb
This is a forum for people with less knowledge then yourself to read and understand how to do things.  This is the reason I've asked for an explanation to be written on the forum so that other people will also benefit from reading it.  Your cryptic messages and arrogant tone are confusing and not at all in line with the point of the reckon community. 

Furthermore your equally cryptic email  where you tried to charge me for providing an example is not cool.
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 37,062 Points 20k badge 2x thumb
Mike Im sure ypu didnt come here expecting to get free help. Reckon is a complicated system and you are asking for detailed help on a complex task. I dont really care if you think my expertise is worthless I have a different view. I have helped dozens of people to do this already but I stopped at the point of actually doing the work for them. My offer is still open. Thank you for your time.
(Edited)
Photo of Mike

Mike

  • 330 Points 250 badge 2x thumb
I asked you to use a 4 line journal in the template you provided so that I could see how it would apply.  This would literally take 2 minutes (maybe less) to do.  Please don't try to play this off as something other than that.  You tried to do something unethical and I pulled you up on it.
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 37,022 Points 20k badge 2x thumb
Very funny Mike. Since when is it unethical to seek reward for effort? Take your time with an answer. I can wait.
(Edited)
Photo of Mike

Mike

  • 330 Points 250 badge 2x thumb
Move on Russell, I have.
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 37,022 Points 20k badge 2x thumb
Its Kevin Mike and I never stop moving. Just got back from a 13k run. Keep up the good work
Photo of Nicole Gough

Nicole Gough

  • 82 Points 75 badge 2x thumb
Hi Mike,

Did you ever sort this out?  I too am also trying to work out how to import a journal from excel so I can split wages against various projects quickly.

Any advice would be greatly appreciated.

Thaks
Nicole
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 37,022 Points 20k badge 2x thumb
You can import journals. You cannot import payroll. Drop me an email kevin@zappy.com.au
Photo of Mike

Mike

  • 330 Points 250 badge 2x thumb
Hi Nicole, 

I was able to find this out, although it took a while.  There is a template which is an .iif file type which can be opened and completed in excel.  To create an .iif
 file, complete the journal template in excel (as per below) then save as a Text (tab delimited) file type.  Open the folder where you saved the .txt file and rename the file to end with .iif as its file type.  After you have 1 .iif file type you can re-use it directly instead of having to go through this process each time.

I have uploaded an image so you can see the layout of a simple journal (you can add more lines as needed).  Note this is assuming you split your projects out by class.  Hope this helps.  I am new to using it but it saves me time.  The only issue i have encountered is rounding on larger journals - sometimes you will need to adjust the cents as reckon wont accept it if it does not balance exactly. There may be a better way to do it but overall this seems to work fine.

Once you have the .iif file as you need it.  First Make sure you are logged in to Reckon Hosted as Admin and switch to single user mode (under the file menu). Then upload the .iif file into Reckon using the red upload button (the same place you go to download exported reports from reckon - inside the little red suitcase icon).  

Once you have uploaded the file you then need to import it into Reckon.    Click File - Utilities - Import - IIF Files...  You will then need to choose the uploaded .iif file from the upload folder in Q drive (that's where it is for me anyway).  Click the file and import - if it works a message will pop up saying its been successful. And that's it.

I then go to the journal section in Reckon and check it looks ok.  Hope this helps.  Let me know if you get stuck, cheers.

Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 37,022 Points 20k badge 2x thumb
Anyone can do this. The search facility in Reckon is basic but its entirely satisfactory. I use it every day. Its not complicated.
Photo of Georgina Lawry

Georgina Lawry

  • 60 Points
Hello Mike,

I tried your template and it imported but it doesn't show the journal in my journals ledger. Do you know what I may have done wrong? 

Also is it possible to use this template for importing estimates? If so would you change any of the line items? 

Appreciate if you can give me guidance on how to import estimates? 

Many thanks,