beancount/fava

m20a

@m20a_gitlab

thanks for that

Yan Haonan

@VegetaPn

Hi everyone. I occur an error when I run fava on pythoneverywhere. What can I do to fix it?

Jakob Schnitzer

@yagebu

You need to set app.config['BEANCOUNT_FILES'] to contain the paths to the files you want to load

Yan Haonan

@VegetaPn

@yagebu Thank you.

Andre Engelbrecht

@andrewebdev

Hey... newbie here to fava and beancount. I'm in a bit of a pickle. I need to prepare tax returns for my business. Issue is my business uses Cryptocurrency for my foreign clients. Basically they pay me in crypto, and then I use that crypto by either converting back to GBP and then paying salary, or just using the crypto debit card directly.

I've entered all my transactions for the year, and even included weekly historical prices using the "price" directive

but I cannot find a way to report the "Realized capital gains"

(or loss)

2019-06-26 * "EE Top Up"
      Assets:GB:Coinbase:ETH                 -0.04020595 ETH {{10.00 GBP}}
      Expenses:Communications:Mobile               10.00 GBP

That is how I enter my transactions. Am I missing anything related to reporting the realized capital gains/loss?

matrixbot

@matrixbot

PotterScholar Yeah, you need a line to calculate the gain/loss, let me show you what I'm doing

PotterScholar ;ethereum purchases
2017-07-14 * "Coinbase" "Crypto: Ethereum Purchase"
Assets:Cryptocurrency:Ethereum 0.51772979 ETH {193.15 USD}
Expenses:Fees 2.99 USD
Assets:Checking

;ethereum sales
2017-12-07 ! "<person>" "Crypto: Ethereum Sale"
Assets:Cryptocurrency:Ethereum -2.55155802 ETH {} @ 427.10 USD
Expenses:Fees 16.24 USD
Assets:Checking 1089.77 USD
Income:Other:Investment-Income

PotterScholar The gains/losses are in Income:Other:Investment-Income, the basis is maintained in Assets:Crypto:Eth, and the gross profits are in the cash account

Andre Engelbrecht

@andrewebdev

ah ok thx... I'll try that

Andre Engelbrecht

@andrewebdev

hmm, that doesn't work in my case. When I add the extra income line for gain/loss, I get a error: too many missing numbers for currency group 'GBP'

matrixbot

@matrixbot

David Yes, the transaction is balanced, so adding more accounts doesn't make sense. Right now your transaction basically says "I sold eth for £10 and spent £10". There's no room for basis info. You need to modify your transaction to credit the account holding your basis in ETH, then you can add the gain/loss income line.

David I can better explain in a few hours.

Andre Engelbrecht

@andrewebdev

yeah an explanation would be grand. A lot of the terminology used is going a bit over my head and as much as I read through the docs there are still many things that I miss or am confused about.

Andre Engelbrecht

@andrewebdev

This is what that transaction looks like atm

2019-05-24 * "EE Top Up"
  Assets:GB:Coinbase:ETH                 -0.05392256 ETH {} @ 196.58 GBP
  Expenses:Communications:Mobile               10.00 GBP
  ;Income:Realized:PnL

and it balances perfectly, so no PnL. The same goes for all my other transactions

Andre Engelbrecht

@andrewebdev

could it because I'm using "NONE" on my accounts instead of "FIFO/LIFO"?

Andre Engelbrecht

@andrewebdev

ok I figured it out. I had to put the exchange rate inside the curlies as well as using @ -price

ikwtif

@ikwtif

Hi Guys. I have a quick question about the fava option collapse-pattern. I just have this in my journal.beancount file, but it tells me "Invalid option: 'collapse-pattern'" . Anyone know why this wouldn't work?

ikwtif

@ikwtif

help tells you to insert it like this : 2020-01-01 custom "fava-option" "collapse-pattern"

but that just returns syntax errors

and when I insert it in like this: "fava-option" "collapse-pattern" ".:.:.*" I get the option error

ikwtif

@ikwtif

so I kind of fixed the syntax errors by putting this inside my accounts.beancount file but still nothing collapses

2001-01-01 custom "collapse-pattern" ".*:"

although at this point I think I'm misunderstanding what this option should do

Eugeniu Plamadeala

@Zburatorul

Anyone know why https://fava.pythonanywhere.com/ is down?

matrixbot

@matrixbot

David It's because I needed to reference it to setup budgets, so now it's down. Sorry everyone!

David I've had some luck getting cached pages through google

Eugeniu Plamadeala

@Zburatorul

Is anyone aware of a hotkey that shows/hides accounts with zero balance?

matrixbot

@matrixbot

Jorge Martínez López > <@gitter_zburatorul:matrix.org> Is anyone aware of a hotkey that shows/hides accounts with zero balance?

No, it seems it's only available as an option. I guess you can change that setting on your beancount file and reload.

Eugeniu Plamadeala

@Zburatorul

How do you all deal with the proliferation of closed accounts? Even if show-closed-accounts is False, accounts with a non-zero balance will always be shown.
(I have Income accounts that are no longer relevant)

matrixbot

@matrixbot

Jorge Martínez López Sorry Eugeniu tried to post a link and it failed

Jorge Martínez López showing zero balance accounts and close accounts is configurable as an option

Jorge Martínez López https://fava.pythonanywhere.com/example-beancount-file/help/options/

Eugeniu Plamadeala

@Zburatorul

@matrixbot, these options don't work. I have both show-accounts-with-zero balance at false, and show-closed-accounts at false. But as I mentioned in my original post closed accounts with non-zero balance still show up. While it may not make sense to have such asset/liability accounts. Such income/expense accounts do make sense.

qymab

@qymab

Hi,

I want to use this plugin > plugin "beancount.plugins.implicit_prices"

but I'm not quite sure how to run the plugin ?

Adam Gibbins

@adamgibbins

qymab: you simply put plugin "beancount.plugins.implicit_prices" at the top of your beancount file

qymab

@qymab

qymab: you simply put plugin "beancount.plugins.implicit_prices" at the top of your beancount file

Already put the syntax, but nothing change in beancount file ?

I try run the bean-check

Eugeniu Plamadeala

@Zburatorul

@qymab, how did you install the plugin?

Dr Louis Krüger

@llsjk_twitter

Hi,

Is there any method to get rid of old queries? How do one run queries inside the beancount file?

Glen Schrader

@gschrader

@llsjk_twitter it's kept in the browser local storage, F12 in chrome under Application

Where communities thrive

People

Repo info

Activity