Monthly Expenses Spreadsheet in Excel From Real Spending

Quick Answer: A useful monthly expenses spreadsheet starts from what you actually spent, not what you remember. Put all your bank and card transactions in one Excel table with columns for date, payee, amount, category and month, add a category to each row, and build a PivotTable with categories down the side and months across the top. Each month, add the new statement's rows to the table and refresh.

Most monthly expense trackers fail because they depend on typing in every purchase. A better design takes the transactions your bank already recorded, adds one column of judgment (the category) and lets Excel do the totals. The layout below needs one sheet of data, one small list of categories and one pivot table, and it stays accurate because the numbers come straight from your statements.

What goes in a monthly expenses spreadsheet?

Use a single sheet named Spending for every transaction from every account, and turn it into an Excel table (Ctrl+T) so formulas and the pivot grow with it. These columns are enough:

Keep amounts signed. When a statement uses separate debit and credit columns, combine them first with =[@Credit]-[@Debit]. A signed column means a refund simply cancels part of a purchase in the totals, and money moving in never gets counted as spending.

The Month column uses text like 2026-10 on purpose. It sorts correctly, it reads the same in every locale, and the pivot treats each month as a clean label without any date grouping.

How do you get your statement rows into Excel?

You want rows, not a picture of a statement. Three routes, in order of effort:

1. The bank's own download. Most online banking offers a CSV or Excel export of recent activity. When it exists, use it.
2. Excel's Get Data from PDF. Included in recent Excel versions for Windows. It works on simple single-table statements and struggles when a page has several tables or wrapped descriptions.
3. A statement converter. QuickBankConvert reads bank and credit card statement PDFs into one row per transaction with date, description and signed amount, which maps straight onto columns A to C. A free account downloads Excel for a few statements a month; the PDF to Excel page shows the output.

Paste the new rows under the last row of the table. The table expands and the Month and Week formulas fill automatically.

Which categories should you use?

Make a second sheet named Lists with your groups in one column and point a data validation dropdown on column E at that range, so every row picks from the same list. A starting set for a household:

• Housing (rent or mortgage, HOA)
• Utilities (power, water, internet, phone)
• Groceries
• Eating out
• Transport (fuel, transit, parking, car payment)
• Insurance
• Health
• Kids and pets
• Shopping
• Subscriptions
• Travel
• Gifts and giving
• Fees and interest
• Savings (transfers out to savings or investments)
• Income (pay, refunds you don't want netted, interest)

Two rules keep the data clean. Card payments from checking are transfers, not spending; give them a group like "Card payment" and filter it out, otherwise every purchase counts twice, once on the card and once when you pay the card. And pick one home for each payee. If a supermarket is "Groceries" in March, it should be "Groceries" in April.

To speed up categorizing, add a third column on Lists that pairs payee keywords with groups, then use a lookup in a helper column to suggest a group. You still review each row, but most will be right.

How do you see spending by month?

Select any cell in the table and follow Microsoft's PivotTable steps: Insert, PivotTable, choose New Worksheet, then OK. In the PivotTable Fields pane:

• Drag Group to Rows.
• Drag Month to Columns.
• Drag Amount to Values (it will show as Sum of Amount).
• Drag Account to Filters if you want to look at one card at a time.

You now have a grid of every category by every month. Spending shows as negative numbers; if you'd rather see positives, add a calculated column to the table, =-MIN(0,[@Amount]), and use that in Values instead.

When you add next month's rows, right-click the pivot and choose Refresh.

A summary without a pivot

Some people prefer a fixed grid they can format. Put groups in A3:A17 of a sheet named Summary, months like 2026-01 in B2:M2, and in B3:

=-SUMIFS(Spending[Amount],Spending[Group],$A3,Spending[Month],B$2)

Fill right and down. Microsoft's SUMIFS documentation notes that the sum range comes first, unlike SUMIF, which is the usual cause of a SUMIFS that returns zero.

What should you look at each month?

A spreadsheet only helps if you read it. Ten minutes after each update:

1. Total spending against total income for the month. Is the gap where you expected?
2. The three biggest groups. Housing will be one; are the other two what you thought?
3. Fixed vs flexible. Filter column H to Y for the bills you can't change quickly, and look at what's left. That is the money you can actually steer.
4. Anything new. Sort the month by Payee and scan for names you don't recognize, especially small recurring ones.
5. Week by week. For a tight month, a second pivot with Week in Rows shows where spending bunched up.

If you want to set targets for each group, that is a budget. Our budget spreadsheet guide builds one from the same data, and the pivot table walkthrough goes deeper on pivots.

How do you track a household with several accounts or people?

The single-table design handles this without extra sheets. Every row already carries an Account value, so a joint checking account, two personal cards and a store card can all live in Spending side by side. Add one more column, Who, if two people share the tracker and want to see their own spending; fill it once per account, since each card usually belongs to one person.

Then a pivot with Who in Columns and Group in Rows answers the question couples actually argue about, without anyone typing receipts. For shared bills paid from one person's account, decide a rule up front, such as tagging them Who = Shared, so the totals stay fair. Our monthly bills spreadsheet covers due dates and autopay for those shared bills.

How do you keep it updated without it becoming a chore?

Tie the update to the statement cycle. When each account's statement posts, download it, add the rows, categorize, refresh. Batching once a month takes about as long as a single sitting with a coffee, and you never have half a month of typed-in purchases to reconcile against the bank.

Before you trust a month, check one thing: the sum of the Amount column for each account should equal that statement's closing balance minus its opening balance. If it doesn't, rows are missing or duplicated.

Related guides

• Expense tracker in Google Sheets
• Monthly bills spreadsheet
• Budget spreadsheet from bank statements