Studio 1 · June 2026 reconciliation

Your figures vs the automated June pull — side by side

Yours = the numbers from your screenshots  ·  Mine = pulled from the CRM daily-sales export (sales) and Square debt-collections (team), for 1–30 June 2026.
Yours (screenshot) Mine (June pull) green Δ = mine higher red Δ = mine lower
1 · Sales by marketing code — sale price & cash collected (deposit)
Code YOURS (screenshot) MINE (June 2026) Δ Sale $
Sale $Collected% Sale $Collected%
6ab $254,832$92,53236.3% $122,462$41,82534.2% $-132,370-52%
5ab $50,275$13,92027.7% $46,649$26,54956.9% $-3,626-7%
cmn $50,000$17,52535.0% $49,225$13,42527.3% $-775-2%
R $103,766$35,51534.2% $108,149$42,30939.1% +$4,383+4%
N1N $76,405$24,62032.2% $64,745$24,97038.6% $-11,660-15%
tc $17,100$8,30048.5% $10,000$1,20012.0% $-7,100-42%
GD $91,704$31,12233.9% $39,460$17,56044.5% $-52,244-57%
4ab $32,550$18,65057.3% $6,000$4,30071.7% $-26,550-82%
Neilsall codes except 4ab $644,082$223,53434.7% $440,690$167,83838.1% $-203,392-32%
Recycledall codes except GD $584,928$211,06236.1% $407,230$154,57838.0% $-177,698-30%
Grand Totalwhole business $3,635,288$1,399,07838.5% $3,473,699$1,344,67738.7% $-161,589-4%
Why the per-code rows diverge. The grand totals nearly match (yours $3,635,288 vs mine $3,473,699, within 4.4%), but several of your per-code figures are ~2× my June (6ab, GD, N1N, 4ab), while others match closely (cmn, R). That pattern means your screenshot's code breakdown is a longer / different window than a single June — a one-month grand total can't contain per-code rows twice its own size. If you want a true like-for-like, tell me the exact date range your screenshot covered and I'll re-pull that window.
2 · Team Collections (debt collections) — the card, both versions
YOURS (screenshot)
$109,697.89
One Off
$34,281.35
Scheduled
$38,695.36
Recurring
$182,674.60TEAM TOTAL
MINE (June 2026, net of refunds)
$95,928.59
One Off
$43,015.60
Scheduled
$39,387.49
Recurring
$178,331.68TEAM TOTAL
 YoursMine (June)Δ
One Off$109,697.89$95,928.59$-13,769.30
Scheduled$34,281.35$43,015.60+$8,734.25
Recurring$38,695.36$39,387.49+$692.13
Team Total$182,674.60$178,331.68$-4,342.92
Team Collections is close — totals within ~$4.3k (yours $182,674.60 vs mine $178,331.68). Mine is a fresh pull today, net of refunds/chargebacks that landed after month-end, so it reads slightly lower than an earlier snapshot. The mix shifted a little (your One Off higher, Scheduled lower) — likely a different as-of date. Give me the date you captured your card and I'll match it exactly.
Generated for June 2026 reconciliation · sale price = CRM Package Price · collected = up-front deposit cash · team collections = Square, net of refunds.