Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
June 3, 2024
Question

How to upload a purchase invoice of 50 products on quickbooks through a sheet?

  • June 3, 2024
  • 2 replies
  • 6 views
No text available

2 replies

SIAB
Level 2
June 3, 2024

Do you need to import Purchase Order or Bill?

JaeAnnC
Level 6
June 3, 2024

I'll be happy to assist you with uploading a purchase invoice with 50 products in QuickBooks Online (QBO), globalvisio.

 

If you're referring to customer invoices, you'll need to import the new products and services into QBO first before uploading the invoice.

 

Once done, prepare your spreadsheet with the following columns:

 

  • Invoice number
  • Customer
  • Invoice date
  • Due date
  • Item amount

 

Since your invoice has 50 products, ensure each line entry has the necessary columns.

 

Then, upload your spreadsheet. To do that:

 

  1. Go to the Gear icon and select Import Data.
  2. Click Invoices.
  3. Tick the checkbox to add the new customer if they don't exist yet in QBO.
  4. Select Browse and upload the spreadsheet.
  5. Click Next.

 

Proceed to map your import fields afterward. For a detailed discussion, please see this article: Import multiple invoices at once in QuickBooks Online.

 

If you're referring to importing purchase orders, this option is currently unavailable in QBO. However, if you're implying bills, follow the steps in this link if you have QBO Advanced: Create multiple bills or expenses in QuickBooks Online Advanced.

 

Moreover, you'll want to review or make quick changes to your transactions directly in the account register to ensure your financial records are accurate.

 

Please keep us informed if you have other queries about importing purchase invoices in QBO. We'll stay in touch to continue assisting you. Have a wonderful day ahead.