Quick answer
The Prequalification Activity Report is a report in Billy that lists every vendor prequalification form your subcontractors have submitted, in one table view. It shows vendor name, trade, who submitted the form, the submitted date, Days Waiting, reviewer and review date, vendor created date, prequalification status, requirement group, Procore sync status, company level compliance status, prequalification notes, and a link that opens the vendor record. Every column sorts, the report exports to Excel, and Days Waiting keeps counting until the form is reviewed.
Why this report exists
Prequalification only protects you if someone actually reviews the submissions. Forms arrive from the field, from estimating, and straight off your website, and they can sit for weeks before anyone notices. Checking vendor records one at a time does not scale once you have hundreds of subcontractors in your construction compliance platform.
The Prequalification Activity Report replaces that manual hunt with one screen. Open it, sort by Days Waiting, and you immediately know which subcontractors are stuck in the queue and who owns the next step. It pairs with the Vendor Prequalification Tool and the workflow in Reviewing Vendor Prequalification Submissions in Billy.
Where to find the Prequalification Activity Report
Log in to Billy.
Open Reports from the main navigation.
Select Prequalification Activity Report.
The table loads with every submitted prequalification form for your account.
If you do not see the report, your user role may not include reporting access. Ask an administrator on your account, or read Compliance Reports in Billy: A Complete Guide to All 13 Dashboard Reports.
Every column in the report, explained
Each row is one submitted prequalification form.
Vendor Name: the subcontractor or supplier that submitted the form.
Trade: the scope of work the vendor selected, so you can group submissions by trade.
Submitted By: the person at the vendor who completed and sent the form.
Submitted Date: the date the form arrived in Billy, and the start point for Days Waiting.
Days Waiting: how many days the submission has been waiting for review. Counting stops on the review date and keeps going while the form is unreviewed.
Reviewed By: the teammate who completed the review.
Review Date: the date the review decision was recorded.
Vendor Created Date: when the vendor record was first created in Billy, useful for telling new vendors apart from vendors you are requalifying.
Prequalification Status: where the vendor stands in your prequalification process.
Requirement Group: the set of insurance and document requirements applied to the vendor. See Selecting a Requirement Group During Prequalification Vendor Review.
Synced to Procore: Yes or No, confirming whether the vendor reached your Procore account.
Company Level Compliance Status: the vendor overall compliance standing across your company. See Understanding Vendor Compliance Statuses in Billy.
Prequalification Notes: notes recorded during review, visible right in the table.
Action: a link that opens the vendor record so you can review, approve, or follow up immediately.
How Days Waiting works
Days Waiting is the number that turns a list into a queue. It starts on the submitted date and stops on the review date. While a form is still unreviewed, the number increases automatically every day, so the report always reflects the true age of the submission without anyone updating a spreadsheet.
Example: Apex Electrical submitted on the third of the month and no one has reviewed it, so the count keeps climbing. Harbor Concrete submitted and was reviewed two days later, so the count is frozen at two.
Many teams set an internal service level, for example every prequalification form gets a decision within five business days. Days Waiting makes that promise measurable.
Sorting the report
Every column is sortable. Click a column header to sort by that field, and click again to reverse the order.
Days Waiting: find the backlog and clear the oldest submissions first.
Trade: review all vendors in one scope together so your requirement decisions stay consistent.
Prequalification Status: separate what is still open from what is already decided.
Synced to Procore: confirm that approved vendors actually landed in Procore.
Submitted Date: report on prequalification volume for a month, a quarter, or a bid cycle.
Exporting the report to Excel
Use the export option to download the full report as an Excel file. The export is useful for weekly risk meetings, owner reporting, and audit files. Because it carries every column, including Days Waiting and reviewer names, it doubles as a record of how quickly your team responds to subcontractors.
Want the numbers to arrive without logging in? See Daily Report Email Subscriptions in Billy and Exporting Compliance Data from Billy: A Complete Guide.
Opening a vendor record from the Action column
The Action column links straight to the vendor record. From there you can read the full submission, choose a requirement group, approve or decline the vendor, and start collecting documents. When a vendor is approved, Billy can create the vendor in your project management system automatically, as described in Creating a Vendor in Procore When a Prequalification Form is Approved.
How teams use this report
Monday morning queue review. Sort by Days Waiting, work top down, and assign anything older than your threshold.
Preconstruction bid coverage. Sort by Trade to confirm you have enough prequalified subcontractors in each scope before bids go out. If a trade looks thin, send the form to more vendors using Sharing and Embedding Your Prequalification Form on Your Website.
Procore reconciliation. Look at rows where Synced to Procore says No and confirm nothing stalled between systems.
Audit and owner reporting. Export to Excel for a dated record of who submitted, who reviewed, and how long each decision took. Pair it with Company Level Compliance Tracking.
Keeping the report clean
Turn on notifications so submissions never sit unseen. See Setting Up Email Notifications for Prequalification Submissions.
Set an expiration interval so vendors requalify on schedule. See Automatically Requalify Vendors with Expiring Prequalification Forms.
Review your form questions once a year so the Trade and status values stay meaningful. See Prequalification Form Questions.
Let vendors know their form arrived with the Vendor Prequalification Submission Confirmation Email.
Frequently asked questions
What is the Prequalification Activity Report in Billy?
It is a single table view of every submitted vendor prequalification form in your Billy account, with columns for vendor, trade, submitter, dates, Days Waiting, reviewer, status, requirement group, Procore sync, company level compliance status, notes, and a link to the vendor record.
How is Days Waiting calculated?
It counts days from the submitted date until the review date. If the form has not been reviewed, the count continues to grow each day.
Does Days Waiting update on its own?
Yes. Open the report and the number is current.
Can I sort by any column?
Yes. Click any column header to sort the report by that field.
Can I export the report?
Yes. The full report exports to Excel, including every column shown on screen.
Does the report include reviewed submissions too?
Yes. Every submitted prequalification form appears, whether it is waiting for review or already decided.
Where does the Action link take me?
To that vendor record in Billy, so you can review the submission and take the next step without searching.
Does this work with Autodesk, Sage, Viewpoint Vista, and other systems?
Billy connects to a range of construction systems. Browse the full list on the Billy integrations page.
Related articles
See it in your own account
Billy is the construction compliance platform general contractors use to prequalify subcontractors, collect certificates of insurance, and keep vendor records in sync with Procore. Walk through the report with our team: request a demo.
Still have questions about vendor prequalification in Billy? Start a chat with our support team or explore the subcontractor prequalification tool.
