From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id 2DzeAlC73GG5ywAAgWs5BA (envelope-from ) for ; Tue, 11 Jan 2022 00:03:44 +0100 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id SIr8Ok+73GFavgAAauVa8A (envelope-from ) for ; Tue, 11 Jan 2022 00:03:43 +0100 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 7DB302F05A for ; Tue, 11 Jan 2022 00:03:43 +0100 (CET) Received: from localhost ([::1]:39356 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1n73hW-0004fQ-0y for larch@yhetil.org; Mon, 10 Jan 2022 18:03:42 -0500 Received: from eggs.gnu.org ([209.51.188.92]:33734) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1n73PF-0000Ph-Hi for emacs-orgmode@gnu.org; Mon, 10 Jan 2022 17:44:49 -0500 Received: from [2a00:1450:4864:20::135] (port=42591 helo=mail-lf1-x135.google.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1n73PC-0001yt-C0 for emacs-orgmode@gnu.org; Mon, 10 Jan 2022 17:44:49 -0500 Received: by mail-lf1-x135.google.com with SMTP id h2so49768354lfv.9 for ; Mon, 10 Jan 2022 14:44:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=fUaJH2qP8Zm2RTvMdV+iC4n6/TgPhvYPjZOPb2+chSc=; b=QT8cxzwPDMP6pqKFoxpi76c3/vM+fkPeSc6ZM03ufXdlsZw+VQldapGDEsdWAB2s2b p4XcBPnmczZ36RPrJNP99ZSMQWupjWV3jtp0uXV9WeobOYywEz/N0POqRV3pf8fMkUla nG/CTDlWfyojKjrVhxn5aj2rEaJztRxwsFVUiUjVHCJsm/cfv5mzScbKLSR1qsFUa5LX qcFeguqCBdzlciGVWPhr+8MxtvEWhrTmVJ5A+48ZiQyZbhJ4Vv9udItHve++VpMaWELg sGAYpvmznUJXytu7oZUCLYttIcG8VKbJ4lC7s1KerSyGbo702zXd4H3M9EIWsISP68KX fJBQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=fUaJH2qP8Zm2RTvMdV+iC4n6/TgPhvYPjZOPb2+chSc=; b=Abd38Ll2Sp3sU/yrzMhoXyMIJkG0k4GWSNECB+e7wjqRqjOV2azHulUQ7cOlGy5RZe vFDPOCRBJSHoJkngbbkEoz/egjv+yZuo1sy4cmggm42W+lUeXWaNe7OqKJIHIcD+W0PI Zy96GahMvN7j6kAylDXD0nEPovbfZOGk/LNIYVwZBuH6o1pHcAuewE67Dh4CuUN4eV06 loLS3m3dHV6W+/OxeojdNdzHGoxE1Q6AvMOOwruHnOPgexFtYz2hiBXps9Am3k3R3S8B buYbL7pYAe5D8VKX5fu+LBomseCiemKKtMbFa/L+vU4omS2ugAV0GlkFM7fu5ZD4iVVt vA6A== X-Gm-Message-State: AOAM5333X5nZJh43kko4MmiQnoDBb/qO/lpVm+3f/E0PdGQHez19BV+F EZ6fHuKDw7YH7+zAMpK43zqMW+LdAFkbtkgkqy8= X-Google-Smtp-Source: ABdhPJzBtovoo8YBbVRlbRZYFJoOPpKfVhbFW0CxAcDRpDiE3Vn6QyQ/AHJPTH11VBOusLJApFkLeNBzF/VVGc8ogoU= X-Received: by 2002:a19:5515:: with SMTP id n21mr1371850lfe.70.1641854683126; Mon, 10 Jan 2022 14:44:43 -0800 (PST) MIME-Version: 1.0 Received: by 2002:ab3:7511:0:0:0:0:0 with HTTP; Mon, 10 Jan 2022 14:44:41 -0800 (PST) In-Reply-To: <87v8yrxvi5.fsf@mbork.pl> References: <137562d1-e6fe-4a68-b18b-abedef513fbd@www.fastmail.com> <87zgo4xea3.fsf@mbork.pl> <2352934.1641828705@apollo2.minshall.org> <87v8yrxvi5.fsf@mbork.pl> From: Samuel Wales Date: Mon, 10 Jan 2022 15:44:41 -0700 Message-ID: Subject: Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet To: Marcin Borkowski Content-Type: text/plain; charset="UTF-8" X-Host-Lookup-Failed: Reverse DNS lookup failed for 2a00:1450:4864:20::135 (failed) Received-SPF: pass client-ip=2a00:1450:4864:20::135; envelope-from=samologist@gmail.com; helo=mail-lf1-x135.google.com X-Spam_score_int: -12 X-Spam_score: -1.3 X-Spam_bar: - X-Spam_report: (-1.3 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RDNS_NONE=0.793, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=no autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: Greg Minshall , Neil Jerram , Charles Berry , Samuel Banya Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN X-Migadu-Country: US ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1641855823; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=fUaJH2qP8Zm2RTvMdV+iC4n6/TgPhvYPjZOPb2+chSc=; b=fS3hyrvTdO7jQs3+XdajUgsSXYtkc/zfGuY8SNFys6mEjab7f1peXInJnEB5UMTWmILoM6 KEp+6zLudMVARY7nAH/7fP33a1qFqCwTXWzw3pBEmy9/Rev62YwZpJkwXQGXg6o+xqFn3+ J5tZWh6S9gWnKO6EalgLMi/UDeIffd/ki+iZioEHS/aMsBBzoVcbnX/30ZOpgnq3c68/yF WNVp0jO1QKpuXKp7dSc3JZgOY3l/1mDnEvXaMSGgAgO/WMjRYLjPJnmsTWA03I3tt5XZX2 5tiyEAgzRRoidL3/Jt3i7U88SrUOI5wHFx+lXyFRxwStSisoKy6IbOvllP4t9Q== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1641855823; a=rsa-sha256; cv=none; b=Nsuw+Lwjny3K5+GzpiiX8CIS4z8QI//yCD7nMqHr7d441anvwJt57kc6Qyh/v9GO+Vak7G JhZmP+zDt2OhRIbw0n4E7uGlqHm+6yg5cxU/b2os3atDqmqs42pbtKwi63GnGofWUnGgAY fcbzdClCc0fVpLNrdT9W8DthvK2waYr7Sh3SqwW4DbyQDStG6IGEMu4/ct1jeUN7zMZ+Ys zP7llPWx2CZtrW4vLPtgkT0ubqc9uDw6BLkmQjSUfsbSMHGYP5wlr18X7/vOuggUqeR4LH UydfYrQ5B6lIPI8LGoQ1B03vVzcjxvkyNy0qjTtfd5rmUv317pKJ4vmVmDLx7Q== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20210112 header.b=QT8cxzwP; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none); spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Spam-Score: -2.01 Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20210112 header.b=QT8cxzwP; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none); spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Queue-Id: 7DB302F05A X-Spam-Score: -2.01 X-Migadu-Scanner: scn0.migadu.com X-TUID: ad+lgKPhJkmc fwiw, my experience: double entry is what i found ledger useful for. iiuc it is that transactions go from one place to another, which felt intuitive to me. anything else, such as taking monthly averages, didn't end up as i expected. weird concept of average to me, and v3 bugs with floating point etc. i could never get them to be pretty. so the example you give of ledger's rough edge is actually the one non-rough-edge i found in ledger. in org, i hae a shell babel block ad an exampale or ledge block for data. i find it strange that agenda searching doesn't find stuff in the ledger data block, and would want org dates if poss. i did not try to use ledger properly with its emacs mode. On 1/10/22, Marcin Borkowski wrote: > > On 2022-01-10, at 18:01, Samuel Banya wrote: > >> The 'double reporting' idea might have been why I just flat out shook my >> head when I saw the one presentation on 'ledger' in Emacs on YouTube a >> while ago as its a bit too complicated and unnecessary for a layman. >> >> I just don't need that kind of over-thinking when it comes to my finances >> since I just need a spreadsheet that listed expenses, and to count totals. >> That's about it. > > You may think it's overthinking... unless you encounter one of the many > /real-world problems/ the double-accounting system was /designed/ to > solve. > > A classic example is when you buy something on day X (expense) but pay > for it on day Y (cash outflow), and you want to be able to record both > dates. > > Or you have some irregular costs (like paying for a car insurance once > a year) and you want to spread them more evenly over a longer period, so > that your /cash outflow/ is recorded once a year, but the associated > /cost/ is recorded every month. (This may help tremendously with > budgeting.) > > Or you decide to transfer money between two bank accounts (both yours), > but money going from account A arrives at account B after one day (or > even later). > > Or you buy something for someone and he pays you back a few days (or > weeks, or months) later, or not at all (which may happen). > > > As you might notice, the first two examples are situations when the > /expense/ and /cash outflow/ are detached in time - something > /extremely/ common in business, but also pretty common in personal > finance. You might say that you don't care - and I understand that - > but it is actually very useful to track /both/ expenses (so that you > know your cost of living etc.) and cash in- and outflows (so that you > can reconcile your ledger with your cash/bank account etc., to ensure > you didn't make any mistake). (If you - like most people, I assume - > barely have liquidity, tracking cash flows may become even more > important.) Also, the difference in time between income/expenses and > cash flow may become /extremely/ important when calculating taxes. > > The third example is also connected with things happening at different > moments in time, though to be fair, if you're only interested in actual > /expenses/, you probably wouldn't even want to record that. > > The last example is similar to the third one - it's not an /expense/ per > se, but again - tracking cash is useful, tracking your assets and > liabilities (in that case, money you owe to other people and money other > people owe to you) is /extremely/ useful, even just as an individual, > and if that guy /doesn't/ pay you back (mind you, this may happen for > /legitimate/ issues, like death), it can actually /become/ an expense. > > Also, using accounting software makes things like calculating your net > worth trivial. And there are other issues which can quickly become > pretty hairy when you try to wrap you head around them with a simple > spreadsheet (like dealing with various currencies/stock/commodities with > varying prices, for instance), but which have standard, well-known > solutions in the world of accounting. > > > Actually, I'd argue that learning the basics of accounting could help > a /layman/ better manage their finances. While the technicalities of > bookkeeping are not relevant to that, the general ideas like cash flow, > income and expenses, balance sheet, assets and liabilities, liquidity, > compound interest etc. provide a very useful way of thinking about > money. Two examples. A friend of mine (an economist) was asked to > conduct a 45-minute class for high-schoolers about economics (and > finance, I guess). He decided that if these kids are to have any use of > that class, he should gice them a few sentences - "anchors", I'd call > them - which could be some kind of guidelines to use when navigating the > world of economy (on a scale of a country as well as of a household) and > finance. One of these sentences was: "If I don't have enough cash to > buy , it means I cannot afford it." It's as simple as that - but > it goes very much against the message you get from (among others) the > banking system. (And yes, there are "exceptions". But you can learn > about those later.) The second example is actually my pet peeve - some > people buy things and call them "investments", probably to (possibly > unconsciously) justify these expenses. Usually these expenses have > /nothing/ to do with investments. Buying a car is /not/ an investment > unless you use it to earn money. Buying a better tv is /not/ an > investment. Buying a house /can/ be an investment if it allows you to > save on rent. Simply put: an "investment" is an expense you make that > will enable you to generate income (or at least cut costs) in the future > (with reasonable certainty or at least reasonable probability - buying > a lottery ticket is /not/ an investment). > > > Anyway, if any of the above sounds like it might be useful for you, I'd > strongly suggest learning the basics of double accounting. It's neither > very hard nor boring! > > Best, > mb > > > >> >> I will take a look at the other suggestions with specific Org Mode >> formulas, looked awesome, thanks. >> >> On Mon, Jan 10, 2022, at 10:31 AM, Greg Minshall wrote: >>> > I'm wondering if your opinion about Ledger isn't influenced by the >>> > fact >>> > that it uses basic accounting principles, like the idea of >>> > double-entry >>> > accounting. For me, it's /very/ simple and intuitive, but I graduated >>> > in economics many years ago and had a (basic, but still) course on >>> > accounting. If that is your problem, I'd suggest spending some time >>> > on >>> > understanding that - even if you don't end up using Ledger but some >>> > other software, you might find learning about accounting useful. >>> > (Also, >>> > it's fascinating. No, really! It's an extremely clever abstract >>> > system with a real-life use-case.) >>> >>> i agree that learning the principles of double-entry is worthwhile, >>> actually interesting, and of a very interesting history! >>> > > > -- > Marcin Borkowski > http://mbork.pl > > -- The Kafka Pandemic A blog about science, health, human rights, and misopathy: https://thekafkapandemic.blogspot.com