Late Payment analysis

[Hussein982]

Hi all:

I am trying to perform an late payment analysis over our invoice and payment file. The end goal is to find out if we were late in paying our vendors (results should be in number of days).

Within that table (see below), there are the following information: 

1- Vendor # and name 

2- Invoice terms 

3- Purchase orders terms 

4- Supplier terms 

5- Invoice date

6- Invoice amount

7- payment date  

8- payment amount 

I would like to see if we respected the 3 terms above (2,3,4) and if not then we have a delay in payment.

Appreciate any inputs in advance.

Vendor #	Vendor name	invoice terms	PO terms	Supplier terms	invoice date	Invoice amount	payment date	payment amount
1	A	Immediate	Net 28	Net 30	15-Sep-19	100	15-Nov-19	100
2	B	Immediate	Net 30	Net 30	15-Aug-19	200	14-Dec-19	200
3	C	Immediate	Net 28	Net 30	15-Jul-19	300	1-Dec-19	300
4	D	Immediate	Net 30	Net 30	15-Jun-19	400	16-Dec-19	400
5	E	Immediate	Net 28	Net 30	15-May-19	500	14-Oct-19	500

Cheers,

[ArtApa · Accepted solution]

Hi @Hussein982 - I've built a simple solution that creates 3 flags. Hope it will work for you.

[Hussein982]

Thank you so much. This is helpful.