Your paycheck has a plan. Now your spreadsheet does too.

The Expense Tracker Dashboard is a paycheck-aware Excel spreadsheet that syncs your budget to your actual pay schedule — weekly, bi-weekly, or monthly. Log your transactions once and every tab updates instantly: dashboards, charts, bill calendars, and annual summaries. Zero formula errors. Tested end-to-end.

WHAT'S INSIDE

📋 How To Use
Step-by-step instructions and a full legend — you'll be tracking within minutes.

⚙️ Paycheck Settings
Set your pay frequency (Weekly, Bi-Weekly, or Monthly) and your first paycheck date. The entire spreadsheet recalibrates to your pay cycle automatically.

🗂 Budget Categories
15 categories across five sections — Income, Savings, Bills, Expenses, and Debt — fully customizable to your financial situation.

💳 Transactions Log
One entry point: date, merchant, category, subcategory, and amount. Every other tab pulls from this single log automatically.

📊 Paycheck Dashboard
Select a paycheck number and instantly see:

Your exact pay period dates
Planned vs. actual spending by section
A bar chart breakdown
Two donut widgets: % Spent and % Saved

📅 Bills & Debt Calendar

A bill list with due day, amount, and status badges
An auto-generated monthly calendar grid showing exactly what's due on which day — no more missed payments

🌐 Overview Dashboard

Annual KPI summary
Expense category pie chart
Month-by-month income vs. expense bar comparison
Net balance trend line to track your financial direction over time

BUILT RIGHT. TESTED THOROUGHLY.

Every formula verified — pay-period date math, section rollups, calendar day-of-week placement, and all charts. Recalculates clean with zero errors.

INSTANT DOWNLOAD

✅ Available immediately after purchase
✅ Microsoft Excel only
✅ No subscriptions, no logins — yours forever
✅ Personal use licence included