Santander statement to CSV
Drop the Santander PDF as you downloaded it. It is converted right here on your computer, every row checked against the running balance printed beside it, then its totals compared with the ones Santander printed. Export for Xero, QuickBooks, MYOB or any spreadsheet.
What a Santander statement looks like and what the parser handles
- Dates carry an ordinal and no year, written 8th Feb.
- The parser reads the ordinal and takes the year from the period printed on the first page, so 8th Feb becomes 2024-02-08.
- The transaction table is on the last page, after two pages of notices and rates.
- The parser finds the table by its columns wherever it sits, and the rate tables on the way there carry no dates, so they are not read as transactions.
- Only the last transaction of a day carries a balance.
- The parser carries the earlier amounts forward and checks them together against the next balance printed.
- The table opens with a Previous statement balance row and closes with a Current statement balance row.
- The opening and closing balances come from them, and neither is exported as a transaction.
- The first page prints Total credits and Total debits, the debits with a minus.
- The parser compares its own totals with them, reading the minus as direction rather than as part of the figure.
One real Santander business current account statement has been through this parser: three cheques on one day, the running balance reconciled, and the printed total credits and total debits matched to the cent.
Only the Santander business current account statement has been tested. Scanned or photographed statements are not supported, because the text has to be in the PDF already.
Once it is converted, the import steps for Xero, QuickBooks and MYOB are the same whatever bank it came from.
Questions
Is my statement uploaded anywhere?
No. Your own computer does the whole conversion, so the file never goes anywhere. Close this tab and it is gone from here too. If you would rather see that than take our word for it, your browser can show you everything a page sends: open its developer tools before you drop a statement, and nothing carrying your statement will appear. Even the typeface comes from this site rather than from somewhere else, so nothing about you reaches anyone.
Does it handle Santander credit card statements?
Not yet. The Santander business current account statement is the only one tested, so this page does not claim credit card or business statements.
Does it handle scanned statements?
No. A scan or a photo of a statement is an image, and there is no text in it to read. Download the PDF from online banking instead.
What does it cost?
Excel and plain CSV are free, for as many statements as you like, with no account to create and nothing that runs out. Xero CSV, QBO, OFX, QIF and MT940 are $9 a month, as is downloading a whole sitting at once. See what each plan includes.