CHARITY COMMISSIO FOR ENGLANO AND WALE Coun6•111ng SupportS•rvl¢e$ Southend 1184892 Receipts and payments accounts CC16a For the perlod from 01 &0rf12021 31 March 2022 Section A Receipts and payments UnrostflCt8d funds Restrlcted fun(Is Endowmont funil$ Total funds La5tyear ioth•neoresl£ toth• nBats¥t lolheneare51£ A1 Re¢•1 communty Sub total(Gros$ income for AR? 2,562 2*62 A2 Asset and Inve$tmentsales, (see tabl81. Sub total 2.662 2.562 A3Pa ments VrlunteerexpgnGe$ Freelanceltulots Tel. Intemet. Fam TI8vÈVpa￿n Relreshrneni$d￿n PhOtoCop￿Tr9 matkellng hire In$urance Officesupp￿s 60 14B 60 136 17 17 197 197 177 Sub totol 162 A4 Asset and Inv¥$tm¢nt urchases, see tsb Sub total 363 Net of rècèipts/(payments) A5 Tron$fers belween lund5 A6 Cash funds last year end Cash funds this year ènd 2.010 2,010 383 590 9S3 2.600 2.600 690 CCKX R1 acuunts ISSI Section B Statement of assets and liabilities at the end of the period Unre$til¢lèd Restrlcted fund$ fund$ Endowm8nt funds to neaM81£ CalecJo¥io$ B1 Ca¥h fvnd$ ChNDly Funds Totsl ea$h fund 2,600 ¢coMysII Unr8Strlci•d funds tr•neol¢et£ R•strl¢t•d fund5 to n•ar••l£ Endowment fund$ Details --•4#4 Fund ￿whIC Details ¢o¥tI￿oNI1j on - ze#e Fund iowhlc* ¢uwMtval Details 84 A$s•ts rètalnod for th• charSty'$ own Fund lowhlch IAI•s Afflountdu on Details BS Llabllltles by on8 cf bw5tep6 haifof 811 thettU51etss Signatur8 Pn'nt Name Dal8 of roval CCXX R2 *xou)ts Issi 2011012022 instructions below before using the cashbook. You will need basic Excel skills to use this c **Many thanks.** ## INSTRUCTIONS you'll be taken to that worksheet. **Bank Account Petty Cash Account Project 1 Project 2 Unrestricted Funds Income and Expenditure Balance Sheet** AUTOMATICALLY. ## **1. Bank Account** ALL money coming into your organisation and leaving your organisation must be entered in your bank acco entered AGAIN in the appropriate project worksheet or under petty cash. Don't forget to add all the details o (box) G50, if you need more lines, put the cursor on G50, hold down the button on your mouse and drag G5 enough lines. If you go need to go beyond G200, you'll need to add these lines manually. ## **2. Petty Cash Account** ## **3. Project Reports (project 1, project 2 etc.)** under the appropriate project account. Firstly, add the names of your projects to the worksheet headings, e ## **4. Unrestricted Funds** ## **5. Income and Expenditure** ## **6. Balance Sheet** This provides a 'snap-shot' of the organisation's finances, and will show how much money is being held by t surplus or deficit. Obviously, these figures are based on your own records and may not correspond to bank s bank statements with your records and carry out regular bank reconciliation. ## Bank Account |Date|Details|Cheque no/ref|Project code| |---|---|---|---| |4/1/2021|Deposit|100005|UF| |4/6/2021|DD Ansvar Insurance||UF| |5/5/2021|Direct Credit from Aerian Studios||UF| |7/2/2021|DD Ansvar Insurance||UF| |6/28/2021|Room Hire LTC Inv No: 15222|100023|UF| |6/8/2021|NC expenses NC8|100022|UF| |8/3/2021|DD Ansvar Insurance||UF| |9/2/2021|DD Ansvar Insurance||UF| |8/23/2021|Room booking Inv No: 15437|100024|UF| |10/4/2021|DD Ansvar Insurance||UF| |10/1/2021|Room booking Inv No: 63498|100025|UF| |10/11/2021|SAVS invoice No: 188|100026|UF| |11/2/2021|DD Ansvar Insurance||UF| |10/26/2021|Room Hire Inv No: 15720|100027|UF| |12/2/2021|DD Ansvar Insurance||UF| |1/5/2022|DD Ansvar Insurance||UF| |1/12/2022|Credit from HMRC Ref: ZD10226||UF| |2/2/2022|DD Ansvar Insurance||UF| |2/17/2022|Deposit at Barclays Southend|100006|| |3/3/2022|DD Ansvar Insurance||UF| |||2599.88|| |---|---|---|---| |Incoming|Outgoings|Balance|Date Cleared| |||590.22|| |2,000.00||2590.22|4/1/2021| ||19.70|2570.52|4/6/2021| |50.00||2620.52|5/5/2021| ||19.71|2600.81|7/2/2021| ||28.80|2572.01|7/6/2021| ||210.56|2361.45|7/15/2021| ||19.70|2341.75|8/3/2021| ||19.70|2322.05|9/2/2021| ||20.16|2301.89|9/7/2021| ||19.70|2282.19|10/4/2021| ||15.60|2266.59|10/21/2021| ||60.00|2206.59|10/27/2021| ||19.70|2186.89|11/2/2021| ||20.16|2166.73|11/5/2021| ||19.70|2147.03|12/2/2021| ||19.70|2127.33|1/5/2022| |501.95||2629.28|1/12/2022| ||19.70|2609.58|2/2/2022| |10.00||2619.58|2/17/2022| ||19.70|2599.88|3/3/2022| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| |||2599.88|| 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 2599.88 ## Petty Cash Account Date Details Voucher no/ cheque no Project ref 0.00 |Incoming|Outgoings|Balance| |---|---|---| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| |||0.00| ## Project 1 |Project 1|||||||||||||| |---|---|---|---|---|---|---|---|---|---|---|---|---|---| ||||||||Variance|0.00|0.00|0.00|0.00|0.00|0.00| ||||||||Budget||||||| ||||||0|0|Actual balance|0.00|0.00|0.00|0.00|0.00|0.00| |||||**Income**|||||||||| |Date|Details|Cheque no.|Ref|Grant|Other||Opening Balance|Salaries|Tax/NI|Volunteer|Trustee|Freelance /|Tel/internet| |||/Ref|||income|||||expenses|Expenses|tutors|/fax| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| ||||||||0.00||||||| 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 |0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00| |---|---|---|---|---|---|---|---| |0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00| ||**Expenditure**||||||| |Travel/parking|Light/heat/|Snacks -|Photo-|Publicity|Venue hire|Insurance|Ofce| ||utilities|clients|copying||||supplies| ## Project 2 [name of project] ||||||||Variance|0.00|0.00|0.00|0.00|0.00| |---|---|---|---|---|---|---|---|---|---|---|---|---| ||||||||Budget|||||| ||||||0|0|Actual balance|0.00|0.00|0.00|0.00|0.00| |||||**Income**||||||||| |Date|Details|Cheque|Ref|Grant|Other||Opening Balance|Salaries|Tax/NI|Volunteer|Trustee|Freelance /| |||No/Ref|||income|||||expenses|expenses|tutors| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| |0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00| |---|---|---|---|---|---|---|---|---| |0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00| |||**Expenditure**||||||| |Tel/internet|Travel/parking|Light/heat/|Snacks -|Photo-|Publicity|Venue hire|Insurance|Ofce| |/fax||utilites|clients|copying||||supplies| ## Project 2 [name of project] ||||||||Variance|0.00|0.00|0.00|0.00|0.00| |---|---|---|---|---|---|---|---|---|---|---|---|---| ||||||||Budget|||||| ||||||0|0|Actual balance|0.00|0.00|0.00|0.00|0.00| |||||**Income**||||||||| |Date|Details|Cheque|Ref|Grant|Other||Opening Balance|Salaries|Tax/NI|Volunteer|Trustee|Freelance /| |||No/Ref|||income|||||expenses|expenses|tutors| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| |0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00| |---|---|---|---|---|---|---|---|---| |0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00| |||**Expenditure**||||||| |Tel/internet|Travel/parking|Light/heat/|Snacks -|Photo-|Publicity|Venue hire|Insurance|Ofce| |/fax||utilites|clients|copying||||supplies| ## Project 2 [name of project] ||||||||Variance|0.00|0.00|0.00|0.00|0.00| |---|---|---|---|---|---|---|---|---|---|---|---|---| ||||||||Budget|||||| ||||||0|0|Actual balance|0.00|0.00|0.00|0.00|0.00| |||||**Income**||||||||| |Date|Details|Cheque|Ref|Grant|Other||Opening Balance|Salaries|Tax/NI|Volunteer|Trustee|Freelance /| |||No/Ref|||income|||||expenses|expenses|tutors| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| ||||||||0.00|||||| |0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00| |---|---|---|---|---|---|---|---|---| |0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00| |||**Expenditure**||||||| |Tel/internet|Travel/parking|Light/heat/|Snacks -|Photo-|Publicity|Venue hire|Insurance|Ofce| |/fax||utilites|clients|copying||||supplies| ## Unrestricted Funds |||||||Variance|0.00|0.00|0.00| |---|---|---|---|---|---|---|---|---|---| |||||||Budget|||| |||||0|2561.95|Actual balance|0.00|0.00|0.00| |||||**Income**|||||| |Date|Details|Cheque|Ref|Grant|Other|Opening Balance|Salaries|Tax/NI|Volunteer| |||No/Ref|||income||||expenses| |||||||590.22|||| |4/1/2021|Deposit|100005|||2000|2,590.22|||| |4/6/2021|DD Ansvar Insurance|||||2,570.52|||| |5/5/2021|Direct Credit from Aerian Studios||||50|2,620.52|||| |7/2/2021|DD Ansvar Insurance|||||2,600.81|||| |6/28/2021|Room Hire LTC Inv No: 15222|100023||||2,572.01|||| |6/8/2021|NC expenses NC8|100022||||2,361.45|||| |8/3/2021|DD Ansvar Insurance|||||2,341.75|||| |9/2/2021|DD Ansvar Insurance|||||2,322.05|||| |8/23/2021|Room booking Inv No: 15437|100024||||2,301.89|||| |10/4/2021|DD Ansvar Insurance|||||2,282.19|||| |10/1/2021|Room booking Inv No: 63498|100025||||2,266.59|||| |10/11/2021|SAVS invoice No: 188|100026||||2,206.59|||| |11/2/2021|DD Ansvar Insurance|||||2,186.89|||| |10/26/2021|Room Hire Inv No: 15720|100027||||2,166.73|||| |12/2/2021|DD Ansvar Insurance|||||2,147.03|||| |1/5/2022|DD Ansvar Insurance|||||2,127.33|||| |1/12/2022|Credit from HMRC Ref: ZD10226||||501.95|2,629.28|||| |2/2/2022|DD Ansvar Insurance|||||2,609.58|||| |2/17/2022|Deposit at Barclays Southend|100006|||10|2,619.58|||| |3/3/2022|DD Ansvar Insurance|||||2,599.88|||| |||||||2,599.88|||| |||||||2,599.88|||| |0.00|-60.00|-148.21|-28.42|0.00|-7.95|0.00|-16.99|-84.72|-197.01|-8.99| |---|---|---|---|---|---|---|---|---|---|---| |0.00|60.00|148.21|28.42|0.00|7.95|0.00|16.99|84.72|197.01|8.99| |||||**Expenditure**||||||| |Trustee|Freelance /|
Tel/internet|Travel/parking|Light/heat/|Snacks -|Photo-|Publicity|Venue hire|Insurance|Ofce| |expenses|tutors|/fax||utilites|clients|copying||||supplies| ||||||||||19.70|| ||||||||||19.71|| |||||||||28.80||| |||148.21|28.42||7.95||16.99|||8.99| ||||||||||19.70|| ||||||||||19.70|| |||||||||20.16||| ||||||||||19.70|| |||||||||15.60||| ||60.00|||||||||| ||||||||||19.70|| |||||||||20.16||| ||||||||||19.70|| ||||||||||19.70|| ||||||||||19.70|| ||||||||||19.70|| ## Income and Expenditure |**Balance B/F**
**Income**
**Grants**
**Other Income**
**Total Income**
**Expenditure**
Salaries
Tax/NI
Volunteers Expenses
Trustees Expenses
Freelance/tutors
Tel, Internet, Fax
Travel/Parking
Light/heat/utilities
Snacks - clients
Photocopying
Publicity
Venue hire
Insurance
Ofce supplies
**Total Expenditure**
**Surplus/Defcit**
**Balance C/F**|**Total**
590.22
0.00
0.00
0.00
0.00
2,561.95
**2,561.95**
0.00
0.00
0.00
0.00
60.00
148.21
28.42
0.00
7.95
0.00
16.99
84.72
197.01
8.99
**552.29**|**UF**
**590.22**
2,561.95
**2,561.95**
0.00
0.00
0.00
0.00
60.00
148.21
28.42
0.00
7.95
0.00
16.99
84.72
197.01
8.99
**552.29**
**2,009.66**
2599.88|**Total**
**RF**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
0.00|**Restricted**
**Project 1 Project 2**| |---|---|---|---|---| |||||| |||||| |||||0.00
0.00| |||||| |||||0.00
0.00| |||||| |||||**0.00**
**0.00**| |||||| |||||0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00| |||||| |||||**0.00**
**0.00**| |||||| ||**2,009.66**|||**0.00**
**0.00**| ||2599.88|||| |||||0.00
0.00| ## **Funds (RF) Project 3 Project 4** |0.00|0.00| |---|---| |0.00|0.00| |**0.00**|**0.00**| |0.00|0.00| |0.00|0.00| |0.00|0.00| |0.00|0.00| |0.00|0.00| |0.00|0.00| |0.00|0.00| |0.00|0.00| |0.00|0.00| |0.00|0.00| |0.00|0.00| |0.00|0.00| |0.00|0.00| |0.00|0.00| |**0.00**|**0.00**| ||| |**0.00**|**0.00**| |0.00|0.00| ## Balance Sheet ## **Current Assets** |**Cash and Bank**
Bank Account
2,599.88
Petty Cash
0.00
**Total Current Assets**
**Net Assets**
**Funds Position**
**Restricted**
FSJ
0.00
Project2
0.00
Project3
0.00
Project4
0.00
**Unrestricted**
**Total Funds**|| |---|---| ||**2,599.88**| ||| ||**2,599.88**| ||| ||**0.00**| ||| ||2,599.88| ||| ||**2,599.88**|