Oct 02 2021 06:38 AM
Oct 02 2021 06:41 AM
Oct 02 2021 06:44 AM
Oct 02 2021 06:46 AM
Oct 02 2021 09:55 PM
@Thomas610 I believe your need is to match e.g. individual vendor invoice amounts (credits) with individual payments made (debits) to these individual vendor invoices. The attached workbook contains an example for such a situation. It's inspired by this (rather old) article, but it still does the job:
https://www.myonlinetraininghub.com/excel-bank-reconciliation-formula
I have adapted it a little so that it matches amounts by vendor.