Bulk suppliers: Reckon Hosted
Jacqui_7590379
Member Posts: 5 ✭
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
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
0
Comments
-
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.0
-
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 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.1
-
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.0
-
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.0
-
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
0 -
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.0
Categories
- All Categories
- 6.8K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 18 📢 Reckon Payroll - Announcements
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 325 Point of Sale
- 1.9K Personal Plus and Home & Business
- 73 About Reckon Community