:root{
  --navy:#1f3864; --navy2:#2a4a7f; --ink:#1c2430; --muted:#6b7684;
  --line:#e3e7ee; --bg:#f5f7fa; --ok:#1e7a45; --okbg:#d6f0df;
  --review:#8a6d00; --reviewbg:#fdf0c9; --error:#a01c2c; --errorbg:#fbdbe0;
}
*{box-sizing:border-box}
body{margin:0;font-family:-apple-system,BlinkMacSystemFont,"Segoe UI",Roboto,Helvetica,Arial,sans-serif;
  color:var(--ink);background:var(--bg);line-height:1.5}
a{color:var(--navy2);text-decoration:none}
a:hover{text-decoration:underline}
.topbar{display:flex;justify-content:space-between;align-items:center;background:var(--navy);
  color:#fff;padding:12px 24px}
.brand{display:flex;align-items:center;gap:12px}
.logo{background:#fff;color:var(--navy);font-weight:800;letter-spacing:.5px;padding:4px 8px;border-radius:5px;font-size:14px}
.logo.big{font-size:22px;padding:8px 12px}
.app{font-weight:600}
.topbar nav{display:flex;align-items:center;gap:18px}
.topbar nav a{color:#dfe6f2}
.topbar .user{color:#c3cee2;font-size:13px}
.btn-signout{display:inline-block;border:1px solid rgba(255,255,255,.45);color:#fff;padding:5px 14px;border-radius:7px;font-size:13px;font-weight:600;background:rgba(255,255,255,.06)}
.btn-signout:hover{background:#fff;color:var(--navy);text-decoration:none}
/* ---- app shell / sidebar ---- */
.app-shell{display:flex;min-height:100vh}
.app-shell.anon{display:block}
.sidebar{width:230px;flex:0 0 230px;background:var(--navy);color:#dfe6f2;display:flex;flex-direction:column;position:sticky;top:0;height:100vh}
.side-brand{display:flex;align-items:center;gap:11px;padding:14px 18px;border-bottom:1px solid rgba(255,255,255,.12)}
.side-brand .brand-txt{font-weight:600;color:#fff;white-space:nowrap;font-size:15px}
.side-logo{width:40px;height:40px;flex:0 0 40px;border-radius:50%;background:#fff;padding:2px;object-fit:contain;box-shadow:0 1px 4px rgba(0,0,0,.25)}
.side-nav{flex:1;padding:10px 8px;overflow-y:auto}
.side-link{display:flex;align-items:center;gap:12px;color:#dfe6f2;padding:10px 12px;border-radius:8px;font-weight:600;font-size:14px;white-space:nowrap}
.side-link:hover{background:rgba(255,255,255,.08);text-decoration:none}
.side-link.active{background:#fff;color:var(--navy)}
.side-link .ico{font-size:17px;width:22px;text-align:center;flex:0 0 22px}
.side-children{display:flex;flex-direction:column;margin:2px 0 8px 30px}
.side-sub{color:#aeb9d4;font-size:13px;padding:6px 10px;border-radius:6px;white-space:nowrap}
.side-sub:hover{background:rgba(255,255,255,.06);color:#fff;text-decoration:none}
.side-sub.active{color:#fff;font-weight:600;background:rgba(255,255,255,.10)}
/* collapse toggle — sits at the TOP of the sidebar */
.collapse-btn{background:transparent;border:0;border-bottom:1px solid rgba(255,255,255,.12);color:#aeb9d4;padding:10px 16px;cursor:pointer;display:flex;align-items:center;justify-content:flex-end;gap:8px;font-size:12px;letter-spacing:.3px;text-transform:uppercase;white-space:nowrap;width:100%}
.collapse-btn:hover{color:#fff;background:rgba(255,255,255,.06)}
.collapse-btn .c-ico{font-size:17px;line-height:1;display:inline-block;transition:transform .15s ease}
/* easter egg — subtle, at the very BOTTOM of the sidebar */
.egg-btn{background:transparent;border:0;border-top:1px solid rgba(255,255,255,.12);color:#5f6d8f;padding:10px 16px;cursor:pointer;display:flex;align-items:center;justify-content:center;gap:8px;font-size:13px;white-space:nowrap;width:100%;transition:color .2s ease}
.egg-btn:hover{color:#ffd76a;background:rgba(255,255,255,.05)}
.egg-btn .egg-ico{font-size:15px}
/* collapsed */
.app-shell.collapsed .sidebar{width:60px;flex-basis:60px}
.app-shell.collapsed .brand-txt,.app-shell.collapsed .side-link .lbl,
.app-shell.collapsed .side-children,.app-shell.collapsed .collapse-btn .lbl,
.app-shell.collapsed .egg-btn .lbl{display:none}
.app-shell.collapsed .side-link{justify-content:center;padding:11px 0}
.app-shell.collapsed .side-brand{justify-content:center;padding:14px 0}
.app-shell.collapsed .collapse-btn{justify-content:center}
.app-shell.collapsed .collapse-btn .c-ico{transform:rotate(180deg)}
.main-col{flex:1;min-width:0;display:flex;flex-direction:column}
.topbar-lite{display:flex;align-items:center;gap:14px;background:#fff;border-bottom:1px solid var(--line);padding:10px 22px}
.topbar-lite .spacer{flex:1}
.topbar-lite .user{color:var(--muted);font-size:13px}
.topbar-lite .btn-signout{border:1px solid var(--line);color:var(--navy);background:#fff}
.topbar-lite .btn-signout:hover{background:var(--navy);color:#fff}
.hamburger{display:none;border:0;background:#eef1f7;border-radius:6px;width:34px;height:34px;font-size:16px;cursor:pointer}
@media(max-width:760px){.hamburger{display:block}.sidebar{position:fixed;z-index:40;left:0;top:0}.app-shell:not(.collapsed) .sidebar{box-shadow:2px 0 12px rgba(0,0,0,.2)}.app-shell.collapsed .sidebar{transform:translateX(-100%)}}

.wrap{max-width:1180px;margin:26px auto;padding:0 24px;width:100%}
.foot{text-align:center;color:var(--muted);font-size:12px;padding:26px}
h1{font-size:22px;margin:.2em 0}
h2{font-size:16px;margin:0 0 12px}
.muted{color:var(--muted)}
.mono{font-family:ui-monospace,SFMono-Regular,Menlo,Consolas,monospace}
.small{font-size:12px}

.card{background:#fff;border:1px solid var(--line);border-radius:12px;padding:20px;margin-bottom:20px;
  box-shadow:0 1px 2px rgba(20,30,50,.04)}
.grid-2{display:grid;grid-template-columns:1.4fr 1fr;gap:20px}
@media(max-width:820px){.grid-2{grid-template-columns:1fr}}

.btn-primary{display:inline-block;background:var(--navy);color:#fff;border:0;padding:11px 18px;
  border-radius:8px;font-weight:600;cursor:pointer;font-size:14px}
.btn-primary:hover{background:var(--navy2);text-decoration:none}
.btn-sm{display:inline-block;background:#eef1f7;color:var(--navy);padding:5px 11px;border-radius:6px;font-size:13px}
.btn-sm:hover{background:#e2e8f4;text-decoration:none}

.uploader{display:flex;flex-direction:column;gap:14px;margin-top:10px}
.drop{border:2px dashed #c4cde0;border-radius:10px;padding:26px;text-align:center;color:var(--muted);
  cursor:pointer;transition:.15s;background:#fafbfe}
.drop:hover{border-color:var(--navy2);background:#f3f6fd}
.drop input{display:none}

.stat-list{list-style:none;padding:0;margin:0}
.stat-list li{padding:7px 0;border-bottom:1px solid var(--line)}
.stat-list li:last-child{border:0}
.stat-list b{font-size:18px;color:var(--navy)}
.stat-list .warn b{color:var(--error)}

.tbl{width:100%;border-collapse:collapse;font-size:14px}
.tbl th{text-align:left;background:#f0f3f9;color:#41506a;padding:9px 10px;border-bottom:2px solid var(--line);font-size:12px;text-transform:uppercase;letter-spacing:.3px}
.tbl td{padding:9px 10px;border-bottom:1px solid var(--line);vertical-align:top}
.tbl.compact td,.tbl.compact th{padding:6px 8px;font-size:13px}
.tbl tbody tr:hover{background:#fafbfe}

.pill{display:inline-block;padding:2px 9px;border-radius:20px;font-size:12px;font-weight:700}
.pill.ok{background:var(--okbg);color:var(--ok)}
.pill.review{background:var(--reviewbg);color:var(--review)}
.pill.error{background:var(--errorbg);color:var(--error)}
tr.rs-ERROR{background:#fff7f8}
tr.rs-REVIEW{background:#fffdf4}

.flags .flag{display:block;font-size:11.5px;color:#6a5300;background:#fdf6de;border:1px solid #f0e2ac;
  border-radius:5px;padding:1px 6px;margin:2px 0}
tr.rs-ERROR .flag{color:#7a1420;background:#fdeef0;border-color:#f2c4cc}

.run-head{display:flex;justify-content:space-between;align-items:flex-start;gap:16px;margin-bottom:16px}
.cards-row{display:flex;gap:14px;margin-bottom:18px;flex-wrap:wrap}
.stat{flex:1;min-width:130px;background:#fff;border:1px solid var(--line);border-radius:10px;padding:14px 16px}
.stat b{display:block;font-size:26px;color:var(--navy)}
.stat span{color:var(--muted);font-size:13px}
.stat.ok b{color:var(--ok)} .stat.review b{color:var(--review)} .stat.error b{color:var(--error)}

.filter-bar{display:flex;align-items:center;gap:8px;margin-bottom:12px}
.chip{border:1px solid var(--line);background:#fff;border-radius:20px;padding:5px 13px;cursor:pointer;font-size:13px}
.chip.active{background:var(--navy);color:#fff;border-color:var(--navy)}
.crumbs{color:var(--muted);font-size:13px;margin-bottom:8px}

.login-card{max-width:420px;margin:8vh auto;background:#fff;border:1px solid var(--line);border-radius:16px;
  padding:40px;text-align:center;box-shadow:0 6px 24px rgba(20,30,50,.06)}
.login-card h1{margin:16px 0 6px}
.btn-google{display:inline-flex;align-items:center;gap:10px;border:1px solid #d0d7e2;border-radius:8px;
  padding:11px 20px;margin-top:18px;font-weight:600;color:var(--ink);background:#fff}
.btn-google:hover{background:#f7f9fc;text-decoration:none}
.btn-google .g{background:var(--navy);color:#fff;width:22px;height:22px;border-radius:4px;display:grid;place-items:center;font-weight:800}
.dev-note{margin-top:18px;font-size:12px;color:var(--review);background:var(--reviewbg);padding:8px;border-radius:6px}

/* edit button + edited tag */
.btn-edit{border:1px solid var(--line);background:#fff;color:var(--navy);border-radius:6px;padding:3px 12px;font-size:12px;cursor:pointer;font-weight:600}
.btn-edit:hover{background:var(--navy);color:#fff;border-color:var(--navy)}
.edited-tag{color:var(--navy2);font-weight:700;cursor:default}

/* modal */
.modal-back{position:fixed;inset:0;background:rgba(20,30,50,.45);display:none;align-items:flex-start;justify-content:center;z-index:50;padding:40px 16px;overflow:auto}
.modal-back.show{display:flex}
.modal{background:#fff;border-radius:14px;max-width:720px;width:100%;box-shadow:0 12px 40px rgba(0,0,0,.25)}
.modal-head{display:flex;justify-content:space-between;align-items:center;padding:18px 22px;border-bottom:1px solid var(--line)}
.modal-head h2{margin:0}
.modal-x{border:0;background:#eef1f7;border-radius:6px;width:30px;height:30px;cursor:pointer;font-size:15px}
.edit-form{padding:20px 22px}
.ef-grid{display:grid;grid-template-columns:1fr 1fr;gap:12px 16px}
.edit-form label{display:flex;flex-direction:column;font-size:12px;color:var(--muted);font-weight:600;gap:4px}
.edit-form label.wide{grid-column:1 / -1}
.edit-form input{border:1px solid var(--line);border-radius:7px;padding:8px 10px;font-size:14px;color:var(--ink)}
.edit-form input:focus{outline:2px solid var(--navy2);border-color:var(--navy2)}
.hint{font-size:12px;color:var(--muted);background:#f3f6fd;border:1px solid #dce6f7;border-radius:7px;padding:8px 10px;margin:14px 0}
.live-flags{margin:12px 0;display:flex;flex-wrap:wrap;gap:6px;align-items:center}
.modal-actions{display:flex;justify-content:flex-end;gap:10px;margin-top:8px}
.history{border-top:1px solid var(--line);padding:16px 22px;background:#fafbfe;border-radius:0 0 14px 14px}
.history h3{margin:0 0 8px;font-size:13px;color:#41506a;text-transform:uppercase;letter-spacing:.3px}
.hist-item{font-size:13px;padding:4px 0;border-bottom:1px dashed var(--line)}
.hist-item:last-child{border:0}

/* ---- data grid (results table) ---- */
.tbl-scroll{width:100%}
.datagrid{width:100%;table-layout:auto;font-size:13.5px}
.datagrid td,.datagrid th{padding:7px 10px;vertical-align:top}
.datagrid td{font-family:-apple-system,BlinkMacSystemFont,"Segoe UI",Roboto,Helvetica,Arial,sans-serif;color:#2b3240}
.datagrid thead th{position:sticky;top:0;z-index:2;background:#eef2f8}
.datagrid .code{color:#8a94a4;font-size:11.5px;margin-right:2px}
.datagrid .acct{color:#41506a;font-size:12px;word-break:break-word;line-height:1.35}
.datagrid .col-account{max-width:270px}
.datagrid .col-school{max-width:190px}
.datagrid .col-reason{max-width:180px}
.datagrid .col-emp{max-width:150px}
.datagrid .col-flags{max-width:230px}
.datagrid .col-sub{max-width:150px}
.hidden-col{display:none!important}
/* pin the Edit column on the left */
.datagrid th.col-edit,.datagrid td.col-edit{position:sticky;left:0;background:#fff;z-index:1}
.datagrid thead th.col-edit{z-index:3;background:#eef2f8}
.datagrid tr.rs-ERROR td.col-edit{background:#fff7f8}
.datagrid tr.rs-REVIEW td.col-edit{background:#fffdf4}

/* column chooser */
.col-chooser{position:relative}
.chooser-panel{display:none;position:absolute;right:0;top:34px;background:#fff;border:1px solid var(--line);
  border-radius:8px;box-shadow:0 8px 24px rgba(20,30,50,.14);padding:8px;z-index:30;min-width:190px;max-height:320px;overflow:auto}
.chooser-panel.show{display:block}
.chooser-panel label{display:flex;align-items:center;gap:8px;font-size:13px;padding:5px 7px;cursor:pointer;white-space:nowrap;color:var(--ink)}
.chooser-panel label:hover{background:#f3f6fd;border-radius:5px}
.count-note{color:var(--muted);font-size:12px;margin-top:10px}

/* subs + settings */
.year-select select,.type-edit select{border:1px solid var(--line);border-radius:7px;padding:7px 10px;font-size:13px;background:#fff}
.type-pill{display:inline-block;padding:2px 9px;border-radius:20px;font-size:12px;font-weight:600;background:#eef1f7;color:#41506a}
.type-pill.t-retired{background:#e7e0f7;color:#5a3fa0}
.type-pill.t-long-term{background:#dceafc;color:#215793}
.type-pill.t-regular{background:#e3f0e8;color:#1e7a45}
.type-pill.t-lt{background:#fde9d6;color:#9a5a15}
.stip{font-size:12px;color:#41506a;margin:2px 0}
.stip.stip-ok{color:var(--ok);font-weight:600}
.bar{height:5px;background:#e8ecf3;border-radius:4px;overflow:hidden;margin-top:2px;max-width:150px}
.bar span{display:block;height:100%;background:var(--navy2)}
.stip-ok .bar span{background:var(--ok)}
.settings-nav{display:flex;gap:8px;flex-wrap:wrap;margin-bottom:18px}
.settings-nav a{background:#eef1f7;color:var(--navy);padding:6px 12px;border-radius:20px;font-size:13px}
.settings-nav a:hover{background:var(--navy);color:#fff;text-decoration:none}
.add-form{display:flex;gap:8px;flex-wrap:wrap;margin-top:14px;align-items:center;border-top:1px dashed var(--line);padding-top:14px}
.add-form input,.settings .card input{border:1px solid var(--line);border-radius:7px;padding:7px 9px;font-size:13px}
.card table input{border:1px solid var(--line);border-radius:6px;padding:6px 8px;font-size:13px;width:100%;box-sizing:border-box}
.card table input.num{max-width:100px}
.card table input.wideinput{font-family:ui-monospace,Menlo,monospace;font-size:12px}
.row-actions{display:flex;gap:6px}
.row-actions form{display:inline}
.btn-sm.danger{background:#fdeef0;color:var(--error)}
.btn-sm.danger:hover{background:var(--error);color:#fff}
.datagrid td.ctr,.datagrid th{ text-align:center }
.datagrid td.ctr{text-align:center}
#repTbl td:first-child,#repTbl td:nth-child(2){text-align:left}
#repTbl th:first-child,#repTbl th:nth-child(2){text-align:left}
.totals-row td{background:#f0f3f9;font-weight:600;border-top:2px solid var(--line)}
.paid-form{margin:0}
.paid-form input[type=date]{border:1px solid var(--line);border-radius:6px;padding:4px 6px;font-size:12px}

/* ---- SCUSD logo in the anon top bar ---- */
.topbar-logo{width:34px;height:34px;border-radius:50%;background:#fff;padding:2px;object-fit:contain}

/* ---- "filled" tag on auto-filled account codes ---- */
.tag{display:inline-block;margin-left:6px;padding:1px 7px;border-radius:20px;font-size:10px;font-weight:700;background:var(--reviewbg,#fff3cd);color:var(--review,#8a6d00);text-transform:uppercase;letter-spacing:.4px}

/* ---- easter-egg GIF modal ---- */
.egg-back{position:fixed;inset:0;background:rgba(15,22,40,.72);display:none;align-items:center;justify-content:center;z-index:70;padding:24px}
.egg-back.show{display:flex;animation:eggfade .18s ease}
@keyframes eggfade{from{opacity:0}to{opacity:1}}
.egg-modal{position:relative;background:#000;border-radius:16px;overflow:hidden;box-shadow:0 20px 60px rgba(0,0,0,.5);max-width:92vw}
.egg-gif{display:block;max-width:520px;width:100%;max-height:72vh;object-fit:contain}
.egg-cap{color:#fff;text-align:center;font-size:14px;padding:10px 14px;background:#111}
.egg-x{position:absolute;top:10px;right:10px;width:34px;height:34px;border:0;border-radius:50%;background:rgba(0,0,0,.55);color:#fff;font-size:15px;cursor:pointer;z-index:2}
.egg-x:hover{background:rgba(0,0,0,.85)}