cash collection prognoses

Ask a Question

Hi all,

I need to create an overview in which:

1. all payments received in the reporting month are listed in one column

2. expected future payments in monthly columns

Invoicenumber	paid 2018-01 (reporting month)	2018-02	2018-03	etc	etc

Please see attached file

The reasoning is to allocate a (future) payment to a column by defining an additional date. The logic could be something like

IF(Pay_date<>0 than Pay_date = Payment_Date,

Elseif(Rep_Date>Due_date than Rep_Date+45= Payment_date ;

Else (Due_date+15= Payment_date)

How should I do this?

0 Replies