Spreadsheet: 754374d1636129201-transfer-specific-information-from-several-files-to-one-september-2021-sample
Sheet: Sheet1

[NAME] | Type | Rent | Past due from | Late Fee $10 | Total Due | AMT PAID | BALANCE | DATE PAID | LEASE START | LEASE END | SECURITY
 |  |  | previous mth. | for the ist $1000 |  |  |  |  |  |  | DEPOSIT
 |  |  |  | 5% on the rest
A1 | 3BR | 1240 | -60.51000000000022 | 8.97449999999999 |  | 1000 |  | 2021-09-07 00:00:00 | 2019-05-17 00:00:00 | 2022-04-30 00:00:00 | 1800
A2 | 3BR | 1245 | -5.119064999690636 | 0 |  | 1240 |  | 2021-09-07 00:00:00 | 2019-05-06 00:00:00 | 2022-04-30 00:00:00 | 3000
A3 | 2BR | 1110 | 1116.408699604649 | 15.5 |  |  |  |  | 2019-05-06 00:00:00 | MONTH TO MONTH | 1455
A4 | 2BR | 1010 | 0 | 0 |  | 1010 |  | 2021-09-07 00:00:00 | 2019-05-15 00:00:00 | 2022-04-30 00:00:00 | 970
A5 | 3BR | 1150 | -85.71000000000004 | 0 |  | 1150 |  | 2021-09-07 00:00:00 | 2018-01-25 00:00:00 | 2021-12-31 00:00:00 | 1612.5
A6 | 3BR | 1265 | 6847.203125 | 23.25 |  |  |  |  | 2016-03-01 00:00:00 | MONTH TO MONTH | 2200
A7 | 2BR | 1010 | 0 | 0 |  | 1010 |  | 2021-09-07 00:00:00 | 2019-08-26 00:00:00 | 2022-07-31 00:00:00 | 1940
A8 | 2BR | 1005 | -40 | 0 |  | 1005 |  | 2021-09-02 00:00:00 | 2018-03-14 00:00:00 | 2022-02-28 00:00:00 | 950
A9 | STUDIO | 750 | 0 | 0 |  | 750 |  | 2021-09-03 00:00:00 | 2019-05-07 00:00:00 | 2022-04-30 00:00:00 | 725
A10 | 2BR | 1010 | -24.07500000000005 | 0 |  | 2020 |  | 2021-09-07 00:00:00 | 2019-05-10 00:00:00 | 2022-04-30 00:00:00 | 1455
A11 | 2BR | 1010 | -99.99624999999992 | 0 |  | 1010 |  | 2021-09-03 00:00:00 | 2019-05-10 00:00:00 | 2022-04-30 00:00:00 | 900
A12 | 2BR | 800 | -800 | 0 |  |  |  |  | 2019-05-17 00:00:00 | 2021-04-30 00:00:00 | 0
A13 | STUDIO | 755 | 0 | 0 |  | 755 |  | 2021-09-07 00:00:00 | 2019-06-03 00:00:00 | 2022-05-31 00:00:00 | 2175
A14 | 2BR | 1010 | 0 | 0 |  | 1010 |  | 2021-09-01 00:00:00 | 2019-06-01 00:00:00 | 2022-05-31 00:00:00 | 2910
A15 | 2BR | 995 | 0 | 2.25 |  | 950 |  | 2021-09-04 00:00:00 | 2019-07-01 00:00:00 | 2022-06-30 00:00:00 | 1830
A16 | 2BR | 1010 | -180 | 0 |  | 1010 |  | 2021-09-07 00:00:00 | 2019-05-01 00:00:00 | 2022-04-30 00:00:00 | 2425
A17 | 2BR | 1200 | 0 | 20 |  | 1200 |  | 2021-09-08 00:00:00 | 2020-07-15 00:00:00 | MONTH TO MONTH | 1075
A18 | 2BR | 1080 | 0 | 1 |  | 1060 |  | 2021-09-01 00:00:00 | 2019-08-16 00:00:00 | 2022-07-31 00:00:00 | 1040
A19 | 2BR | 1060 | 530.3744228821988 | 10 |  | 960 |  | 2021-09-07 00:00:00 | 2014-08-01 00:00:00 | MONTH TO MONTH | 1720
A20 | 2BR | 970 | 895.4967187499998 | 10 |  | 900 |  | 2021-09-10 00:00:00 | 2007-06-15 00:00:00 | 2022-05-31 00:00:00 | 1700
A21 | 2BR | 0 | 0 | 0 |  |  |  |  |  |  | 0
A22 | 2BR | 1180 | -28 | 0 |  | 1170 |  | 2021-09-01 00:00:00 | 2019-04-24 00:00:00 | MONTH TO MONTH | 2080
A23 | 2BR | 990 | -5830 | 0 |  |  |  |  | 2018-11-08 00:00:00 | 2021-10-31 00:00:00 | 1425
A24 | 2BR | 940 | 310 | 0 |  | 940 |  | 2021-09-13 00:00:00 | 2009-11-17 00:00:00 | 2021-10-31 00:00:00 | 1720
A25 | 3BR | 1190 | -27.48624999999993 | 18.12568750000001 |  | 1180.64 |  | 2021-09-30 00:00:00 | 2014-02-20 00:00:00 | 2022-05-31 00:00:00 | 1612.5
A26 | 3BR | 1185 | -60 | 0 |  | 1185 |  | 2021-09-01 00:00:00 | 2013-03-22 00:00:00 | 2022-04-30 00:00:00 | 1612.5
A27 | 2BR | 975 | 0 | 0 |  | 975 |  | 2021-09-07 00:00:00 | 2017-11-03 00:00:00 | 2021-10-31 00:00:00 | 1372.5
A28 | 2BR | 970 | -40 | 0 |  | 990 |  | 2021-09-07 00:00:00 | 2017-06-02 00:00:00 | 2022-05-31 00:00:00 | 1790
A29 | 3BR | 1240 | 0 | 0 |  | 1240 |  | 2021-09-03 00:00:00 | 2019-11-06 00:00:00 | 2021-10-31 00:00:00 | 1220
A30 | 3BR | 1185 | -15 | 0 |  | 1170 |  | 2021-09-03 00:00:00 | 2007-05-05 00:00:00 | 2022-04-30 00:00:00 | 1025
A31 | 2BR | 1010 | 256 | 10 |  | 1030 |  | 2021-09-07 00:00:00 | 2019-07-01 00:00:00 | 2022-06-30 00:00:00 | 1940
A32 | 2BR | 965 | 0 | 0 |  | 965 |  | 2021-09-01 00:00:00 | 2017-10-01 00:00:00 | 2021-09-30 00:00:00 | 1372.5