Importing bills from Excel to link into outstanding Purchase orders

Let me share details about the importing bills in QuickBooks, @COSNZ.

At this time, the option to import bills in bulk is unavailable in the US version of QuickBooks Online (QBO). You may consider looking for a third-party application that can help import your bill transactions that can also read or link with purchase orders.

To find a third-party app, you can go to the Apps menu and search for a keyword (bill importer). You might also want to go directly to our Apps Store and look for an app from there.

For further questions about the third-party application, I recommend contacting their customer service team.

Also, you might want to review all your vendor transactions in the future. You can go to the Expenses menu and select Vendors. Then, go to the Transactions List tab.

I've additionally included a couple of detailed resources about creating bills that may come in handy moving forward:

• Create bills & record bill payments
• Learn the difference between bills, checks, and expenses in QuickBooks Online

Please leave a comment if you have any other questions or concerns. I'm always here to help. Take care and have a great day, @COSNZ.

@COSNZ 

You can prepare your Bills data with the following template

then utilize an importer tool

https://transactionpro.grsm.io/qbo

Unfortunately, you won't be able to link PO data to Bills. You can export your PO data out to XLS with the exporter tool, modify the "PO Status" data field from Open to Closed, and reimport back the modified file into your QBO account.

Consider to utilize the backup restore app as for your insurance.

https://rewindio.grsm.io/quickbooks