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-09-21 05:03.
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.
-
In PSA and contacted
-
Needs contact
-
Not in PSA
How the book is doing
Open work that is ours. Each rate shows the share, what it was measured
against, and how many are left to fix — the number is the link. The spreadsheet line
is not a company number: the sheets are kept by hand and lag on purpose.
Spreadsheet caught up——the sheets are manual and lag on purpose
Change in points against Monday 2026-09-14, 7 days back. The week starts Monday, so the comparison always lands on one. Hidden when one project manager is selected — the comparison is book-wide.
Coverage
-
All jobs
-
Missing from XactAnalysis
non-XA claims excluded
-
Missing from PSA
-
No Encircle photos
no photographs on the job
-
On a sheet, in no system
-
In a system, on no sheet
-
Closed, never in PSA
finished -- nothing to create
-
Cancelled or reassigned
not ours to create
-
XactAnalysis names another PM
not ours -- the open ones are on Dawn's list
Movement
compared with 2026-09-19, 33 hours ago
0
Added
0
Closed
0
Gaps opened
0
Gaps closed
0
Disappeared from the data
The book
-
Open
-
Closed
-
CAT
-
Non-XA
-
North
-
South
-
Unknown
Money
-
Estimated revenue (PSA)
-
No revenue figure
Worth a look
-
Records with a gap
-
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 (1)
Jasmine Wittow & Barry Janzen — XactAnalysis claim has no PSA job
On a tracker sheet, in neither system (1)
Cathy Hys, property manager — on a tracker sheet but in neither XactAnalysis nor PSA
A contents/rebuild phase row we could not match to its job (4)
Cuff — a contents/rebuild phase row that did not match a parent job (row 12, row 13) -- the row gives a surname and no address
Singh — a contents/rebuild phase row that did not match a parent job (row 14) -- the row gives a surname and no address
Maloney — a contents/rebuild phase row that did not match a parent job (row 24) -- the row gives a surname and no address
Gibbens — a contents/rebuild phase row that did not match a parent job (row 25) -- the row gives a surname and no address
PSA job with no XactAnalysis claim (3)
2297635 Alberta Ltd. — PSA job exists but no XactAnalysis claim
Strong Pilates — PSA job exists but no XactAnalysis claim
Doug Kassian and Donna Kassian — PSA job exists but no XactAnalysis claim
PSA and XactAnalysis hold this loss under different claim numbers (4)
Brian Mcclelland Laurie Mcclelland — this record is filed under 004000001346856; PSA job K26-2096-CATWM carries claim 004000001346817
Keathann Laflamme — this record is filed under AA2-2-008058; PSA job K26-2318-CATWM carries claim AA2-2-008084
Karen Bernecker — this record is filed under 000-00-292759; PSA job K26-2300-CATWM carries claim 000-00-277029
Sasa Sestic — this record is filed under AA2-2-006990; PSA job K26-2406-CATWM carries claim AA2-2-007986
XactAnalysis reassigned or cancelled this, and PSA still has the job (4)
Sevim Kocak — XactAnalysis has reassigned or cancelled this assignment (claim 5520045724282) -- PSA still has K26-2160-CATWM open Sheet note: Reassigned
1089909 Alberta Ltd. — XactAnalysis has reassigned or cancelled this assignment (claim 000-00-274659) -- PSA still has K26-2207-CATWM open Sheet note: Inspected: Outside service area
John Breen — XactAnalysis has reassigned or cancelled this assignment (claim 36176970) -- PSA still has K26-2213-CATWM open
Allan Mytrash — XactAnalysis has reassigned or cancelled this assignment (claim 000-00-273752) -- PSA still has K26-2285-CATWM open
In XactAnalysis, on no tracker sheet (6)
Karen Bernecker — 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
Virpal Khosa & Rajinder Khosa — in XactAnalysis (south) but on no tracker sheet
Rgmm Developments Inc — in XactAnalysis (south) but on no tracker sheet
Rachel Mcdonald — in XactAnalysis (cat) but on no tracker sheet
PSA job on no tracker sheet (12)
Karen Bernecker — PSA job K26-2300-CATWM is on no tracker sheet
Virpal Khosa & Rajinder Khosa — PSA job K26-2292-CATWM is on no tracker sheet
Rgmm Developments Inc — PSA job K26-2291-CATWM is on no tracker sheet
2297635 Alberta Ltd. — PSA job K26-2062-CATWM is on no tracker sheet
Kevin Sembaliuk — PSA job K26-2097-CATWM, K26-2399-CNT is on no tracker sheet
Strong Pilates — PSA job K26-2180-CATWM is on no tracker sheet
P76679646hab — PSA job K26-2201-CATWM is on no tracker sheet
Cu Nham — PSA job K26-2244-CATWM, K26-2396-CNT is on no tracker sheet
Ali Abbaspour Gharamalek (URG) — PSA job K26-2301-CATWM is on no tracker sheet
Doug Kassian and Donna Kassian — PSA job K26-2437-WM, K26-2437-CNT is on no tracker sheet
Rachel Mcdonald — PSA job K26-2471-CATWM is on no tracker sheet
Abedi,Jafar — PSA job K26-2488-CATWM is on no tracker sheet
XactAnalysis and PSA name different project managers (3)
Geraldine Gibbens — XactAnalysis says Andrew Chapman, PSA says Kyle Brandon Sheet note: XA assignment previously sent
Carmen Legge (Emg) — XactAnalysis says Andrew Chapman, PSA says Kyle Brandon Sheet note: This one was already scheduled for today.
Two open PSA jobs for the same phase of this claim (3)
Dave Watson Buffy Watson — PSA holds K26-2037-CNT, K26-2390-CNT -- both contents jobs on this claim
Michele Moscicki (Urg) — PSA holds K26-2158-CATWM, K26-2186-CATWM -- both mitigation jobs on this claim
2297635 Alberta Ltd. — PSA holds K26-2061-CATWM, K26-2093-CATWM -- both mitigation jobs on this claim
xa_pm_outside_book (1)
Abedi,Jafar — XactAnalysis assigns this claim to Chad Nicolson, who is not one of ours; PSA holds K26-2488-CATWM under Kyle Brandon
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 (1)
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 (3)
Olabisi Aluko (Urg) — sheet is green (contacted) but no contact date in any system Sheet note: She does not have photos as this is her rental. Would like to speak with a PM to decide on how to move forward.
HEIDY JOSE — sheet is green (contacted) but no contact date in any system Sheet note: Job not sold
Cathy Hys, property manager — sheet is green (contacted) but no contact date in any system
Sheet is red, but PSA has the job (21)
Brian Mcclelland Laurie Mcclelland — sheet is red (not in PSA) but PSA has K26-2096-CATWM
Florinda Moreira — sheet is red (not in PSA) but PSA has K26-2333-CATWM
Keathann Laflamme — sheet is red (not in PSA) but PSA has K26-2318-CATWM
Robert Kelly — sheet is red (not in PSA) but PSA has K26-2303-CATWM
The Estate Of Rick Babichuk — sheet is red (not in PSA) but PSA has K26-2286-CATWM Sheet note: Number not in service
Jessica Beamish — sheet is red (not in PSA) but PSA has K26-2216-CATWM, K26-2227-CATWM
Corey John — sheet is red (not in PSA) but PSA has K26-2215-CATWM
Elliot Chiles — sheet is red (not in PSA) but PSA has K26-2208-CATWM
Corey Clark — sheet is red (not in PSA) but PSA has K26-2064-CATWM, K26-2389-CNT Sheet note: 2nd Claim (you have the first)
Jennifer Hareuther — sheet is red (not in PSA) but PSA has K26-2066-CATWM Sheet note: 2nd Claim (you have the first)
Lorraine Mckay — sheet is red (not in PSA) but PSA has K26-2048-CATWM Sheet note: Declined had other contractor
Maria Luisa Castro Faurillo (Urg) — sheet is red (not in PSA) but PSA has K26-2167-CATWM Sheet note: H/O denied our services for now.
Roxanne Giebelhaus — sheet is red (not in PSA) but PSA has K26-2095-CATWM
Allen Priebe — sheet is red (not in PSA) but PSA has K26-2067-CATWM Sheet note: This is a reassigment
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-2060-CATWM, K26-2047-CATWM Sheet note: PuroClean Edmonton
Sevim Kocak — sheet is red (not in PSA) but PSA has K26-2160-CATWM Sheet note: Reassigned
Laurie Moreau — sheet is red (not in PSA) but PSA has K26-2203-CATWM
1089909 Alberta Ltd. — sheet is red (not in PSA) but PSA has K26-2207-CATWM Sheet note: Inspected: Outside service area
John Breen — sheet is red (not in PSA) but PSA has K26-2213-CATWM
Joel Aspden — sheet is red (not in PSA) but PSA has K26-2271-CATWM
Sheet says it needs contact, but a contact date exists (55)
Brian Mcclelland Laurie Mcclelland — sheet is red (needs contact) but xactanalysis has a contact date
Mel Knott — sheet is yellow (needs contact) but xactanalysis has a contact date
Megan Sumner / Nicholas Klose — sheet is yellow (needs contact) but xactanalysis has a contact date
Mildred Campbell — sheet is yellow (needs contact) but xactanalysis has a contact date
Camille Ostapowich-Allen — sheet is yellow (needs contact) but xactanalysis has a contact date
Stanley Essery — sheet is yellow (needs contact) but xactanalysis has a contact date Sheet note: Left voicemail
Connie Bolton — sheet is yellow (needs contact) but xactanalysis has a contact date
Devra Henderson/ James Henderson — sheet is yellow (needs contact) but xactanalysis has a contact date
Florinda Moreira — sheet is red (needs contact) but xactanalysis has a contact date
Olga Zurowski — sheet is yellow (needs contact) but xactanalysis has a contact date
Keathann Laflamme — sheet is red (needs contact) but xactanalysis has a contact date
Nola-Rose Taylor Visser — sheet is yellow (needs contact) but xactanalysis has a contact date
J.Maurice Gaudet — sheet is yellow (needs contact) but xactanalysis has a contact date
Robert Kelly — sheet is red (needs contact) but xactanalysis has a contact date
Karen Chomiak — sheet is yellow (needs contact) but xactanalysis has a contact date
The Estate Of Rick Babichuk — sheet is red (needs contact) but xactanalysis has a contact date Sheet note: Number not in service
Novel Masih — sheet is yellow (needs contact) but xactanalysis has a contact date
Elgen John Rivera — sheet is yellow (needs contact) but xactanalysis has a contact date
Jessica Beamish — sheet is red (needs contact) but xactanalysis has a contact date
Corey John — sheet is red (needs contact) but xactanalysis has a contact date
Elliot Chiles — sheet is red (needs contact) but xactanalysis has a contact date
Andrew Dye — sheet is yellow (needs contact) but xactanalysis has a contact date Sheet note: Left voicemail
Filomena Scarsella — sheet is yellow (needs contact) but xactanalysis has a contact date
Sasa Sestic — sheet is yellow (needs contact) but xactanalysis has a contact date
Cornelius Strydhorst — sheet is yellow (needs contact) but xactanalysis has a contact date
Corey Clark — sheet is red (needs contact) but xactanalysis has a contact date Sheet note: 2nd Claim (you have the first)
Arshbir Kaur Sandhu — sheet is yellow (needs contact) but xactanalysis has a contact date
Renato Acupan — sheet is yellow (needs contact) but xactanalysis has a contact date Sheet note: Left voicemail
Jennifer Hareuther — sheet is red (needs contact) but xactanalysis has a contact date Sheet note: 2nd Claim (you have the first)
Lorraine Mckay — sheet is red (needs contact) but xactanalysis has a contact date Sheet note: Declined had other contractor
Colin Bain — sheet is yellow (needs contact) but xactanalysis has a contact date Sheet note: Left voicemail explaining crew is on the way, and will contact by the end of the week.
Neil Macleod (Urg) — sheet is yellow (needs contact) but xactanalysis has a contact date Sheet note: Left voicemail explaining the backlog and that I have sent a link to send pics back to us.
Maria Luisa Castro Faurillo (Urg) — sheet is red (needs contact) but xactanalysis has a contact date Sheet note: H/O denied our services for now.
Shiraz Mithani (Urg) — sheet is yellow (needs contact) but xactanalysis has a contact date Sheet note: Number is not in service now.
Martin Saunders (Urg) — sheet is yellow (needs contact) but psa has a contact date Sheet note: Left voicemail asking to upload photos into encircle link I sent to him.
Sheena Abar-Iyamu (Urg) — sheet is yellow (needs contact) but xactanalysis has a contact date Sheet note: Left voicemail asking HO to upload pictures via link sent in email
Nekayla Beddow (Urg) — sheet is yellow (needs contact) but xactanalysis has a contact date Sheet note: Left message saying they will be contacted by PM within 24 hours
Roxanne Giebelhaus — sheet is red (needs contact) but xactanalysis has a contact date
Jasmine Wittow & Barry Janzen — sheet is red (needs contact) but xactanalysis has a contact date
Joe Guevarra — sheet is yellow (needs contact) but xactanalysis has a contact date
…and 15 more in the CSV.
Phase rows for one claim carry different colours (2)
Jennifer Hareuther — phase rows for this claim carry different colours Sheet note: 2nd Claim (you have the first)
Allen Priebe — phase rows for this claim carry different colours Sheet note: This is a reassigment
The same assignment is listed twice on one sheet (1)
Nancy Maldonado — Open Jobs row 214: called='Duplicate' Sheet note: Called: Duplicate
Jerry Kiriak — Open Jobs row 136: inspected='Duplicate' Sheet note: Inspected: Duplicate
Patricia Swanson — Open Jobs row 234: job start='N/A' Sheet note: Inspection Fee Invoice only.
Patricia Swanson — Open Jobs row 234: estimate uploaded='N/A' Sheet note: Inspection Fee Invoice only.
Deborah Lone — Open Jobs row 72: inspected='Duplicate ?' Sheet note: Inspected: Duplicate ?
Corey Forbes — Open Jobs row 57: inspected='Duplicate' Sheet note: Inspected: Duplicate
1089909 Alberta Ltd. — Open Jobs row 3: inspected='Outside service area' Sheet note: Inspected: Outside service area
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
JobList.csv
2026-09-21 05:00
0 h old
XactAnalysis export
XactAnalysis_Export_a_chapman_2026-09-21.xlsx
2026-09-21 05:03
0 h old
Andrew's tracker
Andrew-Outsourced.xlsx
2026-09-20 19:04
10 h old
CAT tracker
CAT Job Tracker - Edmonton.xlsx
2026-09-20 19:04
10 h old
Encircle
encircle-reconcile-2026-09-20.csv
2026-09-20 19:24
10 h old
Why this page and the dashboard differ
Checked 2026-09-20. The master list is the whole book with no date cutoff; the exceptions dashboard carries this week's open work, filed by claim number. They are meant to differ — what matters is that every claim in the gap is accounted for.
278 on this page, 236 on the dashboard, 234 on both.
Every one of the 46 differences has a named cause. Nothing here is an error.
Claims
Where
Why they are not on both
15
on this page only
The job is closed. The dashboard carries open work; the master list is the whole book.
7
on this page only
A tracker row that never resolved to a claim number. The dashboard is indexed by claim, so it has nowhere to put these.
7
on this page only
PSA has the job and XactAnalysis genuinely has no assignment for it. Verified against the raw exports, not taken on the master list's word.
5
on this page only
XactAnalysis has cancelled or closed the claim. Same reason as above.
5
on this page only
Production is closed on the PSA job. PSA keeps Status = Open until invoicing and payment settle, so the job stays in the book -- but the work is finished, and the dashboard carries live work.
3
on this page only
The CAT tracker's Assigned Team column does not list this claim under Kelowna, but one of our own project managers is named on it -- on the PSA job or by XactAnalysis. That column is hand-kept and our record is not, so somebody has to say which of the two is right.
2
on the dashboard only
On the dashboard, and the CAT tracker's Assigned Team column does not list it under Kelowna. With no PSA job of ours against it, it should not be sitting on a PM's board here.
1
on this page only
Andrew's outsourced workbook lists this claim -- that IS the assignment, and it is to us. It is absent from the dashboard because the board still scopes itself on the XactAnalysis project manager, which names somebody else. A difference to close in the board's scope, NOT a question for Andrew: asking him whose it is asks him something his own file already answers.
1
on this page only
XactAnalysis has reassigned this claim away from us, and PSA still holds an open job on it. Somebody has to decide whether we still have the work.