* Stefano Zacchiroli <[email protected]> [2014-05-20 11:59]:
> So, do you have a way to automatically check that, for each expense
> report, your employee has actually reimbursed you the exact amount
> you've asked for? (It doesn't always happen with my employer, and when
> it doesn't I want to subsequently record a Income:Reimbursement gain /
> Expense:Reimbursement loss --- but I need a way to spot that first!)
It's not automatic, but I can run an easy query:
ledger -f 2014 --effective --sort d reg receivable:xxx and tag
2014-03-21-boston-libreplanet
When I receive the reimbursement, the figure should go to zero. If
it stays > 0, you'd just account for this Expense:Reimbursement loss.
When I update the ledger file for my bank account, I see a payment
coming in from my employer. Based on the amount and time, I will know
whether it's a reimbursement or my salary. If it's a reimbursement,
I can look up with the query above if the amount matches (fortunately,
I don't have the same issue above - if my expert report is approved, I
get the correct figure).
And then you do:
2014-05-08 * Reimbursement for HP EEM TER 10216952
; :2014-04-28-hp-expenses:
; :HP:EEM:TER10216952:
Assets:Current:NatWest 67.05 GBP
Assets:Receivable:HP
In your case, if the money was off, it would be:
2014-05-08 * Reimbursement for ...
; :some-tag:
Assets:Bank 70.00 EUR
Expense:Reimbursement loss 10.00 EUR ;
employer rejected taxi
Assets:Receivable:Employer -80.00 EUR
As an aside, one of my future projects is to add account, commodity
and tag directives, so I can use --explicit --pedantic. I'll
therefore change
; :HP:EEM:TER10216952:
to:
; :HP:
; EEM: TER10216952
because I don't want to define every TER* tag (There's a new one for
every expensive report). I just want to say that EEM is a valid tag
and the value has to be ^TER\d+$
> I've a work-flow similar to yours, but the problem I'm facing is that
> the Assets:Reimbursable (or Assets:Receivable FWIW) coalesces together
> all trips, so it's hard to check if a specific trip balances to zero.
I just tag all transactions with a tag that indicates where I store
receipts for that trips. This way, you can easily see what refers to
that trip only:
ledger -f 2014 --effective --sort d reg reimbu and tag
2014-03-21-boston-libreplanet
> As an additional complexity, you might imagine a trip in which you've
> been reimbursed 10$ more, and another in which you've been reimbursed
> 10$ less; they sum up to zero but I'd like to see both of them as
> "errors" instead of concluding that everything is fine up to now.
Just use tags.
--
Martin Michlmayr
http://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 [email protected].
For more options, visit https://groups.google.com/d/optout.
