Santander Bank Statement to Excel Converter

Converting Santander Statements to Excel

Santander UK statements tend to spell payments out in full. Instead of a two-letter code, a line might read CARD PAYMENT TO followed by the retailer, DIRECT DEBIT PAYMENT TO followed by the company, or FASTER PAYMENTS RECEIPT followed by a reference and the payer's name. That is easy to read, but these descriptions often wrap onto a second line, and copying a page into a spreadsheet splits them across rows and pushes amounts out of line. Finlyzers keeps each description with its own transaction and puts money in and money out in separate columns.

How a Santander Statement Is Usually Laid Out

• Header: account name, sort code, account number and the statement period.
• Summary: typically the opening balance, money in, money out and the closing balance for the period.
• Transaction table: columns usually labelled Date, Description, Money in, Money out and Balance.
• Page breaks: balances brought forward and carried forward between pages are not transactions, so they are left out of the transaction list.

Two Dates on Card Payments

Santander card payment descriptions often include the date the card was used, for example CARD PAYMENT TO EXAMPLE SUPERMARKET ON 18-09-2026, while the date column shows when the payment reached the account. In the spreadsheet the statement date goes in the Date column, and the card date stays in the description.

This matters at period ends. A purchase made on 5 April might not reach the account until 7 April, after the tax year has ended. If you are preparing Self Assessment figures or month-end accounts, decide which date you are working from and apply it consistently.

Filtering Santander Descriptions in Excel

Because each description starts with the payment type in words, Excel's text filters work well. Use Text Filters, then Begins With, and enter:

• CARD PAYMENT to list debit card spending;
• DIRECT DEBIT or STANDING ORDER to list regular bills and commitments;
• FASTER PAYMENTS RECEIPT or BANK GIRO CREDIT to list money received.

This is a quick way to build a household budget, check which subscriptions are still running, or total rent received if you let out a property.

If you want the payee on its own, Excel's Text to Columns or a simple formula can strip the leading phrase, leaving just the retailer or company name. Because the full description is kept, you can always go back to the original wording if a split does not work for a particular line.

Downloads, PDFs and Accounting Software

Santander online banking usually lets you download recent transactions, which is handy for your own open account. The statement PDF is what you need for older months, closed accounts, and statements that have been emailed to you by a client or family member.

For accounting software:

• Xero, FreeAgent or QuickBooks: import OFX into the matching bank account, which is useful for months before a bank feed was connected.
• Sage or other tools: use CSV and map the date, description, money in and money out columns.
• Making Tax Digital: if you are moving your records into compatible software, converted statements can give it a history for the months before you started.

Mortgage and Rental Applications

Lenders and letting agents commonly ask for recent statements. Converting them to Excel first lets you see your income, regular outgoings and balances the way an underwriter or agent will, and check that nothing unexpected stands out.

Other Banks and Statement Types

For other UK banks, see the HSBC and NatWest converter pages. Converting a Santander credit card statement? Use the credit card converter. For paper statements that have been scanned or photographed, try the scanned statement converter.