Excel Financial Due Diligence

I need you to complete the attached Excel file **“APF – Organisation Data Sheet FY 2026–27”** for organisation. Your responsibility is to complete the entire workbook accurately and make it **submission-ready**. Please do not just enter whatever information is readily available—review the instructions in the workbook, identify the information/documents required, collect the missing details from the organisation's records, and complete all applicable sections. ### Scope of Work Please review and complete the following tabs: 1. **Org Profile & Documents** * Verify and complete the organisation profile. * Complete all required organisation details. * Review the complete list of required documents. * Mark whether each document has been uploaded/available. * Add appropriate remarks wherever a document is pending, unavailable, not applicable, or requires clarification. * Identify any missing documents/details that need to be provided by us. 2. **Governing Body** * Complete details of all current governing body/board members. * Include name, position, address/contact details, relationship with other members, tenure, occupation, educational background, political exposure/affiliation, other institutional associations and brief profile, wherever applicable. * Verify information against available organisational records. 3. **Statutory Filings** * Complete the required statutory information for the period specified in the sheet. * Include TDS details section-wise, challan/payment dates, PF, ESI, PT and other applicable statutory payments. * Cross-check figures and dates with payroll, challans and accounting records. * Do not estimate or fabricate any figures. If information is unavailable, clearly flag it for confirmation. 4. **Salary Format** * Complete the latest-month consolidated salary details for all existing staff. * Correctly allocate salary across donors/projects/general funds as applicable. * Complete deductions including PT, employee PF, ESI, TDS and net salary. * Complete employer PF/ESI, medical insurance, gratuity and total cost to organisation wherever applicable. * Complete the proposed positions/roles section as required. * Ensure all formulas and reconciliation/check columns work correctly. 5. **Funding Details** * Complete donor/funder information for the required financial years. * Use the **full legal name of each donor/funder** as appearing in agreements/records. * Enter historical funding figures from the appropriate financial records. * Complete current and future committed funding details. * Include start/end dates, purpose of grant, funder type and remarks. * Reconcile totals with audited financial statements, donor records and available agreements. 6. **Expenditure** * Complete total organisational expenditure for the financial years requested. * Separate salary, programme, administration, capital, relief and depreciation expenditure as required. * Complete Foundation-supported expenditure separately. * For FY 2026–27, use actual figures available up to the relevant date and clearly mention the date. * Reconcile totals with accounting records/financial statements. 7. **For Hospitals** * Review this section and determine whether it is applicable to the organisation. * If applicable, complete all relevant licences/regulatory information with validity and renewal dates. * If not applicable, clearly mark it as **Not Applicable** rather than leaving it ambiguous. ### Important Requirements * **Read the “Instructions” tab first and follow every instruction in it.** * Do not overwrite the existing format, headings, formulas or structure unnecessarily. * Preserve the workbook's formatting. * Ensure formulas are correct and totals reconcile. * Do not invent, assume or guess any information. * Wherever information is missing, create a clear list of what is required from us. * Cross-check information wherever possible against source documents such as: * audited financial statements * books of accounts/Tally * payroll records * TDS challans/returns * PF/ESI/PT records * donor agreements * registration certificates * board records * statutory registrations and licences * previous-year records * Maintain consistency of names, dates, amounts and financial years throughout the workbook. * Use the correct financial-year convention: **FY 2022–23, FY 2023–24, FY 2024–25, FY 2025–26 and FY 2026–27**, wherever applicable. * Clearly distinguish between **audited, unaudited, actual, committed and projected** figures. * Do not change source figures simply to make totals match. Investigate and flag discrepancies. * Where a section is not applicable, explicitly mention **N/A / Not Applicable** with a brief reason. * Highlight any item requiring management confirmation before final submission. ### Final Deliverables Please provide: **1. Completed Excel workbook** * Fully filled * Formulas checked * Totals reconciled * Formatting preserved * No unnecessary blank/placeholder entries * Submission-ready **2. Pending Information/Document List** Provide a separate list containing: * Item required * Relevant sheet/section * Why it is required * Source/document needed * Person from whom it needs to be obtained, if known * Status **3. Discrepancy/Clarification List** Clearly mention any mismatch found between the Excel sheet and source records, including the figures/dates involved. ### Quality Standard I will consider the work complete only when **all applicable sections have been filled, figures have been cross-checked, formulas and totals have been verified, and all missing information/documents have been clearly identified**. Please do not mark the assignment as complete merely because the Excel file has been partially populated. The objective is to deliver a **complete and internally consistent APF FY 2026–27 Organisation Data Sheet ready for review/submission**.