online personal finance software that I can host myself
I generally concur with your sentiments. mint.com has 'hack me' written all over it.  I know of two major open source tools for accounting: GNUCash and LedgerSMB. I use GNUCash, which comes close to meeting your needs: The 2.4 series introduced SQL DB support; mysql, postgres and sqlite are all supported. I migrated to sqlite to see how the schema looked and ran, the conclusion was that it runs fine but writing direct sql queries is probably beyond me. I may move it to postgres in the future, just so I can write some decent reports. Note that while it uses HTML for reporting, there is no no web frontend. It still requires a client, and is not multi-user safe. But it's probably about the closest to what you what that still falls under the heading of 'personal finance'. A fork of SQL Ledger, this is postgreSQL only but does have a web frontend. All the open source finance webapps I've found are designed for small to medium busineses. I believe it should meet your needs, though I've never used it. It might be overkill and difficult to use for your limited purposes though. I know one or two people in the regional LUG use LedgerSMB, but I really don't need invoicing and paystubs. You can use www.mint.com for most of your requirements. It works great for me, it's free and I'd say is secure. Hosting that kind of service just for your will be time-consuming and not necessarily more secure than most of the stuff that is readily available out there. Good luck.
If you can live with managing the individual category amounts yourself, this is trivial. Just set up a spreadsheet listing each category (and a column for the total amount of money in the account), adding or subtracting as you deposit or withdraw money to the account. To the bank it will be just one (physical) account, but to you, it can be any number of (accounting asset) accounts. You can choose to keep a history, or not. It's all up to how complex you want to make it. It doesn't even have to be a spreadsheet - you can just as well do this on paper if you prefer that. But the computer makes it easier. I imagine most personal finance software will help you, too; I know GnuCash can be coaxed into doing this with only a bit of creativity, and it almost certainly isn't the only one. I do this myself and it works very well. I don't know but imagine that companies do it all the time: there is no reason why there must be a one-to-one relationship between bank accounts and accounting asset accounts, and in fact, doing so would probably quickly become impractical. Buxfer is a personal-finance web app which you might like.  It's not open-source.  But at least none of your complaints about financeworks.intuit.com apply to Buxfer. Buxfer offers a piece of software you can download to your own PC, called Firebux.  This macro-recording software provides automation that helps you download statements and upload them to Buxfer.  So you never have to give Buxfer any of your bank or brokerage usernames or passwords. Buxfer and Firebux are both free of charge. Wesabe, another personal-finance web app, also used to offer data-uploader software, but Wesabe has now gone out of business. A desktop application that has the same features (although as already stated, nothing will be identical but if you are looking for functionality then certainly there will be) and pretty simple to use was Microsoft Money, however, Microsoft stopped supporting it with newer versions and while the existing versions will work, I still use mine, there will be no future updates. I like the interface, its simple to use and has all the features you want. They abandoned it in favor of Intuit's Quicken but personally I am not a fan of the Quicken interface. They still had a more extensive and probably too much for the average user application called Office Accounting, but they abandoned future updates and supports on that in favor of Intuit's Quickbooks. Again, I am not a fan of the interface but they are very feature rich including invoicing and payroll, again overkill for the average user. They still have the Small Business Accounting in the form of Microsoft Dynamics, but that is utterly overkill for personal use. I generally don't trust online or cloud based accounting solutions like Mint or even Quicken online because I don't trust my information security to some third party without knowing how they are securing it and what will happen to me if/when they are leaked due to breach. So I like to keep everything local to myself and that's a good move for you, you should do that. It seems at the moment the market standard without much competition is Quicken for personal use and Quickbooks for small business. I would recommend you start with Quicken and if your needs increase in the future, you can easily transfer into Quickbooks to scale up as they are fully compatible with each other. Check it out here and compare their products to see what works best for your needs. Long time Quicken user, but I have Bootcamp on my Mac, and one reason is so I can run Quicken Windows. That's one solution. You didn't mention what version of the Mac OS you're running, but Bootcamp is one alternative if you have (or can purchase) a Windows license. Be advised, Bootcamp 4, which is available with OS 10.7 (Lion) and OS 10.8 (Mountain Lion), officially supports Windows 7 only. Quicken running under Bootcamp isn't perfect, but it's better than any Mac version, and Quicken 2013 has a mobile app that allows you to view your data & enter transactions via your mobile. The Mac Version of Quicken has been panned by users. I do use Windows for work-related stuff, so I have a reason for running Windows besides using Quicken. I've read that Intuit has a market share of more than 70% in the personal finance software sector, and at this point it seems pretty clear that they are not interested in pursuing a larger share via Mac users. So if we ever see a highly functional version of Quicken for the Mac OS, it won't be any time soon. I've not used other products, but there are many reviews out there which rank them, and some consistently come to the front. Top 10 Reviews Mac Personal Finance Software 2013; WeRockYourWeb Personal Finance Software Rankings includes many Web-based alternatives; Personally, I'm not real enthusiastic about posting my personal financial data on someone's Web site. I have nothing to hide, but I just can't get comfortable with cloud-based personal finance software providers that are combing through my data, Google-like, to generate revenue. Too, it seems an unnecessary risk giving a third party a list of all my account numbers, user names, and passwords. I know that information is out there, if one has the right sort of access, but to my way of thinking, using a cloud-based personal finance software application makes it more out there. I like to put money I am going to spend in my Quicken register (similar to Money in my limited experience) and that is the big ticket feature missing from mint.com.  Mint.com can only tell you what you did, or in a very general sense what you plan to do. As a register, mint.com is flexible enough for me to categorize my transactions.  As a planning / budgeting tool mint.com is very simple and fast to get going, but lacks the depth of a budget I want to manage every week.  Mint.com also tracks my investments, but I freely admit my investment management is nothing more than putting money into the same accounts.  I bother with investment tracking other than looking to see it isn't zero. I say try mint.com.  Mint.com has a place to totally delete your account. Do you have a broker? Any online brokerage (TD Ameritrade, E*Trade, Scott Trade, etc) offer the functionality that you want. If you're not interested in opening a brokerage account, you can search for threads here related to stock market simulation, since most of those services also provide the features that you want.  If you do you have a physical broker at some firm, contact him/her and ask about the online tools that the brokerage offers. Almost all of them have portfolio management tools available to clients. Billshrink offers some pretty neat analysis tools to help you pick a credit card. They focus more on rewards than the features you mention but it might be worth a look. If you use Mint, they offer a similar service, too. If you're not already using Mint, though, I'd look at Billshrink as Mint requires some extensive setup. MOD EDIT  Looks like billshrink.com is shut down.  From their site: Dear BillShrink customer, As you may have heard, BillShrink.com was shut down on July 31, 2013.   While we’re sad to say goodbye, we hope we’ve been able to help you be   better informed and save some money along the way! The good news is   that much of the innovative award-winning BillShrink technology will   still be available via our StatementRewards platform (made available   to customers by our partnering financial institutions). Moreover, we   expect to re-launch a new money-saving service in the future. To see   more of what we’re up to, visit Truaxis.com. We have deleted your personal information as of July 31. We will   retain your email address only to announce a preview of the new tool.   If you do not want us to retain your email address, you can opt out in   the form below. This opt out feature will be available until September   31, 2013. If you have already opted out previously, you do not need to   opt out again. If you have any further questions, contact us at   info@billshrink.com. Thanks, The BillShrink/Truaxis Team I like using Mint.com to track my expenses.  It makes it very easy to watch my budget and monitor my spending.