Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
Balance Report showing all accounts
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  7 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Siddharth Sharma  
View profile  
 More options Jun 9 2012, 8:38 am
From: Siddharth Sharma <s...@svs.io>
Date: Sat, 9 Jun 2012 05:38:16 -0700 (PDT)
Local: Sat, Jun 9 2012 8:38 am
Subject: Balance Report showing all accounts

Hello, I am having a problem getting the balances for all accounts.
Consider the following Journal file

2012-01-02 brown fox
  Assets:Checking       10
  Liabilities:Saving   -10

2012-01-03 jumps over
  Assets:Checking:Jumping         100
  Liabilities:Saving:Sleeping    -100

when I ask for the balance report, there is no entry for "Assets", only
"Assets:Checking" and "Assets:Checking:Jumping". How can I get the balance
report to also give me one line for "Assets", which is the sum total of all
accounts below Assets?

I have tried --flat, custom formats, etc.

thanks in advance
Sid


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Craig Earls  
View profile  
 More options Jun 9 2012, 6:35 pm
From: Craig Earls <ender...@gmail.com>
Date: Sat, 9 Jun 2012 15:35:37 -0700
Local: Sat, Jun 9 2012 6:35 pm
Subject: Re: Balance Report showing all accounts
In the given ledger Asset:Checking is the top level tracked.
'Jumping' is a subaccount of Assets:Checking.  You need another sub
account of Assets before ledger will roll it up.

If you use this:

2012-01-02 brown fox
  Assets:Checking       10
  Liabilities:Saving   -10

2012-01-03 jumps over
  Assets:Jumping         100
  Liabilities:Saving:Sleeping    -100

then `ledger bal` reports:

15:33:48 ~  > ledger -f test.dat bal
                 110  Assets
                  10    Checking
                 100    Jumping
                -110  Liabilities:Saving
                -100    Sleeping
--------------------
                   0

On Sat, Jun 9, 2012 at 5:38 AM, Siddharth Sharma <s...@svs.io> wrote:
> 2012-01-02 brown fox
>   Assets:Checking       10
>   Liabilities:Saving   -10

> 2012-01-03 jumps over
>   Assets:Checking:Jumping         100
>   Liabilities:Saving:Sleeping    -100

--
Craig, Corona De Tucson, AZ
enderw88.wordpress.com

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Martin Michlmayr  
View profile  
 More options Jun 9 2012, 6:55 pm
From: Martin Michlmayr <t...@cyrius.com>
Date: Sat, 9 Jun 2012 23:55:29 +0100
Local: Sat, Jun 9 2012 6:55 pm
Subject: Re: Balance Report showing all accounts
* Siddharth Sharma <s...@svs.io> [2012-06-09 05:38]:

> when I ask for the balance report, there is no entry for "Assets", only
> "Assets:Checking" and "Assets:Checking:Jumping". How can I get the balance
> report to also give me one line for "Assets", which is the sum total of all
> accounts below Assets?

You only get Assets:Checking because Assets:Checking and Assets are
the same in your case.  You'd get Assets as a separate line if you had
multiple sub-accounts within Assets.

You could also use --depth 1 to just get Assets but then you don't see
details for sub-accounts.

--
Martin Michlmayr
http://www.cyrius.com/


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Siddharth Sharma  
View profile  
 More options Jun 10 2012, 12:59 am
From: Siddharth Sharma <s...@svs.io>
Date: Sun, 10 Jun 2012 10:29:18 +0530
Local: Sun, Jun 10 2012 12:59 am
Subject: Re: Balance Report showing all accounts

Thanks for the replies. It seems there's no way to have an "Assets" line in
the tree of accounts shown for the ledger file in my example? Not a problem
- I am working around the issue with some ruby code.

cheers
Sid


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Craig Earls  
View profile  
 More options Jun 10 2012, 8:03 am
From: Craig Earls <ender...@gmail.com>
Date: Sun, 10 Jun 2012 05:03:43 -0700
Local: Sun, Jun 10 2012 8:03 am
Subject: Re: Balance Report showing all accounts
No.  You did not understand,  in your example there is no tree, only a
straight line.  Since you no doubt will have more than one sub account
under assets your problem will go away with a more realistic example
file.

--
Craig, Corona De Tucson, AZ
enderw88.wordpress.com

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Siddharth Sharma  
View profile  
 More options Jun 10 2012, 3:17 pm
From: Siddharth Sharma <s...@svs.io>
Date: Mon, 11 Jun 2012 00:47:08 +0530
Local: Sun, Jun 10 2012 3:17 pm
Subject: Re: Balance Report showing all accounts

On Sun, Jun 10, 2012 at 5:33 PM, Craig Earls <ender...@gmail.com> wrote:
> No.  You did not understand,  in your example there is no tree, only a
> straight line.  Since you no doubt will have more than one sub account
> under assets your problem will go away with a more realistic example
> file.

Ah, so we agree! There is no way to get a line for just Assets in my
example.

What if this is nested deep inside the tree? i.e. A:B:C:D:E and A:B:C:F.
Now there's no line for D and one can expect this to happen even in a more
realistic situation. In any case, I do not know beforehand what the
structure of the file is going to be, so I would love for ledger to print
all the "node" accounts separately so I can display them in a balance sheet
or something similar, no matter the structure. I am working around this
using a small wrapper script.

thanks for the replies.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
John Wiegley  
View profile  
 More options Jun 11 2012, 1:30 am
From: John Wiegley <jo...@newartisans.com>
Date: Mon, 11 Jun 2012 00:30:48 -0500
Local: Mon, Jun 11 2012 1:30 am
Subject: Re: Balance Report showing all accounts

>>>>> Siddharth Sharma <s...@svs.io> writes:
> Ah, so we agree! There is no way to get a line for just Assets in my
> example.

Just using --empty should do it.

John


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »