Bulk suppliers: Reckon Hosted

Jacqui_7590379
Jacqui_7590379 Member Posts: 5
edited July 2017 in Accounts Hosted
Hi there,

We need to make a payment to about 1500 suppliers.  We use Reckon Hosted and bank with Commbiz.  Is there a way to bulk load into Reckon Hosted (from a spreadsheet) - either just supplier details or (even better) supplier details and invoice itself?  I know from Commbiz I can only bulk load payments from the ABA file so I have to enter all the invoices into Reckon individually.

Ideally I don't want to use an add-on or separate service as this is a one-off.

any help gratefully received.
Jacqui

Comments

  • Kathy Mackinlay_6947388
    Kathy Mackinlay_6947388 Member Posts: 141
    edited August 2015
    Can definitely do the Suppliers details. I would export the list of creditors you have and then add the ones you want to it. If you do it that way you know the fields you need to enter. Once you have done all your changes you will them import the file back into hosted and match the fields. It is quite easy and works well. I haven't done the bills but will give it a try.
  • Kathy Mackinlay_6947388
    Kathy Mackinlay_6947388 Member Posts: 141
    edited August 2015
    Check this http://support.quickbooks.intuit.com/support/articles/HOW12778. We import our clients invoices and credit notes every day. We export from another program. I do changes in the file in excel and make sure it is still an IIF file. Then upload to hosted. Then I use File/Utilities/import IIF files and select the file to import. The link is to the list of fields you need. I have sent a sample of a file to be imported by us. I have cut it in two and the first on e is the header part of the file imageimage the second one is the details for the bill itself. You do have to put 2 line in each bill but if you have the same thing for each bill it will be easy to copy and paste. Hope i have helped.
  • Kathy Mackinlay_6947388
    Kathy Mackinlay_6947388 Member Posts: 141
    edited August 2015
    sorry I put the pictures in the wrong order. You will see the second one has the suppliers details and the account that the entries will be charged to and what account type they are. You would pu the accounts payable and the expense or whatever account you are charging the bill to.
  • TamNguyen
    TamNguyen Member Posts: 48
    edited September 2015
    If you just need to update supplier details, I would try to go into utilities and import then chose the file you want to import either excel or IFF file. 
  • Jacqui_7590379
    Jacqui_7590379 Member Posts: 5
    edited August 2015
    wow thanks for that.  its looks a little complicated but I'm sure if we can make it work it will be a lot quicker than keying in 1500 new suppliers.  many many thanks for your help

  • Kathy Mackinlay_6947388
    Kathy Mackinlay_6947388 Member Posts: 141
    edited August 2015
    Hi Jacqui, It is worth effort. I did forget to mention to make sure the account you put in is EXACTLY the same spelling, spacing etc as that on quickbooks. If you don't it will create a new GL account for you and then you need to amalgamate them.