Beancount getting started

Thanks Tino, i feel like abusing you abit for my ubuntu-learning :grin: sorry for that!
so I followerd your suggestions, but the syslog file would not pop up. appearently, rsyslog is installed.

I do find the dpkg.log which continas a long log on packages, but no syslog

btw I do not use docker, I tried that but gave up not soon after you guys tried to help me with that. i am using plain WSL Ubuntu 18.04

In this kind of accounting, you book what you own (assets) with a positive sign. And since the sum of all positions has to equal 0, then the source of what you own has to be negative.

Also note that what you owe (liabilities) is not any different from what you own (assets). Owing is like owning a negative amount. So if you owe me $1000, then I book +$1000 under assets/liabilities. But if I owe you $1000, I book -$1000. If I put this account under assets or liabilities will depend on my preference: if I generally owe you or you owe me for most of the time.

Thanks for the explanation.

I am indeed familiar with this since I use GNUCash which also imposes that Equity = Assets - Liabilities, both being positive numbers if you have assets and owe money. However in Gnucash Expenses and Income are also both positive, so that PnL = Income - Expenses. In Beancount I see that Assets + Liabilities + Expenses + Income must be zero, which is still a bit of brain gymnastics for me, but sure.

Given the modular nature of Beancount it should be no problem writing my own reports where I adjust for this :slight_smile:

1 Like

Exactly.

A + L + E + X + I = 0

NI = X + I

A + L = - E - X - I

Check out Beancount Manual for more.

Strange
 Try to delete the package with:

sudo apt-get purge rsyslog

and then reinstalling it

sudo apt-get install rsyslog

Later do a
sudo service rsyslog restart

Hello there, I am back with another noobie question: is it possible to exclude some category from the “Trial Balance” in Fava?

I tried the obvious: prepending “-” to Account filter. That does not work.

What I’m trying to do is to interpret the treemap/sunburst diagrams, but I don’t want to compare my groceries with tax payments.

If it’s not possible in Fava, is it possible to write custom query in Beancount directly, which would calculate me the %-split?


EDIT: I figured it out, though it’s not very intuitive to me. I had to put this in the general filter, not the account filter (source):
-any(account:"Expenses:Taxes")

2 Likes

Thank you for the solution.
Just a comment
 the command is:

all(-account:"^Expenses:Taxes")

Regards.

Both of these work:
all(-account:"Expenses:Taxes")
-any(account:"Expenses:Taxes")

However, they have slightly different semantic, depending if you put more terms inside the parenthesis.

Yep, you are right.

My mistake was because I copy and paste your command and didn’t work. I was looking in the doc and I found the example that I wrote (with all()) and that worked. I didn’t remark the both ** at the end of your command that was what made the command invalid.

Thank you for your explanation.

I spent the last few days to get my beancount setup running. So far I have the following importers working:

  • ZKB
  • Viseca
  • Revolut (with which I had a double counting issue initially because of the Exchange In/Out statements)
  • IB

Missing:

  • Neon

What kind of expense accounts do you have? I‘m currently thinking of separating take-away food like Bretzelkönig from Groceries for example.

Hi, it depend of you.
Un my case, I have a round 100. I like to have an Income:Stock:VT and Income:Stock:VTI . Somebody could be happy with Income:Stock and put everything inside.

For you could be necessary to split by countries, currencies, etc


For food I only have a Food account where I put everything, but for you could be interesting how much you expend in alcohol, or in shusi! So you’ll need 3 accounts: General, Alcohol and Sushi


I would’t care too much, in the last year I split accounts or unify others. With VisualCode I search and replace text in all files at once. Really nice.

Regards

When creating Income accounts, it’s good to think about the source of income, because that’s what interests you. Personally, I would divide investing income into Dividend and Gains. Also, I have it grouped by broker, but maybe it makes more sense to group by asset?

For food I made the following split:

open Expenses:Food:Canteen  (at work, school)
open Expenses:Food:Groceries
open Expenses:Food:Restaurants (includes take away, cafe)

Interesting but do you strictly separate Groceries in Food and Non-Food categories? Or are you counting Toilet Paper as Food in this case? xD

I do. I can’t imagine classifying every single item :stuck_out_tongue_winking_eye:

For stocks I have one income account for interest/dividends and one for capital gain. Capital gain is already tied to the security by the transactions and for interest/dividend I tie it with a 0 posting together. That way I can then still figure out individual incomes for each stock without having to have too many income accounts.

For everything else it really depends on what you’re interested in and what you want to split up (e.g. if you go shopping do you want to split up the different positions or is it just the whole shopping)

Feels like too much freedom. Why are there no best practices or example account lists for FIRE seekers?
Took me another evening to get bean-price working but now I‘m able to comfortably convert all assets to CHF in Fava. And they seemingly match what I had in the spreadsheets, yay.

Well, what I did is I took some examples from https://github.com/beancount/beancount/tree/master/examples and showing the trees in Fava. I clean some accounts, add some others and voila!

In one year I changed 4 o 5 accounts, rename some and join others.
That’s is the cool thing with Beancount and a powerful text editor. You can use a global search with all your files, change text, modify
 Really freedom.

Regards.

I think someone else already mentioned but are there fava plugins for monthly saving rate etc? Would be nice to be able to export some graphs to my blog directly from the web ui.

1 Like

Hello everyone!

are there fava plugins for monthly saving rate etc?

+1, someone mentioned there is, but I’ve done some research and I wasn’t able to find any.

However, during my search I found this treasure, which has many many interesting plugins from the author himself:
https://bitbucket.org/blais/beancount/src/default/experiments/


I have a question about tracking delayed transactions. How do you track when there is a related transaction referring to a date (or daterange) in the past? Two use-cases:

  • For electricity I sometimes get a bill many months later. E.g. for 2019 I’d get a bill in 2020. Would you keep the posting in 2020? Or would you split the transaction to amortize the “Expenses” category?

  • Sometimes, my employer reimburses what I spend, but it takes around ~2-3 months to process. How would you deal with this? Since I know that the transaction will be reimbursed, I don’t want to put it in the Expenses category.

1 Like

Depends on how you want to track it. Since this will happen every year I just take the expenses into account when I pay the bill. However you could also post, on the date when you use your electricity have an Expense from an account called “Owed to power company” and then make a transfer from your current account to that account when you pay the bill. That way your current account balance is up to date and you track the actual time of the expense as well. In my opinion this would be an overkill.

Again, just my opinion: I have an “Expenses:Professional expenses” account that I exclude from reporting. Whenever I get a reimbursement I substract the reimbursed amount.

Thanks!!!