Spreadsheet: 819166d1677258892-sumifs-over-two-worksheets-bank-account-and-project-reports-workings
Sheet: Cashbook v2

Income and Spend - 2022-2023
Date | Notes | Value | Income or Spend? | Transaction Type | Invoice / Receipt | Project | Stmt. Value | Balance |  | Month
2022-04-07 00:00:00 | Balance Brought Forward |  |  |  |  |  |  | 10000
2022-07-01 00:00:00 | Spend | 8 | Spend | Spend - Travel | No | General
2022-07-01 00:00:00 | Spend | 19 | Spend | Spend - Classes | No | General
2022-07-04 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-07-04 00:00:00 | Spend | 6 | Spend | Spend - Classes | No | General
2022-07-05 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-07-05 00:00:00 | Spend | 5.2 | Spend | Spend - Travel | No | General
2022-07-05 00:00:00 | Spend | 6 | Spend | Spend - Classes | No | General
2022-07-06 00:00:00 | Spend | 7.2 | Spend | Spend - Travel | No | General
2022-07-06 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-07-07 00:00:00 | Spend | 5.8 | Spend | Spend - Travel | No | General
2022-07-08 00:00:00 | Spend | 6 | Spend | Spend - Classes | No | General
2022-07-08 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-07-09 00:00:00 | Spend | 5.8 | Spend | Spend - Travel | No | General
2022-07-09 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-07-10 00:00:00 | Spend | 6.2 | Spend | Spend - Travel | No | General
2022-07-10 00:00:00 | Spend | 6 | Spend | Spend - Classes | No | General
2022-07-10 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-07-11 00:00:00 | Spend | 43 | Spend | Spend - Classes | No | General
2022-07-11 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-07-12 00:00:00 | Spend | 6 | Spend | Spend - Classes | No | General
2022-07-12 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-07-13 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-07-17 00:00:00 | Spend | 16 | Spend | Spend - Classes | No | General
2022-07-21 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-07-21 00:00:00 | Spend | 2.6 | Spend | Spend - Travel | No | General
2022-07-21 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-07-22 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-07-23 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-07-23 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-07-24 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-07-25 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-07-26 00:00:00 | Spend | 18 | Spend | Spend - Travel | No | General
2022-07-26 00:00:00 | Spend | 10 | Spend | Spend - Classes | No | General
2022-07-26 00:00:00 | Spend | 5.8 | Spend | Spend - Travel | No | General
2022-07-27 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-07-28 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-07-28 00:00:00 | Spend | 6.05 | Spend | Spend - Travel | No | General
2022-07-28 00:00:00 | Spend | 90 | Spend | Spend - Classes | No | General
2022-07-28 00:00:00 | Spend | 1 | Spend | Spend - Classes | No | General
2022-07-28 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-07-29 00:00:00 | Spend | 1 | Spend | Spend - Classes | No | General
2022-07-29 00:00:00 | Spend | 7.2 | Spend | Spend - Travel | No | General
2022-07-30 00:00:00 | Spend | 6.8 | Spend | Spend - Travel | No | General
2022-07-30 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-07-30 00:00:00 | Spend | 1 | Spend | Spend - Classes | No | General
2022-07-30 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-07-31 00:00:00 | Spend | 4.45 | Spend | Spend - Travel | No | General
2022-07-31 00:00:00 | Spend | 1 | Spend | Spend - Classes | No | General
2022-08-01 00:00:00 | Spend | 1 | Spend | Spend - Classes | No | General
2022-08-01 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-08-02 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-08-03 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-08-04 00:00:00 | Spend | 42.5 | Spend | Spend - Classes | No | General
2022-08-31 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-08-31 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-09-01 00:00:00 | Spend | 18 | Spend | Spend - Travel | No | General
2022-09-01 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-09-02 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-09-02 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-09-03 00:00:00 | Spend | 5.1 | Spend | Spend - Travel | No | General
2022-09-26 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-09-26 00:00:00 | Spend | 2.6 | Spend | Spend - Travel | No | General
2022-09-26 00:00:00 | Spend | 10 | Spend | Spend - Classes | No | General
2022-09-27 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-09-28 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-09-28 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-09-28 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-09-29 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-09-29 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-09-29 00:00:00 | Spend | 3.2 | Spend | Spend - Travel | No | General
2022-09-30 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-09-30 00:00:00 | Spend | 43 | Spend | Spend - Classes | No | General
2022-09-30 00:00:00 | Spend | 12 | Spend | Spend - Classes | No | General
2022-10-03 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-10-04 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-04 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-10-04 00:00:00 | Spend | 18 | Spend | Spend - Classes | No | General
2022-10-04 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-10-05 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-05 00:00:00 | Spend | 2.5 | Spend | Spend - Classes | No | General
2022-10-05 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-10-06 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-06 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-10-06 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-10-07 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-10-07 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-08 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-08 00:00:00 | Spend | 1 | Spend | Spend - Classes | No | General
2022-10-09 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-10-10 00:00:00 | Spend | 1 | Spend | Spend - Classes | No | General
2022-10-10 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-10-10 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-10-11 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-12 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-12 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-10-12 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-10-13 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-13 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-10-13 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-10-13 00:00:00 | Spend | 10 | Spend | Spend - Classes | No | General
2022-10-14 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-14 00:00:00 | Spend | 18 | Spend | Spend - Classes | No | General
2022-10-15 00:00:00 | Spend | 1 | Spend | Spend - Classes | No | General
2022-10-15 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-16 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-10-17 00:00:00 | Spend | 1 | Spend | Spend - Classes | No | General
2022-10-17 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-10-18 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-18 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-10-18 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-10-19 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-19 00:00:00 | Spend | 15 | Spend | Spend - Classes | No | General
2022-10-20 00:00:00 | Income | 42.5 | Income | Spend - Classes | No | General
2022-10-20 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-24 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-10-25 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-25 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-10-26 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-26 00:00:00 | Spend | 1 | Spend | Spend - Classes | No | General
2022-10-26 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-10-26 00:00:00 | Spend | 18 | Spend | Spend - Classes | No | General
2022-10-27 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-27 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-10-27 00:00:00 | Spend | 1 | Spend | Spend - Classes | No | General
2022-10-28 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-28 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-10-29 00:00:00 | Spend | 1 | Spend | Spend - Classes | No | General
2022-10-29 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-10-30 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-10-30 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-11-01 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-11-03 00:00:00 | Spend | 40 | Spend | Spend - Classes | No | General
2022-01-04 00:00:00 | Spend | 2 | Spend | Spend - Classes | No | General
2022-11-08 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-11-08 00:00:00 | Spend | 1 | Spend | Spend - Classes | No | General
2022-11-09 00:00:00 | Spend | 5.9 | Spend | Spend - Travel | No | General
2022-11-09 00:00:00 | Spend | 6 | Spend | Spend - Classes | No | General
2022-11-10 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-11-10 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-11-10 00:00:00 | Spend | 6 | Spend | Spend - Classes | No | General
2022-11-11 00:00:00 | Spend | 7.45 | Spend | Spend - Travel | No | General
2022-11-11 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-11-12 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-11-12 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-11-13 00:00:00 | Spend | 5.2 | Spend | Spend - Travel | No | General
2022-11-13 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-11-13 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-11-14 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-11-15 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-11-15 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-11-16 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-11-20 00:00:00 | Spend | 18 | Spend | Spend - Classes | No | General
2022-11-21 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-11-21 00:00:00 | Spend | 1 | Spend | Spend - Classes | No | General
2022-11-22 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-11-22 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-11-23 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-11-23 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-11-23 00:00:00 | Spend | 1 | Spend | Spend - Classes | No | General
2022-11-23 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-11-24 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-11-24 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-11-24 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-11-25 00:00:00 | Spend | 1 | Spend | Spend - Classes | No | General
2022-11-25 00:00:00 | Spend | 72 | Spend | Spend - Classes | No | General
2022-11-25 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-11-26 00:00:00 | Spend | 7.45 | Spend | Spend - Travel | No | General
2022-11-26 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-11-27 00:00:00 | Spend | 0.45 | Spend | Spend - Travel | No | General
2022-11-27 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-11-28 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-11-29 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-11-29 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-11-30 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-11-30 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-11-30 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-12-01 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-12-01 00:00:00 | Spend | 5.2 | Spend | Spend - Travel | No | General
2022-12-01 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-12-02 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-12-03 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-12-04 00:00:00 | Spend | 2.4 | Spend | Spend - Travel | No | General
2022-12-04 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-12-05 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-12-06 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-12-06 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-12-07 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-12-07 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-12-07 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-12-08 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-12-08 00:00:00 | Spend | 5 | Spend | Spend - Classes | No | General
2022-12-09 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-12-10 00:00:00 | Spend | 7.6 | Spend | Spend - Travel | No | General
2022-12-11 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-12-12 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-12-13 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-12-13 00:00:00 | Spend | 8 | Spend | Spend - Classes | No | General
2022-12-13 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-12-14 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-12-15 00:00:00 | Spend | 5.2 | Spend | Spend - Travel | No | General
2022-12-15 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-12-16 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-12-16 00:00:00 | Spend | 16 | Spend | Spend - Classes | No | General
2022-12-17 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-12-17 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-12-18 00:00:00 | Spend | 2.4 | Spend | Spend - Travel | No | General
2022-12-20 00:00:00 | Spend | 18 | Spend | Spend - Classes | No | General
2022-12-20 00:00:00 | Spend | 3.3 | Spend | Spend - Travel | No | General
2022-12-21 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-12-21 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-12-22 00:00:00 | Spend | 11 | Spend | Spend - Classes | No | General
2022-12-22 00:00:00 | Spend | 7.7 | Spend | Spend - Travel | No | General
2022-12-22 00:00:00 | Spend | 9 | Spend | Spend - Classes | No | General
2022-12-23 00:00:00 | Spend | 5.8 | Spend | Spend - Travel | No | General
2022-12-24 00:00:00 | Spend | 5.1 | Spend | Spend - Travel | No | General
2022-08-16 00:00:00 | Income | 5000 | Income | Income - Gifts / Donations | No | Project 1
2022-08-16 00:00:00 | Income | 3865.05 | Income | Income - Gifts / Donations | No | Project 1
2022-08-19 00:00:00 | Income | 405.56 | Income | Income - Gifts / Donations | No | Project 1
2022-08-19 00:00:00 | Spend | 3000 | Spend | Spend - Dancers | No | Project 1
2022-08-19 00:00:00 | Spend | 1557.51 | Spend | Spend - Dancers | No | Project 1
2022-08-19 00:00:00 | Spend | 19 | Spend | Spend - Dancers | No | Project 1
2022-08-19 00:00:00 | Spend | 990 | Spend | Spend - Dancers | No | Project 1
2022-08-20 00:00:00 | Income | 2500 | Income | Income - Gifts / Donations | No | Project 1
2022-08-20 00:00:00 | Income | 2500 | Income | Income - Gifts / Donations | No | Project 1
2022-08-23 00:00:00 | Spend | 210 | Spend | Spend - Dancers | No | Project 1
2022-08-23 00:00:00 | Spend | 210 | Spend | Spend - Dancers | No | Project 1
2022-08-23 00:00:00 | Spend | 210 | Spend | Spend - Dancers | No | Project 1
2022-08-23 00:00:00 | Spend | 210 | Spend | Spend - Dancers | No | Project 1
2022-08-31 00:00:00 | Spend | 210 | Spend | Spend - Dancers | No | Project 1
2022-08-31 00:00:00 | Spend | 210 | Spend | Spend - Dancers | No | Project 1
2022-08-31 00:00:00 | Spend | 210 | Spend | Spend - Dancers | No | Project 1
2022-08-31 00:00:00 | Spend | 210 | Spend | Spend - Dancers | No | Project 1
2022-09-02 00:00:00 | Income | 275 | Income | Income - Other | No | Project 1
2022-09-02 00:00:00 | Spend | 275 | Spend | Spend - Videography | No | Project 1
2022-09-06 00:00:00 | Spend | 2250 | Spend | Spend - Dancers | No | Project 1
2022-09-07 00:00:00 | Spend | 1536.39 | Spend | Spend - Dancers | No | Project 1
2022-09-07 00:00:00 | Spend | 19 | Spend | Spend - Dancers | No | Project 1
2022-09-09 00:00:00 | Spend | 2250 | Spend | Spend - Dancers | No | Project 1
2022-09-10 00:00:00 | Income | 1000 | Income | Income - LA Contribution | No | Project 1
2022-09-10 00:00:00 | Income | 2500 | Income | Income - Gifts / Donations | No | Project 1
2022-09-10 00:00:00 | Income | 31.29 | Income | Income - Gifts / Donations | No | Project 1
2022-09-10 00:00:00 | Spend | 2250 | Spend | Spend - Dancers | No | Project 1
2022-09-13 00:00:00 | Spend | 2250 | Spend | Spend - Dancers | No | Project 1