From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp10.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id yLOcIvss6GFpIQEAgWs5BA (envelope-from ) for ; Wed, 19 Jan 2022 16:23:39 +0100 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp10.migadu.com with LMTPS id OO23GPss6GFoRwAAG6o9tA (envelope-from ) for ; Wed, 19 Jan 2022 16:23:39 +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 05DEC41A83 for ; Wed, 19 Jan 2022 16:23:39 +0100 (CET) Received: from localhost ([::1]:34864 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nACoE-0007pT-5J for larch@yhetil.org; Wed, 19 Jan 2022 10:23:38 -0500 Received: from eggs.gnu.org ([209.51.188.92]:60656) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nACTl-0006OB-VI for emacs-orgmode@gnu.org; Wed, 19 Jan 2022 10:02:32 -0500 Received: from [2a00:1450:4864:20::535] (port=41513 helo=mail-ed1-x535.google.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1nACTV-0006a3-9O for emacs-orgmode@gnu.org; Wed, 19 Jan 2022 10:02:29 -0500 Received: by mail-ed1-x535.google.com with SMTP id j2so13355882edj.8 for ; Wed, 19 Jan 2022 07:02:09 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=O5fV/I4C3QuOeHRwtoEieLbF9EB1bYhY3/x3QYs9vuI=; b=WQddwuRmPUjdMr0+oGi3Is0KkpXyM8TZUm2qz8QS2M+Yu5uOypmAqw81kyDFXCOCLk gnAyRq/C4yoO6qi4yx6g56QOUO5lZ7meUBWK8FF/xSABDH3X032ThpHE0KsrU8Dxv1dd o3e8syTfoGxCtf1K1Draqb4FJW4ueJOcwwmoaBtIdBR24SqitQTzywcZhYsCGUPHrZGG CIDYHiw6y3Pg+cg+L7JNXVnjmJvluhshVPy5tyrYV6huSVHluP5Wt78oBcfN7mzhYUro /xgYkQXuhxgcDgFevE7ctyR3wgvzMpbOchyeDz5H7l9kGiII+U8VK2+K1MA6g0LAc94U 6aUw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=O5fV/I4C3QuOeHRwtoEieLbF9EB1bYhY3/x3QYs9vuI=; b=KecDpR2web+jcerifVACApHbIESj7dU/4h1/V2rEOHon1BHceksKzbTYlybjJvLU97 4ldPLgocUUN7ugMuMY85gbOryQ9fzf6NIR/Fnb1fOLdmYOpmUMZpSV2lGb/StZXXNWHW xjo9d8knFp2TFe/tvqIh+p++xVGOFZjUZ5QRSyNRmd3s/H62R4IhXufziwCdSYEX+3xp AUW3uxwO3b5arTrtIAargFIT8E8qdGGWj9NidW9xuvuXDGmkv15Vj6zKrsu9TPiAk6bh YMGejLgaLH+DH8Mk0K1APKdb7uB6J2XHBKU9wRN8zcpHO5W7EGs3wr1tk4vrXQWQNS1i INEA== X-Gm-Message-State: AOAM533yqhDPfDAeUFSTgC/3j01gNYZviHrfcHK/Oe+PmcWURmrKqwFi 8Ptz4wGcEcmPXhIwolPNtirBoRMYDLM9TK9Hu8g= X-Google-Smtp-Source: ABdhPJxRyTezUUKN8myQVMK4o+9XHEnBna8/McqHnPcqCLZ6/4Kb8mhWA/II+4NCfSQf07TWE0OiT3HS+GdwmQ8i3nw= X-Received: by 2002:a17:907:7eaa:: with SMTP id qb42mr4244199ejc.135.1642604528555; Wed, 19 Jan 2022 07:02:08 -0800 (PST) MIME-Version: 1.0 References: <137562d1-e6fe-4a68-b18b-abedef513fbd@www.fastmail.com> In-Reply-To: From: Neil Jerram Date: Wed, 19 Jan 2022 15:01:57 +0000 Message-ID: Subject: Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet To: Samuel Banya Content-Type: text/plain; charset="UTF-8" X-Host-Lookup-Failed: Reverse DNS lookup failed for 2a00:1450:4864:20::535 (failed) Received-SPF: pass client-ip=2a00:1450:4864:20::535; envelope-from=neiljerram@gmail.com; helo=mail-ed1-x535.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, PDS_HP_HELO_NORDNS=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: Charles Berry 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=1642605819; 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=O5fV/I4C3QuOeHRwtoEieLbF9EB1bYhY3/x3QYs9vuI=; b=A2NXYwUn4Jemv52qfudUYSMirHSH4KZXHyzD6T1SOex8mOcr/L+lk7C3Hu3CgcnBTAhQe9 iPRaSRojvzFwkrVmyZwjHp3IJlzIxFCkoyvJm7ShPTJzYIjrS/bkixq1tnwJndat4Jxl17 TBqMWKRCHuiqRV/Kgu1UWCSpg/6te57203l3cz3uBgircS8GPB5YIUYApTmq7kWMecqbCf lfnbnDTChWCQqKcJeQHtqNs1LPOextUXYV/esB1GtIAl15hLzV4CQD4KX8UToVXLmeHGbE l/tF/NtGXYtj2Lk8CDndyBIQDsH0Lj4uAYxGQf1JDpkma3oc2C/gr/U7nC+fmw== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1642605819; a=rsa-sha256; cv=none; b=TRUZu9L2LA9+SlOx+YJOevY7+wDu8qWQCo1lHFOLeYw+w5aOG79/YyCtFRULN1gnOeB3pm ke3BlzmsZLMUzNEFVnqzsoej1D2L6b7x4dzTzt4zF5j3drpYchSa6tGHOu/oq7K16Rdez0 WGajiTIGzoB+yaSzBwNgpyYSEaVGcrFwHOlOdQT0VuBdZVsH9GoUUNtkjABYi14r2xJxUe Q5cDRyDOQJiFaGyeZVvQaZ3/N1WkrsgR47zGAJZDUuJKkzepoA2s6rej4wz+6VvvYgz/4N 69q29nZnfg+9iaUvQU49IbpZvbO6/vE8zavf7m6P5cBD286Uam7ksdZQtPs2pA== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=WQddwuRm; dmarc=pass (policy=none) header.from=gmail.com; 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: -7.82 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=WQddwuRm; dmarc=pass (policy=none) header.from=gmail.com; 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: 05DEC41A83 X-Spam-Score: -7.82 X-Migadu-Scanner: scn0.migadu.com X-TUID: dTJk/IuryJWP On Mon, 10 Jan 2022 at 10:31, Neil Jerram wrote: > > On Mon, 10 Jan 2022 at 03:42, Samuel Banya wrote: > > > > 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. > > I have similar observations. I don't (so far) see that Ledger (or > alternatives) offers enough added value to be worth incorporating in > my workflow, compared to directly processing the raw data. > > The value that would be of interest to me is: > - Classifying/grouping transactions at analysis time (not entry time) > according to a set of rules/regexps etc. > - Drawing insights by analysing past expenditure, with that kind of > classification. > - Using such insights as part of future budgeting. > - An overall functional approach, where the raw data is never changed, > and the other inputs to an analysis can be tweaked on each run. > > I wish plaintextaccounting.org had a forum/ML for discussing this kind > of thing, as it isn't specific to any of ledger/hledger/beancount in > particular. I have been reading the Ledger manual, and wanted to follow up because it turns out Ledger (with ledger-autosync) actually *can* do the workflows that I'm interested in (above). - ledger-autosync can read my OFX files and output Ledger transactions with Expenses:Unknown everywhere. - Ledger supports account definitions with regexps, that mean "if you see a transaction with *Unknown, and the description matches this regexp, treat the *Unknown as actually this account". - Then I can execute whatever reporting I need. So, although it's not Ledger's primary use case, it seems Ledger can operate "functionally" with the OFX files as the raw data and account definitions saying how to categorize those, and considering the generated Ledger journal to be ephemeral. Assuming I don't run into gotchas, I reckon that makes me a Ledger convert, and I can discard all my own code. Best wishes, Neil