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**.