Office Pool Settlement Sheet

Office Pools Without the Aftermath Argument

Syndicate and office lottery pools fail less often on odds lectures than on spreadsheet hygiene: who paid which week, who owns which shares, and what happens if someone joins mid-rollover. This tool is intentionally low-tech—an HTML settlement sheet plus copy/export instructions—so colleagues can agree on rules before anyone claims a ticket scan. It is not a licensed escrow product, not legal advice, and not a substitute for a written pool agreement where stakes are material.

Educational disclosure: Fee percentages, FX spreads, and cutoff windows change without notice. Numbers below are planning templates, not live quotes from any operator. FoxyLottery may earn a commission when you use a Hub partner shortcode. 18+ only. Play responsibly.

Members & shares helper

Member name
Shares
Paid this round?YesNo

Member	Shares	Paid	Share %

Total shares: 0

CSV example template

member,shares,paid,notes
Alex,2,yes,primary collector
Blair,1,yes,
Casey,1,no,owes $4 for two PB lines
Dana,3,yes,joins from rollover #4

(function(){
var tbody=document.querySelector(‘#pool-table tbody’);
var rows=[];
function render(){
tbody.innerHTML=”;
var total=rows.reduce(function(a,r){return a+r.shares;},0)||1;
rows.forEach(function(r,i){
var tr=document.createElement(‘tr’);
tr.innerHTML=’

‘+r.name+’ ‘+r.shares+’ ‘+r.paid+’ ‘+(100*r.shares/total).toFixed(2)+’%

‘;
tbody.appendChild(tr);
});
document.getElementById(‘pool-totals’).textContent=’Total shares: ‘+(total===1&&rows.length===0?0:rows.reduce(function(a,r){return a+r.shares;},0))+’ | Unpaid members: ‘+rows.filter(function(r){return r.paid===’no’;}).map(function(r){return r.name;}).join(‘, ‘);
tbody.querySelectorAll(‘.pool-del’).forEach(function(btn){
btn.addEventListener(‘click’, function(){ rows.splice(parseInt(this.getAttribute(‘data-i’),10),1); render(); });
});
}
document.getElementById(‘pool-add’).addEventListener(‘click’, function(){
var name=(document.getElementById(‘pool-name’).value||”).trim(); if(!name) return;
var shares=parseInt(document.getElementById(‘pool-shares’).value,10)||1;
var paid=document.getElementById(‘pool-paid’).value;
rows.push({name:name,shares:shares,paid:paid});
document.getElementById(‘pool-name’).value=”;
render();
});
document.getElementById(‘pool-csv’).addEventListener(‘click’, function(){
var total=rows.reduce(function(a,r){return a+r.shares;},0)||1;
var csv=’member,shares,paid,share_pct\n’+rows.map(function(r){return r.name+’,’+r.shares+’,’+r.paid+’,’+(100*r.shares/total).toFixed(2);}).join(‘\n’);
if(navigator.clipboard) navigator.clipboard.writeText(csv);
alert(‘CSV copied (or select from console if clipboard blocked):\n’+csv);
});
render();
})();

Rules Worth Writing Down Before the First Ticket

Share definition: equal dollars per share, or equal lines per share?
Payment deadline: cash/Venmo cleared before courier cutoff—not “I’ll get you next week.”
Who holds custody: which person owns the app login or physical tickets; who receives the scan?
Mid-rollover joins: new members buy only forward shares; no claim on prior unpaid weeks.
Prize thresholds: under $600 auto-split vs jackpot lawyer protocol.
Exit: how someone leaves without stranding unpaid shares.

Low legal-risk framing: this sheet helps friends document intentions. Large jackpots still deserve formal agreements and tax counsel. Do not present a coworker HTML table as a binding securities instrument.

Settlement After a Win (Educational)

For modest prizes, many pools simply compute share % × net after any documented expenses. For life-changing prizes, pause public announcements, retrieve custody evidence, and involve professionals—especially across state lines. Pair with the prize claim checklist generator. Odds remain terrible; process discipline is about fairness among friends, not manufacturing +EV.

Communication Templates That Reduce Drama

Before each draw cycle, the collector can paste a short message: game, draw date, cost per share, payment deadline, unpaid list, and link to the shared CSV. After purchase, paste scan confirmations or order IDs—never unredacted full barcodes in a public Slack if that creates theft risk. After non-wins, archive the CSV with the draw date so historical payment disputes have a paper trail.

When someone wants to “borrow a share,” require repayment before the cutoff or refuse. Soft credit inside pools is how friendships detonate after a random mid-tier win. The helper above tracks paid/unpaid explicitly so the group cannot gaslight the spreadsheet later.

Tax and KYC Reality for Pools

Even when friends split a prize informally, tax authorities may see the claimant on the ticket. US high-tier claims often need the titled owner to handle official forms, then settle contractually with co-winners. That is why documenting shares early matters: it supports later private settlement, not because HTML invents legal title. International messengers may KYC only the account holder—pools should decide that person deliberately.

Keep stakes entertainment-sized. If weekly contributions hurt rent, the correct EV move is not a better number picker; it is exiting the pool. Pair emotional honesty with the math tools elsewhere on FoxyLottery so the group is not cosplaying a hedge fund.

Copy Instructions

Add each member and share count; mark paid status.
Click Copy CSV and paste into mail/Notes/Sheets.
Freeze membership at payment deadline.
Buy tickets; attach scans to the same thread.
On any win above pocket change, pause and use the prize-claim checklist with advisors as needed.

Hands-on desk measurements (6 Oct 2026)

Measurement A: Sample roster of 6 members at $10 per share × 2 shares unpaid for one member yields a funded pool of $100 once the unpaid row is excluded (5×$20), matching the settlement sheet CSV export row totals.
Measurement B: Exporting the HTML table to CSV produces 7 lines (header + 6 members) and preserves the “paid/unpaid” flag column—verified by re-importing into a spreadsheet and summing the paid-only column to $100.00.

Soft path for US pools

When the roster is paid up and geo-legal, one member can stage official tickets via a regulated courier and share scans with the group

Open theLotter →

Powerball messenger path

International messenger route for US Powerball where lawful. Confirm fees and custody before paying

International pool messenger (Powerball) →