Creating and Importing Contractor Excel Invoice to QB

You may utilize the IIF feature to import Invoices data.

https://quickbooks.intuit.com/learn-support/en-us/manage-lists/iif-overview-import-kit-sample-files-...

If you are not familiar with it, you have other options to utilize an importer tool

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

I am in the same situation...were you able to make this work for you?

We can import invoices to QuickBooks Desktop using an Intuit Interchange Format (.IIF) file, ahill17.

Before proceeding, QuickBooks uses ASCII text, TSV (Tab-Separated Value) files to import or export lists/transactions. Please refer to this article to ensure that you're using the correct one: IIF Overview: Import Kit, Sample Files, and Headers.

Once verified, you can follow these steps to import your transactions. 
 

1. Sign in to your company file as the Admin.
2. Click the File menu at the top and select Switch to Single-user Mode.
3. Click the File menu again and select Utilities.
4. Select Import and choose IIF Files.
5. Look for the .IIF file and click Open.
6. Click OK.

For more details, please see this article: Export, Import, and Edit IIF Files.

Aside from using IIF, you can also look for a file converter online. Then, follow the steps to import the data again.

Additionally, I've included these articles that'll help you learn more about importing IIF files in QuickBooks Desktop:

• Tasks you can do with IIF Files
• Improved IIF Import in QuickBooks 2019 and Later

Feel free to comment down below if you have any other concerns or questions about importing transactions. I'm always glad to help in any way I can.

@ahill17 

Prepare your Bills data with the following template

then utilize one of the importer tools as I mentioned earlier.

Another option, consider having a billing management app to integrate with your QBD. You will find multiple ways to quickly import your bills, with little to no manual entry required.

https://billcom.grsm.io/qbd

https://plooto.grsm.io/quickbooks