How to Create a Work in Progress Report with ChatGPT

Creating a work in progress (WIP) report can feel like a chore that pulls you away from the actual work you're supposed to be reporting on. Instead of spending an hour formatting updates and summarizing progress, you can use ChatGPT to instantly draft a clear and professional report. This article will show you exactly how to prepare your data, write effective prompts, and turn pages of notes into a concise WIP report in minutes.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly is a Work in Progress (WIP) Report?

A WIP report is a document that provides a high-level overview of the current status of a project. Its goal is to keep stakeholders, team members, and management informed about what's been done, what's happening now, and what's coming next. It flags potential roadblocks and ensures everyone is aligned.

While the format can vary, a solid WIP report almost always includes these key elements:

• Project / Task Name: What are you working on?
• Assignee: Who is responsible?
• Status: Is it Not Started, In Progress, Blocked, or Complete?
• Percentage Complete: A rough estimate of how much work is done.
• Due Date: When is it expected to be finished?
• Blockers / Issues: What's getting in the way?
• Next Steps: What is the immediate plan of action?

Manually gathering this from different people and compiling it into a readable format is exactly where the time gets lost. And it's exactly what AI is great at automating.

Step 1: Get Your Data Ready for ChatGPT

ChatGPT can't analyze what it can't see. The first and most critical step is to gather all your raw project information into one place. LLMs work best with structured data, so the clearer you can make your input, the better your output will be. You don't need a perfectly formatted database, but you should aim for something better than a random collection of sticky notes.

The goal is to provide context. The AI doesn't know about your projects, so you have to feed it the details. You can do this by organizing your updates in a simple list or, even better, a markdown table.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Example: Formatting Project Updates

Let's say you're managing a "Q3 Website Relaunch" project. Your raw notes from a team meeting might look like this:

"Okay, so Sarah is finishing the new homepage design, she said she's about 75% done and needs it for Friday. Mike is blocked on the API integration because we're waiting for credentials from the third-party service. He can't move forward. The blog content is almost all done, maybe 90%, David's leading that. And I still need to start the user-testing scope document, that one's due next Wednesday."

This is too messy for a good report. To get a useful summary from ChatGPT, structure that information first. Copying and pasting data from a project management tool or a quick spreadsheet works perfectly. Here’s how you could clean it up:

Project: Q3 Website Relaunch

Tasks:

• Task: New Homepage Mockups, Assignee: Sarah, Status: In Progress, Completion: 75%, Due: Fri, Oct 27, Blocker: None
• Task: API Integration, Assignee: Mike, Status: Blocked, Completion: 10%, Due: Mon, Oct 30, Blocker: Waiting for API credentials from vendor
• Task: Transfer Blog Content, Assignee: David, Status: In Progress, Completion: 90%, Due: Wed, Nov 1, Blocker: None
• Task: Finalize User Testing Scope, Assignee: Alex (Me), Status: Not Started, Completion: 0%, Due: Wed, Nov 1, Blocker: None

This organized format makes it easy for ChatGPT to understand each task's details and relationships, leading to a much more accurate report.

Step 2: Crafting the Right ChatGPT Prompt

Your prompt is your instruction manual for the AI. A vague prompt will get you a vague answer. A specific, well-structured prompt will give you a well-structured report. Think of it less as a search query and more as a detailed request to an assistant.

A powerful prompt generally contains four elements:

1. Role: Tell ChatGPT who to be. For example, "Act as an experienced project manager."
2. Task: State exactly what you want it to do. For example, "Analyze the project data below and generate a Work in Progress report."
3. Context: Paste your formatted data here.
4. Format: Specify how you want the output structured. Tell it what sections to include, whether to use bullet points, and the tone it should adopt.

Example Prompt for a WIP Report

Using our formatted data from the last step, here’s a comprehensive prompt you could use:

Act as a senior project manager writing a weekly progress update for executive leadership. Your tone should be professional, clear, and concise.

Analyze the raw data provided below and create a formal Work in Progress (WIP) report.

**Report Structure:**
1.  **Overall Summary:** A brief, 2-3 sentence overview of the project's health.
2.  **Key Accomplishments:** A bulleted list of significant progress made. Frame tasks that are nearly complete as accomplishments.
3.  **Active Tasks:** A bulleted list of what's currently being worked on.
4.  **Blockers & Risks:** A single, clearly stated bullet point for any task that is blocked. Highlight the impact.
5.  **Next Steps:** A bulleted list of priorities for the upcoming week.

**Raw Data:**
Project: Q3 Website Relaunch

Tasks:
- Task: New Homepage Mockups, Assignee: Sarah, Status: In Progress, Completion: 75%, Due: Fri, Oct 27, Blocker: None
- Task: API Integration, Assignee: Mike, Status: Blocked, Completion: 10%, Due: Mon, Oct 30, Blocker: Waiting for API credentials from vendor
- Task: Transfer Blog Content, Assignee: David, Status: In Progress, Completion: 90%, Due: Wed, Nov 1, Blocker: None
- Task: Finalize User Testing Scope, Assignee: Alex, Status: Not Started, Completion: 0%, Due: Wed, Nov 1, Blocker: None

By defining the persona, task, structure, and providing clean data, you guide the AI to generate a report that is not only accurate but also in a format that's ready to share.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 3: Review and Refine the Output

ChatGPT is an incredible assistant, but it's not the project manager - you are. Always review the generated report for accuracy, context, and tone. The AI might summarize something in a way that is technically correct but misses a subtle nuance that only a human would catch.

After your initial prompt produces a report, you can easily ask for revisions. This is where the conversational nature of ChatGPT truly shines.

Example Refining Prompts:

Maybe the first draft is a bit too formal or verbose. You can easily correct it:

• "Can you make the summary more optimistic?"
• "Rephrase the 'Blockers' section to be more solution-oriented. Mention that we are actively following up with the vendor daily."
• "Expand on the 'New Homepage Mockups' accomplishment. Add a sentence about how this unblocks the development team."
• "Condense this whole report into a single paragraph for a quick Slack update."

Don't be afraid to have a back-and-forth conversation until the report is perfect. Each refinement helps the final output better match your specific needs and communication style.

Advanced Techniques for More Complex Reports

Once you've mastered the basics, you can use ChatGPT for more complex reporting tasks.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Creating Reports From Unstructured Data

What if your data isn't in a neat list? Sometimes, all you have is a long email thread or a messy Slack channel conversation. You can paste that unstructured text into ChatGPT and ask it to pull out the key information.

Example Prompt:

Act as a project manager. Read the following email thread transcript and extract all tasks, statuses, blockers, and deadlines. Then organize that information into an easy-to-read WIP report summary.

[Paste your raw email thread or Slack conversation here...]

While the output will be less reliable than with structured data, it's an incredibly fast way to get a "first draft" of project status and identify action items you might have missed.

Identifying Trends Over Time

If you save your weekly data inputs, you can ask ChatGPT to analyze them for patterns. This moves beyond simple summarization and into true analysis.

Example Prompt:

I've provided the past four weekly project updates below. Please analyze them and identify any recurring blockers or tasks that have consistently been delayed.

[Paste data from Week 1]
[Paste data from Week 2]
[Paste data from Week 3]
[Paste data from Week 4]

This allows you to spot systemic issues, like a particular team member being consistently overloaded or a recurring dependency causing delays - insights that are tough to see when you're caught in the weekly reporting cycle.

Final Thoughts

Using ChatGPT to draft your WIP reports helps you standardize your reporting process and reclaim hours of manual work. By preparing clean data, using specific prompts, and refining the output, you can transform scattered updates into clear, actionable documents that keep everyone on your team in sync.

While this manual copy-and-paste method is a huge step up from spreadsheets, we know that getting true visibility requires connecting directly to your live data sources. At Graphed, we automate this entire process by integrating with your tools like Google Analytics, Shopify, Salesforce, and HubSpot. Instead of compiling data for a report, you can just ask questions in plain English - like "create a dashboard showing campaign performance vs sales for the last 30 days" - and get a live, interactive dashboard instantly. It gives you real-time answers without ever touching a CSV file again.