Guided project · 5 steps Cellwise Plus
Tax-time receipts folder in Excel
Sort a year of receipts into category and month totals, catch the ones with no category, and set aside your share.
You will use: MONTH, SUMIF, COUNTBLANK, ROUND
Starting data
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Date | Payee | Category | Amount | Month | Category | Total | October total | ||
| 2 | Sep 4, 2026 | Print shop | Supplies | 38.6 | Supplies | |||||
| 3 | Sep 15, 2026 | Design app | Software | 54.99 | Software | |||||
| 4 | Sep 22, 2026 | City pharmacy | Medical | 27.4 | Medical | |||||
| 5 | Oct 3, 2026 | Office store | Supplies | 112.35 | Donations | |||||
| 6 | Oct 11, 2026 | Food bank | Donations | 50 | Missing a category | |||||
| 7 | Oct 15, 2026 | Design app | Software | 54.99 | ||||||
| 8 | Oct 19, 2026 | Hardware store | 89.9 | Side income this quarter | 3150 | |||||
| 9 | Oct 27, 2026 | Urgent care | Medical | 95 | Set aside % (your choice) | 0.25 | ||||
| 10 | Nov 2, 2026 | Print shop | Supplies | 22.15 | Amount to set aside | |||||
| 11 | Nov 15, 2026 | Design app | Software | 54.99 |
Build it step by step
Step 1
Pull the month number out of each date in E2 so you can total by month. Fill to E11.
Step 2
Total each category in H2, fill to H5.
Step 3
What did October cost across every category? Put it in K1, using the Month column.
Step 4
A receipt with no category is missing from every category total. Count the blank categories in H6.
Step 5
Work out the amount to set aside in H10: side income times the percentage you chose, rounded to cents.