Change bean-count to report in operating currency

614 views
Skip to first unread message

ad...@vyomtech.com

unread,
Mar 7, 2016, 4:26:13 AM3/7/16
to Beancount
Hi!

Is there an option in bean-web to just use single currency for reporting. I have defined the operating currency option and it is only used to calculate the networth, but is not used in balance sheet and income statement.

In earlier version there was an option -c but in new version 2.0 it does not exist anymore. I have already defined the price for currency conversion.

I need to work in at least 5 currencies but the report needs to be in single currency for tax purposes.


Martin Blais

unread,
Mar 7, 2016, 10:52:48 PM3/7/16
to Beancount
Yeah, somebody else was asking for the same feature recently. I wouldn't mind having it myself.


--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/abd01e35-922e-4938-a735-c0c7212a4856%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

vess...@gmail.com

unread,
Mar 8, 2016, 4:10:14 PM3/8/16
to Beancount
Nice synchronicity! 

I would like this as well, and it seems to be a gap for hledger (and possibly ledger). But, almost always this sort of report is needed for projections, decision making and tax reporting. So it makes some sense to build.

ROKA Admin

unread,
Mar 8, 2016, 8:24:33 PM3/8/16
to bean...@googlegroups.com

Ledger has an option -X <Commodity> to report in single commodity.
I use it to generate reports in different currency for different jurisdiction.

In beancount earlier version there was and option -c <commodity>, but in 2.0 this option is no longer there.

I think it can easily be done using bean query. It will be a nice addition for bean-web and easier for people to analyze report in specific currency.

You received this message because you are subscribed to a topic in the Google Groups "Beancount" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/beancount/5JE9vntz54o/unsubscribe.
To unsubscribe from this group and all its topics, send an email to beancount+...@googlegroups.com.

To post to this group, send email to bean...@googlegroups.com.

Martin Blais

unread,
Mar 9, 2016, 11:18:45 PM3/9/16
to Beancount
On Tue, Mar 8, 2016 at 8:24 PM, ROKA Admin <ad...@vyomtech.com> wrote:

Ledger has an option -X <Commodity> to report in single commodity.
I use it to generate reports in different currency for different jurisdiction.

In beancount earlier version there was and option -c <commodity>, but in 2.0 this option is no longer there.

Ouf.... that's a long long time ago in another galaxy...

 

I think it can easily be done using bean query. It will be a nice addition for bean-web and easier for people to analyze report in specific currency.

This should it:
beancount> select account, convert(sum(position), "USD") from close  clear group by 1 order by 1




 
Reply all
Reply to author
Forward
0 new messages