Thank you! The second approach works for me! I can only see the clearance information in the credit card statement, so I don't have that data immediately after making the payment.
Can you also please explain why the change in representation fixes the problem? Running `ledger -X Rs reg` shows me that Commodity Revaluation is still happening, but I guess the new style of writing transactions pushed the revaluation data to the `liabilities:card:icici` account instead? On Tue, Feb 6, 2024 at 6:12 AM psionl0 <[email protected]> wrote: > > How about modifying the transactions this way? > 2023/07/18 * OpenAI Invoice > liabilities:vendors:openai $ -14.83 > expenses:programming > > 2023/07/24 * OpenAI Payment Receipt > liabilities:card:icici Rs -1267.82 > liabilities:vendors:openai $ 14.83 > > 2023/08/08 * OpenAI Invoice > liabilities:vendors:openai $ -0.79 > expenses:programming > > 2023/08/15 * OpenAI Payment Receipt > liabilities:card:icici Rs -68.36 > liabilities:vendors:openai $ 0.79 > > 2023/09/13 * OpenAI Invoice > liabilities:vendors:openai $ -10.67 > expenses:programming > > 2023/10/03 * OpenAI Payment Receipt > liabilities:card:icici Rs -924.11 > liabilities:vendors:openai $ 10.67 > > Then when you run a balance report you get the following: > $ ledger -f vedang.txt bal | cat > $ 26.29 expenses:programming > Rs -2260.29 liabilities:card:icici > -------------------- > $ 26.29 > Rs -2260.29 > > You can also keep the currency conversions in-card (handy if the clearance > date is different to the payment date) > 2023/07/18 * OpenAI Invoice > liabilities:vendors:openai $ -14.83 > expenses:programming > > 2023/07/24 * OpenAI Payment Receipt > liabilities:card:icici $ -14.83 > liabilities:vendors:openai > > 2023/07/24 * Currency Conversion > liabilities:card:icici Rs -1267.82 > liabilities:card:icici $ 14.83 > > 2023/08/08 * OpenAI Invoice > liabilities:vendors:openai $ -0.79 > expenses:programming > > 2023/08/15 * OpenAI Payment Receipt > liabilities:card:icici $ -0.79 > liabilities:vendors:openai > > 2023/08/15 * Currency Conversion > liabilities:card:icici Rs -68.36 > liabilities:card:icici $ 0.79 > > 2023/09/13 * OpenAI Invoice > liabilities:vendors:openai $ -10.67 > expenses:programming > > 2023/10/03 * OpenAI Payment Receipt > liabilities:card:icici $ -10.67 > liabilities:vendors:openai > > 2023/10/03 * Currency Conversion > liabilities:card:icici Rs -924.11 > liabilities:card:icici $ 10.67 > > > $ ledger -f vedang2.txt bal | cat > $ 26.29 expenses:programming > Rs -2260.29 liabilities:card:icici > -------------------- > $ 26.29 > Rs -2260.29 > On Monday, February 5, 2024 at 5:57:26 PM UTC+8 Vedang Manerikar wrote: >> >> Hello All, >> >> This is the first time I am posting, so if this question is already answered >> previously, I'm sorry for the noise and please direct me to it. I did some >> searching but could not find it. >> >> I live in India and the default currency I want to see reports in is Rs >> (Rupees). Payments to international service providers happens in $, and then >> on my credit card statement I see the actual amount I was charged in Rupees. >> Here are some example transactions: >> >> 2023/07/18 * OpenAI Invoice >> liabilities:vendors:openai $ -14.83 >> expenses:programming >> >> 2023/07/24 * OpenAI Payment Receipt >> liabilities:card:icici $ -14.83 @@ Rs 1267.82 >> liabilities:vendors:openai >> >> 2023/08/08 * OpenAI Invoice >> liabilities:vendors:openai $ -0.79 >> expenses:programming >> >> 2023/08/15 * OpenAI Payment Receipt >> liabilities:card:icici $ -0.79 @@ Rs 68.36 >> liabilities:vendors:openai >> >> 2023/09/13 * OpenAI Invoice >> liabilities:vendors:openai $ -10.67 >> expenses:programming >> >> 2023/10/03 * OpenAI Payment Receipt >> liabilities:card:icici $ -10.67 @@ Rs 924.11 >> liabilities:vendors:openai >> >> Here, OpenAI sends me an invoice in $, I make the payment on my credit card >> in $, and then I look at the credit card statement to see how much I was >> actually charged in Rs by the bank and note that amount down. >> >> The problem is that I'd like `ledger -X Rs bal liabilities:vendors:openai` >> to show that I owe 0 Rs to pay back to OpenAI, but it does not do so due to >> the fluctuating $ price. >> >> How do I do this? >> >> I've read the commodities and lot-prices sections of the manual, but perhaps >> I didn't understand them correctly. The changing rate of the $ is important >> information that I want to capture, but it's equally important that the >> liabilities:vendors account be balanced properly. >> >> Thanks, >> Vedang > > -- > > --- > 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/PjqvqTL52s0/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/ledger-cli/abddc688-26e7-406c-ab9f-869161d04fccn%40googlegroups.com. -- Cheers, Vedang https://vedang.me @vedang on fosstodon.org -- --- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/CABzEscb-%3D0bBCkeiQxPWEX7%3Dnaa4sQMGyJ7EdjmEzQYBL%3DFkeg%40mail.gmail.com.
