PSRP Invoice Tracker

Detroit Private Sewer — Phase II  · 

Filters

#AddressAP# Permit #Date of ServiceInvoice due DocsPart APart BWhose courtWhat's needed to close

Project totals

The whole project, always. No filter on this page changes these figures — for a filtered view use the Metrics tab.

Where we are

Addresses that started in the same Monday–Sunday week are one week of work. Each counts as 1 unless you change it — use a fraction for a short week.

Week ofAddressesCounts as

What's left

Quantities by address

Total across the addresses shown
$0.00

# AP # Address Permit # Invoice type Item qty Item value Part A Part B Total

Select any address to open and edit its line items.

Complaints

One outstanding complaint per address. Resolving a complaint keeps it as history; complaints are never deleted. A billing hold is a warning only — it does not stop any invoice from moving.

AddressAP#StatusReceived ResolvedAgeAssigned to / Whose court Billing holdComplaintCurrent action

Metrics filters

Filtered analysis — every tile and chart below reflects these filters. The Project totals on the Tracker tab are always whole-project.

Billings submitted by month

Click any month to break it down by week.

Movement — this week vs last week

Outstanding by whose court

Open invoices only, counted by who currently owns the next action.

Past due — still ours

Days past the invoice due date. Excludes anything with DWSD, HRD or Oracle.

Settings

Configuration and shared documents. Day-to-day work happens on the other tabs; nothing here changes an invoice, a quantity or a checklist.

Access management

Who can sign in, pending requests and account history. Approving someone gives them every normal PSRP operation, including deleting addresses.

Photo Doc Builder

Where PSRP sends you when you press Open Photo Doc Builder. The Builder reads addresses from this same database through one authenticated lookup.

Current destination

Document templates

The shared files PSRP and the Photo Doc Builder build documents from. Replacing one changes it for everyone, so it is kept in the database rather than on anybody’s machine and only the project owner can replace it.

Download gives you the file documents are being built from right now. Edit it in Excel or Word — PSRP cannot edit an Office file — then Upload replacement, which checks it and stages it without changing anything. The stored file is then downloaded back and matched against the copy that was checked — a version that fails that cannot be published. Publish is the step that changes what everybody generates, and any earlier version can be published again.

Template What it is used for In use Published By Validation

Friday report preview — this week vs last week

Friday report preview — this is the content currently prepared for the weekly 8 AM report, built from the same figures as the rest of the tracker. Previewing sends nothing.

Opens the finished report, ready to download as PDF or print.

The week's baseline is captured on its own — nothing to click.

PSRP Invoice Tracker
Detroit Private Sewer — Phase II

Not saved to the shared database

The change below was put back to the value PSRP still holds, so what you see is what is stored. Nothing else was affected.

Delete Address?

You are about to permanently delete:

—
Applicant #: —

This action cannot be undone.