Before
After
Audit Trail
Forensic record of every change to your protected financial tables — contracts, hours ledger, invoices, bank balances, carryover events, recurring templates. Use this when you need to answer "who touched what, when, and why" in 10 seconds instead of pasting SQL.
Quick investigations
Pre-built forensic queries. Press any to load its results below. Counts honor your filters above.
Pick an investigation above to see results. Start with Everything (filtered) for an overview.
No matches.
Try widening the date range, clearing the client filter, or picking a different investigation.
That query did not load.
| Day | Table | Inserts | Updates | Deletes | Total |
|---|
No writes in the last 14 days.
That query did not load.
All clear
No unresolved integrity findings. Last nightly check ran successfully.
That query did not load.
All clearNo unresolved integrity findings. Last nightly check ran successfully.1 unresolved finding — {crit} critical{n} unresolved findings — {crit} criticalThe nightly integrity check found drift in your data. Review immediately.1 unresolved finding{n} unresolved findingsThe nightly integrity check surfaced something worth a look.View findingsClientAll clientsDate rangeLast 24 hoursLast 7 daysLast 30 daysLast 90 daysLast yearAll timeTableAll tablesClear filtersEverything (filtered)All audit rows matching your filters.Override usedEvery row where pmintegrity.override was active. Should be near-empty.All deletesEvery row deletion. Most should be draft contracts or unpaid invoices (allowed by Layer 1).Recurring template bumpsEvery change to client_recurring_invoices (the renewal billing template). The Fern case.hours_ledger changesEvery hour debit, credit, or correction.Bank balance changesEvery change to client_bank_balance and contract_carryover_events.Contract changesDrafts, activations, expirations, cancellations.Invoice changesInvoice creation, status flips, line edits.Daily volumeWrites per day per table for the last 14 days. Anomaly detection — sudden spikes are worth a look.14d?ResultsPick an investigation above to load.Pick an investigation above to see results.Start with **Everything (filtered)** for an overview.1 row{n} rows{n} rows (capped — tighten filters)No matches.Try widening the date range, clearing the client filter, or picking a different investigation.That query did not load.(no summary)by {who}system / cronOverrideShow diffHide diffBeforeAfter(none — insert)(none — delete)Integrity findingsUnresolved alerts from the nightly check. Investigate each one, then mark resolved when fixed.1 finding{n} findings1 day-table bucket{n} day-table bucketsNo writes in the last 14 days.DayTableInsertsUpdatesDeletesTotalInsertUpdateDelete