cancel
Showing results for 
Search instead for 
Did you mean: 
osama-mdc
Level 1

Hi, I want to import a bill with many items inside, how can I do that?

 
1 Comment 1
Archie_B
QuickBooks Team

Hi, I want to import a bill with many items inside, how can I do that?

Welcome to the Community, osama-mdc.

 

Let me guide you in importing a bill in QuickBooks Online.

 

You can prepare and use a CSV file to import your data accurately. You can use this sample.pdf to guide you with the following mandatory fields:

 

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

 

There is also an example of a data file available for you to download when you try to import your data.

 

Once you're file is ready, you can follow these steps below to import your bill.

 

Like this:

 

  1. Go to Settings ⚙️, then select Import data.
  2. Choose Bills.
  3. Click on Browse.
  4. Select your .csv file, then Open. If you would like to auto-create suppliers, just tick the checkbox beside Add new suppliers that don't already exist in QuickBooks.
  5. Click on Next. and select the data format you've used.
  6. Map all mandatory fields and hit Next.
  7. Tap Start Import to begin the process.
  8. Once completed, an import summary will be displayed. Note any bills that didn't import and why, then select Done and you'll see a final completion summary.
  9. Select OK to finish.

 

For more details, check out this link: Import your bills in QuickBooks Online.

 

I've also added this article for common questions about importing data to QuickBooks Online.

 

I'll be here if you still need further assistance about bills. Take care and have a wonderful day!