How to convert a bank (checking) statement to Excel or QuickBooks

A bank statement — the one for your checking account, not a credit card — is conceptually simple: a running list of deposits and withdrawals with a starting and ending balance. But like credit-card statements, banks give it to you as a PDF, and every accounting tool wants something else. This guide walks the full workflow: PDF in, spreadsheet or accounting-software file out, reconciled.

Bank statements vs. credit-card statements

The two look similar but differ in one important way: sign convention. On a bank statement, deposits are money coming in (positive) and withdrawals are money going out (negative). That matches both what a human sees and what accounting software expects for a checking account — no sign flip is needed.

Credit-card statements are the opposite: purchases (money you owe) are shown as positive on the statement but need to be exported as negative for QuickBooks/Xero (because a credit card is a liability, not an asset). Our separate guide on that explains why.

For a bank statement, the convention is simpler: deposit positive, withdrawal negative, both in your spreadsheet and in every accounting import.

The short version

1. Download your bank statement as a PDF from online banking.
2. Drop it into the converter — it auto-detects whether the PDF is a card or bank statement and applies the right sign convention.
3. Review the ✓ balanced check: starting balance + all transactions should equal ending balance.
4. Download as Excel, CSV, QuickBooks (.qbo), Quicken (.qif), or Xero.

Reconciling against the ending balance

Every bank statement has a starting balance (also called “previous balance”) and an ending balance. For the numbers to be correct, the following equation must hold:

starting_balance + (sum of all transactions) = ending_balance

The converter runs this check automatically. If it says ✓ Balanced, every transaction was captured. If it says ⚠ Off by $X, something is missing — usually a transaction on a page the extractor didn't see, or a fee/interest line-item mixed with the transactions.

This is a different check than the credit-card version (which compares against the stated purchases total), but the idea is the same: never trust an export that doesn't reconcile.

Step 1: Download the PDF

Sign in to online banking. Find Statements & Documents (Chase), Deposit Statements (Bank of America), or the equivalent, and download the month(s) you need as PDF. For business checking accounts, this is usually under a separate business banking section.

If the bank offers CSV: it's usually capped at 90 days. PDFs typically go back years, which is what makes them the go-to source for catch-up work.

Step 2: Convert

Drop the PDF into the converter. It reads the page visually, so scanned and digital PDFs both work — no need for the text layer that older PDF-to-CSV tools require.

The extractor auto-detects whether you've uploaded a checking statement or a credit-card statement and adjusts the sign convention and reconciliation accordingly. You don't need to tell it which type it is.

Step 3: Pick the right export format

Which format you want depends on where the file is going:

• Excel — for human reading, tax prep, categorising by hand. Real .xlsx with headers and currency formatting.
• CSV — for general spreadsheet use or as an intermediate step to another tool.
• QuickBooks (.qbo) — for direct import into QuickBooks Online or Desktop as a bank feed. Uses the OFX bank statement wrapper, not the credit-card wrapper.
• Quicken (.qif) — for Quicken or Moneydance. Uses !Type:Bank instead of !Type:CCard.
• Xero— CSV formatted for Xero's bank statement import wizard. Dates as YYYY-MM-DD.

Step 4: Import into your accounting software

Once you have the file, the import flow is the same as for credit cards. The QuickBooks import guide and Xero import guide cover the click paths — the only difference is that you select your checking account (not the credit card) as the destination in the import wizard.

Business vs. personal checking

The workflow is identical for both. For business checking:

• The transactions matter for Schedule C or your S-corp/LLC books.
• You'll almost certainly want to import into accounting software rather than working in a spreadsheet alone.
• Keep the original PDFs archived alongside the exports — the IRS wants the source document if you're ever audited.

For personal checking, you might just export to Excel and use it for budgeting or one-off analysis. That's fine too.

Common pitfalls

• Only downloading part of the statement. Some banks split long statements across multiple PDF files. Make sure you have the full period, or the reconciliation will be off.
• Confusing the check number with the amount. Modern converters (this one included) handle it, but older PDF-text tools sometimes grabbed the check number as the amount. Verify a couple of rows if anything looks off.
• Fees and interest on separate summary lines.Good extraction pulls these into the transaction list. If the ending balance doesn't reconcile, missing a $12 monthly service fee is one of the most common causes.

That's the whole thing

A year of monthly checking statements is 12 PDFs, converted in a few minutes each, imported in another few minutes. Instead of retyping hundreds of rows, you're done in under an hour with numbers that provably tie out.