Thanks, Martin. I'll take a look. David
On Tuesday, June 2, 2015 at 4:08:04 PM UTC-4, Martin Blais wrote: > > See this similar discussion: > https://groups.google.com/d/msg/ledger-cli/rrSewPJ_qn8/QjblyrC75q8J > > Source code from the original thread is here: > > https://bitbucket.org/blais/beancount/src/ebf90c52ea37f29b3ed460a6af748cb5b792b587/src/python/beancount/plugins/tag_pending.py?at=unicode > > You could riff on this code and build something that works for you, > possibly using Ledger's Python API even. Personally I would extent it with > a heuristic that attempts to match up the transactions if not explicitly > linked together in the input file. > > > > On Tue, Jun 2, 2015 at 12:54 PM, David Sklar <[email protected] > <javascript:>> wrote: > >> A report wrangling question: how to concisely display my list of bills to >> pay? >> >> When I receive a bill on May 1 due May 27 I create a transaction such as >> this: >> >> 2015/05/01=2015/05/27 The Telephone Company >> Liabilities:Bills:The Telephone Company >> Expenses:Communication $34.21 >> >> Then when I pay the bill from my checking account I create a transaction >> such as this: >> >> 2015/05/10 The Telephone Company >> Liabilities:Bills:The Telephone Company $34.21 >> Assets:Checking >> >> This works swell and I use the following little bash script to display >> upcoming bills I need to pay: >> >> for bill in $(ledger bal --flat --no-total Liabilities:Bills | awk >> '{print $2}') >> do >> ledger reg --aux-date $bill >> done >> >> It finds each account under Liabilities:Bills with a balance, then prints >> the register for those accounts, telling me the amount due and when it's >> due (the aux date). >> >> My problem is that I would like to restrict the final output to only the >> outstanding amounts (whatever their date), excluding paid bills. As it is >> now, I get things like this: >> >> 15-May-06 PhoneCo Liabilit:Bills:PhoneCo $28.91 >> $28.91 >> 15-May-11 PhoneCo Liabilit:Bills:PhoneCo >> $-28.91 0 >> 15-Jun-10 PhoneCo Liabilit:Bills:PhoneCo $-28.63 >> $-28.63 >> >> Showing my previous month's bill being entered and paid, and then this >> month's bill outstanding. >> >> I could just display the latest-date transaction for each account, which >> would mostly work, but then i would lose information if there were two >> bills due at a time, or an old one hadn't been paid for some reason. >> >> Any thoughts on a good way to accomplish this? Have something that goes >> through and pairs up old transactions (by payee/acct and amount) and >> applies some "paid bill" tag to them so the final report excludes such >> transactions? Some kind of filter on the final report that can find the >> most recent date the balance was 0 and exclude everything before that? >> Something else? >> >> Thanks, >> David >> >> >> >> >> -- >> >> --- >> 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 [email protected] <javascript:>. >> 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
