Before using a personal statement, load the fictional sample from the converter. A correct result shows 3 transactions across Date, Description, Debit, Credit and Balance, ending at 2,295.50. Compare those rows and the final balance, then download Excel or CSV.
1. Start with the clearest source
If your bank provides a transaction download in a suitable spreadsheet format, consider using that original export first. When your starting point is a PDF, open it and inspect the transaction section. Can you select the text, or does the whole page behave like a picture? Selectable text often allows direct extraction; a picture requires optical character recognition, usually called OCR.
The current converter accepts PDF, PNG and JPG files up to 10 MB, with a maximum of five PDF pages. It is designed for English tables with separate Date, Description, Debit, Credit and Balance headings. It does not promise support for every bank. Check this layout before spending time on a conversion, particularly if your statement uses one signed Amount column or descriptions spread over several lines.
Use the original digital PDF where available. For a scan, make sure the entire table is visible, the page is upright and the digits are sharp enough to read at normal zoom. Cropping away a column or photographing a page at an angle can remove information that no converter can reliably reconstruct. Only choose a file you are entitled to process.
2. Convert and inspect the preview
Open the bank statement converter, choose your file and select Excel or CSV. Press Convert statement. Digital PDF text is extracted in the browser; clear image pages are read using local OCR. Wait for the operation to finish before changing the file. Scans can take longer than digital text because the browser must recognize the characters first.
You can test the flow without providing a personal document. Select Try a sample to load a fictional scanned statement, then convert it. The sample contains three transactions with known amounts. The initial table shown before conversion is labelled as an example; it is not a result extracted from your own document.
After a successful conversion, the preview shows the extracted rows and the download button appears. On a narrow screen, scroll within the table to view the Credit and Balance columns. When you select another file, the previous result is cleared. If the new conversion fails, an old workbook is not offered as though it belonged to the new statement.
PDFs default to all pages. If a statement repeats transactions in a separate detail section, you may explicitly select transaction pages, such as 1 or 1-2. The preview warns when other pages are excluded, and the download filename includes the selected pages. Always check that your selection includes every transaction you need.
Some statements repeat transactions in a by-type detail section. The current converter can check explicitly labelled detail pages against a balance table when the account number, dates, amounts and descriptions match. Matching entries are not exported twice. An unmatched entry blocks the full export; compare the pages instead of assuming it is a duplicate. Other detail layouts and check image attachments may still require review.
3. Check the transaction sequence
Keep the original PDF open beside the preview. Start by comparing the number of transaction rows, then check the first and last entries on each page. Look for missing transactions near page breaks, duplicated rows and description text that has drifted into an amount column. A neat table can still contain a recognition mistake.
- Dates: compare the year, month and day with the source. Full dates use year-month-day text when unambiguous. Dates without a year keep the original text and require review. Do not assume that an unfamiliar date convention was interpreted correctly.
- Descriptions: confirm that each description belongs to its transaction. Similar merchant names and wrapped lines deserve a closer look.
- Debit and credit: verify which column represents money leaving and entering the account. A blank cell is different from an extracted zero.
- Amounts: check decimal points, thousands separators and repeated digits. Compare both large payments and small charges.
- Balances: follow the transaction order shown on the source, rather than sorting the table before checking it.
An opening balance of 1,000.00 plus a 2,500.00 credit gives 3,500.00. Subtracting a 1,200.00 debit leaves 2,300.00. Subtracting the next 4.50 debit leaves 2,295.50. These three rows let you check that credits, debits and balances have landed in the right columns.
The converter flags certain running-balance mismatches. Treat a warning as a reason to inspect the source, not as a suggestion to change values until the arithmetic works. It does not establish that every transaction is present, and an absence of warnings does not certify the export. Check each page separately, especially when a statement carries a balance forward.
4. Choose Excel or CSV for your next step
Choose Excel when you want a workbook for review and editing. The downloaded XLSX contains a Transactions sheet with five column headers. Amounts are numeric cells displayed to two decimal places; dates remain explicit text values. You can add filters or formulas in your spreadsheet application after reviewing the extraction. The workbook does not reproduce the statement's letterhead or page layout.
Choose CSV when you need a plain-text table for another application. The five columns carry the same transaction data, without workbook formatting. Before importing, check the destination's required headers, date format and treatment of debits and credits. A generic CSV is not automatically compatible with a particular accounting system, and this converter does not create QBO or OFX files.
For more about importing external data in Excel, see Microsoft's data import documentation. Available import options depend on your Excel environment. Keep the original statement and a reviewed copy of the export before adapting the columns for another workflow.
After export: validate the workbook, then reconcile
Before using formulas, confirm that imported amounts are numbers: =ISNUMBER(C2) checks a nonblank debit cell. CSV import settings can leave numeric text that Excel totals ignore; merely changing its display format is not enough. Compare the final calculated balance with the PDF closing balance, checking that Credit increases and Debit decreases a deposit-account balance.
Equal offsetting omissions can leave the closing balance unchanged, so also compare the individual source rows. Full bank reconciliation needs your independent books and a review of outstanding items, not just an internally consistent export. Use the Excel reconciliation guide and fictional worked formulas for that separate step.
After reviewing and categorizing your transactions, you can enter your monthly totals manually in the SuperCalc budget calculator. SuperCalc is operated by the same team as BankStatementMate.
What to do when conversion stops
A password-protected PDF must be unlocked in an authorized local workflow before this converter can read it. A damaged file may need to be downloaded again. If the table headings, dates or amount positions cannot be recognized, the converter stops instead of offering a knowingly incomplete result. An unsupported layout may need another tool or manual entry.
For unclear scans, first inspect the source at a readable size. If you cannot distinguish a digit yourself, obtain a clearer copy. Enlarging an already blurred picture does not restore the missing detail. If you encounter a balance warning after conversion, review the affected sequence against the original and correct any confirmed errors in your spreadsheet, preserving the source for comparison.
Common questions
Does this process upload my bank statement?
The current converter reads your selected file in your browser. Its PDF and OCR processing runs locally, without a document-upload endpoint. Remove the file or close the page to clear the current view. Downloaded spreadsheets remain wherever your browser saves them, so manage those copies according to your own privacy needs.
Is this a paid service already?
Create and verify an account for one free successful conversion, without entering payment details. Paid plans provide additional pages for the same supported formats. The five-page PDF and 10 MB file limits apply to every plan. Review the current prices and allowances before choosing a plan.
Can I combine several statements?
The current interface processes one file at a time. Review each output separately before combining data elsewhere. Keep account identifiers and statement periods clear, and check overlapping date ranges for duplicate transactions before building a combined worksheet. Follow the Excel workflow for combining multiple statement CSV files to preserve row sources and review overlaps.
For a specific task, follow the scan-to-Excel workflow, review PDF transaction extraction steps, or inspect the fictional workbook example.
Need an Excel workbook? Keep the XLSX export and review its Transactions sheet. If your destination is Google Sheets, use the manual CSV-to-Google-Sheets workflow instead, or open the XLSX there and check the imported cells. Uploading either file to Google moves that copy into your chosen Google service.