| Organisation's Name | Rights For Peace Ltd | |
|---|---|---|
| Last day in financialyear | 31/12/2023 | |
| Funds Unrestricted Rent Fund GSF South Sudan Advocacy Ext GSF Sudan Study Launch GSF Sudan Study Ext Matrix Causes Fund Danish Hrts Institute GSF Core Funding GSF IRM Phase 1 (2023) DT-Global/OTI-USAID Spare fund 10 Spare fund 11 Months(from first in FY) January February March April May June July August September October November December |
Categories Balance brought forward Transfers Refunds Donations Online Campaigns Grants GiftAid (HMRC) Sporting Events Campaign Directors Loan EasyFundraising Receipt - spare 9 Receipt - spare 10 Rent Direct Activity Costs - South Sudan Direct Activity Costs - Sudan Direct Activity Costs - Other Int'l Travel Local Transportation Subscriptions / Software Postage / Stationary / Office Supplies Computer / IT Equipment / Hardware Publications (printing,design) Volunteer Expenses Consultant Fees Consultant Expenses Accountancy Fees Insurance Communication Govt Charges (registration fees etc) Translation/Interpretation Events Bank charges Promotion/Fundraising Costs Accounting, Finance, Reporting Payment - spare 23 Payment - spare 24 Payment - spare 25 |
|
| Categories | ||
| Balance brought forward Transfers |
||
| Refunds Donations Online Campaigns Grants GiftAid (HMRC) Sporting Events Campaign Directors Loan EasyFundraising Receipt - spare 9 Receipt - spare 10 |
||
| Rent Direct Activity Costs - South Sudan |
||
| Direct Activity Costs - Sudan | ||
| Direct Activity Costs - Other Int'l Travel Local Transportation Subscriptions / Software Postage / Stationary / Office Supplies Computer / IT Equipment / Hardware Publications (printing,design) Volunteer Expenses Consultant Fees Consultant Expenses Accountancy Fees Insurance Communication Govt Charges (registration fees etc) Translation/Interpretation Events Bank charges Promotion/Fundraising Costs Accounting, Finance, Reporting Payment - spare 23 Payment - spare 24 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 Total Receipts & Payments Account |
- 3,777.14 5,641.00 To be spent by 30 April 2023 105,636.42 Total Unrestricted Spare fund 10 Spare fund 11 GSF South Sudan Advocacy Ext GSF Sudan Study Launch GSF Sudan Study Ext Matrix Causes Fund Danish Hrts Institute GSF Core Funding GSF IRM Phase 1 (2023) DT-Global/OTI- USAID |
|---|---|
Receipts Refunds Donations Online Campaigns Grants GiftAid (HMRC) Sporting Events Campaign Directors Loan EasyFundraising Receipt - spare 9 Receipt - spare 10 Payments Rent Direct Activity Costs - South Sudan Direct Activity Costs - Sudan Direct Activity Costs - Other Int'l Travel Local Transportation Subscriptions / Software Postage / Stationary / Office Supplies Computer / IT Equipment / Hardware Publications (printing,design) Volunteer Expenses Consultant Fees Consultant Expenses Accountancy Fees Insurance Communication Govt Charges (registration fees etc) Translation/Interpretation Events Bank charges Promotion/Fundraising Costs Accounting, Finance, Reporting Payment - spare 23 Payment - spare 24 Payment - spare 25 Net receipts / (payments) Transfers Balance brought forward Balance carried forward Made up of: Current account Savings account Cash float Spare |
|
| 26.64 0.00 0.00 0.00 0.00 0.00 0.00 26.64 0.00 0.00 0.00 0.00 3,044.10 3,044.10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 587.79 587.79 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 109,199.14 3,589.36 38,338.97 25,037.00 11,618.24 3,000.00 0.00 2,020.00 3,633.27 21,962.30 0.00 0.00 759.25 759.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5,000.00 5,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 320.22 320.22 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 |
|
| 118,937.14 13,300.72 38,338.97 25,037.00 11,618.24 3,000.00 0.00 2,046.64 3,633.27 21,962.30 0.00 0.00 |
|
| 570.00 60.00 60.00 150.00 60.00 0.00 0.00 120.00 60.00 60.00 0.00 0.00 23,861.00 0.00 23,861.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 9,355.58 0.00 0.00 1,667.68 0.00 0.00 0.00 108.00 0.00 7,579.90 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6,192.22 0.00 970.28 2,716.54 0.00 0.00 0.00 162.74 0.00 2,342.66 0.00 0.00 1,346.13 0.00 188.10 24.06 0.00 0.00 0.00 0.00 0.00 1,133.97 0.00 0.00 857.37 279.98 180.84 80.43 208.16 0.00 0.00 0.00 107.96 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,628.99 405.94 0.00 343.05 0.00 0.00 0.00 0.00 0.00 880.00 0.00 0.00 2,277.52 100.00 0.00 1,879.00 0.00 0.00 0.00 0.00 0.00 298.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 49,543.27 7,905.24 8,976.00 12,735.24 4,517.56 1,360.00 1,973.67 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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 800.63 34.00 0.00 677.03 47.60 0.00 0.00 0.00 0.00 42.00 0.00 0.00 13.00 13.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5,060.42 0.00 0.00 0.00 4,610.42 0.00 0.00 0.00 0.00 450.00 0.00 0.00 2,169.46 64.37 0.00 2,105.09 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 179.40 155.90 0.00 23.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 19,284.89 6,282.70 4,102.75 2,635.38 2,174.50 0.00 0.00 3,524.56 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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 |
|
| 123,139.88 15,301.13 38,338.97 25,037.00 11,618.24 1,360.00 1,973.67 3,915.30 3,633.27 21,962.30 0.00 0.00 |
|
| (4,202.74) (2,000.41) 0.00 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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 8,935.44 3,733.11 0.00 0.00 0.00 1,360.00 1,973.67 1,868.66 0.00 0.00 0.00 0.00 |
|
| 4,732.70 1,732.70 0.00 0.00 0.00 3,000.00 0.00 0.00 0.00 0.00 0.00 0.00 |
|
| 4,732.70 Transfers 57.00 0.00 0.00 0.00 Total income 115,160.00 4,732.70 Expenditure 123,112.00 Net receipts/payments 7,952.00 0.00 Brought from 2022 8,935.00 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 Refunds Donations Online Campaigns Grants GiftAid (HMRC) Sporting Events Campaign Directors Loan EasyFundraising Receipt - spare 9 Receipt - spare 10 Payments Rent Direct Activity Costs - South Sudan Direct Activity Costs - Sudan Direct Activity Costs - Other Int'l Travel Local Transportation Subscriptions / Software Postage / Stationary / Office Supplies Computer / IT Equipment / Hardware Publications (printing,design) Volunteer Expenses Consultant Fees Consultant Expenses Accountancy Fees Insurance Communication Govt Charges (registration fees etc) Translation/Interpretation Events Bank charges Promotion/Fundraising Costs Accounting, Finance, Reporting Payment - spare 23 Payment - spare 24 Payment - spare 25 Net receipts / (payments) Transfers Balance brought forward Rolling balance Made up of: Current account Savings account Cash float Spare Checks - this should equal zero |
Total January February March April May June July August September October November December |
|---|---|
| 26.64 0.00 0.00 26.64 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,044.10 225.00 0.00 0.00 2,005.00 14.10 500.00 0.00 0.00 0.00 300.00 0.00 0.00 587.79 0.00 0.00 0.00 0.00 0.00 0.00 182.57 0.00 0.00 9.61 0.00 395.61 109,199.14 11,484.37 0.00 0.00 37,343.96 0.00 10,898.00 0.00 22,339.00 1,645.70 7,349.00 0.00 18,139.11 759.25 0.00 56.25 0.00 0.00 453.00 250.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5,000.00 0.00 0.00 0.00 (2,000.00) 0.00 0.00 7,000.00 0.00 0.00 0.00 0.00 0.00 320.22 0.00 195.53 0.00 0.00 95.76 0.00 0.00 0.00 0.00 0.00 28.93 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 |
|
| 118,937.14 11,709.37 251.78 26.64 37,348.96 562.86 11,648.00 7,182.57 22,339.00 1,645.70 7,658.61 28.93 18,534.72 |
|
| 570.00 0.00 150.00 0.00 0.00 0.00 120.00 60.00 0.00 60.00 60.00 60.00 60.00 23,861.00 0.00 0.00 0.00 0.00 15,973.50 0.00 7,887.50 0.00 0.00 0.00 0.00 0.00 9,355.58 1,635.76 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,133.00 12.96 521.72 6,052.14 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6,192.22 728.34 492.71 0.00 82.80 0.00 487.98 0.00 0.00 482.30 640.47 3,277.62 0.00 1,346.13 1,133.97 0.00 0.00 0.00 0.00 0.00 0.00 0.00 188.10 24.06 0.00 0.00 857.37 251.21 34.37 50.47 53.57 53.57 53.57 60.77 19.97 19.97 19.97 19.97 219.96 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,628.99 880.00 0.00 0.00 0.00 0.00 405.94 0.00 0.00 0.00 0.00 0.00 343.05 2,277.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,979.00 0.00 298.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 49,543.27 3,850.00 4,550.00 2,220.00 1,214.50 9,893.11 7,780.00 5,126.00 0.00 4,226.00 2,704.34 2,040.25 5,939.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 800.63 123.60 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4.99 672.04 0.00 13.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 13.00 5,060.42 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,735.42 875.00 450.00 0.00 0.00 2,169.46 2,169.46 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 179.40 0.00 0.00 71.50 12.69 34.74 30.87 15.00 0.00 14.60 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 19,284.89 0.00 0.00 2,765.63 0.00 5,188.01 3,275.00 2,700.00 0.00 2,700.00 1,375.00 625.00 656.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 |
|
| 123,139.88 10,772.34 5,227.08 5,107.60 1,363.56 31,142.93 12,153.36 15,849.27 3,755.39 9,698.97 7,270.79 7,216.60 13,581.99 |
|
| (4,202.74) 937.03 (4,975.30) (5,080.96) 35,985.40 (30,580.07) (505.36) (8,666.70) 18,583.61 (8,053.27) 387.82 (7,187.67) 4,952.73 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 8,935.44 8,935.44 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 |
|
| 4,732.70 9,872.47 4,897.17 (183.79) 35,801.61 5,221.54 4,716.18 (3,950.52) 14,633.09 6,579.82 6,967.64 (220.03) 4,732.70 |
|
| Errors 4,732.70 1 All entries on row 49 should be zero (except in B49 and C49), 0.00 because all balances are brought forward on the first day of the year. 0.00 2 If any figures on row 49 are in a red cell, please review and correct. 0.00 4,732.70 How to forecast forward from here 1 Right click on the "Total Cashflow" tab at the foot of this sheet. 0.00 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 Receipts Refunds Donations Online Campaigns Grants GiftAid (HMRC) Sporting Events Campaign Directors Loan EasyFundraising Receipt - spare 9 Receipt - spare 10 Payments Rent Direct Activity Costs - South Sudan Direct Activity Costs - Sudan Direct Activity Costs - Other Int'l Travel Local Transportation Subscriptions / Software Postage / Stationary / Office Supplies Computer / IT Equipment / Hardware Publications (printing,design) Volunteer Expenses Consultant Fees Consultant Expenses Accountancy Fees Insurance Communication Govt Charges (registration fees etc) Translation/Interpretation Events Bank charges Promotion/Fundraising Costs |
Current account Total Unrestricted GSF South Sudan ~~Ad Et~~ |
|---|---|
| 26.64 0.00 0.00 3,044.10 3,044.10 0.00 587.79 587.79 0.00 109,199.14 3,589.36 38,338.97 759.25 759.25 0.00 0.00 0.00 0.00 5,000.00 5,000.00 0.00 320.22 320.22 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ~~vocacy x~~ |
|
| 118,937.14 13,300.72 38,338.97 |
|
| 570.00 60.00 60.00 23,861.00 0.00 23,861.00 9,355.58 0.00 0.00 0.00 0.00 0.00 6,192.22 0.00 970.28 1,346.13 0.00 188.10 857.37 279.98 180.84 0.00 0.00 0.00 1,628.99 405.94 0.00 2,277.52 100.00 0.00 0.00 0.00 0.00 49,543.27 7,905.24 8,976.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 800.63 34.00 0.00 13.00 13.00 0.00 5,060.42 0.00 0.00 2,169.46 64.37 0.00 179.40 155.90 0.00 0.00 0.00 0.00 |
| Accounting, Finance, Reporting Payment - spare 23 Payment - spare 24 Payment - spare 25 Net receipts / (payments) Transfers Balance brought forward Balance carried forward Checks - this should equal zero |
19,284.89 6,282.70 4,102.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 |
|---|---|
| 123,139.88 15,301.13 38,338.97 |
|
| (4,202.74) (2,000.41) 0.00 0.00 0.00 0.00 8,935.44 3,733.11 0.00 |
|
| 4,732.70 1,732.70 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 Refunds Donations Online Campaigns Grants GiftAid (HMRC) Sporting Events Campaign Directors Loan EasyFundraising |
Unrestricted Restricted Total - 26.64 26.64 3,044.10 - 3,044.10 587.79 - 587.79 3,589.36 105,609.78 109,199.14 759.25 - 759.25 - - - - - - 320.22 - 320.22 8,300.72 105,636.42 113,937.14 60.00 510.00 570.00 - 23,861.00 23,861.00 - 9,355.58 9,355.58 - - - - 6,192.22 6,192.22 - 1,346.13 1,346.13 279.98 577.39 857.37 - - - 405.94 1,223.05 1,628.99 100.00 2,177.52 2,277.52 - - - 7,905.24 41,638.03 49,543.27 - - - - - - - - - 34.00 766.63 800.63 13.00 - 13.00 - 5,060.42 5,060.42 64.37 2,105.09 2,169.46 155.90 23.50 179.40 - - - 6,282.70 13,002.19 19,284.89 15,301.13 107,838.75 123,139.88 (7,000.41) (2,202.33) (9,202.74) - - - 3,733.11 5,202.33 8,935.44 (3,267.30) 3,000.00 (267.30) 4,732.70 - - - 4,732.70 -5,000.00(Directors loan) |
Previousyear |
|---|---|---|
| 1,283.62 735.76 162,589.03 125.65 164,734.06 2,200.00 64,916.64 14,316.11 4,132.39 264.19 560.64 101.56 777.98 80.00 75,391.26 850.00 36.00 13.00 5,579.60 161.80 600.59 10.00 169,991.76 |
||
| Total receipts Payments Rent Direct Activity Costs - South Sudan Direct Activity Costs - Sudan Direct Activity Costs - Other Int'l Travel Local Transportation Subscriptions / Software Postage / Stationary / Office Supplies Computer / IT Equipment / Hardware Publications (printing,design) Volunteer Expenses Consultant Fees Consultant Expenses Accountancy Fees Insurance Communication Govt Charges (registration fees etc) Translation/Interpretation Events Bank charges Promotion/Fundraising Costs Accounting,Finance,Reporting |
||
| Total payments | ||
| Net receipts / (payments) Transfers Balance brought forward |
(5,257.70) - 14,193.15 |
|
| Balance carried forward Made up of: Current account Savings account Cash float Spare 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 (bank statement) |
Date paid / received (bank statement) |
||
|---|---|---|---|
| 1. December 2022 Consultancy Fees paid in March 2023 after receipt of final 20% of GSF SS (2022) Grant: |
|||
| - VT Dec Fee - VT Dec Fee - VT Dec Fee - MG Sept Fee - MG Oct Fee - MG Nov Fee - MG Nov Fee - MW Dec Fee - NA Nov & Dec |
8-Mar-23 8-Mar-23 8-Mar-23 8-Mar-23 8-Mar-23 8-Mar-23 8-Mar-23 8-Mar-23 8-Mar-23 |
||
| 2. Late Payments made in 2023 that pertain to 2022 accounts | |||
| MG Per diem for December 2022 trip to Juba $150 MG Juba return flight in December 2022 Accounting Fee for Ariana Accountants 2022 Accounts |
22-Dec-23 22-Dec-23 4-Sep-23 |
Paid in 1 transaction of £1021 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 Consultancy Consultancy Consultancy Consultancy Consultancy Consultancy Consultancy Consultancy Consultancy Accounting Grant Income Direct Activity Cost Direct Activity Cost |
Amount 1,200.00 640.00 360.00 -23.50 900.00 900.00 900.00 1,320.00 1,280.00 3,000.00 3,000.00 124.79 897.10 1,021.89 875.00 1,896.89 12,396.89 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