Rent Tracker Excel Sheet

Well, here is a starter:

in A1, enter DATE
In B1, Buck
In C1, Carl
In D1, Dan
In E1, Ellis
In F1, Frank
In G1, Extra (or Bills, or whatever)

The first day of the preset fortnight is entered in A2.

Then, since the renters "never pay on the same date", we will allow six empty rows for up to six different dates, one for each renter. This will be rows 3 through 8.

Row 9 will be used for totals on the last day of the fortnight, so, in cell A9, enter the ending date for the prsent fortnight, and, in cell B9, enter =SUM(B2:B8), and copy it to cells C9:F9.

Row 10 will be used to catch delinquencies, so, in cell A10, enter "In
Arrears", and, in B10, enter =IF(B9<80,80-B9,""), and copy it across C10:F10. In cell G10, enter, =IF(G10=260,"",260-G9)

The above will take care of the renters, and show who owes at the end of the fortnight, and, how much.

does this fulfill your need? Let us know.

Well, here is a starter:

in A1, enter DATE
In B1, Buck
In C1, Carl
In D1, Dan
In E1, Ellis
In F1, Frank
In G1, Extra (or Bills, or whatever)

The first day of the preset fortnight is entered in A2.

Then, since the renters "never pay on the same date", we will allow six empty rows for up to six different dates, one for each renter. This will be rows 3 through 8.

Row 9 will be used for totals on the last day of the fortnight, so, in cell A9, enter the ending date for the prsent fortnight, and, in cell B9, enter =SUM(B2:B8), and copy it to cells C9:F9.

Row 10 will be used to catch delinquencies, so, in cell A10, enter "In
Arrears", and, in B10, enter =IF(B9<80,80-B9,""), and copy it across C10:F10.

The above will take care of the renters, and show who owes at the end of the fortnight, and, how much.

Does this fulfill your need? Let us know.