One row per rep and per store. GP is RQ sales history; GP / traffic is Verizon’s traffic report; new lines, perks, premium, VMP, internets and pull through are Verizon’s reports, graded against the month’s scorecard goals. Hours, chargebacks and accessory shrink are Payroll’s. The live month refreshes every 5 minutes; a closed month comes from its saved scorecard month.

The portal keeps its own copy of every uploaded report and of each month’s goals (section goals, each rep’s targets, the store goals table). The check works the month out from those copies alone and compares it with the scorecard, number by number. Once it matches, the sheets aren’t needed to work a month out.

Kept in the portal, copied once from the Commission sheet: last year’s store GP for manager bonuses (exactly as set up there), and the Gusto ID lists the Gusto file is built from. Payroll no longer reads the Commission sheet. If you change one of these tabs on the sheet, copy it again here.

Every day’s GP by store, by rep and product units from the Sales by Invoice and product uploads. Moving it into the portal copies the Redstone Sales History sheet once and checks the GP and unit totals match before switching. After that, uploads save here, and the scorecard, year over year, Payroll and the Data table all read it from here; the sheet is no longer read or written.

The same person should have the same name on every list: the leaderboard, portal logins, comp plans, uploaded hours, RQ sales and Gusto IDs. This lists anyone missing from a list, with a likely match under another spelling.