![Deborah Ho](/img/default-banner.jpg)
- 12
- 623 801
Deborah Ho
Australia
Registrace 6. 01. 2014
How to Download the Expense Tracker - 2024 UPDATED VERSION | Debbbag
Hello!
This is an updated tutorial for downloading my Expense Tracker into your own drive.
Unfortunately, Google has changed their sharing capabilities so the forms easily don't copy over like they used to (unless you have edit access to the entire folder, which I'm unable to provide publicly). I cannot give edit access to anyone because it means anyone can delete, and change the files -- and when I have in the past, people have removed files :(
Good news is, once you have the forms in your own drive, the duplication is super easy! Which I show in Part 2.
Timestamps
0:00 Part 1: Downlading Expense Tracker from me :)
12:47 Part 2: Duplicating Expense Tracker from your own Drive
Download the Original Expense Tracker: deborahho.com/productivity/expense-tracker
Buy me a Kofi: ko-fi.com/debbbag
Website: deborahho.com/
This is an updated tutorial for downloading my Expense Tracker into your own drive.
Unfortunately, Google has changed their sharing capabilities so the forms easily don't copy over like they used to (unless you have edit access to the entire folder, which I'm unable to provide publicly). I cannot give edit access to anyone because it means anyone can delete, and change the files -- and when I have in the past, people have removed files :(
Good news is, once you have the forms in your own drive, the duplication is super easy! Which I show in Part 2.
Timestamps
0:00 Part 1: Downlading Expense Tracker from me :)
12:47 Part 2: Duplicating Expense Tracker from your own Drive
Download the Original Expense Tracker: deborahho.com/productivity/expense-tracker
Buy me a Kofi: ko-fi.com/debbbag
Website: deborahho.com/
zhlédnutí: 2 982
Video
How to add a Weekly Overview to your Expense Tracker | Debbbag
zhlédnutí 12KPřed 3 lety
Today I'm going to teach you how to add a weekly overview your tracker so you can see how much you're spending a week! Shoutout to Asif who kindly shared the Weekly formula with me in the comments of my other video! ^_^ I just discovered that angled brackets aren't allowed in this description box so please check the pinned comment for the copy-and-paste formulas T_T Download the tracker here (W...
How to Solve Data Transfer Issues in your Expense Tracker | Debbbag
zhlédnutí 6KPřed 3 lety
In this tutorial I'll help you troubleshoot any data transfer issues you have in your Expense Tracker! Timestamps: 00:38 Typos in your category name 01:30 Writing SUMIF instead of SUMIF 02:17 Date is wrong or reversed 03:46 Year is wrong 04:41 Sheet name is wrong in formula 05:38 Data is being taken out from the wrong column Download the Original Expense Tracker: deborahho.com/productivity/expe...
How to Solve Permission Issues with your Expense Tracker | Debbbag
zhlédnutí 3,2KPřed 3 lety
If you're having issues accessing or copying my Expense Tracker and needing to ask for permission... I'll show you how to bypass all of that so you can get started on tracking your expenses asap! Download the tracker here: www.deborahho.com/productivity/expense-tracker Download/Installation Tutorials: Download on Desktop: czcams.com/video/clheeJtG4nc/video.html Download on iOS: czcams.com/video...
How to add Recurring Payments to Your Expense Tracker | Debbbag
zhlédnutí 13KPřed 3 lety
This tutorial is going to teach you how to add recurring payments to your Expense Tracker! Download the Original Expense Tracker: deborahho.com/productivity/expense-tracker How to build your Expense Tracker from scratch: czcams.com/video/yd-YMYdj6EI/video.html Customisation Tutorial (Includes Conditional Formatting): czcams.com/video/IS8y1oPUojM/video.html Watch my original Tiktok - where it al...
Updating your Expense Tracker for the New Year | Debbbag
zhlédnutí 17KPřed 3 lety
This tutorial is going to teach you how to update your Expense Tracker for the new year! Super simple and there's a few ways to do it. Pick the one that suits your lifestyle :) Timestamps: 00:32 How to change the year 02:11 Intro to different yearly versions 02:22 Version 1: New Tracker Form ( Template) 05:51 Version 2: Same Tracker Form, New Dashboard 08:29 Version 3: Using the Same Tracker, b...
Converting your Expense Tracker to Euros (€) | Debbbag
zhlédnutí 4,9KPřed 3 lety
How to convert your Expense Tracker to Euros :) Customisation Tutorial: czcams.com/video/IS8y1oPUojM/video.html Download the Original Expense Tracker: deborahho.com/productivity/expense-tracker Watch my original Tiktok - where it all started: www.tiktok.com/@debbbag/video/6864133021088451846 Buy me a Kofi: ko-fi.com/debbbag Website: deborahho.com/ Tiktok: tiktok.com/@debbbag Instagram: instagra...
How to build your Expense Tracker from scratch! | Debbbag
zhlédnutí 351KPřed 3 lety
Today I'm going to teach you how to build this Expense Income Tracker from scratch. It will show you the principles and formulas - so you can make the perfect tracker to suit your lifestyle :) Timestamps: 0:39 Create a form for your expenses 3:48 Create a form for your income 6:17 Adding sample data: expenses income 8:15 Change your title, country timezone 8:58 Building your main dashboard 14:0...
How to Customise your Expense Tracker | Debbbag
zhlédnutí 71KPřed 3 lety
Walking you through all the ways to customise your expense tracker so it's perfect for your lifestyle and needs :) 00:24 1. Change category name 02:43 2. Change category colour 04:22 3. Add category 08:22 4a. Adding income to the expense tracker form (How it works in the new template) 10:16 4b. Adding income to the expense tracker form (How to update your expense tracker to include income) 12:5...
Expense Tracker - Download on iOS + Add to Homescreen | Debbbag
zhlédnutí 31KPřed 3 lety
This is how you download the Expense Tracker on iOS! Fixing the permissions bug Set this video at 1.5x speed because I'm talking very slowly haha. 0:00 How to download Expense Tracker on your iOS device 1:03 Fixing the permissions bug 3:11 Adding the form to your homescreen Download the Expense Tracker here: deborahho.com/productivity/expense-tracker Buy me a Kofi: ko-fi.com/debbbag Website: de...
Expense Tracker - Download on Android + Add to Homescreen | Debbbag
zhlédnutí 19KPřed 3 lety
This is how you download the Expense Tracker on Android! Add to Homescreen 0:00 How to download Expense Tracker on your android 2:11 Why your data isn't getting transferred over Download the Expense Tracker here: deborahho.com/productivity/expense-tracker Buy me a Kofi: ko-fi.com/debbbag Website: deborahho.com/ Tiktok: tiktok.com/@debbbag Instagram: debbbag Twitter: de...
Expense Tracker - Desktop Download Tutorial + Fixing data errors | Debbbag
zhlédnutí 94KPřed 3 lety
This is how you download the Expense Tracker on desktop! Why data isn't being collected 0:00 How to download Expense Tracker on your desktop 3:52 Why your data isn't getting transferred over Download the Expense Tracker here: deborahho.com/productivity/expense-tracker Buy me a Kofi: ko-fi.com/debbbag Website: deborahho.com/ Tiktok: tiktok.com/@debbbag Instagram: debbbag Twitter: t...
hey how do i get to tracking my savings like how do i input another category seperatly where i track what my savings are
THANK YOU SO MUCH! I have been stressing about how to log my income/expenses properly for YEARS. You are such a godsend!!!!!!
Hello! I am new to tracking my expenses and I already made a mistake with my sheet lol. My monthly and weekly overview and income dashboard doesn't seem to link with my income and expense form. How do you fix this? Thank you!
Hi Deb, just found your great looking expense tracker. This tut on how to dowload and set it up keeps freezing at 2:09 minutes in. I've tried rebooting, opening it from other links but its doing the same thing. Any suggestions as I'd love to use this. Thanks, Jess
✨Thank you for sharing! How do you create the numerical condition for the 'Amount' question in the form? Shown in 1:31
I have an issue is whenever i add an expense through the form it gets added to the monthly expenses sheet but i cant find the row in the expenses spreadsheet itself, its like it gets added directly without being an entry in the spreadsheet 😭
Could you add a Credit card/personal loan and car note section?
Thank you much for this! How do I delete the test info and example info on the sheet so I have a clean slate to get started?
For some reason I can not download first 2 files. My browser says I need permission. Anyway, thanks for this super useful tracker.
Make sure you're signed in to Google.
This is amazing! Thank you so much. <3
Thank you so much for sharing :)
Im so thankful that you share the tracker with us. I've been using it for 3 years now ❤
Hey just found the video and trying to set it up to use it for work thanks a lot keep up the good work
This is great, thanks Deborah! Quick question though, how to rename the income sources Workplace 1.2.3, and change to the actual name of the company? Appreciate your response.
Hi. Great Tutorial & Awesome work. Thumbs Up! Quick question: Can I bring the form onto my iPhone Home Screen? If yes, can you show us how?
Started using your tracker last year, amazing thank you!
Hi!! Awesome tutorial! Could you please let me know how to change the names of the categories? So it can say "Ordinary Salary" instead of workplace 1
I have a tutorial :) czcams.com/video/IS8y1oPUojM/video.html
Man, I just found your tracker yesterday and you created this video yesterday. I was getting so frustrated with trying to get it to work, but happy now that it all works. What divine timing haha! Thank you for your generosity for creating such an amazing system that works like magic. You're single handedly making a huge difference in thousands of peoples lives with their finances with your gifts and talents!
Thank you so much
You are amazing! I love your expense tracker, I've been using it since 2021 🤗 Thank you so much!!! 🙌🏼🙌🏼
I've been using your tracker since 2021 and love it. It helped me buy my first home a couple years ago. Thank you so much.
Wow so glad to hear that !! 😍
thank you for this very thorough tutorial!! 🫶
Is there a way to add 2 income tabs? I am trying to keep my wages vs my tips separate. I am finding when I try to add the second it’s deducting as if it’s an expense rather than adding as if it’s income. Thanks!! 😊
mandou muito!!
This is amazing! Thank you so so much!
Make in inr (india)
The form wont download with the sheet. I did everything exactly like in the video
niice
When I make a copy of your expense tracker it doesn't populate a form in MyDrive. Any advice?
This is amazing! Thank you. When I copied the sheet, the form did not copy over. Any idea why?
same issue
Hi! It's been several years now and I just downloaded the 2.0 template, but I feel like google may have done some updates because when I copy (as shown) it only copies the spreadsheet not any of the forms. Did it several times, ensuring that I was logged in, and even did it several times on my laptop and then iphone as well. Any ideas?
this no longer works
Thank you!
@DeborahHo Form not copying over to my drive after copying excel sheet.
If you are having issues copying and setting it up the Download Free Expense + Income Tracker 2.2 I posted a video tutorial on my channel on how to do it
I'm having an issue when copying over the tracker, I know you're only supposed to copy the tracker sheet and the forms will automatically copy, but every single time I try to copy it over (the 2.2 version), only either the expense form will copy or the income form will copy ): idk what the problem is
Thanks for this amazing dashboard! I have a problem, everytime when i put in the range, it doesnt include the first and last value of the range?? idk what is wrong with it
When I do this my setup starts off with like $20000 for each category. could you shed some insight on what i may have entered incorrectly to give me amounts that are larger than what i have as my starting amounts in my form?
This is really amazing! I have followed your tutorial and setup exactly like this. Thank you soo much! Now I hope I stick to actually tracking my expenses using this hahaha
Thank you Deborah, its 2024 and I just created this sheet. For anyone that is getting the following "Error Message ("Argument Must be a range",) Make sure that the name of the your Expenses form, the name on the sheet is Expenses..as that is that she uses in the formula.. I had changed mine and was getting the error message as form name didnt match the name in the forumla! Hope this helps someone...
I have a problem with the data's though, I have 9 categories and on my 9th category is "Others" but it doesn't read the data from the Expense Data Sheet and I have to manually input it so that it will add to my data. I have re watched the video many times and I tried to make the excel a couple times starting from scratch but it doesn't seem to work. Is there something I can do to fix this?
My expense tracker form is not automatically downloading with the download of the Expense Tracker. This is the income and expense tracker 2.2 - the most recent version on your website. Has anyone else had this problem?
Read comment by @zelbiee3678, it worked for me :)
I get paid on the 28th of each month. How could I change the formula to suit that?
Can you create a video on how to make with INCOME, EXPENSE, and TRANSFER from Wallet to wallet?
thank you so much for this video.
It’s not showing up on the charts
If I copy the sheet, it either copies the income form or the expense form. Both of them dont happen at the same time so I have to keep deleting the forms and sheet. Is there any work around?
I copied the 2.2 income tracker. Income form is not working, I followed your instructions if this did not work I had to create a new form and it still does not show up on income spreadsheet. Can you help me?
when I try to access the form via safari it says missing file upload folders. is there a fix?
Hello, after making a copy of any tracker, no form will generate.
So I think I figured it out: You need to make a copy of the forms you don't have & open them in your drive. There will be a pop up saying that files need to be restored, hit "Restore." Then go to the "responses" tab in the form, and on the right hand side there should be the google sheets logo next to a hyperlink that says something like "no sheets linked." click that & hit "link sheet" & select your copy of the spreadsheet. it will make a new sheet with the purple forms logo at the bottom of the page in your spreadsheet, and you'll need to find the "expenses" or "income" sheet (whichever form you're trying to link) and delete it & rename your new sheet the same name. On the overview & income dashboard tabs there are errors now. to get around this, on the Monthly Overview select the first cell with data (B2), and copy the formula from the formula (fx) bar at the top. then delete the formula, and paste it back in. It should now show "$ -" in the cell. To apply to the rest of the cells hover over the bottom left corner of cell B2 until the cursor turns into a cross & click + drag to cell M2. while those cells are highlighted repeat the click+drag to row 13. Repeat for the weekly overview page for example: the expenses form did not link to the spreadsheet. I delete the existing expenses tab & link the copied expenses form to my copy of the spreadsheet. I rename the new tab that's appeared at the bottom of my spreadsheet "Expenses". To fix the errors that are on my weekly and monthly expenses now, I copy the formula from cell B2 then delete the formula, then I paste the formula back. Click+drag from B2 to the rest of the categories to apply the formula to the top row, then click+drag to apply to the rest of the table. I do the same to cell C2 on the weekly overview.
this worked like a charm. thank you so much@@zelbiee3678
@@zelbiee3678 thank you so much for this, I was getting so upset that I couldn't get it to work!