Plumbing Open Jobs Tracker: Show the Blocker and Next Step

Define what an open job means

Choose an operational definition, such as work that has been accepted but has not completed its agreed scope and closeout responsibilities. Keep that definition separate from accounting status.

A finished job may have an unpaid invoice. An open job may already have a deposit. Neither fact alone determines whether the work itself is complete.

Document your definition at the top of the tracker so staff do not use it as an inconsistent mix of estimates, appointments, invoices, and payment reminders.

Use fields that explain the next action

job_id,customer_ref,service_property,work_stage,blocker,next_action,action_owner,next_review_date,next_visit,scope_remaining
J-240,C-18,Property A,Waiting on material,Confirmed part not arrived,Check supplier arrival update,Office,2026-10-02,,Install remaining approved item
J-241,C-22,Property B,Ready to schedule,Access window needed,Confirm access with manager,Office,2026-10-01,,Approved return visit
J-242,C-30,Property C,Closeout review,Completion note incomplete,Clarify remaining work,Supervisor,2026-09-30,,Review scope completion

These rows are fictional. Replace them with your own identifiers and dates; do not import them into live customer records.

The next review date tells the office when to revisit a blocker. It is not a promised customer appointment.

Use a small number of defined work stages

Useful stages might include ready to schedule, scheduled, in progress, waiting on a prerequisite, return visit required, and closeout review. Decide what evidence moves a job between stages.

Keep the blocker in a separate field. “Waiting on material” is different from “waiting on customer approval,” even though both may be temporarily unscheduled.

Avoid creating a unique status for every possible problem. A short stage list plus a specific blocker is easier to maintain than dozens of overlapping categories.

Review age with context

A job open for several weeks may be proceeding normally through an agreed sequence. A newly opened job may already be urgent because a promised next step was missed.

Track both age and the next-action commitment. Do not rank every open job only by creation date; review customer promises, operational consequences, and prerequisite dependencies as well.

If you calculate days open, state which start date you use. Request date, approval date, and first-visit date answer different questions.

Close jobs with evidence

Before removing a job from the open queue, confirm that remaining scope and closeout tasks are addressed or explicitly transferred to a linked follow-up record. Preserve the history rather than deleting the row.

Record the closeout date and any separate billing action. This keeps the tracker from hiding unfinished responsibilities merely to make the open count smaller.

Use software without assuming a native custom report

GoPlumber's job and scheduling records can support an open-work review. Test how its current statuses and views map to your chosen definitions.

This tracker is a process design, not a promise that GoPlumber includes this exact report or every listed custom field. Keep a controlled supporting view where needed, and avoid creating competing versions that staff update inconsistently.