How to Set Up Your Free Personal Finance Budget Tracker in Excel (Step-by-Step)

Most people in Ghana know they should be tracking their personal finances. Very few actually do it — not because they don’t care, but because the tools feel too complicated, too expensive, or built for someone else’s financial reality.

This tracker was built for yours.

It’s a free Excel file with nine sheets that work together: a transaction log, a multi-account banking sheet, a zero-based budgeting system, a budget vs actual comparison, and more. No subscription. No app. No syncing. Just open it, set it up once, and use it every day.

Here’s exactly how to get started.

What’s Inside the Personal Finance Tracker

Before the steps, a quick map of what you’re working with:

The tracker comes loaded with sample data so you can see how everything connects before you clear it and start fresh.

Before You Begin: A Note on Sample Data

The file ships with sample transactions, accounts, and budgets already filled in. This is intentional — it lets you see how the system works before you touch anything.

Before you enter your own data, you’ll need to clear:

• Transactions — delete all rows from row 6 downward
• Banking — replace with your real accounts and opening balances
• TransCategories — remove categories you’ll never use, add the ones you need
• ExpenseBudgetPlanner — update amounts to reflect your actual spending plan
• PayDayCenter — update wallet allocations to match your income and accounts
• Upcoming — replace with your own expected bills

Don’t rush this. A clean setup now means clean data forever.

Step 1: Set Up Your Accounts (Banking Sheet)

This is your foundation. Every account you own should live here — it’s what feeds the dropdowns everywhere else in the tracker.

For each account, fill in:

SpendingWallet? = Yes is important — those accounts appear in the budget sheets for expense tracking. Mark savings accounts as No so they’re tracked but kept separate from your spending picture.

Step 2: Review and Customise Your Categories (TransCategories Sheet)

The tracker uses a two-level category system:

Parent Categories are the broad groups:

• Giving — charitable donations, family support
• Fixed Expenses — rent, subscriptions, insurance
• Everyday Expenses — food, transport, airtime
• Savings, Income, Others, Lend/Borrow (not budgeted — just tracked)

Subcategories are the specific line items that appear in your transaction dropdown. Things like Food & Groceries, Transport, Rent/Mortgage.

Go through the TransCategories sheet and:

1. Delete subcategories you’ll never use (e.g. Childcare if you don’t have kids, Pets if you don’t have any)
2. Add any that are missing for your lifestyle
3. Assign each subcategory a Tracking Wallet (column D) — this links it to an account in PayDayCenter for envelope budgeting
4. Assign each subcategory a Pillar — Essentials, Lifestyle, or Future

Critical warning: Once you start entering budget amounts, do not delete, add, or reorder subcategories. Budget values are tied to row position. Rearranging mid-year will misalign your data. Get your categories right before you move to the next step.

Step 3: Set Your Budget Month Start Date

Go to Banking!M1 and enter the day of the month your budget period starts.

If you get paid on the 25th, enter 25. If it’s the 1st, enter 1.

This date controls how the tracker assigns transactions to budget months. Getting it right means your Budget vs Actual numbers will always reflect your actual pay cycle, not the calendar month.

Step 4: Enter Your Monthly Budgets (ExpenseBudgetPlanner Sheet)

Now that your categories are finalised, you can set your budgets.

The ExpenseBudgetPlanner lets you plan for the entire year at once (January through December in columns) or month by month as you go. Categories auto-populate from TransCategories in three groups: Giving, Fixed Expenses, and Everyday Expenses.

Enter a budget amount for each subcategory under each month. Section totals calculate automatically.

Be honest here. A budget that’s aspirational but not realistic will just demoralise you when you check your actuals. Start with what you actually spend, then adjust from there.

Step 5: Set Up PayDayCenter (Optional — For Envelope Budgeters)

If you want zero-based budgeting — where every cedi of your income is assigned a job before you spend it — use PayDayCenter.

Here’s how it works:

1. Select an account from the dropdown in row 6 (e.g. GCB Bank)
2. The categories you assigned to that Tracking Wallet auto-populate below
3. Enter a budget amount for each category
4. The Variance row shows whether you’ve allocated all your income — the target is zero

Do this each payday. It takes five minutes and removes all ambiguity about whether you can afford something.

If zero-based budgeting feels like too much structure right now, skip this sheet. The rest of the tracker works perfectly without it.

Step 6: Clear the Sample Data (Transactions Sheet)

Delete all rows from row 6 downward in the Transactions sheet. Leave row 5 (the header row) intact.

Now you’re ready to start logging your own transactions.

Step 7: Log Your First Transaction

The Transactions sheet is your daily data entry point. For each transaction:

Only fill in the first six columns. Everything else calculates automatically using XLOOKUP from your TransCategories and Banking sheets.

Checking Your Performance (ExpenseBudgetVsActual)

Once you have a few weeks of transactions logged, head to ExpenseBudgetVsActual.

Select a month in cell C2. The sheet pulls your budgeted amounts from ExpenseBudgetPlanner and your actual spending from Transactions, then shows you the variance for each category.

Green means you’re under budget. Red means you’ve overspent.

Review this weekly — not just at the end of the month. Catching an overspend in week two gives you time to adjust. Catching it in week four just gives you regret.

Tips for Staying Consistent

• Record transactions the same day — don’t let them pile up. Five transactions a day takes thirty seconds. Fifty transactions at the end of the month takes a painful hour.
• Transfer to savings the moment your income arrives — not what’s left over at the end of the month. What’s left over is usually nothing.
• Use emojis in category names for fast visual scanning (e.g. 🍔 Food & Groceries, 🚌 Transport). Small thing, surprisingly effective.
• Use the VBA data entry form if it’s enabled — it’s faster (and better) than typing directly into the sheet.
• Rename subcategories freely — names update everywhere automatically. You cannot break anything by renaming.

What’s Next

Once you’re tracking consistently, you’ll start seeing patterns you couldn’t see before — which categories quietly eat your money, where you’re actually disciplined, and what your real net worth looks like month over month.

If you want to go beyond personal finance and learn how to build tools like this yourself — dashboards, automated reports, data models from scratch — that’s exactly what Excel for Professionals covers.

Get the tracker free — no credit card, no catch. Download the Personal Finance Budget Tracker →