Spreadsheet: 727639d1617989608-summarizing-expenses-by-committee-data-sample
Sheet: Desired Output

Column from raw data worksheet: |  |  | (Column AB) | (Column AC) | (Column AD) | (Column AE) | (Column AF) | (Column AJ) | (Column AM)
 |  |  | Gate Contract | Security Patrols | Decals | Telephone | Security Cameras | R&M -  Guard House | R&M - Gates
Date | Payee | Invoice | 8012-000 | 8012-001 | 8013-001 | 8013-003 | 8013-004 | 8110-002 | 8110-011
 | Work Orders | 7 | 0 | 0 | 0 | 0 | 0 | 75 | 0
2021-01-01 00:00:00 | Good Enough Electronics | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 327
2021-01-02 00:00:00 | Water Service | 11 | 0 | 0 | 0 | 0 | 0 | 53.6 | 0
2021-01-01 00:00:00 | Cleaning & Supply | 12 | 0 | 0 | 0 | 0 | 0 | 160.01 | 0
2021-01-06 00:00:00 | Good Enough Electronics | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 352.5
2021-01-11 00:00:00 | Pest Elimination | 19 | 0 | 0 | 0 | 0 | 0 | 60 | 0
2021-01-11 00:00:00 | Phones | 20 | 0 | 0 | 0 | 926.82 | 0 | 0 | 0
2021-01-13 00:00:00 | Good Enough Electronics | 22 | 0 | 0 | 0 | 0 | 0 | 0 | 1992.63
2021-01-14 00:00:00 | Good Enough Electronics | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 154
2021-01-22 00:00:00 | Good Enough Electronics | 39 | 0 | 0 | 0 | 0 | 0 | 0 | 187
2021-01-22 00:00:00 | Good Enough Electronics | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 136.25
2021-01-22 00:00:00 | Good Enough Electronics | 42 | 0 | 0 | 0 | 0 | 0 | 0 | 293.07
2021-01-26 00:00:00 | ABC Electronics Inc | 47 | 0 | 0 | 0 | 0 | 0 | 276 | 0
2021-01-26 00:00:00 | Recovery Services | 48 | 0 | 0 | 0 | 0 | 0 | 200 | 0
2021-01-27 00:00:00 | Good Enough Electronics | 54 | 0 | 0 | 2450.3 | 0 | 0 | 0 | 0
2021-01-28 00:00:00 | Good Enough Electronics | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 264
2020-12-30 00:00:00 | Good Enough Electronics | 56 | 0 | 0 | 0 | 0 | 0 | 0 | 81
2021-01-28 00:00:00 | Allied | 57 | 25000 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-31 00:00:00 | Water Service | 59 | 0 | 0 | 0 | 0 | 0 | 0.66 | 0
2020-12-30 00:00:00 | Fences Inc | 70 | 0 | 0 | 0 | 0 | 0 | 2651.98 | 0
2021-02-01 00:00:00 | Good Enough Electronics | 73 | 0 | 0 | 0 | 0 | 49.95 | 0 | 0
2021-02-02 00:00:00 | Allied | 78 | 500 | 0 | 0 | 0 | 0 | 0 | 0
2021-02-04 00:00:00 | Good Enough Electronics | 80 | 0 | 0 | 0 | 0 | 0 | 0 | 250.47
2021-02-08 00:00:00 | Security Patrols | 81 | 0 | 1980 | 0 | 0 | 0 | 0 | 0
2021-02-08 00:00:00 | Credit card | 82 | 0 | 0 | 0 | 0 | 0 | 30.16 | 0
2021-02-10 00:00:00 | Good Enough Electronics | 86 | 0 | 0 | 0 | 0 | 0 | 0 | 375.85
2021-02-10 00:00:00 | Security Systems | 87 | 0 | 0 | 0 | 0 | 1909.6 | 0 | 0
2021-02-11 00:00:00 | A/C Contractor | 89 | 0 | 0 | 0 | 0 | 0 | 129 | 0
2021-02-11 00:00:00 | Phones | 90 | 0 | 0 | 0 | 926.82 | 0 | 0 | 0
2021-02-12 00:00:00 | Good Enough Electronics | 92 | 0 | 0 | 0 | 0 | 0 | 0 | 138.6
2021-02-12 00:00:00 | PCLTD - refund | 93 | 0 | -165 | 0 | 0 | 0 | 0 | 0
2021-02-16 00:00:00 | Cleaning & Supply | 99 | 0 | 0 | 0 | 0 | 0 | 102.7 | 0
2021-02-16 00:00:00 | Pest Elimination | 100 | 0 | 0 | 0 | 0 | 0 | 60 | 0
2021-02-17 00:00:00 | Cleaning & Supply | 102 | 0 | 0 | 0 | 0 | 0 | 29.96 | 0
2021-02-22 00:00:00 | Water Service | 106 | 0 | 0 | 0 | 0 | 0 | 60.05 | 0
2021-02-23 00:00:00 | Good Enough Electronics | 107 | 0 | 0 | 0 | 0 | 0 | 0 | 196.2
2021-02-25 00:00:00 | Fire Master Chief | 118 | 0 | 0 | 0 | 0 | 0 | 53.5 | 0
2021-02-25 00:00:00 | Allied | 119 | 20000 | 0 | 0 | 0 | 0 | 0 | 0
2021-02-25 00:00:00 | Allied | 120 | 600 | 0 | 0 | 0 | 0 | 0 | 0
2021-03-01 00:00:00 | Good Enough Electronics | 127 | 0 | 0 | 0 | 0 | 49.95 | 0 | 0
2021-03-02 00:00:00 | ABC Electronics Inc | 138 | 0 | 0 | 0 | 0 | 0 | 190 | 0
2021-03-04 00:00:00 | PCLTD | 139 | 0 | 1980 | 0 | 0 | 0 | 0 | 0
2021-03-11 00:00:00 | Phones | 145 | 0 | 0 | 0 | 926.82 | 0 | 0 | 0
2021-03-19 00:00:00 | Doors Inc | 152 | 0 | 0 | 0 | 21.99 | 0 | 0 | 0
2021-03-22 00:00:00 | Water Service | 158 | 0 | 0 | 0 | 0 | 0 | 53.6 | 0
2021-03-23 00:00:00 | Pest Elimination | 159 | 0 | 0 | 0 | 0 | 0 | 60 | 0
2021-03-25 00:00:00 | Allied | 160 | 20000 | 0 | 0 | 0 | 0 | 0 | 0
2021-03-25 00:00:00 | Allied | 161 | 800 | 0 | 0 | 0 | 0 | 0 | 0
2021-03-25 00:00:00 | Good Enough Electronics | 163 | 0 | 0 | 0 | 0 | 0 | 0 | 273.08
2021-03-31 00:00:00 | Water Service | 181 | 0 | 0 | 0 | 0 | 0 | 44.08 | 0
2021-04-01 00:00:00 | Cleaning Services, Inc | 184 | 0 | 0 | 0 | 0 | 0 | 150 | 0
2021-04-01 00:00:00 | Good Enough Electronics | 185 | 0 | 0 | 0 | 0 | 49.95 | 0 | 0
2021-04-06 00:00:00 | Security Patrols | 188 | 0 | 1980 | 0 | 0 | 0 | 0 | 0