Set-off Invoices against Payments

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 >>>

By: Arun Vikraman

Leave a Reply

Your email address will not be published. Required fields are marked *