News for hackers. Stuff that matters.

Show HN: Aggregate Finance, your financial data in a spreadsheet you own

https://app.aggregatefi.com/

I started building Aggregate Finance a couple of years ago because I was manually updating a Google Sheet to track my credit card statements, monthly recurring transactions, and spending habits. This seemed perfect for automation as I was having to log in to six separate banking apps to pull this information together.

My original intention was to use this tool locally, but I figured it would be an excellent learning opportunity to understand how to scale the application for others to use. The core functionality of Aggregate Finance revolves around syncing banks and brokerages through Plaid to create visuals and data analytics in Google Sheets and OneDrive/Excel, but I've also added Stripe for payments, passkey and TOTP support for MFA (wanted to better learn how WebAuthn works, mostly), and Resend for emailing account updates.

The first question you're likely thinking is: isn't this just reinventing the wheel? There's plenty of other personal finance/budgeting apps out there like Rocket Money, Monarch, Copilot Money, YNAB, Tiller, Credit Karma, etc. I personally tried Rocket Money but it left a bad taste in my mouth how my entire financial history was stored on their servers without having direct ownership of the data. Another pain point with these personal finance apps is you're locked into their subscription and lose access to your financial data if you cancel.

That's why I opted for the Google Sheet and OneDrive/Excel approach since this persists financial data over time and provides direct data ownership. There's a fair argument that these options still share your financial data with Google or Microsoft, so I built a way to download your financial data locally via CSV/Excel/LibreOffice exports.

In terms of data encryption, Aggregate Finance encrypts financial data before it reaches MongoDB: balances, transactions, merchants, statements, holdings, and any user customizations. Each user gets their own AES-256 key rather than a shared key. The reason I went with this approach is for data deletion: when someone deletes their account, their encryption key is deleted as well, so any financial data stored in prior database backups can't be decrypted.

I've been using Aggregate Finance with my own live bank accounts and investment holdings, and it's already been helpful. I can see when my credit card statements are due, monitor my entire investment portfolio, keep track of recurring charges, create budgets, and see how my spending pans out over a given month or over the past year. I'm curious whether it's useful for anyone else, and I'd of course welcome any feedback on how I can improve it. You can try it with a free sample spreadsheet that contains a year of example data with no bank connection required at https://app.aggregatefi.com.

( 6 comments | on HN )
Re:Show HN: Aggregate Finance, your financial data in a spre... by dieselgate on Wednesday November 04, 2026 @05:57PM (#50372633)
Thanks for sharing, looks polished on mobile. Is it “agent-ready” in any capacity?
Re:Show HN: Aggregate Finance, your financial data in a spre... by mitchthebaker on Wednesday November 04, 2026 @10:09PM (#50374668)
I haven't explored any AI or agent-specific features yet but that's a good flag, thanks. Based on some initial research, it's possible to create a read-only MCP server using OAuth to sign in to Aggregate Finance securely from Claude, ChatGPT, or any other MCP client. The client would then get a short-lived token scoped to your financial data. In the meantime, you could import the Google Sheet and/or CSV/Excel downloads into an LLM and work with the data that way.
Re:Show HN: Aggregate Finance, your financial data in a spre... by Charlotte_P on Thursday November 05, 2026 @04:14AM (#50376968)
having all your financial data in a personal spreadsheet sounds pretty useful. Most finance apps in the market use dashboards and subscription model, so being able to export everything is a nice feature. Curious how well the bank sync works if you are extracting data from multiple accounts.
Re:Show HN: Aggregate Finance, your financial data in a spre... by mitchthebaker on Wednesday November 11, 2026 @02:10AM (#50450533)
Thanks. I currently have six banks/brokerages connected for tracking my personal finances and haven't noticed any major inconsistencies. There's a daily job that runs to sync latest transactions from banks and you can sync manually anytime as well.
Re:Show HN: Aggregate Finance, your financial data in a spre... by imbaggaarm on Monday November 09, 2026 @09:51AM (#50426452)
> Another pain point with these personal finance apps is you're locked into their subscription and lose access to your financial data if you cancel.

Hmmm, i don't think so though, most of the app allow you to export all data (it's actually a regulatory requirement to have this feature)

Re:Show HN: Aggregate Finance, your financial data in a spre... by mitchthebaker on Wednesday November 11, 2026 @02:03AM (#50450495)
Fair point. What I was trying to drive at is once you cancel their subscription, you lose access to any valuable visualizations and data breakdowns. Yes you can export your data but what are most people going to do next with a CSV file? That's where I wanted to differentiate with the Google Sheets/OneDrive approach, since you'd still possess ownership of your data and the charts/visuals we provide after cancelling our service.