ExtractMint guides

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.

Protected PDFs How to Convert a Password-Protected Bank Statement PDF

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 Workbook

Review 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 CSV

Compare 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 Amounts

Choose 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 Statement

Calculate 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 Sheets

Choose 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 CSV

Choose 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 Excel

Choose between a bank export, Excel Power Query, and a reviewed PDF conversion.

Read the guide →
Silent walkthrough Watch a statement become reviewable Excel rows

See a click-to-play walkthrough using a synthetic statement, then try the sample yourself.

Watch the walkthrough →
Excel reconciliation template Bank Reconciliation Template for Excel

Download 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 balances

Use 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 details

Spot 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 dates

Resolve 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.