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

How do I upload existing invoices to QBs that I didn't create via the platform?

 
1 REPLY 1
Nicole_N
QuickBooks Team

How do I upload existing invoices to QBs that I didn't create via the platform?

We need to gather all existing invoices in a CSV file format and that the data is sorted to meet the necessary requirements, Gracey.

 

You can download a sample file provided by QuickBooks or use an existing spreadsheet. Just make sure it fulfill the following standards:

 

  • Each line item needs its own invoice number, customer, invoice date, due date, item amount, and item tax code.
  • Each imported spreadsheet can contain up to 1,000 rows.
  • You can import a maximum of 100 invoices at a time.
  • You can't add negative charges, such as discounts or credit notes.

 

Once everything's verified,  upload your file by following the steps below:

 

  1. From the Cog Wheel, click Import data.
  2. Select  Invoices.
  3. From there, you can choose to Download a sample file or click Browse and then find and select the spreadsheet for your invoices.


     
  4. Hit Next.
  5. Follow the instructions to complete the process.


You can refer to this article for a comprehensive information: Import invoices in QuickBooks Online
 

After you imported your invoices, learn how they looked like in QuickBooks through these articles: 

 

 

Let us know if you need more help with importing invoice transactions. We'll be here to help.

Need to get in touch?

Contact us