cancel
Showing results for 
Search instead for 
Did you mean: 
sshafar
Level 1

Can I import a spread sheet to the batch transactions, specifically bills.

 
3 Comments 3
SashaMC
Moderator

Can I import a spread sheet to the batch transactions, specifically bills.

Hello Sshadfar,

 

Thank you for reaching out to the Quickbooks Community! That's a great question. To import bills, we need to turn on the import bills. These are the steps to proceed:

 

  1. Select the Gear Icon, then click Quickbooks Labs.
  2. Click ON from Import Bills.
  3. On the bottom of the page, select Done.
  4. Go back to Gear icon, choose Import Data, then Import Bills.

With this, CSV files are used for uploading the bills. I recommend following this article because there are some limitations and capabilities when using this feature. 


By following that article, you should be able to map and import the bills. Please keep me updated and if you have any other question, simply reply. Have a good day!

vpcontroller
Level 11

Can I import a spread sheet to the batch transactions, specifically bills.

@sshafar 

@SashaMC 

 

"Can I import a spread sheet to the batch transactions, specifically bills."

 

Importing batch transactions for Vendor Bills from the Excel spreadsheet is not available in any QBO plans. Maybe with a purchase of 3-rd party app, you can do it but not within QBO yet.

 

In the Advanced QBO plan, you can enter batch transactions for Vendor Bills. But such entering batch transactions feature is currently not available other plans (Plus, Essentials & Simple Start).

 

batch-transactions1.PNGbatchtransactions2.png

 

Fiat Lux - ASIA
Level 15

Can I import a spread sheet to the batch transactions, specifically bills.

@sshafar 

Utilize this 3rd party importer tool

https://transactionpro.grsm.io/qbo

 

Need to get in touch?

Contact us