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 · $12.99

See what is inside 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 →

Email me these results

We'll send this result plus the matching worksheet. No spam, unsubscribe anytime.

Last updated: October 2026

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