Re: How to filter journal queries by amount ?

Can you help me with an example please ? bean-query ~/beancount/personal.beancount "JOURNAL 'Expenses' FROM number > 800" didn't work for me. Greetings, Varac Excerpts from Martin Blais's message of Oktober 22, 2020 3:20 vormittags: > I think you want "number" > https://github.com/beancoun

Re: ofx max_date correct?

Ditto, banks don't seem to be fully consistent on these. FWIW, for my importers , I use the following dates via ofxparse : - date of last transaction, used for filing via bean-file: I use ofxpar

Re: How to filter journal queries by amount ?

FROM applies to a transaction, WHERE applies to postings. I may be mistaken, but WHERE cannot be used with JOURNAL for this reason, in my understanding. This might possibly be what you want: SELECT date,description,account,position,balance WHERE account ~ "^Expenses" AND number > 800 https://b

Re: How to filter journal queries by amount ?

Thanks, that did it ! Excerpts from Red S's message of Oktober 22, 2020 10:10 vormittags: > FROM applies to a transaction, WHERE applies to postings. I may be > mistaken, but WHERE cannot be used with JOURNAL for this reason, in my > understanding. > > This might possibly be what you want: > SELEC

Re: How to filter journal queries by amount ?

Both can be used, but FROM can be used only with transaction columns and WHERE can be used only with posting columns. On Thu, Oct 22, 2020, 04:11 Red S wrote: > FROM applies to a transaction, WHERE applies to postings. I may be > mistaken, but WHERE cannot be used with JOURNAL for this reason, i

Learning path for Emacs beancount mode

Dear all, I made numerous attempts to start learning Emacs beancount mode, but never progressed it, since my knowledge of Emacs is also 0. Question: can somebody advice learning path for absolute Emacs beginner to be able to use productively Emacs beancount mode? Regards. -- You received th

Re: Learning path for Emacs beancount mode

On Thu, 22 Oct 2020 at 15:07, Chary Chary wrote: > Dear all, > > I made numerous attempts to start learning Emacs beancount mode, but never > progressed it, since my knowledge of Emacs is also 0. > > Question: can somebody advice learning path for absolute Emacs beginner to > be able to use produ

Re: Learning path for Emacs beancount mode

Set a modest goal: to replace your current editor, no extra new functionality. 1. Make a list of all the functions / special keystrokes you use in your current editor 2. Take some time to find the Emacs equivalents and make up a cheatsheet (on paper, next to your keyboard). Get used to that for a w

Importing ADP payroll extracts to Beancount

Hi everyone, I tried posting this question on reddit but I'm rarely successful getting any responses. Anyone here has had any luck importing ADP info into Beancount? I am trying to get a breakdown of my corporate salary, and current firm uses A

Re: Learning path for Emacs beancount mode

If you're coming from vim, the evil-mode really helps. spacemacs is one option for that (emacs has crazy customization possibilities, it can be easier to start from a fixed base). This is diametrically opposed to starting from vanilla emacs, but for vim-familiar users its probably less jarring. O

Re: How to filter journal queries by amount ?

beancount> JOURNAL WHERE number > 5 ERROR: Syntax error near 'WHERE' (at 8) JOURNAL WHERE number > 5 ^ beancount> help journal Select a journal of some subset of postings. This command is a convenience and converts into an equivalent Select statement, designed to extract the most sensib

Re: How to filter journal queries by amount ?

Hit send too soon, sorry. Martin, I assume you meant WHERE can be used with SELECT. Varac was unable to use it with "JOURNAL" (see below), and I'd explained why. Doesn't make a huge difference, but I'd be interested in knowing if I'm missing anything. On Thursday, October 22, 2020 at 11:13:53 P

Re: Importing ADP payroll extracts to Beancount

Long ago, I had to download data from ADP. Now, it's a different provider. Both had/have the same problem: no obvious way to export data to csv/ofx or anything other than pdf. PDFs are a mess with automation. I use pdftotext, followed by a simple python parser/importer to get payroll data into