Income Tracker Template
Track every income stream — salary, freelance, interest — with per-source subtotals and a monthly total computed by SUMIF formulas.
Preview
The workbook ships with the example values below plus blank rows — every total is a live formula.
| Date | Source | Description | Amount |
|---|---|---|---|
| 2026-03-01 | Salary | March paycheck | $4,200.00 |
| 2026-03-08 | Freelance | Website project (50%) | $1,200.00 |
| 2026-03-15 | Interest | Savings interest | $12.40 |
| 2026-03-22 | Freelance | Website project (final) | $1,200.00 |
| 2026-03-28 | Rental Income | Unit 4B rent | $1,450.00 |
| By source | |||
| Salary | $4,200.00 | ||
| Freelance | $2,400.00 | ||
| Rental Income | $1,450.00 | ||
| Interest | $12.40 | ||
| Total income | $8,062.40 | ||
How to use it
- Log each deposit with its date, source, description, and amount.
- The By-source table recalculates each stream’s monthly total automatically.
- Rename sources freely — then update the source names in the summary table to match.
- Freelancers: log gross invoice amounts here and expenses in the Expense Tracker template.
Related online calculators
Free for personal use. The file contains no macros — just data, formatting, and standard spreadsheet formulas that work in Excel, Google Sheets, and LibreOffice.