Open the link - It should open in your Google Drive App How to download the Expense Tracker on iOS + Add to Homescreen Select 3 dots in the top right corner again and select ‘Add to Home Screen’. Select 3 dots in top right corner and select 'Preview’ - it will open a new tab with the form where you can input data It will be the ‘editable version’ where you can’t input data. Open your Expense Tracker Form in your browser. 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. And you can compare your expenses with your income in this worksheet also, so you will see the profile of your household financial situation monthly.The Expense Tracker is easiest way to keep track of your spending - simple, customisable, no app required. The third worksheet is the monthly expenses worksheet that will summarize all your expenses monthly. ![]() I provide also a credit card box that will help you summarize your credit card usage within a month. This is useful if you want to compare your income to your total expenses. Even though I put the title "expenses" in the expenses column, you can put your income and select the appropriate category to record your income. Just type your expenses row by row and let the excel formula do the rest of tracking process. You can customize again while you recording your expenses and find there is no suitable category for that expenses.Īfter customizing the category worksheet, you can start tracking your daily expenses in the daily income and expenses worksheet. You don't have to create all the categories in the beginning, since probably you can't remember all. You can simplify the written category if you fill those categories are too detail, or you can customize based on your criteria. Define your group category first, followed by subcategory and category. You can start to customize your spreadsheet by going to category worksheet and define your categories. It consist of three worksheets, category worksheet, daily income and expenses worksheet and monthly expenses worksheet. This is basically just a strip version of my household budget spreadsheet where it is only can be used to track and record your expenses without budget consideration.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |