Claim Guardians
ClaimsCalQL8ter
Office Escrow Comparison
This is the office-wide escrow form for every claim currently in the program. Enter the bank balance on this page to compare the app’s escrow total against your actual bank escrow account.
Office Escrow Rollup
This is the office-wide view of how much money is sitting in escrow across all claims in ClaimsCalQL8ter. Use the bank balance on the right to compare the program total against your actual escrow account.
App Escrow Total
$14,488.22
This is the number that should generally match the escrow account at the bank.
Claims Advanced Elsewhere
$8,583.37
Claim money that was prepaid from another account and still needs to be replenished.
Net Claim Escrow Position
$5,904.85
Office escrow total after subtracting prepaid advances from other accounts.
Active Claims
15 of 15
Claims still open or partially paid that may still move money.
Bank Comparison
Enter the daily balance from your bank statement so you can track how far the app is from your real escrow account while you work through claims.
Use the actual escrow balance from the bank.
Use the bank date you want the office to compare against.
Optional note for unusual deposits, timing differences, or cleanup work still in progress.
Bank Balance
$0.00
Enter a bank balance above to compare it.
App Escrow
$14,488.22
Live total currently sitting in office escrow across all claims.
Reconciliation Difference
-$14,488.22
Bank balance minus app escrow total. This should trend toward zero.
Saved Daily Totals
| Statement Date | Bank Balance | App Escrow | Difference | Notes |
|---|---|---|---|---|
| No saved bank totals yet. | ||||
Supporting Totals
These give you the rest of the office-wide picture beyond escrow alone.
At Mortgage
$0.00
Money/checks still routing through mortgage handling.
Mortgage Escrow
$0.00
Money still sitting in a mortgage company escrow account.
Homeowner Funds
$52,979.37
Money still with or already paid to the homeowner.
Unallocated / In Transit
$8,614.74
Money still in transit or not yet placed into a final bucket.
Paid to CGPA
$21,550.40
Fee money already moved out of escrow to CGPA.
Paid to Vendors
$176,212.25
Carrier money already paid out to contractors or vendors.
Carrier Paid To Date
$273,454.86
Total carrier money entered across all claims.
Claims In Rollup
$15.00
Every claim currently captured in the program.
Claim-by-Claim Escrow Position
This is the sub-ledger view. Each row shows how much that claim is holding in office escrow and whether it is ahead or behind after outside advances.
| Claim | Insured | Status | Office Escrow | Advanced Elsewhere | Net Position | At Mortgage | Mortgage Escrow | Homeowner Funds | Unallocated | Payments | Vendors | Updated |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1: 33-88J6-21T | Mary Weaver | open | $0.00 | $8,583.37 | -$8,583.37 | $0.00 | $0.00 | $4,342.78 | $0.00 | 12 | 5 | Jun 13, 2026 |
| 2: 33-90G6-45F | Mary Weaver | open | $1,482.04 | $0.00 | $1,482.04 | $0.00 | $0.00 | $0.00 | $0.00 | 7 | 4 | Jun 11, 2026 |
| 33-95B2-58S | Kristen Cathell | open | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $13,667.85 | $0.00 | 3 | 2 | May 28, 2026 |
| 0796775807 | Robert Covert | open | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $4,421.83 | $0.00 | 4 | 3 | May 26, 2026 |
| 7009464880-1 | Veronica Carethers | open | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 1 | May 26, 2026 |
| 058642204-01 | Troy Byrd | open | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 1 | May 26, 2026 |
| 7009974817-1 | Allyson Bucek | open | $3,792.23 | $0.00 | $3,792.23 | $0.00 | $0.00 | $0.00 | $1,305.40 | 5 | 5 | May 26, 2026 |
| 33-95C4-80H | Gary Brady | open | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 1 | May 25, 2026 |
| 0821005642 | Sade Jones-Massey | open | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $13,573.84 | $7,309.34 | 3 | 5 | May 25, 2026 |
| 1: NC25-0104570 | Mary Barlow | open | $5,024.24 | $0.00 | $5,024.24 | $0.00 | $0.00 | $0.00 | $0.00 | 2 | 4 | May 25, 2026 |
| 2: NC25-0104654 | Mary Barlow | open | $1,061.84 | $0.00 | $1,061.84 | $0.00 | $0.00 | $0.00 | $0.00 | 1 | 1 | May 25, 2026 |
| 00110300554 | Betsy Braddy | open | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 1 | May 25, 2026 |
| JCA9697001H | Daniel and Sarah Caudill | other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $6,414.59 | $0.00 | 7 | 2 | May 20, 2026 |
| CLF-00136246 | Wendell Ingram | open | $3,127.87 | $0.00 | $3,127.87 | $0.00 | $0.00 | $0.00 | $0.00 | 2 | 3 | May 7, 2026 |
| 171362AB | Norma Eubanks | partially paid | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $10,558.48 | $0.00 | 2 | 1 | May 7, 2026 |