Re: [GNC] Old Line Bank

[Tom Moffett]

Thanks Dave.

Tom
If there are no dogs in heaven, then when I die I want to go where they went - 
Will Rogers


-Original Message-
From: David Reiser [mailto:dbrei...@icloud.com] 
Sent: Thursday, February 28, 2019 11:05 PM
To: Tom Moffett
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Old Line Bank


> On Feb 28, 2019, at 4:27 PM, Tom Moffett  wrote:
> 
> Has anyone had success connecting to Old Line Bank?  It is listed in the
> database, but when I setup a user and attempt to retrieve a list of accounts
> I get an error message that I have entered and incorrect username or
> password.  I questioned the bank's tech support folks and they had never
> heard of GnuCash.  They said they support Quicken (which I have been using
> successfully).  If I can't connect to this bank GnuCash won't work for me at
> all.
> 
> 
> 
> Thanks in advance for any help.
> 
> 
> 
> Tom Moffett
> 
> I hope to become the man my dog thinks I am.
> 
Regarding “it’s listed in the database”, which database? Quicken references a 
participating banks list in Intuit’s fi.intuit.something, mentioning that 
Intuit does control those web pages, but may not be keeping the information up 
to date. How sweet.

Anyway, in Intuit’s list, they say that Old Line Bank has Web Connect, but not 
DirectConnect. In my limited experience, unless that web page advertised 
Directconnect, there was no way to get Gnucash/Aqbanking to connect to your 
data for a direct download.

All of Old Line Bank’s resource information for customers of last year’s 
acquired Bay Bank mentions Web Connect and Express Web Connect  for all sorts 
of vintages of Mac and Windows Quicken users. No mention of DirectConnect.

One other thing to keep in mind. If you still have an active copy of Quicken on 
your computer, when you tell Old Line Bank to send your Quicken (QFX) data, 
Quicken will probably try to hijack the download. You want to end up with a 
downloaded QFX file on your disk that you can import into Gnucash.

Dave
--
Dave Reiser
dbrei...@icloud.com




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Old Line Bank

[David Reiser via gnucash-user]

> On Feb 28, 2019, at 4:27 PM, Tom Moffett  wrote:
> 
> Has anyone had success connecting to Old Line Bank?  It is listed in the
> database, but when I setup a user and attempt to retrieve a list of accounts
> I get an error message that I have entered and incorrect username or
> password.  I questioned the bank's tech support folks and they had never
> heard of GnuCash.  They said they support Quicken (which I have been using
> successfully).  If I can't connect to this bank GnuCash won't work for me at
> all.
> 
> 
> 
> Thanks in advance for any help.
> 
> 
> 
> Tom Moffett
> 
> I hope to become the man my dog thinks I am.
> 
Regarding “it’s listed in the database”, which database? Quicken references a 
participating banks list in Intuit’s fi.intuit.something, mentioning that 
Intuit does control those web pages, but may not be keeping the information up 
to date. How sweet.

Anyway, in Intuit’s list, they say that Old Line Bank has Web Connect, but not 
DirectConnect. In my limited experience, unless that web page advertised 
Directconnect, there was no way to get Gnucash/Aqbanking to connect to your 
data for a direct download.

All of Old Line Bank’s resource information for customers of last year’s 
acquired Bay Bank mentions Web Connect and Express Web Connect  for all sorts 
of vintages of Mac and Windows Quicken users. No mention of DirectConnect.

One other thing to keep in mind. If you still have an active copy of Quicken on 
your computer, when you tell Old Line Bank to send your Quicken (QFX) data, 
Quicken will probably try to hijack the download. You want to end up with a 
downloaded QFX file on your disk that you can import into Gnucash.

Dave
--
Dave Reiser
dbrei...@icloud.com




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Old Line Bank

[Thomas Moffett]

Thanks David. I was hoping to make the first option work but apparently it
will not. I will keep working on the second option.

Tom

sent from my Note 5

On Thu, Feb 28, 2019, 6:30 PM David Carlson 
wrote:

> Tom,
>
> There are two types of approach for you to consider and either will not
> require Quicken once you have it working.
>
> 1.  GnuCash does have a feature similar to the Quicken One Step Update
> through the Online Actions menu, but it is tricky to set up and you need to
> set up credentials which are easiest to obtain by reading the Logs from
> previous Quicken activity.   Some of us make this work and others give up
> and switch  to:
>
> 2.  Your bank probably allows you to download transaction histories in
> several different formats from your Internet online banking page, possibly
> including CSV, QIF, and OFX.  Sometimes they use different names.  Of the
> three, the OFX gives the best experience when importing into GnuCash.  The
> bank may call the OFX format the Quicken format.  With this method you
> download the data file, save it somewhere in a temporary folder, then
> import it into GnuCash.
>
> Since I have not made number 1 work for me, I cannot help you try that.
>
> David Carlson
>
> On Thu, Feb 28, 2019 at 5:05 PM Kenneth Schneider <
> kschnei...@bout-tyme.net> wrote:
>
>> Download you transactions from the bank in CSV format for import directly
>> to GNUcash. I’ve found this works very well. You will need to go through
>> the process of bayeshen (?) matching but with time it works. There is going
>> to be a learning curve but it’s not that steep.
>>
>> Ken Schneider
>>
>> > On Feb 28, 2019, at 5:37 PM, Thomas Moffett 
>> wrote:
>> >
>> > I'm not sure I follow you. The point of switching to gnucash is so that
>> I
>> > no longer need to download into Quicken because they're cutting off my
>> > online access unless I upgrade.
>> >
>> > It sounds like you're suggesting that I download into Quicken and then
>> > import from Quicken into gnucash. Or am I completely misunderstanding
>> your
>> > suggestion?
>> >
>> > Tom
>> >
>> > sent from my Note 5
>> >
>> >> On Thu, Feb 28, 2019, 5:20 PM  wrote:
>> >>
>> >> I would use the the import function of gnu cash after downloading the
>> >> quicken information from your bank website using your username and
>> >> password. I use this method for all my online banking services that
>> are not
>> >> gnucash friendly.
>> >>
>> >> Joseph St Denis
>> >>
>> >> Get Outlook for Android 
>> >>
>> >>
>> >>
>> >>
>> >> On Thu, Feb 28, 2019 at 4:29 PM -0500, "Tom Moffett" <
>> >> tlmoffet...@gmail.com> wrote:
>> >>
>> >> Has anyone had success connecting to Old Line Bank?  It is listed in
>> the
>> >>> database, but when I setup a user and attempt to retrieve a list of
>> accounts
>> >>> I get an error message that I have entered and incorrect username or
>> >>> password.  I questioned the bank's tech support folks and they had
>> never
>> >>> heard of GnuCash.  They said they support Quicken (which I have been
>> using
>> >>> successfully).  If I can't connect to this bank GnuCash won't work
>> for me at
>> >>> all.
>> >>>
>> >>>
>> >>>
>> >>> Thanks in advance for any help.
>> >>>
>> >>>
>> >>>
>> >>> Tom Moffett
>> >>>
>> >>> I hope to become the man my dog thinks I am.
>> >>>
>> >>>
>> >>>
>> >>> ___
>> >>> gnucash-user mailing listgnucash-u...@gnucash.org
>> >>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> >>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> >>> -
>> >>> Please remember to CC this list on all your replies.
>> >>> You can do this by using Reply-To-List or Reply-All.
>> >>>
>> >>>
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@gnucash.org
>> > To update your subscription preferences or to unsubscribe:
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> > -
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>> >
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
> --
> David Carlson
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnu

Re: [GNC] Old Line Bank

[David Carlson]

Tom,

There are two types of approach for you to consider and either will not
require Quicken once you have it working.

1.  GnuCash does have a feature similar to the Quicken One Step Update
through the Online Actions menu, but it is tricky to set up and you need to
set up credentials which are easiest to obtain by reading the Logs from
previous Quicken activity.   Some of us make this work and others give up
and switch  to:

2.  Your bank probably allows you to download transaction histories in
several different formats from your Internet online banking page, possibly
including CSV, QIF, and OFX.  Sometimes they use different names.  Of the
three, the OFX gives the best experience when importing into GnuCash.  The
bank may call the OFX format the Quicken format.  With this method you
download the data file, save it somewhere in a temporary folder, then
import it into GnuCash.

Since I have not made number 1 work for me, I cannot help you try that.

David Carlson

On Thu, Feb 28, 2019 at 5:05 PM Kenneth Schneider 
wrote:

> Download you transactions from the bank in CSV format for import directly
> to GNUcash. I’ve found this works very well. You will need to go through
> the process of bayeshen (?) matching but with time it works. There is going
> to be a learning curve but it’s not that steep.
>
> Ken Schneider
>
> > On Feb 28, 2019, at 5:37 PM, Thomas Moffett 
> wrote:
> >
> > I'm not sure I follow you. The point of switching to gnucash is so that I
> > no longer need to download into Quicken because they're cutting off my
> > online access unless I upgrade.
> >
> > It sounds like you're suggesting that I download into Quicken and then
> > import from Quicken into gnucash. Or am I completely misunderstanding
> your
> > suggestion?
> >
> > Tom
> >
> > sent from my Note 5
> >
> >> On Thu, Feb 28, 2019, 5:20 PM  wrote:
> >>
> >> I would use the the import function of gnu cash after downloading the
> >> quicken information from your bank website using your username and
> >> password. I use this method for all my online banking services that are
> not
> >> gnucash friendly.
> >>
> >> Joseph St Denis
> >>
> >> Get Outlook for Android 
> >>
> >>
> >>
> >>
> >> On Thu, Feb 28, 2019 at 4:29 PM -0500, "Tom Moffett" <
> >> tlmoffet...@gmail.com> wrote:
> >>
> >> Has anyone had success connecting to Old Line Bank?  It is listed in the
> >>> database, but when I setup a user and attempt to retrieve a list of
> accounts
> >>> I get an error message that I have entered and incorrect username or
> >>> password.  I questioned the bank's tech support folks and they had
> never
> >>> heard of GnuCash.  They said they support Quicken (which I have been
> using
> >>> successfully).  If I can't connect to this bank GnuCash won't work for
> me at
> >>> all.
> >>>
> >>>
> >>>
> >>> Thanks in advance for any help.
> >>>
> >>>
> >>>
> >>> Tom Moffett
> >>>
> >>> I hope to become the man my dog thinks I am.
> >>>
> >>>
> >>>
> >>> ___
> >>> gnucash-user mailing listgnucash-u...@gnucash.org
> >>> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>> -
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>>
> >>>
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] BUSINESS CHECK PRINTING - BILLS PAID INFORMATION ON STUBS

[Greg Crawford]

Victor, thanks for the reply. The data for the splits will be present in my
company file moving forward, I will be entering it complete and in real
time. I'm looking for workable solutions prior to migrating all of my
companies to GNUCASH. And printing bill payment checks, with meaningful
stubs is a must.

My level of programming expertise is spotty. I've messed around extensively
with VBA doing work with Excel, cobbling together solutions for my own very
specific accounting tasks. At the moment, if nobody has something much
simpler to offer here... I see the most likely solution being to write an
external VBA script that will go and grab the data right from my XML file
itself and build the checks external to GNUCASH. To a man with a hammer...
everything looks like a nail, I guess. I don't love it. It seems labor
intensive and clunky. I had hoped for more from GNUCASH... Especially since
the data points I need all seem to be present somewhere... Just not linked
up accessibly.

Hoping others might have a solution up their sleeves. Or that someone can
definitively say there is NOT one. I hope that's not the case, but it would
at least be a starting point, I suppose.

On Thu, Feb 28, 2019 at 5:22 PM R. Victor Klassen 
wrote:

> I know of no way to get that information automatically included.
>
> With the right format, you can get the name and address, and - if the
> information on the stubs is in the splits - the rest of the information
> more or less as shown.
> The lack of automation is in getting the information into the splits.
>
> With some moderate programming you could likely extract the information
> for the splits from a vendor report and then massage it into a format
> suitable to be imported as qif or perhaps csv, thereby automatically
> populating the splits.
> But I have no idea what your level of programming expertise is.
>
> > On Feb 28, 2019, at 2:09 PM, Greg Crawford 
> wrote:
> >
> > Hello,
> >
> > Please advise if I err in format or in conforming to mailing list rules.
> > I'm new to this and as well as to GNUCASH and open source programs.
> >
> > I've installed GNUCASH on my Windows 10 PC this month. I'm still trying
> to
> > figure out functions.
> >
> > When I print a check that I have paid bills with, I need it to display
> the
> > original bill information on the stubs. So far, I have only been able to
> > get it to display "Liabilities:Accounts Payable" and the total amount of
> > that bill.
> >
> > I've attached a sample check (generated from Quickbooks exported check
> data
> > by a VBA macro I wrote). This shows the information that I need on
> checks.
> > Is there a way to print checks in this manner from GNUCASH? Or, maybe a
> > report I can generate that will contain that information?
> >
> > Thanks for your help,
> > g
> >  PDF.pdf>___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Old Line Bank

[Thomas Moffett]

Thanks

Tom

sent from my Note 5

On Thu, Feb 28, 2019, 6:07 PM  wrote:

> I am using gnucash for the my accounting program and download the quicken
> information from my bank website directly since I am not using quicken I do
> not have to upgrade the quicken program. You have to open the bank's
> website from your computer's internet program and download the quicken
> information save the download data. I normally have gnucash already opened
> so that I can just click on the qnucash tab and import  the latest download
> from the bank.
>
> Get Outlook for Android 
>
>
>
>
> On Thu, Feb 28, 2019 at 5:37 PM -0500, "Thomas Moffett" <
> tlmoffet...@gmail.com> wrote:
>
>  I'm not sure I follow you. The point of switching to gnucash is so that I
>> no longer need to download into Quicken because they're cutting off my
>> online access unless I upgrade.
>>
>> It sounds like you're suggesting that I download into Quicken and then
>> import from Quicken into gnucash. Or am I completely misunderstanding your
>> suggestion?
>>
>> Tom
>>
>> sent from my Note 5
>>
>> On Thu, Feb 28, 2019, 5:20 PM  wrote:
>>
>>> I would use the the import function of gnu cash after downloading the
>>> quicken information from your bank website using your username and
>>> password. I use this method for all my online banking services that are not
>>> gnucash friendly.
>>>
>>> Joseph St Denis
>>>
>>> Get Outlook for Android 
>>>
>>>
>>>
>>>
>>> On Thu, Feb 28, 2019 at 4:29 PM -0500, "Tom Moffett" <
>>> tlmoffet...@gmail.com> wrote:
>>>
>>> Has anyone had success connecting to Old Line Bank?  It is listed in the
 database, but when I setup a user and attempt to retrieve a list of 
 accounts
 I get an error message that I have entered and incorrect username or
 password.  I questioned the bank's tech support folks and they had never
 heard of GnuCash.  They said they support Quicken (which I have been using
 successfully).  If I can't connect to this bank GnuCash won't work for me 
 at
 all.



 Thanks in advance for any help.



 Tom Moffett

 I hope to become the man my dog thinks I am.



 ___
 gnucash-user mailing listgnucash-u...@gnucash.org
 To update your subscription preferences or to 
 unsubscribe:https://lists.gnucash.org/mailman/listinfo/gnucash-user
 If you are using Nabble or Gmane, please see 
 https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
 -
 Please remember to CC this list on all your replies.
 You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Old Line Bank

[stdenis0--- via gnucash-user]

I am using gnucash for the my accounting program and download the quicken 
information from my bank website directly since I am not using quicken I do not 
have to upgrade the quicken program. You have to open the bank's website from 
your computer's internet program and download the quicken information save the 
download data. I normally have gnucash already opened so that I can just click 
on the qnucash tab and import  the latest download from the bank. 




Get Outlook for Android







On Thu, Feb 28, 2019 at 5:37 PM -0500, "Thomas Moffett"  
wrote:










 I'm not sure I follow you. The point of switching to gnucash is so that I no 
longer need to download into Quicken because they're cutting off my online 
access unless I upgrade.
It sounds like you're suggesting that I download into Quicken and then import 
from Quicken into gnucash. Or am I completely misunderstanding your suggestion?

Tom

sent from my Note 5
On Thu, Feb 28, 2019, 5:20 PM   wrote:
I would use the the import function of gnu cash after downloading the quicken 
information from your bank website using your username and password. I use this 
method for all my online banking services that are not gnucash friendly.




Joseph St Denis 




Get Outlook for Android







On Thu, Feb 28, 2019 at 4:29 PM -0500, "Tom Moffett"  
wrote:










Has anyone had success connecting to Old Line Bank?  It is listed in the
database, but when I setup a user and attempt to retrieve a list of accounts
I get an error message that I have entered and incorrect username or
password.  I questioned the bank's tech support folks and they had never
heard of GnuCash.  They said they support Quicken (which I have been using
successfully).  If I can't connect to this bank GnuCash won't work for me at
all.

 

Thanks in advance for any help.

 

Tom Moffett

I hope to become the man my dog thinks I am.

 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.











___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Old Line Bank

[Kenneth Schneider]

Download you transactions from the bank in CSV format for import directly to 
GNUcash. I’ve found this works very well. You will need to go through the 
process of bayeshen (?) matching but with time it works. There is going to be a 
learning curve but it’s not that steep.

Ken Schneider 

> On Feb 28, 2019, at 5:37 PM, Thomas Moffett  wrote:
> 
> I'm not sure I follow you. The point of switching to gnucash is so that I
> no longer need to download into Quicken because they're cutting off my
> online access unless I upgrade.
> 
> It sounds like you're suggesting that I download into Quicken and then
> import from Quicken into gnucash. Or am I completely misunderstanding your
> suggestion?
> 
> Tom
> 
> sent from my Note 5
> 
>> On Thu, Feb 28, 2019, 5:20 PM  wrote:
>> 
>> I would use the the import function of gnu cash after downloading the
>> quicken information from your bank website using your username and
>> password. I use this method for all my online banking services that are not
>> gnucash friendly.
>> 
>> Joseph St Denis
>> 
>> Get Outlook for Android 
>> 
>> 
>> 
>> 
>> On Thu, Feb 28, 2019 at 4:29 PM -0500, "Tom Moffett" <
>> tlmoffet...@gmail.com> wrote:
>> 
>> Has anyone had success connecting to Old Line Bank?  It is listed in the
>>> database, but when I setup a user and attempt to retrieve a list of accounts
>>> I get an error message that I have entered and incorrect username or
>>> password.  I questioned the bank's tech support folks and they had never
>>> heard of GnuCash.  They said they support Quicken (which I have been using
>>> successfully).  If I can't connect to this bank GnuCash won't work for me at
>>> all.
>>> 
>>> 
>>> 
>>> Thanks in advance for any help.
>>> 
>>> 
>>> 
>>> Tom Moffett
>>> 
>>> I hope to become the man my dog thinks I am.
>>> 
>>> 
>>> 
>>> ___
>>> gnucash-user mailing listgnucash-u...@gnucash.org
>>> To update your subscription preferences or to 
>>> unsubscribe:https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>> 
>>> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Old Line Bank

[Thomas Moffett]

 I'm not sure I follow you. The point of switching to gnucash is so that I
no longer need to download into Quicken because they're cutting off my
online access unless I upgrade.

It sounds like you're suggesting that I download into Quicken and then
import from Quicken into gnucash. Or am I completely misunderstanding your
suggestion?

Tom

sent from my Note 5

On Thu, Feb 28, 2019, 5:20 PM  wrote:

> I would use the the import function of gnu cash after downloading the
> quicken information from your bank website using your username and
> password. I use this method for all my online banking services that are not
> gnucash friendly.
>
> Joseph St Denis
>
> Get Outlook for Android 
>
>
>
>
> On Thu, Feb 28, 2019 at 4:29 PM -0500, "Tom Moffett" <
> tlmoffet...@gmail.com> wrote:
>
> Has anyone had success connecting to Old Line Bank?  It is listed in the
>> database, but when I setup a user and attempt to retrieve a list of accounts
>> I get an error message that I have entered and incorrect username or
>> password.  I questioned the bank's tech support folks and they had never
>> heard of GnuCash.  They said they support Quicken (which I have been using
>> successfully).  If I can't connect to this bank GnuCash won't work for me at
>> all.
>>
>>
>>
>> Thanks in advance for any help.
>>
>>
>>
>> Tom Moffett
>>
>> I hope to become the man my dog thinks I am.
>>
>>
>>
>> ___
>> gnucash-user mailing listgnucash-u...@gnucash.org
>> To update your subscription preferences or to 
>> unsubscribe:https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] BUSINESS CHECK PRINTING - BILLS PAID INFORMATION ON STUBS

[R. Victor Klassen]

I know of no way to get that information automatically included.

With the right format, you can get the name and address, and - if the 
information on the stubs is in the splits - the rest of the information more or 
less as shown.
The lack of automation is in getting the information into the splits.  

With some moderate programming you could likely extract the information for the 
splits from a vendor report and then massage it into a format suitable to be 
imported as qif or perhaps csv, thereby automatically populating the splits.
But I have no idea what your level of programming expertise is.

> On Feb 28, 2019, at 2:09 PM, Greg Crawford  wrote:
> 
> Hello,
> 
> Please advise if I err in format or in conforming to mailing list rules.
> I'm new to this and as well as to GNUCASH and open source programs.
> 
> I've installed GNUCASH on my Windows 10 PC this month. I'm still trying to
> figure out functions.
> 
> When I print a check that I have paid bills with, I need it to display the
> original bill information on the stubs. So far, I have only been able to
> get it to display "Liabilities:Accounts Payable" and the total amount of
> that bill.
> 
> I've attached a sample check (generated from Quickbooks exported check data
> by a VBA macro I wrote). This shows the information that I need on checks.
> Is there a way to print checks in this manner from GNUCASH? Or, maybe a
> report I can generate that will contain that information?
> 
> Thanks for your help,
> g
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Old Line Bank

[stdenis0--- via gnucash-user]

I would use the the import function of gnu cash after downloading the quicken 
information from your bank website using your username and password. I use this 
method for all my online banking services that are not gnucash friendly.




Joseph St Denis 




Get Outlook for Android







On Thu, Feb 28, 2019 at 4:29 PM -0500, "Tom Moffett"  
wrote:










Has anyone had success connecting to Old Line Bank?  It is listed in the
database, but when I setup a user and attempt to retrieve a list of accounts
I get an error message that I have entered and incorrect username or
password.  I questioned the bank's tech support folks and they had never
heard of GnuCash.  They said they support Quicken (which I have been using
successfully).  If I can't connect to this bank GnuCash won't work for me at
all.

 

Thanks in advance for any help.

 

Tom Moffett

I hope to become the man my dog thinks I am.

 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Old Line Bank

[Tom Moffett]

Has anyone had success connecting to Old Line Bank?  It is listed in the
database, but when I setup a user and attempt to retrieve a list of accounts
I get an error message that I have entered and incorrect username or
password.  I questioned the bank's tech support folks and they had never
heard of GnuCash.  They said they support Quicken (which I have been using
successfully).  If I can't connect to this bank GnuCash won't work for me at
all.

 

Thanks in advance for any help.

 

Tom Moffett

I hope to become the man my dog thinks I am.

 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Cashflow-like report to show realized and unrealized gains / balance sheet delta report

[csingley]

Setting aside my umbrage at GAAP-related gaslighting... Chary Chary, I think
what you're looking for is a custom report.  I believe GnuCash already
captures all the necessary data, it just doesn't treat unrealized as a
first-class citizen.

But for your purposes as I understand them, GAAP financial statements are
really a bit of a red herring.  You can do a lot better than GAAP compliance
for investment performance reporting!

Sadly, I lack the ability to knock up custom reports in Scheme that would
help fill this gap.  I'd be game to help anybody that does, though.  I'm
pretty familiar with the relevant calculations and their application to
performance reporting (this isn't really very difficult).


David Carlson-4 wrote
> On Thu, Feb 28, 2019 at 7:50 AM Chary Chary <

> chary314@

> > wrote:
> 
>> csingley,
>>
>> thanks for feedback.  I found the correct report name, which I think I
>> want. In finance 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.
>> 
>>
>> But I am not sure I understand the complexity to calculate it in gnucash.
>>
>> Once just has to walk through all records in the price database (stock
>> and
>> currency) and calculate net worth before and after change and log delta
>> as
>> a transaction in some virtual account.
>>
>>
>> Regards.
>>
>>
>> While it is probably possible to do that in GnuCash, it is well beyond
>> the
> scope of the design of GnuCash.  Particularly generating and tracking all
> of the necessary non-cash information in a manner that would satisfy an
> auditor who understood what you were doing would be mind-boggling to me.
> 
> I doubt that other users here have contemplated stretching GnuCash that
> far, and while several of us can help telling you details here and there
> about how parts of GnuCash work 'under the hood', you will have to do your
> own spadework to craft questions to ask us.
> 
> That said, GnuCash is very versatile and many users have figured out ways
> to stretch it to do amazing things.
> 
> Good luck with your ambitions.
> -- 
> David Carlson
> ___
> gnucash-user mailing list

> gnucash-user@

> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GnuCash Android is dead?

[GTI .H]

Em qui, 28 de fev de 2019 às 03:45, Ngewi Fet  escreveu:

> Hi GTI,
> Progress is slow due to personal circumstances of developers in the core
> team.
> We have to prioritize the very limited resources available at the moment.
> But the GitHub issues are being read.
>

Hi Ngewi Fet !!!

Thanks for the reply.
Only you're alive, I'm already very satisfied  ! 😀 !


> It is best to report issues directly on GitHub (or the developer mailing
> list:  gnucash-android-...@googlegroups.com )
>
> Cheers,
> Ngewi
>

Okay, and we have new issues to solve.


-- 
Regards
GTI
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Accounting for gold coins

[Michael or Penny Novack]

On 2/28/2019 10:01 AM, Gary Holtum wrote:

Adrien,

Thank you for the detailed response. I will work on the steps you describe but 
I am beginning to think GnuCash is not suited for providing the data I would 
like. Maybe an Excel spreadsheet would be easier. Thanks again for your 
expertise.

Gary
 The suggestions that have been made to you were based on the 
assumption "automatic calculation". Since manual would more or less be 
your situation using a spreadsheet, you should compare THAT to using 
manual processing in gnucash.


There would be nothing special about accounting for a fixed asset that 
just happened to be gold bars compared to a fixed asset that was an 
antique car (that you periodically remarked "to market"). Notice that 
this is what you would have to do if the gold or silver coin that had 
value OTHER than just as bullion. Or "stones".


Michael D Novack

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Cashflow-like report to show realized and unrealized gains / balance sheet delta report

[Michael or Penny Novack]

On 2/28/2019 8:43 AM, Chary Chary wrote:

csingley,

thanks for feedback.  I found the correct report name, which I think I
want. In finance 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.


I think this is what the initial questioner was after BUT not what words 
said as this is distinctly NOT "cash flow like". A person/business might 
be doing fine with regard to income/expense but be in trouble with cash 
flow and vice versa. Those are VERY different things, especially when 
unrealized gains are involved.


It is also important to note that for some comparisons, especially 
between "net worth" positions, our standard books are of little to no 
use except to provide some/most of the components making up net worth to 
be added to other components that do not have "book value" (not 
exchangeable for money, or not at a fair price)


Annuities would be an example of this (the right to receive a series of 
"rents", possibly "ay least x" but otherwise as long as one or more 
people are alive). Note that an actuary can compute the "present value" 
of such a right, it's what an insurance company would charge you for the 
right, but not salable for that amount (annuity sellers being desperate, 
they get a raw deal).


Besides annuities there are things like "life tenancies"

Thus if you wanted to describe the equivalent net worth of person you 
would take their book net worth and add things like the present value of 
any annuities, the estimated value of any life tenancies, etc.  
Especially if some of these "off book" components were large compared to 
the book components.


Remember, some of us are faced with choices involving options of this 
sort << for example, at retirement, your employer might offer you a 
choice >>


Michael D Novack

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Accounting for gold coins

[Gary Holtum]

Adrien,

Thank you for the detailed response. I will work on the steps you describe but 
I am beginning to think GnuCash is not suited for providing the data I would 
like. Maybe an Excel spreadsheet would be easier. Thanks again for your 
expertise.

Gary 

-Original Message-
From: gnucash-user 
[mailto:gnucash-user-bounces+diamondhranchqh=earthlink@gnucash.org] On 
Behalf Of Adrien Monteleone
Sent: Wednesday, February 27, 2019 11:35 AM
To: gnucash-user
Subject: Re: [GNC] Accounting for gold coins

Gary,

1. Turn on Trading Accounts.

File > Properties > Accounts > Use Trading Accounts

2. Set full transaction view options. (I find this helps to see everything 
about a transaction and to better understand double-entry)

View > Transactions Journal (optionally, View > Double Line)

3. Switch to formal accounting labels (again, helps to understand double-entry, 
the non-formal terms can get confusing I find)

Preferences > Accounts > Use Formal Accounting Labels

4. Set up your online quotes

a. If you have not already done so, read the relevant sections of the 
Help Manual
 * https://www.gnucash.org/docs/v3/C/gnucash-help/tool-price.html
 * 
https://www.gnucash.org/docs/v3/C/gnucash-help/tool-security-edit.html

b. Follow the instructions in the Help manual to setup Online Price 
Retrieval
 * 
https://www.gnucash.org/docs/v3/C/gnucash-help/acct-create.html#Online-price-setup
 * get your Alpha Vantage API key, and enter it in the Preferences > 
Online Quotes section

5. Add XAU as a Currency in the Price Editor

You can choose Bid, Ask, or Last as a price type, also available are: 
’Net’ which I’m not sure of, and ‘Unknown’ which I can’t fathom the purpose 
for. I went with ‘Last’ because that is what I had been tracking for years 
before I started using GnuCash, but ‘Bid’ is closest to what you will get if 
you sell on that day. (‘Bid' and ‘Ask' aren’t always available, ‘Last’ is 
reliable)

*note* XAU & XAG are spot prices of 1 ounce of metal. (XPT and XPD are 
available as well) But this does not mean the price quoted is what to expect to 
receive or pay. Rather, these are based on a 1 Kilogram contract (32.1507 Troy 
ounces) for Gold, or a 1000 Troy ounce contract for Silver. But it is likely 
the best approximation absent an actual buying/selling price from a real-world 
transaction.

You can always enter your own price quotes in the Price Editor manually 
if you like. (or you are having technical difficulties retrieving them)

6. Create your Asset holding account

You can place this in the Asset tree where you want, but for something 
more formal, I suggest:

Assets:Current Assets:Other (in my case, I labeled ‘Other’ as ‘Metals & 
Collectables’)

You’ll likely want to make that a Placeholder account so you don’t put 
any transactions in it and create sub accounts for each metal type:

Assets:Current Assets:Metals & Collectables:Gold Bullion
Assets:Current Assets:Metals & Collectables:Gold Numismatics
Assets:Current Assets:Metals & Collectables:Silver Bullion
Assets:Current Assets:Metals & Collectables:Silver Numismatics
etc.

Set this account as type ‘Cash’
Set the currency to XAU (or other metal as needed) for the bullion 
accounts.

You don’t need separate accounts for each form of bullion as bullion is 
valued all the same. (a bar or ingot is the same as a bullion coin for example) 
I do however set my Description or Notes to reflect what I actually purchased. 
(bars, Eagles, etc.) This allows me to do Transaction Reports to show those 
items if I wish.

For Numismatics, I set those accounts to my home currency and book them 
at actual purchase price. I don’t estimate any ‘unrealized gain’ on them as 
there is no way to tell what they might fetch at sale. (as a numismatic) If you 
want to track these as bullion instead, you can just lump them in the other 
account entered as their own fractions/multiples of metal.

7. Enter your Opening Balance

This is for any holdings prior to the date you want to start the 
account, usually the opening date of your file

a. Enter the amount of metal in ounces as a debit assigned to this 
account (already listed by default), using decimals as needed. (if you had a 
1-kilo bar, you’d enter XAU 32.1507 as the amount)
b. Assign the balancing split as a credit in your home currency to the 
Equity:Opening Balances account
c. When you hit [Enter] GnuCash will dutifully create the additional 
trading account splits to balance with your book’s home currency.

Here’s a generic 1oz. example using yesterday’s last price of 
$1328.67412 USD:

Dr. Assets:Current Assets:Metals & Collectables:Gold1.00
Dr. Trading:CURRENCY:USD$1328.67
Cr. Equity:Opening Balances   

Re: [GNC] Cashflow-like report to show realized and unrealized gains / balance sheet delta report

[David Carlson]

On Thu, Feb 28, 2019 at 7:50 AM Chary Chary  wrote:

> csingley,
>
> thanks for feedback.  I found the correct report name, which I think I
> want. In finance 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.
> 
>
> But I am not sure I understand the complexity to calculate it in gnucash.
>
> Once just has to walk through all records in the price database (stock and
> currency) and calculate net worth before and after change and log delta as
> a transaction in some virtual account.
>
>
> Regards.
>
>
> While it is probably possible to do that in GnuCash, it is well beyond the
scope of the design of GnuCash.  Particularly generating and tracking all
of the necessary non-cash information in a manner that would satisfy an
auditor who understood what you were doing would be mind-boggling to me.

I doubt that other users here have contemplated stretching GnuCash that
far, and while several of us can help telling you details here and there
about how parts of GnuCash work 'under the hood', you will have to do your
own spadework to craft questions to ask us.

That said, GnuCash is very versatile and many users have figured out ways
to stretch it to do amazing things.

Good luck with your ambitions.
-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Cashflow-like report to show realized and unrealized gains / balance sheet delta report

[csingley via gnucash-user]

Chary Chary,

Generally, foreign currency/exchange and derivatives/hedging transactions
belong in the statement of comprehensive income.

Current GAAP mandates that unrealized gain/loss from equity securities be
included on the income statement (usually as "other income").

http://www.fasb.org/jsp/FASB/Document_C/DocumentPage?cid=1176167762170&acceptedDisclaimer=true

Companies have been dragging their heels about adopting ASU 2016-01, because
they prefer to keep this volatility off their income statement & stick it
under the statement of comprehensive income (which is much less analyzed b/c
less significant).

However, the FASB has been very insistent about fair valuing all the things,
and running those balance sheet changes through net income.  They view this
as a top priority in updating GAAP.

The people who set the accounting standards (both in USA and globally...
IFRS is similar on this point) are vigorously opposed to the viewpoint that
we should ignore unrealized gains and just value things at cost.  They're
working hard to pull this idea up by the roots, despite some stubborn
opposition.

Happily, free software can hide from their baleful scrutiny and continue to
resist the man.  But we shouldn't be under any illusions that the way we
handle investments in GnuCash represents best accounting practice.  Quite
the opposite is true, really.


Chary Chary wrote
> csingley,
> 
> thanks for feedback.  I found the correct report name, which I think I
> want. In finance 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.
> 
> 
> But I am not sure I understand the complexity to calculate it in gnucash.
> 
> Once just has to walk through all records in the price database (stock and
> currency) and calculate net worth before and after change and log delta as
> a transaction in some virtual account.
> 
> 
> Regards.
> 
> 
> 
> On Wed, Feb 27, 2019 at 6:48 PM csingley <

> csingley@

> > wrote:
> 
>> Adrien Monteleone-2 wrote
>> > Keep in mind, except for very special circumstances, for most people,
>> > ‘unrealized gains’ are simply a ‘what if’ level of thinking. They do
>> not
>> > belong in your books. Only actual realized gains are reflected there.
>>
>> I don't think "owning investments" counts as very special
>> circumstances...
>> and for investments, carrying them at historical cost is really the "what
>> if" thinking.  The entire profession of accountancy has risen up with one
>> voice to declare loudly that financial assets are worth what you can sell
>> them for today, and anchoring on your cost basis is bad accounting that
>> leads to bad decisions.  In fact, Deutsche Bank is currently being widely
>> shamed in the financial press for just this very sin (refusing to write
>> down
>> some horrible mortgage deals until they actually disposed of them years
>> later).
>>
>> If you buy a stock, and it becomes worthless, you are *actually poorer*
>> even
>> if you don't realize the loss.  Conversely, try telling long-time
>> Berkshire
>> Hathaway stockholders that their position deserves a 95% haircut, even if
>> they can sell their BRK stock today and exchange it for bonds that would
>> pay
>> an annual income equal to their cost basis in BRK.  Guess they'd better
>> postpone retirement until they sell their stock... "Using this one weird
>> accounting trick, he increased his safe retirement withdrawal 10x with
>> the
>> click of a mouse!  CFPs hate him!!"
>>
>> Looking only at realized gains can be fine if you just want to report
>> *what
>> happened*, as for paying taxes.  However, if you want financial reports
>> that
>> help you decide *what to do*, it's unhelpful to convince yourself that
>> unrealized gains don't exist.
>>
>> It's not really "what if" to examine your winners & losers, and decide to
>> rebalance your portfolio accordingly.  It's not really "what if" to look
>> at
>> how much in unrealized losses you have to offset realized gains in order
>> to
>> manage your tax bill.  These are not weird corner cases, they are primary
>> concerns of the users of these financial reports (like the OP).
>>
>> They're just a pain to implement.  They're not wrong-headed.
>>
>>
>> Adrien Monteleone-2 wrote
>> > If the gain is unrealized, then the account balance has not changed.
>> >
>> > If you physically (or in a bank account) have USD 1000 at the beginning
>> of
>> > the year because you traded EUR 1000 at a 1:1 rate, and at the end of
>> the
>> > year, have not done anything with that USD 1000, you still only have
>> USD
>> > 1000.
>> >
>> > GnuCash might value this at 

Re: [GNC] Cashflow-like report to show realized and unrealized gains / balance sheet delta report

[Chary Chary]

csingley,

thanks for feedback.  I found the correct report name, which I think I
want. In finance 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.


But I am not sure I understand the complexity to calculate it in gnucash.

Once just has to walk through all records in the price database (stock and
currency) and calculate net worth before and after change and log delta as
a transaction in some virtual account.


Regards.



On Wed, Feb 27, 2019 at 6:48 PM csingley  wrote:

> Adrien Monteleone-2 wrote
> > Keep in mind, except for very special circumstances, for most people,
> > ‘unrealized gains’ are simply a ‘what if’ level of thinking. They do not
> > belong in your books. Only actual realized gains are reflected there.
>
> I don't think "owning investments" counts as very special circumstances...
> and for investments, carrying them at historical cost is really the "what
> if" thinking.  The entire profession of accountancy has risen up with one
> voice to declare loudly that financial assets are worth what you can sell
> them for today, and anchoring on your cost basis is bad accounting that
> leads to bad decisions.  In fact, Deutsche Bank is currently being widely
> shamed in the financial press for just this very sin (refusing to write
> down
> some horrible mortgage deals until they actually disposed of them years
> later).
>
> If you buy a stock, and it becomes worthless, you are *actually poorer*
> even
> if you don't realize the loss.  Conversely, try telling long-time Berkshire
> Hathaway stockholders that their position deserves a 95% haircut, even if
> they can sell their BRK stock today and exchange it for bonds that would
> pay
> an annual income equal to their cost basis in BRK.  Guess they'd better
> postpone retirement until they sell their stock... "Using this one weird
> accounting trick, he increased his safe retirement withdrawal 10x with the
> click of a mouse!  CFPs hate him!!"
>
> Looking only at realized gains can be fine if you just want to report *what
> happened*, as for paying taxes.  However, if you want financial reports
> that
> help you decide *what to do*, it's unhelpful to convince yourself that
> unrealized gains don't exist.
>
> It's not really "what if" to examine your winners & losers, and decide to
> rebalance your portfolio accordingly.  It's not really "what if" to look at
> how much in unrealized losses you have to offset realized gains in order to
> manage your tax bill.  These are not weird corner cases, they are primary
> concerns of the users of these financial reports (like the OP).
>
> They're just a pain to implement.  They're not wrong-headed.
>
>
> Adrien Monteleone-2 wrote
> > If the gain is unrealized, then the account balance has not changed.
> >
> > If you physically (or in a bank account) have USD 1000 at the beginning
> of
> > the year because you traded EUR 1000 at a 1:1 rate, and at the end of the
> > year, have not done anything with that USD 1000, you still only have USD
> > 1000.
> >
> > GnuCash might value this at EUR 2000 for the purpose of balancing your
> > books, but what you actually hold has not changed. Your bank isn’t going
> > to report that you now have EUR 2000 instead of USD 1000.
> >
> > Now, if you trade that USD 1000 back to EUR at the new rate, then and
> only
> > then will you really have EUR 2000 - a realized gain.
> >
> > If you are using multiple currencies properly, the USD account should
> > reflect USD 1000, not EUR 2000.
> >
> > If you want to see why the GnuCash balance sheet might reflect a
> valuation
> > change on a currency or commodity, turn on Trading Accounts, select them
> > in the report options and also choose the option to show exchange rates.
> >
> > If you look at the exchange rates for the end of last year balance sheet
> > and new balance sheet, they difference will reflect the value assigned to
> > the ’Trading Gain/Loss’ line.
> >
> > Keep in mind, except for very special circumstances, for most people,
> > ‘unrealized gains’ are simply a ‘what if’ level of thinking. They do not
> > belong in your books. Only actual realized gains are reflected there.
> > (even being required to ‘mark to market’ would be handled by a
> transaction
> > to realize any gain/loss)
> >
> > Regards,
> > Adrien
> >
> >> On Feb 27, 2019, at 4:18 AM, Chary Chary <
>
> > chary314@
>
> > > wrote:
> >>
> >> Christopher,
> >>
> >> thanks.
> >>
> >> But I must say, I still have a sneaky feeling, that I may be missing
> >> something, because I just don't understand how people who deal with
> >> several
> >> currencie

Re: [GNC] Help! Decimal point won't enter; description freezes

[Colin Law]

On Thu, 28 Feb 2019 at 09:58, Finbar Mahon  wrote:
>
> OK, thanks, will do that.  Meanwhile a save>quit and restart seems to
> have sorted the issues.

That will have overwritten the trace file I think.

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Help! Decimal point won't enter; description freezes

[Finbar Mahon]

OK, thanks, will do that.  Meanwhile a save>quit and restart seems to 
have sorted the issues.


Thanks.

On 27/02/2019 15:09, Colin Law wrote:

Have a look in the gnucash trace file to see if there is anything of note there.

Colin

On Wed, 27 Feb 2019 at 11:53, Finbar Mahon  wrote:

Hello,

Using - Version: 3.4
Build ID: 3.4+ (2018-12-30)

On Windows 10 Home, version 1803, on a Lenovo PC

Entering data in a bank account, exisiting, not new.

Entering description, freezes, won't move on; then, if it does, entering
amount won't take the decimal point.

This does not happen for every entry, but when it does it is irritating,
sometimes the work around is to delete the transaction and retry, but
not always.

Finbar

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.