Showing Posts From

Lists & Spreadsheets

Paid, Unpaid, or Wrong Amount? Match Bank Deposits to Prepaid Orders in One Pass

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

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…