I am looking for suggestions on an app to keep track of personal finances for the Mac and probably to be synced to an iPad. Nothing complicated, please. Just something to maintain a checkbook, a regular bank account(s), a small Ebay seller’s account. I am probably going to want to itemize on my taxes.
I use to have Quicken for my Mac and really liked it. Now it is on sale for $30. It doesn’t say but I am assuming it is Mac compatible.
Any recommendation and insight you could share would be greatly appreciated.
If your bank provides transaction exports in CSV (comma-separated values) format, then Numbers is a perfectly adequate transaction tracker. For years I have compiled with Numbers all my income tax work papers that assess income, personal and business expenses, in preparation for my tax filing software. I have about a dozen accounts that to track, and they all support CSV export. I find it a lot easier and faster to do things like this in Numbers than in any finance software I’ve wasted money on in the past.
I know somebody that’s run his whole business for…well…as long as computers have been reasonably available and commercially-useful…in Excel. Without anything like pivot tables or any other weird stuff - just straight-up spreadsheet math. I think three spreadsheets basically run the whole thing.
In the case I’m talking about it’s not a template, but just long lists of numbers. Money in (multiple columns for things like sales tax collected), money out, bank account balances, and some sums that total everything up and effectively provide a double-check.
I.e. if “money in” minus “money out” doesn’t basically equal “bank account balance”, there’s a problem somewhere.
That is encouraging. Math is not exactly my strong point, Web. I never cared for it. Yuck. But I am considerably better at it than I give myself credit for. (I just round things off and then I can determine how far off the mark any figures might be, prior to doing the actual math.
Right. If the figures are not jiving, there’s a problem.
The only thing is knowing myself I might try to reinvent the wheel.
So one spreadsheet for each account and then one main one wherein all the totals are included?
If I had an example, I could work off of that and not get terribly distracted.
Yes I use templates. Basically, I have master sheet that has rows for all the relevant tax categories for my situation. The sheet has columns for each account – and each account has its own sheet. The master sheet accumulates the relevant totals from the account sheets. In the master sheet I have canned calculations for allocating expenses between tax types, etc. I can accumulate and assess an entire year’s expenses in a day, once a year.
I run both my business and my personal finances in You Need a Budget.
People are mad about the recent (poorly handled) price increase but I remain happy with the app. It has enabled me to get in control of my finances as I never could before. I only need one account to run both budgets.
I second @anon41602260 ‘s Numbers suggestion. It may be all you need. I’ve used a lot of commercial apps over the years and most are overkill for someone needing an electronic checkbook. Today I use my bank’s website or app that has the ability to aggregate multiple accounts. Then I download a .csv report as needed. Numbers does such a good job of formatting the report all I do is file it as is.
If you find you need something more take a look at Moneydance. It’s been a few years since I’ve used it but they still offer a free trial (limited to 100 entries) and have an iOS app.
This is what I would say, not that I used it a lot, I just tested it out when I was looking for a Bankitivity replacement (which was a good program but they went to a fairly expensive subscription) and it’s a really solid program.
I am not sure I would recommend Numbers/Excel to someone who doesn’t have spreadsheet experience. A good tracker will do all the bells and whistles without any prior knowledge or setup. I do mine in Excel across four workbooks and 20+ tabs (it covers multiple accounts, investing, mortgage tracking, subscriptions, budgets, etc). It gets complicated quickly and you need to learn so fairly complicated formulas to do things Moneyspire will do automatically.
You know, Leeabe, I do have experience with the Mac version of the spreadsheet software but that was a couple of decades ago. LOL! I don’t recall it being terribly difficult but I didn’t have a lot of experience with it.