Every job that is ours across Edmonton North, Edmonton South, the CAT
account and direct carrier referrals — checked against XactAnalysis, PSA, Encircle
and the two tracker spreadsheets. Generated 2026-08-07 15:09.
This board was built from data that is 23 hours old
The oldest input is XactAnalysis export, exported 2026-08-06 16:24. Anything changed in PSA or XactAnalysis since then is not on this page.
Where the numbers come from
Each source is exported or synced separately, so they are rarely the same
age. This page does not average them into one “as of”.
| Source | File | Exported | Age |
|---|
| PSA job list | Data/JobList.csv | 2026-08-06 20:50 | 18 h old |
| XactAnalysis export | Data/XactAnalysis\XactAnalysis_Export_2026-08-06_162444.xlsx | 2026-08-06 16:24 | 23 h old |
| Andrew's tracker | MasterList/Trackers\Andrew-Outsourced.xlsx | 2026-08-07 14:09 | 1 h old |
| CAT tracker | MasterList/Trackers\CAT Job Tracker - Edmonton.xlsx | 2026-08-07 14:09 | 1 h old |
| Encircle | C:\Users\Jonathan\OneDrive - PuroClean Kelowna\_Jonathan's Documents\Projects\Claude Code\Edmonton XactAnalysis Review\Reports\xactanalysis\encircle-reconcile-2026-08-07.csv | 2026-08-07 15:05 | 0 h old |
Where every job stands
Green, yellow and red mean what they mean on Andrew's sheet —
but taken from XactAnalysis and PSA this morning, not from the spreadsheet.
Coverage
-
Missing from XactAnalysis
non-XA claims excluded
-
No Encircle documentation
-
On a sheet, in no system
-
In a system, on no sheet
Movement
No comparison available — first run -- no earlier snapshot to compare with.
Worth a look
-
Spreadsheet out of date
expected; sheets are manual
-
Matched by name, not by number
check these
-
Contact attempted, not reached
Where the spreadsheets and the systems disagree
The tracker sheets record what people believe; XactAnalysis and PSA record
what the systems hold. These are the places the two do not line up.
In XactAnalysis, no PSA job yet (14)
- Matthew Hafso Bmc Hafso Farms Ltd — XactAnalysis claim has no PSA job
- Karen Chomiak — XactAnalysis claim has no PSA job
- Kyla Moore — XactAnalysis claim has no PSA job
- Patricia Swanson — XactAnalysis claim has no PSA job
- The Estate Of Rick Babichuk — XactAnalysis claim has no PSA job
- Kristopher Barker — XactAnalysis claim has no PSA job
- Terence Yaceyko — XactAnalysis claim has no PSA job
- Allan Mytrash — XactAnalysis claim has no PSA job
- Josephine Arsenio, Placido Ii Catapang — XactAnalysis claim has no PSA job
- Marcos Valdes (Urg) — XactAnalysis claim has no PSA job
- Kayleigh Cline (Gen) — XactAnalysis claim has no PSA job
- Jasmine Wittow & Barry Janzen — XactAnalysis claim has no PSA job
- Virpal Khosa & Rajinder Khosa — XactAnalysis claim has no PSA job
- Rgmm Developments Inc — XactAnalysis claim has no PSA job
On a tracker sheet, in neither system (26)
- Charles Bonsant — on a tracker sheet but in neither XactAnalysis nor PSA
- Kiara Mclaughlin — on a tracker sheet but in neither XactAnalysis nor PSA
- Davis, Craig — on a tracker sheet but in neither XactAnalysis nor PSA
- Geraldine GIbbens — on a tracker sheet but in neither XactAnalysis nor PSA
- Omar Abouzeenni — on a tracker sheet but in neither XactAnalysis nor PSA
- Lucas Knight — on a tracker sheet but in neither XactAnalysis nor PSA
- row:andrew:Edmonton South:94 — on a tracker sheet but in neither XactAnalysis nor PSA
- HEIDY JOSE — on a tracker sheet but in neither XactAnalysis nor PSA
- Constance Shore — on a tracker sheet but in neither XactAnalysis nor PSA
- Jeremy Trapp — on a tracker sheet but in neither XactAnalysis nor PSA
- 2297635 Alberta Ltd — on a tracker sheet but in neither XactAnalysis nor PSA
- Cathy Hys, property manager — on a tracker sheet but in neither XactAnalysis nor PSA
- Samantha Hardeman — on a tracker sheet but in neither XactAnalysis nor PSA
- Ken Feth — on a tracker sheet but in neither XactAnalysis nor PSA
- Nigel Pronovost — on a tracker sheet but in neither XactAnalysis nor PSA
- Cuff — on a tracker sheet but in neither XactAnalysis nor PSA
- Singh — on a tracker sheet but in neither XactAnalysis nor PSA
- Charles Bonsant — on a tracker sheet but in neither XactAnalysis nor PSA
- Kiara Mclaughlin — on a tracker sheet but in neither XactAnalysis nor PSA
- Maloney — on a tracker sheet but in neither XactAnalysis nor PSA
- Gibbens — on a tracker sheet but in neither XactAnalysis nor PSA
- McClelland — on a tracker sheet but in neither XactAnalysis nor PSA
- row:andrew:Other Phases (CON & RE):52 — on a tracker sheet but in neither XactAnalysis nor PSA
- row:andrew:Other Phases (CON & RE):53 — on a tracker sheet but in neither XactAnalysis nor PSA
- Diane Anderson — on a tracker sheet but in neither XactAnalysis nor PSA
- Rostyslav Merdukh — on a tracker sheet but in neither XactAnalysis nor PSA
PSA job with no XactAnalysis claim (41)
- Allstate Insurance - Alberta Regional Office — PSA job exists but no XactAnalysis claim
- Allstate Insurance - Alberta Regional Office — PSA job exists but no XactAnalysis claim
- Wawanesa Insurance — PSA job exists but no XactAnalysis claim
- Square One Claims — PSA job exists but no XactAnalysis claim
- Square One Claims — PSA job exists but no XactAnalysis claim
- Definity / Economical / Family Insurance — PSA job exists but no XactAnalysis claim
- Allstate Insurance - Alberta Regional Office — PSA job exists but no XactAnalysis claim
- Portage Mutual Insurance — PSA job exists but no XactAnalysis claim
- Wawanesa Insurance — PSA job exists but no XactAnalysis claim
- Wawanesa Insurance — PSA job exists but no XactAnalysis claim
- Square One Claims — PSA job exists but no XactAnalysis claim
- Wawanesa Insurance — PSA job exists but no XactAnalysis claim
- Wawanesa Insurance — PSA job exists but no XactAnalysis claim
- TD Insurance — PSA job exists but no XactAnalysis claim
- TD Insurance — PSA job exists but no XactAnalysis claim
- Dylan Ammar — PSA job exists but no XactAnalysis claim
- Square One Claims — PSA job exists but no XactAnalysis claim
- Strong Pilates — PSA job exists but no XactAnalysis claim
- TD Insurance — PSA job exists but no XactAnalysis claim
- Allstate Insurance - Alberta Regional Office — PSA job exists but no XactAnalysis claim
- Definity / Economical / Family Insurance — PSA job exists but no XactAnalysis claim
- Allstate Insurance - Alberta Regional Office — PSA job exists but no XactAnalysis claim
- Wesley MacMillan — PSA job exists but no XactAnalysis claim
- Aviva Specialty Claims Canada — PSA job exists but no XactAnalysis claim
- Aviva Specialty Claims Canada — PSA job exists but no XactAnalysis claim
- Matt Cairns — PSA job exists but no XactAnalysis claim
- Donna Lidgett — PSA job exists but no XactAnalysis claim
- Ryan Jordaan — PSA job exists but no XactAnalysis claim
- Yvonne Stefanidis — PSA job exists but no XactAnalysis claim
- Huma Aziz Warsi — PSA job exists but no XactAnalysis claim
- Yeow Kwang Goh — PSA job exists but no XactAnalysis claim
- Nooran Ostadeian — PSA job exists but no XactAnalysis claim
- Brian Mihailides — PSA job exists but no XactAnalysis claim
- Hakan Yildirim — PSA job exists but no XactAnalysis claim
- Milanka Mitchell — PSA job exists but no XactAnalysis claim
- Annette Guerrette — PSA job exists but no XactAnalysis claim
- Vincent Cossette — PSA job exists but no XactAnalysis claim
- Andrew Burns — PSA job exists but no XactAnalysis claim
- Nooran Ostadeian — PSA job exists but no XactAnalysis claim
- Kevin Kennedy — PSA job exists but no XactAnalysis claim
- …and 1 more in the CSV.
In XactAnalysis, on no tracker sheet (21)
- Matthew Hafso Bmc Hafso Farms Ltd — in XactAnalysis (north) but on no tracker sheet
- Karen Chomiak — in XactAnalysis (cat) but on no tracker sheet
- Kyla Moore — in XactAnalysis (cat) but on no tracker sheet
- Patricia Swanson — in XactAnalysis (cat) but on no tracker sheet
- The Estate Of Rick Babichuk — in XactAnalysis (cat) but on no tracker sheet
- Kristopher Barker — in XactAnalysis (cat) but on no tracker sheet
- Tracey Bennett — in XactAnalysis (cat) but on no tracker sheet
- Renato Acupan — in XactAnalysis (south) but on no tracker sheet
- Colin Bain — in XactAnalysis (south) but on no tracker sheet
- Josephine Arsenio, Placido Ii Catapang — in XactAnalysis (south) but on no tracker sheet
- Jack Bentham And Paula Bentham And Paul Bentham — in XactAnalysis (south) but on no tracker sheet
- Mike Mayr — in XactAnalysis (south) but on no tracker sheet
- Andrew Dye — in XactAnalysis (south) but on no tracker sheet
- Normand Paradis — in XactAnalysis (south) but on no tracker sheet
- Marcos Valdes (Urg) — in XactAnalysis (south) but on no tracker sheet
- Kayleigh Cline (Gen) — in XactAnalysis (south) but on no tracker sheet
- Frank Horvath (Gen) — in XactAnalysis (south) but on no tracker sheet
- Jasmine Wittow & Barry Janzen — in XactAnalysis (south) but on no tracker sheet
- Krystal Browning (Kirner) — in XactAnalysis (south) but on no tracker sheet
- Virpal Khosa & Rajinder Khosa — in XactAnalysis (south) but on no tracker sheet
- Rgmm Developments Inc — in XactAnalysis (south) but on no tracker sheet
PSA job on no tracker sheet (41)
- Tracey Bennett — PSA job K26-2251-CATWM is on no tracker sheet
- Renato Acupan — PSA job K26-2249-CATWM is on no tracker sheet
- Colin Bain — PSA job K26-2237-CATWM is on no tracker sheet
- Jack Bentham And Paula Bentham And Paul Bentham — PSA job K26-2254- is on no tracker sheet
- Mike Mayr — PSA job K26-2240-CATWM is on no tracker sheet
- Andrew Dye — PSA job K26-2252-CATWM is on no tracker sheet
- Normand Paradis — PSA job K26-2221-WM is on no tracker sheet
- Frank Horvath (Gen) — PSA job K26-2248 -CAT-WR is on no tracker sheet
- Krystal Browning (Kirner) — PSA job K26-2238-CATWM is on no tracker sheet
- Allstate Insurance - Alberta Regional Office — PSA job K26-2040-CATWM is on no tracker sheet
- Wawanesa Insurance — PSA job K26-2050-CATWM is on no tracker sheet
- Square One Claims — PSA job K26-2061-CATWM is on no tracker sheet
- Square One Claims — PSA job K26-2062-CATWM is on no tracker sheet
- Definity / Economical / Family Insurance — PSA job K26-2093-CATWM is on no tracker sheet
- Allstate Insurance - Alberta Regional Office — PSA job K26-2097-CATWM is on no tracker sheet
- Portage Mutual Insurance — PSA job K26-2103-CATWM is on no tracker sheet
- Wawanesa Insurance — PSA job K26-2104-CATWM is on no tracker sheet
- Wawanesa Insurance — PSA job K26-2105-CATWM is on no tracker sheet
- Square One Claims — PSA job K26-2106-CATWM is on no tracker sheet
- Wawanesa Insurance — PSA job K26-2107-CATWM is on no tracker sheet
- Wawanesa Insurance — PSA job K26-2108-CATWM is on no tracker sheet
- TD Insurance — PSA job K26-2169-CATWM is on no tracker sheet
- Square One Claims — PSA job K26-2178-CATWM is on no tracker sheet
- Strong Pilates — PSA job K26-2180-CATWM is on no tracker sheet
- TD Insurance — PSA job K26-2186-CATWM is on no tracker sheet
- Aviva Specialty Claims Canada — PSA job K26-2247-CATWM is on no tracker sheet
- Aviva Specialty Claims Canada — PSA job K26-2250-CATWM is on no tracker sheet
- Matt Cairns — PSA job K26-2255-CATWM is on no tracker sheet
- Donna Lidgett — PSA job K26-2256-CATWM is on no tracker sheet
- Ryan Jordaan — PSA job K26-2257-CATWM is on no tracker sheet
- Yvonne Stefanidis — PSA job K26-2258-CATWM is on no tracker sheet
- Huma Aziz Warsi — PSA job K26-2259-CATWM is on no tracker sheet
- Yeow Kwang Goh — PSA job K26-2260-CATWM is on no tracker sheet
- Nooran Ostadeian — PSA job K26-2261-CATWM is on no tracker sheet
- Brian Mihailides — PSA job K26-2262-CATWM is on no tracker sheet
- Milanka Mitchell — PSA job K26-2268-CATWM is on no tracker sheet
- Vincent Cossette — PSA job K26-2272-CATWM is on no tracker sheet
- Andrew Burns — PSA job K26-2274-CATWM is on no tracker sheet
- Nooran Ostadeian — PSA job K26-2275-CATWM is on no tracker sheet
- Kevin Kennedy — PSA job K26-2276-CATWM is on no tracker sheet
- …and 1 more in the CSV.
Where the spreadsheets have fallen behind
The trackers are maintained by hand, so they lag the systems — that is expected, not a problem with the job. The colours everywhere else on this page come from XactAnalysis and PSA, not from these sheets. This list is here so somebody can bring the spreadsheets back into line.
Sheet is green, but there is no PSA job (6)
- Charles Bonsant — sheet is green (in PSA) but no PSA job was found
- Kiara Mclaughlin — sheet is green (in PSA) but no PSA job was found
- Davis, Craig — sheet is green (in PSA) but no PSA job was found
- Geraldine GIbbens — sheet is green (in PSA) but no PSA job was found
- HEIDY JOSE — sheet is green (in PSA) but no PSA job was found
- Cathy Hys, property manager — sheet is green (in PSA) but no PSA job was found
Sheet is green, but no system has a contact date (6)
- Charles Bonsant — sheet is green (contacted) but no contact date in any system
- Kiara Mclaughlin — sheet is green (contacted) but no contact date in any system
- Davis, Craig — sheet is green (contacted) but no contact date in any system
- Geraldine GIbbens — sheet is green (contacted) but no contact date in any system
- HEIDY JOSE — sheet is green (contacted) but no contact date in any system
- Cathy Hys, property manager — sheet is green (contacted) but no contact date in any system
Sheet is red, but PSA has the job (8)
- Brian Mcclelland Laurie Mcclelland — sheet is red (not in PSA) but PSA has K26-2096-CATWM
- Jennifer Hareuther — sheet is red (not in PSA) but PSA has K26-2066-CATWM
- Lorraine Mckay — sheet is red (not in PSA) but PSA has K26-2048-CATWM
- Roxanne Giebelhaus — sheet is red (not in PSA) but PSA has K26-2095-CATWM
- Corey Clark — sheet is red (not in PSA) but PSA has K26-2064-CATWM
- Allen Priebe — sheet is red (not in PSA) but PSA has K26-2067-CATWM
- Cristal Goodman — sheet is red (not in PSA) but PSA has K26-2034-CATWM
- Bridget Stasow — sheet is red (not in PSA) but PSA has K26-2047-CATWM
Sheet says it needs contact, but a contact date exists (12)
- Brian Mcclelland Laurie Mcclelland — sheet is red (needs contact) but psa has a contact date
- Jennifer Hareuther — sheet is red (needs contact) but xactanalysis has a contact date
- Lorraine Mckay — sheet is red (needs contact) but xactanalysis has a contact date
- Roxanne Giebelhaus — sheet is red (needs contact) but xactanalysis has a contact date
- Joe Guevarra — sheet is yellow (needs contact) but xactanalysis has a contact date
- Corey Clark — sheet is red (needs contact) but xactanalysis has a contact date
- Allen Priebe — sheet is red (needs contact) but xactanalysis has a contact date
- Filomena Scarsella — sheet is yellow (needs contact) but xactanalysis has a contact date
- Aaron Dent — sheet is yellow (needs contact) but xactanalysis has a contact date
- Charles Rahall — sheet is yellow (needs contact) but xactanalysis has a contact date
- Cristal Goodman — sheet is red (needs contact) but xactanalysis has a contact date
- Bridget Stasow — sheet is red (needs contact) but xactanalysis has a contact date
Phase rows for one claim carry different colours (2)
- Jennifer Hareuther — phase rows for this claim carry different colours
- Allen Priebe — phase rows for this claim carry different colours
The same assignment is listed twice on one sheet (1)
- Cuff — Other Phases (CON & RE) rows 12, 13 share mfn 06X1ZG5
A date column holds text we could not read (1)
- Diane Anderson — Open Jobs row 197: called='This has been Reassigned to Bremara Power INC'
The list
| Claim # | Customer | Address | Account | PM |
PSA job | Status | In | Status colour | Sheet says | Flags | Sheet rows |