Money Excel - Personal Finance Blog

Menu
MENUMENU
MENUMENU
  • Home
  • Business Ideas
    • 225 Small Business Ideas
    • 40 Online Business Ideas
    • 20 Business Ideas for Beginners
    • 20 small manufacturing business
    • 30 Food Business Ideas
    • 100 Business Ideas low investment
  • Stock Market
    • Best Demat & Trading Accounts 2020
    • Best Stocks 2020 by Experts
    • Best Virtual Trading Apps
    • Best Stock Screener
    • Best Discount Brokers in India
    • Multibagger Stocks of LockDown
    • Rakesh Jhunjhunwala Portfolio
  • Mutual Funds
    • Best Mutual Funds 2020-21
    • Best Direct Mutual Fund Platform
    • Best Mutual Fund Mobile Apps
  • Incometax
    • Income Tax Slab FY 2020-21
    • Income Tax Calculator FY 2020-21
    • Income Tax Refund Request
    • Pay Advance Tax Online
    • Download New 15G -15 H Forms
  • Investment
    • Best Investment Ideas 2020
    • Long Term Investment Options
    • Best Investment Regular Income
    • Best Investment Options NRI
  • Credit Card
    • Best Credit Cards 2020-21
    • Best credit card for online shopping
    • Best Forex Card in India
    • Best Business Credit Cards
    • Credit Cards against Fixed Deposit
  • Insurance
    • Best Term Insurance Plans 2020
    • Best Health Insurance 2020
    • Best LIC Policy 2020
    • Best Car Insurance Companies
    • Best Mobile Insurance Companies
  • Downloads
Home
Personal Finance
Simple Expense Tracker using Google Docs

Simple Expense Tracker using Google Docs

Shitanshu Kapadia August 2, 2020

google docs

Tracking expense is essential need to control finance. Each of one use different mechanism to track spending’s, like excel sheet, smart phone apps or certain software on desktop, but bottom line is same to track where each penny / rupee is going.

I am herewith way to make simple expense tracker using google docs, this expense tracker will take details of your expense in simple form. It will allow you to track your expense not only that you can do analysis by using built in chart anytime. So let’s check out how you can make your own ‘Simple expense tracker” using google docs.

Expense Tracker using Google Docs:-

Do not miss below posts -
  • New PPF Rules – Premature Closure Relaxation
  • How to Check your Aadhaar Bank Account Linking Status?
  • How to safeguard Internet Banking?

Step 1:- Create a new Google docs – Form

Login to Google Docs using your google account once you are inside click on create “form” tab as shown below.

google form

Once you click this tab it will open a new window where you can create a form. We will use this form to enter spending details.

Step 2:- Create basic expense tracking form

We will now create a basic form with the following fields:

  1. How much?       – Money Spending
  2. Spends on:-  A description for the spending
  3. Category:- A      list of categories for spending

google spend tracker

The first step is to name the form. I have chosen “Spending Tracker”. You can give your own name. Next add three basic questions as shown above, the process is very simple, just try for yourself. Finally save expenditure tracking form.

Step 3:- Enter Expense in form

Once you are done, open the link which is marked by red box in above figure or Identified by “You can view the published form here”. Don’t forget to bookmark this link. This is the URL you will access whenever you want to enter new expense.

Form will look like:-

spending tracker

Just start adding your expense once you enter few expenses the spreadsheet will look like this:

spreadsheet

Google adds the time stamp for each expense made by you. So you don’t have to worry about entering expense date. You can use this tracker to track you spending. (provided you enter information as soon as possible)

Step 4:- Analysis of Expense

Google docs also give you facility to analyze your expense, just use built-in charts in Google docs to do some analysis of the expenses. I did a bar chart to show what is possible.

chart

So, what are you waiting for just click here to take a test drive for the expense tracker made using google docs.

Don’t forget to share this with your friends. Add your comments/ query I will be happy to answer it.

Subscribe to Blog

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Prev Article
Next Article
Tags:docs expense expense tracker expense tracker using google google google docs spending

About The Author

Shitanshu Kapadia

Hi, I am Shitanshu. By Profession I am Engineer and working in the IT field. I am crazy about Finance and like to research on financial matters. I have written 80+ article on this blog. If you like my efforts kindly subscribe to this blog and also let your friends know about this website by sharing.

One Response

  1. Jaydeep

    this is simple and effective way of tracking expenses

    April 24, 2017

Leave a Reply

Cancel reply

IIFL Demat Account

Search

Top Posts & Pages

  • Income Tax Calculator FY 2020-21 (AY 2021-22) – Excel Download
  • Rakesh Jhunjhunwala Portfolio Holdings - January 2021
  • How to check Property Records and Land Records online in India?
  • LIC Premium Paid Certificate Download For Income Tax Purpose - Online
  • 20 small manufacturing business ideas with low cost
  • 225 Small Business Ideas with Low Investment in 2021-22
  • Cash Deposit Machine Locator – How to find CDM Near You?
  • Top 60 Manufacturing Business Ideas
  • ASM List - What to do in ASM list Stocks?
  • Income Tax Calculator FY 2019-20 (AY 2020-21) - Excel Download

Subscribe to Blog via Email

Join 5,475 other subscribers

Follow MoneyExcel

Money Excel – Personal Finance Blog

Personal Finance Blog
Copyright © 2021 Money Excel - Personal Finance Blog
| About |Downloads | Contact Us | Sitemap | Disclaimer | Privacy Policy |