tag:blogger.com,1999:blog-6220049951646758125.post8798587940312555148..comments2024-03-18T22:51:22.201-04:00Comments on MoneySavingMethods.com: Step by Step Tutorial - Week 1 - Day 1Carrie @ Moneysavingmethods.comhttp://www.blogger.com/profile/03180111156666321863noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-6220049951646758125.post-55153251467173306692008-04-07T13:57:00.000-04:002008-04-07T13:57:00.000-04:00I've just started getting organized and my newest ...I've just started getting organized and my newest tool is my favorite! I've used a small photo album to organize my coupons. It makes it very easy to flip through and find what I want!Mirandahttps://www.blogger.com/profile/16027117351843832213noreply@blogger.comtag:blogger.com,1999:blog-6220049951646758125.post-6194519708044195412008-04-02T23:43:00.000-04:002008-04-02T23:43:00.000-04:00Kardel,That is where I am behind on technology. I...Kardel,<BR/>That is where I am behind on technology. I have no idea how to do a downloadable form. :-)<BR/>But, if you want to email me, I can email you the spreadsheets I do have and you could alter them for your needs.<BR/>CarrieCarrie @ Moneysavingmethods.comhttps://www.blogger.com/profile/03180111156666321863noreply@blogger.comtag:blogger.com,1999:blog-6220049951646758125.post-8123606699413112812008-04-02T16:53:00.000-04:002008-04-02T16:53:00.000-04:00Hello Carrie, I have been reading your site for a ...Hello Carrie, I have been reading your site for a week or two, and I am inspired. <BR/><BR/>Getting organized is where I need the most improvement, but I don't have any idea how to use excel. Do you have any examples/screen shots you could share with us about that? A downloadable form?kardelhttps://www.blogger.com/profile/02907687224624713781noreply@blogger.comtag:blogger.com,1999:blog-6220049951646758125.post-24282069632775279312008-04-01T14:39:00.000-04:002008-04-01T14:39:00.000-04:00Evelyn,Thanks for the question. I, personally, hav...Evelyn,<BR/>Thanks for the question. I, personally, have links, going from one spreadsheet to another, pivot tables, etc linking all my stuff back to my checking and savings account balances, etc. But, I love spreadsheets.<BR/><BR/>If you just want basic columns and how to track your savings and earnings by themselves, I would have just a generic Savings and Earnings Spreadsheet.<BR/><BR/>I broke mine out into columns. The first Column was the date. The 2nd column was the description ( I typed notes, so I would remember what it was ) the 3rd column was the title, and the 4th column was the Amount Saved and Earned. I lumped mine together, but you are welcome to break it out if you want.<BR/>So, date is self explantory. Description, too.<BR/><BR/>The title is a predetermined title I had for each of my categories before I started ( although I could add them later if I need to ).<BR/><BR/>So, my titles are:<BR/>Credit Cards<BR/>Gift Cards<BR/>Obopay<BR/>Rebates<BR/>Checking<BR/>Donation<BR/>Grocery Game<BR/>Kroger<BR/>Prescription<BR/>Ebay<BR/>Cable<BR/>Car Insurance<BR/>BigCrumbs<BR/>Walgreens<BR/>Free Trials<BR/>Rebuy/Return<BR/>CVS<BR/>Online Offers<BR/>Survey<BR/>Freebies<BR/>Ebates<BR/>RME<BR/>Upromise<BR/>Cust Satisfaction<BR/>Recycle Bags<BR/>Buying Coupons<BR/>Text Pay Me<BR/>Loyalty Programs<BR/>Kids Eat Free<BR/>Affiliates<BR/>Sale Shopping<BR/>Newspaper<BR/>Birthday Freebies<BR/>Telephone/Internet<BR/><BR/>And, I will add to this list as I stumble upon new ways to make money. :-)<BR/><BR/>Then, I have a table at the bottom that calculates it all by category. So, here is the formula. =SUMIF($C$2:$D162,B171,$D$2:$D162)<BR/><BR/>So, on the table, make the 1st column your list of titles. Then, in the 2nd column, type that formula. You will need to change the $D162 to be whatever you last cell is ( that is my last cell )<BR/><BR/>Also, B171 will change for each row. So, for Credit Cards, you change B171 to be whatever Letter/# combination the title Credit Cards is in. Do this to the first one. Then, just pull the formula down. The number will automatically update for each title. Hope that kind of makes sense?<BR/><BR/>For your example of your CVS purchase. I would just log the date, Brief Description, and the amount saved ( you can find this on your receipt ). It should be the total of the items, 100% savings, since your OOP wasn't really OOP. It was paid from ECB.<BR/><BR/>I don't log the new $14.97 in ECBs until I actually use them ( it will then show in the total savings on your receipt next time ). Why? Because, although you can use it like cash, they do expire...just like a coupon. And, if you would forget to use it, not be able to make it to the store, ...you didn't really make any money on it then. I don't like to log the savings until I actually use it and save!Carrie @ Moneysavingmethods.comhttps://www.blogger.com/profile/03180111156666321863noreply@blogger.comtag:blogger.com,1999:blog-6220049951646758125.post-8331378886196651912008-04-01T14:02:00.000-04:002008-04-01T14:02:00.000-04:00Could you comment more on what will be on the exce...Could you comment more on what will be on the excel sheet? Examples of columns? I have no idea of what to chart.<BR/><BR/>My example: I bought the soft soap body wash the other day. <BR/><BR/>3 body washes<BR/>1 bar of soap<BR/><BR/>$4.50 in soap coupons<BR/>$5 off coupon<BR/>$3/$5 beauty coupon<BR/><BR/>So OOP was around $3 which I paid with other CVS bucks. I got back $14.97 in ECB. How do you show that?<BR/><BR/>Good jobEvelynhttps://www.blogger.com/profile/08408940767300894357noreply@blogger.com