In the DEBTOR STTMNT column, put a mark to indicate whether our sales 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 sales invoice (and not subject to our monitoring of payment), mark NR (for Not Relevant).
This column is useful to find out paid and unpaid invoices by our customers.
Entering Data In The DEBT AGE Column (Column P)
In the DEBT AGE (days) column, cell 05 should already contain the following formula:
=IF (NS="open", CutOffDate-85,"NR")
Just copy the formula to the cells below it.
Please refer to the note on page 11 on how to set the 'Cut OFF Date'.
Entering Data In The DEBT AGE GROUP Column (Column Q)
In the DEBT AGE GROUP column, cell V2 should already contain the following formula
=IF(O2="open",IF(P2<30,"0-30",IF(P2<60,"30-60",IF(P2<90,"60-90",IF(P2<120,"90-120",">120"))))),"NR")
Just copy the formula to the cells below.
Entering Data In The CREDITOR STTMNT Column (Column W)
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 X)
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
No comments:
Post a Comment