import bulk bills(items)

I'm here to help you import the bills, sy_jung-spigen-c.

You can go to the Gear > Import data > Bills and click the Download an example link to help you prepare your CSV (or Excel) file accurately. Please make sure to save the file where you can easily find it. 

Here are the following columns that are required:

• Bill no.
• Supplier
• Bill Date
• Due Date
• Account
• Line Amount
• Line Tax Code

Once done, go back to the Bills page and follow these steps:

1. Under Upload your CSV file, click the Browse button and select your .csv file.
2. Click Open, then hit Next. Note: You are required to populate the Line Account field even if you are only importing bill totals. Note: If your CSV file contains new suppliers and accounts, you must import or add new suppliers, accounts, and customers before uploading the file.
3. Map your column headings.
4. Follow the on-screen instructions until finish.

Please see this sample screenshot for a visual guide:

For more information about the capabilities and limitations, you can read this article: Import your bills in QuickBooks Online.

Should you have any follow-up questions or other concerns, please let me know in the comments below. My colleagues and I are always here to help. Take care!

I want to know import multiple bills of items...(Not category)

Thanks for your reply, sy_jung-spigen-c.

To verify, are you trying to import your products and services? If so, you can follow these steps:

1. Go to the Gear > Import data.
2. Select the Products and Services tile.
3. Click the Download an example to prepare your CSV (or Excel) file.
4. Follow the on-screen instructions to map the columns.

Please see this sample screenshot for a visual guide: 

You can also check out this article for the details instructions: Import products and services into QuickBooks Online.

Please don't hesitate to add another reply below if you still need more help with QuickBooks Online. I'm always here to help. 

Hi, now the person wasn't wanting to import the Products and Services they were wanting to import Bills WITH Items. Please can you tell us how to do this. All the instructions only describe importing bills for Categories. 

Many thanks.

Simon

@Migrating to On-Line Problem 

Like this one?

I appreciate you participating in this conversation. Let me address your concern about importing bills with items.

In QuickBooks Online (QBO), limitations may apply when importing bills. Currently, we're unable to include the item details section. For this reason, it's not possible to bring them in, which would automatically increase inventory.

In the meantime, I suggest searching for a third-party tool to assist you in uploading them to QBO. To do that:

1. Go to Apps and select Find Apps.
2. Search for a keyword in the search bar and press Enter.
3. Select an app and click Get app now to integrate.
   

While the program is unable to carry out this task, we suggest sharing your valuable input with our software engineers. This way, they can review your suggestion and possibly take it into account for our upcoming product improvements. To do that, go to the Gear icon and select Feedback.

Additionally, gaining an overview of your sales and expenses is a breeze if you generate reports in QBO. Doing so provides details about outstanding bills and their due dates, as well as all the transactions associated with each vendor.

Feel free to reach out back to us whenever you need additional help with importing bills with items. I'm more than willing to assist you further. Stay safe.