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 ...
Filetype Excel XLSX | Posted on 08 Aug 2022 | 2 years ago
The words contained in this file might help you see if this file matches what you are looking for:
...How to use this tool set your financial year in the sorp column beginning date should be first day of while ending last manually enter bank balance at cell q tab download digital statement from online banking and copy transactions or key into for each month ensure you can identify complete following details cells a g transaction b amount that all payments are negative numbers c other party d reference fields i select drop down icon grey row want classify relevant receipt payment category go completed receipts once classified end if have included get an ok message otherwise will error note comes prepopulated with example so see it works delete data white tabs before begin using spreadsheet april march may june july august september october november december january february total operating donations fundraising similar fees subscriptions members providing goods services interest dividends investment income less related public volunteer employee grants made surplus deficit add capital sa...