Creating Spreadsheets Sample Clauses

Creating Spreadsheets. Spreadsheets can contain any desired data so long as the data to be imported is in compliance with the limitations listed below. It is not necessary to fill in all the data in all of the columns or even to use all of the headings. Use only the column headings for which you have data and put the import data columns in the left most columns of the spreadsheet. To create an importable file from an existing spreadsheet, use one of the supplied Excel .xlt templates and save it as the desired file name and in the .xls file format. You will then be able to enter data and delete unneeded columns. To change the format of the supplied master template, save the template under a different file name and in the .xls format. Cut and paste the column headings as desired and then save this new spreadsheet as a new master template. It is also possible to create your own spreadsheet using the headings and definitions found in Appendix B.  Do not change the text in the master template column headings! This will cause the import to fail for that column.  It is not advisable to put more than one harness into a spreadsheet.
AutoNDA by SimpleDocs

Related to Creating Spreadsheets

  • Basis of compilation This statement of eligible expenditure has been prepared to meet the requirements of the grant agreement between [enter Grantee name] and the Commonwealth represented by the Department of Industry, Science, Energy and Resources. Significant accounting policies applied in the compilation of the statement of grant income and expenditure include the following: [enter details] Certification by directors [if not director, replace with appropriate equivalent] [Grantee name] [Project number] For the period [dd/ mm/yyyy] to [dd/ mm/yyyy] We confirm that, to the best of our knowledge and believe, having made such enquiries as we considered necessary for the purpose of appropriately informing ourselves: Statement of grant income and expenditure We have fulfilled our responsibilities for the preparation of the statement of grant income and expenditure in accordance with the cash basis of accounting and the terms of the grant agreement with the Commonwealth, represented by the Department of Industry, Science, Energy and Resources dated [enter date]; in particular, the statement of grant income and expenditure presents fairly in accordance therewith. All events subsequent to the date of the statement of grant income and expenditure which require adjustment or disclosure so as to present fairly the statement of grant income and expenditure, have been adjusted or disclosed. [Where applicable] The effects of uncorrected misstatements are immaterial, both individually and in the aggregate, to the statement of grant income and expenditure as a whole. A list of the uncorrected misstatements is attached to this representation letter. That all Grantee contributions and other financial assistance were spent for the purpose of the project and in accordance with the grant agreement and that the Grantee has complied with the grant agreement and relevant accounting policies. That salaries and allowances paid to persons involved in the project are in accordance with any applicable award or agreement in force under any relevant law on industrial or workplace relations. Signature Name [enter name] Director Date [dd/mm/yyyy] Signature Name [enter name] Director Date [dd/mm/yyyy] For Auditor use only I certify that this statement of grant income and expenditure is the one used to prepare my independent audit report dated [enter date] for the Department of Industry, Science, Energy and Resources. Signature Name [enter name] Position [enter position] Auditor’s employer [enter employer name] Date [dd/mm/yyyy] Attachment B - Independent audit report Background for auditors The purpose of the independent audit report is to provide us with an auditor's opinion on the Grantee’s statement of grant income and expenditure. The statement of grant income and expenditure is prepared by the Grantee to correspond with the expenditure reported to the department by the Grantee for the same period, in the process of claiming grant payments. The independent audit report must be prepared by a person who is an approved auditor. An approved auditor is a person who is: registered as a company auditor under the Corporations Xxx 0000 or an appropriately qualified member of Chartered Accountants Australia and New Zealand, or of CPA Australia or the Institute of Public Accountants; and not a principal, member, shareholder, officer, agent, subcontractor or employee of the Grantee or of a related body corporate or a Connected Entity. The audit should be undertaken and reported in accordance with Australian Auditing Standards. The independent audit report must follow the required format and include any qualification regarding the matters on which the auditor provides an opinion. We may follow up any qualifications with the Grantee or auditor. The independent audit report must be submitted on the auditor's letterhead. Auditors must comply with the professional requirements of Chartered Accountants Australia and New Zealand, CPA Australia and the Institute of Public Accountants in the conduct of their audit. If the auditor forms an opinion that the statement of grant income and expenditure does not give a true and fair view of the eligible expenditure for the period, the independent audit report should be qualified and the error quantified in the qualification section of the independent audit report. The required independent audit report format follows. Auditor’s report Independent audit report in relation to [Grantee name]’s statement of grant income and expenditure to the Commonwealth, represented by the Department of Industry, Science, Energy and Resources (the department). We have audited: the accompanying statement of grant income and expenditure of [Grantee name] for the period [dd/mm/yyyy] to [dd/mm/yyyy], a summary of significant accounting policies and other explanatory information, and management’s attestation statement thereon (together “the financial statement”). The financial statement has been prepared by management using the cash basis of accounting described in note 3.2 to the financial statement; and [Grantee name]'s compliance with the terms of the grant agreement between [Grantee name] and the Commonwealth dated [date of agreement] for the period [dd/mm/yyyy] to [dd/mm/yyyy] (the grant agreement). We have: reviewed [Grantee name]’s statement of labour costs in support of its claim of eligible expenditure[; and performed limited assurance procedures on [Grantee name]’s statement of employee numbers under the grant agreement]. Management’s responsibility Management is responsible for: the preparation and fair presentation of the financial statement in accordance with the basis of accounting described in note 3.2, this includes determining that the cash basis of accounting is an acceptable basis for the preparation of the financial statement in accordance with the grant agreement; compliance with the terms of the grant agreement; the preparation of the statement of employee numbers and labour costs in support of eligible expenditure; and such internal control as management determines is necessary to: enable the preparation of the financial statement and the statement of [employee numbers and ]labour costs that are free from material misstatement, whether due to fraud or error; and enable compliance with the terms of the grant agreement. Auditor’s responsibility Our responsibilities are: To express an opinion, based on our audit, on: the financial statement; and [Grantee name]’s compliance, in all material respects, with the terms of the grant agreement; and To conclude based on: our review procedures, on the statement of labour costs; and our limited assurance procedures on the statement of employee numbers. We conducted our audit of the financial statement in accordance with Australian Auditing Standards; our audit of compliance with the grant agreement in accordance with ASAE 3100, our review of the statement of labour costs in accordance with ASRE 2405[; and our limited assurance procedures on employee numbers in accordance with ASAE 3000]. The applicable Standards require that we comply with relevant ethical requirements and plan and perform our work to: obtain reasonable assurance about whether the financial statement is free from material misstatement and that [Grantee name] has complied, in all material respects, with the terms of the grant agreement; and obtain limited assurance as to whether anything has come to our attention that causes us to believe that the statements of employee numbers and labour costs are materially misstated. An audit involves performing procedures to obtain audit evidence about the amounts and disclosures in the financial statement and about the Grantee’s compliance with the grant agreement. The procedures selected depend on the auditor’s judgement, including the assessment of the risks of material misstatement of the financial statement, whether due to fraud or error. In making those risk assessments, the auditor considers internal control relevant to the Grantee’s preparation and fair presentation of the financial statement, and to the Grantee’s compliance with the grant agreement, in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the Grantee’s internal control. An audit also includes evaluating the appropriateness of accounting policies used by management, as well as evaluating the overall presentation of the financial statement.

  • Detailed Monthly Report Vendor shall electronically provide DIR with a detailed monthly report in the format required by DIR showing the dollar volume of any and all sales under the Contract for the previous calendar month period. Reports are due on the fifteenth (15th) calendar day of the month following the month of the sale. If the 15th calendar day falls on a weekend or state or federal holiday, the report shall be due on the next business day. The monthly report shall include, per transaction: the detailed sales for the period, Customer name, invoice date, invoice number, description, quantity, MSRP or List Price, unit price, extended price, Customer Purchase Order number, contact name, Customer’s complete billing address, the estimated administrative fee for the reporting period, subcontractor name, EPEAT designation (if applicable), configuration (if applicable), contract discount percentage, actual discount percentage, negotiated contract price (if fixed price is offered instead of discount off of MSRP), and other information as required by DIR. Each report must contain all information listed above per transaction or the report will be rejected and returned to the Vendor for correction in accordance with this section. Vendor shall report in a manner required by DIR which is subject to change dependent upon DIR’s business needs. Failure to do so may result in contract termination.

  • Budget Narrative Services are strictly paid as cost reimbursement. No funds will be paid for services not provided.

  • Explanatory Statement 6 A. Pursuant to Article II of Chapter 60 of the Harford County Code, as amended (the 7 “Act”), the County Council of Harford County, Maryland (the “County Council”) created the 8 Agricultural Land Preservation and Purchase of Development Rights Program to preserve 9 productive Agricultural Land and Woodland (each as defined in the Act), which provide for the 10 continued production of food and fiber for the citizens of the County.

  • Program Narrative All restricted xxxxxx courses which are taught for the purpose of qualifying an individual for restricted xxxxxx license to practice barbering shall consist of a minimum of 1200 hours of training to prepare each restricted xxxxxx to service their communities.

  • Monthly Statements Each month we will send you a statement showing purchases, cash advances, payments, and credits made to your Account during the billing cycle, as well as your “New Balance”, any Finance Charge and any late charges. Your statement also will identify the minimum monthly payment you must make for that billing period and the date it is due. You agree to retain for statement verification copies of transaction slips resulting from each purchase, each advance, and other transactions on your Account. Unless you notify us of a billing error in accordance with the section entitled “Your Billing Rights”, you accept your monthly statement as an accurate statement of your Account with us.

  • Pro Forma Statement The Receiver, as soon as practicable after Bank Closing, in accordance with the best information then available, shall provide to the Assuming Institution a pro forma statement reflecting any adjustments of such liabilities and assets as may be necessary. Such pro forma statement shall take into account, to the extent possible, (i) liabilities and assets of a nature similar to those contemplated by Section 2.1 or Section 3.1, respectively, which at Bank Closing were carried in the Failed Bank's suspense accounts, (ii) accruals as of Bank Closing for all income related to the assets and business of the Failed Bank acquired by the Assuming Institution hereunder, whether or not such accruals were reflected on the Accounting Records of the Failed Bank in the normal course of its operations, and (iii) adjustments to determine the Book Value of any investment in an Acquired Subsidiary and related accounts on the "bank only" (unconsolidated) balance sheet of the Failed Bank based on the equity method of accounting, whether or not the Failed Bank used the equity method of accounting for investments in subsidiaries, except that the resulting amount cannot be less than the Acquired Subsidiary's recorded equity as of Bank Closing as reflected on the Accounting Records of the Acquired Subsidiary. Any Loan purchased by the Assuming Institution pursuant to Section 3.1 which the Failed Bank charged off during the period beginning the day after the Bid Valuation Date to the date of Bank Closing shall be deemed not to be charged off for the purposes of the pro forma statement, and the purchase price shall be determined pursuant to Section 3.2.

  • Monthly Status Reports 19.1.1 During the Operation Period, the Concessionaire shall, no later than 7 (seven) days after the close of each month, furnish to the Authority and the Independent Engineer a monthly report stating in reasonable detail the condition of the Project including its compliance or otherwise with the Maintenance Requirements, Maintenance Manual, Maintenance Program and Safety Requirements, and shall promptly give such other relevant information as may be required by the Independent Engineer or the Authority. In particular, such report shall separately identify and state in reasonable detail the defects and deficiencies that require rectification.

  • Financial Statement Audit If, during its fiscal year, Grantee expends less than $750,000 in Federal Awards, Grantee is subject to the following audit requirements:

  • Timesheets 5.1. At the end of each week of an Assignment (or at the end of the Assignment where it is for a period of 1 week or less or is completed before the end of a week) the Agency Worker shall deliver to the Employment Business a timesheet duly completed to indicate the number of hours worked during the preceding week (or such lesser period) and signed by an authorised representative of the Hirer.

Time is Money Join Law Insider Premium to draft better contracts faster.