CHARITY COMMISSIO Fok ENfjIAND AND WALE acu8 Counsfrlling and Support 1163844 Receipts and payments accounts CC16a For the pèrlod from 01 Aprfl 2020 To 31 March 2021 Section A Receipts and payments Unrestrlcted funds lo th8 n••rqst Restiicted fund8 Endowmont funds Total fvnd8 Las¢ ywr to thgn•aro81£ tothe near•8t£ to the nearBst £ lo Ih? n0ar96t£ Al R8cg1 ts Ro¥c8 Trusl 40tK) 1,203 25Q 1.000 2.000 and Shoebvry¢ommunity E8sexCommuni Foundation Groundwork OonalionG 1,203 250 1.0 4.320 Sub total (Gross Income for AR) 3.203 8.250 9A5Y 9,809 A2 Asset and Investm•nt sales, Is80 tabl81. Sub total Total rec8lpts 3,203 6,250 9,453 9,809 A3Pa ents CDwThllorsupèrvlslDn supe[SOrs supervts4on bACP Insurance supe[sn FDDM hlr& Telephon$ Inlpmglfax Mifeage Tralnkng Refre$hmBnls 90 60 8S 31$ 1,¥Y 1,327 6DD 161 496 270 66 1.43 765 76 547 128 215 239 1,110 228 813 618 1,878 131 204 8.931 38 55 4T 250 147 17$ 250 2$1 275 Publi¢itylmatkeling V*nup hire Prini1nthotOCopy Olfice ovetheadG T34 140 2.085 140 3,9qB Sub total 1.033 A4 Asset and Investment puh¥S•s, (S tabl&l Sub total 1.033 2,885 3.918 8,931 Net of recelpts/fpayments) A5 Transf418 botw88n fundB A6 Cash funds last year end Cash funds thls yearend 2.170 3,365 5,535 878 5,362 7,532 2,201 5,566 7,563 13,098 6,685 7,563 CCXX R1 acc<xJnts ISSI
Section B Statement of assets and liabilities at the end of the period Unrestrlcted funds to nO&rt£ R$$trl¢ted funds to noavest £ Endowmènt funds tty n•arÈst £ Details B1 Cash funds Rosca TruBi 4709 Groundwo 857 Cttarfty Funds Total cash funds 7,532 5,506 &CPlulll$l) Unrgstrlct•d funds Rastrlct•d funds to nf4r¢At£ Endowm8nt funds to neare•l£ Detai15 to nearest£ Fund to whl¢h asBOtbeion Currontvaluo onal Details ost loptlona Fvrul towhlcb Detai15 Co6tloptlonall Cvwront valu¥ B4 Assots retalnod for the charlty's own usè I ni-, Fund to whl¢h ablll relat•s Amounldue loth•l Wh0* Ilonal Details B5 Llabllltles Signed by onB or Lwo trustees OTh behall of all th8 trust688 Slgn8tur& Prlnt Narne Dat6 of roval I Sh¢Art ¢00 22 9121 oqILI CCXX R2 acojunts 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 |
|---|---|---|---|
| 4/6/2020 | DD to Virgin Ref:FA65154677 | ECF | |
| 1/13/2020 | NL expenses NL41 ref: 2/1/20 | 100306 | ECF |
| 3/2/2020 | NL expenses NL38a ref:2/2/20 | 100310 | ECF |
| 5/4/2020 | DD to Virgin Ref:FA65154677 | ECF | |
| 5/21/2020 | Credit Amazon Europe | UF | |
| 6/4/2020 | DD to Virgin Ref:FA65154677 | ECF | |
| 7/6/2020 | DD to Virgin Ref:FA65154677 | ECF | |
| 7/15/2020 | NL expenses NL 42 ref 2/3/20 | 100313 | ECF |
| 7/20/2020 | ASD Deposit: B2 Southend | UF | |
| 7/15/2020 | NC Expenses NC 21 ref 1/2/20 | 100314 | ECF |
| 7/24/2020 | Direct Credit from Essex Comm | ECF 2 | |
| 8/4/2020 | DD to Virgin Ref:FA65154677 | ECF | |
| 8/6/2020 | Direct Credit from Gould WA | UF | |
| 7/28/2020 | NA Expenses ref:4/1/20 | 100315 | ECF |
| 7/28/2020 | NL expenses Inv 43 ref: 2/4/20 | 100316 | ECF |
| 9/4/2020 | DD to Virgin Ref:FA65154677 | ECF | |
| 9/18/2020 | Direct Credit from Gould WA | UF | |
| 9/22/2020 | Direct Credit from Wignal&Grayl | UF | |
| 9/10/2020 | NC Expenses NC 22 ref 1/3/20 | 100318 | ECF/ECF 2 |
| 10/5/2020 | DD to Virgin Ref:FA65154677 | ECF | |
| 10/6/2020 | Direct Credit from Gould WA | UF | |
| 9/10/2020 | NL expenses NL 44 ref:2/5/20 | 100317 | ECF |
| 10/8/2020 | NL supervision 8, 9, 10/20 | 100319 | ECF |
| 11/3/2020 | ASD Deposit: B2 Southend | 100058 | UF |
| 11/4/2020 | DD to Virgin Ref:FA65154677 | ECF | |
| 11/2/2020 | NL supervision 1/2/20 | 100320 | ECF |
| 11/2/2020 | NL expenses NL 45 ref: 2/6/20 | 100321 | ECF |
| 11/2/2020 | Hub Invoice 082 | 100323 | ECF/UF |
| 11/2/2020 | service insurance | 100324 | UF |
| 11/2/2020 | Macromedia Marketing | 100322 | ECF/UF |
| 12/4/2020 | DD to Virgin Ref:FA65154677 | ||
| 12/8/2020 | Direct Credit from Khalifeh A | ||
| 12/7/2020 | Supervisors supervision 29/11/20 | 100325 | UF |
| 12/7/2020 | NL Supervision NL 46 ref 2/7/20 | 100326 | UF |
| 12/7/2020 | Hub room hire Invoice 088 | 100327 | UF |
| 12/23/2020 | Credit from Khalifeh A re Donation | UF | |
| 12/30/2020 | Direct Credit S Carter ref: EC1 | UF | |
| 12/30/2020 | Deposit Re 29Southend on sea | 100059 | UF |
| 1/5/2021 | DD to Virgin Ref:FA65154677 | UF | |
| 1/14/2021 | Direct Credit from Rosca Trust | Rosca | |
| 2/4/2021 | DD to Virgin Ref:FA65154677 | Rosca | |
| 2/3/2021 | NL expenses NL 47 ref: 2/1/21 | 100330 | Rosca |
| 2/3/2021 | NL expenses NL 48 ref: 2/2/21 | 100331 | Rosca |
| 2/11/2021 | Direct Credit from Amazon | ||
| 12/1/2021 | SAVS accounts review Inv 96 | 100328 | Rosca |
| 2/12/2021 | Direct Credit from Groundwork | ||
| 2/1/2021 | Hub Room hire Invoice 089 | 100329 | |
| 2/18/2021 | Direct Credit from Khalifeh A | ||
| 3/4/2021 | DD to Virgin Ref:FA65154677 | Groundwork |
3/5/2021 Direct Credit from Miss K pipe 3/8/2021 Direct Credit from Pearl Penelope 3/8/2021 Direct credit from Stacey Carter 3/16/2021 Direct Credit from Pearl Penelope 3/22/2021 Direct Credit from Pearl Wright
| 10093.79 | ||||
|---|---|---|---|---|
| Incoming | Outgoings | Balance | Date Cleared | |
| 4560.06 | entered opening balance in colum | |||
| 5.53 | 4554.53 | 4/6/2020 | ||
| 260.60 | 4293.93 | 4/7/2020 | ||
| 100.00 | 4193.93 | 4/7/2020 | ||
| 5.53 | 4188.40 | 5/4/2020 | ||
| 5.00 | 4193.40 | 5/21/2020 | ||
| 5.53 | 4187.87 | 6/4/2020 | ||
| 5.53 | 4182.34 | 7/6/2020 | ||
| 354.20 | 3828.14 | 7/20/2020 | ||
| 100.00 | 3928.14 | 7/20/2020 | ||
| 227.88 | 3700.26 | 7/21/2020 | ||
| 250.00 | 3950.26 | 7/24/2020 | ||
| 5.53 | 3944.73 | 8/4/2020 | ||
| 80.00 | 4024.73 | 8/6/2020 | ||
| 215.20 | 3809.53 | 8/11/2020 | ||
| 180.00 | 3629.53 | 8/11/2020 | ||
| 5.53 | 3624.00 | 9/4/2020 | ||
| 60.00 | 3684.00 | 9/18/2020 | ||
| 80.00 | 3764.00 | 9/22/2020 | ||
| 486.83 | 3277.17 | 9/23/2020 | ||
| 5.53 | 3271.64 | 10/5/2020 | ||
| 90.00 | 3361.64 | 10/6/2020 | ||
| 90.00 | 3271.64 | 10/19/2020 | ||
| 180.00 | 3091.64 | 10/27/2020 | ||
| 100.00 | 3191.64 | 11/3/2020 | ||
| 5.53 | 3186.11 | 11/4/2020 | ||
| 60.00 | 3126.11 | 11/4/2020 | ||
| 203.50 | 2922.61 | 11/4/2020 | ||
| 137.50 | 2785.11 | 11/13/2020 | ||
| 315.12 | 2469.99 | 11/27/2020 | ||
| 145.00 | 2324.99 | 12/8/2020 | ||
| 5.53 | 2319.46 | 12/8/2020 | ||
| 120.00 | 2439.46 | 12/8/2020 | ||
| 60.00 | 2379.46 | 12/10/2020 | NEED to copy the cell | |
| 188.10 | 2191.36 | 12/11/2020 | ||
| 225.00 | 1966.36 | 12/21/2020 | ||
| 120.00 | 2086.36 | 12/23/2020 | ||
| 90.00 | 2176.36 | 12/23/2020 | ||
| 2,000.00 | 4176.36 | 12/30/2020 | ||
| 5.53 | 4170.83 | 1/5/2021 | ||
| 5,000.00 | 9170.83 | 1/14/2021 | ||
| 5.53 | 9165.30 | 2/4/2021 | ||
| 95.60 | 9069.70 | 2/9/2021 | ||
| 90.00 | 8979.70 | 2/9/2021 | ||
| 7.12 | 8986.82 | 2/11/2021 | ||
| 100.00 | 8886.82 | 2/12/2021 | ||
| 1,000.00 | 9886.82 | 2/12/2021 | ||
| 137.50 | 9749.32 | 2/15/2021 | ||
| 240.00 | 9989.32 | 2/18/2021 | ||
| 5.53 | 9983.79 | 3/4/2021 |
| 20.00 | 10003.79 | 3/5/2021 |
|---|---|---|
| 30.00 | 10033.79 | 3/8/2021 |
| 40.00 | 10073.79 | 3/8/2021 |
| 10.00 | 10083.79 | 3/16/2021 |
| 10.00 | 10093.79 | 3/11/2021 |
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 | ||
| 10093.79 |
10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79
10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79 10093.79
mn G5
ls down to G200 in order to register as a balance
9,452.12 3,918.39 12532.2 7447.76 -3,080.08 -3,529.37
Deposit Bank Account
| Date | Details | Cheque no/ref | Project code |
|---|---|---|---|
| 6/3/2020 | Interest | ||
| 9/3/2020 | Interest | ||
| 12/3/2020 | Interest | ||
| 3/3/2021 | Interest |
| 3004.32 | |||||
|---|---|---|---|---|---|
| Incoming | Outgoings | Balance | Date Cleared | ||
| 3002.95 | entered opening balance in colum | ||||
| 0.81 | 3003.76 | 6/3/2020 | |||
| 0.42 | 3004.18 | 9/3/2020 | |||
| 0.07 | 3004.25 | 12/3/2020 | |||
| 0.07 | 3004.32 | 3/3/2021 | |||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | NEED to copy the cell | ||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 | |||||
| 3004.32 |
3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32
3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32
3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32 3004.32
mn G5
ls down to G200 in order to register as a balance
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 | ||
| 0.00 |
Project 1
| Project 1 | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Variance | -1,056.83 | -540.00 | -76.00 | -181.00 | -37.50 | |||||||
| entered opening balance from my accounts | Budget | |||||||||||
| 0 | 0 | Actual balance | 1,056.83 | 540.00 | 76.00 | 181.00 | 37.50 | |||||
| Income | ||||||||||||
| Date | Details | Cheque no. | Ref | Grant | Other | Opening Balance | Counselling | Supervisors | BACP | Insurance | Supervision | |
| /Ref | income | 0.00 | Supervision | Supervision | Room Hire | |||||||
| 4/6/2020 | DD to Virgin Ref:FA65154677 | 2,201.23 2,195.70 |
||||||||||
| 1/13/2020 | NL expenses NL41 ref: 2/1/20 | 100306 | 1,935.10 | 180.00 | 60.00 | 15.00 | ||||||
| 3/2/2020 | NL expenses NL38a ref:2/2/20 | 100310 | 1,835.10 | 100.00 | ||||||||
| 5/4/2020 | DD to Virgin Ref:FA65154677 | 1,829.57 | ||||||||||
| 6/4/2020 | DD to Virgin Ref:FA65154677 | 1,824.04 | ||||||||||
| 7/4/2020 | DD to Virgin Ref:FA65154677 | 1,818.51 | ||||||||||
| 7/15/2020 | NL expenses NL42 ref 2/3/20 | 100313 | 1,464.31 | 90.00 | 240.00 | 15.00 | ||||||
| 7/15/2020 | NC Expenses NC 21 ref 1/2/20 | 100314 | 1,236.43 | 45.00 | ||||||||
| 8/4/2020 | DD to Virgin Ref:FA65154677 | 1,230.90 | ||||||||||
| 7/28/2020 | NA Expenses ref 4/1/20 | 100315 | 1,015.70 | 76.00 | 120.00 | |||||||
| 7/28/2020 | NL expenses Inv 43 ref: 2/4/20 | 100316 | 835.70 | 180.00 | ||||||||
| 9/4/2020 | DD to Virgin Ref:FA65154677 | 830.17 | ||||||||||
| 9/10/2020 | NC Expenses NC 22 ref 1/3/20 | 100318 | 593.34 | 236.83 | ||||||||
| 10/5/2020 | DD to Virgin Ref:FA65154677 | 587.81 | ||||||||||
| 9/10/2020 | NL expenses NL 44 ref:2/5/20 | 100317 | 497.81 | 90.00 | ||||||||
| 10/8/2020 | NL supervision 8, 9, 10/20 | 100319 | 317.81 | 180.00 | ||||||||
| 11/4/2020 | DD to Virgin Ref:FA65154677 | 312.28 | ||||||||||
| 11/2/2020 | NL supervision 1/2/20 | 100320 | 252.28 | 60.00 | ||||||||
| 11/2/2020 | NL expenses NL 45 ref: 2/6/20 | 100321 | 48.78 | 135.00 | 61.00 | 7.50 | ||||||
| 11/2/2020 | Hub Invoice 082 | 100323 | 11.28 | |||||||||
| 11/2/2020 | Macromedia Marketing | 100322 | 0.00 | |||||||||
| 0.00 | ||||||||||||
| 0.00 |
| -44.24 | -41.20 | 0.00 | 0.00 | 0.00 | -146.96 | -37.50 | 0.00 | -40.00 | ||
|---|---|---|---|---|---|---|---|---|---|---|
| 44.24 | 41.20 | 0.00 | 0.00 | 0.00 | 146.96 | 37.50 | 0.00 | 40.00 | ||
| Expenditure | ||||||||||
| Tel/internet | Mileage | Training | Snacks - | IT | Publicity / | Venue hire | Printing | Stationary/ | ||
| /fax | clients | marketing | overheads | |||||||
| 5.53 | ||||||||||
| 5.60 | ||||||||||
| 100.00 | ||||||||||
| 5.53 | 5.53 | |||||||||
| 5.53 | ||||||||||
| 5.53 | 5.53 | |||||||||
| 9.20 | 354.20 | |||||||||
| 7.20 | 135.68 | 40.00 | ||||||||
| 5.53 | ||||||||||
| 19.20 | ||||||||||
| 5.53 | 5.53 | |||||||||
| 5.53 | ||||||||||
| 5.53 | ||||||||||
| 37.50 | ||||||||||
| 11.28 |
Project 2
| Project 2 | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Variance | 0.00 | 0.00 | 0.00 | |||||||
| entered opening balance from | my accounts | Budget | ||||||||
| 250 | 0 | Actual balance | 0.00 | 0.00 | 0.00 | |||||
| Income | ||||||||||
| Date | Details | Cheque | Ref | Grant | Other | Opening Balance | Counsellor | Supervisors | BACP | |
| No/Ref | income | 0.00 | Supervision | Supervision | ||||||
| 7/24/2020 | Direct Credit from Essex Comm | 250 | 250.00 | |||||||
| 9/10/2020 | NC Expenses NC 22 ref 1/3/20 | 100318 | 0.00 | |||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 | ||||||||||
| 0.00 |
| 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | -250.00 | 0.00 | 0.00 | 0.00 | 0.00 |
|---|---|---|---|---|---|---|---|---|---|---|
| 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 250.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Expenditure | ||||||||||
| Insurance | Supervision | Tel/internet | Mileage | Training | Refreshments | IT | Publicity | Venue hire | Printing | Stationary/ |
| Room Hire | /fax | overheads |
250.00
Rosca Trust
| Variance | -180.00 | 0.00 | 0.00 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Budget | ||||||||||
| 5000 | 0 | Actual balance | 180.00 | 0.00 | 0.00 | |||||
| Income | ||||||||||
| Date | Details | Cheque | Ref | Grant | Other | Opening Balance | Counselling | Supervisors | BACP | |
| No/Ref | income | Supervision | Supervision | |||||||
| 1/14/2021 | Direct Credit from Rosca Trust | 5000 | 5,000.00 | |||||||
| 2/4/2021 | DD to Virgin Ref:FA65154677 | 4,994.47 | ||||||||
| 2/3/2021 | NL expenses NL 47 ref: 2/1/21 | 100330 | 4,898.87 | 90.00 | ||||||
| 2/3/2021 | NL expenses NL 48 ref: 2/2/21 | 100331 | 4,808.87 | 90.00 | ||||||
| 12/1/2021 | SAVS accounts review Inv 96 | 100328 | 4,708.87 | |||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 | ||||||||||
| 4,708.87 |
4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87 4,708.87
| 0.00 | 0.00 | -5.53 | -5.60 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | -100.00 | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0.00 | 0.00 | 5.53 | 5.60 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 100.00 | |
| Expenditure | |||||||||||
| Insurance | Supervision | Tel/internet | Mileage | Training | Refreshments | IT | Publicity / | Venue hire | Printing | Stationary/ | |
| Room Hire | /fax | marketing | overheads |
5.53
5.60
100.00
Project 4 Groundwork
| Project 4 | Groundwork | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Variance | 0.00 | 0.00 | 0.00 | |||||||
| Budget | ||||||||||
| 1000 | 0 | Actual balance | 0.00 | 0.00 | 0.00 | |||||
| Income | ||||||||||
| Date | Details | Cheque | Ref | Grant | Other | Opening Balance | Counselling | Supervisors | BACP | |
| No/Ref | income | Supervision | Supervision | |||||||
| 2/12/2021 | Direct Credit from Groundwork | 1000 | 1,000.00 | |||||||
| 2/1/2021 | Hub Room hire Invoice 089 | 100329 | 862.50 | |||||||
| 3/4/2021 | DD to Virgin Ref:FA65154677 | 856.97 | ||||||||
| 856.97 | ||||||||||
| 856.97 | ||||||||||
| 856.97 | ||||||||||
| 856.97 | ||||||||||
| 856.97 | ||||||||||
| 856.97 | ||||||||||
| 856.97 | ||||||||||
| 856.97 | ||||||||||
| 856.97 | ||||||||||
| 856.97 | ||||||||||
| 856.97 | ||||||||||
| 856.97 | ||||||||||
| 856.97 | ||||||||||
| 856.97 | ||||||||||
| 856.97 | ||||||||||
| 856.97 | ||||||||||
| 856.97 | ||||||||||
| 856.97 | ||||||||||
| 856.97 |
| 0.00 | 0.00 | -5.53 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | -137.50 | 0.00 | 0.00 | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0.00 | 0.00 | 5.53 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 137.50 | 0.00 | 0.00 | |
| Expenditure | |||||||||||
| Insurance | Supervision | Tel/internet | Mileage | Training | Snacks - | IT | Publicity / | Venue hire | Printing | Stationary/ | |
| Room Hire | /fax | clients | marketing | overheads |
137.50
5.53
Unrestricted Funds
| Variance | -90.00 | -60.00 | ||||||
|---|---|---|---|---|---|---|---|---|
| Budget | ||||||||
| 0 | 3203.49 | Actual balance | 90.00 | 60.00 | ||||
| Income | ||||||||
| Date | Details | Cheque | Ref | Grant | Other | Opening Balance | Counsellor | Supervisors |
| No/Ref | income | Supervision | Supervision | |||||
| 5,361.78 | ||||||||
| 5/21/2020 | Credit Amazon Europe | 5 | 5,366.78 | 0.00 | ||||
| 6/3/2020 | Deposit acc Interest | 0.81 | 5,367.59 | |||||
| 7/20/2020 | ASD Deposit: B2 Southend | 100 | 5,467.59 | |||||
| 8/6/2020 | Direct Credit from Gould WA | 80 | 5,547.59 | |||||
| 9/3/2020 | Interest | 0.42 | 5,548.01 | |||||
| 9/18/2020 | Direct Credit from Gould WA | 60 | 5,608.01 | |||||
| 9/22/2020 | Direct Credit from Wignal&Grayl | 80 | 5,688.01 | |||||
| 10/6/2020 | Direct Credit from Gould WA | 90 | 5,778.01 | |||||
| 11/3/2020 | ASD Deposit: B2 Southend | 100058 | 100 | 5,878.01 | ||||
| 11/2/2020 | Hub Invoice 082 | 100323 | 5,778.01 | |||||
| 11/2/2020 | service insurance | 100324 | 5,462.89 | |||||
| 11/2/2020 | Macromedia Marketing | 100322 | 5,329.17 | |||||
| 12/3/2020 | Interest | 0.07 | 5,329.24 | |||||
| 12/4/2020 | DD to Virgin Ref:FA65154677 | 5,323.71 | ||||||
| 12/8/2020 | Direct Credit from Khalifeh A | 120 | 5,443.71 | |||||
| 12/7/2020 | Supervisors supervision 29/11/20 | 100325 | 5,383.71 | 60.00 | ||||
| 12/7/2020 | NL Supervision NL 46 ref 2/7/20 | 100326 | 5,195.61 | 90.00 | ||||
| 12/7/2020 | Hub room hire Invoice 088 | 100327 | 4,970.61 | |||||
| 12/23/2020 | Credit from Khalifeh A re Donation | 120 | 5,090.61 | |||||
| 12/30/2020 | Direct Credit S Carter ref: EC1 | 90 | 5,180.61 | |||||
| 12/30/2020 | Deposit Re 29Southend on sea | 100059 | 2000 | 7,180.61 | ||||
| 1/5/2021 | DD to Virgin Ref:FA65154677 | 7,175.08 | ||||||
| 2/11/2021 | Direct Credit from Amazon | 7.12 | 7,182.20 | |||||
| 2/18/2021 | Direct Credit from Khalifeh A | 240 | 7,422.20 | |||||
| 3/3/2021 | Interest | 0.07 | 7,422.27 | |||||
| 3/5/2021 | Direct Credit from Miss K pipe | 20 | 7,442.27 | |||||
| 3/8/2021 | Direct Credit from Pearl Penelope | 30 | 7,472.27 | |||||
| 3/8/2021 | Direct credit from Stacey Carter | 40 | 7,512.27 | |||||
| 3/16/2021 | Direct Credit from Pearl Penelope | 10 | 7,522.27 | |||||
| 3/22/2021 | Direct Credit from Pearl Wright | 10 | 7,532.27 | |||||
| 7,532.27 | ||||||||
| 7,532.27 | ||||||||
| 7,532.27 |
7,532.27 7,532.27 7,532.27 7,532.27 7,532.27 7,532.27 7,532.27 7,532.27 7,532.27
| -85.00 | -315.12 | -232.50 | -11.06 | -5.60 | 0.00 | 0.00 | 0.00 | -133.72 | -100.00 | 0.00 | 0.00 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 85.00 | 315.12 | 232.50 | 11.06 | 5.60 | 0.00 | 0.00 | 0.00 | 133.72 | 100.00 | 0.00 | 0.00 | |
| Expenditure | ||||||||||||
| BACP | Insurance | Supervision | Tel/internet | Mileage | Training | Refreshments | IT | Publicity | Venue hire | Printing | Stationary/ | |
| Room Hire | /fax | overheads | ||||||||||
| 100.00 | ||||||||||||
| 315.12 | ||||||||||||
| 133.72 | ||||||||||||
| 5.53 | ||||||||||||
| 85.00 | 7.50 | 5.60 | ||||||||||
| 225.00 | ||||||||||||
| 5.53 |
| 5/9/2017 | Deposit | 100017 | 125.02 |
|---|---|---|---|
| 5/17/2017 | DD Credit | 100 | |
| 6/27/2017 | Deposit | 100019 | 108 |
| 7/4/2017 | Deposit | 100020 | 161 |
6/27/2017 Deposit 100019 7/4/2017 Deposit 100020 7/10/2017 Room Hire I 100190
108 161 .52.5
Income and Expenditure
| Balance B/F Income Grants Other Income Total Income Expenditure Counsellor Supervision Supervisors Supervision BACP Insurance Supervision Room Hire Tel, Internet, Fax Mileage Training Refreshments IT Publicity/marketing Venue hire Printing Ofce/ overheads Total Expenditure Surplus/Defcit Balance C/F |
Total 5,361.78 6,250.00 0.00 0.00 0.00 3,203.49 9,453.49 1,326.83 600.00 161.00 496.12 270.00 66.36 52.40 0.00 0.00 250.00 280.68 275.00 0.00 140.00 3,918.39 |
INSERT brought forward balances Total Restricted UF RF ECF ECF 2 5361.78 2201.23 6250.00 0.00 250.00 3,203.49 0.00 0.00 0.00 3,203.49 6,250.00 0.00 250.00 90.00 1236.83 1,056.83 0.00 60.00 540.00 540.00 0.00 85.00 76.00 76.00 0.00 315.12 181.00 181.00 0.00 232.50 37.50 37.50 0.00 11.06 55.30 44.24 0.00 5.60 46.80 41.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 250.00 0.00 250.00 133.72 146.96 146.96 0.00 100.00 175.00 37.50 0.00 0.00 0.00 0.00 0.00 0.00 140.00 40.00 0.00 1,033.00 2,885.39 2,201.23 250.00 2,170.49 3,364.61 -2,201.23 0.00 7532.27 3364.61 0.00 0.00 |
INSERT brought forward balances Total Restricted UF RF ECF ECF 2 5361.78 2201.23 6250.00 0.00 250.00 3,203.49 0.00 0.00 0.00 3,203.49 6,250.00 0.00 250.00 90.00 1236.83 1,056.83 0.00 60.00 540.00 540.00 0.00 85.00 76.00 76.00 0.00 315.12 181.00 181.00 0.00 232.50 37.50 37.50 0.00 11.06 55.30 44.24 0.00 5.60 46.80 41.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 250.00 0.00 250.00 133.72 146.96 146.96 0.00 100.00 175.00 37.50 0.00 0.00 0.00 0.00 0.00 0.00 140.00 40.00 0.00 1,033.00 2,885.39 2,201.23 250.00 2,170.49 3,364.61 -2,201.23 0.00 7532.27 3364.61 0.00 0.00 |
|---|---|---|---|
| 2201.23 | |||
| 0.00 250.00 |
|||
| 0.00 0.00 |
|||
| 0.00 250.00 |
|||
| 1,056.83 0.00 540.00 0.00 76.00 0.00 181.00 0.00 37.50 0.00 44.24 0.00 41.20 0.00 0.00 0.00 0.00 0.00 0.00 250.00 146.96 0.00 37.50 0.00 0.00 0.00 40.00 0.00 |
|||
| 2,201.23 250.00 |
|||
| 5,535.10 | -2,201.23 0.00 |
||
| 10896.88 | |||
| 0.00 0.00 |
Funds (RF) Rosca G work
5,000.00 1,000.00 0.00 0.00
5,000.00 1,000.00
| 180.00 | 0.00 |
|---|---|
| 0.00 | 0.00 |
| 0.00 | 0.00 |
| 0.00 | 0.00 |
| 0.00 | 0.00 |
| 5.53 | 5.53 |
| 5.60 | 0.00 |
| 0.00 | 0.00 |
| 0.00 | 0.00 |
| 0.00 | 0.00 |
| 0.00 | 0.00 |
| 0.00 | 137.50 |
| 0.00 | 0.00 |
| 100.00 | 0.00 |
| 291.13 | 143.03 |
| 4,708.87 | 856.97 |
| 4708.87 | 856.97 |
Balance Sheet
Current Assets
| Cash and Bank Bank Account 10,093.79 Depost Account 3,004.32 Petty Cash 0.00 Total Current Assets Net Assets Funds Position Restricted ECF 0.00 ECF 2 0.00 Rosca 4,708.87 G work 856.97 Unrestricted Total Funds |
|
|---|---|
| ### | |
| ### | |
| 5,565.84 | |
| 7,532.27 | |
| ### |