Showing Posts From
Lists & Spreadsheets

Paid, Unpaid, or Wrong Amount? Match Bank Deposits to Prepaid Orders in One Pass
Don't tick off 20 prepaid orders against 19 bank deposits one by one — a payment under a family member's name and one short payment will slip past you. Load the order list and the deposit history together and the matches come back already split — matched, unpaid, amount mismatch, and cannot confirm…

48 People Registered, 44 Paid — Stop Comparing Two Lists by Eye
Don't draw lines between two printed lists by eye — with 48 names on one side and 44 on the other, someone always gets skipped. Paste the full roster as List A and the paid list as List B, pick the phone's last four digits as the extra identifier, and the result splits into matched, missing, and ne…