02 / DATA / 2026

FINANCIAL
TRACKER

Spreadsheet for monthly tracking of income and expenses.

Scroll ↓
01 / OVERVIEW

ORGANIZED MONTHLY TRACKING

Financial tracker built to centralize records and monitor each month's transactions within a single spreadsheet.

TYPEIndependent Project
YEAR2026
AREAData
MY ROLEStructure · Formulas · Logic · Visualization
Vertical view of the financial tracker in Excel
Overview of the spreadsheet's monthly dashboard
02 / OBJECTIVE

A PRACTICAL NEED

The project came from the need to organize the financial activity of a small rural operation, making it easier to record expenses and understand each month's results.

  • Centralize income, expenses, and fixed costs in a single file.
  • Make monthly data entry easier without relying on external systems.
  • Provide quick access to balances and spending distribution.
Income and expense organization in the spreadsheet
Detailed view of financial records
03 / STRUCTURE

ONE MONTH PER TAB

The spreadsheet is organized into 12 tabs, one for each month. Each one brings together income, expenses, fixed costs, balance, and visual indicators.

01
Income:Monthly income records.
02
Expenses:Date, amount, category, and optional description for each entry.
03
Fixed costs:Recurring costs separated from variable entries.
04
Balance:Result calculated automatically at the end of each month.
Overview of the 12 monthly tabs
Table structure and entries by category
Monthly tracking of balance and fixed costs
04 / LOGIC

FORMULAS ACROSS TABS & CATEGORIES

Formulas connect individual entries to monthly summaries, aggregate expenses by category, and reuse information across periods. This reduces manual calculations and keeps the data organized within the spreadsheet.

  • SUM calculates overall totals, while SUMIF consolidates values by category.
  • IF handles specific conditions, while FILTER returns only the required data.
  • Cross-sheet references make it possible to reuse information and keep periods connected.
Formulas and logic rules applied in the spreadsheet
Automatic calculations and category consolidation
05 / VISUALIZATION

MONTHLY VIEW

Each month's data automatically feeds totals, balance, and charts that help visualize spending distribution and the relationship between income and expenses.

WHAT IS DISPLAYED
  • Total monthly income and expenses
  • Automatically calculated balance
  • Spending distribution by category
  • Charts showing distribution and the relationship between income and expenses
Monthly distribution and balance charts in Excel
Visual indicators and consolidated summaries
06 / KEY LEARNINGS

FORMULAS IN PRACTICE

The project expanded my use of conditional formulas, cross-sheet references, and data organization, especially when building calculations based on specific categories.

01

SUMIF and FILTER simplified calculations and selections that would otherwise require manual checking.

02

Cross-sheet references required careful setup to keep each month's values connected correctly.

03

Organizing tabs and categories properly from the start made the spreadsheet easier to maintain.

Formulas and structure in Excel, financial tracker
Monthly spreadsheet tracking and organization
EXPLORE THE PROJECT

Open the spreadsheet and explore its structure, formulas, and visualizations in action.

DOWNLOAD SPREADSHEET ↓Fictional data used exclusively for demonstration.
STACK & TOOLS
  • EXCEL
  • SUM
  • SUMIF
  • IF
  • FILTER
  • TABLES
  • CHARTS

NEXT PROJECT

EXPERIMENTAL E-COMMERCE

Experimental E-commerce, next project

OPEN TO NEWOPPORTUNITIES

If you'd like to discuss a role or project, feel free to get in touch.

GET IN TOUCHDOWNLOAD RESUME