Comprehensive Bank Statement Analysis
Budget: $30 – $250 USD
I have two account statements ready for review and need a clear, insight-rich analysis delivered in Excel. The workbook should open to an at-a-glance dashboard, then drill down into the detail so I can trace every conclusion back to the raw line items.
Scope of the analysis
• Transaction summary – a concise overview of total inflows, outflows and net position for the full statement period.
• Monthly breakdown – month-by-month totals that highlight swings in cash flow and any seasonality.
• Category spending analysis – intelligent grouping of expenses and income (you may create or adjust categories where logical).
• People focus – separate lists of the main payees (persons receiving funds) and payers (persons depositing funds), each ranked by total value and frequency.
• Trend spotting & critique – surface notable patterns, anomalies or irregularities and add a short narrative explaining what these might mean for budgeting, risk or opportunity.
Acceptance criteria
1. All figures reconcile to the source statements (no rounding errors).
2. Categories are consistent across the two accounts.
3. Dynamic formulas or PivotTables allow me to filter by month, category or counter-party without breaking the model.
4. A one-page written summary (on a separate worksheet) captures key findings, red flags and recommended next steps.
I value clear, well-commented formulas over hard-coded numbers, and a clean, intuitive layout over excessive styling. Feel free to suggest improvements if you see a better way to present the data—insight is the ultimate goal here.
Scope of the analysis
• Transaction summary – a concise overview of total inflows, outflows and net position for the full statement period.
• Monthly breakdown – month-by-month totals that highlight swings in cash flow and any seasonality.
• Category spending analysis – intelligent grouping of expenses and income (you may create or adjust categories where logical).
• People focus – separate lists of the main payees (persons receiving funds) and payers (persons depositing funds), each ranked by total value and frequency.
• Trend spotting & critique – surface notable patterns, anomalies or irregularities and add a short narrative explaining what these might mean for budgeting, risk or opportunity.
Acceptance criteria
1. All figures reconcile to the source statements (no rounding errors).
2. Categories are consistent across the two accounts.
3. Dynamic formulas or PivotTables allow me to filter by month, category or counter-party without breaking the model.
4. A one-page written summary (on a separate worksheet) captures key findings, red flags and recommended next steps.
I value clear, well-commented formulas over hard-coded numbers, and a clean, intuitive layout over excessive styling. Feel free to suggest improvements if you see a better way to present the data—insight is the ultimate goal here.