Import Bills to Online Hosted Reckon 2018 for NZ Company

  • 2
  • Question
  • Updated 7 months ago
  • Answered
  • (Edited)
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 ?
Photo of paul

paul

  • 150 Points 100 badge 2x thumb

Posted 7 months ago

  • 2
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 40,914 Points 20k badge 2x thumb
Yup

Send me an email kevin@zappy.com.au

Kr
Photo of paul

paul

  • 150 Points 100 badge 2x thumb
Many thanks for that Kevin. Appreciate your help.
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 40,914 Points 20k badge 2x thumb
Delighted to be of assistance Paul.
Photo of Masha

Masha

  • 180 Points 100 badge 2x thumb
Hi
I am trying to do the same thing.  I need to import a bill into Reckon Hosted Edition 2017 for an AU company.
Could you please explain me how I can do it?
Thank you
Masha
Photo of Masha

Masha

  • 180 Points 100 badge 2x thumb
Hi Paul,
Thank you very much for your detailed answer. It's really useful!
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.

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.
I have already posted this question in here: https://community.reckon.com/reckon/topics/iif-transaction-imports-amounts-include-tax-flag

If you have any ideas, I will be very grateful
Masha
Photo of paul

paul

  • 150 Points 100 badge 2x thumb
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.
Photo of Masha

Masha

  • 180 Points 100 badge 2x thumb
Thank you very much Paul :))
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 40,860 Points 20k badge 2x thumb
I suspect Reckon dont want you to this. Its probably difficult for a reason. Possibility of database corruption
Photo of Masha

Masha

  • 180 Points 100 badge 2x thumb
Thank very much Kevin! It is good to know, so I will stop trying to find a way to do this :))
I really appreciate your help in this matter!
Masha