Contract Exceptions

Priority	Check	Count	What it means
Action	1. No technician assigned (Action)	27	Active locations with no tech on the Techs tab - they won't appear on any schedule.
Action	2. Assigned technician inactive or unknown (Action)	1	Assignments to a tech who is terminated/inactive or not in the technician master.
Action	3. Monthly bill unusually high (Action)	1	Active locations with a Current Bill Amount of $10,000 or more - almost certainly a typo.
Review	4. Active contract with no locations (Review)	10	Contracts marked active with no account locations under them.
Review	5. Active location billing $0 (Review)	40	Active locations whose Current Bill Amount is $0 - may be fine (e.g. a secondary location), worth a look.
FYI	6. No transactions in 12+ months (FYI)	64	Active locations with no transaction in the last 12 months.
FYI	7. P.O. expired (FYI)	1	Active contracts whose P.O. expiration date has passed.
FYI	8. Salesrep missing or unknown (FYI)	11	Active contracts with a blank or unrecognized salesrep code.

Export to XLSX Export to CSV Check   Contract   Location   Name   Detail     Check: 1. No technician assigned (Action) (27 item(s))   3419 3MAV 3M AVIATION Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   3419 3MC1 3M CENTER Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   3419 3MCE 3M CENTER Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   2851 GUI9 BOSTON SCIENTIFIC Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   2851 GUID BOSTON SCIENTIFIC Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   3049 MNEL ELMER L ANDERSON BUILDING Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   3073 PARM FORWARD PMX Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   1246 IWCO IWCO DIRECT Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   3049 MNMS METRO SQUARE ANNEX Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   3049 MNMB MINNEHAHA BUILDING Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   2453 TREX MONEY GRAM INTERNATIONAL Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   3195 MOGR MONEYGRAM INTERNATIONAL Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   3399 NORP NORTHRUP GRUMMAN Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   3498 NOAZ NORTHSIDE ACHIEVEMENT ZONE Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   2495 READ NOVASPECT, INC. Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   2753 PCHR PARK CHRYSLER Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   3049 MNPB PINE BUILDING Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   PSCP PSCP PLANTSCAPE, INC Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   2870 EASB RIVERPLACE Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   3407 ROAC ROACH ASSOCIATES LLC Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   3289 SAMB SAMBATEK Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   3307 SHRR SHERATON RIDGEDALE Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   3049 MNGR STATE OF MINNESOTA Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   23196 23196 THE ENSLEY PROJECT Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   3161 UHGR UNITED HEALTH GROUP Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   3521 URBW URBAN WOK Active contract, but the Techs tab has no technician - this account won't appear on any schedule.   3439 WHOA WHITE OAK FINANCIAL Active contract, but the Techs tab has no technician - this account won't appear on any schedule. Check: 2. Assigned technician inactive or unknown (Action) (1 item(s))     NPC8   Tech code ANGELA isn't in the technician master. Check: 3. Monthly bill unusually high (Action) (1 item(s))   3539 MVPL MVP LOGISTICS Current Bill Amount is $20,618.14 - every other location bills under a few thousand. Possible data-entry error (it also inflates billing totals on these pages). Check: 4. Active contract with no locations (Review) (10 item(s))   3999     Status ACTIVE (started date not set) but no account locations point at this contract.   5560     Status ACTIVE (started date not set) but no account locations point at this contract.   3900     Status ACTIVE (started date not set) but no account locations point at this contract.   354     Status ACTIVE (started date not set) but no account locations point at this contract.   CUSH   CUSHMAN AND WAKEFIELD Status ACTIVE (started 04/20/2026) but no account locations point at this contract.   3413   MARQUEE APARTMENTS Status ACTIVE (started 12/16/2020) but no account locations point at this contract.   3409   NORTHPARK CORPORATE CENTER Status ACTIVE (started 11/30/2020) but no account locations point at this contract.   MNPB   PINE BUILDING Status ACTIVE (started 10/31/2006) but no account locations point at this contract.   3542   THE ENSLEY PROJECT Status ACTIVE (started 05/07/2026) but no account locations point at this contract.   3490   WHITEWATER MANAGEMENT Status ACTIVE (started 08/07/2020) but no account locations point at this contract. Check: 5. Active location billing $0 (Review) (40 item(s))   3419 3MAV 3M AVIATION Current Bill Amount is $0 (lease amount $175.00).   3419 3MC1 3M CENTER Current Bill Amount is $0 (lease amount $0.00).   3419 3MCE 3M CENTER Current Bill Amount is $0 (lease amount $0.00).   3176 44TH 44TH STREET DENTAL Current Bill Amount is $0 (lease amount $335.45).   3504 OSHL 7151 METRO HOLDING LLC Current Bill Amount is $0 (lease amount $1,269.25).   3544 AMFI AMERICAN FAMILY INSURANCE Current Bill Amount is $0 (lease amount $888.07).   3150 BAPT BLUE APARTMENTS Current Bill Amount is $0 (lease amount $55.40).   2851 GUI9 BOSTON SCIENTIFIC Current Bill Amount is $0 (lease amount $0.00).   3496 CORS CORSA Current Bill Amount is $0 (lease amount $648.00).   3546 CUSH CUSHMAN & WAKEFIELD Current Bill Amount is $0 (lease amount $13,054.50).   3481 DJRF DJR FLATS ON 94 Current Bill Amount is $0 (lease amount $756.25).   3049 MNEL ELMER L ANDERSON BUILDING Current Bill Amount is $0 (lease amount $6,946.00).   3537 EVER EVEREVE HQ Current Bill Amount is $0 (lease amount $0.00).   3501 FIDD FIDELITY INVESTMENTS Current Bill Amount is $0 (lease amount $307.70).   3073 PARM FORWARD PMX Current Bill Amount is $0 (lease amount $364.50).   2810 GNRS GN RESOUND NORTH AMERICA Current Bill Amount is $0 (lease amount $0.00).   3547 COP2 GRECO PROPERTIES Current Bill Amount is $0 (lease amount $297.25).   3505 HOGR HORTON GROUP Current Bill Amount is $0 (lease amount $335.00).   1246 IWCO IWCO DIRECT Current Bill Amount is $0 (lease amount $114.00).   3507 KLBR K L BROWN & ASSOCIATES Current Bill Amount is $0 (lease amount $259.00).   3536 MMAR MARTIN MARIETTA Current Bill Amount is $0 (lease amount $0.00).   3510 MCGO MCGOUGH Current Bill Amount is $0 (lease amount $807.95).   3049 MNMS METRO SQUARE ANNEX Current Bill Amount is $0 (lease amount $182.25).   3049 MNMB MINNEHAHA BUILDING Current Bill Amount is $0 (lease amount $619.00).   2453 TREX MONEY GRAM INTERNATIONAL Current Bill Amount is $0 (lease amount $0.00).   3399 NORP NORTHRUP GRUMMAN Current Bill Amount is $0 (lease amount $0.00).   3499 NOA2 NORTHSIDE ACHIEVEMENT ZONE Current Bill Amount is $0 (lease amount $858.50).   3498 NOAZ NORTHSIDE ACHIEVEMENT ZONE Current Bill Amount is $0 (lease amount $288.00).   3049 MNPB PINE BUILDING Current Bill Amount is $0 (lease amount $938.55).   PSCP PSCP PLANTSCAPE, INC Current Bill Amount is $0 (lease amount $0.00).   3514 PREN PRENUVO Current Bill Amount is $0 (lease amount $633.50).   3511 RLNC RED LAKE NATIONAL COLLEGE Current Bill Amount is $0 (lease amount $756.00).   2870 EASB RIVERPLACE Current Bill Amount is $0 (lease amount $3,211.55).   3289 SAMB SAMBATEK Current Bill Amount is $0 (lease amount $0.00).   3307 SHRR SHERATON RIDGEDALE Current Bill Amount is $0 (lease amount $1,150.00).   3049 MNGR STATE OF MINNESOTA Current Bill Amount is $0 (lease amount $0.00).   23196 23196 THE ENSLEY PROJECT Current Bill Amount is $0 (lease amount $0.00).   23196 ENSL THE ENSLEY PROJECT Current Bill Amount is $0 (lease amount $992.70).   3521 URBW URBAN WOK Current Bill Amount is $0 (lease amount $0.00).   3461 TEXA VOLO Current Bill Amount is $0 (lease amount $0.00). Check: 6. No transactions in 12+ months (FYI) (64 item(s))   3001 MANL 1915 PLAZA DRIVE Last transaction 09/15/2025   3419 3MAV 3M AVIATION Last transaction 02/27/2023   3419 3MC1 3M CENTER Last transaction 03/07/2023   3419 3MCE 3M CENTER Last transaction 03/07/2023   3200 NATH 6000 NATHAN LANE, LLC Last transaction 03/11/2025   3377 ALLN ALLINA Last transaction 02/13/2025   3323 AVRD AVEDA Last transaction 05/15/2025   3336 BELL BELL BANK Last transaction 07/14/2025   3287 BIYN BIYNAH INDUSTRIAL PARTNERS Last transaction 08/01/2025   2851 GUI9 BOSTON SCIENTIFIC Last transaction 07/23/2015   2851 GUID BOSTON SCIENTIFIC Last transaction 05/24/2017   3218 BOXF BOX FINANCIAL Last transaction 10/17/2024   2239 EPBB BREMER BANK BUILDING Last transaction 03/12/2024   3496 CORS CORSA Last transaction 06/04/2025   3049 MNDC DC-1 Last transaction 03/10/2025   3480 DRCW DORAN CITY WEST Last transaction 04/03/2025   3049 MNEL ELMER L ANDERSON BUILDING Last transaction 09/03/2009   3011 CRAN ENGINEERING SYSTEMS INC. Last transaction 04/25/2024   3537 EVER EVEREVE HQ Last transaction 08/14/2025   3361 FITA FIT APARTMENTS Last transaction 05/28/2025   3073 PARM FORWARD PMX Last transaction 03/30/2021   3489 GAR2 GARDNER Last transaction 07/10/2023   2961 GDER GOOD EARTH Last transaction 08/15/2025   3313 INDU INDUSTRIOUS OFFICE Last transaction 03/07/2025   3051 MNLB LAFAYETTE PARK / STATE OF MN Last transaction 10/03/2025   1177 OPPQ LOCKRIDGE GRINDAL NAUEN PLLP Last transaction 03/07/2025   3522 MACQ MACQUARIE Last transaction 04/03/2025   3512 MCNA MCNELLIS & ASATO, LLC Last transaction 04/11/2025   2668 MHOC MENDOTA HTS. OFFICE CENTER Last transaction 07/21/2025   3049 MNMS METRO SQUARE ANNEX Last transaction 05/12/2009   3452 MILK MILK SPECIALTIES GLOBAL Last transaction 10/08/2025   3049 MNMB MINNEHAHA BUILDING Last transaction 05/01/2009   3519 MIRO MIRO Last transaction 01/24/2025   2453 TREX MONEY GRAM INTERNATIONAL Last transaction 12/20/2019   3195 MOGR MONEYGRAM INTERNATIONAL Last transaction 02/01/2023   3399 NORP NORTHRUP GRUMMAN No transactions on file for this location.   3498 NOAZ NORTHSIDE ACHIEVEMENT ZONE Last transaction 01/19/2024   2487 SEID NORTHSTAR CAPITAL, LTD. Last transaction 08/14/2025   2495 READ NOVASPECT, INC. Last transaction 03/27/2024   3517 SCSH ONWARD INVESTORS Last transaction 10/01/2024   2753 PCHR PARK CHRYSLER Last transaction 02/09/2005   3049 MNPB PINE BUILDING Last transaction 02/03/2017   PSCP PSCP PLANTSCAPE, INC Last transaction 05/29/2025   2742 POLA POLARIS Last transaction 09/09/2025   3299 POLP POLARIS Last transaction 04/12/2023   3514 PREN PRENUVO Last transaction 06/13/2025   3389 QCON Q CONSULTING Last transaction 02/13/2025   3511 RLNC RED LAKE NATIONAL COLLEGE Last transaction 06/28/2024   2870 EASB RIVERPLACE Last transaction 12/01/2021   3407 ROAC ROACH ASSOCIATES LLC Last transaction 01/12/2023   3444 ROCK ROCKET55 Last transaction 06/30/2025   3289 SAMB SAMBATEK No transactions on file for this location.   3307 SHRR SHERATON RIDGEDALE Last transaction 04/25/2020   3049 MNGR STATE OF MINNESOTA Last transaction 09/04/2009   3090 SUMM SUMMERHILL PROFESSIONAL BUILDING Last transaction 03/03/2025   3402 SWER SWERVO OFFICE Last transaction 03/27/2025   3426 TDAT TD AMERITRADE Last transaction 06/13/2025   3161 UHGR UNITED HEALTH GROUP Last transaction 04/26/2024   3521 URBW URBAN WOK No transactions on file for this location.   3461 TEXA VOLO Last transaction 02/01/2023   3282 WMAR WASTE MANAGEMENT BUILDING RECEPTION Last transaction 09/29/2025   3439 WHOA WHITE OAK FINANCIAL Last transaction 09/04/2024   3064 YANK YANKEE DOODLE PROFESSIONAL BLDG Last transaction 01/12/2023   2938 ZHVM ZELLE HOFMANN VOELBEL & MASON LLC Last transaction 05/02/2024 Check: 7. P.O. expired (FYI) (1 item(s))   1111   DONALDSON COMPANY, INC. P.O. 9496000 expired 07/31/1990. Check: 8. Salesrep missing or unknown (FYI) (11 item(s))   3999     No salesrep on the contract.   5560     No salesrep on the contract.   3900     No salesrep on the contract.   354     No salesrep on the contract.   3427   BOWLINE CHAMPLIN Salesrep code E isn't in the salesrep master.   CUSH   CUSHMAN AND WAKEFIELD No salesrep on the contract.   3533   GASSEN COMPANIES Salesrep code AS isn't in the salesrep master.   3536   MARTIN MARIETTA Salesrep code AS isn't in the salesrep master.   3537   PLANTSHED No salesrep on the contract.   3535   SICK Salesrep code AS isn't in the salesrep master.   23286   T3 NORTH LOOP No salesrep on the contract.    Loading… Loading…

"Last transaction" checks use Magic's Transactions log (Visits / Last Visit stopped being updated in 2022). Nothing here changes Magic - fix items in Magic itself, then use "Refresh now" above.