After doing accounting for my business, a medium-sized non-profit, and our personal finances, I keep coming back to Microsoft Excel. Using someone else's accounting software feels like trying to do an Iron Man with a straight jacket. At least with Excel, you can code VBA/C#/formulas/etc. to your heart's content and make it do exactly what you want. That's what I love about it.
Want to import bank data? Well, you DO have to export the CSV manually from the bank, but then you can code something to make your financial reporting do exactly what you want.
Need graphs or reporting? MS Excel, well, excels at that.
Want to munge the data in a special way? Easy to do with formulas, coding, excel builts-ins, or some combination thereof.
Want to pre-process data before you suck it into a finances program? Write an external munger that exports to a .txt file, and then link an Excel Data Range to that .txt file.
I wonder sometimes if I have blinders on for choosing Excel, but hey, it works. And since I like coding, it actually makes doing finances kinda fun.
You're brave. I struggled with Excel for a year before giving up and moving to Ledger/SQLite, which was a night and day difference (and I had an easier time scripting).
If I was going to use Excel, I'd store the transactions in a real database and export to Excel for reporting.
Want to import bank data? Well, you DO have to export the CSV manually from the bank, but then you can code something to make your financial reporting do exactly what you want.
Need graphs or reporting? MS Excel, well, excels at that.
Want to munge the data in a special way? Easy to do with formulas, coding, excel builts-ins, or some combination thereof.
Want to pre-process data before you suck it into a finances program? Write an external munger that exports to a .txt file, and then link an Excel Data Range to that .txt file.
I wonder sometimes if I have blinders on for choosing Excel, but hey, it works. And since I like coding, it actually makes doing finances kinda fun.