I figured out why the #GnuCash dates were wonky. #Claude assumed that the dates should be stored as ISO timestamps, which they were in old versions of GC, instead of text. So instead of complaining, GC just interpreted the integer dates as text. Easy fix in the script.

This is yet another hassle I've had trying to use A.I. It often offers solutions using outdated or deprecated methods. It should either assume I'm using the latest apps, or at least ask what version before it generates code.

I asked Claude to convert #Banktivity to #GnuCash by exporting directly from SQLite database to database. It thought a long time and produced a script that came pretty darn close with some glaring weirdness. Transaction dates in the GnuCash database look fine, but they're displayed months different. Also, the GC database is much smaller so I'm wondering what's missing. This at least looks promising.
I’m trying to move away from #Banktivity. #GnuCash was a disaster. I heard about #Beancount but I was skeptical; how could a flat text file have any performance? But I was willing to concede they knew something I didn’t. I fought like hell to import my QIF export and although there were problems, enough worked for me to try it out. It is stunningly … slooow … as expected. It takes 8(!) seconds on an M4 Mac mini to open a single transaction! I deleted the whole awful mess. Still searching.

I found another serious #GnuCash QIF importer bug. It properly imported a transaction with multiple lines in the split. BUT, it took one item from the split and replicated it 4 transactions further down as it's own split transaction. How do you even write code that does crapola like that?!

There is no way I can import a large 407,000 line QIF file with GnuCash this badly borked. I bet even Quicken 😱 would work better.

Now I know why some people just manage their finances with a spreadsheet.

I'm trying to import a QIF file exported from #Banktivity into #GnuCash and it does import, but the account balances are wildly wrong. One nasty bug in GC's importer is that if a split transaction has two items and one of them doesn't have a category, GC uses the category from one item and the amount from the other as a single non-split entry. It just throws away the categorized amount. I 💩 you not!

HTF does this get by testing? What other horrors await as I try to resolve this mess?

⚠️ WARNING: #Steam makes you pay twice for the same DLC!

While we wait for the #Metro2039 announcement on April 16th, Steam runs a #DLC sale for #MetroExodus. It includes The Two Colonels and Sam's Story, for which i've already paid. Steam DID NOT mark it as a "Library" item! 🤬 (edit: i've just got a refund)

I've only discovered this, because #GNUcash auto-completes descriptions of new entries in my household book. 👍

#Gaming

Der Micromanager in meinem Hirn schreit schon wieder, unter welche Kategorie er das Essen, dass ich während der Reise zu mir genommen habe, in #GnuCash verbuchen soll, Ausgehen oder Urlaub.

Ich mache seit ich angefangen habe zu studieren privat Buchhaltung mit doppelter Buchführung. Anfangs um zu verstehen, was das ist und wie es geht, inzwischen auch um die jährliche Steuererklärung zu unterstützen.

Das Programm, das ich dafür nutze (#Gnucash) stellt dabei auch für Aufwendungs- und Ertragskonten das Saldo über den gesamten Zeitraum dar. Das ist zwar praktisch völlig irrelevant, aber es ist echt verrückt, wie viel Geld man über die Zeit verdient und wieder ausgibt! 🫣

#Finanzen

Finally found time to update the bank statement converter for #gnucash

Now it also supports #BBVA bank from Spain. Also a bug with #ANWB #VISA card has been solved. Happy.

https://github.com/JensTec/NL-Bankstatement-converter

GitHub - JensTec/NL-Bankstatement-converter: Simple converter written in Python to convert .csv, .xlsx and .pdf bank account statements to a .csv file which easily imports into GnuCash

Simple converter written in Python to convert .csv, .xlsx and .pdf bank account statements to a .csv file which easily imports into GnuCash - JensTec/NL-Bankstatement-converter

GitHub