looking for an excel spreadsheet to track spending - Mothering Forums
Forum Jump: 
 
Thread Tools
#1 of 8 Old 03-19-2011, 04:17 PM - Thread Starter
 
lunamama's Avatar
 
Join Date: Jan 2002
Location: Wild Rivers Coast
Posts: 228
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)

I have been looking all over and cannot find one that will add my spending and categorize. Seems simple enough. I would create one myself if I knew how.

lunamama is offline  
#2 of 8 Old 03-19-2011, 07:00 PM
 
PlayaMama's Avatar
 
Join Date: Apr 2007
Posts: 2,763
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)

i think there are much better budget systems than excel.

 

 

if you want to add up a series of numbers use this formula =SUM(letternumber:letternumber) this is for a bunch of numbers in a column, so like A1:A12 would add up all the numbers from A1 to A12.

 

i think you'd have to categorize it yourself, but that wouldn't be too hard if you just each item into a different row. there might be some way to do it, but i'd look for something that is designed for budget stuff.


eh. who needs a signature?
PlayaMama is offline  
#3 of 8 Old 03-20-2011, 07:36 AM
 
Shakti77's Avatar
 
Join Date: Dec 2008
Location: Toronto
Posts: 390
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)

I have been using MS Money and recent convert to Quicken and loving it! Before all of this, I did create an xl sheet that group income and expenses into categories and showed me how I have more to spend ;) (alright, save.) And it was VERY helpful.

 

For free xl sheets that track expenses, I found these. http://www.mdmproofing.com/iym/excel.html - They have a few spreadsheets. maybe one it might suit your needs.

 


nerdy mom to DD1 7yo, D2 infant
Shakti77 is offline  
#4 of 8 Old 03-20-2011, 07:53 AM
rcr
 
rcr's Avatar
 
Join Date: Jul 2008
Posts: 2,711
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)

We have been using mint.com. It is free and does everything for you. I have guardianship for my mom with Alzheimer's, so I have to report yearly to the probate court on what I spend on her behalf. mint.com does all the work for me. I highly recommend it, if you don't mind sharing your personal information with a third party.


Mom to DS 12/07 and DD 11/13, plus a bunch of chickens, dogs, and cats.

Moving past many years of infertility and always thinking of my friends in the infertility forums.

rcr is offline  
#5 of 8 Old 03-20-2011, 09:29 PM
 
SundayCrepes's Avatar
 
Join Date: Feb 2008
Posts: 4,745
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)

I use Quicken 2007. I enter each expenditure with appropriate category. I can tell you how much I spend on chicken feed, how much I spent on straw for the chickens, how much on haircuts for each member of the family, etc. I can get a report or graph. The graph was really helpful when I wanted to see how much I'd been spending on groceries each month. Doing taxes is really easy because the H&R software will download all my tax-related expenditures right into the program so I hardly have any information I have to enter.

 

Intuit makes you buy a new version every 3 years if you use the automatic update feature.  I've read reviews of the 2010 version and I think people found the older versions easier (though I don't remember the details since it's been a year since I read the reviews.) To update my accounts, I go into my bank's account website and download from there. I cannot update my investment accounts. You can still get copies of 2007 at amazon for a reduced price.

 

I also carry a pda with me and use this software: http://www.inesoft.com/eng/index.php?in=premium.html I enter my transactions into the pda while I'm at the store then transfer them to my computer at home. Supposedly they are going to make a version for android then I can put it on my phone.


Created an instant family (7/89 and 5/91) in 1997. Made a baby boy 12/05 adopted a baby girl 8/08. Ask me about tandem adoptive nursing. Now living as gluten, dairy, cane sugar, and tomato free vegetarians. Homeschooling and loving it.

SundayCrepes is offline  
#6 of 8 Old 03-21-2011, 10:20 AM
 
heatherdeg's Avatar
 
Join Date: Dec 2003
Location: Everywhere... thanks, technology!
Posts: 4,888
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 4 Post(s)

I have an Excel sheet.  I've used the rest and sorry, I'm just an Excel person.  I like the COMPLETE control I have over what gets put where.  Quicken & Money were more work for me--trying to make sure that they sorted this or that correctly.  I just got used to Excel.  It's really just one of those things that when you're comfortable with one thing, it's hard to find something else that's as comfortable.  I also don't like my data in someone else's hands--like mint.com, etc.  Mine will track what you spend in each budget category for the month vs. what you planned.  You still have to sort the entries by category (you just enter the amount under the right category), but it rolls up into a monthly "budget v. actual".

 

If you want to pm me your e-mail addy, I will strip mine of my personal data and send it out before Friday (when I leave for vacation! :D)


Heather - Wife , Mommy  & Health & Wellness Educator, Speaker & Consultant 
 
Dairy, soy & corn free with limited gluten... yes, really. And journeying towards peace.  Blogging about both.
 
Let me guide you to find the food and lifestyle choices...
heatherdeg is offline  
#7 of 8 Old 03-23-2011, 04:26 PM
 
happysmileylady's Avatar
 
Join Date: Feb 2009
Posts: 1,216
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)

What year version of Excel do you have?

 

I have Office 2007 and if you click the little windows button at the top, then click new, you can download all manner of versions of budget sheets.  And then you can change them to fit whatever your needs are.

happysmileylady is offline  
#8 of 8 Old 03-25-2011, 11:39 AM - Thread Starter
 
lunamama's Avatar
 
Join Date: Jan 2002
Location: Wild Rivers Coast
Posts: 228
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)

I couldn't find what I was looking for to use in excel.

I actually found an app for my iphone that is exactly what I was looking for. It is called ExpenseTracker. I'm happy with it so far.

lunamama is offline  
Reply

Quick Reply
Message:
Drag and Drop File Upload
Drag files here to attach!
Upload Progress: 0
Options

Register Now

In order to be able to post messages on the Mothering Forums forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.
User Name:
If you do not want to register, fill this field only and the name will be used as user name for your post.
Password
Please enter a password for your user account. Note that passwords are case-sensitive.
Password:
Confirm Password:
Email Address
Please enter a valid email address for yourself.
Email Address:

Log-in

Human Verification

In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.



User Tag List

Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page


Forum Jump: 

Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off