Situation
The accounting team manually categorized bank transactions using color codes, added category totals, and copied the results into the daily cash-flow report. The process was repetitive, time-consuming, and exposed to mechanical errors.
Work
- Built a structured Excel file where bank statement data could be pasted directly.
- Used formulas, VBA, Power Query, dropdown categorization, and formatting logic.
- Automatically categorized recurring expenses.
- Flagged new transactions for manual review through dropdown classification.
- Consolidated categorized transactions into the final cash-flow report.
- Reduced the amount of manual work required from the accounting team.
Result
The reporting process changed from almost a full working day of manual work to approximately 30 minutes.