Docstoc

Statement of Income and Expenditure template _Excel 55

Document Sample
Statement of Income and Expenditure template _Excel 55 Powered By Docstoc
					                                                                    5f119124-8a61-4f82-8967-157696bbeb3d.xls




ATTACHMENT 2: STATEMENT OF INCOME AND EXPENDITURE OF COMMONWEALTH GRANT FUNDS


Instructions
                1 Statements of Income and Expenditure are required as part of each Progress Report. Submission dates are specified in the
                  Schedule of the Funding Agreement (the Schedule).
                2 The Statement of Income and Expenditure should only record activity against the Budget line items listed under Item B of the
                  Schedule, and should only show expenditure of Commonwealth grant funds.
                3 Accrual based accounting principles should be used when reporting on spending activities.

                4 Report all income and invoiced expenditure.

                5 Fields requiring Participant input are shaded. Populate the shaded fields only.

                6 Ensure the Certificate of Compliance is signed by two officers authorised in accordance with clause 8 of the Funding Agreement.

                7 Audited Statements of Income and Expenditure must be submitted for the total funding period with the Final (third) Report. Audited
                  Statements of Income and Expenditure must include:
                             a) A Scope and an Audit Opinion signed by an approved auditor certifying that the financial accounts are complete and
                                accurate as per clauses 11.3(g) and 11.4(d) of the Funding Agreement.
                             b) A declaration by the Participant.

                8 Variations between the Budget item amounts agreed in Item B of the Schedule and actual expenses against those items will be
                  monitored by the Department. Any variations should be explained under question 13 of the Progress Report.

Please Note:      The requirement to have Statements of Income and Expenditure of Commonwealth funds audited separately from your
                  organisation's other auditing activity may result in an additional cost being incurred by your organisation. Any such costs will need
                  to be met by your organisation.




                                                                                  Page 1 of 4
                                                                      5f119124-8a61-4f82-8967-157696bbeb3d.xls




                                                        First      Second           Third
                                                     Reporting    Reporting       Reporting
                           Year 1       Year 2         Period       Period          Period        Cumulative
           Income          Budget       Budget        Income       Income          Income          Income

Gross Income                   $0.00        $0.00         $0.00          $0.00           $0.00           $0.00

GST                            $0.00        $0.00         $0.00          $0.00           $0.00           $0.00

Nett Income                    $0.00        $0.00         $0.00          $0.00           $0.00           $0.00

Carry Forward                    N/A          N/A         $0.00          $0.00           $0.00             N/A

Interest                         N/A          N/A         $0.00          $0.00           $0.00           $0.00
Total                          $0.00        $0.00         $0.00          $0.00           $0.00           $0.00

Report all expenditure exempt of GST
                                                       First        Second       Third
                                                     Reporting     Reporting   Reporting
                           Year 1       Year 2        Period        Period      Period    Cumulative
         Expenditure       Budget       Budget      Expenditure   Expenditure Expenditure Expenditure

Item 1                                                    $0.00          $0.00           $0.00           $0.00

Item 2                                                    $0.00          $0.00           $0.00           $0.00
Item 3                                                    $0.00          $0.00           $0.00           $0.00

Item 4                                                    $0.00          $0.00           $0.00           $0.00

Item 5                                                    $0.00          $0.00           $0.00           $0.00

Item 6                                                    $0.00          $0.00           $0.00           $0.00
Total                          $0.00        $0.00         $0.00          $0.00           $0.00           $0.00

Surplus/Deficit                                           $0.00          $0.00           $0.00

Balance of Funds (GST Excl) in the Bank Account:

Ensure the Certificate of Compliance is filled in, signed and returned with the Project Report




                                                                                    Page 2 of 4
                                                                             5f119124-8a61-4f82-8967-157696bbeb3d.xls




CERTIFICATE OF COMPLIANCE:
We, the undersigned, certify for the abovementioned Project that:

  [1] all Funds received have been expended for the purposes for which they were provided and in
accordance with the Agreement;

 [2] all Funds have been accounted for;

 [3] all salaries and allowances paid to persons involved in the Project are in accordance with applicable
awards or agreements in force; and

 [4] That all obligations in respect of GST have been complied with.

We acknowledge that it is an offence under Section 137 of the Criminal Code Act 1995 to provide false or
misleading information or documents to the Commonwealth.

Signed:…………………………………                         Date:……………………………………..


Name:…………………………………..                         Position:…………………………………


Signed:…………………………………                         Date:……………………………………..


Name:…………………………………..                         Position:…………………………………




                                                                                            Page 3 of 4
                                                                     Office Use Only




                                             First       Second         Third
                   Year 1      Year 2     Reporting     Reporting     Reporting    Cumulative
Income             Budget      Budget   Period Income Period Income Period Income   Income
Gross Income          $0.00       $0.00           $0.00        $0.00         $0.00      $0.00
GST                   $0.00       $0.00           $0.00        $0.00         $0.00      $0.00
Nett Income           $0.00       $0.00           $0.00        $0.00         $0.00      $0.00
Carry Forward           N/A         N/A           $0.00        $0.00         $0.00         N/A
Interest                N/A         N/A           $0.00        $0.00         $0.00      $0.00
Total                 $0.00       $0.00           $0.00        $0.00         $0.00      $0.00

                                              First          Second           Third
                                            Reporting       Reporting       Reporting
                   Year 1      Year 2        Period          Period          Period      Cumulative    %
   Expenditure     Budget      Budget      Expenditure     Expenditure     Expenditure Expenditure Expenditure
Item 1                $0.00       $0.00            $0.00           $0.00           $0.00      $0.00  #DIV/0!
Item 2                $0.00       $0.00            $0.00           $0.00           $0.00      $0.00  #DIV/0!
Item 3                $0.00       $0.00            $0.00           $0.00           $0.00      $0.00  #DIV/0!
Item 4                $0.00       $0.00            $0.00           $0.00           $0.00      $0.00  #DIV/0!
Item 5                $0.00       $0.00            $0.00           $0.00           $0.00      $0.00  #DIV/0!
Item 6                $0.00       $0.00            $0.00           $0.00           $0.00      $0.00  #DIV/0!
Total                 $0.00       $0.00            $0.00           $0.00           $0.00
Surplus/Deficit       $0.00       $0.00            $0.00           $0.00           $0.00



     Deliverable               Due Date                % Project Period               Cumulative %
      Execution                 1/7/2007
        Period 1              31/12/2007                           25%                        25%
        Period 2              31/12/2008                           50%                        75%
        Period 3               30/6/2009                           25%                       100%