gmane.comp.finance.ledger.general

Re: manual cleanup

John Wiegley — 2008-11-25T21:28:57

On Nov 25, 2008, at 3:36 PM, Simon Michael wrote: Cool, the command I needed was: git remote add -f simon http://joyful.com/repos/ledger/.git I didn't realize you had a repository with a working tree up there. John

Re: manual cleanup

Simon Michael — 2008-11-25T19:36:06

John Wiegley wrote: Done!

Re: manual cleanup

John Wiegley — 2008-11-24T03:39:45

On Nov 23, 2008, at 8:36 AM, Simon Michael wrote: In order for me to access it via HTTP, you have to run "git update- server-info" in that repository. You should then also run it in the post-update hook. John

ANN: hledger 0.2 released

Simon Michael — 2008-11-23T22:46:22

hledger is a minimal haskell clone of John Wiegley's "ledger" text-based accounting tool (http://newartisans.com/software/ledger.html). hledger generates ledger-compatible register & balance reports from a plain text ledger file, and demonstrates a functional implementation of ledger. For more information, see the hledger home page: http://joyful.com/hledger INSTALLATION ------------ If you have cabal-install, do:: cabal install hledger otherwise, unpack http://hackage.haskell.org/packages/archive/hledger/0.2/hledger-0.2.tar.gz and do:: runhaskell Setup.hs configure runhaskell Setup.hs build sudo runhaskell Setup.hs install (or for the latest code, darcs get http://joyful.com/repos/hledger) NEWS ---- * fixes * fix balance report totals when filtering by account * fix balance report selection of accounts when filtering by account * fix a bug with account name eliding in balance report * if we happen to be showing a not-yet-auto-balanced entry, hide the AUTO marker * fix print command filtering by account * omit transactions with zero amount from register report * Fix bug in parsing of timelogs * rename --showsubs to --subtotal, like ledger * drop --usage flag * don't require quickcheck * features * priced amounts (eg "10h < at > $50") and --basis/--cost/-B flag to show them with cost basis * easy --depth option, equivalent to c++ ledger's -d 'l<=N' * smarter y/m/d date parsing for -b and -e (any number of digits, month and day default to 1, separator can be / - or .) * -n flag for balance command * --empty/-E flag * build a library, as well as the exe * new home page url (http://joyful.com/hledger) * publish html and pdf versions of README * detect display preferences for each commodity like c++ ledger * support amounts with multiple currencies/commodities * support --real/-R flag * support -C/--cleared flag to filter by entry status (not transaction status) * support virtual and balanced virtual transactions * parse comment lines beginning with a space, as from M-; in emacs ledger-mode * allow any non-whitespace in account names, perhaps avoiding misleading missing amounts errors * clearer error message when we can't balance an entry * when we fail because of more than one missing amount in an entry, show the full entry * document the built-in test runner in --help * add a --verbose/-v flag, use it to show more test-running detail * includes 43 tests Contributors: * Simon Michael * Tim Docker

manual cleanup

Simon Michael — 2008-11-23T12:36:20

Hey John, all, I have a hard time finding my way around the ledger manual, except by searching the one-page html version. I had some energy tonight and ended up learning enough git and Texinfo to be dangerous, and reorganised the manual a bit. I think it's more linear now. It starts with the Introduction. (An action-packed Getting Started might be better, but the current content is more Introduction.) It then gives the overview and reference for all the commands and options (Using Ledger). It might seem odd to put this here but I feel the rest is so involved that it's better to learn early on what exactly the tool does and then get into the details of using it. Next there's the Ledger Tutorial (the old Usage Overview). And finally, all the other topics form an ever-growing "Ledger in Practice" chapter. current version: http://joyful.com/repos/ledger/doc/ledger/ new version: http://joyful.com/repos/ledger/doc/ledger-sm/ git repo (I think this works ?): http://joyful.com/repos/ledger Feedback welcome!

example balance sheet report

Simon Michael — 2008-11-20T22:07:56

I'm working on reports which my accountant can recognise. Here's my latest balance sheet script, for anyone interested. I'd like to see what other folk are using. #!/bin/sh # balancesheet [extraoptions] echo "Balance sheet as of `date`" echo "totals include sub-accounts" echo ledger -nE --balance-format '%10T %2_%-a\n' --display "l<=2" --basis --subtotal $* balance assets echo ledger -nE --balance-format '%10T %2_%-a\n' --display "l<=2" --basis --subtotal $* balance liabilities echo ledger -nE --balance-format '%10T %2_%-a\n' --display "l<=4" --basis --subtotal $* balance equity echo echo "`ledger --balance-format '%10T %2_%-a\n' --basis $* balance liabilities equity | tail -1`liabilities + equity" echo ledger --balance-format '%10T %2_%-a\n' --basis $* balance assets liabilities equity | tail -2

BUG? --prices-db not performing tilde expansion in .ledgerrc

2008-11-10T10:38:14

It seems that the --priced-db option in .ledgerrc does not perform tilde expansion on the filename specified, and so does not update the prices database file. For example, if my .ledgerrc file reads --file ~/docs/ledger/ledger.dat --price-db ~/docs/ledger/prices.dat and I issue the command ledger -QV bal . then I notice that my prices.dat file is not updated. However, if I specify an absolute path in .ledgerrc: --file ~/docs/ledger/ledger.dat --price-db /Users/mcarter/docs/ledger/prices.dat and issue the command, then prices.dat is properly updated.

Re: getquote-uk.py

2008-11-08T14:26:48

On Nov 6, 11:41 pm, "Mark Carter" public.gmane.org> wrote: Actually, I'm wrong. If you enclose it in quotes, it's OK, as in "GSK.L" . It also solves the problem I encountered with OEICS, which had digits in their code. Looking through the source code, I discovered that < at >< at > can be used to specify the total cost of a commodity - very handy!

Re: getquote-uk.py

Mark Carter — 2008-11-07T22:03:34

On 7 Nov 2008, at 7:37, John Wiegley wrote: Thanks John. I had written my own accounting package using python - but I have grown dissatisfied with it - it's very kludgy and inflexible. I have been looking around for alternatives, and had considered lots of things, none of which really measured up. GnuCash has a nice UI, but doesn't support the kind of reports I am interested in. Its data file is hopelessly complicated, as too is its programming. Sql-ledger seemed both too heavyweight for what I need and lacked some specific features I am interested in. This brought me back to Ledger. I had played with it before, but over the last couple of days I decided to give it a more intensive workout. So far, it looks like it will be a useful replacement for me. The good thing about Ledger is that it is an accounting program that seems to be closer to the UNIX philosophy than others. It would be nice if it stays that way, I have been able to adapt the quote-getter because of this - and I hope to provide some IRR calcs in the near future, too. Stay tuned. You might like to know that I dedicated a webpage to Ledger: http://mcarter.myzen.co.uk/ledger/ledger.htm It's just a skeleton page at the moment, but I hope to provide some tutorials on getting to grips with equities, and a cookbook of recipes. Although I have Ledger compiling fine on Ubuntu, I have yet to get it to compile on OS X ... something about boost_regex. No doubt with time, and plenty of chicken blood, I'll sort out what the problem is. In the meantime, I would like to thank you for your efforts in producing Ledger. Regards, Mark.

Re: getquote-uk.py

John Wiegley — 2008-11-07T19:37:09

On Nov 7, 2008, at 10:41 AM, Mark Carter wrote: By default, Ledger attempts to get prices for all currencies which you might be trying to report. To stop it from asking for a price for £, put the line "N £" in your ledger file. This means "do not ever ask for quotes for this commodity". John

Re: getquote-uk.py

Mark Carter — 2008-11-07T14:41:43

getquote-uk.py

Mark Carter — 2008-11-06T23:41:35

Re: Emacs mode bug: sort moves the ledger-mode header

John Wiegley — 2008-11-04T02:38:40

On Nov 3, 2008, at 9:20 PM, Steve Hicks wrote: This needs to be fixed. For now, just mark the range of the file which contains only entries (with M-SPC), and then use C-x n n to narrow the region. Now sort, and after using C-x n w to widen the file back. John

Emacs mode bug: sort moves the ledger-mode header

Steve Hicks — 2008-11-04T01:20:37

Hi, I put "; -*-ledger-*-" at the top of my ledger file, as suggested in the manual, but then using C-c C-s to sort the entries I find that this gets sorted along with them, and ends up at the bottom of the file. The sorting behaves better if I prepend a space, but then ledger itself doesn't like it. Cheers, steve

Re: Illegal option -Q

John Wiegley — 2008-11-03T00:36:23

On Nov 2, 2008, at 11:30 AM, alt.mcarter-gM/Ye1E23mwN+BqQ9rBEUg< at >public.gmane.org wrote: It just hasn't been restored to functionality yet. John

Illegal option -Q

2008-11-02T15:30:38

I recently compiled the git version of ledger. Am I right in thinking that the option to download equity quotes has been removed?

Re: formulas for mortgage interest etc?

John Wiegley — 2008-11-01T23:37:07

On Nov 1, 2008, at 11:43 AM, David Roundy wrote: This is a very interesting request, and I'll add a task to attempt proper syntax for it. At the moment, a transaction's amount expression can only access the details of the transaction itself and of its parent entry -- but not the balance of accounts, which are not computed during parse-time. I may not ever be able to support this, but I'll give it some more thought. John

formulas for mortgage interest etc?

David Roundy — 2008-11-01T15:43:33

Hello, I've just started experimenting with ledger, and it looks very nice, but I've run into a problem that must be pretty common, but which I can't find an example for in the manual. I'd like to create entries that use a formula to compute the values, which doesn't seem to be supported (but I hope I'm wrong). I imagine something like 11/5 mortgage payment Assets:Checking $-2000 Expenses:Mortgage Interest 0.05*(Liabilities:Mortgage) Expenses:Tax $500 Liabilities:Mortgage So that I could automatically keep track of how much the principle still is on my mortgage. Of course, I could write a script to generate this payment, but I'd rather not bother. Is there a syntax for formulas like this? The closest I could see was the tithing example, but I'd like this to be a real account and a real (non- virtual) transaction. On the other hand, perhaps it wouldn't hurt to allow the Liabilities:Mortgage account to be virtual, since I never directly access it... Is this something others have dealt with, and if so, what do you do? David

Re: Business Logic

Russell Adams — 2008-10-30T19:38:42

On Wed, Oct 29, 2008 at 10:18:58PM -0700, Manish wrote: Glad you enjoyed it. ;] I'll start working up some documentation on it and a sample. My hours aren't typically that complicated. I'm fine with right now entering them into Ledger directly, perhaps later I can look into Org integration. I currently do not use the Org timeclock features. Thanks. ------------------------------------------------------------------ Russell Adams RLAdams-oD4XmFtju8sd7qmyaarJZgC/G2K4zDHf< at >public.gmane.org PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/ Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3

Re: Business Logic

Manish — 2008-10-30T05:18:58

On Oct 24, 9:49am, Russell Adams wrote: > I've been working off and on to integrate basic business logic with > Ledger. I noticed you mentioned that in your Org demo talk. > > So far my main two items have been: > > - Expense Reporting > - For reimbursement > - PDF Report via Latex w/ Scanned images > - Invoicing > - # Hours by project & period > - PDF Invoice > > I have a functional expense reporting system I'll share if anyone is > interested. Yes, please. I would like to see how the system works and see if I can use it too. > > I'd like to solicit some help regarding the invoicing. I'd like to use > accounts in Ledger to track the status of the hours, tie in the > invoice # for reporting, and more. How do you plan to integrate hours clocked in Org with accounts in Ledger? Copying data from clock reports manually or do you have something else in mind? -- Manish

Re: how to show credit card liability when initializing ledger

Michal Wallace — 2008-10-26T22:18:34

Hey there, Your example is almost right, except that the number should be negative. When you pay your credit card from your bank, you want to subtract from the asset account and add to the liability account. So the debt should be a negative number. Also, if you want, you can put all your opening balances in a single entry. (That's my personal preference - it doesn't really matter) -Michal On Sun, Oct 26, 2008 at 4:03 PM, lunatech public.gmane.org> wrote: