Re: How to fix the income statement so that incomes are positive and expenses are negative?

[John Mee]

beancount-web produces the same outputs of positive and negatives, so it's 
not fava's fault? 
Perhaps I need education as to how things to think of things on balance 
sheets and income statements.

ie on reports:
 assets +'ve & equity -'ve  === income -'ve & expenses +'ve?
vs
 assets- & equity+ === income+ & expenses-
vs
 everything +'ve.

I lean toward thinking everything should be positive values; in your 
opinion, considering the books from a personal point-of-view, should assets 
be positive or negative? liabilities/income/expenses??

-- 
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/a4f90305-baa3-4ac7-bd1c-e8c8da8addc0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: How to fix the income statement so that incomes are positive and expenses are negative?

[Martin Michlmayr]

* John Mee <*@johnmee.com> [2019-05-09 00:26]:
> beancount-web produces the same outputs of positive and negatives,
> so it's not fava's fault? 

You may want to read this introduction to find out why income, equity
and liabilities are negative in beancount:
https://docs.google.com/document/d/100tGcA4blh6KSXPRGCZpUlyxaRUwFHEvnz_k9DyZFn4/edit

> I lean toward thinking everything should be positive values

beancount doesn't use debits and credits; it uses plus and minus
instead.

> in your opinion, considering the books from a personal
> point-of-view, should assets be positive or negative?

Assets are positive

> liabilities/income/expenses??

Liabilities and income are Negative, expenses are positive.

This way, things balance.
-- 
Martin Michlmayr
https://www.cyrius.com/

-- 
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/20190509074356.GE17832%40jirafa.cyrius.com.
For more options, visit https://groups.google.com/d/optout.

Re: How to fix the income statement so that incomes are positive and expenses are negative?

[Florian Lindner]

Am 09.05.19 um 08:44 schrieb John Mee:> Perhaps this is an issue of fava, 
I'm sure you'll redirect me if so... my problem is that fava's balance 
sheet shows assets as positive values and equity as negative (which is also 
odd, imho both sides should be positive values?) thence the income 
Statement shows income as negative and expenses as positives.
> 
> I started mucking around with code to try and flip all my beancount text 
file entries from positives to negatives but, given that is "work, (eg: got 
so far as to be searching for routine in beancount.data that outputs 
Transaction instance as beancount text?), that now I'm reconsidering my 
approach.  Even if I do flip it all successfully my balance sheet will show 
assets as negatives, equity as positives, income as positive and expenses 
as negative: better but still not "right" imho (please correct me as 
appropriate).
> 
> Ultimately I (think I) would like fava's income statement to list income 
in positive values; expenses can be either positive or negative I don't 
particularly care, but it would be nice if both sides of the balance sheet 
were positive although I can live with whatever I get on that. 
> 
> (First) Question is perhaps: Should I proceed to invert every entry in 
beancount, or focus on "fixing" fava?
Hello,

if I understand you correctly, that's the way double-entry accounting works.

You receive X money: Your employer pays to your checkings account: Income 
-> Assets. Since money is moved from Income to Assets, now your income is 
negative X and your Assets is postive X.
Same with Equity. Equity is an account for something you already have. It's 
also used for Opening Balances. In order to start an Asset account you need 
to fill it with money at the point in time you decide to start accounting. 
For that, you book that amount from Equity:Opening-Balances (which goes 
negative then) to Assets (which goes positive by the same amount).

Now, if you something, you book the money from Assets to Expenses, 
resulting in a negative change in Assets and a positive change in Expenses.

Hope that helped a bit,

Best,
Florian

-- 
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/11f15495-549e-49cc-a6b2-e1c44eb72ecf%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: How to fix the income statement so that incomes are positive and expenses are negative?

[Zhuoyun Wei]

I understand you.

The problem here is that Beancount does not use traditional double-entry terms 
like "credit" and "debit" for different types of accounts. It uses signs. It 
uses this modified account equation:

(Income + Liabilities) + (Assets + Expenses) + Equity = 0

So, in most cases, Income and Liabilities are negative, while Assets and 
Expenses are positive.

I have been using Beancount for more than 3 years, so I am already attuned to 
its usage of negative and positive signs. But your post reminds me that if a 
user has used tranditonal double-booking method before, they may feel confused 
facing the Income Statement in Beancount.

Perhaps Fava could provide a fava-option that flips the signs to generate a 
"traditional" Income Statement and Balance Sheet?

-- 
Zhuoyun Wei

On Thu, May 9, 2019, at 02:44, John Mee wrote:
> 
> Perhaps this is an issue of fava, I'm sure you'll redirect me if so... 
> my problem is that fava's balance sheet shows assets as positive values 
> and equity as negative (which is also odd, imho both sides should be 
> positive values?) thence the income Statement shows income as negative 
> and expenses as positives.
> 
> I started mucking around with code to try and flip all my beancount 
> text file entries from positives to negatives but, given that is "work, 
> (eg: got so far as to be searching for routine in beancount.data that 
> outputs Transaction instance as beancount text?), that now I'm 
> reconsidering my approach. Even if I do flip it all successfully my 
> balance sheet will show assets as negatives, equity as positives, 
> income as positive and expenses as negative: better but still not 
> "right" imho (please correct me as appropriate).
> 
> Ultimately I (think I) would like fava's income statement to list 
> income in positive values; expenses can be either positive or negative 
> I don't particularly care, but it would be nice if both sides of the 
> balance sheet were positive although I can live with whatever I get on 
> that. 
> 
> (First) Question is perhaps: Should I proceed to invert every entry in 
> beancount, or focus on "fixing" fava?
> 
> 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/a06f3d41-4aa9-4a92-87b3-1efd16ff1c49%40googlegroups.com
>  
> .
>  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/b0b68380-ad4d-4927-bfe0-7dc304093698%40www.fastmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: How to fix the income statement so that incomes are positive and expenses are negative?

[Stefano Zacchiroli]

On Thu, May 09, 2019 at 04:51:15AM -0400, Zhuoyun Wei wrote:
> Perhaps Fava could provide a fava-option that flips the signs to
> generate a "traditional" Income Statement and Balance Sheet?

There are indeed two different aspects here that have been conflated in
this thread.

One is what Beancount internally uses --- and I'm pretty sure that's not
gonna change.

One is how Fava shows (or not) signs to users. I agree it would make a
sense to have a UI option in Fava that make signs more "standard" and
less puzzling for traditional debit/credit double-entry accounting
users. This is a question for the Fava devs though, that usually react
quickly to this kind of suggestions via the GitHub issue tracker
https://github.com/beancount/fava

Cheers
-- 
Stefano Zacchiroli . z...@upsilon.cc . upsilon.cc/zack . . o . . . o . o
Computer Science Professor . CTO Software Heritage . . . . . o . . . o o
Former Debian Project Leader & OSI Board Director  . . . o o o . . . o .
« the first rule of tautology club is the first rule of tautology club »

-- 
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/20190509091837.ut5jm6vm2gelcev3%40upsilon.cc.
For more options, visit https://groups.google.com/d/optout.

Re: How to fix the income statement so that incomes are positive and expenses are negative?

[Zhuoyun Wei]

https://github.com/beancount/fava/issues/920

-- 
Zhuoyun Wei

On Thu, May 9, 2019, at 05:18, Stefano Zacchiroli wrote:
> On Thu, May 09, 2019 at 04:51:15AM -0400, Zhuoyun Wei wrote:
> > Perhaps Fava could provide a fava-option that flips the signs to
> > generate a "traditional" Income Statement and Balance Sheet?
> 
> There are indeed two different aspects here that have been conflated in
> this thread.
> 
> One is what Beancount internally uses --- and I'm pretty sure that's not
> gonna change.
> 
> One is how Fava shows (or not) signs to users. I agree it would make a
> sense to have a UI option in Fava that make signs more "standard" and
> less puzzling for traditional debit/credit double-entry accounting
> users. This is a question for the Fava devs though, that usually react
> quickly to this kind of suggestions via the GitHub issue tracker
> https://github.com/beancount/fava
> 
> Cheers
> -- 
> Stefano Zacchiroli . z...@upsilon.cc . upsilon.cc/zack . . o . . . o . o
> Computer Science Professor . CTO Software Heritage . . . . . o . . . o o
> Former Debian Project Leader & OSI Board Director  . . . o o o . . . o .
> « the first rule of tautology club is the first rule of tautology club »
> 
> -- 
> 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/20190509091837.ut5jm6vm2gelcev3%40upsilon.cc.
> 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/a527cce2-8670-48b2-b4c2-e6f4bf623e16%40www.fastmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: How to fix the income statement so that incomes are positive and expenses are negative?

[francois PEGORY]

Showing the sign on the traditional way meaning positive for income and
negative for expenses could also have some consequences.

For example: I see the transactions related to my banking account.
Here when I have a transaction where it is a expense, it is logical that
the legs of the transaction related to my banking account is shown as
negative (because it is shown like on my banking )but if E want to show the
legs of the transaction also related to the "expense category" as negative
I will finish to SHOW both of the legs as negative.
Does it could be quite weird ?

Regards

Le jeu. 9 mai 2019 à 11:18, Stefano Zacchiroli  a écrit :

> On Thu, May 09, 2019 at 04:51:15AM -0400, Zhuoyun Wei wrote:
> > Perhaps Fava could provide a fava-option that flips the signs to
> > generate a "traditional" Income Statement and Balance Sheet?
>
> There are indeed two different aspects here that have been conflated in
> this thread.
>
> One is what Beancount internally uses --- and I'm pretty sure that's not
> gonna change.
>
> One is how Fava shows (or not) signs to users. I agree it would make a
> sense to have a UI option in Fava that make signs more "standard" and
> less puzzling for traditional debit/credit double-entry accounting
> users. This is a question for the Fava devs though, that usually react
> quickly to this kind of suggestions via the GitHub issue tracker
> https://github.com/beancount/fava
>
> Cheers
> --
> Stefano Zacchiroli . z...@upsilon.cc . upsilon.cc/zack . . o . . . o . o
> Computer Science Professor . CTO Software Heritage . . . . . o . . . o o
> Former Debian Project Leader & OSI Board Director  . . . o o o . . . o .
> « the first rule of tautology club is the first rule of tautology club »
>
> --
> 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/20190509091837.ut5jm6vm2gelcev3%40upsilon.cc
> .
> 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/CALUWbLfG4qqCc4U2gOYuThGf0vZadnAr0-2%2Bsuk4ug%3DwRqd_xA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: bean-bake export from linux to mac or windows

[richard gott]

Our mac is a geriatric!

Prof R Gott


> Sent: Wednesday, May 08, 2019 at 5:17 PM
> From: "Zhuoyun Wei" 
> To: Beancount 
> Subject: Re: bean-bake export from linux to mac or windows
>
> I heard that recent versions of macOS use a newer filesystem named APFS. 
> Perhaps you could try to open the file in a newer macOS?
>
> Again, I am not a macOS user so I cannot try that out... Good luck!
>
> --
> Zhuoyun Wei
>
> On Wed, May 8, 2019, at 19:59, richard gott wrote:
> > Many thanks for this. I presume that means I can't do it.
> > Richard
> >
> > Prof R Gott
> >
> >
> > > Sent: Wednesday, May 08, 2019 at 10:51 AM
> > > From: "Zhuoyun Wei" 
> > > To: Beancount 
> > > Subject: Re: bean-bake export from linux to mac or windows
> > >
> > > I've never used bean-bake before. I just tried it.
> > >
> > > Some of the output filenames contain colons, for example 
> > > "Assets:Cash.html".
> > >
> > > Some filesystem and/or OS cannot handle colons in paths. Linux allows 
> > > colons in paths, while Windows does not.
> > >
> > > For example, if you mount an NTFS filesystem in Linux, and create a file 
> > > called "foo:bar.txt" in it before mounting this NTFS filesystem in 
> > > Windows, you cannot open / rename / move /delete the file in Windows. In 
> > > this case, NTFS allows colons, but Windows does not support it.
> > >
> > > I don't use macOS, but I guess it's something similar. A quick Google 
> > > search reveals that the HFS filesystem used by previous versions of macOS 
> > > does not allow colons in filenames.
> > >
> > > --
> > > Zhuoyun Wei
> > >
> > > On Tue, May 7, 2019, at 10:28, richard gott wrote:
> > > > Hello
> > > > I am the treasurer of a small charity. I have recently switched from
> > > > ledger. One of the main reasons was to make use of bean-bake to share
> > > > full accounts adn reports with the other trustees.
> > > > When I run bean-bake I get the folder as predictied whcih works fine -
> > > > linux (arch adn ubuntu - both ok - ext4).
> > > > BUT:
> > > >  * try to copy to USB, fails with 'cannot copy files'
> > > >  * zip and send to mac, unzip OR
> > > >  * upload to google drive adn download to mac* index opens fine,
> > > > structure is intact
> > > >* top level accounts open ok
> > > >* anything below that is empty
> > > > It behaves as if the apple file system can't cope with the folder depth
> > > > of the lower level files in the bean-bake folder. But I am not a
> > > > computer expert adn that may be complete rubbish.
> > > > I would be most grateful for any help that can be offered
> > > > Thanks
> > > > Richard
> > > >
> > > >  --
> > > >  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/trinity-703d58fc-e627-4414-9191-c4b76b7cbc2b-1557148626744%403c-app-mailcom-bs06
> > > >  
> > > > .
> > > >  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/2de489f9-3a19-4a09-bbe8-ae9e4d856f38%40www.fastmail.com.
> > > 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/trinity-3638278d-4e8c-469e-b577-c6361bcf40c9-1557316786738%403c-app-mailcom-bs13.
> > 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/5c8bd647-56cd-4c83-9824-9ede91ee2d91%40www.fastmail.com.
> For more options, visit https://groups.google.com/d/optout.
>

Re: bean-bake export from linux to mac or windows

[richard gott]

The man's a star. I shall try that asap.
Thank you
Richard

Prof R Gott


> Sent: Thursday, May 09, 2019 at 4:31 AM
> From: "Martin Blais" 
> To: Beancount 
> Subject: Re: bean-bake export from linux to mac or windows
>
> bergamot:~$ bean-bake --help
> ...
>   --no-colons   Don't render colons in filenames (for Windows).
>
>
>
>
> On Wed, May 8, 2019 at 7:59 AM richard gott  wrote:
>
> > Many thanks for this. I presume that means I can't do it.
> > Richard
> >
> > Prof R Gott
> >
> >
> > > Sent: Wednesday, May 08, 2019 at 10:51 AM
> > > From: "Zhuoyun Wei" 
> > > To: Beancount 
> > > Subject: Re: bean-bake export from linux to mac or windows
> > >
> > > I've never used bean-bake before. I just tried it.
> > >
> > > Some of the output filenames contain colons, for example
> > "Assets:Cash.html".
> > >
> > > Some filesystem and/or OS cannot handle colons in paths. Linux allows
> > colons in paths, while Windows does not.
> > >
> > > For example, if you mount an NTFS filesystem in Linux, and create a file
> > called "foo:bar.txt" in it before mounting this NTFS filesystem in Windows,
> > you cannot open / rename / move /delete the file in Windows. In this case,
> > NTFS allows colons, but Windows does not support it.
> > >
> > > I don't use macOS, but I guess it's something similar. A quick Google
> > search reveals that the HFS filesystem used by previous versions of macOS
> > does not allow colons in filenames.
> > >
> > > --
> > > Zhuoyun Wei
> > >
> > > On Tue, May 7, 2019, at 10:28, richard gott wrote:
> > > > Hello
> > > > I am the treasurer of a small charity. I have recently switched from
> > > > ledger. One of the main reasons was to make use of bean-bake to share
> > > > full accounts adn reports with the other trustees.
> > > > When I run bean-bake I get the folder as predictied whcih works fine -
> > > > linux (arch adn ubuntu - both ok - ext4).
> > > > BUT:
> > > >  * try to copy to USB, fails with 'cannot copy files'
> > > >  * zip and send to mac, unzip OR
> > > >  * upload to google drive adn download to mac* index opens fine,
> > > > structure is intact
> > > >* top level accounts open ok
> > > >* anything below that is empty
> > > > It behaves as if the apple file system can't cope with the folder depth
> > > > of the lower level files in the bean-bake folder. But I am not a
> > > > computer expert adn that may be complete rubbish.
> > > > I would be most grateful for any help that can be offered
> > > > Thanks
> > > > Richard
> > > >
> > > >  --
> > > >  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/trinity-703d58fc-e627-4414-9191-c4b76b7cbc2b-1557148626744%403c-app-mailcom-bs06
> > <
> > https://groups.google.com/d/msgid/beancount/trinity-703d58fc-e627-4414-9191-c4b76b7cbc2b-1557148626744%403c-app-mailcom-bs06?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/2de489f9-3a19-4a09-bbe8-ae9e4d856f38%40www.fastmail.com
> > .
> > > 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/trinity-3638278d-4e8c-469e-b577-c6361bcf40c9-1557316786738%403c-app-mailcom-bs13
> > .
> > 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%2BhPOGVksd0EyRA5qd1KqbrOsZiT4Hz-8Cg%2B249vJ%2BPTrTA%40mail.gmail.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Gro

How to account for a partial reimbursement

[troy . williams]

 I went to the dentist last month for a root canal and had to pay out of 
pocket for the costs and I was reimbursed later on, but not the full amount 
of the cost. I have an account, Expenses:Medical:Dental, which I usually 
charge against. The idea behind this account is that at the end of the year 
it should tell me my out of pocket expenses which I can claim on my income 
taxes.

Here is what I did to track the transactions:

; inital transactions at the dentist - full amount on credit card 
2019-04-12 * "Dentist" "Root Canal"
Expenses:Medical:Dental 1500.00 CAD ; I was billed this amount by the 
dentist
Liabilities:CreditCard

; reimbursement from insurance
2019-04-16 * "Insurance" "Medical Expense reimbursement for Root Canal"
Income:Company:Medical -1000.00 CAD ; This is what I was reimbursed
Assets:Chequing

; apply reimbursement to credit card
2019-04-19 * "Credit Card" "Medical Expense reimbursement for Root Canal"
Liabilities:CreditCard 1000.00 CAD
Assets:Chequing

; apply the reimbursement amount to the Expenses:Medical:Dental so that it 
accurately tracks unimbursed costs 
2019-04-19 * "Dentist" "Root Canal"
 Income:Other:PartialReimburse 1000.00 CAD 
 Expenses:Medical:Dental

I am not sure that it is done correctly, but when I check the balanes of 
the Expenses:Medical:Dental account it is correct. Any advice would be 
great.

-- 
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/f2ce06a2-90a2-4f0e-8de9-b5b2980e7402%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

load_file omits some entries (balances)

[Florian Lindner]

Hello,

I extended my importer to also work as transformer, applying the rules used 
at input on existing beancount files:

entries, error, option_map = bc.loader.load_file(args.inputfile)

transformed_entries = []
for e in entries:
transformed_entries.append(transform_txn(e) if type(e) == 
data.Transaction else e)

with open(args.outputfile, "w") as f:
bc.parser.printer.print_entries(transformed_entries, file = f)


My beancount files are organized as one main.beancount file which contains 
the open and pad directives and an account.beancount for each banking 
account.

To keep the transactions separate, I apply the transformation only on 
account.beancount (=args.filename). Naturally, there are several validation 
errors because of invalid accounts and failing balances. At this point, 
however, I don't care about the failing validations.

The problem is, that entries from load_file does not contain all 
transactions. I am not sure which transactions are omitted, but all 
balances are definitely left out. When I write out the transformed entries, 
information is lost.

How can I read in all entries of a file, get them as entries, but not 
perform any validation checks? Or otherwise, what is the best way to work 
around that?

Thanks!
Florian

-- 
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/fd082e96-693c-47ba-9f32-3425c7ff179c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: How to account for a partial reimbursement

[Daniel Clemente]

In your example, from the 1500 CAD only 500 CAD are from your money, so
that's the only expense (and I guess it's the only part you can deduct when
filing taxes). The other 1000 CAD are like a loan you're making to your
insurance (you're lending them money to pay the bill and you later recover
it).
In the moment you did the transaction, maybe you didn't know which part
would be expense and which part reimbursable, but after you know it, you
can go back and edit that transaction.

I would write something like this (I'm ignoring the part of the credit
card, I'm assuming that you pay and are reimbursed by bank transfer. You
can expand on it to include it):

2019-04-12 * "Dentist" "Root Canal"
Expenses:Medical:Dental 500.00 CAD ; effectively paid
Liabilites:Medical:PartialReimburse +1000 CAD ; later reimbursed
Assets:Bank -1500 CAD ; I was billed this amount by the dentist

2019-04-13 * "Insurance pays back"
Liabilites:Medical:PartialReimburse
Assets:Bank +1000 CAD



On Thu, May 9, 2019 at 4:51 PM  wrote:

>  I went to the dentist last month for a root canal and had to pay out of
> pocket for the costs and I was reimbursed later on, but not the full amount
> of the cost. I have an account, Expenses:Medical:Dental, which I usually
> charge against. The idea behind this account is that at the end of the year
> it should tell me my out of pocket expenses which I can claim on my income
> taxes.
>
> Here is what I did to track the transactions:
>
> ; inital transactions at the dentist - full amount on credit card
> 2019-04-12 * "Dentist" "Root Canal"
> Expenses:Medical:Dental 1500.00 CAD ; I was billed this amount by the
> dentist
> Liabilities:CreditCard
>
> ; reimbursement from insurance
> 2019-04-16 * "Insurance" "Medical Expense reimbursement for Root Canal"
> Income:Company:Medical -1000.00 CAD ; This is what I was reimbursed
> Assets:Chequing
>
> ; apply reimbursement to credit card
> 2019-04-19 * "Credit Card" "Medical Expense reimbursement for Root Canal"
> Liabilities:CreditCard 1000.00 CAD
> Assets:Chequing
>
> ; apply the reimbursement amount to the Expenses:Medical:Dental so that it
> accurately tracks unimbursed costs
> 2019-04-19 * "Dentist" "Root Canal"
>  Income:Other:PartialReimburse 1000.00 CAD
>  Expenses:Medical:Dental
>
> I am not sure that it is done correctly, but when I check the balanes of
> the Expenses:Medical:Dental account it is correct. Any advice would be
> great.
>
> --
> 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/f2ce06a2-90a2-4f0e-8de9-b5b2980e7402%40googlegroups.com
> 
> .
> 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/CAJKAhPD5VEeCeLuC4KUng5xD6g-LsgEbsP2Ssq_rSCyyAcatSg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: How to account for a partial reimbursement

[troy . williams]

Thank you Daniel. That is what I was looking for!

On Thursday, May 9, 2019 at 11:38:56 AM UTC-4, Daniel Clemente wrote:
>
> In your example, from the 1500 CAD only 500 CAD are from your money, so 
> that's the only expense (and I guess it's the only part you can deduct when 
> filing taxes). The other 1000 CAD are like a loan you're making to your 
> insurance (you're lending them money to pay the bill and you later recover 
> it).
> In the moment you did the transaction, maybe you didn't know which part 
> would be expense and which part reimbursable, but after you know it, you 
> can go back and edit that transaction.
>
> I would write something like this (I'm ignoring the part of the credit 
> card, I'm assuming that you pay and are reimbursed by bank transfer. You 
> can expand on it to include it):
>
> 2019-04-12 * "Dentist" "Root Canal"
> Expenses:Medical:Dental 500.00 CAD ; effectively paid
> Liabilites:Medical:PartialReimburse +1000 CAD ; later reimbursed
> Assets:Bank -1500 CAD ; I was billed this amount by the dentist
>
> 2019-04-13 * "Insurance pays back"
> Liabilites:Medical:PartialReimburse
> Assets:Bank +1000 CAD
>
>
>
> On Thu, May 9, 2019 at 4:51 PM > 
> wrote:
>
>>  I went to the dentist last month for a root canal and had to pay out of 
>> pocket for the costs and I was reimbursed later on, but not the full amount 
>> of the cost. I have an account, Expenses:Medical:Dental, which I usually 
>> charge against. The idea behind this account is that at the end of the year 
>> it should tell me my out of pocket expenses which I can claim on my income 
>> taxes.
>>
>> Here is what I did to track the transactions:
>>
>> ; inital transactions at the dentist - full amount on credit card 
>> 2019-04-12 * "Dentist" "Root Canal"
>> Expenses:Medical:Dental 1500.00 CAD ; I was billed this amount by the 
>> dentist
>> Liabilities:CreditCard
>>
>> ; reimbursement from insurance
>> 2019-04-16 * "Insurance" "Medical Expense reimbursement for Root Canal"
>> Income:Company:Medical -1000.00 CAD ; This is what I was reimbursed
>> Assets:Chequing
>>
>> ; apply reimbursement to credit card
>> 2019-04-19 * "Credit Card" "Medical Expense reimbursement for Root Canal"
>> Liabilities:CreditCard 1000.00 CAD
>> Assets:Chequing
>>
>> ; apply the reimbursement amount to the Expenses:Medical:Dental so that 
>> it accurately tracks unimbursed costs 
>> 2019-04-19 * "Dentist" "Root Canal"
>>  Income:Other:PartialReimburse 1000.00 CAD 
>>  Expenses:Medical:Dental
>>
>> I am not sure that it is done correctly, but when I check the balanes of 
>> the Expenses:Medical:Dental account it is correct. Any advice would be 
>> great.
>>
>> -- 
>> 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 bean...@googlegroups.com .
>> To post to this group, send email to bean...@googlegroups.com 
>> .
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/beancount/f2ce06a2-90a2-4f0e-8de9-b5b2980e7402%40googlegroups.com
>>  
>> 
>> .
>> 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/e7f580fe-4733-4841-9602-8d027f7e7e4a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: How to fix the income statement so that incomes are positive and expenses are negative?

[John Mee]

> You may want to read this introduction to find out why income, equity 
> and liabilities are negative in beancount: 
>
> https://docs.google.com/document/d/100tGcA4blh6KSXPRGCZpUlyxaRUwFHEvnz_k9DyZFn4/edit
>  
>

Thanks Martin.  It's reassuring to discover that this 'fault' is by 
design.  What's even better is the discovery that I've actually done it 
"right"... my Incomes are indeed negative values as it stands.  So nothing 
to do here, glad I asked.

Whilst reading I discovered this...

We just use additions everywhere and learn to keep in mind that 
> Liabilities, Equity and Income accounts normally have a negative balance. 
> While this is unconventional, it’s much easier to grok. And If there is a 
> need to view a conventional report with positive numbers only, we will be 
> able to trigger that in reporting code (4), inverting the signs just to 
> render them in the output.
>
> (4) This is not provided yet in Beancount, but would be trivial to 
> implement. All we'd need to do is invert the signs of balances from 
> Liabilities, Income and Equity accounts. It's on the roadmap to provide 
> this eventually. 
>
 
Is it really?  On a roadmap? Trivial to implement?

-- 
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/7800ca9e-3407-4f3c-9420-1285c9b7c28f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: How to account for a partial reimbursement

[John Mee]

...doh, sorry for the noise, that should probably be around the other 
way... fiddle until it is right.  I just wanted to suggest tagging as the 
solution.

2019-04-16 * "Insurance" "Medical Expense reimbursement for Root Canal" 
#reimbursment #
Assets:Chequing   1000.00 CAD
Expenses:Medical:Dental

-- 
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/ab38a75b-b011-4843-897f-179e08347720%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: How to account for a partial reimbursement

[John Mee]

I'd shy away from editing the old transaction as it discards the timeline 
and doesn't reflect reality.  You have transactions on your CC that your 
accounts don't correctly reflect!  In this instance it was only a few days, 
but sometimes these things take weeks, or months, for the cycle to be 
completed.  It's a slippery slope.

I thought what you did looks great, excepting that for the final/4th 
entry.  My solution would be to book the second transaction directly 
against expenses, and forgo the 4th entry but, if I have your problem 
understood, you want a report on reimbursements.  Your mileage may vary 
but, rather than creating a special account and virtual transactions, I 
start tagging things like that, and run reports against the tags.   eg:


2019-04-16 * "Insurance" "Medical Expense reimbursement for Root Canal"   
*#reimbursment  
#*
*Expenses:Medical:Dental* 1000.00 CAD
Assets:Chequing

-- 
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/f6521bde-e181-49b9-8c89-bed8c42f06e2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: load_file omits some entries (balances)

[Martin Blais]

I read your message twice. I don't understand what you're trying to do.



On Thu, May 9, 2019 at 11:12 AM Florian Lindner  wrote:

> Hello,
>
> I extended my importer to also work as transformer, applying the rules
> used at input on existing beancount files:
>
> entries, error, option_map = bc.loader.load_file(args.inputfile)
>
> transformed_entries = []
> for e in entries:
> transformed_entries.append(transform_txn(e) if type(e) ==
> data.Transaction else e)
>
> with open(args.outputfile, "w") as f:
> bc.parser.printer.print_entries(transformed_entries, file = f)
>
>
> My beancount files are organized as one main.beancount file which contains
> the open and pad directives and an account.beancount for each banking
> account.
>
> To keep the transactions separate, I apply the transformation only on
> account.beancount (=args.filename). Naturally, there are several validation
> errors because of invalid accounts and failing balances. At this point,
> however, I don't care about the failing validations.
>
> The problem is, that entries from load_file does not contain all
> transactions. I am not sure which transactions are omitted, but all
> balances are definitely left out. When I write out the transformed entries,
> information is lost.
>
> How can I read in all entries of a file, get them as entries, but not
> perform any validation checks? Or otherwise, what is the best way to work
> around that?
>
> Thanks!
> Florian
>
> --
> 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/fd082e96-693c-47ba-9f32-3425c7ff179c%40googlegroups.com
> 
> .
> 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%2BhOfMr4aNMQ58rGBPJDsN4wtO%3DzOsnnry7qioER4p8gqxg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: How to fix the income statement so that incomes are positive and expenses are negative?

[Martin Blais]

Two old ideas which have never been implemented:

- Allow all positive signs in the input, inverting based on the accounts
(all postings are associated with accounts, so this would be easy).
This may make it a little more difficult to eyeball that a transaction
balances properly, but that's up to the user in the end (it should be an
option).

- Render all numbers in reports with inverted signs based on the accounts
(balances are almost always associated with accounts, so this should also
be easy).

We never bothered to implement either - it's rarely requested - and so far
input and output are using the internal representation and users are just
used to it.
I think those two features would be nice to have though, and provide a bit
of polish on the interface of Beancount.









On Thu, May 9, 2019 at 6:32 PM John Mee <*@johnmee.com> wrote:

>
> You may want to read this introduction to find out why income, equity
>> and liabilities are negative in beancount:
>>
>> https://docs.google.com/document/d/100tGcA4blh6KSXPRGCZpUlyxaRUwFHEvnz_k9DyZFn4/edit
>>
>
> Thanks Martin.  It's reassuring to discover that this 'fault' is by
> design.  What's even better is the discovery that I've actually done it
> "right"... my Incomes are indeed negative values as it stands.  So nothing
> to do here, glad I asked.
>
> Whilst reading I discovered this...
>
> We just use additions everywhere and learn to keep in mind that
>> Liabilities, Equity and Income accounts normally have a negative balance.
>> While this is unconventional, it’s much easier to grok. And If there is a
>> need to view a conventional report with positive numbers only, we will be
>> able to trigger that in reporting code (4), inverting the signs just to
>> render them in the output.
>>
>> (4) This is not provided yet in Beancount, but would be trivial to
>> implement. All we'd need to do is invert the signs of balances from
>> Liabilities, Income and Equity accounts. It's on the roadmap to provide
>> this eventually.
>>
>
> Is it really?  On a roadmap? Trivial to implement?
>
> --
> 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/7800ca9e-3407-4f3c-9420-1285c9b7c28f%40googlegroups.com
> 
> .
> 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%2BhP-YWHSjb2bDYAVwjLa9-374%2Bmv2JO_%2BPCYJ-%2BxKCPZ9w%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: How to account for a partial reimbursement

[Martin Blais]

There's a lot to say and it's an involved topic (especially with in-network
and out-of-network differences), I can't do it right now (I'll write a doc
at some point, I started writing something here:
https://docs.google.com/document/d/16RKEl1NJ3qg8VU9vKRRvgIv3CyGs0_4ASS4lD5iBFTw/edit?usp=sharing
but it's not quite finished yet, needs review), but one quick thing I'd
mention is you should use a links to tie together these transactions, so
you can use the "bean-doctor linked ..." to view them together.

Something like this provides some ideas (for a US context with private
insurance):

;;; accounting/blais.beancount:49452:




;;;




;;;2015-10-01 * "KLEIN" "Cleaning, X-ray, Oral evaluation. Issued:
2015-10-10" #out-network ^delta-dental-claim-2015123456789



;;;  Expenses:Health:Dental:Claims  440.00 USD




;;;  Expenses:Health:Dental:ClaimsPayment  -301.00 USD




;;;  Liabilities:AccountsPayable:Klein  -49.00 USD




;;;  Expenses:Health:Dental:WriteOffs   -90.00 USD




;;;




;;;




;;; accounting/blais.beancount:25387:




;;;




;;;2015-10-19 * "Klein Dentists" "KLEIN DDS"
^delta-dental-claim-2015123456789




;;;  note: "Paid $350 right away, will wait for insurance check
later."



;;;  Liabilities:US:BofA:GoldCard -350.00 USD




;;;  Liabilities:AccountsPayable:Klein   49.00 USD




;;;  Assets:AccountsReceivable  301.00 USD




;;;




;;;




;;; accounting/blais.beancount:17070:




;;;




;;;2015-11-04 * "ATM CHECK DEPOSIT" ^delta-dental-claim-2015123456789




;;;  Assets:US:BofA:Checking   301.00 USD




;;;  Assets:AccountsReceivable  -301.00 USD




;;;




;;;




;;; |-- Assets




;;; |   |-- AccountsReceivable




;;; |   `-- US




;;; |   `-- BofA




;;; |   `-- Checking  301.00 USD




;;; |-- Expenses




;;; |   `-- Health




;;; |   `-- Dental




;;; |   |-- Claims440.00 USD




;;; |   |-- ClaimsPayment-301.00 USD




;;; |   `-- WriteOffs -90.00 USD




;;; `-- Liabilities




;;; |-- AccountsPayable




;;; |   `-- Klein




;;; `-- US




;;; `-- BofA




;;; `-- GoldCard  -350.00 USD




;;;




;;; Net Income: (-49.00 USD)









On Thu, May 9, 2019 at 7:09 PM John Mee <*@johnmee.com> wrote:

> ...doh, sorry for the noise, that should probably be around the other
> way... fiddle until it is right.  I just wanted to suggest tagging as the
> solution.
>
> 2019-04-16 * "Insurance" "Medical Expense reimbursement for Root Canal"
> #reimbursment #
> Assets:Chequing   1000.00 CAD
> Expenses:Medical:Dental
>
> --
> 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/ab38a75b-b011-4843-897f-179e08347720%40googlegroups.com
> 
> .
> 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%2BhP7bTCF1VpVoZO_3G4NYF1GSyA4s5RZs0D-yXWuBc4aLQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.