Automatic Bank Import

David Reiser dbreiser at earthlink.net
Mon Jun 12 23:45:56 EDT 2006


On Jun 12, 2006, at 9:28 PM, Chris Spencer wrote:

> Derek Atkins wrote:
>> Quoting Chris Spencer <gmane.20.evilspam at spamgourmet.com>:
>>
>>> Elizabeth Dodd wrote:
>>>> On Tuesday 13 June 2006 08:29, Chris Spencer wrote:
>>>>> That's unfortunate. Without some ability to automate the mundane
>>>>> information entry aspect, Gnucash is going to be far more  
>>>>> trouble than
>>>>> it's worth. However, thanks for answering my questions.
>>>> Do you mean transferring old account information or entering new?
>>> Mostly the later. Manually retrieving a file of all my credit/debit
>>> transactions on a daily/weekly/monthly basis shouldn't be necessary.
>>> Granted, syncing with the myriad banking websites is no trivial  
>>> task,
>>> even if they do allow you to export your data.
>>
>> Does your bank support OFX?  If so, you might want to use OFX Direct
>> Connect instead of manually downloading the file from their website.
>
> I'm currently with PNC, and it's not clear if they do, although it  
> looks
> like they support Quicken and Intuit says PNC supports "Direct  
> Connect".
> How do you find out if you bank supports QFX, and how do you take
> advantage of it if they do? I don't see any way to get a QFX file  
> to import.
>
> Chris

PNC supports Quicken, but only as a separate entity from their web  
banking interface. The only 'export' function in the web banking  
interface I've found is csv.

Furthermore, their Quicken support is handled through a third party  
that makes non-proprietary connections difficult. I have successfully  
used Aqbanking's ofxDirectConnect capability inside gnucash 1.9.x to  
connect to several credit card and investment accounts. But it gave  
me an error trying to connect to my PNC checking account. I got a  
free copy of Quicken with TurboTax this year, so I know I can connect  
through Quicken, but the provider seems not to use a standard SSL  
negotiation, as Aqbanking complains about an error in exchanging SSL  
certificate information.

For the moment, I'm not counting on getting PNC to connect with  
gnucash, nor provide an ofx/qfx download. For my business account,  
they also want $2/month for Quicken access (something like $15/month  
for Quickbooks). Time to cancel my free trial, and not move my  
personal accounts from a credit union too small to pay the Intuit  
extortion for an ofx server app. Darn.

--
David Reiser
dbreiser at earthlink.net



More information about the gnucash-user mailing list