All of the transactions to openai are now priced in $ only. How many Rs you
used to pay them is irrelevant to them.
$ ledger -f vedang2.txt reg "openai" | cat
23-Jul-18 OpenAI Invoice liabili:vendors:openai $ -14.83 $
-14.83
23-Jul-24 OpenAI Payment Rece.. liabili:vendors:openai $ 14.83
0
23-Aug-08 OpenAI Invoice liabili:vendors:openai $ -0.79 $
-0.79
23-Aug-15 OpenAI Payment Rece.. liabili:vendors:openai $ 0.79
0
23-Sep-13 OpenAI Invoice liabili:vendors:openai $ -10.67 $
-10.67
23-Oct-03 OpenAI Payment Rece.. liabili:vendors:openai $ 10.67
0
All of the currency conversions now take place in the credit card.
$ ledger -f vedang2.txt reg icici | cat
23-Jul-24 OpenAI Payment Rece.. liabilities:card:icici $ -14.83 $
-14.83
23-Jul-24 Currency Conversion liabilities:card:icici Rs -1267.82 $
-14.83
Rs
-1267.82
liabilities:card:icici $ 14.83 Rs
-1267.82
23-Aug-15 OpenAI Payment Rece.. liabilities:card:icici $ -0.79 $
-0.79
Rs
-1267.82
23-Aug-15 Currency Conversion liabilities:card:icici Rs -68.36 $
-0.79
Rs
-1336.18
liabilities:card:icici $ 0.79 Rs
-1336.18
23-Oct-03 OpenAI Payment Rece.. liabilities:card:icici $ -10.67 $
-10.67
Rs
-1336.18
23-Oct-03 Currency Conversion liabilities:card:icici Rs -924.11 $
-10.67
Rs
-2260.29
liabilities:card:icici $ 10.67 Rs
-2260.29
(this report shows the balances in the icici card after each transaction in
both currencies).
Running `ledger -X Rs reg` shows that commodity revaluations still occur
because it is trying to convert everything into Rs but the exchange rates
are different each time you make a payment. I personally stick with the
simpler reports because the more complicated a report, the more
unpredictable it is.
On Tuesday, February 6, 2024 at 10:22:20 AM UTC+8 Vedang wrote:
> 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/d31eec90-e5fd-4d37-9773-aaeef62897d5n%40googlegroups.com.
