Predicted cashflow analysis to power low balance alert

I'm evaluating Beancount and like what I see so far. I have variance in my cashflow due to varying income (autosale of stock), and varying expenses (credit cards which autopay on a certain date). I can write a script which updates these predicted future transactions and include that file in my ma

Re: Making Beancount Mode Great (I mean, Minor) Again

You could fetch the older version of the beancount emacs plugin out of the git history and use it instead. For the non software engineer one way to do that is to browse to the file on github, and click "blame" (line by line history). You can see the comment about major mode was updated here

Re: Making Beancount Mode Great (I mean, Minor) Again

A2n7r8SE/m/Z0lAQxAKCQAJ TLDR: better completion support. On Sat, Jul 18, 2020 at 3:33 PM TRS-80 wrote: > > On 2020-07-18 18:00, Ben Blount wrote: > > > > You could fetch the older version of the beancount emacs plugin out of > > the git history and use it instead. For the no

Re: Making Beancount Mode Great (I mean, Minor) Again

f the tools I use. Thanks for the pointer about the merge requests on bitbucket. On Sat, Jul 18, 2020 at 4:12 PM Daniele Nicolodi wrote: > On 18/07/2020 16:52, Ben Blount wrote: > > Sometimes folks will put the reasoning behind a change in the commit > > message or pull request. Un

Re: Visidata

This looks like a great tool, thanks for sharing! I particularly like the ability to compute a new column via a python snippet. On Sat, Jul 25, 2020 at 8:51 AM Martin Blais wrote: > Hi, > I discovered a pretty awesome tool yesterday related to text files / > tables / text processing in the conso

Re: Retroactively apply changes made in Importeer

Are your renaming / reparenting scripts published anywhere? I currently use perl oneliners, but it can be tedious for certain kinds of refactorings. There's a beancount-aware renamer here that I haven't tried

Average cost booking

First off, thank you so much for such a great tool! One challenge I haven't been able to solve yet with beancount is tracking basis for my US 401k - average cost booking. I did quite a bit of digging into the code, TODOs, and the mailing list. I actually implemented average cost booking on augmen

Re: Average cost booking

epo. I saw some references to previous testcases written in a 'booking' branch. I don't see that branch anymore, perhaps it was on the old git provider. Do you know where these are / are they worth reusing? On Mon, Nov 16, 2020 at 6:48 PM Martin Blais wrote: > On Mon, Nov 16, 2020

Re: Average cost booking

>> On Tue, Nov 17, 2020 at 12:21 AM Ben Blount wrote: >> >>> Great, glad to hear Martin! >>> >>> I'll start with a doc similar to your docs that outlines the >>> implementation decisions to be made, offering options for each. Once we >>>

Re: Average cost booking

mments). > Totally fine starting with a constrained version. > The issue of reducing within a transaction is a thorny one, but I think > it'll be fine to just reduce against the inventory that comes before the > transaction. > Thank you, > > > On Tue, Nov 17, 2020 at

Re: How to track distributions?

When using Fava you can put a date filter in the box of the top middle. Valid values include: 2020 2020-11 2020-11-02 To get a view of how it changed during the time period, use the income statement view. On Mon, Dec 14, 2020, 1:05 AM Hao Wu wrote: > Hi list, > > I started using beancount + fava

Re: How to transfer lots between accounts and how to query lot information?

I saw a few different questions in there: - "I need to look up/query my lots, but I'm unable to do this. `bean-report FILE holdings` seemed appropriate, but the lot date is missing and the units are trimmed/rounded to two digits:" Beancount tries to infer the right precision for a particular curren

Re: Newbie: How to manage option trades?

You need to have negative units for commodities that give you a credit, and positive for those that you pay for. The only sensible way coming to mind is to decompose the combination into its underlying puts / calls. I'd make negative units = writing options (credit), positive = buying them (debit)

Re: InteractiveBrokers

Are these apis only available for IBKR Pro? On Wed, Dec 30, 2020, 00:12 Martin Blais wrote: > Thank you! > > And actually, for the record, the statement of funds from the custom > reports doesn't provide any trade data. > The statement of funds from the flex queries is the only one that outputs

Re: How to deal with the EUR/XRP tolerance in this case

Have you seen/read https://beancount.github.io/docs/precision_tolerances.html ? On Sat, Jan 2, 2021, 11:56 c79m...@gmail.com wrote: > Peter, > > I don't have any experience with the issues you're dealing with, but I > can't help but notice this line in your output: "Tolerances: XRP=0.0005" > Tha

Re: Can I make a balance assertion about market value? (I think not)

bean-query has functions to convert holdings to market value. You could use these to write a query and dump your holdings at market value. If you're ok with writing some python it would be fairly straightforward to script that together into the type of balance assertions you're looking for. Here'

Re: Custom script that iterates postings with `open on` and `close on` dates

Here are some examples showing modifying a journal based on a query: Delete entry | Rename account . It takes a fu

Re: Recommendation on beancount for Crypto transactions

Income accounts are negative. Your transaction should be 2020-11-26 * "Coinbase" "Sell BTC at Coinbase" Assets:US:Crypto:Coinbase:BTC -0.22712412 BTC {} @ 16539.50 USD Assets:US:Crypto:Coinbase:Cash 3756.53 USD Income:Crypto:Capital-gains -256.52 USD And yes, your next transaction should draw fr

Re: How to transfer lots between accounts and how to query lot information?

Beancount has two ways to track any kind of currency/commodity: at cost, or not at cost. Generally, currency like USD, EUR, etc are not tracked at cost. Stock, securities etc are tracked at cost so you can report capital gains. Beancounts infers what mode you are working in by the presence of a Cos

Re: How to transfer lots between accounts and how to query lot information?

2-17}, 0.01977443 BTC > {25285.17889011212965430609125 USD, 2020-12-26}, 0.01741186 BTC > {28716.05905400112337223019252 USD, 2020-12-30}, 0.01667888 BTC > {29978.03209807852805464155867 USD, 2021-01-01}, 0.01464422 BTC > {34143.16365091483192686261201 USD, 2021-01-03}) > > On M

Re: How to transfer lots between accounts and how to query lot information?

778508 BTC {18078.68014392563700916350683 USD}. Alternatively, Beancount does let you match using the date, assuming that is unambiguous. On Mon, Jan 18, 2021 at 9:52 PM Ben Blount wrote: > Please carefully review the error message. It has been telling you > precisely what is wrong each time

Re: How to transfer lots between accounts and how to query lot information?

;;; > 25285.18 USD, > Assets:US:Crypto:Coinbase:BTC -0.01741186 BTC {2020-12-30} > 28716.06 USD, > Assets:US:Crypto:Coinbase:BTC -0.01667888 BTC {2021-01-01} > 29978.03 USD, > Assets:US:Crypto:Coinbase:BTC -0.01464422 BTC {2021-01-03} >

Re: Tracking after-tax vs pre-tax 401k contributions

I recommend downloading ofx files from them instead. For some reason the ofx export misses some 401k accounts for me, so I use the Quicken qfx export, which beancount_import/sources/ofx can still understand. When you download them you'll end up with separate accounts for each possible source (after

Re: Frustration

> Importing is time consuming I use github.com/jbms/beancount-import and am quite happy with it for the import UI, transaction dedupe logic, transaction clearing, and ML-based categorization. Admittedly I've spent tens of hours programming importers and scrapers and possibly have not made any net t

Re: State of v3

Fava does work on v3 currently. I've been using v3 successfully on my personal ledger for a month or so but as Martin says not much of the new code is lit up. I depend on average cost booking so I will continue on v3 (merging PR #591 on my local copy). Martin I got reasonably familiar with the tho

Re: Newbie: How to manage option trades?

> > 1) Is there any downside of attaching so many currencies to a single > account? For beancount's core tools probably not. It may not work nicely with tooling like Fava's holdings report. 2) Is there a way to represent these transactions using the same currency > over and over (based on the c

Re: Where to write cache data on Windows?

Windows env var %LOCALAPPDATA% should always be set. On my windows machine that points exactly to what you are after: >>> os.getenv("LOCALAPPDATA") 'C:\\Users\\Ben\\AppData\\Local' Unfortunately I couldn't find any official documentation corroborating this but if Microsoft is very careful about ba

Re: Newbie: How to manage option trades?

Good point about the price directive. I agree with your recommendation. Seems like the best way to handle it is to fix any reporting tooling that have problems with the flood of commodity symbols to aggregate or page their output. On Sat, Feb 13, 2021, 14:03 Martin Blais wrote: > On Sat, Feb 13,

Re: Where to write cache data on Windows?

I can do that, please send me the commit to verify and the invocation for the unit tests you want to check. On Sat, Feb 13, 2021, 14:16 Daniele Nicolodi wrote: > On 13/02/2021 22:48, Ben Blount wrote: > > Windows env var %LOCALAPPDATA% should always be set. > > On my windows mach

Re: Newbie: How to manage option trades?

jbms/beancount-import is what I use for those. The workflow is somewhat different than the bean-extract style. On Sun, Feb 14, 2021, 07:46 Rahul Kuchhal wrote: > Thank you! > > I see that adding new commodities is the recommended way then. > > Now on to finding Vanguard and Schwab importers or a

Re: Where to write cache data on Windows?

dle the correct path delimiter. One of my biggest gripes with windows is that it uses \ for paths rather than /. On Sun, Feb 14, 2021 at 3:11 AM Daniele Nicolodi wrote: > On 13/02/2021 23:20, Ben Blount wrote: > > I can do that, please send me the commit to verify and the invocation >

Re: Where to write cache data on Windows?

Are you sure you commited tests/test_cache.py ? I'm not seeing it where it was supposed to be in your commands. On Sun, Feb 14, 2021 at 11:36 AM Daniele Nicolodi wrote: > On 14/02/2021 19:30, Ben Blount wrote: > > I didn't see any relevant unit tests > > in https://gith

Re: How to handle stocks/shares conversions due to company merging?

I'd probably just rename the history and call it a day. Or manually make a transaction that zeroes out the old holdings at cost, then manually recreates every lot with the new commodity name (but with the previous cost, date attached). v3 has a plan

Re: Frustration

Good to know, thanks Daniele! I have subsequently merged my ledger into one file anyway, many of the tools are a little easier with one file. On Sun, Feb 14, 2021, 14:20 Daniele Nicolodi wrote: > On 07/02/2021 18:55, Ben Blount wrote: > > I am using this forked version > > <

Re: Newbie: How to manage option trades?

Nice approach Red. I use a lot of the same institutions and have been working with beancount-import. For example see Schwab CSV importe r with support for brokerage, options, and banking. I'm evaluating swit

Re: Where to write cache data on Windows?

No problem. Tests pass on windows. > python3 -m unittest tests/test_cache.py ... -- Ran 7 tests in 0.031s OK On Sun, Feb 14, 2021 at 12:21 PM Daniele Nicolodi wrote: > On 14/02/2021 20:46, Ben Blount wrote: >

Re: beancount.ingest is no more. Long live beangulp!

No problem Daniele, thanks for fixing up the history! On Fri, Feb 19, 2021 at 4:20 PM Daniele Nicolodi wrote: > On 02/02/2021 07:20, Martin Blais wrote: > > Hi, > > > > Part of v3 plans is thinning out the repository. > > I've just moved the beancount.ingest directory from beancount to a new > >

Re: Handling benefits in kind

How about adding an Income leg for the BIK amount + an equity posting which absorbs it? That will make the transaction balance. On Fri, Feb 26, 2021, 10:02 Pedro F wrote: > Hi everyone, I've been lurking here for a while as I migrated my 10 years > worth of transactions into beancount (from a be

Re: Handling benefits in kind

Putting it in Expenses makes a lot of sense. I was originally thinking Equity since it's not an expense that you personally pay, but since it's an expense incurred on your behalf it does make sense to attribute it to your expenses. I'd want to make sure it was in a separate Expense account if it we

Re: Multipliers

I'm curious to hear a bit more about what gets ugly with modeling futures in the present system. Resolving mark to market seems like a challenge. On Sun, Feb 28, 2021, 08:02 Martin Blais wrote: > FYI. > I added a section on multipliers in the v3 goals: > > https://docs.google.com/document/d/1qPd

Re: Tracking different cost basis methods for different countries?

Hey James, Implementer of the average cost booking here. We rolled it back from v3 due to a performance regression. I've been pretty busy and haven't had a chance to address that to get it merged back again. It works and is correct to the best of my knowledge / tests. My recommendation for taxes:

Re: A beancount plugin that adds checks for balance expressions

+1, great use of plugins + custom directives! On Thu, Mar 18, 2021 at 2:32 PM Martin Blais wrote: > I love it! > > On Thu, Mar 18, 2021, 15:49 Di Weng wrote: > >> Hi everyone! >> >> I made a small plugin for checking balances against the simple >> expressions combining multiple accounts. Here a

Re: Open Account with several transactions for correct cost basis

Beancount doesn't currently support transactions that self-reduce. So you need to at least split the buys and sells. Should be no problem with having those be grouped together though. On Tue, Mar 23, 2021, 09:12 david e wrote: > I am trying to open an account and immediately add existing lots th

Re: Open Account with several transactions for correct cost basis

If you really want but I'm somewhat unclear what you are trying to do. Normally you'd book sales to PnL + a cash account for the proceeds. If you group the transactions together under a single txn your income statement will all be grouped under that date. Maybe that's fine if you don't care about t

Re: Open Account with several transactions for correct cost basis

You can use bean-doctor print to show your journal with fully resolved lots. On Thu, Mar 25, 2021, 05:27 david e wrote: > I just got an error message and really like the way the entry is > displayed, it looks like this > > Invalid currency USD for account 'Expenses:Crypto:ERC20:Fees' > > >20

Re: v3 Booking Redesign

I really like the proposal. I'm glad you thought of a way to simplify booking without needing to have a different syntax specifically for reductions. On Fri, Mar 26, 2021, 18:09 Martin Blais wrote: > Hi, > Lately I've been giving thoughts on redesigning the interpretation of > reducing postings

Re: OT: Cryptocurrencies exchange recommendation

Binance if it's available where you live. Low fees, large set of offerings including derivatives. On Wed, Apr 7, 2021, 13:15 Daniele Nicolodi wrote: > Hello, > > this is a bit OT, but there are many in the list that operate with > cryptocurrencies, thus I would like to ask for a bit of advice: w

Re: how to transfer Lots/cost basis from wallet to wallet

There were several recent threads on this subject that go into more details. I'm on mobile or I'd give you a link. On Sat, Apr 10, 2021, 07:24 david e wrote: > I see, thanks! > > bl...@furius.ca schrieb am Samstag, 10. April 2021 um 16:19:50 UTC+2: > >> It doesn't do that for you. >> It can book

Re: petl (Was: Re: Visidata)

Did either of you end up making some end to end flows with this that you'd be willing to share? I'm looking to make a pivot-table of account rollup balances over time and something like PETL would be a great fit. On Fri, Jan 29, 2021 at 6:50 PM redst...@gmail.com wrote: > Excellent find. I've be

Re: petl (Was: Re: Visidata)

Thank you both! On Sun, Apr 11, 2021 at 2:43 PM redst...@gmail.com wrote: > Yes, extensively in my importers > . > > *Context:* > > https://reds-rants.netlify.app/personal-finance/make-importers-easy-to-write-and-write-lots-of-them/ > https:

Re: BQL PRINT command in a script

Why not write small python scripts whenever you want to do a query? You could have pre-written scripts with bindable parameters. You could even go as far as to accept python snippets from the command line, similarly to how petl does.

Re: The Five-Minute Ledger Update

Thanks for putting this together! On Sun, Apr 18, 2021, 10:22 cha...@gmail.com wrote: > Very well put-together. I will say that for me the thing that made it easy > to stick with Beancount, and plain text accounting in general, is to > simplify my financial life. > > I have one login for my chec

Re: The Five-Minute Ledger Update

I'm interested in how you do password management for ofxget. On Mon, Apr 19, 2021, 17:47 redst...@gmail.com wrote: > Cool, happy to hear this! > > I'll write these articles up soon. Meanwhile, here's a preview of both: > > My testing framework is rather rudimentary, but works well: it's just a >

Re: Roth Contributions

I looked into the calculations by checking the underlying IRS forms a few years ago. It is not prorated, withdrawal of basis dollars is totally tax free until withdrawal exceeds basis. *I am not a tax expert, may be wrong On Sat, Apr 24, 2021, 18:18 Martin Blais wrote: > Oh I see. That makes se

Re: emacs beancount mode and multiple files for accounts

Relevant thread: https://groups.google.com/g/beancount/c/QOJInwm1TZ0/m/ggsT1AsyAQAJ I was using https://github.com/cnsunyour/beancount.el previously to get completion with accounts defined in different files. However I've since merged into one file and am using the official plugin. Daniele mention

Re: emacs beancount mode and multiple files for accounts

I'm fairly new to emacs myself but can answer those questions. Straight is a package manager for emacs. It automates grabbing files from github and updating them when versions change. You can keep using your old code if you don't want to futz with it, you'd just put cnsunyour's version of beancoun

Re: How to create opening balance for commodity holdings ans positions?

+1 to Red. I also just want to make sure you're aware that beancount tools generally have date filtering built in. Bean-query has "FROM OPEN ON" and Fava has the date filter bar. On Sat, May 1, 2021, 12:02 redst...@gmail.com wrote: > That would be exactly how I'd write it if I wanted to. > > Ho

Re: Difficulty accounting for stock sales in foreign currency

bean-doctor context can really help. It prints resolved details from the transaction and should help you track down the imbalance. On Sat, May 1, 2021, 12:46 Caesar Schinas wrote: > But that's the thing: my income *wasn't* 1015.34 GBP, it was 977.88 GBP. > That is the difference between the am

Re: Capital gains and trading commissions

There's a total cost syntax, it's double curlys {{ }}. The main downside of it: we have limited control over the precision for non-round numbers, so the costs can be long (and an exact match is required if you ever want to match by cost). Also there's a # syntax for specifying an expense like a co

Re: autobean.narration: per-posting narration, in comment

Great plugin, thanks for sharing! On Sat, May 8, 2021, 04:04 Archimedes Smith wrote: > Hi all, > > I'm sharing the plugin `autobean.narration` which I've personally been > using a lot for shopping transactions. It allows me to annotate each > posting in a concise way by populating per-posting na

Re: payee per posting

Not out of the box AFAIK. Yes if you write a plugin: - Make "payee" a metadata field on each posting. - Write a plugin that splits the original transaction into several. On Thu, May 20, 2021 at 4:23 PM Matt Hellige wrote: > Migrating a non-profit bookkeeping system from ledger, and currently I

Re: Internal Transfer Mutual funds - SPAIN Use case

I think you'll have to make some tradeoffs to represent this. For tax tracking purposes, you'll want to keep the total cost basis the same. That will let you calculate realized profit when you choose to sell. For investment performance purposes, you want to know what price you actually bought it at

Re: Internal Transfer Mutual funds - SPAIN Use case

Hey Pablo, Nice dashboard! I recommend searching the mailing list archive, there's a wealth of info. Also take a look at Fava investor, also discussed here. On Fri, May 28, 2021, 06:34 Pablo Osers wrote: > Many thanks guys! > > I'm quite new to BC and I need to understand properly the impact on

Re: Query to give converted aggregate balance on date?

Have you tried FROM CLOSE ON See https://beancount.github.io/docs/beancount_query_language.html for more on how this works. On Sat, May 29, 2021, 13:12 Mark Lodato wrote: > Oops, I sent out that email in haste. I didn't mean it for it to sound so > demanding. > > If anyone wouldn't mind helpin

Re: Smart Importer

Hey Jonathan, I don't know the specifics of how to configure the standard Python logger. I just want to offer that you might have a better time with a debugger, which lets you see and change program state at breakpoints. Python being an interpreted language it is one of the absolute easiest languag

Re: FIFO validation with STRICT booking

Custom booking methods would be fantastic. Does anyone have thoughts on how such a registry would be configured? The only mechanism that comes to mind as workable would be to register it like plugins are currently. Given the plans to add pre-booking plugins in v3 that work on direct-from-parser in

Re: FIFO validation with STRICT booking

: > Extra directives look ugly to me. Trying to keep the language lean. > I'd just have a Python-level feature and you'd have to write your own main > with load_file(). > It's pretty exotic anyway. > > On Sat, Jun 5, 2021 at 12:53 AM Ben Blount wrote: > >>

Re: Moving from GnuCash

Add an American, +1. ISO format is best. Let's hope someday rationality will prevail and we can dump the base 2 based imperial system too. On Thu, Jun 10, 2021, 02:37 Thomas den Hollander < denhollander.tho...@gmail.com> wrote: > There are very few countries that use MM/DD/: > https://en.wiki

Re: Moving from GnuCash

> Voiding checks / reversing transactions This is similar to returns. I just handle it by zeroing out the expense posting 2021-06-10 * "Buy something" Expenses:Foo 0 USD ;Was 10 USD. When I return, I set it to 0. Liabilities:CreditCard -10 USD Assets:Receivables 10 USD Assets:Receivabl

Re: holdings

Hi David both questions have been covered in this mailing list. In short, use fava, not bean-report. On Fri, Jun 11, 2021, 08:24 david e wrote: > Hello, I am new to beancount and still making small steps. > > I am managing my trading positions with it and would like to get a better > understandi

Re: Reporting USD Trans in CAD for CRA

There are some other Canadians on the list who have posted previously and developed some plugins to help with a variant of solution 2. See https://groups.google.com/g/beancount/c/UcEqxDKtqB8/m/BJe_XFSlDAAJ and if you search teh mailing list you may find some additional threads. On Mon, Jul 19, 20

Re: Stock amortization

Hey Leo, I'm not familiar with why a fund would so alter its cost basis, so I can't comment on whether adjusting the basis makes sense. But to do what you asked to: Postings are adding or subtracting from an existing position. So adding or removing 0 units doesn't make sense. Try a transaction whi

Re: Filter / Restrict Account Category

It would be easier to help if you give us queries and tell us what you want the output to be instead. On Mon, Aug 23, 2021 at 12:22 PM Toby wrote: > Hi, > I have made some headway with matching the entries using the filter but > not exactly. > It still includes related entries (ie. counter-accou

Re: transferring inventory from one account to another

Yeah this is high on my wishlist too. This came up a bunch for crypto users as well - you should find some examples if you search for crypto on the mailing list. The workaround is you have to transfer the lots manually, e.g make two postings per lot - one to reduce the lot on the old account, then

Re: transferring inventory from one account to another

o that. > > > On Friday, September 3, 2021 at 1:45:29 AM UTC+12 bl...@furius.ca wrote: > >> +1 re. Ben's answer. >> How many of these do you really do? >> >> >> On Thu, Sep 2, 2021 at 2:30 AM Ben Blount wrote: >> >>> Yeah this is high on my wi

Re: transferring inventory from one account to another

mp residuals here, >>> but keep the cost base rather than convert to cost currency". If this >>> doesn't resolve to a single currency it's an error. >>> >>> But that's really a question for Martin; please just consider this a >>> kee

Re: Does anybody use (number, currency) amounts in metadata?

I don't, and it seems like it would be fine to have a single valued metadata. I assume the grammar will require the key to be a string, but the values can be dates, bool, ints, floats etc? If there are folks that rely on this, there's a workaround of breaking it into 2 metadata where knowing the c

Re: How to transfer lots from accounts?

This is one of the most commonly asked questions, please give archives of the list a look and come back if you have questions after that. On Tue, Oct 12, 2021, 07:42 kohlt...@gmail.com wrote: > > I got myself a new broker and migrated all shares there. But whatever I > try beancount complains ab

Re: Fava Plugin to show portfolio summaries with rate of return

Nice project! On Fri, Oct 15, 2021 at 7:08 AM Phractured Blue wrote: > I've developed a Fava plugin that can calculate a portfolio summary. With > several features I've not seen brought together in one place before. > > What I needed was a way to group my various accounts by type (Roth, > Pre-Ta

Re: Questions on solo 401k accounts structure / set up

3. IRAUSD - another possible reason would be to track total basis dollars across all positions in the IRA. Roth IRA early withdrawals is penalty free until you start getting into any earnings, so it's useful to know how much you put in and paid taxes on. 4. Other notes - cost basis in an IRA is us

Re: The Five-Minute Ledger Update

Sadly ofxget compatible endpoints seem to be dying - every year less of the institutions I use support it. It's very easy to use though so if one of your banks works with it, definitely worth trying it. Several of them at least still support ofx export, but from their website, requiring selenium t

Re: The Five-Minute Ledger Update

Ofx is still the best, the institutions that have removed their API endpoints said they did so for security reasons. Vanguard and ibkr for example still offer ofx, just have to download it from the web with a browser or use selenium. On Fri, Nov 12, 2021, 05:51 Bman Q wrote: > "Sadly ofxget comp

Re: Frustration

Sorry it's been a rather crazy time and I don't remember. There are several nice importers in github.com/jbms/beancount-import in addition to a nice webUI for merging / reviewing postings. beancount-import supports using beancount native importers, so in a sense the merging I described is already t

Re: CSV export with both accounts of a transactions

If you are at all familiar with Python, I'd do this by hand in code by looping over the transactions and postings within rather than trying to fiddle with BQL. Here's some inspiration: https://github.com/beancount/beancount/blob/v2/beancount/projects/export.py Once you are familiar with a few API p

Re: Mortgages + Fava Extension / Time Filter

I don't know of a better way. I take the same view that you describe: that the interest portion of the payment should be attributed as an Expense, principal as paying down a Liability, and any escrow taken out for the mortgage company to pay taxes+insurance on your behalf as adding to an Asset acco

Re: Mortgages + Fava Extension / Time Filter

Ah that makes sense, thanks. I still think it's better to produce the transactions instead because that way all beancount tooling will work out of the box. On Thu, Dec 2, 2021, 13:54 Scott Wallace wrote: > Thanks for the leads! And just to clarify, my intent with the Fava > extension wasn't to

Re: A quick word about CSV importers

Sounds great, and aligned with the ethos of v3 splitting and generalizing. On Sun, Dec 5, 2021 at 1:20 PM Martin Blais wrote: > Hi! > > It's been a while since I've done much, but a few weekends ago I rewrote > all my CSV importers. > I had new changes to update my code for, and I was also behin

Re: How to convert from Vanguard Investor shares to Vanguard Admiral shares

Sounds like the cost basis transfers over. If so, you can account for this by making the *total* basis of your new lots equal to the total basis of the original lots. The easiest way to do it is the total cost syntax using double curlys, but if the division ends up being irrational, you can get a

Re: Inferring unit cost from a total amount

I'm not sure what level of deprecation the total cost syntax has, but using that seems like a pretty decent solution. You can also do math just about anywhere where a number is accepted, so you could do this AFAIK: Assets:Bank 100 FOO { 5000 / 100 USD } On Thu, Dec 30, 2021 at 7:49 PM Samuel Lotz

Re: HTTP API

Neat! I'm interested in the financial dashboard you describe. On Sun, Jan 23, 2022 at 10:47 AM Patrick Ruckstuhl wrote: > Hi, > > Funny I had something similar created some time ago that I had also called > bapi (but I have since switched stuff around so I'm no longer actively > using it) > > >

Re: New beancount user, v2 or v3 in 2022?

Fava, importers, and beancount-import all work fine with v3 and I personally use all 3 with v3. I do recall some very minor patching being required at one point, primarily to update import names. As you've said by far the biggest change is in the importer structure. On Tue, Feb 8, 2022 at 5:33 AM

Re: New beancount user, v2 or v3 in 2022?

Here you go. My process was just to attempt running Fava and fix imports until it works. diff --git a/src/fava/core/ingest.py b/src/fava/core/ingest.py index d94a8bce..7d483bbf 100644 --- a/src/fava/core/ingest.py +++ b/src/fava/core/ingest.py @@ -14,9 +14,9 @@ from typing import Tuple from typin

Re: Problem correctly registering a stock split

Hey Zurab - this topic is a pretty frequent one. Take a look at the mailing list archives first and then let us know if you're still having trouble. On Mon, May 2, 2022 at 2:43 PM Zurab Sajaia wrote: > Hi, > I just recently found and started using beancount, and have been having > fun converting

Re: Problem correctly registering a stock split

Glad you got it sorted out! Yes one of the interesting things for me when adopting beancount was getting a much better understanding of how my brokers were actually logging trades. On Tue, May 3, 2022, 07:32 Zurab Sajaia wrote: > Thanks a lot for the quick response! somehow I had assumed that my

Re: Payees, Subaccounts, Channels

+1 to this idea and Stefano's well reasoned response, leaf accounts are an annoying trade-off I often make too. I agree that the metadata approach seems best and totally backwards compatible to older parsers. It would be nice to have the open and closing plugins respect these leaf accounts and not

Re: ofx-summarize: a quick and dirty way to peek inside a .ofx file

This is great, thanks so much for all you do for the community! On Thu, Aug 4, 2022 at 11:23 PM Red S wrote: > I was finally able to get a bunch of tools I use the TLC they needed. I > cleaned them up, added nice click -based > command line interfaces, and che

Re: Best approach to combine multiple data sources

Hey Nasko, Yes plugins are intended to be ephemeral transformations / validations on the ledger. It reads the ledger file(s) on disk, and applies plugins to the in-memory representation of the ledger. My recommendation is to think of your ledger as a pipeline. Some stages of it can be ephemeral an

Re: autobean.refactor: an ergonomic and lossless beancount editing library

This is great, thanks for writing it! On Wed, Oct 5, 2022, 14:39 Archimedes Smith wrote: > Hi beancounters, > > One thing I have been wanting for long in beancount ecosystem is some > tooling to programmatically *edit* my ledger. For example: > >- Formatting > - Sort ledger entries, wi

Re: Banks moving away from Direct Connect API

The only options I know of: - Use mint.com and get their low fidelity CSVs via mintapi project - Use plaid or yodlee, though many banks require prod path flow which I couldn't do on a dev account. - Scrape statements or the web interface manually. - Gaze longingly towards Europe and their data port

Re: transfer_lots Plugin "locks" lots

This should probably be a FAQ. See recent thread: https://groups.google.com/g/beancount/c/88WjwEhJKUk and many before. In short: Booking runs before plugins . There's been discussion in t

  1   2   >