Re:GnuCash: Open-source double-entry accounting software
by orthecreedence on Friday June 07, 2019 @10:25AM
(#20124808)
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.
Re:GnuCash: Open-source double-entry accounting software
by contradictioned on Friday June 07, 2019 @02:18AM
(#20122088)
This is why I always (sloppily) say, Excel is the scripting language of databases.
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.