You did well in describing all the methods you used, @glConley.
The amount of your bill will show 0 or following the rate of the first item when using the quantity and amount column. This is because QuickBooks is yet to identify the correct rate to use base on the number of line items.
To learn more about the columns you can use when importing bills, here's an article you can read for reference: Import your bills in QuickBooks Online.
With this, you can consider following the other method you described using the rate and bill number. Or manually creating the bills. To do so:
- Go to the +New button.
- Under VENDOR, select Bill.
- Select a vendor, terms, and correct dates.
- Choose a category detail.
- Enter the amount accordingly.
- Click Save and close.
In addition, here's an article you can read to learn more about the steps: Enter and pay bills.
Lastly, you can also visit and read through the steps to create a CSV file of the other list that you can import: Import customer or supplier contacts from Outlook, Excel, or Gmail.
You can always leave a comment below if you have any other questions. Stay safe!
