According to this table, it becomes possible to plan the company’s payments for any period and monitor the actual execution of the plan. The system of automatic marking paid and overdue payments is provided in the file.
Note!
Pay attention that this file was made in Excel 2016. It means that in older versions of this program some of the conditional formatting functions may not work and the rows in the table on your computer may not be colored, as described in the article.