How do you get a report to show when the insurance expires if is in a notes field. I do not want to continue to look at each vendor file to see when it expires.
In QuickBooks Online (QBO), you can customize and personalize your reports. To run a vendor report that includes the details added in the notes field, you can use the Vendor Contact List report.
Let me guide you on how to do it. You can follow these steps:
Go to the Reports.
From the Find report by name field, enter Vendor Contact List.
I recognize the importance of tracking insurance expiration dates for vendors. Yes, that's correct. It's possible in the QuickBooks Desktop version. However, it's currently unavailable in QuickBooks Online (QBO).
In the meantime, you can manually track the expiration date by adding it to the Note section of the vendor's profile. You can refer to the steps for guidance.
I also encourage you to share your thoughts and suggestions through our feedback channel so they can consider adding this feature in future software updates.
You state there is a way to track the insurance expirations in QuickBooks Desktop. I am running QuickBooks Enterprise Gold 2025 Contractor's edition and it will allow you to pay a subcontractor with an expired insurance certificate. How do you set up a reminder/governor that disallows payment because of the expired certificate?
We appreciate your inquiry, Holly64. Currently, there isn't a built-in feature that automatically prevents payments to subcontractors with expired insurance certificates.
However, you can set up a manual system to track and remind you of insurance expirations within QuickBooks Desktop (QBDT) Enterprise Gold 2025 Contractor's edition. This process can help you stay on top of insurance expirations and make informed decisions about payments to subcontractors.
Here's how:
Select the Vendors menu and click the Vendor center option.
From there, double-click the name of the vendor you need to edit.
Next, click the Additional info tab
Enter the appropriate dates on the Work Comp Expires and Gen Liability Expires options.
Select OK when done.
I've also added this screenshot for visual reference:
Alternatively, you can generate a Vendor Contact List report to view vendors with expired or soon-to-expire insurance. You can follow the steps below.
Go to the Reports menu at the top of the screen.
Select Vendors & Payables from the drop-down menu.
Choose Vendor Contact List.
Click on Customize Report at the top of the report window.
In the Display tab, tick the Work Comp Expires and Gen Liability Expires custom fields.
Hit OK.
Since the option to block payments to subcontractors whose insurance certificates have expired within the QBDT Enterprise contractor's edition is unavailable, we'd love to hear your thoughts on this option and encourage you to share your suggestions. It will be shared with our Product Development team, allowing us to enhance your experience with QBDT. Here's how:
Go to the Help option.
Choose the Send Feedback Online option.
Select the Product Suggestion option. A pop-up window displays.
Enter your feedback suggestion.
Click the Send Feedback button.
Finally, you can memorize reports to save your customized settings, so you don't have to go through the customization process again. Check out this article to learn more: Create, access, and modify memorized reports in QBDT.
We'd love to hear more from you about how this goes. Please comment below if you need further assistance tracking whose insurance certificates have expired within the QBDT Enterprise contractor's edition. Take care!
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.