cash flow statement

[Ricardo Pietrobon]

Hi, I am a newbie to beancount and so although this question might have an obvious answer I couldn't locate it anywhere: How do i generate a statement of cash flows? I found the function to generate a balance sheet and an income statement, but could only generate the cash flow using hledger.

thanks

[Martin Blais]

Which kinds of breakdowns are you looking for?

AFAIK the statements of cash flows is typically used in companies to break down operating, financing and investing activities.

(The personal equivalent wouldn't be very useful IMHO, but correct me if you think I'm wrong.)

Beancount only enforces a categorization between Assets/Liabilities/Income/Expenses. It doesn't really know further about your activity breakdowns. You'd have to come up with some rules to group your accounts (transactions?) into one of these three types of activities.

HLedger appears to only give you a balance of all accounts except receivables, with some hardcoded account names:

https://github.com/simonmichael/hledger/blob/588f36d662c76d522caf96d9cadae7caf4bf9b2d/hledger-lib/Hledger/Data/Journal.hs#L241

You can easily get the equivalent with a SQL statement (use bean-query).

In any case, if you could let us know what output you're looking for I'm sure we can fix you up with a suitable query.

On Mon, Apr 25, 2016 at 12:11 PM, Ricardo Pietrobon <piet...@gmail.com> wrote:

Hi, I am a newbie to beancount and so although this question might have an obvious answer I couldn't locate it anywhere: How do i generate a statement of cash flows? I found the function to generate a balance sheet and an income statement, but could only generate the cash flow using hledger.

thanks

--
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/ce8f559e-862e-40ee-b1bf-dc9c30ca4a3b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Ricardo Pietrobon]

Hi Martin, thanks a ton for the quick response. What I had in mind was something truly simple: Just a report with all debits and credits for the cash account for a given period. In other words, it's literally what hledger provides under http://goo.gl/dSzfsG . This might be available already and I just don't know how to get it. Thoughts?

--
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/EPUbSSTeA30/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.

To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhPUHKuC_hEnw7vE2xp8B5sxYWwVPQg79%3DJfv3OWNReHHA%40mail.gmail.com.

[Martin Blais]

On Tue, Apr 26, 2016 at 4:25 AM, 'Ricardo Pietrobon' via Beancount <bean...@googlegroups.com> wrote:

Hi Martin, thanks a ton for the quick response. What I had in mind was something truly simple: Just a report with all debits and credits for the cash account for a given period.

What's the "cash account"?

 

In other words, it's literally what hledger provides under http://goo.gl/dSzfsG . This might be available already and I just don't know how to get it. Thoughts?

Have you tried the SQL client?

http://furius.ca/beancount/doc/query

 

To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAF4X4oMv9y9Vx8XUc7cNcg9h%2BNAczWMi1mhTLSwa-T6EGjPoEw%40mail.gmail.com.

[Ricardo Pietrobon]

Thanks Martin, will give the SQL client a try

To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhOR5-MgcJm9FneoCJZnY2BvrmLVnfPN9AdVUK7bHjfvRw%40mail.gmail.com.