Pen & Sheet

Guides

How to see where your money goes using Google Sheets. Each guide answers one question, with the formulas and a worked example, so you can build it yourself.

How to track expenses in Google Sheets

One log tab, a category dropdown, a paid checkbox and SUMIFS totals per month, plus a comparison with your 12-month normal.

How to budget by paycheck in Google Sheets

Make each month run from one payday to the next with a Paydays tab and one VLOOKUP, and check mid-month whether you're spending faster than usual.