Re: Related accounts and running totals

Hi John and all, John Wiegley <jo...@newartisans.com> writes: >>>>>> Richard Lawrence <wyle...@gmail.com> writes: > >> So my question is, is there some way to get a correct running total when >> using --related and limiting to a subset of tran

Re: Related accounts and running totals

John Wiegley <jo...@newartisans.com> writes: >>>>>> Richard Lawrence <wyle...@gmail.com> writes: > >> I think what I'd like to do is limit transactions by the *related* account, >> something like > >> ledger --limit 'related =~ /assets:Me/'

Related accounts and running totals

Hi all, I have a question about related accounts. I'm on ledger 3.1.0. (I also use hledger 0.27, which I'd be happy to employ here if it can answer this question more easily.) Here is my use case: I keep track of expenses shared with a roommate under expenses:shared, and at the end of a given

Re: What to do next

Hi Dee, (Please reply to the list, not just me.) o1bigtenor writes: >>> How do I get back to the # prompt (kill command isn't working)? >> >> Sounds like you are stuck in your pager (e.g., the `less' program). Try >> "q". >> > That works, thank you! > > Is there

Re: What to do next

o1bigtenor writes: > When I use this command: > > ledger balance -f /some/file/20xx.dat > > if things are in balance the last line is: > > (END) > > How do I get back to the # prompt (kill command isn't working)? Sounds like you are stuck in your pager (e.g., the `less'

Re: Question about Automated transactions

Hi Phil, 'Phil Gee' via Ledger writes: > I'm back again with a question. I really, really love what I can do with > automated transactions. However, I run into one problem: Suppose I have a > credit card whose debt I track in Liabilities:CreditCard. Generally its

Re: Feature idea: custom named reports!

Hi Josh, Josh Hanson writes: > Since I don't have every detail of Ledger's syntax memorized, and there are > a few standard reports that I run regularly, I have several ledger command > lines recorded as comments in my journal that I can copy and paste as > needed.

Re: Annual Averages Report

Hi Brian, Brian Exelbierd writes: > I am not seeing a report command line that will give me a list of all > accounts and their average amounts for a given period. > > For example, this will give me one account: > > ledger -f all.ledger --empty register Expense:Food -M --average

Re: Combining within entries in a single posting

Hi Kumar, Kumar Appaiah writes: > Now, I'd like to view a register containing ONLY the total of Incomes. For > example: > > # ledger -f test.dat reg Income > > This will display the Income:Salary and Income:Allowances separately. Is > there a way that I can get them

Reconciling and virtual accounts

Hi everyone, I recently tried to set up "envelope" budgeting, following this guide: https://frdmtoplay.com/envelope-budgeting-with-ledger/ One important aspect of this system is that money is moved from a (real) checking account to a virtual budget account at the start of the budget period, and

Re: Conversion nightmares: gnucash to ledger-cli

Dear Rushad, Rushad Faridi writes: > Firs I tried ledger 2.x approach since 3.x can not do the conversion. I > had not much of a problem installing 2.x but after I issued the command " > ledger -f myfile.gnucash print > myfile.txt" it spitted out 27 lines of >

Re: Opening Balances problem

Hi Filipo, Filipo V writes: Hi all, I'm new to ledger and I'm frustrated I can't figure out what I've done wrong to begin with. Here is part of my file: 2015/05/27 * Opening Balance Assets:BankA:Current 482.40 Equity:Opening Balances Now, when I try to run

Re: Recording real balances in the presence of virtual transactions

Hi John, John Lee writes: However, I guess I can't do this: 2017-10-01 * Opening Balance Assets:CurrentAccount $1000 Equity:OpeningBalances 2017-10-02 * Savings Assets:CurrentAccount:Savings $100 Assets:CurrentAccount Because then if I go on to do this:

Re: Unclear on monthly average balances

Hi Norman, Norman Walsh writes: > I've been happily using ledger-cli for years, but I'm sure I hardly scratch > the surface of what it can do. Every now and then, I get an idea to see if > I can learn to use more of it. Today's thought was "would having a budget > be useful?" > > So I go

Re: how to strip dollar sign in reports

Hi Alan, Alan writes: What's the new way to ask for the amounts as plain, unadorned numbers? Well, I don't know how to do this with ledger, but if you're on some flavor of unix you can always do: ledger (whatever) | tr -d '$' Hope that helps! -- Best, Richard

Re: Cannot get ledger-mode to run properly

Hi Nikolai, Nikolai Stenfors writes: When I invoke ledger mode, M-x ledger-mode, I get the error (translation from Swedish): Searching for program: File or catalog does not exist, ledger This sounds to me like a problem with your PATH. What platform are you

Re: Referring to account in automated transactions

cesar.m...@gmail.com writes: Justin St-Amant writes: Is there a way to refer to the tail-end of the matched account in an automated transaction, using a variable such as '$account_base' or similar? The ledger manual has a section that shows how to refer to the

Re: Monthly balance position

Hi Klauss, Klauss Hass writes: Is there any way to use the argument —monthly or --weekly for bal transactions? I value my assets weekly and it would be useful to see the month ending value variation of my assets:investments accounts along with the -V argument. I don't

Re: Monthly balance position

John Wiegley <jwieg...@gmail.com> writes: "RL" == Richard Lawrence <wyle...@gmail.com> writes: RL> I don't think so, at least not with regular ledger. I'd be happy to be RL> proven wrong, though! I have also wanted this feature. You can use: ledger --gro

Re: Cannot get ledger-mode to run properly

Hi Nikolai, Nikolai Stenfors writes: 1. Debian GNU/Linux 9.3 (stretch), xfce4 2. M-x list-packages, marked ledger-mode, Install 3. PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games No, I cannot find ledger in any of these directories. Ah. Do

Re: Transaction date vs statement date

Budiman Snowman writes: > I want to be able to produce report of monthly expenses as > they are incurred (tuition fee in Aug and doctor visit in Oct) and also > want to record my cash flow (reimburse my wife in Jan). ... > Is there a shorter way, e.g. if ledger lets me put in transaction date

Re: Need Ledger Information

Hi Megha, megha g writes: > That's Great Richard, (Please reply to the whole list, not just to me! That way, the conversation also helps other people getting started.) > it's working fine and i ran few Reports as well. > > 1) How can i create a New journal to my existing project. > > 2) Do i

Re: Need Ledger Information

Dear Megha, megha g writes: > As i am new to this Ledger topic. I am not getting proper idea about > ledger, From where it will run, where i need to do changes in order to get > the ledger output, can anybody please help me out to understand the > details of the ledger. Please guide me.

Re: Income Statement" aka "Profit/Loss Statement" with unrealized gain due to changes in stock and currency exchange rate

Dear Chary, Chary Chary writes: > So, I want to be able to explain a delta between a balance sheet at the > beginning of the ear and at the end. > > E.g.: > > I got so much salary > I paid so much costs > > But also: > Lost so much due to exchange rate change > Gained to much due to

Re: Income Statement" aka "Profit/Loss Statement" with unrealized gain due to changes in stock and currency exchange rate

Hi Chary, Chary Chary writes: > But I can't find any report, which would show me why assets have increased > 2 times. Option --unrealized does not have any effect in this case > > I would expect some report, which would say something like > > -1000 EUR Unrealized gain > -1000 EUR

Re: Income Statement" aka "Profit/Loss Statement" with unrealized gain due to changes in stock and currency exchange rate

Hi Chary and all, Here's a few more thoughts. Chary Chary writes: > ok, thanks, it works indeed! Great! It also works if I run report on > assets all together > > ledger -f ledger.txt bal Assets -X EUR --now 2018-12-31 --unrealized > > But I am just thinking aloud here. > > Unrealized gains

Re: Need Ledger Information

megha g writes: > Thank you for the information. > > 1) And, i am using *Ubuntu *operating system. Great! > 2) Shell is *command prompt.* OK, so your shell is probably bash, then. (Run the command "echo $SHELL" to be sure.) That should be fine. > 3) Path is /home/megha/ledger Hmm. I

Re: Income Statement" aka "Profit/Loss Statement" with unrealized gain due to changes in stock and currency exchange rate

Hi Chary and all, I don't have time for a long reply but here are some quick thoughts: Chary Chary writes: > The approach is quite simple > >1. > >Expenses are tracked at the historical exchange rate (e.i. at the >exchange rate, available during transaction). When exchange

Re: Income Statement" aka "Profit/Loss Statement" with unrealized gain due to changes in stock and currency exchange rate

Hi Chary and all, Chary Chary writes: > Ok, I am not an accountant, so am expressing this from my personal point > of view and personal needs Me too. :) To be honest, I don't approach ledger by thinking in terms of reports. Instead, I just have a bunch of questions I like to ask of my

How does --unrealized work?

Hi everyone, In trying to answer Chary's question, I have realized I do not have a very good grip on how to think about "unrealized" gains and losses, and how ledger calculates them. So I wrote a few test cases to help explain it to myself. (Can you tell I'm procrastinating a little bit? ;) I

Re: Income Statement" aka "Profit/Loss Statement" with unrealized gain due to changes in stock and currency exchange rate

Hi Chary and all, Chary Chary writes: > yes, thanks for your patience. Sorry if I did not express myself correctly > initially. You got me right with small corrections. I want: > > - a single report > > - that shows the change in your assets and Liabilities between two points > in time > > -

Possible bug: Re: How does --unrealized work?

Hi all, I never got a reply, so since it's possible there's a bug here, I thought I would bump this message. Does anyone have any insights about my Example 3? Best, Richard Richard Lawrence writes: > Hi everyone, > > In trying to answer Chary's question, I have realized I do

Re: Backup and cloud-storage

Hi Daniel and all, Dániel Fancsali writes: > Long story short, I was just wondering, what others do to back-up their > work? Do you use version control? Do you back-up to a cloud storage; or > even sync it to multiple machines? What about encryption? I keep my ledger files in a dedicated git

Re: Data Entry GUI - Cashier

Hi Alen and all, Interesting idea! Alen Šiljak writes: > Sure. If there is a quick way of entering transactions on the phone, I'm > all ears! It would save me a lot of time of reinventing the wheel, then. ;) I too would like a better way to capture transactions on my phone when I'm on the

Re: Auto-completion on Tab in Emacs?

Hi Oscar, Oscar writes: > I can't seem to have auto-completion to work when I press tab in > ledger-mode in Emacs . > > Previous versions I never had this problem. Is this a bug? It does indent > but pressing tab doesn't do the autocomplete. This was changed recently; I noticed it too when

Re: Question

o1bigtenor writes: > My record keeping system is a little complex and I have lots of levels > of sub-accounts. As I'm doing my 'do the taxes trick' life would be > quite a bit simpler if I could total the amounts in all the levels of > sub-accounts under a particular account. > > Now

Re: Question

o1bigtenor writes: > On Sun, Dec 22, 2019 at 9:47 AM Richard Lawrence wrote: >> But at least in this case you can fake it with regexps: >> >> ledger reg --limit 'account =~ /9795\.00\.[0-9][0-8]\.(([0-4][0-9])|50)/' >> > Could you possible ex

Retrieving and inserting exchange rates in ledger-mode

Hi all, In case there are ledger-mode users here who might find this useful, I wanted to share a snippet of code I wrote as I was doing my end-of-year journal file tidying. It scrapes the USD-EUR exchange rate from exchange-rates.org for the date of the transaction at point, then enters it as a

Re: Arithmetic

Dan Sladden writes: > Why does this do what I expect: > > 2020/01/01 Works > Assets:Cash(£10*(3 -1)) > Equity > > but this (without the space before the minus sign) doesn't: > > 2020/01/01 Doesn't work > Assets:Cash(£10*(3-1)) > Equity Whoa, strange. I think this is

Re: Feasability of using ledger an co. for small business accounting automation

Tomás de Almeida writes: > I was thinking about doing something very simple and barebones. Akin to > having job that extracts and parses daily transaction reports from the > company's bank account into the main ledger data file. > > I imagine some of the transactions would be easy to automate as

Re: prices & pricedb Reporting Commands

Hi lipp, lipp f writes: > My understanding is that these commands are supposed to somehow show > records from the price database. > > I have tried the following commands > > $ ledger --args-only --price-db prices-db.j -f empty.j pricedb > > $ ledger --args-only --price-db

Re: prices & pricedb Reporting Commands

Hi lipp, lipp f writes: > Thank you for your answer Richard. For me, it makes no difference if I use > a real jurnal or an empty one. Absolutely nothing on the screen. > > Can you please explain what each command does and how are they different? > Maybe to show how you run them, what

include directives in ledger 3.2.1 and ledger-reconcile

Hi everyone, I recently switched from ledger 3.1.22-20190205 (in Debian oldstable) to 3.2.1-20200518 (in GNU Guix) and I'm encountering the following issue. At the top of my ledger file are two include directives: include strict.db include prices.db The two included files are in the same

Re: include directives in ledger 3.2.1 and ledger-reconcile

Hi Colin and all, Colin Dean writes: > I'm using ledger 3.2.1-7build2 from ubuntu impish in the particular records > I'm looking at right now. My includes are using "!include" are relative Thanks, that's good to know. To be clear, ledger itself still seems to read the included files (with