Metric migration / FIN-01
FIN-01 Vendor invoices paid within 30 days of receipt
Owner: Finance. Unit: %. Reconciliation tolerance: 0.1. Target: 90.0 (higher is better).
Written definition
- Source
- Tyler Munis accounts payable
- Calculation
- Invoices paid in the month within 30 days of receipt, divided by all invoices paid in the month, times 100.
- Inclusions
- All funds and departments.
- Exclusions
- Open invoices; voided invoices.
- Time frame
- Calendar month of payment.
- Definition status
- Accepted Office of Data and Innovation, 11/05/2026
As held in the legacy performance database (PerfDB)
- Name
- Vendor invoices paid within 30 days of receipt
- Note
- Invoices paid in the month within 30 days of receipt
- Script
perf_fin_01.sql
CDR value against PerfDB
Calculation as run by the CDR
select date_trunc('month', paid_date)::date as month, 100.0 * avg(case when paid_date - received_date <= interval '30 days' then 1 else 0 end) as value from curated.fact_ap_invoice where paid_date is not null group by 1
Reproduce now from the curated layer Runs the SQL above against the current curated tables, read only.
Monthly reconciliation, latest run
| Month | PerfDB | CDR | Difference | Result |
|---|---|---|---|---|
| Oct 2025 | 100.0 | 100.000 | 0.000 | Within tolerance |
| Nov 2025 | 87.3 | 87.302 | 0.002 | Within tolerance |
| Dec 2025 | 80.4 | 80.407 | 0.007 | Within tolerance |
| Jan 2026 | 81.7 | 81.749 | 0.049 | Within tolerance |
| Feb 2026 | 82.4 | 82.446 | 0.046 | Within tolerance |
| Mar 2026 | 81.7 | 81.675 | -0.025 | Within tolerance |
| Apr 2026 | 84.9 | 84.941 | 0.041 | Within tolerance |
| May 2026 | 82.7 | 82.684 | -0.016 | Within tolerance |
| Jun 2026 | 82.3 | 82.273 | -0.027 | Within tolerance |
| Jul 2026 | 84.0 | 83.973 | -0.027 | Within tolerance |
| Aug 2026 | 84.1 | 84.105 | 0.005 | Within tolerance |
| Sep 2026 | 83.2 | 83.167 | -0.033 | Within tolerance |
| Oct 2026 | 83.3 | 83.304 | 0.004 | Within tolerance |
Reconciliation history
| Run | Result | Months |
|---|---|---|
| L-20261101-0100 | Within tolerance | 13 |
| R-20261102-0200 | Within tolerance | 13 |
| R-20261103-0200 | Within tolerance | 13 |
| R-20261104-0200 | Within tolerance | 13 |
| R-20261105-0200 | Within tolerance | 13 |
| R-20261106-0200 | Within tolerance | 13 |
| R-20261107-0200 | Within tolerance | 13 |
| R-20261108-0200 | Within tolerance | 13 |
| R-20261109-0200 | Within tolerance | 13 |
| R-20261110-0200 | Within tolerance | 13 |
| R-20261111-0200 | Within tolerance | 13 |
Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.