Entering data in sheet Data page 36

Entering Data In The DEBT AGE GROUP Column (Column P)

In the DEBT AGE GROUP column, cell P5 should already contain the following formula

=IF(N5="open",IF(O5<30,"0-30",IF(O5<60,"30-60",IF(O5<90,"60-90",IF(O5<120,"90-120",">120"))))),"NR")

Just copy the formula to the cells below.

Entering Data In The CREDITOR STTMNT Column (Column Q)

In the CREDITOR STTMNT column, put a mark to indicate whether our suppliers invoice has been paid. Use pd to mark the paid invoice. Use open to mark invoice still unpaid. If the source is not related to our suppliers invoice (and not subject to our monitoring of payment), mark NR (for Not Relevant) or leave blank.

This column will help us locate unpaid suppliers invoices.

Entering Data In The CREDIT AGE Column (Column R)

In the CREDIT AGE (days) column, cell R5 should already contain the following formula:

=IF(Q5="open", CutOffDate-B5, "NR")

Just copy the formula to the cells below.

Entering Data In The CREDIT AGE GROUP Column (Column S)

In the CREDIT AGE GROUP column, a cell S5 should already contain the following formula:

=IF(Q5="open",IF(R5<30,"0-30",IF(R5<60,"30-60",IF(R5<90,"60-90",IF(R5<120,"90-120",">120"))))),"NR")

Just copy the formula to the cells below it.

36