Practical guides for reviewing statement conversions.
These guides cover protected PDFs, multiple statements in one workbook, CSV imports into Excel or Google Sheets, and export choices for Xero or QuickBooks, with checks for dates, amounts, balances, and missing rows. They describe ExtractMint’s current workflow and its limits.
Use the per-file password prompt, retry or cancel, then review the opened statement.
Read the guide → Multiple statements How to Combine Multiple Bank Statement PDFs into One Excel WorkbookReview the workbook sheets and check accounts, periods, balances, and overlaps across files.
Read the guide → Xero import choices How to Import Bank Statement Transactions into Xero from PDF or CSVCompare Xero’s direct PDF route with a reviewed CSV handoff and its mapping checks.
Read the guide → Excel CSV import How to Import a Bank Statement CSV into Excel Without Changing Dates or AmountsChoose the delimiter, column types, and locale, then check dates and amount signs.
Read the guide → Excel formulas Running Balance Formula in Excel for a Bank StatementCalculate balances from an opening amount using signed activity or separate withdrawal and deposit columns.
Read the guide → Spreadsheet import How to import a bank statement CSV into Google SheetsChoose import settings, check rows and dates, and review cloud storage and sharing before uploading.
Read the guide → CSV conversion How to convert a bank statement PDF to CSVChoose a bank export or PDF workflow, understand all 16 columns, and review the CSV before handoff.
Read the guide → Extraction methods How to extract a bank statement to ExcelChoose between a bank export, Excel Power Query, and a reviewed PDF conversion.
Read the guide → Silent walkthrough Watch a statement become reviewable Excel rowsSee a click-to-play walkthrough using a synthetic statement, then try the sample yourself.
Watch the walkthrough → Excel reconciliation template Bank Reconciliation Template for ExcelDownload one generic workbook, replace its synthetic inputs, and review statement and book adjustments, formulas, and limits.
Read the guide → Reconciliation How to check a converted bank statement against its balancesUse opening balance, deposits, withdrawals, and the closing balance as an arithmetic cross-check.
Read the guide → PDF review Why statement PDFs can lose or split transaction detailsSpot wrapped descriptions, page breaks, column shifts, repeated headers, and OCR mistakes.
Read the guide → Export formats CSV vs Excel vs QBO: which export should you use?Choose a file for review or handoff, and see what to check before importing it.
Read the guide → Amount signs Why are bank statement amounts negative?Check signed values, debit and deposit columns, Excel number formats, and possible PDF sign mismatches.
Read the guide → Date formats DD/MM or MM/DD? How to read statement datesResolve ambiguous dates such as 03/04/2026 before reviewing or exporting transactions.
Read the guide →What these guides can—and cannot—tell you
ExtractMint provides editable rows and balance checks, but an arithmetic match cannot prove that every transaction was captured. Compare the converted file with the source statement, especially when the layout is unfamiliar or scanned.
The worked figures on these pages are invented. No bank-specific format has been independently validated against real statements.