Home
Excelinator Family Budget Management System - User Guide

Join the community

Connect with us


A thoughtful budgeting system designed by Excel users, for Excel users. Track your household finances with confidence, clarity, and control.

Before you begin

Everything behind this system is already explained step by step in the free YouTube videos.
You can fully rebuild the Excelinator system on your own by following them, or download the ready-made template to avoid starting from scratch (available here).

This user guide will help you

  • understand the system more deeply
  • tailor the template to your own situation
  • see how the different parts connect
  • save time when adapting or extending the file
Quick start
How to Use This Guide

Welcome to your Family Budget Management System. This isn't a single spreadsheet, it's a complete framework designed to grow with your family's needs. You don't need to understand everything at once. Take your time, explore at your own pace, and trust the structure.

Whether you're just starting out or looking to customise advanced features, this guide will help you feel confident and in control. The system works for everyone, regardless of Excel experience.

Find Your Level
Beginner

You're comfortable with basic Excel but prefer to follow established structures. You want a system that works straight away without needing customisation.

Intermediate

You understand Excel formulas and want to adapt categories to match your family's spending patterns. You're ready to make the system your own.

Expert

You're confident with advanced Excel features, including VBA and complex formulas. You want complete control over automation and customisation.

All levels use the same core system. The difference is simply how deeply you interact with it. You can move between levels as your confidence grows, there's no pressure to rush ahead.

What This System Does
A Complete Household Solution

The Family Budget Management System helps you track income, expenses, and savings across multiple accounts. It automatically categorises transactions, highlights unusual spending, and provides clear monthly summaries.

Built on interconnected sheets that work together seamlessly, it solves the common problems of scattered spreadsheets, lost receipts, and unclear spending patterns.

01
Enter transactions

Record income and expenses as they happen

02
Categorise automatically

The system applies codes based on rules

03
Review summaries

See monthly reports and trends

04
Plan ahead

Use insights to improve future budgets

How the Sheets Work Together

Think of this system as a flowing process rather than isolated spreadsheets. Each sheet has a specific purpose, and they all connect to create a complete picture of your family finances.

1
Transaction Entry

Where you record daily spending and income

2
Processing Engine

Applies codes, validates entries, flags issues

3
Summary Reports

Monthly views, trends, and budget comparison

4
Planning Tools

Future budgets based on actual patterns

The structure ensures nothing gets lost. Once you understand the flow, entering data becomes second nature, and insights emerge automatically.

A System You Visit, Not One You Monitor

It's natural to feel a bit daunted when starting a new financial system. Rest assured, the Excelinator is designed to reduce stress, not create it. This system works quietly in the background, ready when you are.

Usage Frequency

This system isn't designed for daily updates. Most users interact with it weekly or monthly, depending on their habits. You don’t need to 'watch' it constantly – the structure keeps things organised in the background.

Setup vs. Long-Term Use

The initial setup takes more time and attention. Once everything is in place, maintaining the system becomes very light and straightforward. Think of it as building a foundation once, then simply keeping it tidy over time.

Take your time getting comfortable. There’s no pressure to rush or be perfect. This system is manageable and designed to fit your life, not the other way around.

Designed for the Long Term
Year After Year Reliability

This system isn't designed for a single month or year, it's built to serve your family for decades. The structure remains consistent while your financial situation evolves. Categories grow with you, reports accumulate history, and patterns become clearer over time.

Whether you're managing student budgets, family expenses, or retirement planning, the same framework applies. You'll develop confidence and expertise naturally, without needing to start over or migrate to new systems.

Beginner – Start Safely
Who This Is For

You're comfortable opening Excel and entering data, but complex formulas feel intimidating. You want a system that works immediately without requiring deep technical knowledge. That's perfectly fine, this system was designed for you.

What You Should Do
  • Use existing categories and codes
  • Fill in transaction amounts
  • Follow the structure exactly as designed
  • Trust the automation to work correctly
What to Avoid
  • Don't modify formula columns
  • Don't delete any sheets
  • Don't create your own category codes yet
  • Don't worry about understanding every cell
Beginner Quick Start
Step 1: Open Budget Planner

Select the year you want to plan for. Fill in the budget amounts for all income and expense codes you use. Some codes can remain blank if they are not relevant to you. Do not fill in any opening account codes, these are handled separately and should remain empty at this stage.

Click "Send budget to DB".

Step 2: Import your transactions

Import transactions via CSV or copy–paste.

Required columns (must not be renamed): Date, Amount, Transaction Details, Merchant Name.
Only import transactions older than 7 days.

Click "Apply Rules".

Step 3: Assign Codes to Remaining Transactions

Red-highlighted rows mean no rule was matched. Manually assign the correct Code to each of these transactions.

Click "Update Real Monthly".

Step 4: Well done!

Go to "Data" → "Refresh All".

You can now view your first transactions in the Dashboard, comparing your planned budget with what you actually spent.

Intermediate – Adapt the System
Who This Is For

You understand how Excel formulas work and feel ready to make this system truly yours. You want categories that reflect your family's actual spending patterns, not generic templates. You're comfortable making intentional changes whilst respecting the underlying structure.

What You Can Customise
  • Rename existing categories to better reflect your real-life spending
  • Add new codes or remove unused ones
  • Modify and reorganise code groupings
  • Create additional rules to further automate the Apply rules process
  • Use dedicated macros to improve import efficiency, such as removing unnecessary columns and adapting the layout to your bank’s export format
  • Calculate your Debt-to-Income (DTI) ratio using smart, automated formulas
Creating Categories and Codes
Identify the Real Need

Start by identifying spending that doesn’t comfortably fit into your existing categories.

⚠️ Keep it simple
Avoid creating too many codes or over-detailed distinctions. This is a family budget, not company accounting. If you wouldn’t realistically analyse this expense separately in 6–12 months, you probably don’t need a new code.

Define Categories First, Then Codes

Always think Category → Codes.

  • Categories give you the big picture (Housing, Transport, Family, Leisure, etc.)
  • Codes are just a way to classify transactions within those categories

Once your Code table structure feels complete, you’re done.

Replicate the code structure in the Budget Planner

📌 This is the only place in the file where you will copy–paste codes and descriptions.

Important rules when editing the Budget Planner:

  • Do not move or reorder rows 1 to 6 (they are required for VBA to work correctly)
  • Keep all codes in column A
  • Make sure total formulas have not shifted after your edits
Send Budget to DB

Click “Send Budget to DB” to finalise your structure.

The system:

  • Verifies that all budget codes match the Category sheet (otherwise it stops)
  • Generates the database lines for each Code × Month × Year based on the current budget
  • Aligns the database exactly with the Budget Planner structure

✅Once done: Your code structure is live in the database. Transactions can be imported and assigned using these codes. No further setup is needed

💡 Reminder
Good categorisation isn’t about detail, it’s about clarity. Always design your categories and codes with future analysis in mind: What will I want to understand about this spending in six months or a year?

Understanding Automation Logic (VBA-driven)
How Rules Work

Transactions are categorised using explicit rules defined in the Rules sheet. Each rule tests keywords against the Merchant Name, Transaction Details, or both. Only transactions with an empty code are processed.

Priority Logic

When multiple rules match the same transaction, the system evaluates all matching rules, not just the first one found. Each rule is compared using its priority value, and the code linked to the highest priority is applied.

This allows broad and specific rules to coexist safely.
Generic rules handle common cases, while higher-priority rules can override them when a more precise match exists.

The behaviour is fully deterministic:

  • The same transaction will always produce the same result
  • No automatic learning or hidden logic is involved

The system strictly follows your rules and priorities, ensuring consistent and controllable categorisation.

Advanced Rule Handling

One specific rule allows a dynamic outcome.

When a rule returns the code 3X, it simply means the transaction is identified as restaurant-related.
The system then decides the final code based on the transaction amount:

  • Small amounts → 33 (Snacks / coffee)
  • Higher amounts → 32 (Restaurant & takeaway)

This mechanism exists only for this case and avoids creating multiple overlapping rules for the same merchant.

It provides flexibility while keeping the rule set simple and easy to maintain.

Visual Validation & Control

After classification, visual cues help you stay in control:

  • Empty codes are highlighted in light red
    → This is an opportunity to understand why the transaction was not classified
    → If the pattern is recurring, you can create a new rule
    (Example: merchant “Coles” can be permanently associated with Groceries)
  • Low-priority matches (priority below 75) are highlighted in light yellow
    → The rule applied, but may deserve review
  • Transactions are automatically sorted by date (most recent first)

💡 Reminder

Good automation isn’t about creating many rules, it’s about creating the right ones.

When adding a new rule, think ahead:

  • Is the keyword found in the Merchant name or Transaction details?
  • Should the match be exact or simply contained in the text?
  • What priority makes sense, knowing that priorities below 75 will be highlighted in yellow for review?

Well-designed rules make future classification faster, cleaner, and easier to trust.
Always ask yourself: Will this rule still make sense in six months or a year?

Inserting Opening Balances with Category 'X'

Category 'X' is crucial for a smooth start, ensuring your financial overview is accurate from day one. It helps you accurately bring your existing funds into the system.

What is Category 'X'?

This special category brings your existing balances into the system when you first start the Excel file. It applies to your spending and savings accounts (like Holiday or House Savings).

Why is it essential?

Using Category 'X' ensures your dashboard starts with the correct real-world balance. This provides an accurate financial snapshot and allows you to track the evolution of these accounts over time.

The Simple Process

Insert one or more transaction lines using Category 'X'. Each line accounts for part or all of your balance before using the file. The total of these lines should match your actual starting balance.

Annual Refresh

Bank and savings accounts are "reopened" each year. On 1 January, take the 31 December closing balance and reinsert it as an opening balance for the new year using Category 'X'.

Key Distinction

Bank and savings account balances carry forward year-to-year. However, income and expense categories reset annually and do not use Category 'X', reflecting their yearly nature.

Recording Savings Interest Correctly

The Transactions sheet is designed primarily for your main bank account. When recording interest from a separate savings account, it's crucial to follow a specific two-step method to maintain accurate balances across all your financial accounts.

Common mistake: Directly importing a single interest line from a savings account would incorrectly increase your main bank balance. The system needs to know where that money originated and where it ultimately resides.

Step 1: Record as Income

Input the interest amount as a positive transaction on your main Transactions sheet. Assign it to an 'Income: Interest' category code. This correctly registers the interest as income earned.

Step 2: Redirect to Savings

Duplicate the line created in Step 1. Change the amount to a negative value and assign it to the specific savings account's category code (e.g., 'Asset: Holiday Savings'). This moves the interest into the correct account within your system.

The result: Interest is accurately accounted for as income, your main bank balance remains unaffected (as the 'outflow' from the main account offsets the initial 'income' entry), and your savings account balance correctly reflects the increase.

Remember: One entry from a different account = two transaction lines. This keeps all balances consistent.

Understanding and Fixing 'ERROR' in the 'Processed' Column

Encountering "ERROR" in your 'Processed' column can be a bit puzzling, but it's a common issue with a straightforward solution. It simply means the system couldn't find a place to put your transaction.

Specifically, "ERROR" indicates a valid transaction, but no corresponding Code × Year × Month entry existed in the system's database. This usually means the category code was not budgeted for that particular year.

How to Resolve the 'ERROR' Step-by-Step
01
Add Missing Code

Go to the 'Category' sheet and add the missing code there, ensuring it's properly defined.

02
Update Budget Planner

Add the same code to your 'Budget Planner' sheet. The amount can be 0 if you don't intend to budget for it.

03
Send Budget to DB

Click "Send budget to DB" to generate the necessary missing database line for the new code.

04
Clear Transaction Error

Go back to your transaction and clear the "ERROR" value from the 'Processed' column.

05
Re-run Update

Re-run "Update Real Monthly". The transaction will now process normally.

Remember, the VBA only processes transactions when the 'Processed' cell is empty. Once the structure exists, the transaction will flow through correctly.

"ERROR doesn’t mean something is broken — it just means the structure wasn’t ready yet."

Expert – Extend and Automate
Who This Is For

You're confident with advanced Excel features including VBA macros, complex nested formulas, and data validation rules. You want complete control over how the system processes transactions, generates reports, and maintains data consistency across years.

1
Advanced Customisation

Modify validation rules, create custom summary views, and design personalised dashboard layouts that highlight the metrics most important to your family.

2
VBA Logic Enhancement

Extend automation scripts, add custom buttons for routine tasks, and create macros that handle bulk categorisation or data import from bank statements.

3
Long-Term Data Architecture

Optimise formulas for performance, implement archiving strategies for historical data, and ensure consistency across growing datasets spanning multiple years.

Key Rules and Safeguards
Why Protection Matters

The system includes intentional restrictions designed to prevent accidental data corruption. Understanding why these safeguards exist helps you work confidently within the structure whilst knowing exactly which areas are safe to modify.

Data Integrity & Input Guidance

Columns highlighted in yellow contain formulas and should not be modified. They are designed to automatically calculate totals and ensure the system works correctly.

Many other columns use dropdown lists to guide your input and prevent typos, helping maintain clean and consistent data throughout the file.

Protected Sheets

The database sheet is protected. Each time a VBA process interacts with it, the sheet is automatically re-protected.

In normal use, there is no need to edit the database manually. All updates are handled through the system’s buttons and workflows, ensuring data integrity and long-term consistency.

Processed Status

The “Processed” marker (Y) prevents double-counting by ensuring that each transaction is handled only once by the system. Transactions marked as processed will not be processed again, even if you click the buttons multiple times.

This allows you to safely rerun actions without risk and acts as a clear confirmation that the data is final and already integrated.

Budget Update Logic

When sending a budget to the database, the system checks whether an entry already exists for the same Code × Month × Year.
If data is already present, you will be prompted to confirm whether it should be overwritten.

This makes it possible to replan or correct your budget if needed, while ensuring nothing is replaced silently.
You stay in control and are always warned before existing data is updated.

Trust and Data Integrity
Built on Reliability

Every safeguard exists to give you confidence. When you see a protected cell or validation rule, it's there to prevent silent errors, the kind that corrupt data without obvious warnings.

These protections aren't restrictions on your freedom; they're the foundation that lets you enter data quickly without constantly double-checking every cell. The system watches for problems so you don't have to.

Prevention Over Correction

It's far easier to prevent errors than fix corrupted historical data. Validation stops problems before they begin.

Consistent Reports

Protected formulas ensure summary reports match transaction details. You can trust the numbers without manual verification.

Future-Proof Structure

Safeguards maintain integrity even as your data grows. Next year's entries work exactly like this year's.

Common Mistakes and Recovery
Mistakes Are Normal

Everyone makes data entry errors. Perhaps you've entered an expense as income, used the wrong category code, or accidentally duplicated a transaction. These mistakes are completely normal, and importantly, nothing is irreversible.

The system is designed with correction in mind. Every mistake has a straightforward solution that doesn't require deleting historical data or starting over. Here's how to fix the most common issues calmly and confidently.

Fixing Common Issues
Dashboard Not Updating

If your data is entered correctly but the dashboard doesn’t update, simply go to Data → Refresh All. Excel needs to refresh PivotTables to reflect any database changes.
💡Reminder: planning your budget and importing transactions both modify the database, so a refresh is required to see the updates in the dashboard.

Wrong Category Code
  • Duplicate the transaction line
  • Assign the same code and reverse the amount sign
  • Reprocess the transaction → this cancels the original entry
  • Duplicate the line once more and assign the correct code
Forgotten Transactions

Add late entries with their actual transaction date, not today's date. The system will incorporate them into the correct month's summaries automatically, preserving accurate historical records.

Duplicate Transactions

If a transaction was imported twice, there’s no need to edit or delete anything.
Simply cancel the duplicate using the same reversal procedure: duplicate the line and invert the amount.

The system will net it out automatically, keeping your history clean and accurate.

Incorrect Sign (Positive/Negative)

Wrong sign when opening an account? No problem.
Use the same procedure as for a wrong code: cancel the line, then re-enter it with the correct sign.

Something Looks Wrong in the Dashboard

If something looks incorrect in the dashboard, it usually means something needs attention earlier in the system.

The dashboard is an indicator, not a place to fix data.
Always check upstream: Transactions (codes, signs, processed status), Budget structure (codes sent to DB) and Database updates (refresh applied)

Once the underlying data is corrected, the dashboard will reflect it automatically after a refresh.

How This System Grows With You
A Journey, Not a Destination

You don't "finish" this system. Instead, you grow with it over months and years. Today's beginner becomes tomorrow's confident intermediate user, not through pressure or obligation, but through natural familiarity and gradually expanding curiosity.

Your needs change. Perhaps you start with basic expense tracking, then add savings goals, then begin analysing spending patterns, then create custom categories for new life stages. The system accommodates every phase without requiring migration to new tools.

1
First Month

Learning basic entry, following existing categories, building confidence with the structure.

2
Six Months

Adding personal categories, understanding reports, recognising spending patterns naturally.

3
One Year

Customising automation rules, creating budget forecasts, using historical trends for planning.

4
Beyond

The system becomes second nature—a trusted financial companion that knows your family's story.

Beginner Today Doesn't Mean Beginner Forever

Starting at the beginner level is wise, not limiting. It means you're building solid foundations rather than rushing into complexity before you're ready. Many experts began exactly where you are now.

As you use the system regularly, you'll naturally notice opportunities to customise. A category that doesn't quite fit. A report you wish existed. A manual step you'd like to automate. These observations signal you're ready for the next level ; not because you must advance, but because you genuinely want to.

The beauty of this system is that growth happens organically. There's no exam, no requirement to unlock features. When you're ready for more control, the tools are waiting. Until then, the beginner path serves you completely.

For Excel Lovers, By an Excel Lover
A Final Word

This system was created by someone who genuinely enjoys Excel ; not as a chore, but as a powerful tool for bringing order to complexity. It's designed with the care and attention that comes from personal use over years, not corporate templates built by people who don't use their own creations.

Whether you're tracking your first budget or managing decades of financial data, this system respects your intelligence whilst meeting you where you are. You understand what this system is, you know where you belong, and you can start calmly without pressure.

"The best financial system is the one you'll actually use."