|**Organisation's Name**||Rights For Peace Ltd|
|---|---|---|
|**Last day in financialyear**||31/12/2023|
|**Funds**<br>Unrestricted<br>Rent Fund<br>GSF South Sudan Advocacy Ext<br>GSF Sudan Study Launch<br>GSF Sudan Study Ext<br>Matrix Causes Fund<br>Danish Hrts Institute<br>GSF Core Funding<br>GSF IRM Phase 1 (2023)<br>DT-Global/OTI-USAID<br>Spare fund 10<br>Spare fund 11<br>**Months(from first in FY)**<br>January<br>February<br>March<br>April<br>May<br>June<br>July<br>August<br>September<br>October<br>November<br>December||**Categories**<br>Balance brought forward<br>Transfers<br>Refunds<br>Donations<br>Online Campaigns<br>Grants<br>GiftAid (HMRC)<br>Sporting Events Campaign<br>Directors Loan<br>EasyFundraising<br>Receipt - spare 9<br>Receipt - spare 10<br>Rent<br>Direct Activity Costs - South Sudan<br>Direct Activity Costs -  Sudan<br>Direct Activity Costs -  Other<br>Int'l Travel<br>Local Transportation<br>Subscriptions / Software<br>Postage / Stationary / Office Supplies<br>Computer / IT Equipment / Hardware<br>Publications (printing,design)<br>Volunteer Expenses<br>Consultant Fees<br>Consultant Expenses<br>Accountancy Fees<br>Insurance<br>Communication<br>Govt Charges (registration fees etc)<br>Translation/Interpretation<br>Events<br>Bank charges<br>Promotion/Fundraising Costs<br>Accounting, Finance, Reporting<br>Payment - spare 23<br>Payment - spare 24<br>Payment - spare 25|
|||**Categories**|
|||Balance brought forward<br>Transfers|
|||Refunds<br>Donations<br>Online Campaigns<br>Grants<br>GiftAid (HMRC)<br>Sporting Events Campaign<br>Directors Loan<br>EasyFundraising<br>Receipt - spare 9<br>Receipt - spare 10|
|||Rent<br>Direct Activity Costs - South Sudan|
|||Direct Activity Costs -  Sudan|
|||Direct Activity Costs -  Other<br>Int'l Travel<br>Local Transportation<br>Subscriptions / Software<br>Postage / Stationary / Office Supplies<br>Computer / IT Equipment / Hardware<br>Publications (printing,design)<br>Volunteer Expenses<br>Consultant Fees<br>Consultant Expenses<br>Accountancy Fees<br>Insurance<br>Communication<br>Govt Charges (registration fees etc)<br>Translation/Interpretation<br>Events<br>Bank charges<br>Promotion/Fundraising Costs<br>Accounting, Finance, Reporting<br>Payment - spare 23<br>Payment - spare 24<br>Payment - spare 25|





## **Instructions** 

- 1 Figures in blue type can be overtyped. 

- 2 Before adjusting spreadsheet save a copy as a master template 

- 3 Start a new spreadsheet for each financial year 

- 4 Set the various funds up in the "Funds" table opposite 

- 5 Set the various receipts and payments up in the "Categories" table opposi Make sure you use unique names for different categories 

- 6 Transaction details are entered on the various bank and cash worksheets Firstly enter opening balances for each of the bank/cash account workshe splitting balances across various funds as appropriate 

- 7 The receipts & payment reports ("R&P" sheets) are auomatically generate and require no intervention 

- 8 To record transfers between accounts, record in both worksheets with Fun "Unrestricted" and category "Transfer" 

- 9 To record transfers between funds enter an in and out on the same works category "Transfer" and fund as appropriate 

- 10 The Transfer row on the Total R&P report worksheet should always total z 

## **Warnings** 

- 1 Once a fund or category has been set up do not alter it once it has been used in entering details on the bank and cash worksheets 

- 2 If on a "R&P" worksheet a warning appears "WARNING: ERROR IN SHEE that the total funds on the "R&P" sheet do not agree to the relevant bank/c sheet. This can happen if: 

   - a) A fund or category that has previously been used is altered in the ta b) When entering a transaction no fund was selected 

   - c) When entering a transaction no category was selected 

- Correct error immediately 



te 

eets 

ed 

nd 

heet, 

zero. 

ET" this means cash account(s) 

ables opposite 



**Rights For Peace Ltd Bank reconciliations Current account** Date: Ending balance per account register Ending balance per bank statement Add unpresented deposits - copy detail from register and check totals in blue cells Date Month Ref Transaction Details Fund Category Money In Total unpresented deposits _Total should match total_ Less unpresented payments - copy detail from register and check totals in green cells Date Month Ref Transaction Details Fund Category Money Out 



Total unpresented payments _Total should match total_ Adjusted balance Difference **Savings account** Date: Ending balance per account register 



Ending balance per bank statement Add unpresented deposits - copy detail from register and check totals in blue cells 

Date Month Ref Transaction Details Fund Category Money In Total unpresented deposits _Total should match total_ Less unpresented payments - copy uncleared payments from register Date Month Ref Transaction Details Fund Category Money Out 



Total unpresented payments _Total should match total_ Adjusted balance Difference **Cash float** Date: Ending balance per account register Ending balance per bank statement Add unpresented deposits - copy uncleared deposits from register Date Month Ref Transaction Details Fund Category Money In Total unpresented deposits Less unpresented payments - copy uncleared payments from register 



|Date|Month|Ref|Transaction Details|Fund|Category|Money Out|
|---|---|---|---|---|---|---|
|Total unpresented payments|||||||
|Adjusted balance|||||||
|Difference|||||||
||||||||
|**Spare**||||||Date:|
|Ending balance|per account|register|||||
|Ending balance|per bank statement||||||





Add unpresented deposits - copy uncleared deposits from register Date Month Ref Transaction Details Fund Category Money In Total unpresented deposits Less unpresented payments - copy uncleared payments from register Date Month Ref Transaction Details Fund Category Money Out Total unpresented payments 



djusted balance
Differen

4,732.70
0.00
127,167.94

0.00
108,867.98
0.00
0.00

0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00

0.00
0.00

0.00
0.00

|**Rights for Peace 2023**|||**Current account**|
|---|---|---|---|
|27-Jan-23 January|15|Paypal Tech Trust - to get WIX subscription discount|GSF Sudan Study Ext|
|8-Mar-23 March|25|V Taban Bank Charge on consultancy fee|GSF Sudan Study Launch|
|31-Mar-23 March|36|Charges Unpaid Item Fee|Unrestricted|
|||Kenya Air - Change of Najlaa's Flight to help her return early||
|27-Apr-23 April|40|when War broke out in Khartoum $100|GSF Sudan Study Launch|
|27-Apr-23 April|42|Bank Charge on 1st Payment for South Sudan Ext Project 80Unrestricted||
|5-May-23 May|45|1st Payment to CIGPJ - Bank charges £11|Unrestricted|
|10-Jul-23 July|89|Justgiving Donation - Sudan Emergency Appeal|Unrestricted|
|14-Jul-23 July|101|VT transfer bank charges|Unrestricted|
|19-Jul-23 July|103|Justgiving Donation - Sudan Emergency Appeal|Unrestricted|
|4-Sep-23 September|116|VT transfer bank charges £15 NatWest + Foreign|Unrestricted|
|2-Oct-23 October|131|EasyJet flight M. Radhouine Geneva launch|GSF Sudan Study Launch|
|9-Oct-23 October|138|EasyJet flight M. Radhouine Geneva bags add-on|GSF Sudan Study Launch|
|9-Oct-23 October|139|Taxi GE launch|GSF Sudan Study Launch|
|10-Oct-23 October|140|Subsistance GE launch|GSF Sudan Study Launch|
|9-Oct-23 October|142|Subsistance GE launch|GSF Sudan Study Launch|
|9-Oct-23 October|143|Hotel Intl'l et Terminus M Radhouane GE|GSF Sudan Study Launch|
|9-Oct-23 October|144|Hotel Intl'l et Terminus M Radhouane GE|GSF Sudan Study Launch|
|13-Nov-23 November|152|MG GE travel expenses|GSF Sudan Study Launch|
|23-Nov-23 November|158|Kamal Interpreter for 9 Oct GE launch (Western Union)|GSF Sudan Study Launch|
|1-Dec-23 November|163|NA Geneva per diem and expenses|GSF Sudan Study Launch|
|1-Dec-23 December|166|Forest Cottages Speke Hotel Kampala|DT-Global/OTI-USAID|
|4-Dec-23 December|167|MG mini bridge loan Dec no1 (500 + 100)|Unrestricted|
|7-Dec-23 December|179|MG mini bridge loan Dec no2 (500 + 100)|Unrestricted|
|19-Dec-23 December|187|MG mini bridge loans Dec no.1 and no.2|Unrestricted|
|22-Dec-23 December|189|Forest Cottages Speke Hotel Kampala Balance (USD 448)|DT-Global/OTI-USAID|
|18-Jan-24 January|203|GE Press Club Sudan launch SPLIT (£2169.46)|GSF Sudan Study Launch|
|18-Jan-24 January|204|GE Press Club Sudan launch|Unrestricted|
|21-Mar-24 March|213|MG Refund overpayment MG Travel expenses Geneva Laun|GSF Core Funding|



19 



226 Exchange rate loss from 2022 

Unrestricted 

15-Jun-24 June 

20 



Spare fund 6
25

||**Ending balance**||**4,732.70**|Total transactions|228|
|---|---|---|---|---|---|
|Subscriptions / Software||34.80|8,909.71|||
|Bank charges||23.50|8,743.04|||
|Bank charges||48.00|3,674.11|**-1,866.02**|**30.87**|
|Int'l Travel||82.80|3,542.74|||
|Bank charges||12.69|37,240.74      39,106.79|||
|Bank charges||11.00|21,241.07|||
|Online Campaigns|146.95||8,185.16|||
|Bank charges||15.00|284.16|||
|Online Campaigns|35.62||278.98|||
|Bank charges||14.60|12,324.09|||
|Int'l Travel||229.11|17,331.35|||
|Int'l Travel||61.43|13,052.92|||
|Local Transportation||24.06|13,028.86|||
|Direct Activity Costs -  Sudan||12.96|13,015.90|||
|Int'l Travel||9.26|13,001.65|||
|Int'l Travel|6.78||13,008.43|||
|Int'l Travel||347.45|12,660.98|||
|Int'l Travel||116.82|9,397.60|||
|Direct Activity Costs -  Sudan||247.00|6,729.53|||
|Int'l Travel||397.35|4,935.85|||
|Direct Activity Costs -  Sudan||3,360.36|6,186.77        7,177.79|991.02||
|Directors Loan|600.00||6,786.77|||
|Directors Loan|600.00||-400.99|||
|Directors Loan||1,200.00|7,152.94|||
|Direct Activity Costs -  Sudan||384.05|4,132.95|||
|Events||2,105.09|11,558.64|||
|Events||64.37|11,494.27|||
|Refunds|26.64||4,216.80|||



26 



Bank charges
30.88
4,732.70
4,732.70
27

Receipt- spare 3
32

1896.89 remained to be paid from 2022
33

|**80647.48**<br>**Total Receipts & Payments Account**|-         3,777.14<br>5,641.00<br>To be spent by 30 April 2023<br>105,636.42<br>Total<br>Unrestricted<br>Spare fund 10 Spare fund 11<br>GSF South<br>Sudan<br>Advocacy Ext<br>GSF Sudan<br>Study<br>Launch<br>GSF Sudan<br>Study Ext<br>Matrix Causes<br>Fund<br>Danish Hrts<br>Institute<br>GSF Core<br>Funding<br>GSF IRM<br>Phase 1 (2023)<br>DT-Global/OTI-<br>USAID|
|---|---|
|<br>**Receipts**<br>Refunds<br>Donations<br>Online Campaigns<br>Grants<br>GiftAid (HMRC)<br>Sporting Events Campaign<br>Directors Loan<br>EasyFundraising<br>Receipt - spare 9<br>Receipt - spare 10<br>**Payments**<br>Rent<br>Direct Activity Costs - South Sudan<br>Direct Activity Costs -  Sudan<br>Direct Activity Costs -  Other<br>Int'l Travel<br>Local Transportation<br>Subscriptions / Software<br>Postage / Stationary / Office Supplies<br>Computer / IT Equipment / Hardware<br>Publications (printing,design)<br>Volunteer Expenses<br>Consultant Fees<br>Consultant Expenses<br>Accountancy Fees<br>Insurance<br>Communication<br>Govt Charges (registration fees etc)<br>Translation/Interpretation<br>Events<br>Bank charges<br>Promotion/Fundraising Costs<br>Accounting, Finance, Reporting<br>Payment - spare 23<br>Payment - spare 24<br>Payment - spare 25<br>**Net receipts / (payments)**<br>Transfers<br>Balance brought forward<br>**Balance carried forward**<br>Made up of:<br>Current account<br>Savings account<br>Cash float<br>Spare||
||26.64<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>26.64<br>0.00<br>0.00<br>0.00<br>0.00<br>3,044.10<br>3,044.10<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>587.79<br>587.79<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>109,199.14<br>3,589.36<br>38,338.97<br>25,037.00<br>11,618.24<br>3,000.00<br>0.00<br>2,020.00<br>3,633.27<br>21,962.30<br>0.00<br>0.00<br>759.25<br>759.25<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>5,000.00<br>5,000.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>320.22<br>320.22<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<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>|
||**118,937.14**<br>**13,300.72**<br>**38,338.97**<br>**25,037.00**<br>**11,618.24**<br>**3,000.00**<br>**0.00**<br>**2,046.64**<br>**3,633.27**<br>**21,962.30**<br>**0.00**<br>**0.00**|
||570.00<br>60.00<br>60.00<br>150.00<br>60.00<br>0.00<br>0.00<br>120.00<br>60.00<br>60.00<br>0.00<br>0.00<br>23,861.00<br>0.00<br>23,861.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>9,355.58<br>0.00<br>0.00<br>1,667.68<br>0.00<br>0.00<br>0.00<br>108.00<br>0.00<br>7,579.90<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>6,192.22<br>0.00<br>970.28<br>2,716.54<br>0.00<br>0.00<br>0.00<br>162.74<br>0.00<br>2,342.66<br>0.00<br>0.00<br>1,346.13<br>0.00<br>188.10<br>24.06<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>1,133.97<br>0.00<br>0.00<br>857.37<br>279.98<br>180.84<br>80.43<br>208.16<br>0.00<br>0.00<br>0.00<br>107.96<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>1,628.99<br>405.94<br>0.00<br>343.05<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>880.00<br>0.00<br>0.00<br>2,277.52<br>100.00<br>0.00<br>1,879.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>298.52<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>49,543.27<br>7,905.24<br>8,976.00<br>12,735.24<br>4,517.56<br>1,360.00<br>1,973.67<br>0.00<br>2,900.31<br>9,175.25<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<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>800.63<br>34.00<br>0.00<br>677.03<br>47.60<br>0.00<br>0.00<br>0.00<br>0.00<br>42.00<br>0.00<br>0.00<br>13.00<br>13.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>5,060.42<br>0.00<br>0.00<br>0.00<br>4,610.42<br>0.00<br>0.00<br>0.00<br>0.00<br>450.00<br>0.00<br>0.00<br>2,169.46<br>64.37<br>0.00<br>2,105.09<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>179.40<br>155.90<br>0.00<br>23.50<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>19,284.89<br>6,282.70<br>4,102.75<br>2,635.38<br>2,174.50<br>0.00<br>0.00<br>3,524.56<br>565.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<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|
||**123,139.88**<br>**15,301.13**<br>**38,338.97**<br>**25,037.00**<br>**11,618.24**<br>**1,360.00**<br>**1,973.67**<br>**3,915.30**<br>**3,633.27**<br>**21,962.30**<br>**0.00**<br>**0.00**|
||(4,202.74)<br>(2,000.41)<br>0.00<br>0.00<br>0.00<br>1,640.00<br>(1,973.67)<br>(1,868.66)<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>8,935.44<br>3,733.11<br>0.00<br>0.00<br>0.00<br>1,360.00<br>1,973.67<br>1,868.66<br>0.00<br>0.00<br>0.00<br>0.00|
||**4,732.70**<br>**1,732.70**<br>**0.00**<br>**0.00**<br>**0.00**<br>**3,000.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**<br>**0.00**|
||4,732.70<br>Transfers<br>57.00<br>0.00<br>0.00<br>0.00<br>Total income<br>115,160.00<br>**4,732.70**<br>Expenditure<br>123,112.00<br>Net receipts/payments<br>7,952.00<br>0.00<br>Brought from 2022<br>8,935.00<br>Carried forward to 2024|
|_Checks - this should equal zero_||
|||



from 2021+transferred+2022 



## **Rights for Peace 2023** 

(instructions for forecasting at the foot of this sheet) 

## **Total Cashflow** 

|**Receipts**<br>Refunds<br>Donations<br>Online Campaigns<br>Grants<br>GiftAid (HMRC)<br>Sporting Events Campaign<br>Directors Loan<br>EasyFundraising<br>Receipt - spare 9<br>Receipt - spare 10<br>**Payments**<br>Rent<br>Direct Activity Costs - South Sudan<br>Direct Activity Costs -  Sudan<br>Direct Activity Costs -  Other<br>Int'l Travel<br>Local Transportation<br>Subscriptions / Software<br>Postage / Stationary / Office Supplies<br>Computer / IT Equipment / Hardware<br>Publications (printing,design)<br>Volunteer Expenses<br>Consultant Fees<br>Consultant Expenses<br>Accountancy Fees<br>Insurance<br>Communication<br>Govt Charges (registration fees etc)<br>Translation/Interpretation<br>Events<br>Bank charges<br>Promotion/Fundraising Costs<br>Accounting, Finance, Reporting<br>Payment - spare 23<br>Payment - spare 24<br>Payment - spare 25<br>**Net receipts / (payments)**<br>Transfers<br>Balance brought forward<br>**Rolling balance**<br>Made up of:<br>Current account<br>Savings account<br>Cash float<br>Spare<br>_Checks - this should equal zero_|Total<br>January<br>February<br>March<br>April<br>May<br>June<br>July<br>August<br>September<br>October<br>November<br>December|
|---|---|
||26.64<br>0.00<br>0.00<br>26.64<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>3,044.10<br>225.00<br>0.00<br>0.00<br>2,005.00<br>14.10<br>500.00<br>0.00<br>0.00<br>0.00<br>300.00<br>0.00<br>0.00<br>587.79<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>182.57<br>0.00<br>0.00<br>9.61<br>0.00<br>395.61<br>109,199.14<br>11,484.37<br>0.00<br>0.00<br>37,343.96<br>0.00<br>10,898.00<br>0.00<br>22,339.00<br>1,645.70<br>7,349.00<br>0.00<br>18,139.11<br>759.25<br>0.00<br>56.25<br>0.00<br>0.00<br>453.00<br>250.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>5,000.00<br>0.00<br>0.00<br>0.00<br>(2,000.00)<br>0.00<br>0.00<br>7,000.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>320.22<br>0.00<br>195.53<br>0.00<br>0.00<br>95.76<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>28.93<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|
||**118,937.14**<br>**11,709.37**<br>**251.78**<br>**26.64**<br>**37,348.96**<br>**562.86**<br>**11,648.00**<br>**7,182.57**<br>**22,339.00**<br>**1,645.70**<br>**7,658.61**<br>**28.93**<br>**18,534.72**|
||570.00<br>0.00<br>150.00<br>0.00<br>0.00<br>0.00<br>120.00<br>60.00<br>0.00<br>60.00<br>60.00<br>60.00<br>60.00<br>23,861.00<br>0.00<br>0.00<br>0.00<br>0.00<br>15,973.50<br>0.00<br>7,887.50<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>9,355.58<br>1,635.76<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>1,133.00<br>12.96<br>521.72<br>6,052.14<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>6,192.22<br>728.34<br>492.71<br>0.00<br>82.80<br>0.00<br>487.98<br>0.00<br>0.00<br>482.30<br>640.47<br>3,277.62<br>0.00<br>1,346.13<br>1,133.97<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>188.10<br>24.06<br>0.00<br>0.00<br>857.37<br>251.21<br>34.37<br>50.47<br>53.57<br>53.57<br>53.57<br>60.77<br>19.97<br>19.97<br>19.97<br>19.97<br>219.96<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>1,628.99<br>880.00<br>0.00<br>0.00<br>0.00<br>0.00<br>405.94<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>343.05<br>2,277.52<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>1,979.00<br>0.00<br>298.52<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>49,543.27<br>3,850.00<br>4,550.00<br>2,220.00<br>1,214.50<br>9,893.11<br>7,780.00<br>5,126.00<br>0.00<br>4,226.00<br>2,704.34<br>2,040.25<br>5,939.07<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<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>800.63<br>123.60<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>4.99<br>672.04<br>0.00<br>13.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>13.00<br>5,060.42<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>3,735.42<br>875.00<br>450.00<br>0.00<br>0.00<br>2,169.46<br>2,169.46<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>179.40<br>0.00<br>0.00<br>71.50<br>12.69<br>34.74<br>30.87<br>15.00<br>0.00<br>14.60<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>19,284.89<br>0.00<br>0.00<br>2,765.63<br>0.00<br>5,188.01<br>3,275.00<br>2,700.00<br>0.00<br>2,700.00<br>1,375.00<br>625.00<br>656.25<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<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|
||**123,139.88**<br>**10,772.34**<br>**5,227.08**<br>**5,107.60**<br>**1,363.56**<br>**31,142.93**<br>**12,153.36**<br>**15,849.27**<br>**3,755.39**<br>**9,698.97**<br>**7,270.79**<br>**7,216.60**<br>**13,581.99**|
||(4,202.74)<br>937.03<br>(4,975.30)<br>(5,080.96)<br>35,985.40<br>(30,580.07)<br>(505.36)<br>(8,666.70)<br>18,583.61<br>(8,053.27)<br>387.82<br>(7,187.67)<br>4,952.73<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>8,935.44<br>8,935.44<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|
||**4,732.70**<br>**9,872.47**<br>**4,897.17**<br>**(183.79)**<br>**35,801.61**<br>**5,221.54**<br>**4,716.18**<br>**(3,950.52)**<br>**14,633.09**<br>**6,579.82**<br>**6,967.64**<br>**(220.03)**<br>**4,732.70**|
||**Errors**<br>4,732.70<br>1 All entries on row 49 should be zero (except in B49 and C49),<br>0.00<br>because all balances are brought forward on the first day of the year.<br>0.00<br>2 If any figures on row 49 are in a red cell, please review and correct.<br>0.00<br>**4,732.70**<br>**How to forecast forward from here**<br>1 Right click on the "Total Cashflow" tab at the foot of this sheet.<br>0.00<br>2 Select Move or Copy…|



- 2 Select Move or Copy… 

- 3 In the dialogue box at the top "To book" select "(new book)" 

4 Make sure you tick the create a copy box You now have the actual cashbook figures on a new spreadsheet. Where months' actual figures are nil and they are future months, overwrite these with your forecast for each row of receipts and payments. Remember to be prudent and realistic eg. Furloughed staff will still cost 80% and grant income won't come in until May at the earliest. Save your work! Extend for future months by entering month names at the top of each column eg June 2020, July 2020 etc Remember to copy totalling formulae on Rows 17,44 and 50. 

- 5  Enter your forecasts for each row and each month, either by typing in a figure or using a formula. 

**Contact for support: claire.welling@wycas.org.uk** 



## **Rights for Peace 2023** 

|**Receipts & Payments Account**<br>**Receipts**<br>Refunds<br>Donations<br>Online Campaigns<br>Grants<br>GiftAid (HMRC)<br>Sporting Events Campaign<br>Directors Loan<br>EasyFundraising<br>Receipt - spare 9<br>Receipt - spare 10<br>**Payments**<br>Rent<br>Direct Activity Costs - South Sudan<br>Direct Activity Costs -  Sudan<br>Direct Activity Costs -  Other<br>Int'l Travel<br>Local Transportation<br>Subscriptions / Software<br>Postage / Stationary / Office Supplies<br>Computer / IT Equipment / Hardware<br>Publications (printing,design)<br>Volunteer Expenses<br>Consultant Fees<br>Consultant Expenses<br>Accountancy Fees<br>Insurance<br>Communication<br>Govt Charges (registration fees etc)<br>Translation/Interpretation<br>Events<br>Bank charges<br>Promotion/Fundraising Costs|**Current account**<br>Total<br>Unrestricted<br>GSF South<br>Sudan<br>~~Ad Et~~|
|---|---|
||26.64<br>0.00<br>0.00<br>3,044.10<br>3,044.10<br>0.00<br>587.79<br>587.79<br>0.00<br>109,199.14<br>3,589.36<br>38,338.97<br>759.25<br>759.25<br>0.00<br>0.00<br>0.00<br>0.00<br>5,000.00<br>5,000.00<br>0.00<br>320.22<br>320.22<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>~~vocacy x~~|
||**118,937.14**<br>**13,300.72**<br>**38,338.97**|
||570.00<br>60.00<br>60.00<br>23,861.00<br>0.00<br>23,861.00<br>9,355.58<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>6,192.22<br>0.00<br>970.28<br>1,346.13<br>0.00<br>188.10<br>857.37<br>279.98<br>180.84<br>0.00<br>0.00<br>0.00<br>1,628.99<br>405.94<br>0.00<br>2,277.52<br>100.00<br>0.00<br>0.00<br>0.00<br>0.00<br>49,543.27<br>7,905.24<br>8,976.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>800.63<br>34.00<br>0.00<br>13.00<br>13.00<br>0.00<br>5,060.42<br>0.00<br>0.00<br>2,169.46<br>64.37<br>0.00<br>179.40<br>155.90<br>0.00<br>0.00<br>0.00<br>0.00|





|Accounting, Finance, Reporting<br>Payment - spare 23<br>Payment - spare 24<br>Payment - spare 25<br>**Net receipts / (payments)**<br>Transfers<br>Balance brought forward<br>**Balance carried forward**<br>_Checks - this should equal zero_|19,284.89<br>6,282.70<br>4,102.75<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|
|---|---|
||**123,139.88**<br>**15,301.13**<br>**38,338.97**|
||(4,202.74)<br>(2,000.41)<br>0.00<br>0.00<br>0.00<br>0.00<br>8,935.44<br>3,733.11<br>0.00|
||**4,732.70**<br>**1,732.70**<br>**0.00**|
||0.00|





|GSF Sudan|GSF Sudan|Matrix Causes|Danish Hrts|GSF Core|
|---|---|---|---|---|
|StudyLaunch|StudyExt|Fund|Institute|Funding|
|0.00|0.00|0.00|0.00|26.64|
|0.00|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|0.00|
|25,037.00|11,618.24|3,000.00|0.00|2,020.00|
|0.00|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|0.00|
|**25,037.00**|**11,618.24**|**3,000.00**|**0.00**|**2,046.64**|
|150.00|60.00|0.00|0.00|120.00|
|0.00|0.00|0.00|0.00|0.00|
|1,667.68|0.00|0.00|0.00|108.00|
|0.00|0.00|0.00|0.00|0.00|
|2,716.54|0.00|0.00|0.00|162.74|
|24.06|0.00|0.00|0.00|0.00|
|80.43|208.16|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|0.00|
|343.05|0.00|0.00|0.00|0.00|
|1,879.00|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|0.00|
|12,735.24|4,517.56|1,360.00|1,973.67|0.00|
|0.00|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|0.00|
|677.03|47.60|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|0.00|
|0.00|4,610.42|0.00|0.00|0.00|
|2,105.09|0.00|0.00|0.00|0.00|
|23.50|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|0.00|





|2,635.38|2,174.50|0.00|0.00|3,524.56|
|---|---|---|---|---|
|0.00|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|0.00|
|**25,037.00**|**11,618.24**|**1,360.00**|**1,973.67**|**3,915.30**|
|0.00|0.00|1,640.00|(1,973.67)|(1,868.66)|
|0.00|0.00|0.00|0.00|0.00|
|0.00|0.00|1,360.00|1,973.67|1,868.66|
|**0.00**|**0.00**|**3,000.00**|**0.00**|**0.00**|





GSF IRM DT-Global/OTISpare fund 10 Spare fund 11 Phase 1 (2023) ~~USAID~~ 

|0.00|0.00|0.00|0.00|
|---|---|---|---|
|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|
|3,633.27|21,962.30|0.00|0.00|
|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|
|**3,633.27**|**21,962.30**|**0.00**|**0.00**|
|60.00|60.00|0.00|0.00|
|0.00|0.00|0.00|0.00|
|0.00|7,579.90|0.00|0.00|
|0.00|0.00|0.00|0.00|
|0.00|2,342.66|0.00|0.00|
|0.00|1,133.97|0.00|0.00|
|107.96|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|
|0.00|880.00|0.00|0.00|
|0.00|298.52|0.00|0.00|
|0.00|0.00|0.00|0.00|
|2,900.31|9,175.25|0.00|0.00|
|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|
|0.00|42.00|0.00|0.00|
|0.00|0.00|0.00|0.00|
|0.00|450.00|0.00|0.00|
|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|





|565.00|0.00|0.00|0.00|
|---|---|---|---|
|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|
|**3,633.27**|**21,962.30**|**0.00**|**0.00**|
|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|
|0.00|0.00|0.00|0.00|
|**0.00**|**0.00**|**0.00**|**0.00**|





## **Rights for Peace 2023** 

## WARNING: ERROR IN SHEET 

## **Total Receipts & Payments Account for the year ended 31/12/2023** 

|**Receipts**<br>Refunds<br>Donations<br>Online Campaigns<br>Grants<br>GiftAid (HMRC)<br>Sporting Events Campaign<br>Directors Loan<br>EasyFundraising|Unrestricted<br>Restricted<br>Total<br>-<br>26.64<br>26.64<br>3,044.10<br>-<br>3,044.10<br>587.79<br>-<br>587.79<br>3,589.36<br>105,609.78<br>109,199.14<br>759.25<br>-<br>759.25<br>-<br>-<br>-<br>-<br>-<br>-<br>320.22<br>-<br>320.22<br>**8,300.72**<br>**105,636.42**<br>**113,937.14**<br>60.00<br>510.00<br>570.00<br>-<br>23,861.00<br>23,861.00<br>-<br>9,355.58<br>9,355.58<br>-<br>-<br>-<br>-<br>6,192.22<br>6,192.22<br>-<br>1,346.13<br>1,346.13<br>279.98<br>577.39<br>857.37<br>-<br>-<br>-<br>405.94<br>1,223.05<br>1,628.99<br>100.00<br>2,177.52<br>2,277.52<br>-<br>-<br>-<br>7,905.24<br>41,638.03<br>49,543.27<br>-<br>-<br>-<br>-<br>-<br>-<br>-<br>-<br>-<br>34.00<br>766.63<br>800.63<br>13.00<br>-<br>13.00<br>-<br>5,060.42<br>5,060.42<br>64.37<br>2,105.09<br>2,169.46<br>155.90<br>23.50<br>179.40<br>-<br>-<br>-<br>6,282.70<br>13,002.19<br>19,284.89<br>**15,301.13**<br>**107,838.75**<br>**123,139.88**<br>**(7,000.41)**<br>**(2,202.33)**<br>**(9,202.74)**<br>-<br>-<br>-<br>3,733.11<br>5,202.33<br>8,935.44<br>**(3,267.30)**<br>**3,000.00**<br>**(267.30)**<br>4,732.70<br>-<br>-<br>-<br>**4,732.70**<br>_-5,000.00_(Directors loan)|Previousyear|
|---|---|---|
|||1,283.62<br>735.76<br>162,589.03<br>125.65<br>**164,734.06**<br>2,200.00<br>64,916.64<br>14,316.11<br>4,132.39<br>264.19<br>560.64<br>101.56<br>777.98<br>80.00<br>75,391.26<br>850.00<br>36.00<br>13.00<br>5,579.60<br>161.80<br>600.59<br>10.00<br>**169,991.76**|
|**Total receipts**<br>**Payments**<br>Rent<br>Direct Activity Costs - South Sudan<br>Direct Activity Costs -  Sudan<br>Direct Activity Costs -  Other<br>Int'l Travel<br>Local Transportation<br>Subscriptions / Software<br>Postage / Stationary / Office Supplies<br>Computer / IT Equipment / Hardware<br>Publications (printing,design)<br>Volunteer Expenses<br>Consultant Fees<br>Consultant Expenses<br>Accountancy Fees<br>Insurance<br>Communication<br>Govt Charges (registration fees etc)<br>Translation/Interpretation<br>Events<br>Bank charges<br>Promotion/Fundraising Costs<br>Accounting,Finance,Reporting|||
|**Total payments**|||
|**Net receipts / (payments)**<br>Transfers<br>Balance brought forward||**(5,257.70)**<br>-<br>14,193.15|
|**Balance carried forward**<br>Made up of:<br>Current account<br>Savings account<br>Cash float<br>Spare<br>_Checks - this should equal zero_||**8,935.45**|
||||



## **Approval of the accounts** 

The financial statements were approved at a meeting of the management committee and signed on its behalf 

Signed:  …………………………………… 

Name  ………………………………………  (Management Committee member) 

Date:  ……………………………………… 



## **Journal:** 

## **END OF YEAR JOURNALS 31st December 2022** 

||**Date paid / received**<br>**(bank statement)**|**Date paid / received**<br>**(bank statement)**||
|---|---|---|---|
|||||
|**1. December 2022 Consultancy Fees paid in March 2023**<br>**after receipt of final 20% of GSF SS (2022) Grant:**||||
|- VT Dec Fee<br>- VT Dec Fee<br>- VT Dec Fee<br>- MG Sept Fee<br>- MG Oct Fee<br>- MG Nov Fee<br>- MG Nov Fee<br>- MW Dec Fee<br>- NA Nov & Dec||8-Mar-23<br>8-Mar-23<br>8-Mar-23<br>8-Mar-23<br>8-Mar-23<br>8-Mar-23<br>8-Mar-23<br>8-Mar-23<br>8-Mar-23||
|**2. Late Payments made in 2023 that pertain to 2022 accounts**||||
|MG Per diem for December 2022 trip to Juba $150<br>MG Juba return flight in December 2022<br>Accounting Fee for Ariana Accountants 2022 Accounts||22-Dec-23<br>22-Dec-23<br>4-Sep-23|**Paid in 1 transaction of £1021**<br>**on 22 December 2023**|
|**5.  Income received in 2023 that is reflected in 2022 accounts:**||||
|GSF South Sudan Advocacy 2022 Grant final 20% (£19,468.97)||8-Mar-23|**Total £19,468.97 receieved on**|





**, 8 March as the final 20% of the 2022 GSF South Sudan Advocacy grant** GSF South Sudan (Core Fund portion) 8-Mar-23 GSF Core Funding GSF Sudan Study Closing Grant income GSF Sudan Study Gift Aid on Jan 2023 donations (Kat + MG) were claimed on the Gift Aid on 2022 donations (claimed in 2023) 1-Feb-23 same day, not to be confused! Donations 



|**Account**<br>Consultancy<br>Consultancy<br>Consultancy<br>Consultancy<br>Consultancy<br>Consultancy<br>Consultancy<br>Consultancy<br>Consultancy<br>Accounting<br>Grant Income<br>Direct Activity<br>Cost<br>Direct Activity<br>Cost|**Amount**<br>1,200.00<br>640.00<br>360.00<br>-23.50<br>900.00<br>900.00<br>900.00<br>1,320.00<br>1,280.00<br>3,000.00<br>3,000.00<br>124.79<br>897.10<br>1,021.89<br>875.00<br>**1,896.89**<br>**12,396.89**<br>10,801.31|
|---|---|



12 



Unrestricted Income 8,667.66 Grant Income 1,475.62 Unrestricted Income 219.17 **21,163.76** 8,766.87 -153.40 



## Directorr's loan 

24-Jul-23 **£           7,000.00** income as "director's loan" **£           2,000.00** donation