2022-01-31-accounts

Bank_Date	Description	Amount _	Expe	Amount_2	Statement_Ru	Trn_Date	Backing_Doc	Reference	Accounting_Section1	Accounting_Section2	Fund_Purpose	Comments
01/31/2021	OpeningBalance				9,076.44
02/04/2021	Sale of Car	600.00	I	600.00	9,676.44	02/04/2021	Stmnt		Sale of Asset	GLS
02/04/2021	AccountancyFees	300.00	E	-300.00	9,376.44	02/04/2021	Stmnt		Overheads	Accountancy		Accountancy2019-20
04/29/2021	Scout Hut	1,280.00	E	-1,280.00	8,096.44		Invoice		Session Costs	Rent		Unpaid from 2019
	Thirty1 Eight Safeguarding	129.00	E	-129.00	7,967.44		Direct Debit		Overheads	Safeguarding		Safeguarding
	Combined Liabilit Insurance	280.00	E	-280.00	7,687.44		Direct Debit		Overheads	Insurance		Insurance W Dennis
06/02/2021	AccountancyFees	300.00	E	-300.00	7,387.44		Stmnt		Overheads	Accountancy		Accountancy2020-21
	TOTAL EXPENDITURE			-2,289.00
	ASSET DISPOSAL			600.00

Date Description Amount _ExpenAmount_2 Petty_Cash_Runni Backing_DoReferenceAccounting_Section1 Accounting_Section2 Fund_Purpose Comments

Charity Commission Analysis Codes

A1_GU	Grant Unrestricted
A1_GR	Grant Restricted
A1_DU	Donations Unrestricted
A1_DR	Donations Restricted
A1_EARN	Earned Income
A1_OTH	Other income
A3_ADV	Advertising/Promotion
A3_BUS	Business Support/Courses
A3_COFR	Cost of Fund Raising
A3_COSF	Session cost - Food
A3_COSM	Session cost - Materials & Other
A3_COSS	Session cost - Contract Staf
A3_EMP	Employee Salary & HMRC (Restricted0
A3_EMPBEN	Employee Benefts (Restricted)
A3_OTH	Oher expenses
A3_EQPT	Equipment
A3_INS	Insurances
A3_PC	Petty Cash
A3_STA	Stationery/Cleaning

On the transaction tab all you need to do is select the category in the coloured colmn and the tran will be placed in the correct analysis cell

DO NOT overwrite the calculations in the transaction tab !!

If you need to add more analysis codes then you will need to do the following.

1. add the code and description to this table - this will extend the range of the table

2. Change the formula in column N to include the extended table.

3. Add new analysis columns

4. copy and amend the calculations in the header, body, and totals of the new analysis column

Charity Name Friends Of Whitworth Youth

Receipts and pay

Period start date

For the period from

10219

Section A Receipts and payments

Unrestricted funds

Restricted funds

to the nearest £ to the nearest £

A1 Receipts

----- Start of picture text -----
Grants - -
Donations - -
- -
- -
- -
- -
- -
- -
Sub total (Gross income for AR) - -
A2 Asset and investment sales,
(see table).
Car 600 -
- -
Sub total [ 600 ] -
Total receipts 600 -
A3 Payments
Accountancy 600 -
Insurance 280 -
Safeguarding 129 -
Scout Hut Unpaid from 2019 1,280 -
- -
- -
- -
- -
- -
- -
- -
- -
- -
Sub total 2,289 -
----- End of picture text -----

----- Start of picture text -----
A4 Asset and investment
purchases, (see table)
- -
- -
Sub total - -
Total payments 2,289 -
----- End of picture text -----

Net of receipts/(payments) - 1,689

-

A5 Transfers between funds - - A6 Cash funds last year end - - Cash funds this year end - 1,689 -

Section B Statement of assets and liabilities at the

Categories

Details

B1 Cash funds

Bank

Total cash funds

(agree balances with receipts and payments account(s))

Details

B2 Other monetary assets

Details

B3 Investment assets

Details

B4 Assets retained for the charity’s own use

Details

B5 Liabilities

Signed by one or two trustees on behalf of all the trustees Signature

No (if any) 1171710

yments accounts

Period end date 310120

To

CC16a

Endowment funds

to the nearest £

Total funds Last year

to the nearest £ to the nearest £

----- Start of picture text -----
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
----- End of picture text -----

----- Start of picture text -----
- 600
- - -
- 600 -
- 600 -
- 600 -
- 280 -
- 129 -
- 1,280 -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- -
- 2,289 -
----- End of picture text -----

----- Start of picture text -----
- -
- -
- - -
- 2,289 -
- - 1,689 -
----- End of picture text -----

----- Start of picture text -----
- - -
- - -
- - 1,689 -
----- End of picture text -----

end of the period

Unrestricted Restricted funds	Endowment
funds	funds
to nearest £ to nearest £ 7,387 - - - - - 7,387 -	to nearest £ - - - -
Agreement Error OK	OK

Unrestricted	Restricted funds	Endowment
funds		funds
to nearest £ - - - - - -	to nearest £ - - - - - -	to nearest £ - - - - - -

----- Start of picture text -----
Fund to which asset Current value
Cost (optional)
belongs (optional)
- -
- -
- -
- -
- -
Fund to which asset Current value
Cost (optional)
belongs (optional)
- -
- -
- -
- -
- -
- -
- -
- -
- -
Fund to which Amount due When due
liability relates (optional) (optional)
-
-
----- End of picture text -----

----- Start of picture text -----
-
-
-
----- End of picture text -----

----- Start of picture text -----
Print Name Date of approval
----- End of picture text -----