Currency excange and balancing
Hi, everybody. I have a problem or misunderstanding with currency exchange. Assume that I have a bank account in Russian rubles (my primary currency): 2017-05-10 Opening balances Assets:Checking:RUB 1,000.00 RUB Equity:RUB And now I want to buy some dollars and have them on my dollars checking account: 2017-05-11 Buy some dollars Assets:Checking:USD 10.00 USD @ 55.00 RUB Assets:Checking:RUB Now, if I run balance report I get this: 450.00 RUB 10.00 USD Assets:Checking 450.00 RUBRUB 10.00 USDUSD -1,000.00 RUB Equity:RUB -550.00 RUB 10.00 USD It looks weird. Why these 450 RUB on the first line of the report is not under any account? Why "Assets:Checking" sum is 10 USD? I feel like I miss something and do it wrong. Can you explain me why my report is balanced this way and how should I deal with several bank accounts using different currencies? Thank you. -- --- 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 ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Can I use the date in typed metadata to generate an automated posting?
I like to handle clearing by splitting my account into :cleared and :uncleared subaccounts. This is simpler and more consistent than the traditional way of doing things, but it also creates more work, unless you can automate it. Can ledger automate it? Here’s an example. After a trip to McDonalds, I add this to my journal: year 2017 05/25 McDonald’s expenses:food and drink:fast food £ -0.99 assets:current account:uncleared £ 0.99 When the payment transaction clears, on the 27th, I add these three lines to the transaction: assets:current account:uncleared £ -0.99 ; [05/27] assets:current account:cleared£ 0.99 ; [05/27] This works, but it adds a lot of extra lines to the file. I would much prefer it if I could just add a note saying that the transaction cleared on the 27th: 05/25 McDonald’s expenses:food and drink:fast food £ -0.99 assets:current account:uncleared £ 0.99 ; cleared:: [05/27] and rely on an automation rule to read the metadata and generate the postings I need. Is this possible? -- --- 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 ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Can I specify a default currency?
Is there a way to set a default currency / commodity? Something like this: year 2017 currency £ 05/29 Asda ; No commodity / currency specified, so default to £ expenses:groceries -5.37 liabilities:credit card 5.37 (Typing £ signs on a Japanese keyboard gets old fast.) The D directive does something similar to what I want, but it only affects xact transactions. -- --- 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 ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: I want to convert my GnuCash file to a ledger-cli file
On 05/28/2017 03:23 PM, John Wiegley wrote: >> "SB" == Segundo Bob writes: > SB> But so far as I can tell, I have not yet produced an executable ledger > SB> 2.6.3. > > After a 'make' there should be a 'ledger' binary somewhere within your build > tree, and you should be able to run it directly from there, although you may > have to change LD_LIBRARY_PATH to point at where the .so lives. Thanks. I used "git status" to show me the files produced by the make--without looking into .gitignore which happens to tell git to ignore almost all the files produced by make. Then I did some finds, but not the right find. Anyway, the following command line executes ledger 2.6.3 on my system: LD_LIBRARY_PATH='/pri/git/Ledger4/2.6.3/ledger-2.6.3/.libs' '/pri/git/Ledger4/2.6.3/ledger-2.6.3/ledger' And I have produced an 8,441 line ledger file from my GnuCash file with the following command: LD_LIBRARY_PATH='/pri/git/Ledger4/2.6.3/ledger-2.6.3/.libs' '/pri/git/Ledger4/2.6.3/ledger-2.6.3/ledger' -f '/pri/git/Ledger4/2.6.3/ledger-2.6.3/data/joint' print > journal.txt Take away my boneheaded mistakes, and this was easy. Thanks. You are a super programmer, John Wiegley. -- Segundo Bob segundo...@earthlink.net -- --- 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 ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: I want to convert my GnuCash file to a ledger-cli file
> "SB" == Segundo Bob writes: SB> But so far as I can tell, I have not yet produced an executable ledger SB> 2.6.3. After a 'make' there should be a 'ledger' binary somewhere within your build tree, and you should be able to run it directly from there, although you may have to change LD_LIBRARY_PATH to point at where the .so lives. -- John Wiegley GPG fingerprint = 4710 CF98 AF9B 327B B80F http://newartisans.com 60E1 46C4 BD1A 7AC1 4BA2 -- --- 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 ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: I want to convert my GnuCash file to a ledger-cli file
On 05/27/2017 08:52 PM, John Wiegley wrote: > These errors sound like you don't have autoconf, automake, and libtool > installed. Thank you. I had autoconf and automake installed. I installed libtool. This got me a little farther. But what I really needed to do was run ./autogen.sh. So now I've successfully run: ./configure make But so far as I can tell, I have not yet produced an executable ledger 2.6.3. I expect running "make install" would produce an executable ledger 2.6.3, but I haven't dared to do this because I don't want to destroy my currently working ledger 3.1.1. For some time, I will have to repeatedly import GnuCash files and use ledger 3.1.1 to generate reports. I don't want the 2.6.3 emacs related files at all. I believe what I want is exactly two 2.6.3 files: /usr/bin/ledger and either /usr/lib/ledger/libledger.so.2 if /usr/lib/ledger.so is not an ELF or /usr/lib/ledger/libledger.so If this is an ELF Is there a reasonable way to generate these files without destroying my current ledger 3.1.1 installation? If not, can I install 2.6.3, copy the files I want to a safe place, and then re-install 3.1.1? I noticed that the make file contains a lot of uninstall code. Is this known to work? Should I uninstall 2.6.3? Is there any way to run 2.6.3 and 3.1.1 on the same operating system? How do I make the ledger 2.6.3 use the 2.6.3 version of libledger, instead of the installed 3.1.1 libledger? I hope this isn't too many questions at once. -- Segundo Bob segundo...@earthlink.net -- --- 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 ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Trying to get Ledger to not Collapse for Single sub totals
* James [2017-05-28 08:08]: > Also does Ledger do a T based accounting report ? Maybe --dc does what you want. -- 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 ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Trying to get Ledger to not Collapse for Single sub totals
Also does Ledger do a T based accounting report ? On Sunday, May 28, 2017 at 12:14:15 AM UTC+8, James wrote: > > Hi, > How do I get ledger to not collapse at single subtotal headings? > Appreciate if someone could help with this. > > Thanks > > -- --- 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 ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Trying to get Ledger to not Collapse for Single sub totals
Hi, So for example I run the bal command I get Expenses:Food in my report because there is no hierarchal branches. Is there a way to make ledger make a branch even tho its only 1 item/category? Like the below:- Expenses Food I hope I am making sense here. On Sunday, May 28, 2017 at 12:14:15 AM UTC+8, James wrote: > > Hi, > How do I get ledger to not collapse at single subtotal headings? > Appreciate if someone could help with this. > > Thanks > > -- --- 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 ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.