I would suggest the following:|------------+-----------------------------------------------------+---+----------|| 01/03/2022 | Example Rent Expense | | -1061.67 || 01/04/2022 | Example Food Expense | | -1061.67 ||------------+-----------------------------------------------------+---+----------|| | January expenses | 0 | -2123.34 ||------------+-----------------------------------------------------+---+----------|| 02/05/2022 | Example Utility Expense | | -2061.67 || 02/06/2022 | Example Random Expense | | -2061.67 ||------------+-----------------------------------------------------+---+----------|| | February expenses | 0 | -4123.34 ||------------+-----------------------------------------------------+---+----------|#+TBLFM: @3$3=vsum(@-I..@-II)::@3$4=vsum(@-I..@-II)::@6$3=vsum(@-I..@-II)::@6$4=vsum(@-I..@-II)
In that case, would a running csv where you paste in each month's newpull work? You could even keep the totals to the side, so that as youpaste new data in e.g. cols A-D, your totals (in E and beyond) can sitright there happily? I alluded to this with respect to the request toautomate csv -> org; without knowing which things must be org and why,it's hard to comment on these kinds of inquiries. Maybe org is justmore fun, maybe it's mandatory because there's some other aspect ofthis we don't know.How would you able to keep the running totals in Column E?Can you provide me with an example of this?On Sun, Jan 16, 2022, at 10:15 AM, Samuel Banya wrote:Hello,I appreciate the enthusiasm for Ledger, but I really just don't like the double posting idea period.I just need totals spreadsheet style, that's about it. I think the whole idea behind bean count is tedious.I just don't think like a mathematician in this respect, too brainy for me.I'll take a look at the Org Mode way to solve this problem via the previous posts, thanks.Sincerely,SamOn Fri, Jan 14, 2022, at 2:54 PM, Quiliro Ordóñez wrote:El 2022-01-09 22:42, Samuel Banya escribió:> Ah, Ledger is way too complicated for what it's worth. I've seen> videos on YouTube about it, and every person who's praised it is> pretty much too smart enough to be able to explain it in simple terms.It is very easy. I made a video for EmacsConf 2019https://emacsconf.org/2019/talks/12/ . I wish someone had showed meexamples like these when I started with it.My fiancee is a preschool teacher (programming is not her area ofexpertize). But she quickly learned how to use it. She keeps about3700 per year with 4500 lines. It takes her about 10 minutes per day.With that investment, she can even tell how much we have spent on applesor on all fruits (as detailed or general as she wants). On these twoyears, she has saved us about half our budget and has us living muchbetter thanks to the knowledge of what we want to invest on. (We now donot think of how to spend money, but how to invest it. That changes thepoint view completely.)There are complicated reports as well as very simple ones that can begenerated. And you can always customize them to the last bit. There isalso a website http://plaintextaccounting.org . There is plenty ofinformation there. You can also use org-babel to include formulas forLedger reports.Just ask away! :-)