Skip to content

5000+ Great Articles

Best Articles & Essays: Interesting Articles to Read Online

  • How to go Back to the old YouTube Layout (2017) How-To
  • Change View Source Code Editor in IE 8 thru 11

    Have you ever viewed the source code of a web page in Internet Explorer? Every web page you view on the Internet is really just code written in diff

  • How to Download Reddit Videos on iPhone How-To
  • Automatically Transcribe YouTube Video/Audio with Google Docs How-To
  • What Do I Need to Create a Windows Service? Windows 10
  • How To Import Your Contacts To Gmail Cool Websites
  • Windows 10 Pro vs Home: What’s the Difference? Windows 10
  • How to Use Your Phone as a Drawing Pad for PC How-To

How To Use Google Forms As An Expense Tracker

Posted on October 7, 2020 By blog_786 No Comments on How To Use Google Forms As An Expense Tracker

An expense counter is vital if you’re budgeting or need to know where your money is going. Google Forms is a free form builder that’s great for tracking expenses.

Google Forms is highly customizable, so while it can also be used as a survey, RSVP tool, contact form, product registration sheet, or any other Q / A form, you can turn it into your own expense counter by selecting expense related questions

How To Use Google Forms As An Expense Tracker

The Google Forms expense counter can track whatever you want in relation to a transaction, and since it works great from your phone, it will always be with you wherever you go.

You can stop saving receipts or try to decrypt a credit card charge; just open the expense tracker right after you spend your money to write down all the important details and send them to a spreadsheet that you can review later.

Tip: Check out our list of the best budgeting and expense tracking apps for other ways to track expenses. They are not as easy to customize as Google Forms, but they have their advantages.

Select what you want to track

The idea behind the expense counter is to keep track of what you are spending your money on, so there are a few basic details to include in your form. But depending on what you want to track, you may need additional fields on the form.

– /

Here are some examples of what you can track:

  • Price: How much is this transaction worth?
  • Shop: Where do you spend your money?
  • Description: What are you spending your money on?
  • Category: What type of purchase is this (entertainment, food, bill, etc.)?
  • Payment method used: How do you pay for it (which card / bank / application)?
  • Who led the cost: if multiple people use the form
  • Notes: Any additional notes you need to make?

When deciding what to include in your Google Forms expense counter, remember that you want the margins to be as wide as possible so that they can be applied to whatever you buy. You don’t necessarily need a field that asks what food you buy, for example, unless it’s a food expense counter; you can also use it to record rental payments and phone bills.

In this note, you can make any of the fields on your expense tracking form required or optional. So, if you need a really specific field for something, just make it optional so you don’t have to use it for every transaction.

Create a Google Forms expense tracker

This is a sample expense counter, so yours should by no means look exactly like this one. We use general questions with even broader answers to show how it works. You will find that editing a form is extremely easy, so you shouldn’t have any problems customizing it for yourself.

  • Open Google Forms
  • Select Blank to start. a new shape.
  • Rename the form to something recognizable.
  • Select the first field and change it to Short Answer.

  • Name this price, make sure the Is number is displayed, and then check the Must button.

How To Use Google Forms As An Expense Tracker

  • Use the plus sign in the menu on the right to add a new question, but this time select Multiple Choice.
  • Name this one Store, then fill in the options with the regular stores you shop at. Others are added by default, so if you end up making a purchase from another store, you can enter it there.

How To Use Google Forms As An Expense Tracker

  • Keep filling out the form by asking various questions that you want to ask yourself every time you buy something. Use the suggestions above, such as a payment method and a descriptive question, to provide as much detail as possible. This will come in handy later when we interpret all the results from the form.
  • Use the preview button (eye icon) at the top of Google Forms to get the URL of your form. You can share it with anyone you want to use the form with, or send it to yourself so it’s easily accessible from your phone.

How To Use Google Forms As An Expense Tracker

This is not necessary, but your form can also include images, headers, and a unique color scheme. A colorful form can make spending tracking fun, if possible! The paint icon at the top of the page is where you go to make these changes.

Account Setup

Each record from your form is collected into a nicely formatted spreadsheet in Google Sheets. Select ANSWERS at the top of the form, and then click the spreadsheet icon to rename it (if desired).

How To Use Google Forms As An Expense Tracker

After the spreadsheet opens, create a new tab at the bottom and name it something like “Calculations”.

How To Use Google Forms As An Expense Tracker

From there, you can do everything that Google Sheets supports: add up all your expenses over a period of time, create graphs to visually understand your expenses, see who is spending the most money, determine which stores are costing you the most, and more.

Using these types of formulas in Google Sheets is beyond the scope of this article, but let’s look at something very basic, like adding up all of the expenses for each person, so we can really see who spends the most. You can always change the formula to calculate how much you spend at each store.

The easiest way to add up all expenses, regardless of the person who made the transaction, is to run an amount formula, for example:

= sum (‘Form Responses 1’! B: B)

How To Use Google Forms As An Expense Tracker

This calculation works for our example because the price column from the form responses is in column B.

Here’s a Google Sheets formula that shows a much more detailed look at how much each person is spending:

= sumif (‘Form Responses 1’! G: G, ”Jeff”, ’Form Responses 1’! B: B)

How To Use Google Forms As An Expense Tracker

It works like this: enter sumif and then select the column containing the names (G in our example). The next part identifies the name Jeff. Finally, select a heading for the prices column so that when another column matches the name we chose, only those prices are added.

Check out the list of Google Sheets features to learn about other ways to interpret data from your form. Another way to see your expenses is with a chart or graph; Google has a guide on this.

–

Share this:

  • Twitter
  • Facebook
Office Tips

Post navigation

Previous Post: What Is Windows PE & How To Make a PE Rescue Disk
Next Post: Fix Background Intelligent Transfer Service Will Not Start Error

Related Posts

  • How To Embed a YouTube Video In Microsoft PowerPoint Office Tips
  • Center Your Worksheet Data in Excel for Printing Office Tips
  • What Is Microsoft 365? Office Tips
  • How To Update an Old Word Document to Latest Word Format Office Tips
  • When to Use Index-Match Instead of VLOOKUP in Excel Office Tips
  • How to Recover Deleted Emails in Office 365 Office Tips

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Archives

  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • November 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • March 2021
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • December 2019
  • July 2019
  • May 2019
  • April 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018

Categories

  • AI Tools & Guides
  • Amazon Web Services
  • Apple Watch
  • Computer Tips
  • Cool Websites
  • Featured Posts
  • Free Software Downloads
  • Gadgets
  • Gaming
  • General Software
  • Google Software/Tips
  • Hardware
  • Help Desk
  • How-To
  • iOS
  • iPad
  • iPhone
  • islamic Books
  • Linux
  • Linux Tips
  • Mac OS X
  • macOS
  • MS Office Tips
  • Networking
  • Office Tips
  • OS X
  • Product Reviews
  • Reviews
  • Safari
  • Smart Home
  • Smartphones
  • Software Reviews
  • technology
  • text
  • Tools Review
  • Troubleshooting
  • Tutorials
  • Uncategorized
  • Urdu Books PDF
  • Web Site Tips
  • Windows
  • Windows 10
  • Windows 7
  • Windows XP Tips
  • Wordpress
  • What Is “Other” Storage on Android And How to Clean It Up ?
  • 7 Legal Websites to Get Free Music Downloads
  • Six Copyscape Alternatives That you can use
  • How to Make Phone Calls Without Revealing Your True identity
  • 50 Useful Websites on the Internet You Didn’t Know Existed
DMCA.com Protection Status

Recent Posts

  • A Simple Trick to Get 50% Discount on Audible for Three Months
  • 6 Best PayPal Alternatives (2017)
  • How to Fix the the “Invalid SIM Card” Error on Android
  • What Is “Other” Storage on Android And How to Clean It Up ?
  • 8 Best Free and Paid Cloud Storage (2017)

Recent Comments

  1. Automatically Transcribe YouTube Video/Audio with Google Docs on 5 Best Team Management Apps (For Small and Large Teams)
  2. 6 Things You Need Know About Email Encryption on Delete All Emails from Gmail With Once Click
  3. Looking For YouTube Alternative? Try These 7 Video Sharing Sites on Ten Best YouTube Video Editing Software 2023
  4. 8 (+1 New) Ways to Post on Instagram From Computer on How I Solved My Bluestacks Graphic Card Error (2 Ways)
  5. Find out what WordPress Theme and Plugin a Website is Using on How to Install a Theme on WordPress
  • Change Default Web Browser in Windows 8

    Windows 8 now has two ways to log into your computer: through a Microsoft account, which syncs your settings and apps across your Windows 8 PC, and

  • Essential Software and Features for a New Windows 10 PC

    While Apple and Android vie to become the undisputed leader in the smartphone and tablet world, Microsoft continues to focus on one of its flagship

  • How To Turn An Old Laptop Into a Chromebook How-To
  • How to View Android Notification History and Logs How-To
  • Unknown Accessory Detected Near You on iPhone Hardware
  • What Is Roblox Premium and Is It Worth It? Software Reviews
  • How to Fix Apple Music Keeps Crashing on iPhone? iPhone
  • Sum a Table Column in Word Office Tips

Copyright © 2023 How To Blog.

Powered by PressBook News WordPress theme

Go to mobile version