• Skip to main content
  • Skip to primary sidebar

How to Track Income & Expense With Income-Expense Sheet

Reading Time: 3 mins. Posted on September 14, 2020 .

Tracking expenses is the most critial for bloggers and freelancers. Track income and expenses in an easy to use Income-Expense Google sheet

How to Track Income & Expense With Income-Expense Sheet

Controlling expenses is an essential part of any business, and freelancing is no different. I use the income-expense sheet, which helps me visualize my overall expenses and income at a glance.

When things are going great, freelancers avoid tracking expenses and spend as and when needed. I also used to do the same. With time I realized it is fruitful to be monitoring your overall cost to analyze where I have been spending more. Moreover, it helps me identify and cut on any unnecessary expenses to increase my comprehensive income even in good times.

As an example, when my subscribers for my Investment Blog increased, the cost of AWeber increased as well. So I moved over from Aweber to Sendy, which is a fantastic alternative to AWeber.

What is an Income-Expense Sheet?

An income-expense sheet is a simple excel sheet that has very easy added income and expenses under each of the different heads.

Tracking your income and expenses is one of the first things a freelancer and blogger should learn when managing money. However, when you search in Google, you find Income-Expense Excel sheets, but they are so overwhelming that I had to create my income-expense sheet.

I designed this sheet for a specific data entry point of view, so it doesn’t require too much time when adding the details.

If you are looking for an effortless way to keep track of your income and expenses on a monthly and yearly basis, my Google sheet can help you.

Download Income-Expense Google Sheet

I maintain my expense diary in Google Sheet, where each row is a month, and each column is the expense head (or source of income like blog, clients, forums).

Create a copy of the above Google sheet and start using it. Please don’t ask for edit permissions.

There are two sheets, the first one is an expense and the second one is an income sheet.

Expense Sheet

Expense Sheet

I like to keep each expense head as columns and each month in a row. The above format helps me analyze how I am spending each month and what amount I am spending on each service.

When I am trying to cut my expense, I look for an alternate service that can provide better value at the same price.

The above sheet is a much toned-down version but my actual sheet, which even contains the name of the contractor who works for me and if I can get a better deal from those who are doing more regularly for me.

Income Sheet

Similarly, I have an income sheet. Each of my earnings is a column and each month becomes a row.

Income Sheet

Again the above format helps me identify what the quantum of income from each of my websites, clients, and consultation service I make every month, and overall in a year is.

If any of my income sources dwindle, it helps me visualize and work on it in a much better way.

Filling Income Expense Data

Adding data to the sheets can be cumbersome and often ignored. So I like to keep the income-expense sheet as simple as it can get to enter the data. Still, for me, income sheets are often missed and underfilled, but expense sheet isn’t.

Each month when paying credit card bills and other invoices, I fill up the expense sheet. When I am making the payment, I enter the data into the sheet as well.

The basic idea to add data to income reports to be able to track things that work and those that don’t work and concentrate more on things that work and then rinse and repeat.

If you want to add more income or expense head, add the columns and then modify the formula for the new column’s total.

For one time expenses, you can add the columns for the whole year and make an entry when you pay for it. Some of my costs are quarterly (Income tax payment) or even once a year (yearly hosting charges), and I like to have those head.

You are Here: Home / Freelancing / How to Track Income & Expense With Income-Expense Sheet

About Shabbir Bhimani

Blogging Since 2009. If I can leave my high paying C# job in an MNC in the midst of global financial crisis of 2008, anybody can do it. @BizTips I guide programmers and developers to Start and Grow an Online Business. Read more about me here.

May I help You With ...

Upwork Proposal
Finding Clients
Start a Store
Start a Blog
 

Or Help Yourself ..

Primary Sidebar

About Shabbir Bhimani

Blogging Since 2009. If I can leave my high paying C# job in an MNC in the midst of global financial crisis of 2008, anybody can do it. @BizTips I guide programmers and developers to Start and Grow an Online Business.

Get in touch with me on LinkedIn or read more about me here.

Let me Guide You to Start and Grow your Online Business

Download my
FREE eBook NOW
to win more clients.
And it is not an annoying pop-up either

Additional menu

  • Twitter
  • Linkedin

BizTips

Shabbir Bhimani: Start and Grow an Online Business

  • Freelancers Start Here
  • Start An eCommerce Store
  • Start A Blog
  • About
  • Archive
  • Disclaimer
  • Contact
  • Glossary

2009 - 2025 All my content & images are licensed as Creative Commons.

WebTurtles LLP. LLPIN: AAL-5288. Hosted with Linode.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT