I think I must have re-read your email 5 times, I'm still not clear on what you're trying to do. - All your rates are set to 0.70, and after conversion the money is in AUD. - Why are your prices commented out? - Look at the CONVERT() function in the source code, here: https://bitbucket.org/blais/beancount/src/4c79f94e085880bb1d4b469c931435eb246855bf/beancount/query/query_env.py#lines-797 there's a variant which accepts a date. - Absolute worst case scenario you could always write some Python to do this. - Patrick: This looks like a deposit of checks in another currency, not an investment, cost is not the right method here AFAICT, price is correct.
On Sat, Dec 8, 2018 at 7:24 AM <zpet...@gmail.com> wrote: > I have recently started using beancount and fave and hav a question > regarding prices, and if it is possible to keep them within the scope of > the transaction. > > Let's say that we have a set of transactions as follows: > > 2018-09-02 * "Invoice" "1" > Assets:AccountsReceivable:Company 1000 AUD > ; @ 0.70 USD > Income:Company > > 2018-09-09 * "Invoice" "2" > Assets:AccountsReceivable:Company 1200 AUD > ; @ 0.70 USD > Income:Company > > 2018-09-16 * "Invoice" "3" > Assets:AccountsReceivable:Company 900 AUD > ; @ 0.70 USD > Income:Company > > 2018-09-23 * "Invoice" "4" > Assets:AccountsReceivable:Company 1100 AUD > ; @ 0.70 USD > Income:Company > > 2018-09-29 * "Payment Received" "Invoices September 2018" > ; This bank transaction is completed in AUD, but the bank has internally > ; evaluated it with a price that has a conversion rate of @ 0.70 USD > Assets:Country:Bank:AUD > 4180 AUD > Expenses:Financial > 20 AUD > Assets:AccountsReceivable:Company > > Even though bank account will hold AUD, I need to keep track of this > evaluation for every payment, which will reflect on one or more invoices. > The reason for this is that the yearly income threshold is evaluated in > USD, according to the evaluation on the day of the transaction. Thus the > exchange rate is only useful for reporting, so I can check the yearly > income converted to USD. Other than that, the currency should remain AUD. > What would be the best way to keep track of this in beancount? > > I have attempted to use prices, but fava uses only the last price to > evaluate the whole year or month. Also, prices seem to be global, so might > be unintentionally used on other transactions. > > Thanks > > -- > You received this message because you are subscribed to the Google Groups > "Beancount" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to beancount+unsubscr...@googlegroups.com. > To post to this group, send email to beancount@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/beancount/14da09b1-099e-4272-8d73-7f68a04ce664%40googlegroups.com > <https://groups.google.com/d/msgid/beancount/14da09b1-099e-4272-8d73-7f68a04ce664%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to beancount+unsubscr...@googlegroups.com. To post to this group, send email to beancount@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhNJ8LVW1sTSP6duutBJtzuy4BTy9%3DxS6ZUsWjPYUuHDtQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.