![]() ![]() Open your Google Drive App (Download it if you don’t already have it) The data will also transfer to the table and graph as well. Input the test data and the response will show up in your Google Sheet. To test - open the Expense Tracker form, click the 3 dots icon then Preview (Eye) icon in the top right corner. Select the Expense Tracker ONLY and select the 3 dots icon under the thumbnail and “Make a Copy” to your Google Drive - YOU DO NOT NEED TO DOWNLOAD OR ACCESS THE FORMīoth a copy of the Expense Tracker + Form will be added to your Drive and be automatically linked :) Open the link > Select your gmail account, It should open in your Google Drive App How to download the Expense Tracker on Android + Add to Homescreen Version 2.2 has a monthly AND weekly overview AND all the built in categories Version 2.1 has a monthly AND weekly overview with limited categories Version 2.0 has a monthly overview ONLY with limited categories ( Tutorial on how I built it) Great for freelancers and those with multiple streams of income Has 2 forms, one for Expenses and one for Income Version 1.1 has a monthly AND weekly overviewĮxpense + Income Tracker Version 2.0 (Watch the Tiktok Video) Simpler version, with only one form for expenses and income Set your budget, and if you go over your month will go redĬalculates your gross savings based on your monthly income and expensesĮxpense Tracker Version 1.0 (Watch the Tiktok Video) Simple expense form that can be installed on your phone’s homescreen for easy access and input Track your expenses with customisable rainbow categories My Expense Tracker Youtube tutorials have totalled over 100k views. It has over 3 million views and the feedback has been immensely positive. I designed it for myself originally, and in 2020 made a video about it… which went viral. It uses Google Sheets combined with Google Forms, and is an accessible and readable tracker that anyone can use. So, there are always going to be 8 different sections in the data input sheet.The Expense Tracker is easiest way to keep track of your spending - simple, customisable, no app required. ![]() ![]() You can put 8 different categories in the dashboard. Basically, in this sheet, you will enter all your expenses under each category you determined in the dashboard section. The second part of the weekly budget Excel template is the data input sheet. ![]() On the pie chart, you will choose the expense category and the distribution will change accordingly. Here, the Actual Expenses chart will show you the expenses on the week you selected from the aforementioned dropdown menu. Moreover, there are two charts in the dashboard: Actual Expenses and Category specific Pie chart. Then, after you input your expenses each week, the weekly budget template will automatically calculate how much money you could save each week.Īlso, you can select the week, which the dashboard displays, from the dropdown menu on top of the Select Week table.Ībove, you can also see that the weekly budget template dynamically presented the summary of your total income, total expenses, and savings. In this dashboard, you will determine your general expense categories and your income sources. DashboardĪt first, you will come across the Dashboard sheet. Someka personal weekly budget template consists of two pages. Let’s explain what is waiting for you in our income and expense planner. Then, check out our Weekly Budget Template in Excel! It is a great tool if you are looking for a simple money manager but don’t want to install another app or program on your computer. But finding a good method for a personal weekly budget is difficult. Creating a weekly budget is a critical habit for anyone who wants to be resourceful and succeed in personal financial management. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |