Daily Sales Tracker Walkthrough (Google Sheets) to Maximize Income
Most business owners don’t need more ideas, they need clear numbers they can check every day. A simple daily sales tracker can turn random sales into a pattern you can spot, repeat, and improve.
This post walks through the Daily Sales Tracker Steph shares, including how to set it up, where to log sales, and how the dashboards update automatically as you go.
Getting Your Daily Sales Tracker Template Ready
Once you grab the tracker, you’ll receive an email with a link to the Google Sheets template. When you open it, look to the right side and choose Use template. That creates your own copy in Google Drive, so you can edit it freely without affecting the original.
Here’s the basic flow:
- Open the email with the tracker link.
- Open the Google Sheets file.
- Click Use template.
- Work from your own copy in Google Drive.
When the sheet opens, it starts on the Yearly Dashboard tab. If anything is blocking your view (like a webcam bubble in a video), you can just scroll or reposition your window so the dashboard is easy to see.
You can also grab the file directly here: Daily Sales Tracker freebie download. It’s beginner-friendly Google Sheets, so you don’t need fancy spreadsheet skills to use it.
Quick Setup for Your Business (Setup Tab)
Before you start logging sales, go to the Setup tab. This is where you customize the tracker so the rest of the sheet makes sense for your goals and your income streams.
In the Setup tab, you can adjust:
- Year: Set the tracker to the year you’re using.
- Daily goal: Change your daily target anytime (for example, from $100 to $150).
- Current month: Pick the month you’re in so your monthly snapshot lines up.
- Revenue sources: List where money comes from, so you can tag each transaction correctly.
- Google URL image (optional): Add an image URL if you want something other than the confetti emoji when you hit your goal.
That last one is optional, but it’s kind of fun. If you leave it alone, you’ll still get the built-in celebration icon when you hit your daily goal. If you add a URL, the sheet should show that image instead.
Example revenue sources you might add
The tracker gives you a dedicated space to list income sources. Steph mentions examples like The Sheet Boss as a primary income source, another brand or stream as a secondary income source, plus affiliates and side hustles like DoorDash or Uber.
Here’s what that can look like in practice:
| Revenue source you list in Setup | Example type of income |
|---|---|
| The Sheet Boss | Primary income |
| Second Biz | Secondary income |
| Affiliate income | Regular affiliate commissions |
| DoorDash | Side hustle |
| Uber | Side hustle |
Once these are set, you can select them later in the Transaction Log instead of typing them every time.
See Your Progress on the Yearly Dashboard
The Yearly Dashboard is your big-picture view. It’s designed to show you, across the entire year:
- Which days you hit your daily goal
- How much you made each day (even on days you didn’t hit the goal)
- Your annual sales total, updated automatically as you log transactions
This matters because you don’t have to guess how the year is going. You can look at the dashboard and see the full story, including the slower days that usually get ignored.
The sheet also connects your daily tracking to monthly results. As you log daily sales, the monthly tabs update, and when you hit your monthly goal, the sheet will reflect that with a “goal reached” message (based on how the tracker is set up).
Track Monthly Wins With the Monthly View (and Progress Bar)
The Monthly View is where you see your month in one place. It includes:
- Your total for the month
- Your monthly goal, based on your daily goal and the number of days in that month
- A progress bar that fills as you log more income
Steph gives a clear example: if your daily goal is $100 and the month has 31 days, the tracker sets a monthly goal of $3,100.
As you enter transactions, the progress bar updates so you can quickly see how close you are. This is helpful when you don’t want to do mental math every day. You can open the sheet, glance at the bar, and know where you stand.
Goal days vs. non-goal days
The sheet still tracks all income, whether you hit the goal or not. The difference is visual:
- When you reach your daily goal, you’ll see the confetti popper (or your optional image).
- When you don’t reach your daily goal, you won’t see the image, but the income still counts toward your totals.
This keeps the tracker honest. It celebrates wins without hiding the days that teach you something.
Boost Consistency With the Visibility Tracker
Sales don’t happen in a vacuum. If you’re promoting a freebie, sharing content, or showing up in different places online, you want a place to track that effort next to the money.
That’s what the Visibility Tracker tab is for. It’s a simple log where you can throw in dates and note what you did to get seen.
You can track things like:
- The date you shared
- Where you shared your work (your platform, community, or channel)
- Which freebie was promoted
- How the experience went
- Whether you gathered any leads
- Whether that freebie was shared (a yes or no style checkbox)
A clean way to think about it is like a companion log to your sales. When you compare visibility actions with sales results, patterns often show up fast.
A simple way to fill it out
| Date | Where you shared | Freebie promoted | Experience notes | Leads gathered | Shared freebie |
|---|---|---|---|---|---|
| (your date) | (platform) | (freebie) | (quick note) | (number) | Yes/No |
On the right side of this tab, Steph also mentions a small directory with information to help you “get visible.” It’s there as a quick reference while you plan where to show up and what to post.
Master the Transaction Log (The Most Important Tab)
If you only use one tab every day, it’s the Transaction Log. This is where everything starts.
Every dashboard and progress bar updates based on what you enter here, so once you build the habit of logging sales, the rest of the tracker does the heavy lifting.
Step 1: Enter the date (make sure it’s current)
Steph calls out a common issue: dates can be set wrong. In her sheet, the date field was set to January 2026, so she adjusted and entered mock dates to demonstrate.
She uses examples like:
- 1/3/26
- 1/23/26
- 1/26/26
The main point is simple: make sure your entries use the correct date, so they show up in the right month and year.
Step 2: Enter the amount earned
In the example, Steph adds three sales amounts:
- $75
- $150
- $300
You can log income even if it doesn’t hit your daily goal. That’s part of what makes the tracker useful, it helps you see the real trend line instead of only counting “perfect” days.
Step 3: Choose the income type and category
The sheet includes dropdowns so you can tag your income. Steph mentions choosing:
- The income type, like a sale or an affiliate
- A category the transaction belongs to
If you need more dropdown options, there’s a small box you can click to add more.
Step 4: Select the source (from your Setup tab)
Remember the revenue sources you listed in Setup? This is where they come back. You can choose the source from that list, which keeps your tracking consistent across the year.
Step 5: Add a short description (optional but useful)
You don’t have to write notes, but a short description can help later when you’re trying to figure out why a day went well or felt slow.
Steph shares examples like:
- “I made extra sales today because XYZ.”
- “I didn’t make as many sales today because I wasn’t as visible as I’m supposed to be.”
Those quick notes can become your best data. A month from now, you won’t remember what happened on a random Tuesday, but your sheet will.
Example of how a few entries might look
| Date | Amount | Income type | Source | Description |
|---|---|---|---|---|
| 1/3/26 | 75 | Sale/Affiliate | (your source) | Notes about the day |
| 1/23/26 | 150 | Sale/Affiliate | (your source) | Notes about the day |
| 1/26/26 | 300 | Sale/Affiliate | (your source) | Notes about the day |
(Your sheet will have its own exact columns and dropdown names, this table just mirrors what Steph demonstrates.)
What updates automatically after you log transactions
Once you fill in the Transaction Log, the sheet pushes that data into the rest of the tracker:
- The Monthly View fills in with your daily totals.
- The confetti icon appears on days you hit your goal.
- The progress bar moves as you get closer to the monthly target.
- The Yearly Dashboard updates to reflect goal days and daily income.
In Steph’s example, the progress bar updates and shows she’s 17% of the way to her monthly goal (based on the amounts she entered).
Keeping the Transaction Log Easy to Use All Year
A log only works if it stays usable. As the year goes on, you’ll have a lot of rows. Steph shares two ways to keep the sheet comfortable to work in.
Option 1: Hide old rows
If you want less clutter, you can right-click on rows and choose to hide them. This is useful if you don’t want to see older entries while you’re working on current ones.
Option 2: Freeze rows so headers stay visible
If you scroll a lot, it’s easy to lose track of which column is which. Freezing rows keeps your headers and key rows “stuck” at the top.
Steph demonstrates the general idea:
- Highlight up to the row you want to freeze (she mentions freezing up to row 16).
- Go to the View menu.
- Choose Freeze, then freeze up to that row.
After that, you can scroll through the rest of the transaction list while the top section stays in place.
What This Daily Sales Tracker Helps You See (Without Overthinking It)
The real value of this tracker is that it builds a quick daily check-in. You log the sale, and the sheet shows you what’s happening.
Over time, that makes it easier to:
- Track sales without guesswork
- Spot momentum and slow days faster
- Tie visibility efforts to results
- Stay consistent because you can see progress building
Steph describes it in plain terms: no fluff, no overwhelm, just a system that works. It’s also part of The Sheet Boss system and built in Google Sheets, so it stays simple.
Conclusion
If you’ve been relying on memory or random notes to track income, a daily sales tracker gives you a clean record you can actually use. Set your year and goals in Setup, log income in the Transaction Log, and let the monthly and yearly dashboards update for you. Add notes on visibility, and you’ll start seeing why certain days perform better than others.
Get the free tracker here: Daily Sales Tracker freebie download. For more spreadsheet tools and resources, Steph shares more at The Sheet Boss website.