Spreadsheet: 754378d1636129219-transfer-specific-information-from-several-files-to-one-november-2021-sample
Sheet: Sheet1

[NAME] | 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 | 1240 | 29.88772499999982 |  |  |  |  |  | 2019-05-17 00:00:00 | 2022-04-30 00:00:00 | 1800
A2 | 1245 | 5.124981750324878 | 0 |  |  |  |  | 2019-05-06 00:00:00 | 2022-04-30 00:00:00 | 3000
A3 | 1110 | 3367.408699604649 |  |  |  |  |  | 2019-05-06 00:00:00 | MONTH TO MONTH | 1455
A4 | 1010 | 0 |  |  |  |  |  | 2019-05-15 00:00:00 | 2022-04-30 00:00:00 | 970
A5 | 1150 | -72.49549999999999 |  |  |  |  |  | 2018-01-25 00:00:00 | 2021-12-31 00:00:00 | 1612.5
A6 | 1265 | 9423.703125 |  |  |  |  |  | 2016-03-01 00:00:00 | MONTH TO MONTH | 2200
A7 | 1010 | 0 |  |  | 1010 |  | 2021-11-03 00:00:00 | 2019-08-26 00:00:00 | 2022-07-31 00:00:00 | 1940
A8 | 1005 | -40 |  |  | 1005 |  | 2021-11-03 00:00:00 | 2018-03-14 00:00:00 | 2022-02-28 00:00:00 | 950
A9 | 750 | 0 |  |  |  |  |  | 2019-05-07 00:00:00 | 2022-04-30 00:00:00 | 725
A10 | 1010 | -24.07500000000005 |  |  | 1010 |  | 2021-11-03 00:00:00 | 2019-05-10 00:00:00 | 2022-04-30 00:00:00 | 1455
A11 | 1010 | -79.99624999999992 |  |  |  |  |  | 2019-05-10 00:00:00 | 2022-04-30 00:00:00 | 900
A12 | 800 | 0 |  |  |  |  |  | 2019-05-17 00:00:00 | 2021-04-30 00:00:00 | 0
A13 | 755 | 765 |  |  |  |  |  | 2019-06-03 00:00:00 | 2022-05-31 00:00:00 | 2175
A14 | 1010 | 0 |  |  | 1010 |  | 2021-11-01 00:00:00 | 2019-06-01 00:00:00 | 2022-05-31 00:00:00 | 2910
A15 | 995 | 47.25 |  |  |  |  |  | 2019-07-01 00:00:00 | 2022-06-30 00:00:00 | 1830
A16 | 1010 | -260 |  |  |  |  |  | 2019-05-01 00:00:00 | 2022-04-30 00:00:00 | 2425
A17 | 1100 | 0 |  |  |  |  |  | 2020-07-15 00:00:00 | 2022-08-31 00:00:00 | 1075
A18 | 1080 | 0 |  |  | 1080 |  | 2021-11-03 00:00:00 | 2019-08-16 00:00:00 | 2022-07-31 00:00:00 | 1040
A19 | 960 | 550.3744228821988 |  |  |  |  |  | 2014-08-01 00:00:00 | 2022-07-31 00:00:00 | 1720
A20 | 970 | 1055.49671875 |  |  |  |  |  | 2007-06-15 00:00:00 | 2022-05-31 00:00:00 | 1700
A21 | 1120 | -100 |  |  | 1020 |  | 2021-11-01 00:00:00 | 2021-10-01 00:00:00 | 2022-09-30 00:00:00 | 1120
A22 | 1180 | 170.0999999999999 |  |  |  |  |  | 2019-04-24 00:00:00 | MONTH TO MONTH | 2080
A23 | 1110 | -3850 |  |  |  |  |  | 2018-11-08 00:00:00 | MONTH TO MONTH | 1425
A24 | 960 | 10 |  |  |  |  |  | 2009-11-17 00:00:00 | 2022-10-31 00:00:00 | 1720
A25 | 1190 | 1209.499409375 |  |  |  |  |  | 2014-02-20 00:00:00 | 2022-05-31 00:00:00 | 1612.5
A26 | 1185 | -60 |  |  | 1185 |  | 2021-11-02 00:00:00 | 2013-03-22 00:00:00 | 2022-04-30 00:00:00 | 1612.5
A27 | 995 | -20 |  |  | 995 |  | 2021-11-04 00:00:00 | 2017-11-03 00:00:00 | 2022-10-31 00:00:00 | 1372.5
A28 | 970 | -60 |  |  |  |  |  | 2017-06-02 00:00:00 | 2022-05-31 00:00:00 | 1790
A29 | 1260 | 0 |  |  |  |  |  | 2019-11-06 00:00:00 | 2022-10-31 00:00:00 | 1220
A30 | 1185 | 0 |  |  |  |  |  | 2007-05-05 00:00:00 | 2022-04-30 00:00:00 | 1025
A31 | 1010 | 163.8 |  |  |  |  |  | 2019-07-01 00:00:00 | 2022-06-30 00:00:00 | 1940
A32 | 985 | 0 |  |  | 985 |  | 2021-11-01 00:00:00 | 2017-10-01 00:00:00 | 2022-09-30 00:00:00 | 1372.5