Hi,
I noticed a weird behaviour when doing a 'reg' on a multi-currency
file (Mexican peso, Guatemalan quetzal and usd). I'm using ledger v.
2.6.2 in Ubuntu linux, 64 bit. Here is my command:
ledger -w -f multicurrency.ledger -V reg payable:jlopez
Here is my output:
2008/05/29 jlopez airfare to Guatemala
co:liabilities:payable:jlopez:cash
$-133.82 $-133.82
2008/05/30 jlopez dinner in Churrasco Centro..
co:liabilities:payable:jlopez:cash
$-50.43 $-184.25
2008/05/31 jlopez dinner in Churrasco Centro..
co:liabilities:payable:jlopez:cash
$-138.44 $-322.69
2008/06/09 Check 1004 - travel expenses reim..
co:liabilities:payable:jlopez:cash
$335.00 $12.31
2008/07/03 jlopez airfare to Guadalajara, Me..
co:liabilities:payable:jlopez:cash
$-347.26 $-334.95
2008/07/06 jlopez meal with prospective clie..
co:liabilities:payable:jlopez:cash
$-112.55 $-447.49
2009/07/06 Check 1012
co:liabilities:payable:jlopez:cash
$614.99 $167.50
2009/07/13 jlopez meal at Bistro Cheney, Mex..
co:liabilities:payable:jlopez:cash
$-27.90 $130.40
2009/07/15 Car Gas
co:liabilities:payable:jlopez:cash
$-30.00 $100.40
2009/07/20 Car Gas
co:liabilities:payable:jlopez:cash
$-8.22 $225.57
2009/07/20 jlopez parking in Mexico, DF
co:liabilities:payable:jlopez:cash
$-1.49 $224.07
The problem is in the second-to-the-last line where the balance goes
from 100.40 to 225.57 with an expense of 8.22 (225.57 instead of
92.18).
Here is my simplified multicurrency.ledger file (105 lines):
;begin of file
----------------------------------------------------------------
;jlopez business trip to Guatemala to visit Grupo Azteca and Dr. Lara
{{{
;with 7.0 qzl per 1 dollar:
P 2008/05/29 qzl $0.142857142857143
2008/05/29 * jlopez airfare to Guatemala
jlopez:assets:reimbursables:plankor
$133.82
jlopez:assets:checking
$-133.82
company:expenses:travel:airfare:jlopez
$133.82
company:liabilities:payable:jlopez:cash
$-133.82
; receipts available
2008/05/30 * jlopez dinner in Churrasco Centroamericano, SA.,
Guatemala
jlopez:assets:reimbursables:plankor
353.00 qzl
jlopez:assets:checking
-353.00 qzl
company:expenses:travel:meals:jlopez
353.00 qzl
company:liabilities:payable:jlopez:cash
-353.00 qzl
; receipts available
2008/05/31 * jlopez dinner in Churrasco Centroamericano, SA.,
Guatemala
jlopez:assets:reimbursables:plankor
969.10 qzl
jlopez:assets:checking
-969.10 qzl
company:expenses:travel:meals:jlopez
969.10 qzl
company:liabilities:payable:jlopez:cash
-969.10 qzl
; receipts available
2008/06/09 * Check 1004 - travel expenses reimbursement to jlopez
jlopez:assets:checking
$335.00
jlopez:assets:reimbursables:plankor
$-335.00
company:liabilities:payable:jlopez:cash
$335.00
company:assets:accounts:checking:bofa
$-335.00
; receipts available
;; bofa-check transaction type: withdraw
;; bofa-check md5: 84ee2140132d30a1567f09fc20a29a0b
;}}}
;July
;jlopez trip to Guadalajara to present product to CIAJ and Confitexpo
{{{
; 10.20 mxn = $1
P 2008/07/03 mxn $0.0980392156862745
2008/07/03 * jlopez airfare to Guadalajara, Mexico (round trip)
jlopez:assets:reimbursables:plankor
3542.01 mxn
jlopez:assets:checking
-3542.01 mxn
company:expenses:travel:airfare:jlopez
3542.01 mxn
company:liabilities:payable:jlopez:cash
-3542.01 mxn
; receipts available
2008/07/06 * jlopez meal with prospective clients at "La Campana Roja,
S de RL de CV", Guadalajara, Mexico
jlopez:assets:reimbursables:plankor
1148.00 mxn
jlopez:assets:checking
-1148.00 mxn
company:expenses:travel:meals:jlopez
1148.00 mxn
company:liabilities:payable:jlopez:cash
-1148.00 mxn
; receipts available
;}}}
;==============================================================================
;2009
;jlopez trip to Mexico City {{{
; $1 usd = 13.5758, from www.sat.gob.mx
2009/07/06 * Check 1012
jlopez:assets:checking
$614.99
jlopez:assets:reimbursables:plankor
$-614.99
company:liabilities:payable:jlopez:cash
$614.99
company:assets:accounts:checking:bofa
$-614.99
;; bofa-check transaction type: withdraw
;; bofa-check md5: bfba1cb366010b18d96ce0bec736559e
; $1 usd = 13.2724, from www.sat.gob.mx
; changed during testing
P 2009/07/08 mxn $0.1
2009/07/13 * jlopez meal at Bistro Cheney, Mexico, DF
jlopez:assets:reimbursables:plankor
279.00 mxn
jlopez:assets:checking
-279.00 mxn
company:expenses:travel:meals:jlopez
279.00 mxn
company:liabilities:payable:jlopez:cash
-279.00 mxn
; receipt available
2009/07/14 * STARBUCKS TLACOQUEMEC
company:expenses:travel:meals:jlopez
$7.25
company:liabilities:debt:creditcard:bofa:jlopez
;; bofa-visa post date: 2009/07/16
;; bofa-visa transaction type: withdraw
;; bofa-visa md5: 54bdac1bf829ce86d9188e8a22c87388
2009/07/15 * Car Gas
jlopez:assets:reimbursables:plankor
300.00 mxn
jlopez:assets:checking
-300.00 mxn
company:expenses:travel:car:gas:jlopez
300.00 mxn
company:liabilities:payable:jlopez:cash
-300.00 mxn
;receipt available
; $1 usd = 13.3895, from www.sat.gob.mx
P 2009/07/20 mxn $0.074685387
2009/07/20 * Car Gas
jlopez:assets:reimbursables:plankor
110.00 mxn
jlopez:assets:checking
-110.00 mxn
company:expenses:travel:car:gas:jlopez
110.00 mxn
company:liabilities:payable:jlopez:cash
-110.00 mxn
;receipt available
2009/07/20 * jlopez parking in Mexico, DF
jlopez:assets:reimbursables:plankor
20.00 mxn
jlopez:assets:checking
-20.00 mxn
company:expenses:travel:parking:jlopez
20.00 mxn
company:liabilities:payable:jlopez:cash
-20.00 mxn
; receipt available
;end of file ------------------------------------------------------
Thanks,
Javier
