cancel
Showing results for 
Search instead for 
Did you mean: 
romeenbasiri
New Member

How to import supplier invoice with different product line and prices under 1 bill

 
1 Comment 1
Maybelle_S
QuickBooks Team

How to import supplier invoice with different product line and prices under 1 bill

I'm here to help import your bill transactions, romeenbasiri.

 

QuickBooks Online (QBO) allows us to import bills with multiple line items and prices efficiently. This functionality can significantly streamline your bill management process.

 

Here are the key columns included in the data file for import:

 

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

 

You can map these columns to the corresponding fields when importing the data in QBO. It ensures that your file is accurately imported and categorised according to your needs.

 

Here's how:

 

  1. Go to the Gear icon and select Import data.
  2. Tap Bills.
  3. Review what's required to import bills. There is also an example of a data file available.
  4. Once you have all the mandatory fields, select Browse, then choose your .csv file.
  5. Hit Open.
  6. Ensure to populate the Line Account field even if you only import bill totals.
  7. If you would like to auto-create suppliers, tick the box beside Add new suppliers that don't already exist in QuickBooks.
  8. Pick Next.

 

Additionally, if your file has a new supplier and accounts, import or add them first in the system. For more details, check this link: Import your bills.

 

Furthermore, visit this link to learn more about handling bill and bill payments in QuickBooks: Enter and manage bills and bill payments.

 

I'm happy to help again if you have more questions about importing bills into QuickBooks. I'm with you every step of the way.