I build my transaction list in Excel and then export that to .beancount with a very simple script. You could do the same with sql except even easier. That give

I build my transaction list in Excel and then export that to .beancount with a very simple script. You could do the same with sql except even easier. That gives me the benefits of Fava and all the other PTA tools as well.