Based in Mexico City, Mexico, Santander México provides statements to its customers as PDF documents in online banking. Convert Santander México statement PDFs to Excel, CSV or an accounting format — with a reconciliation check on every conversion.
Privacy: uploaded files and generated exports are stored only briefly to complete your download and are automatically deleted within 15 minutes. Files are never used for any other purpose.
For catch-up bookkeeping, where a year of statements needs sorting before import.
For moving figures between systems that do not share a native format.
For rebuilding history in software after a bank feed has lapsed.
Every conversion is checked against the statement itself: where the statement prints opening and closing (or running) balances, the extracted transactions must add up to them, or the conversion is flagged and the mismatched rows are marked. A statement whose layout the reader cannot parse is reported honestly — never passed off as converted.
Every Santander México conversion is audited by the document it came from. The extracted transactions are totalled against the printed opening and closing balances and checked row by row against the running balance column where one is printed. A conversion only reports as reconciled when both tests agree to the cent — and when they do, the figures have been proven against the bank's own document, not merely read from it.
Two habits make Santander México statements easier to work with. First, convert the issued PDF rather than a portal screen print — print views paginate differently and can drop the balance lines the check needs. The closing zone carries the balances and any fees or interest summaries; it is the closing zone the reconciliation check answers to, and the first place to look when a conversion is flagged.
In Mexico, bookkeepers commonly work in CONTPAQi and Aspel; the Excel and CSV exports from this converter are the files those tools import, and the CSV export is laid out for direct import where the tool accepts it.
Santander México, a bank based in Mexico City, appears 3rd among the 10 institutions in the Mexico directory; the statements it issues are denominated in $. Santander México is not the only directory institution based in Mexico City — Inbursa, BBVA México and Banamex, and 3 more also give it as their headquarters. A shared city merges nothing: statements from each convert separately, on their own figures. The name appears nowhere else in this directory — no other country's roster lists the group — so these pages answer to Mexico statements alone. In the directory's order Santander México sits between Banorte of Monterrey and Banamex of Mexico City, and its converter pages are built the same way as theirs — the difference is the statement in front of the checker, not the check. Among Mexico's 10 banks, Santander México sits 3rd, between Banorte of Monterrey and Banamex of Mexico City in the directory's order. Read alphabetically, the Mexico roster runs from Banamex to Scotiabank México, and Santander México falls between Inbursa of Mexico City and Scotiabank México of Mexico City. Among the 7 institutions headquartered in Mexico City, the directory's order places Santander México 2nd, between BBVA México and Banamex. The listings around it in the directory — BBVA México (bank, Mexico City), Banorte (bank, Monterrey), Santander México itself (bank), Banamex (bank, Mexico City) and HSBC México (bank, Mexico City) — span 2 headquarters cities and 1 institution kind between them; the converter treats each of them exactly as it treats Santander México, on its own statement's evidence. Banks make up 10 of the 10 institutions listed for Mexico, Santander México among them.
Download all twelve periods first and convert them as one batch, then work through the reconciliation results month by month in order. Fix flagged months before importing anything: it is far easier to resolve a difference against twelve tidy statements than inside a year of mixed postings.
Each format above serves a different next step. Excel suits review and analysis — figures you will sort, total and annotate. CSV suits import into anything and long-term archiving. QuickBooks and Xero exports match those tools' own import layouts, so the file uploads without remapping. OFX suits desktop software that expects a structured bank file. Converting costs nothing extra per format: many people take Excel for their own review and the accounting format for the books.
These are the general steps most banks follow for statement downloads; exact menu labels vary by bank and change over time.
Tip: where the portal shows a 'final' or 'corrected' version of a statement, convert that one — reissued statements supersede the original figures.
Save the statement as a PDF from Santander México online banking, add it to the converter above, and take the an Excel (.xlsx) workbook it produces. Extraction, column normalization and the reconciliation check all happen before the download is offered.
Like most banks in Mexico, Santander México prints dates as the order printed on the statement itself and amounts with the grouping printed on the statement itself. Conversion normalizes dates to an unambiguous form in the output while leaving the figures themselves untouched.
BBVA México, Banamex, HSBC México and Scotiabank México, and 2 more. Each is a separate institution with its own statement layout — a Santander México statement converts against Santander México's balances only, never against a same-city neighbour's.
Where the statement prints opening and closing (or running) balances, the converter adds up the extracted transactions and compares the result with the statement itself. If the numbers do not tie, the conversion is flagged and the mismatched rows are marked — a failed check is never shown as a success.
The statement PDF. It is the issued document and it carries the opening and closing balances the reconciliation check verifies against; a portal CSV has the transactions but nothing to prove them against.
Scan the statement as flat and straight as you can and upload the scan. OCR reads it, and the reconciliation check verifies the read against the printed balances; rows it cannot verify are flagged for a manual look.
That depends on the bank's portal — most keep at least a year of PDFs online, and older periods can usually be requested. However far back you go, download each period as its own PDF.
The QuickBooks and Xero exports are laid out in the column order those tools import. The plain CSV and Excel exports suit everything else, including spreadsheet review before import.
Convert them separately and import only one version of the overlap. Banks occasionally reissue a corrected statement for a period; the later issue supersedes the earlier, and importing both would double the shared days.
No. Uploaded files and generated exports are stored only briefly to complete the download and are automatically deleted within 15 minutes.
Your first statement is free — every format, no card — and every result is checked against the statement itself before you download it.