190x Filetype XLSX File size 0.53 MB Source: www.charities.govt.nz
How to use this tool 1) Set your financial year in the SORP column. The beginning date should be the first day of the financial year while the ending date should be the last day of your financial year. 2) Manually enter the bank balance at the beginning of the year in cell Q35 of the "SORP" tab 3) Download your digital bank statement from your online banking and copy the transactions or manually key in the transactions from your bank statement into the "Bank Statement" tab for each month. To ensure you can identify your transactions complete the following details in cells A to G a) Date of transaction b) Amount of transaction (ensure that all payments are negative numbers) c) The other party to the transaction d) Reference fields In column I of the bank statement tab select the drop down icon in the grey cell of the transaction row you want to classify and select the relevant receipt of 4) payment category. Go to the "SORP" tab for your completed statement of receipts and payments once all transactions are classified. Enter your bank balance at year end in cell Q39. If 5) you have included and classified all payments you should get an OK message in cell Q40 otherwise you will get an error message. *Note; This tool comes prepopulated with an example so you can see how it works. Delete the data in the white cells of the "Bank Statement" tabs before you begin using this spreadsheet to classify your transactions Set your financial year in the SORP column. The beginning date should be the first day of the financial year while the ending date should be the last day of your financial year. Download your digital bank statement from your online banking and copy the transactions or manually key in the transactions from your bank statement into the "Bank Statement" tab for each month. To ensure you can identify your transactions complete the following details in cells A to G In column I of the bank statement tab select the drop down icon in the grey cell of the transaction row you want to classify and select the relevant receipt of Go to the "SORP" tab for your completed statement of receipts and payments once all transactions are classified. Enter your bank balance at year end in cell Q39. If you have included and classified all payments you should get an OK message in cell Q40 otherwise you will get an error message. *Note; This tool comes prepopulated with an example so you can see how it works. Delete the data in the white cells of the "Bank Statement" tabs before you begin using this spreadsheet to classify your *Note; This tool comes prepopulated with an example so you can see how it works. Delete the data in the white cells of the "Bank Statement" tabs before you begin using this spreadsheet to classify your Financial year Beginning Ending Day 1 31 Month April March Year 2018 2019 April May June July August September October November December January February March Total Operating Receipts Donations, Fundraising and other similar receipts $ 15,500 $ - $ - $ - $ - $ - $ 1,000 $ - $ 300 $ - $ 100 $ - $ 16,900 Fees, subscriptions and other receipts from members $ - $ - $ - $ - $ 1,000 $ - $ - $ - $ - $ - $ - $ - $ 1,000 Receipts from providing goods or services $ 250 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 200 $ - $ 450 Interest, dividends and other investment income receipts $ - $ - $ 5 $ - $ - $ - $ - $ - $ - $ - $ - $ 5 $ 10 Other operating receipts $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Less Operating Payments Payments related to public fundraising $ - -$ 100 $ - $ - $ - -$ 200 $ - $ - $ - -$ 500 $ - $ - -$ 800 Volunteer and employee related payments -$ 1,000 -$ 1,000 -$ 1,015 -$ 1,000 -$ 1,000 -$ 1,000 -$ 1,000 -$ 1,100 -$ 1,200 -$ 1,000 -$ 1,000 -$ 1,015 -$ 12,330 Payments related to providing goods or services $ - -$ 50 $ - $ - $ - $ - $ - -$ 1,500 $ - -$ 850 $ - $ - -$ 2,400 Grants and donations made $ - $ - $ - $ - $ - $ - -$ 500 $ - $ - $ - $ - -$ 1,000 -$ 1,500 Other operating payments $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Operating Surplus/(Deficit) $ 14,750 -$ 1,150 -$ 1,010 -$ 1,000 $ - -$ 1,200 -$ 500 -$ 2,600 -$ 900 -$ 2,350 -$ 700 -$ 2,010 $ 1,330 Add Capital Receipts Receipts from the sale of resources $ - $ - $ - $ - $ - $ 50 $ - $ - $ - $ - $ - $ - $ 50 Receipts from borrowing $ - $ - $ - $ 1,000 $ - $ - $ - $ - $ - $ - $ - $ - $ 1,000 Less Capital Payments Purchase of resources $ - $ - $ - -$ 950 $ - $ - $ - $ - $ - $ - $ - $ - -$ 950 Repayment of borrowings $ - $ - $ - $ - -$ 1,000 $ - $ - $ - $ - $ - $ - $ - -$ 1,000 Increase/(Decrease) in cash $ 14,750 -$ 1,150 -$ 1,010 -$ 950 -$ 1,000 -$ 1,150 -$ 500 -$ 2,600 -$ 900 -$ 2,350 -$ 700 -$ 2,010 $ 430 Plus opening bank accounts $ 5,000 $ 19,750 $ 18,600 $ 17,590 $ 16,640 $ 15,640 $ 14,490 $ 13,990 $ 11,390 $ 10,490 $ 8,140 $ 7,440 $ 5,000 Total closing bank accounts $ 19,750 $ 18,600 $ 17,590 $ 16,640 $ 15,640 $ 14,490 $ 13,990 $ 11,390 $ 10,490 $ 8,140 $ 7,440 $ 5,430 $ 5,430 Represented by: Bank account $ 19,750 $ 18,600 $ 17,590 $ 16,640 $ 15,640 $ 14,490 $ 13,990 $ 11,390 $ 10,490 $ 8,140 $ 7,440 $ 5,430 $ 5,430 OK OK OK OK OK OK OK OK OK OK OK OK OK
no reviews yet
Please Login to review.