Excel Financial Due Diligence

₹600-601 INR

Closed

Posted 7 days ago

₹600-601 INR

Paid on delivery

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

Project ID: 40698458

About the project

8 proposals

Remote project

Active 6 days ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

8 freelancers are bidding on average ₹1,332 INR for this job

@abdulqadir4613

As a Full Stack Developer who specializes in Data Engineering and Automation, I have the skills and expertise necessary to tackle your financial due diligence project comprehensively. My experience in building scalable Websites, APIs, and ERP systems reveals my acute familiarity with Excel and its potent capabilities. I have an intimate understanding of data analysis which will enable me to interpret and input relevant data intelligently, ensuring absolute accuracy in all sections of the workbook.

₹601 INR in 7 days

5.0

(13 reviews)

3.8

@AdeebaShamsi

As a skilled CA professional with four years of experience, I have a comprehensive understanding of excel, accounting, financial modeling, and project management. These experiences make me an ideal candidate for your Excel Financial Due Diligence project. I am well-versed in preparing and finalizing financial statements, conducting scrutiny of accounts, and managing account receivables and payables proficiently. Furthermore, my substantial exposure to diverse accounting software such as QuickBooks, Xero, MYOB, Tally will ensure I maintain the integrity of your existing data. Your primary instruction directs us to ensure all formulas and reconciliation columns work accurately which aligns perfectly with my proficiency in maintaining the highest level of accuracy while handling vast data sets. Moreover, I comprehend the significance of identifying missing details promptly and communicating effectively with the team to secure them. The ability to scrutinize available records and cross-check figures assiduously is another merit that I bring to the table. Additionally, as a Power BI expert, I'll be able to create visualizations that will enhance your ability to analyze the business more efficiently.

₹600 INR in 7 days

5.0

(8 reviews)

3.4

@shivanandaa6

Hi, I'd like to take on your APF – Organisation Data Sheet FY 2026-27 assignment. I bring 25+ years in finance controllership, R2R, and multi-entity accounting (US GAAP + Indian statutory), with hands-on experience in TDS, PF/ESI/PT compliance, payroll reconciliation, donor/grant fund tracking, and financial statement preparation — exactly the ground this workbook covers. My approach: 1. Read the Instructions tab fully before touching any cell — I won't guess or estimate figures. 2. Work tab-by-tab (Org Profile, Governing Body, Statutory Filings, Salary Format, Funding Details, Expenditure, Hospitals) and cross-check every figure against source docs — Tally, payroll records, TDS challans, donor agreements, audited financials. 3. Preserve existing formatting, headings, and formulas; verify all reconciliation/check columns tie out. 4. Deliver three things as requested: (a) the fully completed, submission-ready workbook, (b) a Pending Information/Document List with item, sheet reference, reason needed, source, and owner, and (c) a Discrepancy/Clarification List for any mismatches found. I understand this isn't "fill and submit" — it's a data integrity exercise, and I'll flag rather than fabricate anything unclear. Happy to share a quick sample of how I'd structure the Pending Info list before starting, if useful. Available to start immediately and can turn this around within your 6-day window. Looking forward to working on this. Shivananda A V

₹600 INR in 7 days

0.0

(0 reviews)

0.0

@TrystonSA

I’ve read through your project and I’m confident I can help you get this done properly. With extensive experience in financial due diligence and Excel, I will ensure that your workbook is completed accurately and is submission-ready. I will meticulously review each tab, gather missing information, and cross-check all figures against the relevant documents to maintain consistency and accuracy. My approach includes verifying organizational profiles, completing statutory filings, and reconciling financial statements while adhering to your specific requirements and formatting. I will also provide a detailed list of any pending information and discrepancies for your review. Send me a message and I’ll quickly walk you through my approach and the next steps. Regards, TrystonSA.

₹600 INR in 7 days

0.0

(0 reviews)

0.0

@charlieg54

Hi, I can complete and validate the APF Organisation Data Sheet accurately, following every workbook instruction and checking all required sections before delivery. I work asynchronously and will share a clear progress update. Please fund the initial milestone before I begin the detailed data-collection work. Regards, Charlie Grant

₹601 INR in 7 days

0.0

(0 reviews)

0.0

@dave282

I can prepare your APF FY 2026–27 Organisation Data Sheet, cross-check it against supporting records and return the Excel workbook with both required review lists. I’ll read Instructions first and preserve the template’s headings, formatting, structure and working formulas. The review will cover all seven sections: Org Profile & Documents, Governing Body, Statutory Filings, Salary Format, Funding Details, Expenditure and For Hospitals. I’ll reconcile payroll, donor/project allocations, statutory payments, funding and expenditure against supplied accounting records, challans, agreements and financial statements. I’ll check formulas and totals, use donors’ full legal names, distinguish audited/unaudited and actual/committed/projected figures, and state the FY 2026–27 actuals cut-off date. No figures will be guessed or changed merely to force agreement. Unsupported entries will be flagged, and N/A used only with a supported reason. Deliverables: • Updated Excel workbook • Pending Information/Document List, including section, reason, source, responsible person where known and status • Discrepancy/Clarification List with source references and conflicting figures/dates Please provide the workbook and authorised supporting records. I’ll identify further information needed and highlight management confirmations; the file will only be described as submission-ready once outstanding requirements are resolved.

₹600 INR in 1 day