natwest bank statement example

Start with context, then trace the payments

Establish the account, the sort code and account number as printed, and the statement interval before reading activity. Those three facts scope everything else: which account the money moved in, and which window of time the document is responsible for. A transaction outside the interval is not missing, it is simply on another statement.

Working in that order also tells you immediately whether you are holding the right document. A surprising number of reconciliation problems are someone comparing the wrong month.

Payment references are the real description

On a UK account, outgoing and incoming transfers carry a reference set by whoever initiated them. That reference is frequently the only indication of what a payment was for: a surname, an invoice number, a tenancy reference. The payee name alone will not tell you, especially where the same counterparty appears several times.

Capture references exactly as printed, including spacing and case. If you need a tidier label, add it in a second column; the original is what the counterparty and the bank will recognise.

Card payments and cash withdrawals both reduce the balance

A card purchase and a cash withdrawal both take money out, but they describe themselves differently and behave differently in time. The card purchase posts after authorisation; the withdrawal reduces the balance immediately. Categorising them together as spending is usually right for a budget and usually wrong for a reconciliation of a specific day.

Keep the posting date NatWest printed. It is the date the balance changed, which is the only thing a reconciliation can work with.

Use the balance after each row

Where the statement prints a balance after each transaction, it gives you a continuous check: recompute from the opening figure and compare at every row. A single missed entry announces itself at the exact point it was missed instead of as a mysterious total at the end.

That column is also how you find a wrapped description that was read as two transactions, because the phantom second row will throw the balance out by a duplicate amount.

Recurring commitments across months

Direct Debits and Standing Orders repeat, so building the list once lets you check each later statement against it quickly. A missing entry means a cancelled arrangement; an unexpected one means a new commitment worth confirming.

Because Direct Debit amounts can vary between collections, match on payee and date rather than on amount when you check the list.

Downloading the NatWest statement itself

Retrieve each account's document separately inside your own NatWest banking. Keep the file with its account label; a customer with a current account, a savings account and a card will accumulate three documents a month.

The PDF is the record; a converted sheet is for your own analysis.

References as the key to this natwest bank statement example

The reference row is the one that determines whether a transaction can still be explained months later.

Using the balance printed after each row, confirm:

• References were captured exactly, with any tidied label kept separate
• Your rebuilt balance column never parts company with the printed one
• Recurring commitments were checked against a list built from an earlier month

Reference habits at NatWest and other UK banks

Comparing another UK account shows how consistent the reference conventions are across the market. Scheme documentation for UK payments is maintained by Pay.UK, which operates the UK retail payment systems.

Feed the genuine document to the Excel converter or the CSV converter and keep the extraction guide open.

NatWest bank statement example: references and Direct Debits