Spreadsheet: 687078d1594944532-create-dynamic-list-with-blank-rows-in-the-data-test-data-lewis-clark-
Sheet: Owner Accounts

[NAME]:
Operating (average) | 100 | Charges |  | Annual Maint Fee
Refuse | 150 | By |  | Refuse
Additional Fee | 300 | Category: |  | Additional Fee
GCA | 250 |  |  | GCA
Rsrv-Paving | 80 |  |  | Rsrv-Paving
Rsrv-Streets/Walks | 40 |  |  | Rsrv-Streets/Walks
Rsrv-Contingency | 50 |  |  | Rsrv-Contingency
BOY Date: | 2020-01-01 00:00:00 |  |  | Totals:
 |  |  |  |  |  |  |  |  |  | Late Stmt | 45DPL | [NAME] | F'close | Pmt Plan | On Time | Paid Off
Owner | Address | Lot # | Date | Code | Begin Balance | Charges This Yr | Payments | Adjustments | End Balance
1001 |  | 1 |  |  | 0 | 102.46 |  |  |  | Yes |  |  |  | Yes | No
AA
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
 |  |  | 2020-01-03 00:00:00 | Payment |  |  | 100
 |  |  | 2020-02-05 00:00:00 | Payment |  |  | 100
 |  |  | 2020-02-16 00:00:00 | Interest |  | 10.28
 |  |  | 2020-02-16 00:00:00 | Interest Reversal |  |  |  | -10.28
 |  |  | 2020-03-06 00:00:00 | Payment |  |  | 100
 |  |  | 2020-03-19 00:00:00 | Interest |  | 6.35
 |  |  | 2020-05-31 00:00:00 | Late Fee |  | 25
 |  |  | 2020-06-30 00:00:00 | Interest |  | 20.51
1002 |  | 2 |  |  | 0 | 97.54 | 0 |  |  |  |  |  |  |  |  | Yes
BB
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
 |  |  | 2020-01-03 00:00:00 | Payment |  |  | 967.54
1003 |  | 3 |  |  | 0 | 87.19
CC
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
 |  |  | 2020-01-31 00:00:00 | Payment |  |  | 957.19
1004 |  | 4 |  |  | 0 | 92.57
DD
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
 |  |  | 2020-02-16 00:00:00 | Interest |  | 12.42
 |  |  | 2020-02-24 00:00:00 | Payment |  |  | 974.99
1005 |  | 5 |  |  | 0 | 80.89 |  |  |  | Yes |  |  |  |  |  | Yes
EE
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
 |  |  | 2020-01-03 00:00:00 | Payment |  |  | 500
1006 |  | 6 |  |  | 0 | 89.05 |  |  |  | Yes |  |  |  |  |  | Yes
FF
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
 |  |  | 2020-01-29 00:00:00 | Payment |  |  | 800
1007 |  | 7 |  |  | 0 | 90.37
GG
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
 |  |  | 2020-01-07 00:00:00 | PayLease |  |  | 960.37
1008 |  | 8 |  |  | 0 | 124 |  |  |  |  |  |  |  | Yes | No
HH
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
 |  |  | 2020-01-28 00:00:00 | Payment |  |  | 282.55
 |  |  | 2020-02-16 00:00:00 | Interest |  | 9.6
 |  |  | 2020-03-19 00:00:00 | Interest |  | 6.67
 |  |  | 2020-05-28 00:00:00 | Payment |  |  | 282.55
 |  |  | 2020-06-30 00:00:00 | Interest Reversal |  |  |  | -9.6
 |  |  | 2020-06-30 00:00:00 | Interest Reversal |  |  |  | -14.63
 |  |  | 2020-06-30 00:00:00 | Interest |  | 14.63
1009 |  | 9 |  |  | -972.93 | 102.93
II
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
1010 |  | 10 | 2020-01-01 00:00:00 |  | -1118.76 | 112.58
JJ |  |  | 2020-01-01 00:00:00 |  |  | 199.19
 |  |  | 2020-01-01 00:00:00 |  |  | 269.64
 |  |  | 2020-01-01 00:00:00 |  |  | 394.3
 |  |  | 2020-01-01 00:00:00 |  |  | 63.68
 |  |  | 2020-01-01 00:00:00 |  |  | 31.24
 |  |  | 2020-01-01 00:00:00 |  |  | 48.13
1011 |  | 11 |  |  | 0 | 112.58 |  |  |  |  |  | Yes
KK
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
 |  |  | 2020-02-11 00:00:00 | Payment |  |  | 200
1012 |  | 12 |  |  | 0 | 79.44
LL
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
 |  |  | 2020-01-09 00:00:00 | Payment |  |  | 949.44
1013 |  | 13 |  |  | -600 | 75.44 |  |  |  | Yes | Yes | Yes
MM
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
1014 |  | 14 |  |  | -955.56 | 85.56 |  |  |  |  |  |  |  | Yes | Yes
NN
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
1015 |  | 15 |  |  | 0 | 73.62 |  |  |  | Yes | Yes | Yes
OO
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
 |  |  | 2020-01-07 00:00:00 | Payment |  |  | 400
1016 |  | 16 |  |  | 0 | 76.79 |  |  |  | Yes | Yes | Yes
PP
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
1017 |  | 17 |  |  | -952.14 | 82.14
QQ
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
1018 |  | 18 |  |  | -800 | 73.62 |  |  |  | Yes | Yes
RR
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
1019 |  | 19 |  |  | -943.62 | 73.62
SS
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
1020 |  | 20 |  |  |  | 73.62 |  |  |  | Yes | Yes | Yes
TT
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
1021 |  | 21 |  |  | -962.18 | 92.18
UU
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
1022 |  | 22 |  |  | 0 | 77.96 |  |  |  |  |  |  |  | Yes | No
VV
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
 |  |  | 2020-02-11 00:00:00 | Payment |  |  | 300
1023 |  | 23 |  |  | 0 | 77.15
WW
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
 |  |  | 2020-02-05 00:00:00 | Payment |  |  | 947.15
1024 |  | 24 |  |  | 0 | 79.43
XX
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
 |  |  | 2020-02-05 00:00:00 | Payment |  |  | 949.43
1025 |  | 25 |  |  | 0 | 93.4 |  |  |  | Yes | Yes
YY
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
 |  |  | 2020-02-03 00:00:00 | Payment |  |  | 600
1026 |  | 26 |  |  | 0 | 87.83 |  |  |  | Yes | Yes | Yes
ZZ
 |  |  | 2010-01-01 00:00:00
 |  |  | 2010-01-01 00:00:00
 |  |  | 2020-01-03 00:00:00 | Payment |  |  | 400