Bank's Financials Extraction to Excel Organized
Budget: $30 – $250 USD
Title:
Structured Extraction of One Bank’s Financial Statements into Excel (Annual + Quarterly)
________________________________________
Project Description (Clarified and Professional)
You will receive scanned or PDF financial statements for one bank, including:
• 5 Annual Reports covering: 2020, 2021, 2022, 2023, 2024
• 9 Quarterly Reports covering: Q1 2023 through Q2 2025
Your responsibility is to extract, organize, and structure all relevant financial data into one Excel workbook, which must contain two separate sheets:
________________________________________
Sheet 1: Annual Financials (2020–2024)
Structure the data as follows:
• Include the full Income Statement, Balance Sheet, Cash Flow Statement, and all Notes to the Accounts
• Each year should appear in a separate column: 2020, 2021, 2022, 2023, 2024
• Maintain exact line-by-line fidelity with the original financial statements—do not skip or summarize
• Include all notes in full detail: tables and figures inside the notes must be extracted entirely, with their original labels (e.g., "Note 1 – Loans & Advances")
• Notes should be structured clearly with original headings and sub-sections retained
• Where notes or tables differ in formatting or structure from year to year, you must standardize them into a single clear format
________________________________________
Sheet 2: Quarterly Financials (Q1 2023–Q2 2025)
Structure similarly to the Annual sheet:
• Include full Income Statement, Balance Sheet, Cash Flow Statement, and all Notes
• Each quarter (Q1 2023, Q2 2023, ..., Q2 2025) must be in a separate column
• In cases where Q4 figures are not directly provided, you must calculate Q4 by subtracting the sum of Q1, Q2, and Q3 from the annual value
Formula: Q4 = Annual - Q1 - Q2 - Q3 (for income statement)
• Maintain a left-to-right structure from oldest (Q1 2023) to most recent (Q1 2025)
• Tables or notes with large horizontal width (e.g., 5+ columns) and different structures per period must be placed side-by-side for each period rather than merged
• If a note or table has only one or two columns and can logically be merged across time, use a shared structure with additional columns per period
________________________________________
Formatting Standards and Key Expectations
• Use professional and consistent formatting across the file
• All tables inside notes must be extracted and highlighted clearly for easy review
• Do not extract or highlight narrative text—only numeric and tabular content is required
• Standardize all formats: some notes and tables may vary across years or quarters; ensure consistent formatting and structure
• Data must be fully aligned by row, and columns should represent time (year or quarter)
________________________________________
Final Deliverable Per Bank
• One Excel workbook (.xlsx)
o Sheet 1: Annual data from 2020 to 2024
o Sheet 2: Quarterly data from Q1 2023 to Q2 2025
• Both sheets should include:
o Full income statement, balance sheet, cash flow statement
o All notes as full tables with their original numbers and labels
o Standardized format across years/quarters
o Tables placed side-by-side where merging is not feasible
o Calculated Q4s added when not explicitly provided
________________________________________
Clarification on Note/Table Placement
• If a note/table has multiple columns and cannot be merged across years or quarters: place each period’s full version side-by-side
• If a note/table is short and can be merged: use common rows and add time columns
• Do not remove or place tables underneath others—always align period versions side-by-side
• Highlight all included tables, especially those from notes
________________________________________
Your Proposal Should Include
1. Your approach or methodology for ensuring 100% completeness and accuracy
2. Your timeline estimate for one bank
3. Your cost proposal per bank
4. Examples of prior work (if available)
________________________________________
FAQ – Frequently Asked Questions
Q1: Should descriptive text in notes be extracted?
A1: No. Only extract and highlight tables or numeric figures. Skip long descriptive or narrative text unless it contains embedded tables.
Q2: What if tables have inconsistent formats year to year?
A2: You must standardize all table formats to be consistent and structured logically. Differences in structure must be harmonized.
Q3: What if a table is too wide to merge across time?
A3: Place each version side-by-side, not below or merged.
Q4: Are you allowed to skip lines or drop empty rows?
A4: No. Every row and note must be retained, even if blank. No line or item should be skipped.
Q5: How to handle calculated Q4 values?
A5: Use the formula: Q4 = Annual – Q1 – Q2 – Q3. Insert Q4 after Q3 in the same row set.
Q6: In what order should time periods appear?
A6: From oldest to newest, left to right. Last column in Annual Sheet: 2024. Last column in Quarterly Sheet: Q1 2025.
Q7: Should all notes be included?
A7: Yes. All notes that include tables must be fully extracted and labeled with original numbering (e.g., "Note 6 – Deposits").
Structured Extraction of One Bank’s Financial Statements into Excel (Annual + Quarterly)
________________________________________
Project Description (Clarified and Professional)
You will receive scanned or PDF financial statements for one bank, including:
• 5 Annual Reports covering: 2020, 2021, 2022, 2023, 2024
• 9 Quarterly Reports covering: Q1 2023 through Q2 2025
Your responsibility is to extract, organize, and structure all relevant financial data into one Excel workbook, which must contain two separate sheets:
________________________________________
Sheet 1: Annual Financials (2020–2024)
Structure the data as follows:
• Include the full Income Statement, Balance Sheet, Cash Flow Statement, and all Notes to the Accounts
• Each year should appear in a separate column: 2020, 2021, 2022, 2023, 2024
• Maintain exact line-by-line fidelity with the original financial statements—do not skip or summarize
• Include all notes in full detail: tables and figures inside the notes must be extracted entirely, with their original labels (e.g., "Note 1 – Loans & Advances")
• Notes should be structured clearly with original headings and sub-sections retained
• Where notes or tables differ in formatting or structure from year to year, you must standardize them into a single clear format
________________________________________
Sheet 2: Quarterly Financials (Q1 2023–Q2 2025)
Structure similarly to the Annual sheet:
• Include full Income Statement, Balance Sheet, Cash Flow Statement, and all Notes
• Each quarter (Q1 2023, Q2 2023, ..., Q2 2025) must be in a separate column
• In cases where Q4 figures are not directly provided, you must calculate Q4 by subtracting the sum of Q1, Q2, and Q3 from the annual value
Formula: Q4 = Annual - Q1 - Q2 - Q3 (for income statement)
• Maintain a left-to-right structure from oldest (Q1 2023) to most recent (Q1 2025)
• Tables or notes with large horizontal width (e.g., 5+ columns) and different structures per period must be placed side-by-side for each period rather than merged
• If a note or table has only one or two columns and can logically be merged across time, use a shared structure with additional columns per period
________________________________________
Formatting Standards and Key Expectations
• Use professional and consistent formatting across the file
• All tables inside notes must be extracted and highlighted clearly for easy review
• Do not extract or highlight narrative text—only numeric and tabular content is required
• Standardize all formats: some notes and tables may vary across years or quarters; ensure consistent formatting and structure
• Data must be fully aligned by row, and columns should represent time (year or quarter)
________________________________________
Final Deliverable Per Bank
• One Excel workbook (.xlsx)
o Sheet 1: Annual data from 2020 to 2024
o Sheet 2: Quarterly data from Q1 2023 to Q2 2025
• Both sheets should include:
o Full income statement, balance sheet, cash flow statement
o All notes as full tables with their original numbers and labels
o Standardized format across years/quarters
o Tables placed side-by-side where merging is not feasible
o Calculated Q4s added when not explicitly provided
________________________________________
Clarification on Note/Table Placement
• If a note/table has multiple columns and cannot be merged across years or quarters: place each period’s full version side-by-side
• If a note/table is short and can be merged: use common rows and add time columns
• Do not remove or place tables underneath others—always align period versions side-by-side
• Highlight all included tables, especially those from notes
________________________________________
Your Proposal Should Include
1. Your approach or methodology for ensuring 100% completeness and accuracy
2. Your timeline estimate for one bank
3. Your cost proposal per bank
4. Examples of prior work (if available)
________________________________________
FAQ – Frequently Asked Questions
Q1: Should descriptive text in notes be extracted?
A1: No. Only extract and highlight tables or numeric figures. Skip long descriptive or narrative text unless it contains embedded tables.
Q2: What if tables have inconsistent formats year to year?
A2: You must standardize all table formats to be consistent and structured logically. Differences in structure must be harmonized.
Q3: What if a table is too wide to merge across time?
A3: Place each version side-by-side, not below or merged.
Q4: Are you allowed to skip lines or drop empty rows?
A4: No. Every row and note must be retained, even if blank. No line or item should be skipped.
Q5: How to handle calculated Q4 values?
A5: Use the formula: Q4 = Annual – Q1 – Q2 – Q3. Insert Q4 after Q3 in the same row set.
Q6: In what order should time periods appear?
A6: From oldest to newest, left to right. Last column in Annual Sheet: 2024. Last column in Quarterly Sheet: Q1 2025.
Q7: Should all notes be included?
A7: Yes. All notes that include tables must be fully extracted and labeled with original numbering (e.g., "Note 6 – Deposits").