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 noar*8t £
A1 Recelpts
Fundr*isiDg 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 toWh1￿h
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 /|<br>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**<br>**Income**<br>**Grants**<br>**Other Income**<br>**Total Income**<br>**Expenditure**<br>Salaries<br>Tax/NI<br>Volunteers Expenses<br>Trustees Expenses<br>Freelance/tutors<br>Tel, Internet, Fax<br>Rent<br>Light/heat/utilities<br>Snacks - clients<br>Photocopying<br>Publicity<br>Venue hire<br>Insurance<br>Ofce supplies<br>**Total Expenditure**<br>**Surplus/Defcit**<br>**Balance C/F**|**Total**<br>953.21<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>**0.00**<br>0.00<br>0.00<br>0.00<br>0.00<br>50.00<br>135.68<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>177.31<br>0.00<br>**362.99**|**UF**<br>**953.21**<br>0.00<br>**0.00**<br>0.00<br>0.00<br>0.00<br>0.00<br>50.00<br>135.68<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>177.31<br>0.00<br>**362.99**<br>**-362.99**<br>590.22|**Total**<br>**RF**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>0.00|**Restricted**<br>**Project 1 Project 2**|
|---|---|---|---|---|
||||||
||||||
|||||0.00<br>0.00|
||||||
|||||0.00<br>0.00|
||||||
|||||**0.00**<br>**0.00**|
||||||
|||||0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00|
||||||
|||||**0.00**<br>**0.00**|
||||||
||**-362.99**|||**0.00**<br>**0.00**|
||590.22||||
|||||0.00<br>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**<br>Bank Account<br>590.22<br>Petty Cash<br>0.00<br>**Total Current Assets**<br>**Net Assets**<br>**Funds Position**<br>**Restricted**<br>FSJ<br>0.00<br>Project2<br>0.00<br>Project3<br>0.00<br>Project4<br>0.00<br>**Unrestricted**<br>**Total Funds**||
|---|---|
||**590.22**|
|||
||**590.22**|
|||
||**0.00**|
|||
||590.22|
|||
||**590.22**|



