You can "solve" this by throwing your PDF statements at llms and having them extract the transactions. Has privacy implications if you use hosted llms of course.

As for self hosted accounting/budgeting software, IMO Beancount is the best by far: nothing to host, just text files.