http://m.getsatisfaction.com/topics/7734917 Import Bills to Online Hosted Reckon 2018 for NZ Company 2018-05-21T02:40:55Z 2018-05-13T23:54:06Z 7734917 http://m.getsatisfaction.com/topics/7734917 7734917 Import Bills to Online Hosted Reckon 2018 for NZ Company 2018-05-21T02:40:55Z 2018-05-13T23:54:06Z paul http://m.getsatisfaction.com/people/9661917 https://www.gravatar.com/avatar/1cf53bafc3ad7b8b83c7fa3a56009b2e?d=identicon&s=55&r=PG paul_kgspwlt40pdn3 I am trying to find the correct format for importing a Bill into Reckon Hosted 2018 for an NZ company. I followed the help file for setting up the columns for an imported invoice, but that ended up importing as an adjustment note. I found another message on the forum that says that the help is actually for a US set up. Does anyone know definitively what the column layout and data needs to be to import a Bill in the iif format ? question complete 17 5 2 comment http://m.getsatisfaction.com/topics/7734917/replies/19520319 http://m.getsatisfaction.com/topics/7734917 19520319 Kevin Russell responded to "Import Bills to Online Hosted Reckon 2018 for NZ Company" 2018-05-14T02:09:46Z 2018-05-14T02:09:46Z Kevin Russell http://m.getsatisfaction.com/people/7048678 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10842939/20151028_181440_medium.jpg kevin_russell_6743312 Yup <br /><br /> Send me an email <a href="mailto:kevin@zappy.com.au" rel="nofollow">kevin@zappy.com.au</a> <br /><br /> Kr 0 http://m.getsatisfaction.com/topics/7734917/replies/19520486 http://m.getsatisfaction.com/topics/7734917/replies/19520319 19520486 paul responded to "Import Bills to Online Hosted Reckon 2018 for NZ Company" 2018-05-14T05:42:02Z 2018-05-14T05:42:02Z paul http://m.getsatisfaction.com/people/9661917 https://www.gravatar.com/avatar/1cf53bafc3ad7b8b83c7fa3a56009b2e?d=identicon&s=55&r=PG paul_kgspwlt40pdn3 Many thanks for that Kevin. Appreciate your help. 1 http://m.getsatisfaction.com/topics/7734917/replies/19520504 http://m.getsatisfaction.com/topics/7734917/replies/19520319 19520504 Kevin Russell responded to "Import Bills to Online Hosted Reckon 2018 for NZ Company" 2018-05-14T06:00:56Z 2018-05-14T06:00:56Z Kevin Russell http://m.getsatisfaction.com/people/7048678 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10842939/20151028_181440_medium.jpg kevin_russell_6743312 Delighted to be of assistance Paul. 0 http://m.getsatisfaction.com/topics/7734917/replies/19530049 http://m.getsatisfaction.com/topics/7734917 19530049 Masha responded to "Import Bills to Online Hosted Reckon 2018 for NZ Company" 2018-05-18T04:12:48Z 2018-05-18T04:12:48Z Masha http://m.getsatisfaction.com/people/9667009 https://www.gravatar.com/avatar/1d6b35ef2ac40b918d60caa22a6ab540?d=identicon&s=55&r=PG masha_cquog1xofgtrv Hi<br />I am trying to do the same thing.&nbsp; I need to import a bill&nbsp;into Reckon Hosted Edition 2017 for an AU company.<br />Could you please explain me how I can do it?<br />Thank you<br />Masha 0 http://m.getsatisfaction.com/topics/7734917/replies/19530067 http://m.getsatisfaction.com/topics/7734917/replies/19530049 19530067 Kevin Russell responded to "Import Bills to Online Hosted Reckon 2018 for NZ Company" 2018-05-18T04:28:20Z 2018-05-18T04:28:20Z Kevin Russell http://m.getsatisfaction.com/people/7048678 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10842939/20151028_181440_medium.jpg kevin_russell_6743312 I can send you the template. I made the mistake of doing it for someone once. He was not at all grateful. Ill send it through today. 0 http://m.getsatisfaction.com/topics/7734917/replies/19530082 http://m.getsatisfaction.com/topics/7734917/replies/19530049 19530082 paul responded to "Import Bills to Online Hosted Reckon 2018 for NZ Company" 2018-05-18T04:46:01Z 2018-05-18T04:46:01Z paul http://m.getsatisfaction.com/people/9661917 https://www.gravatar.com/avatar/1cf53bafc3ad7b8b83c7fa3a56009b2e?d=identicon&s=55&r=PG paul_kgspwlt40pdn3 Note also that the iif format is very unforgiving. If there is a problem with the data, Reckon will not give you any hint of what the problem is. It doesn't even tell you the line or column that it has a problem with. A couple of things that tripped me up were : The date format must be MM/DD/YYYY and using a Supplier name that already existed in the Company as a Customer name. 0 http://m.getsatisfaction.com/topics/7734917/replies/19530103 http://m.getsatisfaction.com/topics/7734917/replies/19530049 19530103 Masha responded to "Import Bills to Online Hosted Reckon 2018 for NZ Company" 2018-05-18T05:07:40Z 2018-05-18T05:07:40Z Masha http://m.getsatisfaction.com/people/9667009 https://www.gravatar.com/avatar/1d6b35ef2ac40b918d60caa22a6ab540?d=identicon&s=55&r=PG masha_cquog1xofgtrv Thank you!! I will be very grateful if you can help! 0 http://m.getsatisfaction.com/topics/7734917/replies/19531854 http://m.getsatisfaction.com/topics/7734917/replies/19530049 19531854 Masha responded to "Import Bills to Online Hosted Reckon 2018 for NZ Company" 2018-05-18T23:04:03Z 2018-05-18T23:04:03Z Masha http://m.getsatisfaction.com/people/9667009 https://www.gravatar.com/avatar/1d6b35ef2ac40b918d60caa22a6ab540?d=identicon&s=55&r=PG masha_cquog1xofgtrv Hi Kevin and Paul<br /> Could you please explain me how to import Bills?<br /> Paul, I understand that the iif is not ideal, but did you manage to do it? Is it possible at alll?<br /> Could you please share with me your knowledge and experiences :)<br /> I will be very grateful for any help :)))<br /> Masha 0 http://m.getsatisfaction.com/topics/7734917/replies/19532106 http://m.getsatisfaction.com/topics/7734917/replies/19530049 19532106 Chandra,Professional Partner, chandra@cosmicinnovations.com responded to "Import Bills to Online Hosted Reckon 2018 for NZ Company" 2018-05-19T03:03:07Z 2018-05-19T03:03:07Z Chandra,Professional Partner, chandra@cosmicinnovations.com http://m.getsatisfaction.com/people/6779064 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10516777/Newphotoforemail_medium.jpg chandra_6473995 I am curious to know what we talking here . Is this actual bill invoice with single lines or multiple lines invoices to be imporTed <br /> Pls correct me if I am wrong 0 http://m.getsatisfaction.com/topics/7734917/replies/19532137 http://m.getsatisfaction.com/topics/7734917/replies/19530049 19532137 Masha responded to "Import Bills to Online Hosted Reckon 2018 for NZ Company" 2018-05-19T03:38:34Z 2018-05-19T03:38:34Z Masha http://m.getsatisfaction.com/people/9667009 https://www.gravatar.com/avatar/1d6b35ef2ac40b918d60caa22a6ab540?d=identicon&s=55&r=PG masha_cquog1xofgtrv Thank you Chandra,<br />This is a bill with single line and I have a lot of such bills that I need to import.<br />I hope I understооd your question correctly.&nbsp; 0 http://m.getsatisfaction.com/topics/7734917/replies/19532144 http://m.getsatisfaction.com/topics/7734917/replies/19530049 19532144 Chandra,Professional Partner, chandra@cosmicinnovations.com responded to "Import Bills to Online Hosted Reckon 2018 for NZ Company" 2018-05-19T03:48:41Z 2018-05-19T03:48:41Z Chandra,Professional Partner, chandra@cosmicinnovations.com http://m.getsatisfaction.com/people/6779064 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10516777/Newphotoforemail_medium.jpg chandra_6473995 Yes ok in say 3 weeks time we will be launching fully automated bills syNC with multiple line items technology<br />This Is a great technology built on AI and OCR <br />We will integrate 1st wirh RAH<br />But you in NZ I understand we don't have Api for it <br />But there can be another option <br />You may call me on skype: chandra710<br />Unless some one else has other solution in this forum 1 http://m.getsatisfaction.com/topics/7734917/replies/19533953 http://m.getsatisfaction.com/topics/7734917/replies/19530049 19533953 paul responded to "Import Bills to Online Hosted Reckon 2018 for NZ Company" 2018-05-20T20:29:58Z 2018-05-20T20:29:58Z paul http://m.getsatisfaction.com/people/9661917 https://www.gravatar.com/avatar/1cf53bafc3ad7b8b83c7fa3a56009b2e?d=identicon&s=55&r=PG paul_kgspwlt40pdn3 Hi Masha,<br />Yes, it's easy to do if you have the correct format, although it is a manual operation. Once you have an iif file (or multiple files) you need to upload it to your locally hosted drive. See the Reckon help video here on how to do this&nbsp;<a href="https://www.youtube.com/watch?v=R1K93TrteAA" rel="nofollow" title="Link: https://www.youtube.com/watch?v=R1K93TrteAA">https://www.youtube.com/watch?v=R1K93TrteAA</a><br />Once uploaded, you can then import it by going to File--&gt;Utilities--&gt;Import--&gt;IIf Files... That will open a window to the drive where you just uploaded your file(s). In there will be an Upload folder which is where you will find the file(s) you uploaded. You then just click on the file and it will be imported.&nbsp; Note that there are a few third party applications about that can automate this sort of thing as well. 0 http://m.getsatisfaction.com/topics/7734917/replies/19534180 http://m.getsatisfaction.com/topics/7734917/replies/19530049 19534180 Masha responded to "Import Bills to Online Hosted Reckon 2018 for NZ Company" 2018-05-21T00:12:48Z 2018-05-21T00:12:48Z Masha http://m.getsatisfaction.com/people/9667009 https://www.gravatar.com/avatar/1d6b35ef2ac40b918d60caa22a6ab540?d=identicon&s=55&r=PG masha_cquog1xofgtrv Hi Paul,<br />Thank you very much for your detailed answer. It's really useful!<br />You are right about the correct format - it's easy to do if you know which headers to use and what values to assign to them.<br /><br />Now my problem that I don't know what headers I need to use to set the "Amounts includes tax" flag in the Bill information window.<br />I have already posted this question in here:&nbsp;<a href="https://community.reckon.com/reckon/topics/iif-transaction-imports-amounts-include-tax-flag" rel="nofollow" target="_blank" title="Link https//communityreckoncom/reckon/topics/iif-transaction-imports-amounts-include-tax-flag">https://community.reckon.com/reckon/topics/iif-transaction-imports-amounts-include-tax-flag</a><br /><br />If you have any ideas, I will be very grateful<br />Masha 0 http://m.getsatisfaction.com/topics/7734917/replies/19534290 http://m.getsatisfaction.com/topics/7734917/replies/19530049 19534290 paul responded to "Import Bills to Online Hosted Reckon 2018 for NZ Company" 2018-05-21T01:03:21Z 2018-05-21T01:03:21Z paul http://m.getsatisfaction.com/people/9661917 https://www.gravatar.com/avatar/1cf53bafc3ad7b8b83c7fa3a56009b2e?d=identicon&s=55&r=PG paul_kgspwlt40pdn3 I couldn't work that out myself. However, if the amount you send in the header line is inclusive of tax and the details you send in the detail lines have the exclusive amount and the tax amount in the correct columns (and everything balances), then checking and unchecking that flag just changes the display of the bill on screen, it doesn't do any re-calculations. 0 http://m.getsatisfaction.com/topics/7734917/replies/19534358 http://m.getsatisfaction.com/topics/7734917/replies/19530049 19534358 Masha responded to "Import Bills to Online Hosted Reckon 2018 for NZ Company" 2018-05-21T02:28:49Z 2018-05-21T02:28:49Z Masha http://m.getsatisfaction.com/people/9667009 https://www.gravatar.com/avatar/1d6b35ef2ac40b918d60caa22a6ab540?d=identicon&s=55&r=PG masha_cquog1xofgtrv Thank you very much Paul :)) 0 http://m.getsatisfaction.com/topics/7734917/replies/19534366 http://m.getsatisfaction.com/topics/7734917/replies/19530049 19534366 Kevin Russell responded to "Import Bills to Online Hosted Reckon 2018 for NZ Company" 2018-05-21T02:32:26Z 2018-05-21T02:32:26Z Kevin Russell http://m.getsatisfaction.com/people/7048678 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10842939/20151028_181440_medium.jpg kevin_russell_6743312 I suspect Reckon dont want you to this. Its probably difficult for a reason. Possibility of database corruption 0 http://m.getsatisfaction.com/topics/7734917/replies/19534373 http://m.getsatisfaction.com/topics/7734917/replies/19530049 19534373 Masha responded to "Import Bills to Online Hosted Reckon 2018 for NZ Company" 2018-05-21T02:40:55Z 2018-05-21T02:40:55Z Masha http://m.getsatisfaction.com/people/9667009 https://www.gravatar.com/avatar/1d6b35ef2ac40b918d60caa22a6ab540?d=identicon&s=55&r=PG masha_cquog1xofgtrv Thank very much Kevin! It is good to know, so I will stop trying to find a way to do this :))<br />I really appreciate your help in this matter!<br />Masha 1