Cash vs Card Tip Reconciler: Pay Card Tips Right, Declare Cash Clean

The problem this kills

Closing out a shift turns into a tip-math puzzle every single night. The POS spits out card tips by employee, servers and bartenders hand over what they declare in cash, the tips-out to bussers and the bar shuffles money around, and the manager is left squaring it all on a paper sheet or a worn-out spreadsheet. Get it wrong and two things happen, both bad: somebody's card tips don't make it onto their paycheck, or somebody's cash tips get under-declared and the IRS comes calling at year-end.

The two buckets are completely different and people mix them up constantly. Card tips were captured by the POS and still owe the employee money — they flow out through payroll. Cash tips are already in the employee's pocket — no money moves, but they still have to be reported. Confuse the two and you either pay a tip twice or fail to report income. You don't need to live with the nightly guesswork, and you don't need to be a developer to fix it.

What you'll build

A simple internal web tool for closing out a shift. You import the POS card-tip totals per employee (a CSV), enter each person's declared cash tips and any tips-out adjustments, and the tool reconciles every employee in seconds: how much is owed via payroll (their card tips, net of tips-out), versus how much they already took home in cash (declared, to be reported). It checks the math, flags anyone whose declared cash falls below a sensible expected floor (a classic under-declaration red flag), and surfaces mismatches before they bite you. The manager reviews each employee's reconciliation on one screen, fixes anything off, and clicks Approve to close the shift. Only then does the tool export a payroll tip CSV — card tips to pay out, plus total tips to report per employee — in the exact columns your payroll system expects.

What's inside the Implementation Plan

The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — which POS you export card tips from, exactly what your CSV columns are named, how your tips-out and tip-pool rules work, what counts as a reasonable cash-declaration floor for your room, your typical and peak shift sizes, and your messy edge cases — and then it tailors the data model, the reconciliation math, and every later step to your answers. This is not a generic template; the agent reflects a short spec back to you and waits for your thumbs-up before it builds anything. From there it walks the agent through the card-tip import, the cash-declaration entry, the per-employee reconciliation and under-declaration flags, the manager review-and-approve close, and the payroll CSV export — each step with a ready-to-copy prompt. There's also a fallback so you can build the whole thing today even with no API into your POS or payroll system.

The governance it includes (this is the point)

This is real payroll money and real tax reporting, so it ships with the controls a serious operation needs: login so only your managers and bookkeepers can use it, row-level security so each location only ever sees its own shifts and employees, a complete audit trail of who entered, reviewed, and approved each shift close and when, a hard manager-approval gate so no payroll figure is exported until a person signs off, and duplicate guards keyed on employee + shift so the same close can't be processed twice. Under-declared cash is flagged for a conversation now, not a surprise at tax time.

Who it's for

Restaurant and bar managers, GMs, and the bookkeepers who close out shifts and run tip payroll — anyone who needs card tips paid correctly and cash tips properly declared without rebuilding the same fragile spreadsheet every night. If you can describe how your room handles tips-out and declarations, you can build this.

You've got this — start with the plan, paste the first prompt, answer the interview, and you'll watch your first shift reconcile cleanly the same afternoon.