Bank Statement Lesson 8: Project – Monthly Expense Dashboard

📎 This article includes 1 downloadable practice file ↓

📘 Bank Statement Automation Course · Lesson 8 of 8

Put it all together: one page that answers “where did the money go?” every month.

Layout

• KPI cards: income, spending, net saving, savings rate, lowest balance.
• Bar chart: spending by category (sorted largest first).
• Column chart: spending by month.
• Table: top 10 payees (lesson 4’s Payee column + SUMIFS + SORTBY).

Key formulas

Category column:  lesson 3 formula on the combined table
Top category:     =LET(c, UNIQUE(Cat), s, SUMIFS(Withdrawal, Cat, c), INDEX(c, MATCH(MAX(s), s, 0)))
Food share:       =SUMIFS(Withdrawal, Cat, "Food") / SUM(Withdrawal)
Top 10 payees:    =TAKE(SORTBY(UNIQUE(Payee), SUMIFS(Withdrawal, Payee, UNIQUE(Payee)), -1), 10)

Make it monthly

Build on the Power Query table from lesson 7. Each month: drop the CSV, Refresh All, glance at “Other” and add any new keywords. Five minutes instead of an evening.

Turn the formulas you used into named functions with the Excel LAMBDA Library course.

Practice

Download the workbook below. The statement is made up but follows real Indian bank formats (NEFT, NACH, UPI narrations). The Check column turns green when your formula gives the right answer.