cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

Import bills from Excel

I am trying to follow this guide for importing bills into QBO.

https://quickbooks.intuit.com/community/Getting-Started/Importing-Your-Bills/td-p/239463

I cannot get past the first line because nowhere is there an option for "Import Bills" as described.

15 Comments
Highlighted
QuickBooks Team

Import bills from Excel

I’m happy to see you today, RyanErickson.


Welcome to the Online Community. I’m here to clarify why you’re unable to see the Import Bills option.


This feature is currently available in Canada and the UK versions. If you’re in the US, there’s not a direct way of importing bills into QuickBooks.

 

You may search for third-party applications that integrate well and provide seamless importing of bills. Though, we're unable to provide recommendations which one to use.

 

I suggest you visit the QuickBooks Apps site and look for an app that meets your business needs. You can also do this inside your company, just go to Apps on the left panel and then enter a keyword in the search field. 

 

For more insights check out the Apps that work with QuickBooks article. 


This should point you in the right direction. If you have any questions or concerns about QBO, please let me know by leaving a comment below. I’ll be right here to answer them.

 

Highlighted
Level 3

Import bills from Excel

Hello RyanErickson,

 

  As there is already conversation touches thrid-party apps that could be used to import bills to a US company - then I would like to name one that in my opinion will be the most convenient one to use.

 

  The app I am talking about is Business Importer app, and as mention by 

 

 

Highlighted
Level 2

Import bills from Excel

I'm aware of 3rd party apps that perform this.

But why is there a guide describing something that apparently doesn't exist?

Highlighted
Anonymous
Not applicable

Import bills from Excel

Thanks for getting back, @RyanErickson.

 

Allow me to step in for a moment and help share some insights about the guide for importing bills into QBO.

 

The article guide you're referring to is only applicable to Canada and UK versions. As what my colleague @Rasa-LilaM mentioned on this thread, this isn't available yet using the US version of QuickBooks.

 

If you need some references in the future, please feel free to access our site: Help articles for QuickBooks Online. To view the articles for QuickBooks US, make sure to change the flag beside the Go to QuickBooks.com on the upper right corner.

 

Keep me posted if you need anything else. I'm also here to help.

Highlighted
Level 1

Import bills from Excel

How disappointing! When will this feature be coming to the US instance of QuickBooks? ...certainly the framework is there to implement it. 

Highlighted
QuickBooks Team

Import bills from Excel

Hello, @BrooksideLLC,

 

We don't have the specific estimated time on when the import bills feature will be available in the US version.

 

You will need to enter your data manually to record vendor bills.

 

Here's how:

  1. Click the + (plus) icon at the right top.
  2. Under Vendors, select Bill.
  3. Select a vendor from the drop-down list.
  4. Complete other fields on this page.
  5. Use the Account details or Item details sections to enter bill information.
  6. Click Save and close.

To pay your bills:

  1. Click the + (plus) icon at the right top.
  2. Under Vendors, select Pay Bills.
  3. Select the vendor from the list by clicking the box before the payee's name.
  4. Click Save and close to exit.

You can also read through this article for the detailed steps: How to enter and pay bills.

 

You're able to record your bills in QuickBooks Online.

 

If there's anything I can help you with recording your transactions, please let me know. I'm always glad to help.

Highlighted
Level 2

Import bills from Excel

Is this feature STILL not available in the US? 

Highlighted
QuickBooks Team

Import bills from Excel

Hi sarroyo22,

 

As mentioned by the previous agents who replied on this thread, this feature isn't available in QuickBooks Online (QBO) US version. We don't have a specific time on when this will be available in the US version. But, I'll pass this along to our product team to let them know the urgency of your business needs.

 

You'll want to manually enter your bills so you can record them in (QBO).

 

After you've recorded your transactions, you can match and categorize them: Match and Categorize Bank Transactions in QuickBooks Online.

 

Let me know if you need anything else. I'd be glad to help.

Highlighted
Level 2

Import bills from Excel

Thank you. If I'm using a desktop version of QuickBooks, would I have to use a third-party tool to import bills into QuickBooks? Or is it not possible at all?

Highlighted
Moderator

Import bills from Excel

Thank you for joining in the thread, @sarroyo22.

 

Aside from using a third-party tool, you can also use the Intuit Interchange Format (IIF) files.  These are cross-platform text files that can help manage your company data. You can import vendor bills as well as vendor bill refunds and other transactions using this file.

 

To know more about this, please check the following articles:

 

 

You can download and install the .IIF import kit and the sample files to practice importing transactions into QuickBooks. This will be your guide when working with the import files. 

 

Please don't hesitate to let me know if there's anything else I can do for you, I strive to be your number one resource for QuickBooks. Have a great day!

Highlighted
Level 14

Import bills from Excel

@sarroyo22 

If you are not familiar with IIF, utilize the 3rd party tool to import your data

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Hope it helps.

 

Highlighted
Level 1

Import bills from Excel

Why don't we have this option for USA. It does not make sense at all. I am both Canadian and USA client of QBO  and really finding it hard to manually enter the bills for our USA company. Whats the issue here of not having in USA but the same software has it in Canada. Please explain 

Highlighted
QuickBooks Team

Import bills from Excel

Good day to you, @Kaukab5.

 

Let me share some information as to why the Import Bill feature in QuickBooks Online (QBO) isn't available in the US. Each region has different needs. Examples of this are VAT in the UK while in the US its sales tax and for Canada its GST. 

 

It takes time to convert those data to other regions' currency and tax type. Rest assured, QuickBooks always strive to meet our customer needs. As we don't have a specific time frame as to when this feature will roll out in the US. I recommend checking our QuickBooks blog page to stay updated on the latest news and updates in QuickBooks.

 

In the meantime, you can consider the workaround suggested by colleague Rasa-LilaM above in looking for a third-party app that meets your business needs. You can also check this article for additional reference in choosing the right app: Apps that work with QuickBooks.

 

Please let me know if there's anything else you need help with. I'll be around to help you. Take care!

Highlighted
Level 14

Import bills from Excel

@Kaukab5 

For the time being, utilize the trial period of TP Importer for Online

https:// transactionpro.grsm.io/qbo

 

The you may utilize MP as another app to pay your biils to US vendors or Veem for multi currency transactions.

https:// melio.grsm.io/quickbooks

https:// veem.grsm.io/veems

 

Hope it helps.

Highlighted
Level 6

Import bills from Excel

Hi, 

 

Its time to increase the limits maximum of 100 invoices at a time and 1,000 row limit per spreadsheet as its been years now and many business does have stuck with these limits. 

 

Hope QuickBooks Team will understand this concern and do the needful in respect of the same. 

Need to get in touch?

Contact us