NatWest export statement to Excel. Rows accounted for, balance re-added, the break given in pence.
The bank will give the account holder an export; this is for the case where the export is not available to you — a closed account, an old period, or a scan in a client's file. What comes out is a register whose running balance has been walked, with every row that did not add up named and measured.
Drop a NatWest statement here
Or click to pick the file. It opens in the same page you would have used anyway — the balance chain starts re-adding on the next screen.
Three files free, 60 pages in total, no card needed. Paid plans are priced by the page — one page of the original is one page, up to 500 pages in a single file.
The period is not always the month
A NatWest statement period can be set to something other than the calendar month, and a working paper that assumes a month will file the figures against the wrong dates without ever looking wrong. The period is read from the statement and printed on the export, so the ledger says which days it actually covers.
What gets checked before you download
Every line below is arithmetic on the paper you sent — not a supplier's claim about how good its reading is. Where the arithmetic fails, you get the row and the exact difference, and the statement is not called balanced.
The statement period is read, not assumed
The dates the statement covers are taken from the document and stated, so nothing is filed against an assumed month.
Balance chain walked line by line
Each printed balance is checked against the previous one plus or minus that row. Failures are measured exactly.
Two money columns, one sign
Money In and Money Out are folded into one movement with the rule visible.
Page breaks inside the register
Rows seen versus rows written is stated, so a page that lost its heading cannot quietly lose its transactions.
Where a NatWest statement goes wrong quietly
None of these announce themselves. Each one produces a file that looks correct.
Descriptions that carry a reference number
Long numeric references inside a description are not amounts. Only the money columns are read as money.
Overdrawn balances
A balance below zero prints differently on different layouts. It is read from the statement's own convention and flagged where the convention is unclear.
Scanned pages with a fold
A fold or shadow across the table is the classic cause of a misread digit. Cells in that region are flagged more readily.
What we will not claim
We do not claim to reproduce NatWest's own export. We claim the arithmetic on the page you gave us was walked and every failure was named.
The same goes for the arithmetic: a clean run means the checks we ran found nothing to flag. It does not mean the document is correct — it means nothing in it failed the checks listed above.
How it runs
Upload the statement
A native PDF, a scan, or a phone photo of the NatWest statement. No bank connection, no credentials, nothing to authorise.
The ledger is rebuilt and walked
Rows are put back in the order the statement prints them, page furniture is removed, and the balance chain is re-added line by line.
Check the flags, then export
Anything that did not add up is listed first, with its page and exact difference. Then take the Excel file, the other export shapes, and the review sheet.
What lands on your disk
- The .XLSX register — one row per transaction, no merged cells, amounts as numbers
- A Review sheet: who confirmed or corrected which cell, and what it said before
- Plain CSV, Xero-shaped CSV, and QuickBooks .QBO with unique transaction IDs
- A check report stating the rows printed, the rows exported, and every difference found
- Every cell still clickable back to the page and region it was read from
- Files are read, then destroyed — a second upload is a second read
Questions
Does this need the account holder's login?+
No. There is no connection to any bank and no credentials are involved. You upload the document you were given; that is the whole input.
What if the statement is for a closed account?+
That is one of the main reasons people end up here. A PDF or a scan is enough — no export from the bank is required.
How is this different from a converter?+
A converter produces a file. This produces a file plus the arithmetic that says whether the file agrees with the paper, plus the trail of who looked at what.
What does it cost?+
Three files are free, 60 pages in total, with no card and no account needed to try. Paid plans are sold by the page — $19 a month buys 1,000 pages — and a page is one page of the original document.