Type the year and month in the blue cells. Everything else is worked out for you.
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.
Date
Category
What was it
Amount
Paid with
Month (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.
Category
Monthly budget
Spent this month
Left in budget
Budget used
Status
Notes
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.
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.
One email when a new free calculator or trade guide ships. No spam, unsubscribe anytime.
Done — you are on the list.
Something went wrong. Please try again.
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.