Thank you so much for giving us access to this user-friendly expense tracker. My question is if I want to add another expense e.g. school expenses how would I change the formulas to accommodate this and the chart. Thank you again
Thank you for making this! I thought I'd create on myself, but found this to be exactly what I need. I just changed the categories to "Schedule C" terms, added a few, easily updated your formulas, and it's perfect so far. A big improvement to the sheets (without a form) I've been using. Liked. Commented. Subscribed. Thanks again.
This is great, thank you for sharing! I couldn't, however, get the Form to copy. I copied the Excel spreadsheet, and the Income Tracker Form came across automatically, but the Expense Form didn't :( Any suggestions anyone?
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.
Thank you Deborah for giving the public access to this fantastic and user-friendly expense tracker. I stumbled upon this on Pinterest and tracked you down on CZcams. It has helped me manage my expenses for the first time since I started earning. Thank you. :)
Thank you so much for this! Just a question, when I made a copy of the expense tracker, the form was not found alongside the copy of the expense tracker on my drive. Is there any way I can have the supposed 'automatic' form to be with, with my expense tracker copy? Thank you!
Před 5 měsíci
Same here! In this case, should we copy the form too?
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.
@@zelbiee Hello thanks for the advice!!! I see the errors now but when i copy delete and repaste, I still get the error. Anything I could do to override this?
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.
Thank you so much for doing this and sharing this! This is much appreciated. For anyone not getting the preview option (as I have) change to list view for your G drive documents and the preview option appears.
So, how does this adjust for different years? Do i need to delete everything and redo it? I tried adding an expense for 2021, but nothing is showing up for it.
Hi Deborah! Thanks so much for your tutorial! I have a doubt: if I want to change the category's names should I do it in the form or in the sheet? Thanks!
not the OP, but there's an option when you're inputting the general spending options to instead input income. It's one of the categories alongside food, bills, etc.
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.
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?
Okay actually i just figured it out. Change the name on your form, on your monthly expenses and on your graph. Now, when you go to the expenses tab with the list of your stuff, right click the box with the category you want to change. At the bottom click conditional formatting, and then on the right change the word you want to colorize
Hi Deb. I am attempting to do a reconciliation of an account over 2 years. When I enter the data into the sheet back for 2021, it doesn't seem to be populating the tracker, rather it is showing dates from January through to December 2023 2022? Am I supposed to delete these dates or is there another way to have these pre loaded dates removed before I start?
Hi! I recently got your newer version of this the 2.2 and I notice that the weekly overview not log the info you put in if its the present date. Like trying to log something on today's date during today it doesn't show up. Is it meant to do that? Is anyone else having this problem?
thanks so much for this again! just a quick question, how would you extend the tracker for the new year? would you just use a new template or make new tabs or extend it on the sheet itself?
I'm having issues im new to this excel I love it already but I'm having issues changing the categories to what I save them as how can I go about doing that and have it work
Hi, the income isnt working for me, whenever it generates theres an error Missing File Upload folders The folder containing responses to File Upload questions can't be found. This form won't resume collecting responses until the folder is restored.
hi deb! i downloaded both forms and send my responses to the tracker and even though i hit preview and send, the information is not showing up in the main form
Hi Deborah!!! THAAAAANK YOU!!! This is amazing, I was just wondering, can I do this from a budget standpoint? For example, I put in my budget on the sheet beforehand, and then same as the form, I enter what was bought and it deducts from my budgeted amount and lets me know what is left?
This is amazing. Thank you so much. I'm having trouble with the expense and income tracker. When I erased the rows in the income tracker, it did not sync with the income dashboard. Is there something I should do?
Thx for the content Deborah! Super nice! Question: How would we go about importing expenses for a specific month without having to capture them 1 by 1 please? Cheers!
What a great file! Thank you. Question: When I add a a new category and change it in the graphs below it won't have the same colour as above. Any idea what I am doing wrong?
Thank you so much!!! One question though, is there a way to change the currency? I see that I can change it manually in the graphs but not sure where I can change it in the expense chart
Ok awesome Ideas and awesome Expense Tracker.... but is there a way to depreciate one big payment to 12 months? I mean I could break down the payment and add it manually to the list but can I update the form and end up in a depreciation?
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.
I'm not exaggerating when I say I'm about to unalive myself. I followed the instructions and it worked perfectly, until I decided to customize the categories and it stopped logging in the information I uploaded on the forms. so I decided to delete everything and start over, but now when I make a copy of the expense tracker the google form doesn't copy itself automatically and I don't know what to do and if you could save my life I would totally appreciate it
okay soooo somehow in the span of five minutes it worked again but still is there a way I can edit the name and amount of categories and that the information I log in uploads to the sheet
Hi Deb, Thank you for creating this. I have a quick question, would you put an emergency fund in the expense form? I want to keep track of my emergency fund in here as well and I would love your advice. i believe that is what I'll do. Any thoughts you have would be great.
Add an emergency fund as a category :) that way you can input any time you add savings to it, and it will subtract from your income (you are putting it aside) 😀
What do I do if the tracker form says this: "Missing File Upload folders The folder containing responses to File Upload questions can't be found. This form won't resume collecting responses until the folder is restored."
hi deborah i recently downloaded your tracker 2.0 but every time i open the income and expense i get a error message saying "missing file upload folder"
Thank you so much for giving us access to this user-friendly expense tracker. My question is if I want to add another expense e.g. school expenses how would I change the formulas to accommodate this and the chart. Thank you again
Thank you for making this! I thought I'd create on myself, but found this to be exactly what I need. I just changed the categories to "Schedule C" terms, added a few, easily updated your formulas, and it's perfect so far. A big improvement to the sheets (without a form) I've been using. Liked. Commented. Subscribed. Thanks again.
This is great, thank you for sharing! I couldn't, however, get the Form to copy. I copied the Excel spreadsheet, and the Income Tracker Form came across automatically, but the Expense Form didn't :( Any suggestions anyone?
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.
@@zelbiee What would one need to do if the error is not going away with the copy paste method? Thank youu
Thank you Deborah for giving the public access to this fantastic and user-friendly expense tracker. I stumbled upon this on Pinterest and tracked you down on CZcams. It has helped me manage my expenses for the first time since I started earning. Thank you. :)
Thank you so much for giving us access to this for free!! It has helped me a lot to administrate my expenses :)
thank you so much for getting my life together!!!
Thank you so much for this!
Just a question, when I made a copy of the expense tracker, the form was not found alongside the copy of the expense tracker on my drive. Is there any way I can have the supposed 'automatic' form to be with, with my expense tracker copy? Thank you!
Same here! In this case, should we copy the form too?
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.
@@zelbiee Hello thanks for the advice!!! I see the errors now but when i copy delete and repaste, I still get the error. Anything I could do to override this?
When I make a copy of your expense tracker it doesn't populate a form in MyDrive. Any advice?
the forms are not copying for me. idk what to do
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.
Thank you so much for doing this and sharing this! This is much appreciated. For anyone not getting the preview option (as I have) change to list view for your G drive documents and the preview option appears.
Best expense tracker I found so far. Thanks for sharing everything and free.
The form wont download with the sheet. I did everything exactly like in the video
I cannot thank you enough for this!! Honestly is lifechanging
Thank you , I’m going to uni next year and this will help me a lot
I found you on Pinterest your amazing I cant wait to start using this in daily life
Hi! How can I change the valuta from $ to €? Thank you in advance!
yessss dying to do it - i Tried the replace functionality but doesn't work because dollar sign is inserted in the formulas
thank you for actually providing the template and also in so many different languages!!!!!!
The people who have reached out to send me the translated versions are the best!!!
I try to download the expenses tracker but the Google form doesn't show up am I doing something wrong
So, how does this adjust for different years? Do i need to delete everything and redo it? I tried adding an expense for 2021, but nothing is showing up for it.
Keep the fresh template at hand and just change the year
Thank you sooo much for sharing this template. It was just what i need it. Thanks also for the tutorials on how to use it. You are a life saver.
Thank you for sharing those documents and the great tutorials! Super generous of you. All the best!
I have followed the steps but the tracker does not download as well. Has this happened for anyone else?
Thank you! You've changed my spreadsheet-loving life. Love your website, too!
This is amazing! Thank you. When I copied the sheet, the form did not copy over. Any idea why?
same issue
Thanks again for 2023!
This such an incredible help I hope this video blows up!!!! thank you so much
Thank you for that! Hope I'll come back in one year with the best results
@DeborahHo Form not copying over to my drive after copying excel sheet.
Hi Deborah! Thanks so much for your tutorial! I have a doubt: if I want to change the category's names should I do it in the form or in the sheet? Thanks!
This is helpful, thank you for sharing your creation.
that's amazing thank you ! but how can i change the dollar to other coin?
Hello! Thank you for this!! I had a question about how to submit income into the form and the sheet? :)
not the OP, but there's an option when you're inputting the general spending options to instead input income. It's one of the categories alongside food, bills, etc.
Trying to download the "version 2.2" but it does not seem to download the form and other folders.
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.
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 love you. thanks for changing my life.
Yo thank you for creating this - this is awesome
Thanks, I'll be using this from now on!!
thank you so much! you're so generous!
This is a dream come true!! Thank you!!
thank you so much for giving us access to this :)
why does "Clear cache & cookies" come up every time i try to click on the copy? ive done it and it still wont work
My info isn't transferring from forms to the sheets
go to forms, responses and click on the green square and check if they are connected. if they are, check if the categories have the same names in both
I am having the same issue, although I have the exact same categories in both. Any idea what the problem could be?
Thank you thank you so much! You've helped me so much
Thank you!
this is very helpful thank you so much
When I change the a category name through the google docs how do I keep the colour of it on the expenses sheet of the google sheet document?
Same question ^ !
Okay actually i just figured it out. Change the name on your form, on your monthly expenses and on your graph. Now, when you go to the expenses tab with the list of your stuff, right click the box with the category you want to change. At the bottom click conditional formatting, and then on the right change the word you want to colorize
I absolutely loved it! Thanks :)
Hi! After making a copy the expense tracker form still says I need permission. Can anyone help me with this? Thanks.
I got it! Had to redownload the file from original link. I just copied that individual sheet from the folder and voila.
This is perfect! Thank you soo much!!
Thank you so much for your help!
Hi Deb. I am attempting to do a reconciliation of an account over 2 years. When I enter the data into the sheet back for 2021, it doesn't seem to be populating the tracker, rather it is showing dates from January through to December 2023 2022? Am I supposed to delete these dates or is there another way to have these pre loaded dates removed before I start?
Hi! I recently got your newer version of this the 2.2 and I notice that the weekly overview not log the info you put in if its the present date. Like trying to log something on today's date during today it doesn't show up. Is it meant to do that? Is anyone else having this problem?
Thank you. Very helpful!
is there any way to change the date format to dd/mm/yyyy
help a fellow aussie out!
File> Spreadsheet Settings and there should be a location and time setting.
@@sparkleinkcat thank you! that worked. im good with excel. i just don't use google sheets as much.
@@alihsaleem yeah i'm more of an excel user so i went in trying to fix the formula and realised there was none so that failed. but now it's fixed.
@@sparkleinkcat you just saved my life with this answer😍
How do I add a category to the sheet? It won't register on the charts.
Thank you for sharing ❤
thanks so much for this again! just a quick question, how would you extend the tracker for the new year? would you just use a new template or make new tabs or extend it on the sheet itself?
Thank you. Thank you. Thank you!
I'm having issues im new to this excel I love it already but I'm having issues changing the categories to what I save them as how can I go about doing that and have it work
Hello! Do you think this would work in Excel? I am just unsure how I could add an expense from my phone for an EXcel version!
Thankyou for your work! :)
Hi, the income isnt working for me, whenever it generates theres an error
Missing File Upload folders
The folder containing responses to File Upload questions can't be found. This form won't resume collecting responses until the folder is restored.
UP! i have the same problem. Do you have an update to this?
Thank you so much!
hi deb! i downloaded both forms and send my responses to the tracker and even though i hit preview and send, the information is not showing up in the main form
Hey, How did you make it possible for us to copy of the sheets and google autogenerates forms that match?
Thanks! So helpfull! How to have the shortcuts the shortcuts off the form on my mobile
Hi Deborah!!! THAAAAANK YOU!!! This is amazing, I was just wondering, can I do this from a budget standpoint? For example, I put in my budget on the sheet beforehand, and then same as the form, I enter what was bought and it deducts from my budgeted amount and lets me know what is left?
can i change it to another currency?
This is amazing. Thank you so much. I'm having trouble with the expense and income tracker. When I erased the rows in the income tracker, it did not sync with the income dashboard. Is there something I should do?
Thx for the content Deborah! Super nice! Question: How would we go about importing expenses for a specific month without having to capture them 1 by 1 please? Cheers!
Thank you Mrs. Ho
How would you do this for 2021 and beyond?
OMG so amazing thank you!
sorry to bother you but the part of the trak.er didn't copied. I tried several times. can you help me? great job. thanks for sharing with us
Thank you so much this is great ! is it possible that the receipts dont register? and we need to change the categories on every page?
What a great file! Thank you. Question: When I add a a new category and change it in the graphs below it won't have the same colour as above. Any idea what I am doing wrong?
Thank you so much!!! One question though, is there a way to change the currency? I see that I can change it manually in the graphs but not sure where I can change it in the expense chart
Okay, the explanation is in her newest video :D
Thanyouuu very much
Thank you so much for this! How do I change the dollar to pounds?
Is there any way you could make the dates from september-august as I am using this for university x
Ok awesome Ideas and awesome Expense Tracker.... but is there a way to depreciate one big payment to 12 months? I mean I could break down the payment and add it manually to the list but can I update the form and end up in a depreciation?
Thank you so much for giving us access to this. May I know how to change the currency?
does anyone know how to link new categories to the spreadsheet?
Thank you soo much I now acces the free expense tracker, but anyway how do I add the income?
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@@zelbiee
@@zelbiee thank you so much for this, I was getting so upset that I couldn't get it to work!
Watching this right now, wow it says 2 yrs ago here. How can I change the currency to peso pleaseeeeee
Very cool idea thnx a lot
Wow, thank you so much great template! can you make one for income/expense tracker? that will be able to add input amounts?
Yay your name is called Deborah mine is too
I'm not exaggerating when I say I'm about to unalive myself. I followed the instructions and it worked perfectly, until I decided to customize the categories and it stopped logging in the information I uploaded on the forms. so I decided to delete everything and start over, but now when I make a copy of the expense tracker the google form doesn't copy itself automatically and I don't know what to do and if you could save my life I would totally appreciate it
okay soooo somehow in the span of five minutes it worked again but still is there a way I can edit the name and amount of categories and that the information I log in uploads to the sheet
For some reason when I download the tracker it doesnt also download the form?
Hi Deb,
Thank you for creating this. I have a quick question, would you put an emergency fund in the expense form? I want to keep track of my emergency fund in here as well and I would love your advice. i believe that is what I'll do. Any thoughts you have would be great.
Add an emergency fund as a category :) that way you can input any time you add savings to it, and it will subtract from your income (you are putting it aside) 😀
What do I do if the tracker form says this:
"Missing File Upload folders
The folder containing responses to File Upload questions can't be found. This form won't resume collecting responses until the folder is restored."
Go to your form and press 'Restore' when the pop up shows up!
nice
hi deborah i recently downloaded your tracker 2.0 but every time i open the income and expense i get a error message saying "missing file upload folder"
Open your income and expense form and there will be a pop up that prompts you to create a folder for your files :)
Thank you !!
is there any way of putting it in euros?
please, can I add/change some of the name titles?????
how can i access to this one ?
how can ichange a currency from dollar to my own currency