Guides
Bank statement guides for accountants.
How to convert, reconcile and import bank statement PDFs, bank by bank and ledger by ledger. Written by a practising CPA, with no client data leaving anyone's machine.
How to Import Bank Statements into Zoho Books and Match Transactions
Import a bank statement in Zoho Books: the files it accepts, field mapping and preview, duplicates, matching each transaction, and a PDF converted locally.
Read the guideAll guides
Bank statement conversion guides for accountants.
Year-End Bookkeeping Checklist for Canadian Small Business Owners
A year-end accounting checklist for Canadian small business owners doing their own bookkeeping: accounts, payroll, GST/HST, tax deductions and CRA deadlines.
How to Import Transactions into YNAB from a Bank Statement PDF or CSV
Import bank statement transactions in YNAB: the files it reads, how it treats dates and amounts, what to do when Direct Import falls short, and reconciling.
New Bookkeeping Client Onboarding Checklist for Canadian Firms
A bookkeeping client onboarding checklist and template for Canadian firms: scope, CRA access, statements converted locally, PIPEDA and the first reconciliation.
How to Import Bank Statement Transactions into FreshBooks and Reconcile
Import bank statements into FreshBooks: the CSV layout Bank Reconciliation accepts, what to do if the bank connection falls short, and a PDF converted locally.
How to Get Bank Statements From a Closed Account in Canada
Get bank statements from a closed account in Canada: who to ask, what the bank keeps and for how long, published fees, estates, and the PDFs converted locally.
How to Import Bank Statements into Wave Accounting from PDF or CSV
Import bank statements into Wave: the formats its upload accepts, the CSV layout it needs, a PDF converted on your computer, and each transaction reconciled.
Convert Santander Bank Statement PDFs to CSV or Excel
Convert a Santander Bank statement PDF to CSV, Excel, or QBO locally. 25 months sits in online banking, and the bank keeps seven rolling years on request.
Convert PostFinance Bank Statement PDFs to Excel or CSV
Convert a PostFinance bank statement PDF to CSV, Excel, or QBO on your own machine. Documents stay downloadable for 24 months, so retrieval comes first.
Convert Credit Suisse Statement PDFs to CSV or Excel
Convert legacy Credit Suisse bank statement PDFs to CSV or Excel on your own machine, and retrieve them first: the old archives closed on a short clock.
Convert UBS Bank Statement PDFs to CSV, Excel, or QBO
Convert a UBS bank statement PDF to CSV, Excel, or QBO on your own machine. E-banking keeps documents ten years, and migrated Credit Suisse files convert too.
Export Revolut Statements to CSV, Excel, or a QBO File
Export Revolut statements per currency as PDF, Excel, or CSV, then convert the PDF locally so multi-currency transactions reconcile one currency at a time.
Convert Metro Bank Statement PDFs to CSV or Excel
Convert a Metro Bank statement PDF to CSV, Excel, or QBO on your own machine. The archive reaches back to account opening, so the whole history converts.
Export Mercury Bank Statements to CSV, Excel, or a QBO File
Export Mercury bank statements as PDFs or CSVs from the dashboard, then convert the PDF locally when the books, an audit, or diligence need provable rows.
Convert First Citizens Bank Statement PDFs to CSV or Excel
Convert a First Citizens bank statement PDF to CSV, Excel, or QBO locally, whether the file is the current layout or a legacy SVB statement from before 2023.
Convert Citizens Bank Statement PDFs to Excel, CSV, or QBO
Convert a Citizens Bank statement PDF to CSV, Excel, or QBO on your own machine. 18 months sits in the Document Center; seven years is there on request.
Convert Charles Schwab Bank Statement PDFs to Excel, CSV, or QBO
Convert a Charles Schwab bank statement PDF to CSV, Excel, or QBO locally. First check which document you hold: the bank statement or the brokerage one.
Convert Discover Statements to CSV, Excel, or a QBO File
Convert a Discover statement PDF to CSV or Excel on your own machine, with payments, returns, and cashback redemptions kept as three different credits.
Convert Ally Bank Statement PDFs to Excel, CSV, or a QBO File
Convert an Ally bank statement PDF to CSV, Excel, or QBO on your own machine, with CD maturities and renewals kept as term events, not phantom payments.
Export Starling Bank Statements to CSV, PDF, or a QBO File
Export Starling Bank statements as CSV or PDF from the app, choose certified when it matters, and convert the PDF locally when the books need proof.
Export Monzo Bank Statements to CSV, PDF, or a QBO File
Export Monzo statements as CSV, PDF, or QIF straight from the app, and know when your accountant needs the PDF converted instead of the raw CSV.
Convert TSB Bank Statements to Excel, CSV, or a QBO File
Convert a TSB bank statement PDF to CSV, Excel, or QBO on your own machine. Statements live in the Digital Inbox, with about five years of history.
Convert Nationwide Statements to CSV, Excel, or a QBO File
Convert a Nationwide statement PDF to CSV, Excel, or QBO on your own machine. Only 36 months of PDFs are online, so download before you convert.
Convert Bank of Scotland Statement PDFs to CSV or Excel
Convert a Bank of Scotland statement PDF to CSV, Excel, or QBO on your own machine. First, make sure it is not actually an RBS statement.
Convert Halifax Bank Statements to Excel, CSV, or a QBO File
Convert a Halifax bank statement PDF to CSV, Excel, or QBO on your own machine, with the Reward fee and credit kept as the two rows they are.
Convert an RBS Bank Statement PDF to CSV, Excel, or QBO
Convert an RBS bank statement PDF to CSV, Excel, or QBO on your own machine. Seven years in Digital Banking, and mixed NatWest folders handled.
Convert Santander UK Bank Statement PDFs to Excel or CSV
Convert a Santander UK bank statement PDF to CSV or Excel on your own machine, with the 123 fee and cashback rows kept apart instead of netted.
Download and Convert NatWest Bank Statements to CSV, Excel, or QBO
Download NatWest statements as PDFs, then convert to CSV, Excel, or QBO on your own machine. Seven years self-serve, older ones by order.
Convert Lloyds Bank Statement PDFs to Excel, CSV, or QBO
Convert a Lloyds bank statement PDF to CSV, Excel, or QBO on your own machine. One client, three group brands, and the app archive that goes deeper.
Convert HSBC Bank Statement PDFs to Excel, CSV, or a QBO File
Convert an HSBC UK bank statement PDF to CSV or Excel on your own machine. Six years online, and two downloads that are not the same document.
Convert Barclays Bank Statements to Excel, CSV, or a QBO File
Convert a Barclays bank statement PDF to CSV, Excel, or QBO on your own machine. Seven years online while the account is open, five once it closes.
Convert Fifth Third Bank Statements to Excel, CSV, or QBO
Convert a Fifth Third bank statement PDF to CSV, Excel, or QBO locally. The archive runs about two years, so download first and convert second.
Convert American Express (Amex) Statements to Excel, CSV, or QBO
Convert an American Express statement PDF to CSV or Excel on your own machine. Two years online, older statements on request, and no running balance.
Convert Truist Bank Statements to Excel, CSV, or a QBO File
Convert a Truist bank statement PDF to CSV, Excel, or QBO on your own machine. What to do with the BB&T and SunTrust statements still in the file.
Convert TD Bank Statements to Excel, CSV, or a QBO File (US)
Convert a TD Bank statement PDF to CSV, Excel, or QBO on your own machine. Seven years online, and the date convention that ruins cross-border files.
Convert Capital One Bank Statements to Excel, CSV, or QBO
Convert a Capital One bank statement PDF to CSV, Excel, or QBO locally. Seven years of statements, a two-year activity list, and which one to trust.
Convert PNC Bank Statement PDFs to Excel, CSV, or a QBO File
Convert a PNC bank statement PDF to CSV, Excel, or QBO on your own machine. Why Virtual Wallet is three accounts, and how far back the archive goes.
How to Categorize Bank Transactions for Tax Purposes
A workflow for categorizing bank transactions at tax time, starting from the statement rather than the bank feed, and what an accountant actually needs in the file.
Bank Statements for a Business Loan Application: What Lenders Want
What lenders want from business bank statements, how bank statement loans work, and how to prepare a clean statement package before you apply.
Bank Statement OCR: How It Reads a Scanned PDF, and When to Trust It
How bank statement OCR works on a scanned PDF, why scan quality decides the result, and the one check that tells you whether the extraction can be trusted.
Convert US Bank Statements to CSV or Excel
Convert US Bank statements to CSV or Excel on your own machine. Why copy-paste loses the columns, what the statement layout does to a converter, and how to check the result.
Convert Citibank Statement PDF to CSV or Excel
Convert Citibank statements to CSV or Excel on your own machine. What the PDF layout does to a converter, and how to check the output before you import it.
How to Import Bank Statements into QuickBooks Online
Import bank statements into QuickBooks Online from a CSV. The exact column formats QuickBooks accepts, what to do when the bank feed will not reach back far enough, and how to reconcile after.
Which US Banks Let You Export Bank Transactions to a CSV File?
Which US banks offer a real CSV download, how far back each statement archive actually goes, and why a transaction export cannot replace a statement.
How Long Should I Keep Bank Statements? The IRS Rules Explained
The IRS periods of limitations for bank statements, why 7 years is the wrong default, and how far back each major US bank will actually let you go.
How to Convert a Wells Fargo Bank Statement to Excel or CSV
Convert a Wells Fargo statement PDF to CSV, Excel, or QBO on your own machine. Why the archive depth changes by product, and what that costs you.
How to Convert Bank of America Statements to Excel or CSV Files
Convert a Bank of America statement PDF to CSV, Excel, or QBO on your own machine. The 18-month self-serve wall, and how to reach the full 7 years.
Convert a Chase Bank Statement to Excel, CSV, or a QBO File
Convert a Chase bank statement PDF to CSV, Excel, or QBO on your own machine. Where the 7-year archive sits, and why there is no bulk download.
Safeguarding Taxpayer Data: An IRS Security Guide for Tax Professionals
Tax professionals must safeguard taxpayer data under the FTC Safeguards Rule. What a WISP requires, and where client bank statements sit inside it.
Which Canadian Banks Let You Download Statements as CSV Files?
Which Canadian banks offer a direct CSV download, how far back each archive goes, and why a transaction export is not the same thing as a statement.
Convert a Canadian Western Bank Statement PDF to CSV or Excel
Convert a CWB statement PDF to CSV, Excel, or QBO on your own machine. What the National Bank merger changed, and the CDIC window that closes in March 2027.
How to Export and Convert Servus Credit Union Statements to CSV
Convert a Servus Credit Union statement PDF to CSV or Excel on your own machine. The 7-year archive, the separate Mastercard portal, and the balance check.
How to Convert an EQ Bank Statement PDF to CSV or Excel Format
Convert an EQ Bank statement PDF to CSV, Excel, or QBO on your own machine. Where statements sit, the 7-year archive, and why paper copies never exist.
How to Convert Vancity Statement PDFs to Excel or CSV Format
Convert a Vancity statement PDF to CSV, Excel, or QBO on your own machine. Where eStatements sit, the January 2017 cutoff, and how to download several at once.
How to Download a Simplii Bank Statement and Convert It to CSV
Convert a Simplii Financial statement PDF to CSV, Excel, or QBO on your own machine. Where eStatements sit, why the menu goes missing, and the balance check.
How to View and Convert Meridian Credit Union Bank Statements
Convert a Meridian Credit Union statement PDF to CSV, Excel, or QBO on your own machine. Where eStatements sit, the 7-year archive, and the check that matters.
How to Download Tangerine Statements and Convert Them to CSV or Excel
Convert a Tangerine statement PDF to CSV, Excel, or QBO on your own machine. Where statements sit, the 7-year archive, and why the CSV export is desktop only.
How to Do Catch-Up Bookkeeping When All You Have Is PDF Statements
How to work through years of catch-up bookkeeping when all you have is PDF bank statements: scoping the cleanup, converting the stack, and reconciling forward.
Three-Way Trust Account Reconciliation for Canadian Law Firms
How three-way trust account reconciliation works in a Canadian law firm, the 25-day deadline, and why the bank statement is a record in its own right.
How to Convert a Desjardins Statement PDF to CSV or Excel Format
Convert a Desjardins statement PDF to CSV, Excel, or QBO on your own machine. Where statements sit in AccèsD, the 7-year archive, and the check that matters.
Quebec Law 25 Compliance for Accountants Handling Bank Statements
What Quebec Law 25 requires before a client bank statement leaves the province: the Section 17 assessment, the penalties, and how to avoid both.
How to Reconcile Your Bank Account in Sage 50 from a PDF Statement
How to reconcile a bank account in Sage 50, which file formats each import route accepts, and how to turn a PDF statement into one Sage 50 can read.
How to Convert an HSBC Bank Statement PDF to CSV or Excel Format
Convert an HSBC Bank Canada statement PDF to CSV, Excel, or QBO on your own machine. Where the legacy statements sit inside RBC now, and how to pull them.
How to Convert Scotiabank Statements to Excel or CSV Format
Convert a Scotiabank statement PDF to CSV, Excel, or QBO on your own computer. Where to find statements, the 7-year archive, and the check that matters.
CRA Audit Bank Statements: What the CRA Asks For and How to Keep It
What the CRA asks for in an audit, how long to keep bank records under the Income Tax Act, and how to keep converted statement data defensible.
What Is a QBO File? How to Open and Import One Into QuickBooks
A QBO file is a QuickBooks Web Connect file built on the OFX standard. What it contains, how it differs from CSV and QFX, and how to import one properly.
How to Import Bank Statements into Xero: CSV, OFX, and Feeds
Xero imports OFX, QIF, QBO, QFX and CSV, but not PDF. Which format to use, how to convert a PDF statement first, and how to fix the common import errors.
How to Convert National Bank of Canada Statements to CSV or Excel
Convert a National Bank of Canada statement PDF to CSV, Excel, or QBO on your own computer. Covers the 2-year search window and French-language statements.
How to Protect Client Data Across Your Accounting Firm's Software
Client data sits in more places than most firms realise. Where it lives, what PIPEDA and Law 25 require, and the controls that actually reduce breach risk.
Common Bank Reconciliation Errors and How to Catch Them Early
The common bank reconciliation errors, how to tell a real error from a timing difference, and the systematic order to hunt a discrepancy down in minutes.
How to Automate the Month-End Close Process in a Bookkeeping Workflow
Automating month-end close starts with the data-entry bottleneck, not the checklist. What to automate in a bookkeeping workflow, what to leave alone, and why.
How to Convert CIBC Bank Statements to Excel or CSV: Step by Step
Convert a CIBC bank statement PDF to CSV, Excel, or QBO on your own computer. Step-by-step guide covering eStatements, format quirks, and the review step.
Bank Feed Missing Transactions? Feeds vs. Statement Import Explained
Bank feed missing transactions? Learn why feeds drop rows, stall at 90 days, or duplicate entries, and when to import the statement instead for clean books.
How Far Back Can You Get Bank Statements in Canada?
See how far back RBC, TD, BMO, Scotiabank, CIBC, and National Bank keep bank statements online, plus the CRA's six-year rule and how to convert old PDFs.
Do Bank Statements Count as Digital Records for Making Tax Digital?
Do bank statements count as digital records for Making Tax Digital? Not alone. See what HMRC requires and how to turn statement data into MTD-ready records.
How Accurate Are Bank Statement Converters? What "Reconciled" Should Mean
Bank statement converter accuracy has three levels, and vendors rarely say which one their "99%" claim measures. The test that actually matters, explained.
Can ChatGPT Convert a Bank Statement PDF to Excel? What It Misses
ChatGPT can pull transactions from a bank statement PDF into Excel, but it never verifies totals and can invent digits. Here is the honest, full answer.
Why You Should Never Upload Client Bank Statements to Cloud Tools
The privacy case for a no upload bank statement converter: what the US Cloud Act means, why server location fails, and how local processing removes the risk.
How to Clean Up Cryptic Bank Statement Descriptions Into Payee Names
Clean up bank statement descriptions like AMZN MKTP and SQ* into clear payee names. See what the codes mean and how BankWriter renames them in bulk, offline.
How to Convert a Bank Statement With Multiple Accounts Into Clean CSVs
Convert a bank statement with multiple accounts into one clean CSV per account. Each account is reconciled on its own and split for import, all offline.
How to Convert a Scanned Bank Statement PDF to Excel or CSV
How to convert a scanned bank statement PDF to Excel or CSV, why OCR struggles on poor scans, and the balance check that tells you the output is right.
How to Convert a Credit Card Statement PDF to CSV, Excel, or QBO
Convert a credit card statement PDF to CSV, Excel, or QBO on your own machine. BankWriter checks each statement against its printed totals before you export.
Bank Reconciliation Statement: What Most Tools Miss
What the bank reconciliation process actually requires, the five conversion errors that break it, and the three-way check that catches them.
How to Convert BMO Bank Statements to CSV, Excel, or QBO
Convert a Bank of Montreal statement PDF to CSV, Excel, or QBO on your own machine. BMO statement layouts, eStatements, and the checks worth running.
PIPEDA and the Cloud Act: Personal Information in Bank Statements
How PIPEDA and the US Cloud Act apply to client bank statement data, what a compliant workflow looks like, and where Canadian data residency stops helping.
How to Import Bank Statements into QuickBooks Online and Desktop
Import bank transactions into QuickBooks Online or Desktop from a statement. QBO versus CSV, the common import errors, and how to reconcile after.
GDPR and Bank Statement Uploads: Data Protection for Accountants
How GDPR treats the personal data in a client bank statement, what a compliant workflow looks like, and where cloud conversion creates exposure.
Bank Statement Converter for Accountants: What to Look For
What an accountant should look for in a tool to convert PDF bank statements to CSV or Excel, and the red flags worth walking away from.
How to Convert TD Bank Statements to CSV or Excel
Convert a TD Canada Trust statement PDF to CSV, Excel, or QBO on your own machine. How TD statements are structured, and where conversion tools break.
How to Convert RBC Bank Statements to CSV or Excel
Convert an RBC Royal Bank statement PDF to CSV, Excel, or QBO on your own machine. How RBC statements are laid out, and where converters get them wrong.
How to Convert PDF Bank Statements to CSV or Excel (Any Bank, No Upload)
Convert PDF bank statements to CSV or Excel on your own machine, from any bank. What clean output looks like, and why most converters fall short.
No guide matches that.
Try a bank name, a format such as QBO or OFX, or a word from the thing you are trying to do.
By bank
Looking for your bank?
Every bank we cover has its own page: where the statement lives in online banking, what its layout does to a conversion, and how to get it into your ledger.
Stop reading, start converting.
Every guide on this page describes something the app already does. The trial is the fastest way to see it on a statement you have open.
200 transactions freeNo credit card