How to Create a Monthly Budget That Survives Real Life
Five steps, one spreadsheet, and a weekly habit that takes less time than making chai. Here is the monthly budget method we build into every template.
Sheetzy guide
By Mani Dazzle, Template maker at Sheetzy · 21 November 2026
A working timesheet needs exactly four columns: date, project, start time, end time. Add a fifth for notes if you bill different kinds of work, but resist anything beyond that. Every column you add is friction at the moment you least want friction - when you are switching tasks.
Format the start and end columns as Time (Format, Number, Time) before you enter anything. If you skip this, Sheets stores your entries as text and every formula downstream breaks in ways that are tedious to debug.
Hours worked is end minus start: =D2-C2 if start is in C and end in D. Sheets returns a fraction of a day, which looks wrong until you multiply by 24: =(D2-C2)*24 gives you 7.5 for a seven-and-a-half-hour stretch.
Two traps to know. First, a session crossing midnight needs the date change handled - for most freelancers the honest fix is simply to log it as two rows, one per day. Second, format the result cell as a plain number, or Sheets helpfully re-formats it as a time and shows you 7:30 again.
This is where the log pays rent. A SUMIF per project - =SUMIF(project column, project name, hours column) - tells you exactly where the week went. Most freelancers who do this for the first time find one client quietly eating twice the hours they bill for.
Add a week number column (=WEEKNUM(date)) and a SUMIFS that matches both project and week, and you have the report that answers 'what did I do for you this month?' in ten seconds instead of an evening of scrolling.
Many freelancers bill in 15- or 30-minute blocks. The formula =CEILING(hours*4,1)/4 rounds up to the nearest quarter hour. Use it on the billing row, not on your raw log - your own records should stay exact, or you lose the data that tells you your true hourly rate.
That true rate matters more than it looks. If you charge a fixed fee and your logged hours show the fee works out to less than your floor rate three months running, the log has just told you to raise the price or renegotiate the scope.
The system collapses if logging feels like work. Keep the sheet pinned on your phone's home screen. Use a project dropdown instead of typing. And log at the moment you stop, not at the end of the day - the 4 pm task you forgot to log is the 45 minutes you never bill.
Timers are fine if you like them, but a start-stop row is enough. The best timesheet is the one that is actually complete, not the one with the cleverest automation.
Once hours live in a sheet, invoicing is a copy, not a reconstruction. Filter the month, check the totals per project, and the numbers go straight onto the invoice. Our invoice tracker template keeps the who-has-paid side of the same job, and if you bill clients as a freelancer, the self-employment bookkeeping guide shows how the timesheet, the invoice log and the expense tabs fit into one weekly fifteen-minute routine.
The compounding effect is the real prize: three months of honest logged hours is the best pricing data you will ever own. You stop guessing what to charge because the sheet already knows.
Enter start and end times in two columns formatted as Time, then subtract: end minus start. To turn the result into a decimal number you can bill on, multiply by 24 - so 7 hours 30 minutes becomes 7.5.
Google Sheets stores time as a fraction of a day, so 7.5 hours displays as 0.3125. Multiply the result by 24 and format the cell as a number, or format the result cell as Duration to see 7:30 instead.
Add a project column with a dropdown of your project names. Weekly totals per project become a single SUMIF each, and you can see at a glance where the week actually went.
Yes - share a view-only link, or keep a client-facing tab that pulls their project rows only. Showing your workings builds more trust than any invoice line, and it takes no extra effort once the log exists.
Five steps, one spreadsheet, and a weekly habit that takes less time than making chai. Here is the monthly budget method we build into every template.
Half to needs, a third to wants, a fifth to savings. The 50/30/20 rule is the lowest-effort budget that still works - here is how to run it with real numbers.