Bank statement Excel template

Fill in
Bank statement Excel template — page 1

Fill in

SUMMARY BY CATEGORY AND MONTH
Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them.
First monthAug 2026
CategoryAug 2026Sep 2026Oct 2026Nov 2026Dec 2026Jan 2027Feb 2027Mar 2027Apr 2027May 2027Jun 2027Jul 2027Total
Salary-------------
Business income-------------
Interest & fees-------------
Rent-------------
Utilities-------------
Groceries-------------
Transport-------------
Subscriptions-------------
Shopping-------------
Cash-------------
Savings-------------
Uncategorized-------------
-------------
-------------
-------------
-------------
-------------
-------------
-------------
-------------
Money in4,200.004,851.85----------9,051.85
Money out2,254.491,831.29----------4,085.78
Net1,945.513,020.56----------4,966.07
In categories above1,945.513,020.56----------4,966.07
Check (net = categories)OKOKOKOKOKOKOKOKOKOKOKOKOK
Categories: type them in column A (same spelling as on the Rules sheet). "Uncategorized" collects lines no rule matched.
© Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers.