Feature Requests Incident #20112

 


Summary
Project
None
Incident Category
Features
Incident Number
20112
Visibility
public


Product Version
None
Fixed In Version
None


Summary
Online banking interface


Description

Online connection to banks (for online bank rec) Ability to download transactions daily or whatever period for reconciliation (see what Xero does). There is a free service which has a connections to thousands of banks which they are leveraging. I can't remember the name of the service, but I can find out if necessary.


Details
Reporter
fblauer
CRM Account
Trinite Solutions
Status
Confirmed
Assigned
None


Priority
None
Severity
None
Updated
05-22-14 07:42
Resolution
None



Comments

DateUsernameComment
05/22/14 07:42pocock

It may also be useful to take the Firefox "Export to CSV" plugin and adapt it to feed data to xTuple (possibly through one of the middleware options just mentioned)

The Export to CSV plugin simply lets a user click any HTML table in a bank or vendor web site and save the cell contents as CSV data.

A generalized version of the plugin could route the CSV data into xTuple somehow

05/22/14 07:39pocock

This has been discussed on the SF Conservancy npo-accounting mailing list thread here:
http://lists.sfconservancy.org/pipermail/npo-accounting/2014q2/000190.html

05/22/14 07:38pocock

Here are my thoughts/observations on the strategy for this issue:

a) it is not a problem that is unique to xTuple

b) it could be a pain to keep in sync with the API options offered by all the different banks around the world

c) therefore, it may be better to solve this through the creation of some middleware component that can be shared between free software accounting suites

Here are some options that could fulfil this strategy:

GnuCash is already using a middleware called Aqbanking. AqBanking appears to have a focus on the German market (where German banks provide a comprehensive API using common standards) although it appears generic enough that it could support US use too.

Another option that has been pointed out is LedgerHub - http://furius.ca/ledgerhub/

04/21/13 10:07dcsint

This was raised four times under the kickstart project by:

fblauer:
Online connection to banks (for online bank rec) Ability to download transactions daily or whatever period for reconciliation (see what Xero does). There is a free service which has a connections to thousands of banks which they are leveraging. I can't remember the name of the service, but I can find out if necessary.
dkmeans:
I'd also go for enhancements in what we currently call "Bank Rec" - there's a few date quirks still in there, but we really need a "Cash Manager" that gives more flexibility - links to outside bank accounts etc. as suggested - and possibly the ability to have "non-gl" powered transactions - look at the Mint.com application for part of that idea.
Recon iteself of course needs to be g/l driven - but to just be able to "look at the bank balance" before all the monthly stuff is posted.
dustin:
Bank Rec integration
lplummer:
Automated process to record all monthly charges & payments made - similar to quickbooks process that allows for bank and credit card statements to be imported and automatically classified under the correct GL expense account

04/21/13 10:06dcsint

Online connection to banks (for online bank rec) Ability to download transactions daily or whatever period for reconciliation (see what Xero does). There is a free service which has a connections to thousands of banks which they are leveraging. I can't remember the name of the service, but I can find out if necessary.



Files

No Files

Related Documents

No relationships

Subscribers

You do not have permission to view subscribers.


Incident History

DateUsernameFieldChange
04/23/13 09:51dcsintCharacteristic Kickstart Added: "True"
04/21/13 10:06dcsintNewIncident Added
04/21/13 10:33dcsintDescription Updated: "Online connection to..." -> "Online connection to..."
04/21/13 14:39dcsintStatusStatus Changed: New -> Confirmed
07/01/13 15:24jrogelstadCharacteristic Time Estimate Added: "80"