Excel: three worksheets
The workbook has Transactions, Statement, Original Fields sheets. Monetary values are numeric cells. Compare the source-page references and printed original fields with the PDF.
Explore bank statement to Excel conversionA fictional example you can inspect
Bank statement example.
Understand each field.
See what a bank statement looks like, follow the money in and out, and compare the source PDF with its matching Excel, CSV and OFX files.
Download the complete sample packZIP · fictional data · includes the method and validation results
Start with the document
What is a bank statement?
A bank statement records an account’s balances and activity over a defined period. A checking-account statement commonly shows the account, statement dates, opening and closing balances, and completed transactions. Its layout varies by bank.
This one-page example makes those fields visible without exposing anyone’s financial information. All amounts and names below are fictional and match the downloadable PDF.
What does a bank statement look like?
Fictional example · not a bank-issued document
Fulla Fictional Bank
Checking account · ending 0426
Statement period
September 1–30, 2026
- Opening balance
- $1,250.00
- Closing balance
- $3,701.00
| Date | Description | Money out | Money in | Balance |
|---|---|---|---|---|
| 09/02 | Sample client payment | — | $2,400.00 | $3,650.00 |
| 09/04 | Sample office supplies | $84.50 | — | $3,565.50 |
| 09/07 | @Sample design studio | $125.00 | — | $3,440.50 |
| 09/10 | Sample reserve transfer | $600.00 | — | $2,840.50 |
| 09/14 | Sample supplier refund | — | $24.50 | $2,865.00 |
| 09/18 | Sample software subscription | $29.00 | — | $2,836.00 |
| 09/24 | Sample project payment | — | $875.00 | $3,711.00 |
| 09/30 | Sample account fee | $10.00 | — | $3,701.00 |
On a small screen, scroll the transaction table sideways to see every column.
Download this bank statement example as PDFRead it from the top down
How to read this bank statement
- Account and bank
- Fulla Fictional Bank · checking · ending 0426
Identify which account the statement describes. This example uses an invented bank and only four account digits.
- Statement period
- September 1–30, 2026
The dates covered by this record. A statement cycle does not always match a calendar month.
- Opening balance
- $1,250.00
The balance at the start of this example’s period, before its listed transactions.
- Transaction details
- September 4 · Sample office supplies
Read the date and description together. Compare the amount in that same row rather than a nearby line.
- Money out and money in
- $84.50 debit · $2,400.00 credit
For this checking-account example, debits reduce the balance and credits increase it. Both columns show positive magnitudes; the CSV amount column uses signs.
- Running and closing balances
- $3,565.50 after the supplies debit · $3,701.00 at period end
A running balance follows a transaction. The closing balance ends the statement period; it is not a live available balance.
General reading references, checked October 9, 2026. These banks did not issue or endorse this fictional example.
Have a statement to work with?
Turn your PDF into rows you can check.
Fulla drafts the transactions from your bank statement. Review dates and amounts beside the PDF, approve the rows, then download Excel, CSV, OFX or JSON.
Use a one-page PDF: one free page every 24 hours, no account needed. Statements and derived files are deleted 24 hours after upload starts.
What this example proves
Real export code. Authored sample rows.
Manually authored fictional rows passed to the current Fulla Ledger export functions. No extraction model or external accounting importer was run to create these downloads.
The PDF is clearly marked fictional. The files demonstrate format structure, monetary values and a review check. They are not a bank-issued statement, an extraction-accuracy benchmark, or evidence of a completed QuickBooks or Xero import. The existing product videos use their own fictional examples.
Individual files
Choose what you want to inspect.
- PDFDownload
Fictional source statement
One page with selectable text and eight fictional transactions.
- JSONDownload
Expected approved rows
Complete authored rows, metadata, stable IDs and printed original fields.
- CSVDownload
Fulla CSV output
Signed amounts, debit and credit columns, UTF-8 BOM and protected formula-leading text.
- XLSXDownload
Fulla Excel output
Transactions, Statement and Original Fields sheets with numeric monetary cells.
- OFXDownload
Fulla OFX output
OFX 1.0.2 SGML with stable FITIDs; routing-number placeholder 000000000.
- JSONDownload
Worked sign correction
The deliberately incorrect row, correction and before/after balance difference.
- JSONDownload
Validation and file hashes
Reconciliation, export checks, source fingerprints and SHA-256 file hashes.
- TXTDownload
Method and limitations
Reproduction commands, format details and limits of this fictional demonstration.
A worked review example
One reversed sign changes the check by $169.00.
The statement shows a $84.50 supplies debit. If a reviewer records it as a credit, the sign is wrong in both directions: the computed closing balance becomes $3,870.00.
Check the printed debit, correct the row to -$84.50, and recalculate. The rows now explain the printed closing balance of $3,701.00.
Deliberately introduced sign error for a worked review example, not an observed model error. Every downloadable export uses the corrected rows.
Source-supported correction
- Illustrative wrong amount
- +84.50
- Reviewed amount
- -84.50
- Difference before
- 169.00
- Difference after
- 0.00
Carry the context with the rows
Know what each file contains.
CSV: preserve the original
The full export includes review context. Make a separate mapped copy for an importer that expects fewer columns. Keep one date convention and check signed amounts, row counts and formula-leading text.
Prepare a CSV importOFX: inspect the account
Open the text file to inspect currency, period, transaction amounts, stable FITIDs and closing balance. This fictional example uses a routing-number placeholder of 000000000. It is not a live-account import file.
See how PDF to OFX worksJSON: explicit expected rows
The authored reference preserves the expected row values and metadata. Compare it with a result you obtain separately; do not treat it as an observed model response.
Plan an API workflowQuestions about bank statements and this example
Is this a real bank statement?
No. The PDF, account, transactions and bank name are fictional. They are for learning and inspecting Fulla export formats, not proof of funds, income or an account balance. Obtain an official statement from your own bank when you need one.
Do all bank statements look like this?
No. Banks use different headings, layouts and statement cycles. Some group debits and credits separately or omit a running balance. This example illustrates a checking account; credit-card statements use different balances and payment information.
How do I get my own bank statement?
Use your bank’s official app, website or support channel. Look for the account’s statements or documents area and choose the required period. Availability and download steps vary by bank. Fulla converts a PDF you provide; it does not retrieve statements from your bank.
Can I convert a bank statement to Excel or CSV?
Fulla drafts transactions from an uploaded bank statement PDF. You review and correct the rows against the source, approve the revision, then download Excel, CSV, OFX or JSON. The public downloads here were generated from authored expected rows, not a measured extraction run.
What does the free conversion include?
The anonymous allowance is a PDF containing one page, once per IP address every 24 hours, with no account required. It does not extract just the first page of a longer PDF. A free workspace has a separate allowance of five pages every 24 hours.
A reproducible format check.
The method file documents the generation commands. The validation record contains file hashes and reconciliation checks so you can confirm that the files belong to the same sample. No real customer data is included.
A zero balance difference is one check, not proof that a real statement was extracted completely. Compare every date, description, amount and source page before approving your own result.