## **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<br>Feb-22<br>Mar-22<br>Apr-22<br>May-22<br>Jun-22<br>Jul-22<br>Aug-22<br>Sep-22<br>Oct-22<br>Nov-22<br>Dec-22<br>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<br>Feb-22<br>Mar-22<br>Apr-22<br>May-22<br>Jun-22<br>Jul-22<br>Aug-22<br>Sep-22<br>Oct-22<br>Nov-22<br>Dec-22|Jan-22<br>Feb-22<br>Mar-22<br>Apr-22<br>May-22<br>Jun-22<br>Jul-22<br>Aug-22<br>Sep-22<br>Oct-22<br>Nov-22<br>Dec-22|Jan-22<br>Feb-22<br>Mar-22<br>Apr-22<br>May-22<br>Jun-22<br>Jul-22<br>Aug-22<br>Sep-22<br>Oct-22<br>Nov-22<br>Dec-22|Jan-22<br>Feb-22<br>Mar-22<br>Apr-22<br>May-22<br>Jun-22<br>Jul-22<br>Aug-22<br>Sep-22<br>Oct-22<br>Nov-22<br>Dec-22|Jan-22<br>Feb-22<br>Mar-22<br>Apr-22<br>May-22<br>Jun-22<br>Jul-22<br>Aug-22<br>Sep-22<br>Oct-22<br>Nov-22<br>Dec-22|Jan-22<br>Feb-22<br>Mar-22<br>Apr-22<br>May-22<br>Jun-22<br>Jul-22<br>Aug-22<br>Sep-22<br>Oct-22<br>Nov-22<br>Dec-22|Jan-22<br>Feb-22<br>Mar-22<br>Apr-22<br>May-22<br>Jun-22<br>Jul-22<br>Aug-22<br>Sep-22<br>Oct-22<br>Nov-22<br>Dec-22|Jan-22<br>Feb-22<br>Mar-22<br>Apr-22<br>May-22<br>Jun-22<br>Jul-22<br>Aug-22<br>Sep-22<br>Oct-22<br>Nov-22<br>Dec-22|Jan-22<br>Feb-22<br>Mar-22<br>Apr-22<br>May-22<br>Jun-22<br>Jul-22<br>Aug-22<br>Sep-22<br>Oct-22<br>Nov-22<br>Dec-22|Jan-22<br>Feb-22<br>Mar-22<br>Apr-22<br>May-22<br>Jun-22<br>Jul-22<br>Aug-22<br>Sep-22<br>Oct-22<br>Nov-22<br>Dec-22|Jan-22<br>Feb-22<br>Mar-22<br>Apr-22<br>May-22<br>Jun-22<br>Jul-22<br>Aug-22<br>Sep-22<br>Oct-22<br>Nov-22<br>Dec-22|Jan-22<br>Feb-22<br>Mar-22<br>Apr-22<br>May-22<br>Jun-22<br>Jul-22<br>Aug-22<br>Sep-22<br>Oct-22<br>Nov-22<br>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<br>1,116.91|3,305.19|60.00<br>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<br>Feb-22<br>Mar-22<br>Apr-22<br>May-22<br>Jun-22<br>Jul-22<br>Aug-22<br>Sep-22<br>Oct-22<br>Nov-22<br>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 -----**<br>
Cash Flow Projecti<br>Company Name<br>20,000.00<br>15,000.00<br>10,000.00<br>5,000.00<br>0.00<br>-5,000.00<br>Beginning Jan-21 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 O<br>Cash on Hand<br>**----- End of picture text -----**<br>


## **Period** 

Combination chart showing Cash on Hand Minimum Alert and Ca 

Cash balance alert minimum 


**----- Start of picture text -----**<br>
$3,000<br>**----- End of picture text -----**<br>





**----- Start of picture text -----**<br>
ion<br>e<br>Cash Flow Projection<br>Cash on Hand Minimum Alert<br>Oct-22 Nov-22 Dec-22<br>**----- End of picture text -----**<br>


ash Flow Projection is in this cell. 

