cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Sabrah
Level 2

Vendor Bill Entry

Is there a way to bulk enter or import vendor bills from an excel spreadsheet in QB Desktop?  I have a vendor that can issue as many as 50 bills a day.  Thanks.

2 Comments 2
BigRedConsulting
Community Champion

Vendor Bill Entry

There's no good way to do this built into QuickBooks.

 

However, you can convert the worksheet into an IIF file for import. Use our BRC IIF Transaction Creator Pro to help you convert your list of Bills into an IIF file for import.

RCV
QuickBooks Team
QuickBooks Team

Vendor Bill Entry

Thanks for checking in with us, Sabrah.

 

If you are using QuickBooks Desktop Accountant and Enterprise Solutions version, we can enter transactions by batch. Just follow the steps and details in the Enter transactions by batch in QuickBooks Desktop article. If not, we can use the Intuit Interchange Format (IIF) files to import Vendor bills to and from QuickBooks Desktop for Windows and Mac. Here's how:

  1.  Back up your company file before you import IIF files. If you ever run into problems, you can use your backup to restore your data.
  2. Sign in to your company file as an admin. If you’re in Multi-user mode, go to the File menu, then select Switch to Single-user Mode.
  3. Go to the File menu, then select Utilities.
  4. Tap Import, then select Import IIF.
  5. Choose the IIF file you want to import, then select Open.
  6. Select OK to confirm the import.

 

To learn more about this one, see the Export, import, and edit IIF files article. You can also check out these articles for more details about IIF files:

 

Feel free to visit our Expenses and vendors page for more insights about managing your vendor transactions.

 

I want to make sure everything is taken care of for you, please let me know how it goes or if you have any other issues or concerns. Just leave a comment below and I'll get back to you. You have a good one.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us