Tracking Rent

An Excel file that teaches how to perform Tracking Rent operation.

Excel Professional Tracking Rent

Tenant information and period information are entered into the table. Collections and delays are tracked in separate columns. Increase rates are applied from the parameters. The warning area highlights delays with color. A cash flow summary is presented in the report.

Hope it is useful.