Re: [GNC] What does OFX Direct Connect do?

[jean laroche]

On 5/18/2020 9:38 PM, GWB wrote:

When GnuCash imports OFX transactions, it can tell (almost always?
most of the time?) if that particular transaction has already been
recorded in the ledger.  I find that helpful.  The most time consuming
part of the process for me is assigning categories, transfer accounts,
and determining if it is a split transaction (that I usually do in
another step after importing).


You'd be better off assigning accounts ("categories") from the import 
matching dialog, not after the fact, because that's the only time the 
bayesian matching learns.
If you do it after the fact, GC will never learn to assign accounts 
based on your history. In my experience, it becomes very good at it, so 
now I almost never have to correct an assigned transfer account (category).

Jean
___
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] What does OFX Direct Connect do?

[GWB]

OFX as a format does several things CSV does not.  It can give a
unique transaction ID, which the software can then "remember" if there
are a number of repeated transactions of the same amount and similar
dates.  With OFX, you know they are unique transactions because of the
unique identifier.

When GnuCash imports OFX transactions, it can tell (almost always?
most of the time?) if that particular transaction has already been
recorded in the ledger.  I find that helpful.  The most time consuming
part of the process for me is assigning categories, transfer accounts,
and determining if it is a split transaction (that I usually do in
another step after importing).

If there is no other option, CSV can work, and QFX is very close to
OFX (but it adds that hint of evil John mentioned).  I dislike the way
most banks implement Direct Connect, but others think it works fine
for them, and is secure enough.  I connect to the institution using a
VPN and then download the data in all the formats they allow (if they
don't allow downloads, then I'm forced to use Direct Connect).  I then
have an OFX, QFX, CSV and ocassionally QIF files (usually separate
files by month).  That's obviously overkill, but if the OFX download
is missing some data, or gets corrupted, I have the other one as a
check.

And, of course, I do this wearing a tin foil hat (just kidding! I use
Velostat for all my alien mind control prevention).

You would probably be fine just download the OFX file and then
importing the transaction like John describes (File>Import>Import
OFX/QFX).  Use a relatively updated web browser (like brave, but
chrome, firefox, work) and your bank will encrypt the connection with
https.  If you don't see "https" or a locking icon in the browser bar,
then ask your bank about that (you won't get a person on the phone, so
better to google "Is my browser connection encrypted?").  Most people
are fine with that, but assess your own risk.

Gordon

On Mon, May 18, 2020 at 10:09 PM John Ralls  wrote:
>
> No, OFX is a file format. Many financial/bank websites offer OFX or QFX 
> downloads of your transaction data; more in fact than offer OFX Direct 
> Connect. Since OFX (and it's slightly altered evil twin QFX, for Quicken 
> Financial eXchange) are formats expressly designed for transferring consumer 
> transaction information it's a more efficient and less error prone way to 
> import transactions into programs like GnuCash.
>
> If your bank offers OFX Direct Connect then GnuCash can connect to your bank 
> and get that OFX download. If not but allows downloading OFX-formatted files 
> then you go to the bank website, log in, and get the download, then use 
> File>Import>Import OFX/QFX to import it.
>
> Regards,
> John Ralls
>
> > On May 18, 2020, at 2:20 PM, Fran_3  wrote:
> >
> > Woops! No ill intent. I've seen the same response on other SIG's when 
> > someone started a new thread that a groups member or admin thought should 
> > have been included in a recent thread on that some related topic. Oh well.
> >
> > Back to the topic... so OFX just saves you the steps of downloading the 
> > transactions as CSV and then having to do a bit of formatting before you 
> > import them into GC... right?
> >
> >
> >
> > On Monday, May 18, 2020, 1:48:19 PM EDT, John Ralls  
> > wrote:
> >
> >
> > Don't hijack threads, it's rude. Start a new one when you have a new 
> > question.
> >
> > OFX Direct Connect is just like importing an OFX or QFX file downloaded 
> > from your bank's website except that it will connect to the bank and get 
> > the OFX file for you.
> >
> > Regards,
> > John Ralls
> >
> >
> > > On May 18, 2020, at 10:27 AM, Fran_3  wrote:
> > >
> > > If I can jump in here I would like to learn more about OFX Direct Connect 
> > > with GnuCash.
> > >
> > > Does such automatically determine what transactions occur at the bank 
> > > that are not in GC...
> > > And then automatically update GnuCash?
> > >
> > > Or what?
> > >
> > > Thanks.
> > >
> > >
> > > On Monday, May 18, 2020, 12:35:10 PM EDT, John Ralls  
> > > wrote:
> > >
> > >
> > >
> > >
> > > > On May 17, 2020, at 12:06 PM, Hershey  wrote:
> > > >
> > > > I'm new to Gnu and am having issues setting up online downloads.
> > > > My first attempt is Wells Fargo and I get a 2000 error message.
> > > > The Tutorial show Wells Fargo in its example but I've also seen this
> > > > statement on the web: Wells Fargo has switched to OFX Web Connect. 
> > > > GnuCash
> > > > doesn't support this authentication.
> > >
> > > That last sentence is your answer, but perhaps you need some more detail. 
> > > There are two ways of connecting to a bank for OFX online communication, 
> > > OFX Direct Connect and OFX Web Connect. The former collects your user 
> > > name and password as part of the online session and the latter has you 
> > > log in to the bank's website and launch the OFX session from there. The 
> > > way that the bank's website connects to the financial software is 
> > > 

Re: [GNC] What does OFX Direct Connect do?

[John Ralls]

No, OFX is a file format. Many financial/bank websites offer OFX or QFX 
downloads of your transaction data; more in fact than offer OFX Direct Connect. 
Since OFX (and it's slightly altered evil twin QFX, for Quicken Financial 
eXchange) are formats expressly designed for transferring consumer transaction 
information it's a more efficient and less error prone way to import 
transactions into programs like GnuCash.

If your bank offers OFX Direct Connect then GnuCash can connect to your bank 
and get that OFX download. If not but allows downloading OFX-formatted files 
then you go to the bank website, log in, and get the download, then use 
File>Import>Import OFX/QFX to import it.

Regards,
John Ralls

> On May 18, 2020, at 2:20 PM, Fran_3  wrote:
> 
> Woops! No ill intent. I've seen the same response on other SIG's when someone 
> started a new thread that a groups member or admin thought should have been 
> included in a recent thread on that some related topic. Oh well.
> 
> Back to the topic... so OFX just saves you the steps of downloading the 
> transactions as CSV and then having to do a bit of formatting before you 
> import them into GC... right?
> 
> 
> 
> On Monday, May 18, 2020, 1:48:19 PM EDT, John Ralls  
> wrote:
> 
> 
> Don't hijack threads, it's rude. Start a new one when you have a new question.
> 
> OFX Direct Connect is just like importing an OFX or QFX file downloaded from 
> your bank's website except that it will connect to the bank and get the OFX 
> file for you.
> 
> Regards,
> John Ralls
> 
> 
> > On May 18, 2020, at 10:27 AM, Fran_3  wrote:
> > 
> > If I can jump in here I would like to learn more about OFX Direct Connect 
> > with GnuCash.
> > 
> > Does such automatically determine what transactions occur at the bank that 
> > are not in GC...
> > And then automatically update GnuCash?
> > 
> > Or what?
> > 
> > Thanks.
> > 
> > 
> > On Monday, May 18, 2020, 12:35:10 PM EDT, John Ralls  
> > wrote:
> > 
> > 
> > 
> > 
> > > On May 17, 2020, at 12:06 PM, Hershey  wrote:
> > > 
> > > I'm new to Gnu and am having issues setting up online downloads.
> > > My first attempt is Wells Fargo and I get a 2000 error message.
> > > The Tutorial show Wells Fargo in its example but I've also seen this
> > > statement on the web: Wells Fargo has switched to OFX Web Connect. GnuCash
> > > doesn't support this authentication.
> > 
> > That last sentence is your answer, but perhaps you need some more detail. 
> > There are two ways of connecting to a bank for OFX online communication, 
> > OFX Direct Connect and OFX Web Connect. The former collects your user name 
> > and password as part of the online session and the latter has you log in to 
> > the bank's website and launch the OFX session from there. The way that the 
> > bank's website connects to the financial software is proprietary to Intuit, 
> > the makers of Quicken, so that it works only with their products. GnuCash 
> > is able to work only with OFX Direct Connect.
> > 
> > Regards,
> > John Ralls
> > 
> > ___
> > 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] Use of Webkit-GTK in GNC

[John Ralls]

> On May 18, 2020, at 11:51 AM, Mark Sutton  wrote:
> 
> On Mon, May 18, 2020 at 10:48:12AM -0700, John Ralls wrote:
>> Don't hijack threads, it's rude. Start a new one when you have a new 
>> question.
>> 
>> OFX Direct Connect is just like importing an OFX or QFX file downloaded from 
>> your bank's website except that it will connect to the bank and get the OFX 
>> file for you.
> 
> I hope this does not seem like a hijack, but this discussion made me think
> I should ask a question that has been on my mind since Jan.
> What is the use profile of webkit in gnucash. I thought for some reason
> it only was used to render reports  created by gnucash. ie. never interacts
> with foreign data. Is that correct? I wonder because of remote exploit-ability
> of versions prior to 2.26.3.

At least you changed the subject line, but I don't see why you didn't just 
create a new message instead of replying to an unrelated one.

Yes, GnuCash uses webkit only for rendering reports and doesn't expose the 
WebKit API to scripting, though a bad actor with privs to install arbitrary 
files into a users directory could get WebKit to read a maliciously installed 
file. On the other hand if a bad actor has that kind of access to your machine 
there are probably less arcane ways cause trouble.

Regards,
John Ralls

___
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] Use of Webkit-GTK in GNC

[Mark Sutton]

On Mon, May 18, 2020 at 10:48:12AM -0700, John Ralls wrote:
> Don't hijack threads, it's rude. Start a new one when you have a new question.
> 
> OFX Direct Connect is just like importing an OFX or QFX file downloaded from 
> your bank's website except that it will connect to the bank and get the OFX 
> file for you.

I hope this does not seem like a hijack, but this discussion made me think
I should ask a question that has been on my mind since Jan.
What is the use profile of webkit in gnucash. I thought for some reason
it only was used to render reports  created by gnucash. ie. never interacts
with foreign data. Is that correct? I wonder because of remote exploit-ability
of versions prior to 2.26.3.

Thanks, Mark
___
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] What does OFX Direct Connect do?

[Fran_3 via gnucash-user]

 Woops! No ill intent. I've seen the same response on other SIG's when someone 
started a new thread that a groups member or admin thought should have been 
included in a recent thread on that some related topic. Oh well.

Back to the topic... so OFX just saves you the steps of downloading the 
transactions as CSV and then having to do a bit of formatting before you import 
them into GC... right?


On Monday, May 18, 2020, 1:48:19 PM EDT, John Ralls  
wrote:  
 
 Don't hijack threads, it's rude. Start a new one when you have a new question.

OFX Direct Connect is just like importing an OFX or QFX file downloaded from 
your bank's website except that it will connect to the bank and get the OFX 
file for you.

Regards,
John Ralls


> On May 18, 2020, at 10:27 AM, Fran_3  wrote:
> 
> If I can jump in here I would like to learn more about OFX Direct Connect 
> with GnuCash.
> 
> Does such automatically determine what transactions occur at the bank that 
> are not in GC...
> And then automatically update GnuCash?
> 
> Or what?
> 
> Thanks.
> 
> 
> On Monday, May 18, 2020, 12:35:10 PM EDT, John Ralls  
> wrote:
> 
> 
> 
> 
> > On May 17, 2020, at 12:06 PM, Hershey  wrote:
> > 
> > I'm new to Gnu and am having issues setting up online downloads.
> > My first attempt is Wells Fargo and I get a 2000 error message.
> > The Tutorial show Wells Fargo in its example but I've also seen this
> > statement on the web: Wells Fargo has switched to OFX Web Connect. GnuCash
> > doesn't support this authentication.
> 
> That last sentence is your answer, but perhaps you need some more detail. 
> There are two ways of connecting to a bank for OFX online communication, OFX 
> Direct Connect and OFX Web Connect. The former collects your user name and 
> password as part of the online session and the latter has you log in to the 
> bank's website and launch the OFX session from there. The way that the bank's 
> website connects to the financial software is proprietary to Intuit, the 
> makers of Quicken, so that it works only with their products. GnuCash is able 
> to work only with OFX Direct Connect.
> 
> Regards,
> John Ralls
> 
> ___
> 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] Why does Reconciled field auto mark "n" & "c"

[David Cousens]

Fran,

If during the import GnuCash matches an imported transaction to an existing
transaction depending on how close the match is it is marked for update,
(U+C) checked or not to be imported, (C) checked in the import matcher
window. Otherwise the A checkbox is checked and the transaction is marked
for import. (These were previously U+R and R columns in the matcher).

When U+C is checked information in the matching record (amount and value of
the matching split,imbalance, description, notes) is updated from the
imported record and the matching record 's reconcile status is set as as
cleared ('c') and the reconciliation date of the matched GnuCash transaction
record is set to today if it's reconcile status is not reconciled (i.e. it
is not 'y'). 

If C is checked in the matcher, the reconcile status of the matching
transaction in GnuCash is set as 'c' 
and the reconcile date is set to today on import if the matching transaction
is not reconciled (i.e. reconcile status is not 'y') and any online ID in
the imported record is copied to the matched record when imported.

If A is checked in the import matcher, the record is imported, the reconcile
status is also set to 'c' and the reconcile date to today.

The rationale is that in importing a rceord from the internal source which
matches an existing record you have confirmed that the record exists both in
your records and the banks records (you have not confirmed that the balance
for the accounts match however with this reord included so it is not marked
as reconciled).

David Cousens



-
David Cousens
--
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] Fwd: Tips for maintining different accounting for different countries?

[James Cook]

> Hello, James:

Thanks, Jim, your responses are helpful.

A couple of follow-up questions about doing cost-basis tracking outside
of GnuCash (either for Jim or for the list):

* When you do cost-basis tracking in a separate spreadsheet, do you have
  a way to reconcile that with what you have in GnuCash, to make sure
  everything's consistent? (I had been hoping to make my life simpler by
  having a single source of truth, though as you point out, my scheme
  may overcomplicate things.)

* I see your point that my scheme is too complicated. But is using
  separate cost-basis spreadsheets simpler than, e.g, using a separate
  set of GnuCash accounts, or even separate GnuCash files if I want to
  keep that stuff really really separate? I guess I'm just wondering
  whether spreadsheets are inherently simpler than GnuCash for some
  accounting tasks.

The rest of my email is just responses; no new questions below this
line.

--

I will look into finding a tax preparer. My employer paid for my 2018
taxes to be done professionally, because that was the year I moved to
Canada and was therefore especially complicated. I was hoping this year
I could just use my 2018 taxes as a template, but there are a couple of
new twists, and after reading your advice I'm reconsidering.

>  > …if I sell a stock, the realized gains for Canada are based on
> adjusted cost
>  > base, but for the US I can decide which instance of the stock I'm
> selling.…
>
> I have done almost all my cost basis tracking outside of GnuCash, in a
> spreadsheet. Consider if this might be the easier way for you also. And,
> remember that you don't have to take advantage of all the complexity
> that the regs permit you.  Why pick specific lots (pro tip, the GnuCash
> docs call them "lots", not "instances") for your sales, instead of using
> a simpler practice like "first-in-first-out" (FIFO)? You are allowed to
> choose to make your life easier.

My concern was that I'm not sure there's a simple way to satisfy both
Canada and the US. Now that you mention it, I guess there's nothing
stopping me from reporting adjusted cost base to the US. That would at
least make my two returns consistent, but I'd have to look into whether
that makes my US return more complicated due to each sell being matched
to multiple buys.

> I recommend turning on GnuCash's currency trading accounts, as described
> in /Trading Accounts/ 
> in the GnuCash wiki. If you find out things which that page does not
> explain well, please edit the page to improve it.

Yes, I found the tutorial when I was trying to figure out what that
GnuCash option did. I had not seen the GnuCash wiki page on it, though,
so thanks for that.

> So, I have six accounts for medical expenses: Medical:Spouse A:CAD,
> Medical:Spouse A:USD, Medical:Spouse B:CAD, Medical:Spouse B:USD,
> Medical:Non-deductible:CAD, and Medical:Non-deductible:USD.  It is easy
> to assign each expense to one of the accounts based on what currency it
> is in, who it is for, and whether it is deductible in both countries or
> not. For one Canadian individual return, I export totals from
> Medical:Spouse A:CAD, Medical:Spouse A:USD. For the other Canadian
> individual return, I export totals from both Medical:Spouse B:…
> accounts. For the US joint return, I export totals from both all four
> Medical:Spouse A:… and Medical:Spouse B:… accounts. If there are
> expenses which are deductible in one country but not the other, I
> haven't discovered them, or they aren't significant enough to be worth
> tracking.

Thanks, that is a helpful example. I'm still considering using my idea
for adjustment accounts rather than an account for every combination
when it comes to situations like this. I think the total number of
accounts would end up being similar with both approaches. Your idea is
probably a bit more practical, but I can't resist trying to design
something that scales linearly (rather than exponentially) with the
number of tax juridictions, even though in practice N=2 or 3 and really
I'd need only 2-3 accounts.

> Finally, don't be afraid to start simple and modify as you go. GnuCash
> lets you easily rename accounts and change the hierarchical structure of
> accounts without losing data. If you decide to merge two accounts, or
> split one account into two, then you need to go through every
> transaction in those accounts and reassign them, but that might be a
> surprisingly tractable task. It certainly doesn't require touching every
> transaction.

This last piece of advice is also really helpful. I was wondering how
important it is to get everything right when I start out, but now I feel
a bit bolder about jumping in.

- James
___
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 

Re: [GNC] Is there a better way enter multi-currency split transaction?

[Derek Atkins]

John Ralls  writes:

> Trading splits are ignored; they don't turn on the ---split
> transaction--- flag in the Transfer Account cell. I think what's
> causing grief is the no-value Asset:Stock:ABC split.

Oh, yeah, you're absolutely right.  That extra split in there is what's
causing the confusion!

> Regards,
> John Ralls

-derek
-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
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] Report seems to pull wrong amount from transaction

[Derek Atkins]

Adrien Monteleone  writes:

> Originally I was thinking of the setting for GC to determine price by
> ‘Most Recent’ or ‘Nearest In Time’, and such, but I see the
> Transaction Report doesn’t have it.

As indeed it shouldn't.  A transaction has a fixed exchange rate, and
that's the exchange rate that should be used for that transaction in the
transaction report.

The only arguable place where an "other" exchange rate should come in
during a transaction report is if you have a transaction between X and Y
but you're trying to display a report in currency Z.  Then the question
is, if the transaction from X to Y happens at date D, and you're running
the report on date E, what exchange rate should you use for the
transaction?  Note that I don't think there is one right answer for this
question.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek
-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
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] What does OFX Direct Connect do?

[John Ralls]

Don't hijack threads, it's rude. Start a new one when you have a new question.

OFX Direct Connect is just like importing an OFX or QFX file downloaded from 
your bank's website except that it will connect to the bank and get the OFX 
file for you.

Regards,
John Ralls


> On May 18, 2020, at 10:27 AM, Fran_3  wrote:
> 
> If I can jump in here I would like to learn more about OFX Direct Connect 
> with GnuCash.
> 
> Does such automatically determine what transactions occur at the bank that 
> are not in GC...
> And then automatically update GnuCash?
> 
> Or what?
> 
> Thanks.
> 
> 
> On Monday, May 18, 2020, 12:35:10 PM EDT, John Ralls  
> wrote:
> 
> 
> 
> 
> > On May 17, 2020, at 12:06 PM, Hershey  wrote:
> > 
> > I'm new to Gnu and am having issues setting up online downloads.
> > My first attempt is Wells Fargo and I get a 2000 error message.
> > The Tutorial show Wells Fargo in its example but I've also seen this
> > statement on the web: Wells Fargo has switched to OFX Web Connect. GnuCash
> > doesn't support this authentication.
> 
> That last sentence is your answer, but perhaps you need some more detail. 
> There are two ways of connecting to a bank for OFX online communication, OFX 
> Direct Connect and OFX Web Connect. The former collects your user name and 
> password as part of the online session and the latter has you log in to the 
> bank's website and launch the OFX session from there. The way that the bank's 
> website connects to the financial software is proprietary to Intuit, the 
> makers of Quicken, so that it works only with their products. GnuCash is able 
> to work only with OFX Direct Connect.
> 
> Regards,
> John Ralls
> 
> ___
> 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] wells fargo downloads

[Fran_3 via gnucash-user]

 If I can jump in here I would like to learn more about OFX Direct Connect with 
GnuCash.
Does such automatically determine what transactions occur at the bank that are 
not in GC...And then automatically update GnuCash?
Or what?
Thanks.

On Monday, May 18, 2020, 12:35:10 PM EDT, John Ralls  
wrote:  
 
 

> On May 17, 2020, at 12:06 PM, Hershey  wrote:
> 
> I'm new to Gnu and am having issues setting up online downloads.
> My first attempt is Wells Fargo and I get a 2000 error message.
> The Tutorial show Wells Fargo in its example but I've also seen this
> statement on the web: Wells Fargo has switched to OFX Web Connect. GnuCash
> doesn't support this authentication.

That last sentence is your answer, but perhaps you need some more detail. There 
are two ways of connecting to a bank for OFX online communication, OFX Direct 
Connect and OFX Web Connect. The former collects your user name and password as 
part of the online session and the latter has you log in to the bank's website 
and launch the OFX session from there. The way that the bank's website connects 
to the financial software is proprietary to Intuit, the makers of Quicken, so 
that it works only with their products. GnuCash is able to work only with OFX 
Direct Connect.

Regards,
John Ralls
___
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] wells fargo downloads

[John Ralls]

> On May 17, 2020, at 12:06 PM, Hershey  wrote:
> 
> I'm new to Gnu and am having issues setting up online downloads.
> My first attempt is Wells Fargo and I get a 2000 error message.
> The Tutorial show Wells Fargo in its example but I've also seen this
> statement on the web: Wells Fargo has switched to OFX Web Connect. GnuCash
> doesn't support this authentication.

That last sentence is your answer, but perhaps you need some more detail. There 
are two ways of connecting to a bank for OFX online communication, OFX Direct 
Connect and OFX Web Connect. The former collects your user name and password as 
part of the online session and the latter has you log in to the bank's website 
and launch the OFX session from there. The way that the bank's website connects 
to the financial software is proprietary to Intuit, the makers of Quicken, so 
that it works only with their products. GnuCash is able to work only with OFX 
Direct Connect.

Regards,
John Ralls
___
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] Why does Reconciled field auto mark "n" & "c"

[Fran_3 via gnucash-user]

I've been importing csv files into checking with only 5 fields in each import...
Date, Num, Description, Deposit, Withdrawal
During the import process I assign the appropriated expense or income account 
and it works fine.
I also manually enter some transactions.
The Question: 

The Reconciliation column ("R" column) seems to be auto choosing either a "n" 
or"c"What is causing that?
Thanks for any help.


___
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] Reconciliation "R" column question

[Fran_3 via gnucash-user]

 Yes that did help. Thank.

On Monday, May 18, 2020, 9:57:13 AM EDT, Derek Atkins  
wrote:  
 
 Hi,

The three* values (at least in English) are n, c, and y.

Yes, you may freely swap between n and c in the register.  It just causes
a recomputation of account balances.

I do not believe you can get to 'y' without going through formal
reconciliation.  I.e., I don't think you can type 'y' in there and have it
be accepted, although I admit I've never tried to do that.  It would be
missing the "reconcile date" metadata for one thing.

Hope this helps.

-derek

* There is also a 'v' (void) status.

On Mon, May 18, 2020 9:41 am, Fran_3 via gnucash-user wrote:
> In Help 2.94 Reconciliation... "R" column choices are...
> n = not cleared the bankc = cleared the bankr = Reconciled
> I've got the GnuCash Check Register open in one window and I'm logged on
> to the bank in another window looking at recent transactions...I'm trying
> to make sure each bank transaction has been entered into GC.I'm not doing
> a formal monthly reconciliation... this is just an end of day check up.
>
> Question 1: May I freely change "n" and "c" back and forth while looking
> at the check register?Question 2: I understand that if you enter "r" in
> the "R" field it is hard to change back... true?
> Thanks for any help.
>
>
> ___
> 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.
>


-- 
      Derek Atkins                617-623-3745
      de...@ihtfp.com            www.ihtfp.com
      Computer and Internet Security Consultant

  
___
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] Reconciliation "R" column question

[Derek Atkins]

Hi,

The three* values (at least in English) are n, c, and y.

Yes, you may freely swap between n and c in the register.  It just causes
a recomputation of account balances.

I do not believe you can get to 'y' without going through formal
reconciliation.  I.e., I don't think you can type 'y' in there and have it
be accepted, although I admit I've never tried to do that.  It would be
missing the "reconcile date" metadata for one thing.

Hope this helps.

-derek

* There is also a 'v' (void) status.

On Mon, May 18, 2020 9:41 am, Fran_3 via gnucash-user wrote:
> In Help 2.94 Reconciliation... "R" column choices are...
> n = not cleared the bankc = cleared the bankr = Reconciled
> I've got the GnuCash Check Register open in one window and I'm logged on
> to the bank in another window looking at recent transactions...I'm trying
> to make sure each bank transaction has been entered into GC.I'm not doing
> a formal monthly reconciliation... this is just an end of day check up.
>
> Question 1: May I freely change "n" and "c" back and forth while looking
> at the check register?Question 2: I understand that if you enter "r" in
> the "R" field it is hard to change back... true?
> Thanks for any help.
>
>
> ___
> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Reconciliation "R" column question

[Fran_3 via gnucash-user]

In Help 2.94 Reconciliation... "R" column choices are...
n = not cleared the bankc = cleared the bankr = Reconciled
I've got the GnuCash Check Register open in one window and I'm logged on to the 
bank in another window looking at recent transactions...I'm trying to make sure 
each bank transaction has been entered into GC.I'm not doing a formal monthly 
reconciliation... this is just an end of day check up.

Question 1: May I freely change "n" and "c" back and forth while looking at the 
check register?Question 2: I understand that if you enter "r" in the "R" field 
it is hard to change back... true?
Thanks for any help.


___
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] wells fargo downloads

[Hershey]

Thank you David.

Yes, OFX Direct, Windows 10 laptop, V 3.10


*Regards,Doug*
¯\_(ツ)_/¯


On Mon, May 18, 2020 at 8:00 AM David Carlson 
wrote:

> You did not tell us which version of Gnucash you installed or which
> operating system your computer is using.  Since the solution, if there is
> one, varies depending on that information,  we need the info.
>
> I suspect that you may be trying to use OFX Direct Connect, which requires
> outside software and may or may not work with your financial institution.
>
> An alternative that many US users use is to open the bank's website and
> download your data in QIF or OFX format, then import it offline.
>
> David Carlson
>
> On Mon, May 18, 2020, 4:26 AM Hershey  wrote:
>
>> I'm new to Gnu and am having issues setting up online downloads.
>> My first attempt is Wells Fargo and I get a 2000 error message.
>> The Tutorial show Wells Fargo in its example but I've also seen this
>> statement on the web: Wells Fargo has switched to OFX Web Connect. GnuCash
>> doesn't support this authentication.
>>
>> So, I'm stuck and confused.
>>
>> Grateful for your help.
>>
>>
>>
>> *Regards,Doug*
>> ¯\_(ツ)_/¯
>> ___
>> 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] wells fargo downloads

[David Carlson]

You did not tell us which version of Gnucash you installed or which
operating system your computer is using.  Since the solution, if there is
one, varies depending on that information,  we need the info.

I suspect that you may be trying to use OFX Direct Connect, which requires
outside software and may or may not work with your financial institution.

An alternative that many US users use is to open the bank's website and
download your data in QIF or OFX format, then import it offline.

David Carlson

On Mon, May 18, 2020, 4:26 AM Hershey  wrote:

> I'm new to Gnu and am having issues setting up online downloads.
> My first attempt is Wells Fargo and I get a 2000 error message.
> The Tutorial show Wells Fargo in its example but I've also seen this
> statement on the web: Wells Fargo has switched to OFX Web Connect. GnuCash
> doesn't support this authentication.
>
> So, I'm stuck and confused.
>
> Grateful for your help.
>
>
>
> *Regards,Doug*
> ¯\_(ツ)_/¯
> ___
> 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] wells fargo downloads

[Hershey]

I'm new to Gnu and am having issues setting up online downloads.
My first attempt is Wells Fargo and I get a 2000 error message.
The Tutorial show Wells Fargo in its example but I've also seen this
statement on the web: Wells Fargo has switched to OFX Web Connect. GnuCash
doesn't support this authentication.

So, I'm stuck and confused.

Grateful for your help.



*Regards,Doug*
¯\_(ツ)_/¯
___
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.