Days an invoice stays open, by kind of jobOpen at the end of last quarterShow as a table
Days an invoice stays open, by kind of job, open at the end of last quarter
Kind of job
Days open, on average
Insurance claim
57
Commercial
43
Residential
11
What this means
From your open invoices at the end of the quarter: each one, matched to its job through the job number on your invoices, by the kind of job.
Ask a follow-up
Options to consider
Follow up with Kestling Property Management on what is past due
$21,400 of the $58,640 past due is theirs.
Whoever handles billing
Suggested by Oct 15
Add to my plan
Agree payment terms for Insurance claim jobs when you sell them
They stay open longest after install: 57 days on average.
You
Suggested by Oct 31
Add to my plan
Send the final invoice the day the install is done
Invoices still open at the end of last quarter came to $109,450.
Whoever handles billing
Suggested by Oct 15
Add to my plan
How we know this
Last quarter, Jul 1 to Sep 30, 2026
The math
From your aging report as it stood at the end of the quarter: every open invoice with a balance still owed, matched to its job through the job number on your invoice lines, and grouped by the kind of job your jobs file shows. An invoice with no job number is kept and shown on its own. Past due uses the days past due the report gives, or its due date when that is blank. Days open are counted from the invoice date to the end of the quarter. Credits and payments not applied yet are left out, never subtracted. We name a customer when they clearly have the most of what is past due: at least half of it, or at least twice the next customer. The database did every calculation.
The records
44 records from your files are behind this answer.
A sale you install: the flooring or window treatments, the material order and the install.
Install
Putting in a sold job, counted on its first install day.
Last quarter
The most recent full calendar quarter before today. On the demo date of Oct 1, 2026 that is Jul 1 to Sep 30, 2026.
Balances due after install
Open invoices on your A/R aging report at the end of the quarter, by the kind of job they are for (residential, commercial or an insurance claim), matched through the job number on your invoices.