Financial Year Ending 31/12/2021 to 31/12/2022 Support for Survivors Charity
Starting date Dec-21 Cash balance alert minimum 3,000.00
| Beginning | Beginning | Jan-21 | Feb-22 | Mar-22 | Apr-22 | May-22 | Jun-22 | Jul-22 | Aug-22 | Sep-22 | Oct-22 | Nov-22 | Dec-22 | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cash on hand(beginning of month) | 6,642.59 | |||||||||||||
| CASH RECEIPTS | Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Total |
|||||||||||||
| Grant/Funding | 324.37 | 5,000.00 | 3,000.00 | 19,150.00 | 10,000.00 | 2,054.88 | 39,529 | |||||||
| Credit returns | 0.00 | 0.00 | ||||||||||||
| Donars | 90.03 | 42.56 | 18.00 | 724.00 | 18.00 | 36.00 | 18.00 | 18.00 | 618.00 | 18.00 | 1,600.59 | |||
| Commissioning | 0.00 | |||||||||||||
| Refund | 987.00 | |||||||||||||
| Fundraising | 20.00 | 174.04 | 21.00 | 22.00 | 36.64 | 52.72 | 88.78 | 27.88 | 29.50 | 31.75 | 39.58 | 14.50 | 558.39 | |
| Miscellaneous | 1.00 | |||||||||||||
| TOTAL CASH RECEIPTS | 63.56 | 346.37 | 5,054.64 | 3,776.72 | 106.78 | 1,050.88 | 19,197.50 | 10,049.75 | 2,712.46 | 32.50 | 41,688.23 | |||
| Total cash available | 6,642.59 | 20.00 | 98.28 | 63.56 | 346.37 | 5,054.64 | 3,776.72 | 106.78 | 1,050.88 | 19,197.50 | 10,049.75 | 2,712.46 | 32.50 |
| CASH PAID OUT | CASH PAID OUT | Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 |
Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 |
Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 |
Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 |
Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 |
Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 |
Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 |
Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 |
Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 |
Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 |
Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 |
Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 |
Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | ||||||||||||||
| Advertising& Promotions | 20.96 | 20.96 | ||||||||||||
| Volunteer Resourses/Training | 57.90 | 180.00 | 180.00 | 252.88 | 144.00 | 270.00 | 450.00 | 1,534.78 | ||||||
| Miscellaneous | 20.00 | 20.00 | ||||||||||||
| Victims & Survivors benefitprograms | 90.00 | 90.00 | ||||||||||||
| Insurance(other than health) | 668.91 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 753.81 | ||
| Motor Cars | 35.00 | 35.00 | ||||||||||||
| Materials and supplies(in COGS) | 1.99 | 66.92 | 10.00 | 23.99 | 96.81 | 199.71 | ||||||||
| Meals and entertainment | 144.20 | 44.48 | 138.60 | 435.35 | 38.56 | 801.19 | ||||||||
| Room Hire | 289.50 | 191.54 | 184.10 | 105.00 | 79.50 | 849.64 | ||||||||
| Adminstration costs | 7.20 | 14.40 | 14.40 | 14.40 | 14.40 | 14.40 | 14.40 | 14.40 | 14.40 | 14.40 | 136.80 | |||
| Volunteer Expences | 40.00 | 204.50 | 27.50 | 35.98 | 64.96 | 77.64 | 50.93 | 14.40 | 296.06 | 14.68 | 826.65 | |||
| Stationery | 34.51 | 12.90 | 6.20 | 19.86 | 2.40 | 10.49 | 4.00 | 4.00 | 94.36 | |||||
| Printing | 49.95 | 147.81 | 42.97 | 51.95 | 81.45 | 47.46 | 47.46 | 86.00 | 40.96 | 36.47 | 632.48 | |||
| Rent or lease | 325.53 | 383.08 | 133.99 | 46.00 | 976.59 | 651.06 | 2,516.25 | |||||||
| Fundraising | 58.00 | 500.00 | 558.00 | |||||||||||
| Repairs and maintenance | 12.00 | 56.00 | 20.75 | 10.85 | 13.00 | 112.60 | ||||||||
| Supplies - Cleaning | 4.20 | 2.00 | 26.85 | 3.05 | 1.00 | 37.10 | ||||||||
| I.T support and software | 36.00 | 109.70 | 105.00 | 77.00 | 327.70 | |||||||||
| Broadband & Telephone expense | 38.50 | 38.70 | 38.50 | 41.00 | 84.38 | 46.00 | 46.00 | 46.00 | 46.00 | 50.20 | 53.00 | 528.28 | ||
| Travel & Carparking | 17.50 | 14.00 | 189.96 | 140.84 | 230.83 | 129.08 | 6.80 | 292.45 | 327.89 | 229.21 | 159.45 | 1,738.01 | ||
| Postage | 4.19 | 50.15 | 22.26 | 7.75 | 26.08 | 5.07 | 115.50 | |||||||
| Consumables | 23.92 | 5.00 | 20.67 | 1.40 | 9.75 | 60.74 | ||||||||
| Lunchs/refreshments/drop-in & Vol | 26.56 | 12.63 | 480.62 | 227.34 | 197.80 | 145.69 | 63.93 | 148.90 | 256.31 | 17.89 | 144.02 | 68.52 | 1,790.21 | |
| asset(Gazebo) | 74.00 | 10.00 | 50.00 | 29.99 | 191.99 | 41.99 | 397.97 | |||||||
| Fixtures & Fittings | 7.98 | 40.00 | 18.00 | 65.98 | ||||||||||
| Subscriptions & Memberships | 13.80 | 13.80 | 13.80 | 13.80 | 13.80 | 13.80 | 84.79 | 13.80 | 22.79 | 217.86 | 22.79 | 444.83 | ||
| Mobilephones | 143.26 | 89.63 | 65.76 | 91.35 | 55.60 | 356.50 | 149.80 | 39.60 | 39.60 | 208.25 | 132.50 | 1,371.85 | ||
| Fixed asset Office Equipment | 22.00 | 26.00 | 55.60 | 76.75 | 1,052.98 | 1,233.33 | ||||||||
| Miscellaneous | 1.00 | 100.00 | 0.30 | 101.30 | ||||||||||
| SUBTOTAL | 266.46 | 1,602.68 | 1,940.74 | 832.28 | 1,558.07 | 852.01 | 1,066.91 | 3,305.19 | 1,028.13 | 1,220.35 | 2,686.39 | 1,035.82 | 17,395.03 | |
| CASH PAID OUT | Jan-22 | Feb-22 | Maar 22 | Apr-22 | May-22 | Jun-22 | Jul-22 | Aug-23 | Sep-23 | Oct-23 | Nov-23 | Dec-22 | Total | |
| Loanprincipalpayment | 0 | |||||||||||||
| Capitalpurchases | 0 | |||||||||||||
| Other startupcosts | 0 | |||||||||||||
| To reserve and/or escrow | 0 | |||||||||||||
| Cash withdrawal | 832.28 | 1,558.07 | 852.01 | 50.00 1,116.91 |
3,305.19 | 60.00 1,088.13 |
1,220.35 | 2,686.39 | 110.00 | |||||
| TOTAL CASH PAID OUT | 266.46 | 1,602.68 | 1,940.74 | 24,183.20 | ||||||||||
| Cash on hand(end of month) | 6,642.59 | -1,504.40 | -1,877.18 | -485.91 | 3,496.57 | 2,924.71 | -1,010.13 | -2,254.31 | 18,109.37 | 8,829.40 | 52.14 | -1,003.32 | ||
| OTHER OPERATING DATA | Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 |
Total | ||||||||||||
| Sales volume(dollars) | 0 | |||||||||||||
| Accounts receivable balance | 0 | |||||||||||||
| Bad debt balance | 0 | |||||||||||||
| Inventoryon hand | 0 | |||||||||||||
| Accountspayable balance | 0 | |||||||||||||
| Depreciation | 0 |
----- Start of picture text -----
Cash Flow Projecti
Company Name
20,000.00
15,000.00
10,000.00
5,000.00
0.00
-5,000.00
Beginning Jan-21 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 O
Cash on Hand
----- End of picture text -----
Period
Combination chart showing Cash on Hand Minimum Alert and Ca
Cash balance alert minimum
----- Start of picture text -----
$3,000
----- End of picture text -----
----- Start of picture text -----
ion
e
Cash Flow Projection
Cash on Hand Minimum Alert
Oct-22 Nov-22 Dec-22
----- End of picture text -----
ash Flow Projection is in this cell.