A personal finance spreadsheet is a four-tab system for recording transactions, planning spending, and reviewing cash flow. The tabs are:
- Transactions: income, purchases, bills and transfers
- Lists: account names, transaction types and spending categories
- Budget: planned spending compared with actual spending
- Dashboard: income, expenses, cash flow, savings and goals
The examples below use the date 9/20/2026 and a monthly label such as 2026-09.
Use Google Sheets if you want a free, cloud-based spreadsheet. Use Microsoft Excel if you have Microsoft 365 or prefer to work offline. Both support formulas such as SUMIFS, which adds amounts that match multiple conditions, such as a category and a particular month.
Personal Finance Spreadsheet Structure
| Tab | Purpose | Main Information |
|---|---|---|
| Transactions | Record financial activity | Date, account, type, category and amount |
| Lists | Keep entries consistent | Categories, accounts and transaction types |
| Budget | Compare planned and actual spending | Budget, actual and remaining |
| Dashboard | Review your financial position | Income, expenses, cash flow and savings |
You can also start with a ready-made template. Microsoft provides budget templates for monthly budgeting, household finances and related calculations.
Step 1: Create the Transactions Tab
Create these columns in row 1:
| Column | Heading | Example |
|---|---|---|
| A | Date | 9/20/2026 |
| B | Account | Checking |
| C | Type | Expense |
| D | Category | Groceries |
| E | Description | Supermarket |
| F | Amount | 84.62 |
| G | Month | 2026-09 |
Enter each transaction once. Use positive numbers in the Amount column. Use the Type column to show whether the transaction is income, an expense or a transfer.
In cell G2, enter:
=TEXT(A2,"yyyy-mm")
Copy the formula down the column. The formula creates a month label that the budget and dashboard formulas can use.
Recommended Transaction Types
Use three transaction types:
- Income: salary, freelance income, interest or refunds
- Expense: purchases, bills, fees and debt interest
- Transfer: money moved between your own accounts
Keeping transfers separate stops the spreadsheet from treating a checking-to-savings transfer as spending.
How to Record Credit Card Transactions
Choose one method and use it consistently:
- Record the purchase as an expense when you make it, then record the credit card payment as a transfer.
- Record only the payment as an expense and leave out the individual purchases.
The first method gives you better category information. Do not count both the purchase and the payment as expenses, or your spending total will be too high.
Step 2: Add a Lists Tab
Create lists for your dropdown menus.
Transaction Types
Income
Expense
Transfer
Example Accounts
Checking
Savings
Credit Card
Cash
Brokerage
Example Categories
Salary
Freelance
Housing
Utilities
Groceries
Dining Out
Transportation
Insurance
Healthcare
Debt Payments
Subscriptions
Entertainment
Personal
Savings
Investments
Other
Start with broad categories. Ten to twenty categories are easier to maintain than dozens of highly specific ones.
Dropdowns prevent spelling differences such as Dining, Dining Out and Restaurants from splitting your totals. Google Sheets supports dropdown lists through Data > Data validation. Excel supports them through Data > Data Validation.
Step 3: Build the Monthly Budget Tab
At the top of the Budget tab, create a month selector:
| Cell | Content |
|---|---|
| A1 | Budget month |
| B1 | 2026-09 |
Create the budget table starting in row 4:
| Category | Planned | Actual | Remaining |
|---|---|---|---|
| Housing | 1,500 | ||
| Groceries | 500 | ||
| Transportation | 250 | ||
| Dining Out | 200 | ||
| Savings | 400 |
In C5, calculate actual spending for the category in A5:
=SUMIFS(Transactions!$F:$F,Transactions!$C:$C,"Expense",Transactions!$D:$D,$A5,Transactions!$G:$G,$B$1)
This formula adds amounts from the Transactions tab when:
- The type is
Expense - The category matches
A5 - The month matches
B1
SUMIFS works well for monthly category reporting because it adds totals that meet multiple conditions.
In D5, calculate the amount left:
=B5-C5
Copy both formulas down the table.
A positive Remaining value means you are under budget. A negative value means you have exceeded the planned amount.
Step 4: Create the Dashboard Tab
The Dashboard tab should answer four questions:
- How much money came in?
- How much money went out?
- How much cash flow remains?
- How much am I saving?
Assume B1 contains the selected month, B3 contains monthly income and B4 contains monthly expenses.
| Metric | Cell | Formula |
|---|---|---|
| Income | B3 | =SUMIFS(Transactions!$F:$F,Transactions!$C:$C,"Income",Transactions!$G:$G,$B$1) |
| Expenses | B4 | =SUMIFS(Transactions!$F:$F,Transactions!$C:$C,"Expense",Transactions!$G:$G,$B$1) |
| Net cash flow | B5 | =B3-B4 |
| Savings rate | B6 | =IFERROR(B5/B3,0) |
The income formula is:
=SUMIFS(Transactions!$F:$F,Transactions!$C:$C,"Income",Transactions!$G:$G,$B$1)
The expenses formula is:
=SUMIFS(Transactions!$F:$F,Transactions!$C:$C,"Expense",Transactions!$G:$G,$B$1)
Net cash flow is:
=B3-B4
The savings rate is:
=IFERROR(B5/B3,0)
Format the savings rate as a percentage. Format the other figures as currency.
Step 5: Add Irregular Expenses and Financial Goals
Monthly budgets can miss expenses that occur once or twice a year. A sinking funds table spreads those costs across the year.
Sinking Funds
| Expense | Annual Cost | Monthly Amount |
|---|---|---|
| Car insurance | 1,200 | 100 |
| Gifts | 600 | 50 |
| Home repairs | 1,000 | 83.33 |
Use this formula for the monthly amount:
=B2/12
Add the monthly amount to your budget as a planned expense or savings transfer. This spreads annual bills across the year instead of leaving one month to absorb the full cost.
Financial Goals
Create a separate goals table:
| Goal | Target | Current | Remaining |
|---|---|---|---|
| Emergency fund | 5,000 | 2,000 | 3,000 |
| Vacation | 2,400 | 600 | 1,800 |
| Debt payoff | 8,000 | 5,500 | 2,500 |
In the Remaining column, enter:
=B2-C2
To calculate a monthly contribution, add a Months Remaining column and use:
=IFERROR(D2/E2,0)
Step 6: Add Controls That Prevent Mistakes
The spreadsheet only works if the data stays consistent. Add these controls:
- Freeze the top row on the Transactions tab.
- Turn on filters so you can view one account, category or month.
- Format dates as dates and amounts as currency.
- Use dropdowns for Type, Account and Category.
- Protect cells containing formulas.
- Use conditional formatting to highlight negative budget balances.
- Keep a backup copy before making major changes.
- Reconcile account balances with bank and credit card statements each month.
For a more structured file, convert the transaction range into a table where available. Google Sheets tables can apply structure and column types to a range. Excel tables can extend automatically when new records are added.
Step 7: Use the Spreadsheet on a Regular Schedule
During the Week
Add new transactions or import them from your bank. Categorize them while you still remember what each purchase was for.
At the End of the Month
- Confirm that all income was entered.
- Check the spreadsheet against account statements.
- Review categories that exceeded their budgets.
- Move unused budget amounts toward a goal if appropriate.
- Set the next month in the Budget tab.
The Consumer Financial Protection Bureau also uses a monthly income-and-expense worksheet for household budgeting. Its format separates income, spending and financial goals rather than tracking everything as one balance.
Start With One Tab If Needed
Four tabs may be more than you need at the beginning. Start with a transaction log if that is the version you will keep updated:
| Date | Type | Category | Description | Amount |
|---|---|---|---|---|
| 9/20/2026 | Income | Salary | Paycheck | 2,400 |
| 9/20/2026 | Expense | Housing | Rent | 1,200 |
| 9/21/2026 | Expense | Groceries | Supermarket | 84.62 |
Add the Budget and Dashboard tabs after you have recorded two to four weeks of transactions. Starting small is fine. The system becomes more useful when you can update it regularly and review it at the end of each month.