Tracking our expenses

Non-investing personal finance issues including insurance, credit, real estate, taxes, employment and legal issues such as trusts and wills
Post Reply
User avatar
Topic Author
Offshore
Posts: 431
Joined: Wed Apr 09, 2008 9:43 am
Location: Michigan's West Coast

Tracking our expenses

Post by Offshore »

Can someone recommend a software program that tracks household expenses. I am about 10 years from retirement and it's time to know where all of our expenses lie, month to month. The program shouldn't be complicated. If it's too cumbersome, I won't stick with it.

The only qualifier is the program should be Apple compatible.

Thanks!
Random Poster
Posts: 2288
Joined: Wed Feb 03, 2010 10:17 am

Re: Tracking our expenses

Post by Random Poster »

Why does it need to be a software program?

Just write down everything you spend on the day that you spend it, and after a year or two of doing so you should be able to see where all of your expenses are.

All you need is some paper and a pen or pencil.
User avatar
Topic Author
Offshore
Posts: 431
Joined: Wed Apr 09, 2008 9:43 am
Location: Michigan's West Coast

Re: Tracking our expenses

Post by Offshore »

I was hoping for a little more sophistication than a notebook. For example, every month's entries would include food costs, entertainment, fuel, utilities, insurance premiums etc., etc.. At year end, if one wondered how much was spent on just food for the entire year, this number could be obtained with a mouse click, versus adding up 12 months of entries.
littleken
Posts: 68
Joined: Wed Mar 27, 2013 2:26 pm

Re: Tracking our expenses

Post by littleken »

Microsoft excel
ddunca1944
Posts: 940
Joined: Fri Apr 01, 2011 1:49 pm

Re: Tracking our expenses

Post by ddunca1944 »

I use and love YNAB (You Need A Budget). It runs on Macs or PC's (I have a Mac). I also use and love the iphone app that lets me enter transactions on the go and it syncs with the desktop app over the cloud. Not really necessary, but very useful.

You can download transactions or enter them manually.
ieee488
Posts: 1989
Joined: Thu Dec 10, 2009 8:57 am

Re: Tracking our expenses

Post by ieee488 »

littleken wrote:Microsoft excel
Or LibreOffice Calc if you don't want to buy Excel.
Dell Optiplex 3020 (Win7 Pro), Dell Precision M6300 (Ubuntu Linux 12.04), Dell Precision M6300 (Win7 Pro), Dell Latitude D531 (Vista)
investingdad
Posts: 1798
Joined: Fri Mar 15, 2013 10:41 pm

Re: Tracking our expenses

Post by investingdad »

We use Quicken.

We pay almost all of our bills with our credit card. So when we download all the transactions each month (there are many), they're sorted into the right categories. You have to tell Quicken what a transaction counts as (groceries, dining, etc) so it knows in the future but once you've done it you don't have to do it again.

It's very powerful for tracing how much you spend by category, year to year, to different vendors, down to the dollar. In conjunction with a credit card, Quicken works very smoothly and easily.
jay22
Posts: 877
Joined: Thu Aug 23, 2012 8:56 am
Location: Sacramento, CA

Re: Tracking our expenses

Post by jay22 »

Mint.com is all you need for that.
ddunca1944
Posts: 940
Joined: Fri Apr 01, 2011 1:49 pm

Re: Tracking our expenses

Post by ddunca1944 »

Just a note - Quicken for Mac is nothing like Quicken for PC. In fact, that why I abandoned Quicken adter switching to a Mac.

Some folks like Mint. I did not want to upload my account numbers and passwords to the internet. I prefer to keep those to myself. Also did not want to be bothered by all of the advertising.
User avatar
Topic Author
Offshore
Posts: 431
Joined: Wed Apr 09, 2008 9:43 am
Location: Michigan's West Coast

Re: Tracking our expenses

Post by Offshore »

Great info guys! I've read reviews on Moneydance, iFinance, YNAB, SEE finance and Quicken, but the reviews do not give real-world experience. I appreciate the feedback!

ddunca1994- do mean to say to use Quicken you have to upload your personal info to the net? Wow!
ddunca1944
Posts: 940
Joined: Fri Apr 01, 2011 1:49 pm

Re: Tracking our expenses

Post by ddunca1944 »

No, but to use Mint you do.
User avatar
jeffyscott
Posts: 9202
Joined: Tue Feb 27, 2007 9:12 am
Location: Wisconsin

Re: Tracking our expenses

Post by jeffyscott »

ieee488 wrote:
littleken wrote:Microsoft excel
Or LibreOffice Calc if you don't want to buy Excel.
Or google drive spreadsheet, if you don't want to download anything or worry about back-ups and want to have access from any computer.
The two greatest enemies of the equity fund investor are expenses and emotions. ― John C. Bogle
User avatar
mhc
Posts: 4195
Joined: Mon Apr 04, 2011 10:18 pm
Location: NoCo

Re: Tracking our expenses

Post by mhc »

jeffyscott wrote:
ieee488 wrote:
littleken wrote:Microsoft excel
Or LibreOffice Calc if you don't want to buy Excel.
Or google drive spreadsheet, if you don't want to download anything or worry about back-ups and want to have access from any computer.
A spreadsheet of any kind is easy. I have a row for each type of expense, a column for each month, and a worksheet for each year. I also use the spreadsheet to make sure I pay my bills every month.
ieee488
Posts: 1989
Joined: Thu Dec 10, 2009 8:57 am

Re: Tracking our expenses

Post by ieee488 »

Does your credit card company add up the expenses in categories for you, or do you have to it the hard way by using a calculator?
Dell Optiplex 3020 (Win7 Pro), Dell Precision M6300 (Ubuntu Linux 12.04), Dell Precision M6300 (Win7 Pro), Dell Latitude D531 (Vista)
lwfitzge
Posts: 311
Joined: Sun Jun 12, 2011 8:01 am

Re: Tracking our expenses

Post by lwfitzge »

I use Mint.com... I also use its apps for iPhone and iPad.
User avatar
1210sda
Posts: 1720
Joined: Wed Feb 28, 2007 8:31 am

Re: Tracking our expenses

Post by 1210sda »

mhc wrote: A spreadsheet of any kind is easy. I have a row for each type of expense, a column for each month, and a worksheet for each year. I also use the spreadsheet to make sure I pay my bills every month.
I too follow the same approach as mhc. In the top part of my SS, I have those expenses that occur monthly. Below that I have a section for my "non-monthly expenses". Here I include such things as property tax payments, estimated tax payments, homeowners insurance, auto insurance, etc, etc.

This second section helps keep me on track so that I don't forget to pay bills that don't occur regularly every month (for which there is a tendancy to overlook). I don't want to pay late fees or penalties.

1210
User avatar
Toons
Posts: 13829
Joined: Fri Nov 21, 2008 10:20 am
Location: Hills of Tennessee

Re: Tracking our expenses

Post by Toons »

Quicken 20 year user,it works if you use it :happy
"One does not accumulate but eliminate. It is not daily increase but daily decrease. The height of cultivation always runs to simplicity" –Bruce Lee
rixer
Posts: 710
Joined: Tue Sep 11, 2012 4:18 pm

Re: Tracking our expenses

Post by rixer »

I think this might work for you. I use it and you don't have to enter personal info like Mint.
I think I found it on Google doc's.
http://www.free-financial-advice.net/create-budget.html
User avatar
Frugal Al
Posts: 1726
Joined: Fri May 28, 2010 10:09 am

Re: Tracking our expenses

Post by Frugal Al »

Toons wrote:Quicken 20 year user,it works if you use it :happy
+1 If I had to enter all spending into an Excel spreadsheet I'd give up on it. Like Investingdad, I do so little cash spending that it's just a miscellaneous amount and the downloading of credit/debit card data is fast and easy. The ability to quickly sort and categorize spending and purchases, cash flow graphing by month, and loan amortization, along with its reasonable investment tracking functions makes it a bargain if one considers the total functionality.
rr2
Posts: 1032
Joined: Wed Nov 19, 2008 10:04 pm

Re: Tracking our expenses

Post by rr2 »

On my Mac, I use an application called Moneywell. It works great for budgeting and tracking as it has the ability to download transactions from your financial institutions just like Quicken. It uses the envelope budgeting system.
Sidney
Posts: 6751
Joined: Thu Mar 08, 2007 6:06 pm

Re: Tracking our expenses

Post by Sidney »

Offshore wrote:I was hoping for a little more sophistication than a notebook. For example, every month's entries would include food costs, entertainment, fuel, utilities, insurance premiums etc., etc.. At year end, if one wondered how much was spent on just food for the entire year, this number could be obtained with a mouse click, versus adding up 12 months of entries.
When I wanted to track ours, we just started putting everything on 2 credit cards. We tend to use the same "vendors" all the time anyway so I just download the transactions from the CC company, add a few check and DD transactions and run a quick pivot table. I don't have to enter much data manually. Takes me about an hour or two once a year.
I always wanted to be a procrastinator.
User avatar
runner9
Posts: 2134
Joined: Tue Aug 02, 2011 8:49 pm
Location: Ohio

Re: Tracking our expenses

Post by runner9 »

Microsoft Money
User avatar
Lieutenant.Columbo
Posts: 1178
Joined: Sat Sep 05, 2015 9:20 pm
Location: Cicely AK

Re: Tracking our expenses

Post by Lieutenant.Columbo »

1210sda wrote:...In the top part of my SS, I have those expenses that occur monthly. Below that I have a section for my "non-monthly expenses". Here I include such things as property tax payments, estimated tax payments, homeowners insurance, auto insurance, etc, etc.

This second section helps keep me on track so that I don't forget to pay bills that don't occur regularly every month (for which there is a tendancy to overlook). I don't want to pay late fees or penalties
1210sda,
do you split any of the expenses by "discretionary" vs "non discretionary"?
like "discretionary groceries" vs "non discretionary groceries" or "discretionary clothing" vs "non discretionary clothing", etc...
if so, which ones?
thank you
Last edited by Lieutenant.Columbo on Mon Jan 16, 2017 10:24 pm, edited 1 time in total.
Lt. Columbo: Well, what do you know. Here I am talking with some of the smartest people in the world, and I didn't even notice!
mass88
Posts: 59
Joined: Fri Jan 29, 2016 5:31 pm

Re: Tracking our expenses

Post by mass88 »

An excel spreadsheet. You can easily build a simple spreadsheet that allows you to log your expenses and then have it total the categories up on a monthly basis and you can see how you're doing. I have found the less automated everything is, the more I pay attention.

One tab would be a transaction journal where you would list each transaction and assign a category for it. Then on another tab you could have a Profit and Loss Statement to sum the transactions based on month and category to see how you did for the month.
Goinganontoday
Posts: 60
Joined: Sat Jan 14, 2017 4:58 pm

Re: Tracking our expenses

Post by Goinganontoday »

I love You Need A Budget. We've used it for almost four years and it's been fantastic.
Mom 2 Groms
Posts: 39
Joined: Fri Jan 13, 2017 9:57 pm

Re: Tracking our expenses

Post by Mom 2 Groms »

We also use YNAB and recommend it to everyone that we talk finances with IRL. We have YNAB4, so it doesn't sync to accounts online, but with the new version syncing is optional.
frugalfraggle
Posts: 61
Joined: Thu Apr 10, 2014 2:09 pm

Re: Tracking our expenses

Post by frugalfraggle »

I use Banktivity, it's Mac only and strikes a good balance between ease of use and power. www.iggsoftware.com. It's made by some x Intuit folks.
User avatar
CyclingDuo
Posts: 3744
Joined: Fri Jan 06, 2017 9:07 am

Re: Tracking our expenses

Post by CyclingDuo »

frugalfraggle wrote:I use Banktivity, it's Mac only and strikes a good balance between ease of use and power. http://www.iggsoftware.com. It's made by some x Intuit folks.
Curious if anyone uses something like 360 Financial View or Fidelity's Full View which can do the same thing and is free for those who have accounts. Similar services at other institutions as well. Wells Fargo has the "My Expense Report" that tracks everything related to your bank account/credit card. Bank of America and others have similar as well.

Why pay for an outside program if you already have something included with your bank or brokerage? Either way, you have to set it all up and get used to using it - be it pad and paper, Quicken, iBank/Banktivity, 360 Financial View, Full View, My Expense Report, etc... .

The Mac/Apple only iggsoftware Banktivity(formerly iBank) looks like a subscription service. The iPhone version says $39.99 per year. Do you know if the subscription is per device (one for both spouses), and the laptop - or do you have to pay for each device?

TIA
"Save like a pessimist, invest like an optimist." - Morgan Housel
AlwaysAStudent
Posts: 94
Joined: Mon Dec 07, 2015 11:38 am

Re: Tracking our expenses

Post by AlwaysAStudent »

Another vote for YNAB.
User avatar
Lieutenant.Columbo
Posts: 1178
Joined: Sat Sep 05, 2015 9:20 pm
Location: Cicely AK

Re: Tracking our expenses

Post by Lieutenant.Columbo »

CyclingDuo wrote:Fidelity's Full View
CyclingDuo,
does Fidelity Full View require access to credit card and bank accounts?
Thanks
Lt. Columbo: Well, what do you know. Here I am talking with some of the smartest people in the world, and I didn't even notice!
clutchied
Posts: 674
Joined: Mon Jan 05, 2015 12:11 pm

Re: Tracking our expenses

Post by clutchied »

If you want a system that requires very little from you just use Mint and hook up whatever cards or bank information you want; i.e. where you spend your money from.


Mint churns through it all and categorizes items for you and will produce monthly reports. It really is an amazing system. I think I have almost 6 years of data now and it is just about the most useful financial tool I've ever had.


You can develop budgets and it tells you how you've done compared to your budget.
Mom 2 Groms
Posts: 39
Joined: Fri Jan 13, 2017 9:57 pm

Re: Tracking our expenses

Post by Mom 2 Groms »

CyclingDuo wrote:
frugalfraggle wrote:I use Banktivity, it's Mac only and strikes a good balance between ease of use and power. http://www.iggsoftware.com. It's made by some x Intuit folks.
Curious if anyone uses something like 360 Financial View or Fidelity's Full View which can do the same thing and is free for those who have accounts. Similar services at other institutions as well. Wells Fargo has the "My Expense Report" that tracks everything related to your bank account/credit card. Bank of America and others have similar as well.

Why pay for an outside program if you already have something included with your bank or brokerage? Either way, you have to set it all up and get used to using it - be it pad and paper, Quicken, iBank/Banktivity, 360 Financial View, Full View, My Expense Report, etc... .

The Mac/Apple only iggsoftware Banktivity(formerly iBank) looks like a subscription service. The iPhone version says $39.99 per year. Do you know if the subscription is per device (one for both spouses), and the laptop - or do you have to pay for each device?

TIA

I personally don't like the generic tracking tools that come standard with my credit card or bank account. My budget is detailed, and I like having control of the categories. With YNAB, I also have the ability to allocate dollars to a specific category even if I don't spend the dollars for several months. Two examples of this in my budget are car repairs and Christmas gifts. I budget $175/mo for car repairs, even if I don't send my vehicle to the shop every month. When I have a large repair, there isn't a huge hit to my budget and I don't have to change any of my other spending because I've planned for an known variable. Christmas is similar, I budget 1/12 of my Christmas spending every month, but I spend most of it in November or December.
I also prefer it to a spreadsheet because the app syncs with my budget on my computer. When DH are I are out and we think about going out to eat, or a impulse buy, we can check our budget to see how many dollars are available to spend in the appropriate category before we make a decision. It really helps with the discipline of sticking to a planned budget.
PFInterest
Posts: 2684
Joined: Sun Jan 08, 2017 12:25 pm

Re: Tracking our expenses

Post by PFInterest »

excel, google sheets, libre office
mptfan
Posts: 6260
Joined: Mon Mar 05, 2007 9:58 am

Re: Tracking our expenses

Post by mptfan »

Google sheets.
User avatar
CyclingDuo
Posts: 3744
Joined: Fri Jan 06, 2017 9:07 am

Re: Tracking our expenses

Post by CyclingDuo »

Lieutenant.Columbo wrote:
CyclingDuo wrote:Fidelity's Full View
CyclingDuo,
does Fidelity Full View require access to credit card and bank accounts?
Thanks
Yes. So does TIAA, and B of A.
"Save like a pessimist, invest like an optimist." - Morgan Housel
User avatar
Lieutenant.Columbo
Posts: 1178
Joined: Sat Sep 05, 2015 9:20 pm
Location: Cicely AK

Re: Tracking our expenses

Post by Lieutenant.Columbo »

CyclingDuo wrote:
Lieutenant.Columbo wrote:
CyclingDuo wrote:Fidelity's Full View
CyclingDuo,
does Fidelity Full View require access to credit card and bank accounts?
Thanks
Yes. So does TIAA, and B of A.
thank you
1. do you know if Fidelity Full View does a good job a categorizing expenses (like will insurance payments be listed under "insurance")?
2. can one enter cash expenses manually into Full View?
Thank you.
Lt. Columbo: Well, what do you know. Here I am talking with some of the smartest people in the world, and I didn't even notice!
inverter
Posts: 416
Joined: Mon Jul 27, 2015 1:40 pm

Re: Tracking our expenses

Post by inverter »

YNAB. Simple, intuitive, and cost effective. Syncing makes it easy on you.
Oriolesfan
Posts: 6
Joined: Wed Jan 08, 2014 2:26 pm

Re: Tracking our expenses

Post by Oriolesfan »

I am very happy with Mvelopes. I have used it for over four years. The envelope budgeting concept works better for me than anything I have used in the past, like a spreadsheet, quicken, and mint. Mvelopes learning curve was a little quirky to start, but once it becomes familiar its very, very easy to use, love the reliable bank and credit card downloads. Support has been good as well. Like having versions on mobile, windows, mac. Free version and paid version avalable.
User avatar
CyclingDuo
Posts: 3744
Joined: Fri Jan 06, 2017 9:07 am

Re: Tracking our expenses

Post by CyclingDuo »

Lieutenant.Columbo wrote:
CyclingDuo wrote:
Lieutenant.Columbo wrote:
CyclingDuo wrote:Fidelity's Full View
CyclingDuo,
does Fidelity Full View require access to credit card and bank accounts?
Thanks
Yes. So does TIAA, and B of A.
thank you
1. do you know if Fidelity Full View does a good job a categorizing expenses (like will insurance payments be listed under "insurance")?
2. can one enter cash expenses manually into Full View?
Thank you.
Yes to #1.

#2. We don't use cash except for very small food and snack purchases ($1 coffee, bag of peanuts, a sandwich wrap, beverage or snack here and there). So our cash purchases for that are an ATM cash withdrawal with the debit card - and those ATM/Debit withdrawals are recategorized as food in Full View since that's all we use the cash for when it comes to a purchase. In addition to debit/credit card purchases, we use ApplePay which Fidelity does a great job with, along with other cash management options.
"Save like a pessimist, invest like an optimist." - Morgan Housel
User avatar
Lieutenant.Columbo
Posts: 1178
Joined: Sat Sep 05, 2015 9:20 pm
Location: Cicely AK

Re: Tracking our expenses

Post by Lieutenant.Columbo »

CyclingDuo wrote:Yes to #1.

#2. We don't use cash except for very small food and snack purchases ($1 coffee, bag of peanuts, a sandwich wrap, beverage or snack here and there). So our cash purchases for that are an ATM cash withdrawal with the debit card - and those ATM/Debit withdrawals are recategorized as food in Full View since that's all we use the cash for when it comes to a purchase. In addition to debit/credit card purchases, we use ApplePay which Fidelity does a great job with, along with other cash management options.
thank you very much for explaining this
Lt. Columbo: Well, what do you know. Here I am talking with some of the smartest people in the world, and I didn't even notice!
Post Reply