Quick answer: Create three tabs (Income, Expenses, Dashboard), use the same columns on both logs, add category dropdowns with data validation, total each month with SUMIFS, and chart income vs. expenses. Then log everything once a month.
You don’t need fancy accounting software to keep clean books. For many freelancers and creators, a well-organized Google Sheet is faster, cheaper, and easier to understand. Here’s how to set one up so monthly tracking takes minutes, not hours.
🧱 Step 1: Start with three tabs
- Income: every payment you receive
- Expenses: every business purchase
- Dashboard: monthly totals and profit
Keeping income and expenses separate makes formulas simpler and mistakes easier to spot.
Skip the spreadsheet setupBookkeeping Plus does the math: dashboard, profit, and tax set-aside.
See Bookkeeping Plus🗂 Step 2: Use consistent columns
For both Income and Expenses, use the same core columns:
- Date
- Description
- Category
- Amount
- Payment method or account
- Notes or receipt link
Add a Month column with a formula like =TEXT(A2,”YYYY-MM”) so every row is labeled automatically.
🔽 Step 3: Add dropdowns for categories
Use Data → Data validation to turn your Category column into a dropdown. This keeps your categories consistent (no more “Software”, “software”, and “Apps” as three separate things) and makes reporting accurate.
➕ Step 4: Build your dashboard with SUMIFS
On the Dashboard tab, list months down one column and use SUMIFS to total income and expenses for each month. For example, total income for a month looks like =SUMIFS(Income!D:D, Income!G:G, A2). Then profit is just income minus expenses.
Add a second table that totals expenses by category, so you can see where your money goes.
📊 Step 5: Add a chart
Highlight your monthly totals and insert a column chart. Seeing income and expenses side by side makes trends obvious, like a slow summer or a subscription that crept up.
🎨 Step 6: Make it easy on the eyes
- Freeze the header row
- Format amounts as currency
- Use alternating colors for rows
- Use conditional formatting to flag large or uncategorized expenses
⏰ Step 7: Make it a habit
Set a monthly reminder, pull your bank and card statements, and log everything in one sitting. Once your sheet is set up, the dashboard updates itself.
🚀 Skip the setup
If you’d rather start tracking today, our Google Sheets bookkeeping templates come with the tabs, dropdowns, formulas, and dashboard already built. Just make a copy and start logging.
Related guides
Frequently asked questions
Yes. For many freelancers and creators, a Google Sheet with income and expense logs, category dropdowns, and a SUMIFS dashboard is enough to stay organized and tax-ready.
SUMIFS works well, for example =SUMIFS(Expenses!D:D, Expenses!G:G, A2), where column G holds the month and A2 is the month you’re totaling.
For simple businesses, Sheets is cheaper and easier to understand. As you add employees, inventory, or complex invoicing, accounting software may be worth it.
This article is for educational purposes only and isn’t tax or legal advice. Figures reflect IRS guidance for 2026; check with a qualified tax professional about your situation.
