CHARITY COMMISSIO FOII ENGLAND AND WALE Coun59lllng and Support Servlcos Southend 1184892 Receipts and payments accounts CC16a For the rI0 from 01 April 2020 31 March 2021 Section A Receipts and payments Unrestricted funds Restricted funds Endowment funds Totsl fvnds Last year to thg nearest lo Ihe neare$l£ to the noarést£ to1 noai•$t£ totho noar8t £ A1 Recelpts FundrisiDg and community SouthEnd Bor CounThl FSJ Trust Essex Comrnuni 1.QlJO Foundoiion ub total ross inGon7e for AR) 1.000 A2 Asset and Inv8stment sal85, {see tsblel. Sub total Total recelpts 1,000 A3Pa enl8 Volunieer expen5e5 Freelancellutors Tel. Ini¥m81. Fax RÈnt Refreshment¥ ¢lienis Phoio¢opylng PublKtymarktrliTrJ Venue hiFB Insurance Olftce supplies 50 136 136 13 177 177 191 Sub total 363 525 A4 Asset and Investm8nt urchase•. table Sub tolal To¢alpoymgnts 363 525 Nol of receipts/{paymentsJ A5 Transfèrs between funds A6 Cash funds last year end Cash funds thls year end 363 363 475 953 953 478 59D 590 9S3 CCXX R1 acGounts ISSI
Section B Statement of assets and liabilities at the end of the period Unrestrlcted funds Restrlcted funds Endowmont funds tr> n&Br•gt £ lo nearest£ ne4r9St e B1 Cash fund$ Chartty Funds Total cash funds 690 lagr4$ face4)Jp#sTr£fftts K91} Unrestrlcted funds to nearegt£ Restrlcted funds Endowmènt funds Oetalls to nKre5t É to ngai$t£ Fund to whlch •¥s•t belon Dètalls Cosllopllonall Fund toWh1h Gvrrent value Details 84 Asset5 rètainod for tho charity's own uso Fund towhlch volat¢s Am¢)Unl due lonal Wh8n duo onal Detalls B5 Llabllltks Signed by one orh¥o Iruslee8 on behaifof all Ihe Iruslees Dale of rov81 Signaturg Prfnt Nam8 21 Flql2} CCXX R2 ac¢ryJnts ISSI
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 |
|---|---|---|---|
| 7/2/2020 | DD Ansvar Insurance | UF | |
| 3/4/2020 | Expenses NC7 | 100018 | UF |
| 8/4/2020 | DD Ansvar Insurance | UF | |
| 9/3/2020 | DD Ansvar Insurance | UF | |
| 10/1/2020 | DD Ansvar Insurance | UF | |
| 11/3/2020 | DD Ansvar Insurance | UF | |
| 12/2/2020 | DD Ansvar Insurance | UF | |
| 1/5/2021 | DD Ansvar Insurance | UF | |
| 2/2/2021 | DD Ansvar Insurance | UF | |
| 2/1/2021 | Accounts review Inv No 97 | 100021 | UF |
| 3/2/2021 | DD Ansvar Insurance | UF |
| 590.22 | |||
|---|---|---|---|
| Incoming | Outgoings | Balance | Date Cleared |
| 953.21 | |||
| 19.71 | 933.50 | 7/2/2020 | |
| 135.68 | 797.82 | 7/21/2020 | |
| 19.70 | 778.12 | 8/4/2020 | |
| 19.70 | 758.42 | 9/3/2020 | |
| 19.70 | 738.72 | 10/1/2020 | |
| 19.70 | 719.02 | 11/3/2020 | |
| 19.70 | 699.32 | 12/2/2020 | |
| 19.70 | 679.62 | 1/5/2021 | |
| 19.70 | 659.92 | 2/2/2021 | |
| 50.00 | 609.92 | 2/24/2021 | |
| 19.70 | 590.22 | 3/2/2021 | |
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 | |||
| 590.22 |
590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22
590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22
590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22 590.22
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 | |||||||
| Rent | 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 | Rent | 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 | Rent | 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 | Rent | Light/heat/ | Snacks - | Photo- | Publicity | Venue hire | Insurance | Ofce | |
| /fax | utilites | clients | copying | supplies |
Unrestricted Funds
| Variance | 0.00 | 0.00 | 0.00 | 0.00 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Budget | |||||||||||
| 0 | 0 | Actual balance | 0.00 | 0.00 | 0.00 | 0.00 | |||||
| Income | |||||||||||
| Date | Details | Cheque | Ref | Grant | Other | Opening Balance | Salaries | Tax/NI | Volunteer | Trustee | |
| No/Ref | income | expenses | expenses | ||||||||
| 953.21 | |||||||||||
| 7/2/2020 | DD Ansvar Insurance | 933.50 | |||||||||
| 3/4/2020 | Expenses NC7 | 100018 | 797.82 | ||||||||
| 8/4/2020 | DD Ansvar Insurance | 778.12 | |||||||||
| 9/3/2020 | DD Ansvar Insurance | 758.42 | |||||||||
| 10/1/2020 | DD Ansvar Insurance | 738.72 | |||||||||
| 11/3/2020 | DD Ansvar Insurance | 719.02 | |||||||||
| 12/2/2020 | DD Ansvar Insurance | 699.32 | |||||||||
| 1/5/2021 | DD Ansvar Insurance | 679.62 | |||||||||
| 2/2/2021 | DD Ansvar Insurance | 659.92 | |||||||||
| 2/1/2021 | Accounts review Inv No 97 | 100021 | 609.92 | ||||||||
| 3/2/2021 | DD Ansvar Insurance | 590.22 | |||||||||
| 590.22 | |||||||||||
| 590.22 | |||||||||||
| 590.22 | |||||||||||
| 590.22 | |||||||||||
| 590.22 | |||||||||||
| 590.22 | |||||||||||
| 590.22 | |||||||||||
| 590.22 | |||||||||||
| 590.22 | |||||||||||
| 590.22 | |||||||||||
| 590.22 |
| -50.00 | -135.68 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | -177.31 | 0.00 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 50.00 | 135.68 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 177.31 | 0.00 | |
| Expenditure | ||||||||||
| Freelance / | Tel/internet |
Rent | Light/heat/ | Snacks - | Photo- | Publicity | Venue hire | Insurance | Ofce | |
| tutors | /fax | utilites | clients | copying | supplies | |||||
| 19.71 | ||||||||||
| 135.68 | ||||||||||
| 19.70 | ||||||||||
| 19.70 | ||||||||||
| 19.70 | ||||||||||
| 19.70 | ||||||||||
| 19.70 | ||||||||||
| 19.70 | ||||||||||
| 19.70 | ||||||||||
| 50.00 | ||||||||||
| 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 Rent Light/heat/utilities Snacks - clients Photocopying Publicity Venue hire Insurance Ofce supplies Total Expenditure Surplus/Defcit Balance C/F |
Total 953.21 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 50.00 135.68 0.00 0.00 0.00 0.00 0.00 0.00 177.31 0.00 362.99 |
UF 953.21 0.00 0.00 0.00 0.00 0.00 0.00 50.00 135.68 0.00 0.00 0.00 0.00 0.00 0.00 177.31 0.00 362.99 -362.99 590.22 |
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 |
||||
| -362.99 | 0.00 0.00 |
|||
| 590.22 | ||||
| 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 590.22 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 |
|
|---|---|
| 590.22 | |
| 590.22 | |
| 0.00 | |
| 590.22 | |
| 590.22 |