NatWest makes it easy to get your banking data into Xero through a direct bank feed — until the day it isn't easy anymore. Maybe the feed silently disconnects for two weeks. Maybe your accountant asks for last year's full transaction history and Xero only has six months. Maybe you're opening your books on a closed NatWest account that never had a feed at all. When that happens, the fix is straightforward: import your NatWest bank statement into Xero manually, using a CSV file converted from the PDF statement you download from NatWest online banking or the NatWest mobile app.
This guide walks through both sides of the picture — how NatWest's direct feed in Xero actually works, exactly where it falls short, and how to fill the gaps with a clean manual import that won't create duplicate transactions.
How the NatWest direct feed in Xero works
Xero connects to NatWest through a secure bank feed, so transactions flow into your Xero bank account automatically each business day. You set it up once: in Xero, go to your bank account, click Get bank feeds, and authenticate through NatWest's own login screen. NatWest is part of NatWest Group (formerly RBS Group), and the feed covers NatWest current accounts, business accounts, and most credit cards issued under the NatWest brand.
On a normal day, this is all you need. Transactions appear in the For review tab, you categorize and reconcile them, and your books stay current with almost no manual work. If your day-to-day bookkeeping is on rails, don't change a thing — the feed is doing its job.
The problems show up at the edges: the feed only imports from the day you connect it forward, not backward. It sometimes breaks when NatWest changes its authentication flow. And it can't help at all with accounts that no longer exist. That's where a manual import takes over.
When the feed is enough — and when it isn't
Keep the feed running for ongoing, day-to-day reconciliation. It's automatic, timely, and less error-prone than anything manual. But reach for a manual CSV import in these situations:
- Older tax years. A direct feed typically only reaches back to the date you connected it — sometimes Xero pulls a short initial history, sometimes none. If you need the full 2024–25 tax year and connected the feed in March, you're missing months. Convert the PDF statements for those months to CSV and import them to complete the picture.
- Feed disconnections. Feeds break more often than anyone admits. If NatWest's authentication changed and the feed sat disconnected for three weeks, don't hand-enter those transactions one by one. Download the PDF for the gap period, convert it, and import.
- Missing transactions. Occasionally a transaction posts on the NatWest side but never lands in Xero. A manual import of that statement period fills the hole without disturbing everything else.
- Year-end cleanup. Accountants often request complete, uninterrupted transaction histories before signing off. If any stretch of the year relies on a broken feed, a manual import is the fastest way to make the books continuous.
- Closed accounts. You can't connect a feed to an account NatWest has closed. The PDF statements for that account are the only way in.
The mental model is simple: the feed handles the present and future; manual imports handle the past and the gaps. Most businesses that get this right use both, deliberately.
Download your NatWest statement as PDF
Before you can import anything manually, you need the source document. NatWest lets you download statements as PDF from two places:
From NatWest online banking: Log in at natwest.com, open the account you need, and look for Statements or Statement history. Choose the statement period — monthly is standard, but you can usually request custom date ranges for the gap you need to fill. Download each period as a PDF and keep the filename clear, like natwest-business-current-2025-01.pdf. When you're filling a feed gap, download only the missing range so you don't import data the feed already delivered.
From the NatWest mobile app: Open the account, tap Statements, and select the period. The app typically lets you download or share the PDF directly to your device. This is handy for a quick gap-fill — say your accountant needs January while you're sitting in a taxi — but for bulk periods, the desktop site is faster.
One detail that matters: NatWest PDF statements come in a couple of layout styles depending on the account type. A decent converter doesn't care about the layout; it reads the transaction rows — date, description, money in, money out — regardless of how the header is formatted. That consistency is exactly why PDF-to-CSV conversion beats retyping.
Convert the PDF to a Xero-ready CSV
Xero accepts bank statements in CSV format for manual import, with columns for date, description, and amount. The catch is that NatWest gives you a PDF — a document designed to be read by humans, not imported by software. You need the bridge in between: convertstatement.online turns that PDF into a clean CSV in seconds.
The process is intentionally boring: upload your NatWest PDF, check that the transaction rows came through correctly (dates in the right order, amounts positive and negative in the right columns), and download the CSV. The converter handles the two-column money-in/money-out style that NatWest uses, collapsing it into a single amount column with the correct sign — because Xero expects one amount column, not two.
Before importing, open the CSV and do a sixty-second sanity check: does the opening balance plus all transactions equal the closing balance? Do the first and last dates match the statement period? This one check catches the vast majority of conversion mistakes, and it takes less time than making a coffee. If the numbers tie, your data is clean.
Import the CSV into Xero without duplicates
This is the step where people get burned — not because it's hard, but because mixing a feed with a manual import creates a duplicate risk. Xero does not automatically detect that a CSV transaction is the same as one the feed already brought in. Follow this sequence and you won't get doubles:
- Know exactly what's missing. In Xero, open the bank account's Bank Transactions tab and note the date range already covered by the feed. Your manual import should cover only the dates that are not already there. Overlap is the entire problem; precision is the entire solution.
- Go to Manual Import. In Xero, click the bank account, then Manage Account → Import a Statement. Browse to your converted CSV.
- Map the columns. Tell Xero which column is the date, which is the description, and which is the amount. Check the date format matches what Xero expects (DD/MM/YYYY for UK accounts). Preview the first few rows.
- Import and review. The transactions land in the For review tab, same as feed transactions. Reconcile them normally.
- Check for overlaps anyway. Sort by date around the boundary where the feed resumes. If you spot a duplicate — same date, same description, same amount — delete one of them. Thirty seconds of checking beats an hour of cleanup later.
A practical tip: when a feed breaks, fix the feed first (re-authenticate it in Xero), then import only the gap period. That way the feed resumes from today forward and your manual import is a single, clearly bounded block in the past. Neat books, no ambiguity about what came from where.
The NatWest specifics worth knowing
A few details that are particular to NatWest and save time in practice. First, NatWest's online banking lets you export statements in several formats, but the CSV export it offers is sometimes incomplete or formatted for Excel viewing rather than accounting import — the PDF is the authoritative record, and converting from it gives you the full transaction detail. Second, if you hold both NatWest and Royal Bank of Scotland accounts under NatWest Group, treat them as separate feeds and separate imports; Xero sees them as different banks. Third, NatWest savings accounts and fixed-term products often can't be connected to a Xero feed at all, so manual import is the only path for those from day one.
For more on working with this bank's statements generally, see our NatWest statement conversion guide. And if your accountant handles the books, our overview of bank statement reconciliation for accountants covers how firms like yours standardize this workflow across clients.
Frequently asked questions
Can Xero import a NatWest PDF statement directly?
No. Xero's manual statement import accepts CSV, OFX, QIF, and a few other formats — but not PDF. You need to convert the NatWest PDF to CSV first, then import the CSV. The conversion preserves every transaction row exactly as it appears on the statement.
Will importing a CSV create duplicates if my NatWest feed reconnects?
Only if the date ranges overlap. If your CSV covers January through March and the feed was broken for that whole period, nothing doubles up — Xero has no feed data for those dates. Just make sure the CSV doesn't extend into dates the feed already imported.
How far back can I import NatWest statements into Xero?
As far back as you have statements. Xero places no limit on how old an imported transaction can be; the limit is NatWest's side — online banking typically offers several years of statement history. Download the PDFs for the periods you need and convert them in batches.
Is it safe to convert bank statements on an online tool?
Convertstatement.online processes your file over an encrypted connection and doesn't keep your statement data sitting around. That said, never share your banking login credentials with anyone — the PDF route exists precisely so you never have to hand over account access to reconcile your books.
What if the amounts come out in separate debit and credit columns?
That's the raw NatWest layout. A good converter merges them into a single signed amount column that Xero expects. If your CSV still has two amount columns after conversion, combine them in Excel first — money out as negative, money in as positive — before importing.
Make it a routine, not a rescue mission
The cleanest setup most NatWest customers land on: keep the direct Xero feed running for the present, and treat PDF-to-CSV conversion as the reliable backup for everything the feed can't reach. The moment you know your books are missing a month, don't wait until year-end — download that statement, convert it, import it, and move on. Your future self, staring down a tax deadline, will be grateful.
If you're doing this regularly, it pays to keep the workflow tight. Read our primer on how to reconcile a bank statement properly so your manual imports land in books that actually balance. Ready to fill a gap in your Xero data? Convert your NatWest statement to CSV in under a minute, or see pricing for larger volumes.