MS Excel with columns ad rows and creating simple formula.
JMJ Properties
JMJ Apartments
RENT RCORDS
Unit Size
Price
Unit #
Tenant Name
Rent
Amt. Pd.
Date Pd.
Amt. Due
Lease Expires
Deposit
JMJ
Studio
1 BR
1 BR
1 BR
1 BR
1 BR
1 BR
Studio
Studio
Studio
1 BR
1 BR
1 BR
1 BR
2 BR
2 BR
2 BR
2 BR
2 BR
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
-
TOTAL:
-
ABC
XYZ
DD
MJM
MMD
JJDM
JID
ELM
LVM
JPP
MPP
JDM
LPM
JCSM
MASM
MMS
LMN
MAYDM
JEW
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
-
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
-
-
$
11,600.00 $
2,000.00
07/01/15
11/09/15
07/01/15
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
-
-
$
1,400.00
May 3, 2018
August 31, 2018
July 31, 2018
May 23, 2020
February 24, 2019
April 30, 2018
September 30, 2018
February 28, 2018
June 30, 2018
December 1, 2018
November 30, 2017
July 31, 2018
August 31, 2017
December 31, 2017
June 30, 2018
May 31, 2018
March 4, 2020
June 21, 2019
August 5, 2018
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
-
$
6,700.00