Thank you for your reply. On Friday, December 15, 2017 at 4:49:29 AM UTC+1, Justus Pendleton wrote: > > > > On Monday, December 11, 2017 at 11:45:47 PM UTC+7, [email protected] wrote: >> >> I would like to use fava balance sheet as starting point, using >> Equity:Earnings:Current and them moving his balance to something else on >> 2018 >> > > Why Equity? It seems like this should be Income that increases an Asset. >
I think I didn't explained myself properly. I'll post a complete example at the end. > > [ ... ] > > * when I pay myself a salary it's recorder on account Expenses:Salary so >> will be removed from Equity:Earnings:Current >> > > I don't see the problem here, other than I think you should be using an > Asset instead of Equity. > I'm using Equity:Salary because I'm tracking it as an asset in my personal beancount file. Here I have to track that moneys come out from bank account but are no longer tracked here, and must not change Equity:Earnings:Current > >> * there are some expenses that are nondeductible (or only partially >> deductible), this expenses will in any case be subtracted from >> Equity:Earnings:Current >> > > Same thing. I don't see the problem here? The money has to come from > somewhere. Whether it is deductible or non-deductible or partially > deductible it will always come from the same place. (Though it should be an > Asset instead of Equity.) > I created an example ledger, hoping it will help. ;; -*- mode: beancount; -*- 2016-12-01 open Assets:Bank EUR 2016-12-01 open Assets:AccountReceivable EUR 2016-12-01 open Income:Customer1 EUR 2016-12-01 open Expenses:Personal EUR 2016-12-01 open Expenses:Utilities EUR 2016-12-01 open Equity:Salary EUR 2016-12-01 * "Customer1" "Invoice 2016-1" ^invoice2016-1 Assets:AccountReceivable 1000 EUR Income:Customer1 2016-12-15 * "Customer1" "invoice 2016-1" ^invoice2016-1 Assets:Bank 1000 EUR Assets:AccountReceivable 2017-12-01 * "Customer1" "Invoice 2017-1" ^invoice2017-1 Assets:AccountReceivable 1000 EUR Income:Customer1 2017-12-15 * "Customer1" "invoice 2017-1" ^invoice2017-1 Assets:Bank 1000 EUR Assets:AccountReceivable 2017-12-16 * "Caffè" Expenses:Personal 1 EUR Assets:Bank 2017-12-17 * "TheInternet" "internet bill december" Expenses:Utilities 20 EUR ; 50% deductible Assets:Bank 2017-12-20 * "Salary" Assets:Bank -500 EUR Equity:Salary 2017-12-31 query "2017" " SELECT sum(position) as earnings FROM year = 2017 OPEN ON 2017-01-01 CLOSE ON 2018-01-01 CLEAR WHERE account = 'Equity:Earnings:Current' " This is a simplified example that I hope may be useful for explaining my doubts. If I run the last query: $ bean-query example.beancount "run '2017 all'" earnings -------- -979 EUR This output is correct but it's not what I need, I would like to get the same concept as Equity:Earnings:Current but without Expenses:Personal and with only half of Expenses:Utilities (50% deductible) -- 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 [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/2a671cc9-3e72-4651-bd76-530cb8a325bf%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
