Thank you so much Jeff. I currently live in Ecuador and we have a small charity for Ecuadorians to help with food, school supplies and Christmas for their children. I am so glad I found you to keep track of everything as it is still a little costly for us to use one of the big accounting software companies. Thank you again so much.
Thank you Jeff! You know it's that time of year (late January) and I was on the hunt for a spreadsheet. So grateful to be pointed towards yours. God bless YOU!
Thank you so much! This is exactly what I was looking for and you did such a wonderful job describing how to work with it. You should be very proud of yourself!
Thank you, Jeff. I am not Savey at excel and need a spreadsheet for my church. How can I add a tab to keep track of all the donations for the one donor for the year, maybe in the Donor's tab bottom of address.
There is a plus sign + near the bottom that lets you add a new tab. If Word is more your thing, I have this template from my old job: www.dakotasumc.org/media/files/CONFERENCE/5_Conf_Finance_Benefits/Finance/Template_for_Gifts_Over_250.docx
@@JeffPospisil Are you able to update the link with a new spreadsheet? I believe someone may have edited the one you have in the description. Maybe make it read only and have people copy it? The version I have, has a lot of the formula's messed up.
@@ariantylerstar Here's the new link. I'll update the link in Description too. docs.google.com/spreadsheets/d/1YQAUhZLt2ZEVUGKZKlzF9N-GOBo2uj55HAjnFxAPEt4/edit?usp=sharing
You have this setup so anyone that see sit can edit, which will change things if they alter anything. You also have personal information including full names/addresses. You should remove to lorum ipsum or blank and change to "view only" for people that aren't you. People can create a copy if they want it.
I had it as "View Only" before which was causing people issues that wanted to download a copy. Now the pain is people saving personal data without making a copy. I wish I had a link that would just automatically create for them a copy. Thoughts?
I attempted to RESTORE it to the oldest version, it appears to have worked for the most part. I notice the title was edited. I'm to sure Jeff, if there is a way for you to make a google doc available for download but that we cannot EDIT the original version... just out downloaded one? anything to prevent people from not following directions and editing the original document, making it not very useable for others
Thank you for your video. I have tried using your form in the description and it does not match what you have. There are so many additional tabs and became a little confusing where items didn't seem to match up.
It looks like someone forgot to make their own copy. I refreshed the file. Here is the new link: docs.google.com/spreadsheets/d/1zfVDjk6SqLLMtUPCgikakOdIPmqko4kc5KDqsXDoOxM/edit?usp=sharing
Thank you so much, this is something I've been looking for to help track tithes in a small church. Question? The Donation Tab, I couldn't get the list of donors to format like the google sheet. So, when I type the donor's name in a cell it doesn't populate. Do you mind sharing the formular? God Bless!
Try this one. docs.google.com/spreadsheets/d/1KMjr0la09Zp-taIBJ_EXagTk2UX2ijc2CrH8x3AQoxc/edit?usp=sharing You need to create a Copy for yourself. It looks like someone mistakenly edited the original.
Hi Jeff, thank you for sharing this. Do you send periodic Pledge/Tithing statements to your donors? If so, do you have an ideal template for a periodic statement to donors for their records and for their tax purposes?
Hi Anjelica, I do like sending quarterly statements. With that statement, I normally try to give an update on how things are going (not just financially but also with the ministries) and what we're looking forward to.
someone edited it!!! a few days ago ugh!!!!! can you put the original template back up? right now it has been edited. they must not have downloaded a copy before working on it :(
Try "Make a Copy". In the upper right, make sure that it's not shared with anyone. Here's a fresh version for you to make a copy of. Also, it works if you download to Microsoft Excel. docs.google.com/spreadsheets/d/1uo05IaPoWX0fXtS4c8pJSOxfvp1SzQyw65kR6oI_zAA/edit?usp=sharing
I have a question.... Can you make the formula for the counter sheet to sum a date range instead of just one date. I wanted to make it a monthly report and am struggling to figure out how to add the formula in the cell labeled DATE: . Thank you in advance for any help.
This is such a good idea. Thank you! Long story short, I made it so there is a Beginning and Ending Date which is used in the SumIfs formula. I created an updated version for you to check out how I did it: docs.google.com/spreadsheets/d/1nqTNsip6ybgG-1yfFfFn9rKubcraN8B1JHO1GmmFbcw/edit?usp=sharing
@@JeffPospisil I appreciate the updated version. I unfortunately cannot figure out how to link it to what I have already created. I am very new to google sheets and do not know anything with excel. I am just going to have to figure it out. I appreciate your help and I am very grateful for the work you have put into this sheet.
hi jeff, i have different currencies so i want to change the denomination to my currencies. how i do it? my country use 1000 as the lowest nominal.. just like $1
I had to refresh the link. Here it is. You will need to go to "File" and Make a Copy. docs.google.com/spreadsheets/d/1wTOjQu_M4znXI9KIh410eqDqULJqUpHZnxcPgoca9Eo/edit?usp=sharing
Help! I accidentally made edits on the original document instead of the copy I made. Now the link posted on the video takes people to the blank document with the data erased. Can you fix this? I'm so sorry!
The other thing to check is to go to drive.google.com. On the left, there is an option that says "Shared with me". You might be able to find your version in there as well.
I do have my version. I wanted you to be aware that I messed up the link on your video, and if possible, you will want to change that link back to your original version. Sorry again!@@JeffPospisil
Hey Jo, Normally I work in Excel so I'm not sure if this is possible with Google Sheets and Google Docs. What I would do is Export this to Microsoft Excel. You can then use Microsoft Word to Mail Merge the data from the Donor Summary tab into the letter to create a statement. I wish I would have set this up directly in that Donor Tracker template.
@@JeffPospisilhey Jeff! So extremely thankful for this tutorial. Only question I had is like the person above, is there a way to use the donation reports in order to give each doner a yearly report for tax purposes? Thank you!
@@brandicebartholomew3052 , I wish I would have thought of that earlier. I may need to develop a second version of this. I did a video showing what it would look like if you export to Excel and create the statements with Mail Merge: th-cam.com/video/0KcmmCJw2oU/w-d-xo.html
I refreshed the spreadsheet. Here's the fresh copy to use to make your own copy: docs.google.com/spreadsheets/d/12VDvIVOv-yKAizKtuZzFO8htF3bYk6NrwZObkK87Pok/edit?usp=sharing
Starting as a new church treasurer here. Thank you so much. God Bless You
It is an honor to have been able to help. Blessings!
Thank you so much Jeff. I currently live in Ecuador and we have a small charity for Ecuadorians to help with food, school supplies and Christmas for their children. I am so glad I found you to keep track of everything as it is still a little costly for us to use one of the big accounting software companies. Thank you again so much.
That is fantastic to hear! Thank you for sharing.
Thank you Jeff! You know it's that time of year (late January) and I was on the hunt for a spreadsheet. So grateful to be pointed towards yours. God bless YOU!
Very cool!
Thank you so much! This is exactly what I was looking for and you did such a wonderful job describing how to work with it. You should be very proud of yourself!
Thank you for the feedback! I'm happy to help.
Thank you, Jeff. I am not Savey at excel and need a spreadsheet for my church. How can I add a tab to keep track of all the donations for the one donor for the year, maybe in the Donor's tab bottom of address.
There is a plus sign + near the bottom that lets you add a new tab. If Word is more your thing, I have this template from my old job: www.dakotasumc.org/media/files/CONFERENCE/5_Conf_Finance_Benefits/Finance/Template_for_Gifts_Over_250.docx
Thank you! This was so helpful. I’m in the process of trying to get my church to be more compliant efficient and this is so helpful.
Glad to hear! May the LORD bless your efforts.
@@JeffPospisil Are you able to update the link with a new spreadsheet? I believe someone may have edited the one you have in the description. Maybe make it read only and have people copy it? The version I have, has a lot of the formula's messed up.
@@ariantylerstar Here's the new link. I'll update the link in Description too. docs.google.com/spreadsheets/d/1YQAUhZLt2ZEVUGKZKlzF9N-GOBo2uj55HAjnFxAPEt4/edit?usp=sharing
You have this setup so anyone that see sit can edit, which will change things if they alter anything. You also have personal information including full names/addresses. You should remove to lorum ipsum or blank and change to "view only" for people that aren't you. People can create a copy if they want it.
I had it as "View Only" before which was causing people issues that wanted to download a copy. Now the pain is people saving personal data without making a copy. I wish I had a link that would just automatically create for them a copy. Thoughts?
I attempted to RESTORE it to the oldest version, it appears to have worked for the most part. I notice the title was edited. I'm to sure Jeff, if there is a way for you to make a google doc available for download but that we cannot EDIT the original version... just out downloaded one? anything to prevent people from not following directions and editing the original document, making it not very useable for others
I'll need to look into it. Thanks for noticing. I end up refreshing it about once per week.
Thank you for your video. I have tried using your form in the description and it does not match what you have. There are so many additional tabs and became a little confusing where items didn't seem to match up.
It looks like someone forgot to make their own copy. I refreshed the file. Here is the new link: docs.google.com/spreadsheets/d/1zfVDjk6SqLLMtUPCgikakOdIPmqko4kc5KDqsXDoOxM/edit?usp=sharing
Thank you so much, this is something I've been looking for to help track tithes in a small church. Question? The Donation Tab, I couldn't get the list of donors to format like the google sheet. So, when I type the donor's name in a cell it doesn't populate. Do you mind sharing the formular? God Bless!
You are welcome!
Thanks for doing this but I downloaded it and it has only Donations tab. Are there supposed to be others?
Try this one. docs.google.com/spreadsheets/d/1KMjr0la09Zp-taIBJ_EXagTk2UX2ijc2CrH8x3AQoxc/edit?usp=sharing
You need to create a Copy for yourself. It looks like someone mistakenly edited the original.
@@JeffPospisilThanks so much! I'm hoping this will work for a simple donor mgmt for our non-profit. God bless!
Hi Jeff, thank you for sharing this. Do you send periodic Pledge/Tithing statements to your donors? If so, do you have an ideal template for a periodic statement to donors for their records and for their tax purposes?
Hi Anjelica, I do like sending quarterly statements. With that statement, I normally try to give an update on how things are going (not just financially but also with the ministries) and what we're looking forward to.
someone edited it!!! a few days ago ugh!!!!! can you put the original template back up? right now it has been edited. they must not have downloaded a copy before working on it :(
Oh man!
Jeff, just downloaded the spreadsheet but it is in "view only" setting. How can I use it with the editing feature?
I just granted you access. I'll fix the link to "edit" later today.
I downloaded this spreadsheet. Started using it. Now it's all converted to a bejing funds tracker. What's going on?
Try "Make a Copy". In the upper right, make sure that it's not shared with anyone. Here's a fresh version for you to make a copy of. Also, it works if you download to Microsoft Excel. docs.google.com/spreadsheets/d/1uo05IaPoWX0fXtS4c8pJSOxfvp1SzQyw65kR6oI_zAA/edit?usp=sharing
thank you! Now to further the process into creating official tax receipts from these sheets, please?!
I really like that idea. I'll add it to my To Do list.
I have a question.... Can you make the formula for the counter sheet to sum a date range instead of just one date. I wanted to make it a monthly report and am struggling to figure out how to add the formula in the cell labeled DATE: . Thank you in advance for any help.
This is such a good idea. Thank you!
Long story short, I made it so there is a Beginning and Ending Date which is used in the SumIfs formula. I created an updated version for you to check out how I did it: docs.google.com/spreadsheets/d/1nqTNsip6ybgG-1yfFfFn9rKubcraN8B1JHO1GmmFbcw/edit?usp=sharing
@@JeffPospisil I appreciate the updated version. I unfortunately cannot figure out how to link it to what I have already created. I am very new to google sheets and do not know anything with excel. I am just going to have to figure it out. I appreciate your help and I am very grateful for the work you have put into this sheet.
@@ashleyrushmore8205 You are welcome!
How do I make a copy of this that I will only have access to and my foundation?
You need to be logged into Google. Then go to File and Make a Copy.
hi jeff, i have different currencies so i want to change the denomination to my currencies. how i do it? my country use 1000 as the lowest nominal.. just like $1
I'm sorry, I don't have an answer for you. I have experimented with this, but am not sure how to change currencies.
Hi sir can you help!! I'm sooo sorry that I edited on the original excel sheet
No problem. You can continue to use that copy. I made a fresh copy to link to the video.
how do I get this spreadsheet?
I had to refresh the link. Here it is. You will need to go to "File" and Make a Copy. docs.google.com/spreadsheets/d/1wTOjQu_M4znXI9KIh410eqDqULJqUpHZnxcPgoca9Eo/edit?usp=sharing
Help! I accidentally made edits on the original document instead of the copy I made. Now the link posted on the video takes people to the blank document with the data erased. Can you fix this? I'm so sorry!
I do try to keep an archive of these. Was this the one: docs.google.com/spreadsheets/d/1g79iIJMr48lBJ8Pf_iVmiTSwAaFDSb6vXdntC0OMbT0/edit?usp=sharing
The other thing to check is to go to drive.google.com. On the left, there is an option that says "Shared with me". You might be able to find your version in there as well.
I do have my version. I wanted you to be aware that I messed up the link on your video, and if possible, you will want to change that link back to your original version. Sorry again!@@JeffPospisil
@@ZachLyons-lp8yu Thanks, I'll refresh it.
Please refresh it! I lost my entire spreadsheet I started last week 😭
Is there a way to create a contribution statement for each individual at the end of the year?
Hey Jo, Normally I work in Excel so I'm not sure if this is possible with Google Sheets and Google Docs. What I would do is Export this to Microsoft Excel. You can then use Microsoft Word to Mail Merge the data from the Donor Summary tab into the letter to create a statement. I wish I would have set this up directly in that Donor Tracker template.
@@JeffPospisil
I need a lesson on that! I have done a few things in Excel, but it's been a while!
@@johertel I'll do a video on that around the beginning of January. It should help some folks.
@@JeffPospisilhey Jeff! So extremely thankful for this tutorial. Only question I had is like the person above, is there a way to use the donation reports in order to give each doner a yearly report for tax purposes? Thank you!
@@brandicebartholomew3052 , I wish I would have thought of that earlier. I may need to develop a second version of this. I did a video showing what it would look like if you export to Excel and create the statements with Mail Merge: th-cam.com/video/0KcmmCJw2oU/w-d-xo.html
please shred by monthly report sheet by editing
I refreshed the spreadsheet. Here's the fresh copy to use to make your own copy: docs.google.com/spreadsheets/d/12VDvIVOv-yKAizKtuZzFO8htF3bYk6NrwZObkK87Pok/edit?usp=sharing