NatWest bank feed for Xero: post the periods the feed did not deliver

Where the native NatWest feed falls short

NatWest has a direct Xero feed covering business current, savings, credit card and foreign currency accounts. It imports twice a day on a periodic open banking consent and shares up to twelve months of history when you first connect. Bankline is where it gets complicated: the connection fails with a no-valid-accounts error until somebody assigns a user role carrying third-party provider privileges.

The NatWest feed itself is unremarkable in a good way - business current, savings, credit card and foreign currency accounts, importing twice a day, twelve months of history offered at setup. What catches people is Bankline. Connecting a Bankline account to Xero fails with an error saying you have no valid accounts unless a user role carrying third-party provider privileges has been assigned inside Bankline, and that is an administrator action at the bank rather than anything Xero can fix. In a practice this is the worst kind of blocker: the bookkeeper hits the error, the client's Bankline administrator has to act, and the account stays unfed for however long that takes. The rest is the standard open banking shape. Consent lapses periodically and the feed stops on the expiry date rather than on the day it is noticed. Backfill is capped at twelve months, so anything older comes from statements regardless. A reconnection delivers from the day it is made and does not recover the stretch in between.

The manual way, every month

• Download the statement for the missing period
• Check the file format, dates and signed amounts
• Import into the correct Xero account and review overlaps
• Compare the closing balance and reconcile the lines

A usable CSV or OFX from the provider may be enough. Native PDF import is also available for eligible US and Canadian Xero organisations.

Review the statement, then choose how to import it

Preview the extraction, check the transactions, then send eligible lines through Xero's Bank Feeds API or download a Xero-ready CSV. Direct delivery supports dates within the last year and can be blocked by another provider's feed connection. Use CSV for older history. Overlap checks cover previous uploads to the same StatementClear feed, so also check any period already imported from other sources.

1. Step 1

   Start with your statement

   Preview a file before choosing how to get it into Xero.

2. Step 2

   Upload your NatWest statement

   PDF, CSV or Excel - whatever you can export. Map the columns once and we remember the mapping.

3. Step 3

   We check it first

   Review dates, amounts and signs. Balance checks use the source data, and overlap checks use prior StatementClear uploads.

4. Step 4

   Send to Xero or download CSV

   Send eligible lines directly to Xero or download a Xero-ready CSV. You complete reconciliation in Xero.

See the PDF-to-Xero workflow · Check PDF import in your region

Questions about NatWest and Xero

Where this comes from

Everything above about what Xero's native feed covers, what its manual import accepts and how feed lines reach a bank account comes from Xero's own documentation. The relevant pages are below, so you can check the claim rather than take it.

• Import a PDF bank statementNative PDF import in the US and Canada, with plan and document requirements. Checked 30 September 2026.
• About bank feedsXero's own account of which feeds exist, how they connect and what they do not cover.
• Import a CSV bank statementThe manual import: the formats it accepts, and how it handles lines it has seen before.
• Bank Feeds API overviewThe interface StatementClear posts through, and the reason a fed line is not an imported one.

Related accounts

• HSBC bank feed for Xero: post the days and months the feed misses
• Barclays bank feed not working in Xero? Post the missing period as feed lines
• Santander bank feed issues in Xero? Post the missing transactions as feed lines
• Credit card bank feed for Xero: for the cards Xero cannot feed