Payment reconciliation
Build a spreadsheet of fictional invoices and payments containing a short payment, an overpayment and missing remittance information. Reconcile what you can and explain how you would investigate each exception.
The Cash Applications Lead researches payment discrepancies and needs Excel skills to review and reconcile operational data.
Source posting