WB WorkbookBarn All workbooks

Free calculator · nothing to download

Expense Tracker

Type the year and month in the blue cells. Everything else is worked out for you.

WHICH MONTH
YOUR MONTH

THIS MONTH SO FAR

Month these numbers cover
TOTAL SPENT
Purchases logged
Largest single expense
Total of every category budget

BUDGET vs ACTUAL

STILL LEFT TO SPEND
Share of the budget used
Categories over budget
OVERSPEND in those categories
Room left in the other categories
Biggest category this month
What that category cost you

AGAINST YOUR INCOME

Income left after this spending
Against your savings target
Savings rate this month
Share of income spent

PACE FOR THE REST OF THE MONTH

Days in this month
Average spend per day logged
Where the month ends at this pace
Which leaves you over or under by

Expense Log

One row per purchase. Pick the category from the dropdown rather than typing it.

DateCategoryWhat was itAmountPaid withMonth (fills itself)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

Budget by Category

Set a budget in the blue column. The rest reads the Expense Log for whichever month you picked on MONTHLY SUMMARY.

CategoryMonthly budgetSpent this monthLeft in budgetBudget usedStatusNotes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

Where that leaves you

Want it as a spreadsheet you own?

The full workbook adds the tabs this page cannot: a monthly log, a dashboard with charts, and your own copy that works offline in Google Sheets or Excel. One purchase, no subscription.

Get the workbook

Keep it

Expense Tracker — the full workbook

Same formulas as this calculator, plus the tabs, the charts and a 12-month history that this page cannot hold. Google Sheets and Excel. One purchase, no subscription.

Buy on Etsy · $12.99What is inside →

Get the next free tool

One email when a new free calculator or trade guide ships. No spam, unsubscribe anytime.

Educational estimates only. These calculators and workbooks do the arithmetic on the figures you enter; they are general-purpose tools, not financial, investment, tax, legal, lending, insurance or construction advice, and no result is a quote, an offer, or a guarantee of any outcome. Results depend entirely on your inputs and assumptions. Verify anything you intend to rely on with a licensed professional — a CPA, attorney, lender, licensed contractor, or your own agent. WorkbookBarn and Marcos Gil accept no liability for decisions made using these tools. Marcos Gil is a licensed Kentucky real estate agent (License No. 296259) and is not a lender, CPA or attorney.

WorkbookBarn · All free calculators · Workbooks