I am looking for an experienced Excel Data Analyst / Financial Data Analyst to process and analyze my personal bank statements coveUrgent

I will provide detailed bank statements in PDF and/or Excel/CSV format. The goal is to consolidate, organize, analyze and categorize all transactions into a comprehensive Excel workbook.

Scope of Work

The project includes:

Extracting and consolidating all bank transactions into one organized Excel workbook.

Categorizing each transaction based on the merchant, company or type of payment.

Grouping expenses into clear categories, including:

Supermarkets and groceries

Electricity and natural gas

Water bills

Mobile phone and Internet

Fuel and transportation

Restaurants, cafes and food delivery

Shopping, clothing and personal items

Healthcare, doctors and medication

Travel and entertainment

Insurance and bank fees

Other expenses

Calculating the total amount spent in each category for every calendar year: 2023, 2024, 2025 and 2026.

Creating comparative annual reports showing how much was spent in each category per year.

Calculating total annual and monthly expenses.

Creating charts and visual summaries to make spending patterns and year-to-year comparisons easy to understand.

Important Requirements

Every transaction must be recorded only once and assigned to the appropriate category.

Transfers between my own bank accounts must be excluded from actual expenses.

Cash withdrawals, refunds and incoming payments must be identified and separated from actual purchases and expenses.

Transactions that cannot be confidently identified should be flagged for manual review.

The final Excel workbook must be clearly structured, fully editable and easy to understand.

Please include the following in your proposal:

Your total fixed price for completing the entire project.

Your estimated turnaround time (number of working days).

Your relevant experience with bank statement processing and financial data analysis.

Confirmation that you can deliver a complete Excel workbook with detailed transactions, annual summaries, category breakdowns and charts.

The project involves confidential personal financial information. Strict confidentiality and secure handling of all provided files are essential.

Thank you. I look forward to receiving your proposal.

Budget range:
Simple project

Examples:

Expected Excel Workbook – Annual Expenses by Category

I would like the final Excel workbook to include an annual expense summary in the following format:

Annual Expenses by Category

2026 figures should cover the available transaction period only.

Additional Required Reports and Features:

• Total expenses for each calendar year.
• Average monthly spending for each expense category.
• A detailed transaction list, including transaction date, description, merchant, amount and assigned category.
• Charts and graphs showing increases or decreases in spending across different years.
• A separate section for unidentified or unclassified transactions that require further clarification.

The Excel workbook should be professionally formatted, clearly structured, easy to navigate and fully editable.