NatWest Business Credit Card Feed

That would be brilliant if they could. At the moment you can’t link personal or business credit cards to there online banking.

Please let us know if you have any luck with this.

Kindest regards
Chris

Potentially the feed needs to be via NatWest Clearspend as that does link through to a page where it’s possible to view third party data connections granted. There’s no means of connecting to this from QuickFile though at present.

More specifically, Clearspend does show when you try to connect to NatWest, but once you’ve connected a NatWest bank account then QuickFile prevents you from connecting to NatWest a second time, whereas NatWest requires the process to be done twice, once for the bank accounts themselves and a second time for Clearspend to connect card accounts. Unfortunately QuickFile blocks this second round of connectivity as once NatWest is connected then QuickFile removes NatWest from the list of banks which can be connected to, unless you revoke the feed, but even then you can only connect once, so QuickFile lets you connect to NatWest bank accounts, or NatWest clearspend (card accounts) but QuickFile won’t permit both to be enable simultaneously.

Hi @timbrooksbank

Just to confirm - are you able to use the same login for both your NatWest accounts, and the NatWest credit card?

No, it’s a different login on a different web address, however using the QuickFile activate bank feed function for NatWest takes you to a NatWest webpage where there a buttons to connect regular bank accounts, Bankline (NatWest’s corporate banking platform) or Clearspend, so what is needed is a way to get back to that NatWest connection page multiple times. At present QuickFile doesn’t support that.

Hi @timbrooksbank

Right now we don’t support multiple consents for the same banking entity. The problem here is Natwest have implemented different logins for different parts of their service (e.g. credit cards, current accounts etc), but unified everything under one area for Open Banking. Some of these additional options were also bolted on after we created our initial feed.

In most cases a bank will provide a single login so that one entity (e.g. a LTD company) can access and link all services under one consent. Natwest have gone for a different approach that would require us to make some underlying changes to our system.

I’ve asked for this to be reviewed on a technical level to see what can be done.

Hello, is there any update on this? I’ve confirmed with NatWest that it is the Clearspend portal the feed would connect to.

I’ve also tried manually uploading a bank statement from Clearspend to Quickfile, Quickfile rejects the file format from Clearspend, although it does accept files from NatWest Cards Online.

Hi @timbrooksbank

There aren’t any updates here I’m afraid.

If you select “Other” as your bank, you should be able to manually map the columns and upload the file this way.

Is there any update to this? Selecting “other” and mapping the CSV does not work as Quickfile is unable to read the CSV file properly, it thinks everything is in the same column and ignores the commas which separate items.

I should add the other option of using NatWest Cards Online is closing shortly, so all of us who are NatWest users have no way of proceeding with Quickfile and will be forced to cancel our Quickfile subscriptions and move to FreeAgent which is able to correctly connect to NatWest bank and card feeds. FreeAgent is not as capable as Quickfile so it would be a shame to be forced to jump ship from Quickfile.

My natwest credit card and bank account are linked to quickfile. All my accounts have the same log in, if that helps

Is the card a personal card or a NatWest Commercial / Business card? Personal cards appear in NatWest Online Banking so link easily, but Commercial / Business cards do not, they route through a different NatWest system.

Hi, it’s a personal card, which i use for business.

Makes sense then, as why yours doesn’t show.

Thanks

I’ve just come across this thread. I had a Natwest Business Credit Card feed working in QF and noticed now that it’s stopped working. I don’t use the card that much, but it would be nice for this to still work. I don’t remember getting a notification to say it stopped working either :frowning:

Hi @tobyw7,

Sorry to hear that your feed for the credit card has stopped working. When you renewed the access for your feed did you select for all of the accounts? this may be what has caused the credit card to stop

I never had a renewal come through. I have a separate account with Natwest for the main account and this works fine still.

QuickFile only allows one open banking authorisation per bank (not sure whether this is just a QuickFile limitation or an inherent part of the Open Banking protocol), so you can only connect two accounts at the same bank if they can both be authorised under the same OB link (typically, if you can access both through the same online banking login rather than having to log in separately to a different URL for each account).

It’s a QuickFile limitation. Sage, Xero and FreeAgent do not impose this restriction. In most respects QuickFile is far superior from an accounting viewpoint to FreeAgent which is the closest in terms of cost, but its outdated bank feed regime is a real problem which disappointingly nobody at QuickFile seems to be taking seriously.

Tim Brooksbank

Hi @timbrooksbank

Thank you for your feedback.

Please rest assured that we do take this seriously. As my colleague mentioned above, this is something that will be reviewed in due course.

Hi @tobyw7,

Your feed will renew every 90 days, so you may find when you last allowed access you only allowed for your current account.

It might be worth trying to revoke the banks access and starting again making sure to allow for both the credit card and the current account