Re: Time tracking: time formatting and hourly rates

[Colin Dean]

I've used timetracking mode extensively for about a decade now. I'm always 
learning new things about ledger but I feel I've got a lot of experience 
with that particular mode because I've been using it to track my time for 
more than half of my professional life ;-)

Unfortunately, you have to enter the time in fill HH:MM:SS. I've not found 
an option that enables eliding the seconds.

JW will probably respond with input on the latter.
On Wednesday, May 25, 2022 at 12:48:02 PM UTC-4 Carl Tappan wrote:

> Hi,
>
> I'm trying to set up a minimal time tracking system with ledger and have 
> two questions.
>
> 1.) Is it possible to enter time in "HH:MM" format? Converting to decimal 
> hours is clunky, and the various timeclock options don't fit my workflow 
> well. I know that I can add a timelog entry with "time in" and "time out", 
> but ideally I'd be able to post directly to the account.
>
> 2.) Is it possible to define an hourly rate in a price history file, or 
> some other persistent way that doesn't require recording each entry as xx.yyh 
> @ $ ? The documentation implies under 3.4.2 that time is just a 
> commodity, but setting a price as P h $ doesn't seem to work. If I 
> log in units of 'hours' instead of 'h' then defining P hour $ works 
> as expected, but I think that breaks the predefined equivalencies between 
> different time units.
>
> Thanks for any advice, and sorry if this I missed this somewhere in the 
> docs or discussion history.
>
> Best,
> Carl
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/e7819eb0-6ac3-43bb-ac79-469f21d43a97n%40googlegroups.com.

Re: Continuing ledger after a large gap

[Colin Dean]

100% this, Martin!

It's always better to pick up the present and fill in the past than it is 
to languish and lament on the past to spite the present and future.

This probably applies to a lot of things in life, but definitely to 
accounting and definitely to PTA.

For the past things, automate as much as you can to get coarse imports of 
data in that time range, then you can revise with more exact information, 
payees, etc. for data preservation.

On Sunday, March 13, 2022 at 10:52:52 PM UTC-4 Martin Michlmayr wrote:

> * melb...@gmail.com  [2022-03-13 19:35]:
> > Hello I have about 7 years worth of data in a ledger file till
> > ~2019. Due to some life events I had to stop updating it and now I
> > would like to pick it back up.
> > 
> > I would really like add to the same file. Is there a good approach
> > to do this?
>
> I'd post adjustment entries to bring your balances in sync with what
> your bank says.
>
> If your ledger from 2019 says you have 400 EUR in the bank, but the
> bank balance is 1000 EUR right now, you could add this entry:
>
> 2022-03-14 * Adjust bank balance
> Assets:Bank 600.00 EUR = 1000 EUR
> Equity:Opening balance
>
> In fact, ledger supports setting a certain balance like this:
>
> 2022-03-14 * Adjust
> Assets:Bank = 1000 EUR
> Equity:Opening balance
>
> If you later find time to important bank transactions from 2019-2022,
> you can always do that.
>
> -- 
> Martin Michlmayr
> https://www.cyrius.com/
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/d9bea067-9920-482e-973f-976a1c781c97n%40googlegroups.com.

Re: ANN: PTA wiki

[Colin Dean]

This is great. Thanks for getting it started!

On Monday, February 21, 2022 at 3:36:15 PM UTC-5 Simon Michael (sm) wrote:

> Good day friends!
>
> Some time ago I enabled the Github wiki attached to 
> https://plaintextaccounting.org . More recently we had some discussion in 
> the #plaintextaccounting matrix/IRC chat about how to best use it, with a 
> rough consensus to start by collecting and organising concise example 
> journal entries, useful for users of all PTA tools/Ledger-likes. 
>
> Currently we have lots of examples spread over 3+ tool-specific sites. The 
> tool-specific cookbooks are valuable, but there is some duplication of 
> work, and it's often still hard to quickly find the example you need. With 
> a general Plain Text Accounting wiki, there might be opportunities to 
> consolidate some content and effort, co-ordinate content categories, or 
> link back and forth.
>
> So I was just cleaning up the PTA wiki a bit, and I'd like to invite you 
> to check it out, give your ideas and join in if you like. More details are 
> at the wiki. 
>
> https://github.com/plaintextaccounting/plaintextaccounting/wiki - git repo
>
> https://wiki.plaintextaccounting.org [/PAGE] - easier shortcut url
>
>
> Best wishes
> Simon
>
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/f4e4f41a-128b-46a4-b992-66e8a2555dc2n%40googlegroups.com.

Re: include directives in ledger 3.2.1 and ledger-reconcile

[Colin Dean]

I'm using ledger 3.2.1-7build2 from ubuntu impish in the particular records 
I'm looking at right now. My includes are using "!include" are relative but 
my setup is different. I invoke ledger on a file that contains the 
commodity decls and then includes the activity file (and a file with 
opening balances in previous years, but for 2019+ I did everything in one 
file).

On Saturday, January 1, 2022 at 11:08:48 AM UTC-5 wyl...@gmail.com wrote:

> Hi everyone,
>
> I recently switched from ledger 3.1.22-20190205 (in Debian oldstable) to
> 3.2.1-20200518 (in GNU Guix) and I'm encountering the following issue.
> At the top of my ledger file are two include directives:
>
> include strict.db
> include prices.db
>
> The two included files are in the same directory as the ledger file.
> But after upgrading, when I try to reconcile an account using
> ledger-reconcile in Emacs' ledger-mode, I get the following errors:
>
> While parsing file "", line 1:
> Error: File to include was not found: "strict.db"
> While parsing file "", line 2:
> Error: File to include was not found: "prices.db"
>
> I'm not sure exactly what the cause of this is, but I did confirm that
> the issue does not occur if I switch back to ledger 3.1.2.
> It also goes away if I enter full absolute paths for the files, but not
> relative paths like "./prices.db".
>
> I also found this issue about include directives:
>
> https://github.com/ledger/ledger/issues/1659
>
> which resulted in this change:
>
>
> https://github.com/emin63/ledger/commit/9c1a7b1b1dbad11196571b1114ddaf23ae5345ff
>
> Could this be related to the problem? Is it now required to specify
> absolute paths in include directives?
>
> Many thanks for your insights?
>
> -- 
> Best,
> Richard
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/e56e25c8-9a84-44d4-b49b-2cddd8371e3en%40googlegroups.com.

Re: Approve dialog not coming up when transferring from Zilswap

[Colin Dean]

Wrong "Ledger". This is for ledger, a command-line, plain text accounting 
program, not Ledger, the cryptocurrency wallet.

On Sunday, November 7, 2021 at 11:14:10 AM UTC-5 kenm...@gmail.com wrote:

> Hi everyone, it's my first time here. I'm having a problem with 
> Zilpay/Zilswap/Ledger. When I try to send Zil to an exchange it it just 
> timeouts. This has been happening for the last week, I haven't been able to 
> move any Zilliqa out of my Zilpay wallet to an exchange. When I try to swap 
> zil for another token on Zilswap eveything works fine, I get the proper 
> approval dialog, but I can't send tokens. Does anyone have a idea of what 
> might be going on? Thank you!

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/3b19847d-f302-46fb-a307-ac2e70152624n%40googlegroups.com.

Re: Is it possible to abbreviate very large numbers? Using megs (M), kilos (K), etc? (EOM)

[Colin Dean]

You should be able to use commodity equivalencies to solve this problem to 
a degree, but it won't be automatic based on the magnitude in context, only 
whatever you set as the exchange, I think.

https://www.ledger-cli.org/3.0/doc/ledger3.html#Commodity-equivalences

On Sunday, September 12, 2021 at 9:45:48 AM UTC-4 tofe...@gmail.com wrote:

> You MIGHT use a commodity. For example, M_USD for millions of dollars ... 
> that's not a problem I face :-) ... and I realize it's not a direct 
> correlation to your question but maybe it's useful in some context
>
> On Sat, Sep 11, 2021, 19:48 Martin Michlmayr  wrote:
>
>> Not that I'm aware of, but I'm not 100% sure.
>>
>> -- 
>> Martin Michlmayr
>> https://www.cyrius.com/
>>
>> -- 
>>
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "Ledger" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to ledger-cli+...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/ledger-cli/YT1OQ7SldiGXI44c%40jirafa.cyrius.com
>> .
>>
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/7a58f47d-7e92-46e9-84a1-193d621b0d71n%40googlegroups.com.

Re: How to automatically pull bank transactions?

[Colin Dean]

https://github.com/egh/ledger-autosync can do this, although I've not used 
that functionality of it because I've found archiving CSV or OFX files to 
be a needed step for me.

On Tuesday, March 23, 2021 at 1:34:22 PM UTC-4 luka.b...@gmail.com wrote:

> I do it through a combination of Selenium web browser automation and 
> Python scripts exporting into ledger file. It is some scripting work to set 
> it up, but it better serves me as commercial apps.
>
> On Monday, March 22, 2021 at 8:16:24 PM UTC+1 Jin Guu wrote:
>
>> Hello folks,
>>
>> The Ledger workflow has been great. Thanks for all who contributed!
>>
>> There's one last weak point. I find it very cumbersome to pull bank 
>> transactions (csv files) from my bank account manually. If I could let it 
>> be pulled automatically, then I can drop those commercial apps for good. 
>>
>> How would you deal with this aspect? Is there such a way? 
>>
>>
>> Thank you very much!
>>
>> Best,
>> Jin
>>
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/a6e21747-c06e-4ca0-92dc-bcb110b77c2dn%40googlegroups.com.

Re: Feasability of using ledger an co. for small business accounting automation

[Colin Dean]

I've got some custom code in a Sinatra app written in Ruby that's taking 
Stripe webhook posts, transforming them into Ledger records, and submitting 
them as PRs on a GitLab repo. It's slick... when it works. GitLab's "merge 
on successful CI build" doesn't always work and multiple open PRs turn into 
a merge conflict exponential nightmare. The downside is that Stripe doesn't 
seem to include fee information on these posts so I have to go back into 
Stripe once in a while to look up fees. It's not so bad for the ~5-10 txns 
per month I see normally but when there are bursts of 40-50 in a month, 
it's another task on the procrastination pile.

Most of my "automation" is using ledger-autosync to *manually* monthly or 
quarterly sync CSVs, etc. I downloaded and cleaned up. I have only one 
financial institution in my life that provides clean CSV output, sigh.

On Tuesday, February 16, 2021 at 7:40:30 AM UTC-5 Tom.PLAA wrote:

> Hello everyone,
>
> I've recently come across ledger and the concept of PTA and I amvery 
> intrigued.
>
> As I am not an experienced programmer nor have a software engineering 
> background, I am eager to see your opinions on how realistic it is to use 
> ledger (or one of its brothers) to help industrialize accounting and/or 
> book-keeping for a small business.
> My idea is roughly to use ledger as the "backend" and find some way to 
> automate most of the data insertions - maybe by parsing bank extracts and 
> automating the "add" function to the main transaction data file (thinking 
> about using it as a single file for all book-keeping now, as suggested in 
> the hledger FAQ).
>
> My main goals for this particular task are:
>
>1. Spend zero money on accounting software and use something I can 
>read the code of;
>2. Minimize manual transaction recording and general book-keeping 
>tasks;
>3. Be able to produce clean reports and export data to give to an 
>accountant (hoping I can strike some deal where an accountant will lower 
>the fees if I provide clean data and reduce their worload).
>
> As this been done, and if so, how feasible is it to maintain?
>
> Is ledger a good choice for the tasks mentioned above, or is hledger (or 
> another project) better suited for this?
>
>
> Thank you for the attention,
>
> Tomás
>
>
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/cca73f98-00f3-4e73-b3eb-c85d1ea9c835n%40googlegroups.com.

Re: Looking for syntax highlighting in KDE XML format

[Colin Dean]

Looks really cool. I'll keep an eye on it!

On Wednesday, November 18, 2020 at 10:58:22 PM UTC-5 luka.b...@gmail.com 
wrote:

>
> Hi,
> a bit longer answer:)
>
> The short term plan is to make it support our use-cases really well + if 
> we get any suggestions or wishes from other users. 
> Then, the longer term depends a bit on the feedback from the community, 
> whether there is interest or not. My plan is to make it into a powerful 
> accounting tool, combining the CLI+Text, with graphical capabilities and 
> help of IDE. So in the future it has some chance to grow its user base out 
> of programmers who are forced to do finances/accounting, more towards 
> accountants and non-programmers, while still keeping the full CLI appeal.
>
> At the moment I use it as a main personal finance tool, and a backup 
> accounting tool for my company, so I can quickly do my own reports and 
> decisions based on the finances, without the need to wait for the 
> accounting department to give me insights. I find it really useful for this 
> task and this is what made me write the plugin, to make it easier and 
> faster to maintain a ledger copy of the financial data.
>
> Currently it does:
> - Syntax highlighting [dates must be 2020/11/22
> - Accounts autocomplete
> - Marks invoices that are unpaid, and over the payment deadline
> - Marks uncleared, but not over the deadline transactions
>
> Short term plan/need:
> - Add the rest of date formats
> - Autocomplete for tags
> - "Jump to definition", and "find usages/references" for tags and codes
> - Ctrl+click jumping for tags/references/codes/dates where there is 1 
> possible resolution
> - "report views", where a pane or window in IDE shows real-time view of 
> the user's custom given "report command", i.e.: "ledger bal ^Expenses -p 
> 2020"
> - copy-paste translation from TSV/Som EU/Slo + bank of America banks, 
> where paste into IDE converts to ledger format, in a similar way as 
> IntelliJ converts Java into Kotlin. We need this because some banks lack 
> proper secure APIs to do automatic export
> - generate PDF invoices from ledger transactions
> - live documentation helper/ledger hints
>
> Longer term:
> - automate PDF invoicing + sending for recurring invoices such as monthly 
> maintenance
> - proper bank data import
> - sync with main accounting system
> - graphs
> - Graphical IDE windows for reports
>
> Something in this direction. Of course now this is on a slow track, as 
> it's not our company's main activity, but because I found it a very fun and 
> engaging task I add it to the market, to see whether there is any interest.
> On Thursday, November 19, 2020 at 12:34:11 AM UTC+1 c...@cad.cx wrote:
>
>> That's really neat, Luka. What are your plans for that plugin?
>>
>> On Wednesday, November 18, 2020 at 9:51:21 AM UTC-5 luka.b...@gmail.com 
>> wrote:
>>
>>> Hi, we just created a first version of one for IntelliJ:
>>>
>>> https://plugins.jetbrains.com/plugin/15405-ledger-cli
>>>
>>> On Tuesday, July 14, 2020 at 3:05:51 AM UTC+2 c...@cad.cx wrote:
>>>
 I've not been able to find a ledger syntax highlighting file in KDE XML 
 format. I'd really like one. I'm willing to pay commission on it, perhaps 
 $50 USD to the first person who provides one to me and posts here.

>>>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/a224cbc7-7626-4513-b3f9-f2c39e104a18n%40googlegroups.com.

Re: Looking for syntax highlighting in KDE XML format

[Colin Dean]

That's really neat, Luka. What are your plans for that plugin?

On Wednesday, November 18, 2020 at 9:51:21 AM UTC-5 luka.b...@gmail.com 
wrote:

> Hi, we just created a first version of one for IntelliJ:
>
> https://plugins.jetbrains.com/plugin/15405-ledger-cli
>
> On Tuesday, July 14, 2020 at 3:05:51 AM UTC+2 c...@cad.cx wrote:
>
>> I've not been able to find a ledger syntax highlighting file in KDE XML 
>> format. I'd really like one. I'm willing to pay commission on it, perhaps 
>> $50 USD to the first person who provides one to me and posts here.
>>
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/acb2b531-8359-45b2-9b84-04992d20a08en%40googlegroups.com.

Re: Need help just getting started

[Colin Dean]

I'll be conducting an online workshop on July 24, 2020 for Codeland 
Conference.

https://codelandconf.com/workshops/colin-dean/

I'll publish my materials afterward. They're technically already online but 
buried in a repo. I'll put them in their own repo within a couple of weeks 
after.

On Friday, July 17, 2020 at 3:37:30 PM UTC-4, Oliver Hardy wrote:
>
> The fact that other people have actually figured out how to use this 
> program makes me hang my head in shame.
>
> If someone can point me to where in the man pages it describes how to 
> create a journal I would be grateful. Also how does one create accounts, 
> add entries
> etc.
>
> Thank you
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/857dbb11-ed5f-4a29-be89-d3fba2ed8368o%40googlegroups.com.

Re: Looking for syntax highlighting in KDE XML format

[Colin Dean]

I've not been able to find a ledger syntax highlighting file in KDE XML 
format. I'd really like one. I'm willing to pay commission on it, perhaps 
$50 USD to the first person who provides one to me and posts here.

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/99a60174-ab9e-4c97-bfa0-f30210edf5e8o%40googlegroups.com.

Looking for syntax highlighting in KDE XML format

[Colin Dean]

Hey all,

I'm building a workshop around Ledger. I'm using Pandoc to build the 
materials. I'd really like it to highlight the syntax of the ledger 
examples I'm using in the documents I'm producing. Pandoc predictably 
doesn't have ledger format already available as a syntax highlighting 
language. It can take KDE XML syntax definitions at build time, though (
https://pandoc.org/MANUAL.html#option--syntax-definition).

I found a nice repository of them in the skylighting repository at 
https://github.com/jgm/skylighting/tree/master/skylighting-core/xml but I 
think these are the definitions baked into Pandoc (same author).

Does anyone have a syntax highlighting definition for ledger in KDE XML 
format? 

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/2ee91b36-5526-41ca-8627-75c90dad67ddo%40googlegroups.com.

Re: print removes commodity directive

[Colin Dean]

Second thought, it's not. Using 

ledger -f 2020.ledger print -S d --raw > 2020-s.ledger

still dropped the commodity directive.

On Tuesday, June 16, 2020 at 1:32:14 PM UTC-4, Colin Dean wrote:
>
> Thanks, it looks like --raw is what I want.
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/d039c79f-ef49-45a0-a8be-bc34df1bd50ao%40googlegroups.com.

Re: print removes commodity directive

[Colin Dean]

Thanks, it looks like --raw is what I want.

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/0cd00389-e0a1-472a-8343-8039383fe743o%40googlegroups.com.

print removes commodity directive

[Colin Dean]

I’m updating my finances for the first time in a while starting afresh: a
whole new transaction record.

Something I’ve somehow never hit before: My workflow is to append the
output of ledger-autosync to my tx record, make adjustments, categorize,
commit, then sort and format using ledger print. What I’m noticing is that
my commodity directive is getting stripped.

$ cat test.ledger
commodity USD
  alias $
  format 1,000.00

2020/06/16 Test
  Expenses$56
  Assets  -56 USD


$ ledger -f test.ledger bal
 -56 USD  Assets
  56 USD  Expenses

   0

$ ledger -f test.ledger print
2020/06/16 Test
Expenses  56 USD
Assets

This is making is hard to intermix $ and USD, as ledger-autosync mixes the
two outputs depending on the converter in use and I tend to use USD when I
do things manually.

Is there a way to disable removing the commodity? I understand that ‘print’
is supposed to output the most space-efficient representation of the tx
log, but it’s annoying to have to re-add the commodity directive every time
I sort.




-- 
Colin Dean
http://cad.cx

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/CAOWNMOviT3crSYE1wxuVSKL1qhNCO2STkiUwam0cn%2B-9_E88qQ%40mail.gmail.com.

Re: Ledger register history to Sankey diagrams?

[Colin Dean]

A better example in my use case would be something like this:

Available [90] Offered
Offered [70] Owed
Offered [20] Refused
Owed [70] Issued
Issued [3] Canceled
Issued [67] Attendance Verified
Available [10] Unused

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/8f1eb34b-49a5-49ca-a019-42ecc777cee2%40googlegroups.com.

Ledger register history to Sankey diagrams?

[Colin Dean]

Has anyone created a way to easily to Sankey diagrams with Ledger output in 
any way?

https://en.wikipedia.org/wiki/Sankey_diagram

I'm using Ledger's robust commodity support to track conference tickets 
issued to scholarship recipients. I'd like to create a Sankey diagram that 
shows the number of tickets that move through the system. The starting 
state is "Available", then they move through states such as "Offered", 
"Owed", "Issued", "Cancelled", "Attendance Verified".

I'd love to push a button and receive a Sankey diagram that shows the flow 
of tickets through the system but I'm not quite sure of how to approach the 
problem from within the Ledger ecosystem.

I'd be awesome if the output was something that could be input to 
Sankeymatic (http://sankeymatic.com/build/), e.g.

Wages [2000] Budget
Interest [25] Budget
Budget [500] Taxes
Budget [450] Housing
Budget [310] Food
Budget [205] Transportation
Budget [400] Health Care
Budget [160] Other Necessities

but anything that I could massage into a format like this would be great.

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/b4db8266-f161-43ec-a380-0733a58fc422%40googlegroups.com.

Re: Why does the balance assertion fail if the math is right?

[Colin Dean]

I'm using Ledger 3.1.3-20190331 and your example works.

There were some changes to balance assertions that make them work better in 
subsequent versions.  It would likely be worth your time to use a more 
recent version: when I went from 3.1.2 to 3.1.3, my older tx records' BAs 
began to fail. I could trust that they _were_ working, so I could remove 
them or use the flag that turns them off (--permissive, iirc) when 
interacting with those records' files. I upgraded at a year boundary and 
simply sealed off my old records with an opening balances transaction.

On Thursday, August 1, 2019 at 6:10:59 AM UTC-4, Paulo Phagula wrote:
>
> Hi,
>
> I'm using Ledger 3.1.2-20160801 in Ubuntu 18.04. Its on the screenshot.
>
> Cheers
>
> On Wednesday, July 31, 2019 at 8:43:08 PM UTC+2, Robin Johnson wrote:
>>
>> On Fri, Jul 26, 2019 at 10:21:04AM -0700, Paulo Phagula wrote: 
>> > While parsing file "/home/phagulap/Dropbox/financials/minimal.ledger", 
>> line 
>> > 9: While parsing posting: Assets:Banks:MPESA850 MT-1500.00 = MT4225.00 
>> > ^ Error: Balance assertion off by MT-10.00 (expected to see 
>> > MT4235.00) [1] 23522 exit 1 ledger -f minimal.ledger 
>> > 
>> > Does this mean I have to post the fees independently for ledger to 
>> > understand? 
>> Exactly what version of Ledger are you using? Your reduced example works 
>> fine on Ledger 3.1.2. 
>>
>> $ ledger -f minimal.ledger bal 
>>MT4225.00  Assets:Banks:MPESA850 
>>   MT-5735.00  Equity:Opening Balances 
>>MT1510.00  Expenses 
>>  MT10.00Banks:Fees 
>>MT1500.00Food:Bananas 
>>  
>>0 
>>
>> -- 
>> Robin Hugh Johnson 
>> Gentoo Linux: Dev, Infra Lead, Foundation Treasurer 
>> E-Mail   : rob...@gentoo.org 
>> GnuPG FP : 11ACBA4F 4778E3F6 E4EDF38E B27B944E 34884E85 
>> GnuPG FP : 7D0B3CEB E9B85B1F 825BCECF EE05E6F6 A48F6136 
>>
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/37af315d-4100-4dab-8102-e70124b8c499%40googlegroups.com.

Adding Ledger format to Rouge

[Colin Dean]

Hey all,

A while ago, I started on implementing a lexer for Ledger format in Rouge,
a syntax highlighting library written in Ruby. Notably, Rouge is used in
Gitlab.

I've not had any time to pick up where I left off a while ago.

Is anyone interested in continuing my work?

https://github.com/rouge-ruby/rouge/issues/766


--
Colin Dean
http://cad.cx

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/CAOWNMOtipf6n_J0XLB12e9jGUcECz6HQzSS89vhj2QVUJRAnXw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [ANNOUNCE] ledger 3.1.2

[Colin Dean]

I'm excited! Thanks for your hard work, all of you!

On Tuesday, February 5, 2019 at 7:44:39 PM UTC-5, Martin Michlmayr wrote:
>
> We're happy to announce the release of ledger 3.1.2. 
>
> Please see docs/NEWS for a list of changes. 
>
> I have to add a disclaimer up front.  We're releasing with two known 
> failures in the test suite, which obviously isn't great (The org 
> command doesn't give the right output: #1706; and the order of --lots 
> is not reliable: #1747).  I believe both have been exhibited by 
> changes in the toolchain and are also present in 3.1.1, so I don't 
> want to delay the release even more.  If someone can look at the bugs 
> and submit fixes, we can release a 3.1.3 soon. 
>
> This release addresses a number of potential security issues that have 
> been assigned CVEs (Common Vulnerabilities and Exposures, see 
> <https://cve.mitre.org/>).  Thanks to Gwan Yeong Kim and Cory 
> Duplantis for reporting these issues. 
>
> We'd like to thank the following people who contributed fixes and 
> enhancements to ledger 3.1.2: 
>
>   * Aaron Lindsay 
>   * Alexander Pletnev 
>   * Alexandre Rademaker 
>   * Alexis Hildebrandt 
>   * Andreas Hilboll 
>   * Andrew Savinykh 
>   * Atheriel 
>   * Austin Wise 
>   * Bradley M. Kuhn 
>   * Bruno Sutic 
>   * Christoph Dittmann 
>   * Colin Dean 
>   * Craig Earls 
>   * Craig Marshall 
>   * DJ Edmonson 
>   * Daniel Mueller 
>   * Daniele Nicolodi 
>   * Denis 
>   * Eduardo Elias 
>   * Elaina Martineau 
>   * Evan Mallory 
>   * Georg J.P. Link 
>   * Gerhard Poul 
>   * Gina White 
>   * Gonzalo Rizzo 
>   * Gunnar Andersson 
>   * Ismaël Bouya 
>   * Ivan Vanyushkin 
>   * Ivy Foster 
>   * Jakob Demler 
>   * Jan Beich 
>   * Jim Kalafut 
>   * Johannes Loher 
>   * John Lee 
>   * John Wiegley 
>   * Jonas Bernoulli 
>   * Jonas Meurer 
>   * Kyle Fuller 
>   * Manuel Amador (Rudd-O) 
>   * Martin Michlmayr 
>   * Michael Budde 
>   * Mitchell Kember 
>   * Naga Kiran 
>   * Narsimham Chelluri 
>   * Pascal Fleury 
>   * Paulo Flabiano Smorigo 
>   * Peter Feigl 
>   * Peter Pickford 
>   * Rémi Vanicat 
>   * Scott Carpenter 
>   * Sebastian Christ 
>   * Steven R. Baker 
>   * Tim Landscheidt 
>   * Tommi Komulainen 
>   * Vishesh Handa 
>   * myq 
>   * smr894 
>   * thdox 
>   * Øyvind A. Holm 
>
> Of course, we'd also like to thank everyone who submitted bug reports 
> as well as all users of ledger. 
>
> Martin Michlmayr and John Wiegley 
>
> -- 
> Martin Michlmayr 
> https://www.cyrius.com/ 
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Backup and cloud-storage

[Colin Dean]

I'm using Git like others but using Keybase's encrypted git hosting for it.

https://keybase.io/blog/encrypted-git-for-everyone

On Saturday, February 2, 2019 at 5:51:09 AM UTC-5, Dániel Fancsali wrote:
>
> Good morning fellow ledger-lovers,
>
> I was just making slight changes to the layout of my journal files, and 
> adjusting my workflow accordingly, and realised, I got to the point, where 
> I have invested way to much time into this to be able to re-do it, in case 
> my laptop would go missing – or the data would be destroyed/lost for any 
> other reason.
>
> Long story short, I was just wondering, what others do to back-up their 
> work? Do you use version control? Do you back-up to a cloud storage; or 
> even sync it to multiple machines? What about encryption?
>
> Please let us know!
>
> Regards,
> Dan
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Auto-Download CSV

[Colin Dean]

This sounds really great. Would you mind sharing your Docs API code?

On Tuesday, October 16, 2018 at 6:58:13 AM UTC-4, Peter Keen wrote:
>
> I use Tiller. It’s a paid service that dumps transactions from all of my 
> accounts (without account numbers) into Google Docs, and then I use the 
> Docs API to pull transactions directly into ledger format. 
>
> https://www.tillerhq.com
>
>
> On Tue, Oct 16, 2018 at 3:21 AM Matthew Sewell  > wrote:
>
>> I wrote a custom script to download csv files from my banks. It’s written 
>> in python with Selenium. I have it running on a cron job daily. It 
>> downloads then runs it through Reckon to add the transactions to my ledger 
>> file and then it emails me reports. It’s fairly simple to do with basic 
>> python knowledge.
>>
>> Matt Sewell
>>
>> -- 
>>
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "Ledger" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to ledger-cli+...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Confusing Balance assertions

[Colin Dean]

Running your original snippet under 3.1.1-20160111 from Homebrew, it passes.

Running under HEAD of next branch, it fails.

If I add "CHF" to the 0 assertions, it passes.

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Advanced reporting

[Colin Dean]

So far, most of my needs for reporting have been satisfied by simple 
balance reporting, sometimes with some custom formatting.

For some more advanced stuff, I've got a Ruby script that captures the 
output of a few ledger balance reports and then runs some further 
calculations. For example, I want to sum the total expenses of a few 
accounts, half of the expenses of another few accounts, and then some more 
complex logic for some others. Is there a way to do this within ledger?

Next up, I want to try to calculate my savings rate. Is there something 
that would let me effectively capture the output of two balance reports? 
E.g. ledger bal --start "Jan 1" (Assets / (Income - Expenses:Taxes))

I'm working up in my head some kind of wrapper around ledger that would let 
me define simple and complex reports in some kind of manifest format and 
then dump that output to a nice-looking report. I've kinda already cobbled 
something together for the non-profit for which I use ledger, but I want to 
refactor it into something more maintainable than a 1000 line Makefile ;-)

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Bugzilla bugs are on GitHub now

[Colin Dean]

Thanks for your hard work!

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: How to use ledger-cli in a Rust project? (A rust GTK ledger desktop app)

[Colin Dean]

I've been closely watching for someone to start making ledger-cli bindings 
for Rust. I investigated doing it myself and reasoned that it would be a 
very large undertaking that would likely involve significant changes to the 
C++ code to accommodate the port. Most of the work would be around 
implementing a C-only interface to much of ledger-cli, then writing the 
bindings in Rust. This would probably be several dozen hours of work.

Frankly, it would seem "easier" to start ledger-cli in console mode as a 
background process. The Rust program would then feed it commands on its 
STDIN and parse the output on STDOUT. ledger-cli has an xml output mode but 
that's mostly for dumping resolved transaction data. You could probably 
make the output more parseable using the --display-format option crafted to 
output something that serde can parse easily (JSON, most likely).

The quest for a good GUI for reporting led me to Scala-based Abandon 
initially, but I've since switched to ledger-cli + ledger2beancount + fava.

On Sunday, April 29, 2018 at 9:45:18 AM UTC-4, adrian...@gmail.com wrote:
>
> I am trying to create a rust GTK ledger desktop app. I love ledger 
> simplicity and flexibility, and the fact that everything is stored in a 
> simple, readable text file. But I want to keep some reports and operations 
> handy, and I think a GTK desktop app will be perfect for that.
>
> I want to practise with Rust so I think this is a good opportunity for me. 
> The GTK rust app is progressing, but I haven't been successful on calling 
> ledger-cli from rust, since I want to use the original ledger-cli project 
> for maximum compatibility. People working with rust told me it would be 
> very difficult to create good bindings with a C++ app, and the only 
> alternative I have then is to embed the compiled ledger binary and call it 
> directly, but I wouldn't like to do that.
>
> Is there any good ledger-cli port to Rust? Or some good ledger-cli 
> bindings for Rust? I haven't been able to find any of those.
>
> Any advice on how to achieve this? Thanks a lot.
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: New to Ledger: am I budgeting correctly?

[Colin Dean]

On Tuesday, February 13, 2018 at 3:26:36 AM UTC-5, Lifepillar wrote:
>
>
> I haven't tried your example, but what about: 
>
> ~ Monthly since 2018/02/01 until 2018/02/28 
>
> (The end might have to be 2018/03/01, I don't remember if intervals are 
> right-open.) 
>
> In my experience, using since/until is the most reliable way to define 
> budgets within a bounded time period. 
>

So I got the same output as ~Monthly with ~ Monthly since 2018/02/01 until 
2018/03/02 . 

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Time = Money ...exploring the relationship between the two concepts

[Colin Dean]

On Tuesday, February 6, 2018 at 6:58:40 AM UTC-5, Ajoeibin wrote:
>
> If all time must have value then joy in life has been dropped from the 
> equation. 
> Without joy or beauty, for its own sake, then time is only value and value 
> does 
> not nourish all parts of the person.
>

 I think I feel the same. There seems to be a time to "tighten the belt" 
and observe for a short duration and merely as an experiment the time that 
one spends accomplishing tasks that they would otherwise prefer to pay 
someone else to do.

This is especially true if one is in a position where an hour spent working 
is money gained. A software engineer contractor is a good example. A 
contractor can bill for work at any hour of the day. If the contractor can 
bill $100/hr and pay someone $15/hr to mow their lawn, it is a financially 
wise decision to contract out that unpleasant task!

But I think for the average person, thinking about time this way should be 
left in the abstract or napkin math. It seems to lead down a path of 
obsessiveness.

… says the person who logs every financial transaction he makes, manual and 
automated. LOL.

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Future budgets ignored in time-limited forecasting?

[Colin Dean]

>
> > What's up here? Did I find a bug or am I doing something wrong? 
>
> Did you find out more on this one? Would be interesting to know the 
> solution here. 


I have not yet arrived at a solution. I'd welcome input!

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Outputting note associated with accounts

[Colin Dean]

On Thu, 25 Jan 2018 at 08:17 John Wiegley  wrote:

> Should be about a half-hour's work to code, test, and add a test to the
> test
> suite. No documentation needed.
>

I would like to give this a go :-) I might even have time to look at it
tonight.

Thanks, I’d appreciate it. I’m still pretty lost in Ledger’s codebase.

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Outputting note associated with accounts

[Colin Dean]

>>>>> "CD" == Colin Dean <colind...@gmail.com> writes:

CD> Is there a quick way to make the accounts command also output the note
for
CD> each account if I’ve defined the accounts using the account directive?

I don't believe that's currently possible with the 'accounts' report just
now.
No reason why --prepend-format '%(note)' shouldn't work there too, though.

No dice.

$ cat reports/test.ledger
account Assets:Bank
  note My bank account

2018-01-25 Test
  Assets:Bank   30.00 USD
  Equity:OpeningBalances
$ ledger -f reports/test.ledger accounts
Assets:Bank
Equity:OpeningBalances
$ ledger -f reports/test.ledger accounts --prepend-format '%(note)'
Assets:Bank
Equity:OpeningBalances


What would it take for accounts to have an option that did this?

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Forcing output of timekeeping in one unit with --amount-data or --total-data

[Colin Dean]

That's close enough! I can do the math to make it hours with awk:

ledger -f "$(t timelog)" reg --daily --no-total --base -j | awk '{print $1
" " $2/3600}'

Thanks! Now, to figure out how to make gnuplot's output not look so…
spartan.

Colin Dean
http://cad.cx

On Wed, Jan 24, 2018 at 7:16 PM, Clément Pit-Claudel <cpitclau...@gmail.com>
wrote:

> On 2018-01-24 18:37, Jim Robinson wrote:
> > I'm very interested in the answer to this, I was just poking around in
> the documentation trying to see if this was addressed an unable to spot it
> on my first pass.
> >
> > I was looking to see if I could either always produce minutes, or
> produce " h  m" instead of fractional hours.
>
> Did you try --base?
>
> - Added --base reporting option, for reporting convertible commodities
>   in their most basic form.  For example, if you read a timeclock file
>   with Ledger, the time values are reported as hour and minutes --
>   whichever is the most compact form.  But with --base, Ledger reports
>   only in seconds.
>
> ---
> 2017/01/01 * Client 1
> A  5m
> B  7m
> C
>
> 2017/01/02 * Client 2
> A  5h
> B  5h
> C
> ---
>
> $ ledger -f test.ledger --daily --base reg
>
> 2017-01-01 - 2017-01-01 A  300s
>  300s
> B  420s
>  720s
> C -720s
> 0
> 2017-01-02 - 2017-01-02 A18000s
>  18000s
> B18000s
>  36000s
> C   -36000s
> 0
>
> $ ledger -f test.ledger --daily --amount-data --base reg
>
> 2017-01-01 300
> 2017-01-01 420
> 2017-01-01 -720
> 2017-01-02 18000
> 2017-01-02 18000
> 2017-01-02 -36000
>
> Clément.
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Forcing output of timekeeping in one unit with --amount-data or --total-data

[Colin Dean]

I'm attempting to output timekeeping data with the intention of graphing it.

$ ledger -f "$(t timelog)" reg -p 'this week' --daily
18-Jan-22 - 18-Jan-22   (N:Development)   8.19h8.19h
(N:Email) 15.0m8.44h
(N:Meeting:Development)   30.0m8.94h
(N:Meeting:Development:Standup)   30.8m9.45h
(N:TimeTracking)   2.1m9.49h
18-Jan-23 - 18-Jan-23   (N:Development)   4.46h   13.94h
(N:Development:CodeReview)1.44h   15.38h
(N:Meeting:Development:Pairing)   20.8m   15.73h
(N:Meeting:Development:Product)   29.0m   16.21h
(N:Meeting:Development:Standup)   24.1m   16.62h
(N:Meeting:Recruiting:Interview)  1.28h   17.90h
(N:TimeTracking)   7.0m   18.02h
18-Jan-24 - 18-Jan-24   (N:Development)   47.0m   18.80h
(N:Email)  8.1m   18.93h
(N:Meeting:Development:Standup)   30.0m   19.43h
(N:Recruiting)2.25h   21.68h
(N:TimeTracking)   1.0m   21.70h

is turning into

$ ledger -f "$(t timelog)" reg -p 'this week' --daily --amount-data
2018-01-22 8.188611
2018-01-22 15
2018-01-22 30
2018-01-22 30.78
2018-01-22 2.05
2018-01-23 4.458889
2018-01-23 1.439722
2018-01-23 20.816667
2018-01-23 29
2018-01-23 24.05
2018-01-23 1.28
2018-01-23 7
2018-01-24 47
2018-01-24 7.9
2018-01-24 30
2018-01-24 2.25
2018-01-24 1

It's pretty clear from looking at this that the *units* are not the same.
Some events are outputting as minutes while others are in hours. I've tried
adding --exchange s after running commodities on the file and seeing that.
Adding the exchange option changes the specificity of some of the values
but it does not change the output units.

It seems from the section on Commodity equivalences
<https://www.ledger-cli.org/3.0/doc/ledger3.html#Commodity-equivalences>
that I should be able to do this somehow. Any ideas?

--
Colin Dean
http://cad.cx

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Outputting note associated with accounts

[Colin Dean]

Is there a quick way to make the accounts command also output the note for
each account if I’ve defined the accounts using the account directive?



-- 
Colin Dean

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Tools for visualizing timekeeping mode

[Colin Dean]

In addition to using Ledger to track my finances, I've been using it at 
work to track my time using its timekeeping mode 
.

Are any of you aware of existing software or queries to ledger that I could 
use to produce such software that can help me visualize the data?

I'm looking for these kinds of graphs:

* Sunburst showing account tree
* Pie chart showing selected accounts
* Flame graph or bar chart with bar per day broken into components of day

I appreciate any pointers.

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Future budgets ignored in time-limited forecasting?

[Colin Dean]

I'm trying to capture budgets that change over time. It may start with 
simply a ~ Monthly transaction but, over time, I want to "retire" old 
budget amounts as well as document future budget changes, e.g. stepped 
payment plans on rent, student loans, etc.

I had something like this in test.ledger, but ended up reducing it down to 
just this when I found that my future budgets were simply ignored:

~ Monthly
  Expenses:Rent:Office700.00 USD
  Assets

~ Monthly from 2018-01-01
  Expenses:Rent:Expansion 2100.00 USD
  Assets

~ Monthly from 2019-07-01
  Expenses:Rent:Expansion 500.00 USD
  Assets

~ Monthly from 2020-02-01
  Expenses:Rent:Expansion 500.00 USD
  Assets

When I run 

ledger -f test.ledger --forecast "d<[2021-02-01]" register 

I expect to see a 700.00 USD transaction for December 2017, a 2800.00 USD 
transaction (or total) for January 2018, 3300.00 USD total starting July 
2019, and so on. Instead, I only see the result of the first budget 
transaction, the 700.00 USD monthly.

 https://groups.google.com/forum/#!topic/ledger-cli/nu5t9dFOOH4 led me to 
believe that I need to actually include some transactions with the account 
in order to make it appear. I ditched the second account and made some 
other changes, such as setting explicit dates on the budget items:

~ Monthly until 2021-02-28
  Expenses:Rent:Office700.00 USD
  Assets

~ Monthly from 2018-01-01 until 2021-02-28
  Expenses:Rent:Office 2100.00 USD
  Assets

~ Monthly from 2019-07-01 until 2021-02-28
  Expenses:Rent:Office 500.00 USD
  Assets

~ Monthly from 2020-02-01 until 2021-02-28
  Expenses:Rent:Office 500.00 USD
  Assets

2017-12-01 Rent
  Expenses:Rent:Office700.00 USD
  Expenses:Rent:Expansion   0.00 USD
  Assets

but ledger still disregards the other monthly budget transactions when 
executing the same command,

ledger -f test.ledger --forecast "d<[2021-02-01]" register 

What am I doing wrong? This is a powerful feature that I know I've probably 
got something slightly off.

Here's an example output appending --yearly --columns 80 to the above in 
order to keep this message a little shorter.

17-Jan-01 - 17-Dec-31   Assets  -700.00 USD  
-700.00 USD
Expenses:Rent:Office 700.00 USD
0
18-Jan-01 - 18-Dec-31   Assets -8400.00 USD 
-8400.00 USD
Expenses:Rent:Office8400.00 USD
0
19-Jan-01 - 19-Dec-31   Assets -8400.00 USD 
-8400.00 USD
Expenses:Rent:Office8400.00 USD
0
20-Jan-01 - 20-Dec-31   Assets -8400.00 USD 
-8400.00 USD
Expenses:Rent:Office8400.00 USD
0
21-Jan-01 - 21-Dec-31   Assets -1400.00 USD 
-1400.00 USD
Expenses:Rent:Office1400.00 USD
0

2017 is correct but 2018 should be 33600.00 USD, 2019 should be 36600.00 
USD, 2020 should be 37200.00 USD, and 2021 should be 6200.00 USD.

If I add something like this *after* the first budget transaction:

~ Monthly
  Expenses:Accountant999.00 USD
  Assets

It will show up in the forecast. If I put a *from* or *since *date spec on 
the budget transaction, it won't. If I put an *until *or* to *on it, it 
does get included.

What's up here? Did I find a bug or am I doing something wrong?

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Using Ledger as a time tracking system?

[Colin Dean]

You have no idea how happy this makes me.

Thanks, folks. I've found the right tool! For multiple jobs! 

-- 
Colin Dean
http://cad.cx


On Monday, April 8, 2013 at 3:29 PM, thierry wrote:

 $ ledger --daily register 
 13-Apr-05 - 13-Apr-05   (CustomerA:Email)  5.0m 5.0m
 (CustomerB:Config)1.42h1.50h
 ..ntelligent comment])30.0m2.00h
 (Personal:Lunch)  1.50h3.50h
 (Personal:Walk)   30.0m4.00h
 
 -- 
  
 --- 
 You received this message because you are subscribed to a topic in the Google 
 Groups Ledger group.
 To unsubscribe from this topic, visit 
 https://groups.google.com/d/topic/ledger-cli/XVR4t1B-XFI/unsubscribe?hl=en.
 To unsubscribe from this group and all its topics, send an email to 
 ledger-cli+unsubscr...@googlegroups.com 
 (mailto:ledger-cli+unsubscr...@googlegroups.com).
 For more options, visit https://groups.google.com/groups/opt_out.
  
  

-- 

--- 
You received this message because you are subscribed to the Google Groups 
Ledger group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Using Ledger as a time tracking system?

[Colin Dean]

Having some good documentation would make this a lot easier to understand. 
I messed around with it a little last night, but I'm getting caught up on 
the options because I don't know ledger's options very well yet. 

[colin@kid tmp]$ cat time.ledger
i 2013/04/05 09:30:00 Internal:Meeting:Tactical [Intelligent comment]
o 2013/04/05 10:00:00
i 2013/04/05 10:00:00 CustomerA:Email
o 2013/04/05 10:05:00
i 2013/04/05 10:05:00 CustomerB:Config
o 2013/04/05 11:30:00
i 2013/04/05 11:30:00 Personal:Walk
o 2013/04/05 12:00:00
i 2013/04/05 12:00:00 Personal:Lunch
o 2013/04/05 13:30:00
[colin@kid tmp]$ ledger -f time.ledger  print
2013/04/05 ()
(Internal:Meeting:Tactical [Intelligent comment])   1800s

2013/04/05 ()
(CustomerA:Email)   300s

2013/04/05 ()
(CustomerB:Config) 5100s

2013/04/05 ()
(Personal:Walk)1800s

2013/04/05 ()
(Personal:Lunch)   5400s

I'd like for the output to be grouped by day and the time in hours rounded 
to one decimal place.

-- 

--- 
You received this message because you are subscribed to the Google Groups 
Ledger group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Using Ledger as a time tracking system?

[Colin Dean]

I'm admittedly very new to Ledger, using it for the past month or so to 
track finances for my Bitcoin trading. The multi-currency support is great! 
I'm still learning how to take advantage of the capital gains features, 
though.

At my day job, our great time tracking system is going away. It's being 
replaced with an antiquated time tracking system the use of which is 
mandated by the corporation which acquired my we love to use slick web 
apps startup employer. We are not required to log our time daily and 
there's not automated means for populating time into this old system.

Has anyone used Ledger as a means for tracking time?

I envision using it something like this:

2013/04/02 daily time
  CustomerName:Billable:Development55 min
  Internal:Meeting 1 hr
  Other:Lunch  5 min
  Time

I would set up a pricesdb that says that 1 hr = 60 min, plus some other 
conveniences (1 day = 8 hr, etc.).

Weekly, I run a report that that starts at the beginning of the week and 
ends at the end of the week, with the output commodity as hr. This 
absolves me of having to convert minutes to hours in my head!

 The Time account would indicate a negative amount, the absolute value of 
which is how many hours I logged that week. This should generally be 40. 
The other accounts would tell me how much time I spent per customer.

I could also run monthly and yearly reports to see how much time I've spend 
on a certain customer or task.

Thoughts?
  

-- 

--- 
You received this message because you are subscribed to the Google Groups 
Ledger group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Using Ledger as a time tracking system?

[Colin Dean]

I'm admittedly very new to Ledger, using it for the past month or so to 
track finances for my Bitcoin trading. The multi-currency support is great! 
I'm still learning how to take advantage of the capital gains features, 
though.

At my day job, our great time tracking system is going away. It's being 
replaced with an antiquated time tracking system the use of which is 
mandated by the corporation which acquired my we love to use slick web 
apps startup employer. We are not required to log our time daily and 
there's not automated means for populating time into this old system.

Has anyone used Ledger as a means for tracking time?

I envision using it something like this:

2013/04/02 daily time
  CustomerName:Billable:Development55 min
  Internal:Meeting 1 hr
  Other:Lunch  5 min
  Time

I would set up a pricesdb that says that 1 hr = 60 min, plus some other 
conveniences (1 day = 8 hr, etc.).

Weekly, I run a report that that starts at the beginning of the week and 
ends at the end of the week, with the output commodity as hr. This 
absolves me of having to convert minutes to hours in my head!

 The Time account would indicate a negative amount, the absolute value of 
which is how many hours I logged that week. This should generally be 40. 
The other accounts would tell me how much time I spent per customer.

I could also run monthly and yearly reports to see how much time I've spend 
on a certain customer or task.

Thoughts?
  

-- 

--- 
You received this message because you are subscribed to the Google Groups 
Ledger group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.