Convert a NatWest statement to Excel

NatWest online banking can export transactions and also stores PDF statements for years. Use the PDF when you need the balances.

Not every NatWest statement layout has been tested, so try one statement free and check the balance result before you convert a batch. RowBalance is an independent product of Forclev LLC and is not affiliated with, endorsed or sponsored by NatWest. NatWest is a trademark of its owner, named only to describe statement compatibility.

Try a sample statement first, nothing to upload and no pages used:

Sample data: the US checking sample from Summit National Bank. Try it with the US checking (PDF) button.

Balanced Opening $5,234.10 + transactions = closing $14,670.88, the closing balance on the statement.

Opening
$5,234.10
Money in
$12,978.51
Money out
$3,541.73
Closing (statement)
$14,670.88
Closing (computed)
$14,670.88
Difference
$0.00

Export or PDF

NatWest’s Statements and transactions area lets you view transactions for a date range and export them in spreadsheet formats (reported options include Excel/CSV and OFX), for a limited window per search. Formal PDF statements are kept for several years. The export does not include the statement header or opening and closing balances.

Reading a NatWest PDF

Columns are typically Date, Description, Paid in, Withdrawn and Balance. Descriptions carry transaction type codes and references. When the balance is shown per row, RowBalance checks every line as well as the statement total.

Sending it to accounting software

Convert to OFX for FreeAgent, Xero or Sage, to QBO for QuickBooks, or to Excel. Statement amounts come out as signed numbers with real dates.

How to do it

  1. Download your NatWest PDF statements.
  2. Drop them above and check the balance badges.
  3. Export Excel, CSV, or OFX, QBO and Xero CSV on a paid plan.

Excel and CSV are free for up to 5 pages a day, or 10 with a free account. QuickBooks, Xero and OFX files and batch conversion are on paid plans, from a $9 one-off pass: see pricing or go back to the converter.

Questions

Why is the NatWest export missing the balances?

It lists transactions only. The PDF statement is the document with opening and closing balances.

Is RowBalance affiliated with NatWest?

No. NatWest is a trademark of NatWest Group, used only to describe compatibility.

Related guides