jagomart
digital resources
picture1_Excel Statement Template Free Download 31023 | Automatic Cash Book V2


 190x       Filetype XLSX       File size 0.53 MB       Source: www.charities.govt.nz


File: Excel Statement Template Free Download 31023 | Automatic Cash Book V2
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 ...

icon picture XLSX Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Partial file snippet.
            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
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...

no reviews yet
Please Login to review.