Attached is a google sheet.
2 Sheets – Invoices, Payments
Invoices sheet updated with new data monthly
Payments sheet will be pasted with new data on daily basis.
Payments!Amount must set-off (clear off) the oldest Invoices!Amount for a particular account number.
Google Sheet attached >>> http://bit.ly/slrprep
By: Arun Vikraman