In this article:

Free Income Tracker for Google Sheets (2024 Update)

May 8, 2024

Income Tracker in Google Sheets

An income tracker in Google Sheets is useful for monitoring earnings, optimizing financial planning, and enhancing personal or business financial health. 

Get a copy of our free income tracker in Google Sheets here. 

income tracker google sheets

Do not send a request to edit the file. Simply select File > Make a copy.

google sheets income tracker

How to Use our Google Sheets Income Tracker

Follow the steps below to use our income tracker in Google Sheets. 

1. Prepare a New Sheet for Each Month

Begin each month by preparing a new sheet named after the month, like "January". This sheet will track all your daily transactions, both incomes and expenses.

2. Record Transactions Daily Under Correct Categories

For every day of the month, record each transaction under the correct category. If you earn money, put it under "INCOME CATEGORY".

For money spent, use "EXPENSE CATEGORY". Write the amounts in the column for the day it happens.

3. Summarize Monthly Income and Expenses in Total Column

At the end of each category section, notice the "TOTAL" column. This automatically sums up all the daily entries for the month. It gives you a quick look at how much you earned or spent in each category.

At the month's end, review your totals. This helps you see where your money is going and where you might need to cut back or can afford to spend a bit more.

5. Adjust Budgets Based on Previous Month’s Spending

Use what you learn from each month to adjust your spending or saving habits. If you're spending too much on "Eating Out", consider setting a lower budget for that category next month.

6. Link Monthly Totals to the Summary Sheet for a Year-to-Date Overview

Remember, the first sheet in your tracker is a summary. It should pull data from each monthly sheet to give you a year-to-date view. This is done through formulas that reference the total cells in each monthly sheet.

We hope that you now have a better understanding of how to use our free income tracker in Google Sheets. If you enjoyed this article, you might also like our article on our free PTO tracker in Google Sheets or our article on our free bill tracker in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->