Re: Income Statement" aka "Profit/Loss Statement" with unrealized gain due to changes in stock and currency exchange rate
On Thu, Mar 7, 2019 at 9:16 AM Chary Chary wrote: > > Richard, > > 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 > This report is called 'Net Worth' using GAAP terms. Used by businesses all the time. > > I need to study more all these Leger's options. > It seems to be really powerful tool, but not straightforward. I think to > understand ones needs to know internal data representation of the tool, what > it does and how it presents data internally. > I agree with the first part of your sentence. The second is perhaps not accurate. Excellent accounting information is highly complex. Check out forward cost accounting for product development if you want to have a lot of 'fun'. Often that innate complexity of accounting is what is being reflected by ledger . The logic is simple - - as is that for 'record keeping' but that doesn't mean that the process nor the use is. I find that's why some people get someone else to do this - - - its easier to just use the final reports. (Making sure that these reports are accurate is quite another job though!) Dee -- --- 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: exporting to tabular format
On Thu, Mar 7, 2019 at 8:05 AM Fergus Cameron wrote: > > Ah, yes, that can certainly be a problem. I generally figure out the > reports and run them periodically (weekly, monthly, etc) for us. I > tried scripting them for my partner but I guess they have a management > mentality (I did push them to a html for a while but then I forgot to > keep that up). At least the text output ledger produces is good > enough for us. Grin - - - if she wants to input all the data I would let her loose! My says she would like to but she's also not worried about detail and going back to large scale info only - - - my books are a tool for understanding what where and when I've done/am doing something. > > For the raw data there is an actual 'csv' command. You can use the > various filters with it, I understand. And there's a 'csv-format' > switch too. I don't use it but it's in the docs. I think getting someone to do the info entry will be one of the earlier things I pay for in my business. Entry takes a lot of time its in the using of it that I prefer to spend my effort. Gotta like ledger though - - - so much flexibility and its still very robust!! Dee -- --- 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: Income Statement" aka "Profit/Loss Statement" with unrealized gain due to changes in stock and currency exchange rate
Richard, 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 - grouped into Accounts (line with the balance) command - which includes unrealized gains and losses - where the total reflects the overall change Your proposed command did not really worked for me (generated an error). But this one worked ledger -f ledger.txt reg Assets -X EUR 18-Jan-01 Opening Balance Assets:Checking EUR1000 EUR1000 18-Jul-01 *Commodities revalued* EUR500 EUR1500 So, now ledger shows unrealized gain as *Commodities revalued .* I need to study more all these Leger's options It seems to be really powerful tool, but not straightforward. I think to understand ones needs to know internal data representation of the tool, what it does and how it presents data internally. On Thu, Mar 7, 2019 at 1:18 PM Richard Lawrence wrote: > 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 finances, > some of them regularly, some of them only once in a while. For the > former kind of question, I have a few pre-defined commands. For the > latter kind of question, I usually just figure out how to query ledger > for the information I want on the fly. I don't worry about how the > output looks, as long as it contains the information I'm looking for. > > You seem to be thinking about ledger more in terms of predefined > reports. That's fine! These reports exist, after all, because they're > useful ways of organizing and conceptualizing financial data. But I > would suggest that you might find it more helpful to think in terms of > "What kind of questions do I need ledger to answer?" My experience, > anyway, is that it's usually more straightforward to think in these > terms than in terms of "How can I use ledger to generate report X?" > (mostly because that question gets you thinking more about formatting, > rather than the information itself, and formatting can get complicated). > > If you need reports in a specific format -- e.g. because you are running > a business -- ledger can probably produce them (possibly in combination > with other tools). But I'm not the best person to help with that, > unfortunately. :) > > > I must say though, I have a feeling, that I am still missing something. > I > > just don't understand how people, who do investments, own stock can live > > without such report. Is't it logical to be able to explain a delta in > your > > financial net worth between 2 periods of time? > > > So much salary > > so much expenses > > so much increase due to company XXX shared change > > > > Overall change > > > > Without such report you would look at 2 balance sheet reports (A and B) > but > > would not know how exactly you came from A to B. > > OK, I think I see more clearly what you're looking for now: you want > > - a single report > - that shows the change in your assets between two points in time > - grouped into positive and negative changes (i.e., Income and Expenses) > - which includes unrealized gains and losses > - where the total reflects the overall change > > Is that right? If so, I don't think it's super trivial but I believe it > is possible, so let's figure out how to do it. (Hopefully other people > can chime in here, because as I said, reports are not my strong point.) > > A reasonable first approximation is something like: > > ledger -f your_file reg Assets --group-by='amount < 0' --related -X EUR > > though that doesn't show the total, and has one transaction (rather than > one account) per line. > > -- > Best, > Richard > -- --- 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: exporting to tabular format
On Thu, Mar 7, 2019 at 1:25 AM Alan Schmitt wrote: > > On 2019-03-07 00:07, Fergus Cameron writes: > > > if you consider CSV a tabular format, it can. you can post > > process it > > from there ... although, one would need to understand the final > > result > > to make that a sane suggestion since ledger can generally > > produce the > > answers you need directly. > > CSV would be fine. How do I do that? > > My motivation is that my wife does not use ledger and she wants to > use a > spreadsheet to look at our family expenses. > Might be easier if you gave her a list of commands for ledger. She can look for herself and you don't have to do the extra 'fun'. Dee -- --- 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: 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 finances, some of them regularly, some of them only once in a while. For the former kind of question, I have a few pre-defined commands. For the latter kind of question, I usually just figure out how to query ledger for the information I want on the fly. I don't worry about how the output looks, as long as it contains the information I'm looking for. You seem to be thinking about ledger more in terms of predefined reports. That's fine! These reports exist, after all, because they're useful ways of organizing and conceptualizing financial data. But I would suggest that you might find it more helpful to think in terms of "What kind of questions do I need ledger to answer?" My experience, anyway, is that it's usually more straightforward to think in these terms than in terms of "How can I use ledger to generate report X?" (mostly because that question gets you thinking more about formatting, rather than the information itself, and formatting can get complicated). If you need reports in a specific format -- e.g. because you are running a business -- ledger can probably produce them (possibly in combination with other tools). But I'm not the best person to help with that, unfortunately. :) > I must say though, I have a feeling, that I am still missing something. I > just don't understand how people, who do investments, own stock can live > without such report. Is't it logical to be able to explain a delta in your > financial net worth between 2 periods of time? > So much salary > so much expenses > so much increase due to company XXX shared change > > Overall change > > Without such report you would look at 2 balance sheet reports (A and B) but > would not know how exactly you came from A to B. OK, I think I see more clearly what you're looking for now: you want - a single report - that shows the change in your assets between two points in time - grouped into positive and negative changes (i.e., Income and Expenses) - which includes unrealized gains and losses - where the total reflects the overall change Is that right? If so, I don't think it's super trivial but I believe it is possible, so let's figure out how to do it. (Hopefully other people can chime in here, because as I said, reports are not my strong point.) A reasonable first approximation is something like: ledger -f your_file reg Assets --group-by='amount < 0' --related -X EUR though that doesn't show the total, and has one transaction (rather than one account) per line. -- Best, Richard -- --- 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: Income Statement" aka "Profit/Loss Statement" with unrealized gain due to changes in stock and currency exchange rate
> Here, I don't follow you. (Maybe I don't understand what an "income > statement-like" report is?) > > Ok, I am not an accountant, so am expressing this from my personal point of view and personal needs There are 2 financial reports, which are linked to each other Balance sheet https://en.wikipedia.org/wiki/Balance_sheet It effectively lists Assets and Liabilities. The difference between them shows your net worth. It shows how much you have at a specific moment in time. Since ledger does not have explicit special Balance Sheet report, one can produce something like this by running: ledger -f ledger.txt bal Assets Liabilities Income Statement https://en.wikipedia.org/wiki/Income_statement It shows changes to your finance over period of time. Changes happen due to expenses and incomes. Difference between them shows how much you lost or gained over a period of time. Since ledger does not have explicit special Income statement report, to produce an equivalent report one would need to do: ledger -f ledger.txt bal Income Expenses Now, if one does not do investment and uses only single currency, Income Statement, when run over period of time will show you exactly where the difference between 2 balance sheet reports came from. In another words: Starting Balance Sheet Net Worth + Income statement Net Gain/ Loss = Closing Balance Sheet Net Worth However if you deal with different commodities, this will not work. (See my original example). There is however another report for this. In Financial world it is called *Statement of Comprehensive Income* https://www.investopedia.com/terms/c/comprehensiveincome.asp *Comprehensive income includes net income and unrealized income, such as unrealized gains/losses on hedge/derivative financial instruments and foreign currency transaction gains/losses. Comprehensive income provides a holistic view of a company's income not fully captured on the income statement.* Here is example https://www.myaccountingcourse.com/financial-statements/images/other-comprehensive-income-statement-example.jpg I referenced investopedia just to show, that what I am looking for is not something strange. Originally I was just looking for some report to provide a delta between 2 of my balances sheets reports. Ledger is able to show unrealized gains, however it also pulls Assets in the same report. But I do not want assets to be shown on the same report together with unrealized gains. I must say though, I have a feeling, that I am still missing something. I just don't understand how people, who do investments, own stock can live without such report. Is't it logical to be able to explain a delta in your financial net worth between 2 periods of time? So much salary so much expenses so much increase due to company XXX shared change Overall change Without such report you would look at 2 balance sheet reports (A and B) but would not know how exactly you came from A to B. > > -- --- 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.
