Not all banks support Bank feeds, we use Cashbook to process credit card statements, which definitely won't get Open Banking support any time soon.
Idea Benefit | Faster processing, eliminate data entry issues |
How do you solve for this problem today? | We manually enter Cashbook transactions like it's 2002 |
Sounds to be promising. I'm in.
Attachments Open full size
We’re currently working on a potential new feature that will allow the ability to download and import bank transactions for the purposes of bank reconciliation. The data, once imported, would appear within the bank feeds service, allowing you to use a set of custom rules. This would be for a number of reasons:
Bank feeds does not currently have a connection to your bank or your bank account type
Bank feeds isn’t syncing to suit your business requirements i.e. more frequent transaction updates required
We’re looking for customers who would be able to work with us in reviewing this and providing feedback & insight. We don’t anticipate that it will take more than 30 mins of your time and you would need to be available this month (April 2024).
If you are interested in helping please email ukisage200productmanagement@sage.com
Attachments Open full size
At present HSBC don't offer notifications when transactions become available throughout the day with our current Sage built connection syncing once a day.
I've just had our Plaid integration activated for you, that syncs every 6 hours so might work better for you. When connecting it shows as HSBC (UK) - Corporate: HSBC Net - this is the screenshot from inside Sage 200
Attachments Open full size
I'll test that now, thanks.
Working a day behind is too slow for us though. B2C business with same day despatch commitment. Needs to be in real time or at least several updates a day for that day.
Attachments Open full size
so some good news, HSBC Corporate Credit Cards are available as a feed however perhaps not so obvious. In the Sage 200 product when you set up bank feeds within the cashbook account, you need to search for HSBCnet as shown below.
There was an issue where you had a delay with transactions being brought in, this has been addressed and all previous day transactions are now ready by 9am, so you may wish to retry this as it sounds like it would solve your problem?
On the import file piece, yes you would be able to have rules.
Attachments Open full size
File upload sounds good, Do you know if it will feed into the Bank feeds module so we can make use of the bank feed rules feature?
We don't currently use Sage Bank feeds for our HSBC Net accounts because when we trialled it, the Open Banking sync was 24 hours behind. Too slow for us. At the moment we have no way to benefit from the very useful Bank feed Rules feature.
If we can just use file imports instead of having it synced it is actually better than having a link to the bank. (until the link is in real time)
Attachments Open full size
brilliant thank both, I'm trying to find out from our banking team if we have this on the roadmap. We're also looking at adopting a new service which will allow file imports of banking transactions for reconciliations so this would support where the bank feeds isn't connected to your provider or account type.
Attachments Open full size
@Jo, just to confirm MiVision relates to HSBC, which I see Stuart has already answered. Thanks Stuart!
@Stuart - I agree, it isn't the best but on the plus side, at least there are a few things that we can do for ourselves on there which then avoids a 1 or sometimes 2 hour wait on hold to try and get through to HSBC on the phone! Terrible!
Attachments Open full size
Unfortunately we use the MiVision Website for HSBC Cards. It's an absolute dog's dinner and is why I'm confident in my pessimism about the chance of integrating this. We just need the ability to use a csv template to upload into bank feeds...
Attachments Open full size
Hi John, I'm not familiar with MiVision, do you have any more information e.g. which bank and which bank account types and I can check our current connections list
Attachments Open full size
Hi Stuart, we previously used HSBC Commercial Cards but have switched everything to their MiVision platform. You might like to take a look.
Not sure whether Sage works with this, probably not. @ Jo - any plans to include this too please?
Thanks
Attachments Open full size
If we keep them separate then the demand can be tracked easily, the bank feeds is a central team at Sage so they track demand from all Sage products. I've updated the notes on this one now.
Attachments Open full size
Sounds great if it actually gets done (5 years for a csv import option?). I would prefer the already logged idea be implemented. It only needs Sage to make it happen. Just a note on the merged suggestion.. The other suggestions don't specifically mention it, but it needs PL, SL and CB postings to be part of the upload options. It also needs to allow for VAT codes on the NL transactions and also Inter bank account transfers...
Attachments Open full size
thanks Stuart, I think you have 2 ideas, one for the idea already logged and one for bank reconciliation for HSBC Credit Cards.
If you can vote on this one https://sage200uki.ideas.aha.io/ideas/S200UK-I-47
and I suggest that we convert this idea into wanting bank reconciliation for HSBC Commercial Credit cards
what do you think?
Attachments Open full size
I've just tested e-banking, it doesn't work unless the bank provides a plugin, which it doesn't (for credit cards). It doesn't support Bank feeds either. So given all we've spoken about, my suggestion is "can we import Nominal, Sales and Purchase Ledger transactions that also post to the Cashbook using a standard CSV into Sage so it can be reconciled manually?" If that's the same as the 5 year old suggestion linked below that has never been implemented, please merge this with that and continue to not implement it until someone else suggests it and you can tell them how this already exists again...
Attachments Open full size
I've just checked in on bank feeds and we have the partner card services and HSBC retail card live in the USA so let me ask about the UK and corporate cards
Attachments Open full size
Our compatible banks are listed here, unfortunately we don't cover to account level and we don't have banking credentials to allow us to test so you would need to evaluate it.
Attachments Open full size
That "different idea" was suggested in 5 years ago, has 25 votes, has been merged with 5 other ideas, is at "idea accepted - gauging support" and still isn't implemented... I won't hold my breath...
Attachments Open full size
HSBC Commercial Credit Card, we use Bank Reconciliation as a way to process and reconcile the monthly statements which have a mixture of Nominal, Purchase Ledger and POP transactions on them. Approx 200 TX per month, currently processed by one user. Does e-banking deal with this and allow for rules?
Attachments Open full size
You can use e-banking > e-reconciliation to do this more information is in this helpfile page.
Bank Feeds is the modern way to validate your transactions. Please let us know which bank you are using and we can pass this onto our banking product team to review.
If you wish to import the cashbook transactions, for processing rather than reconciliation purposes that would be a different idea - the is already an idea logged for this - https://sage200uki.ideas.aha.io/ideas/S200UK-I-47
Attachments Open full size