The Fulla Ledger reading room
Bank statement guides.
One useful step at a time.
Find a practical answer for the statement in front of you: prepare the PDF, check the rows or choose the right handoff.
69 guides and articles · six tasks to explore
New here?
Three useful places to start.
The full library
Find the task in front of you.
Showing 69 of 69 guides
- Converttutorial
How to convert a bank statement PDF to Excel
Upload the statement, check each drafted transaction against its page, approve one revision, and export it as XLSX.
6 min read
- Reviewtutorial
How to review extracted bank transactions
Use the source page, row evidence, balance sequence, and page coverage together before approving a statement export.
7 min read
- Exportreference
CSV vs Excel, JSON and OFX for Bank Statements
Use CSV for simple tabular exchange, XLSX for workbook review, OFX for QuickBooks Online or Xero statement imports, and JSON for structured application data.
5 min read
- Protectreference
Bank Statement Privacy, Redaction and Retention
Statement sources, extracted rows, review events, and exports share one 24-hour deadline and stay behind authorized access.
6 min read
- Preparechecklist
Preparing scanned and password-protected statements
Use the complete original PDF, confirm the page order, provide the document password when asked, and review scan-derived rows closely.
5 min read
- Developprocess
Automated bank statement processing with a human approval step
Automate PDF extraction and structural checks, then verify source-linked transactions and approve the exact revision before export.
6 min read
- Reviewchecklist
Bank statement reconciliation checklist for reviewed transactions
Use the statement period and available balances to test an extracted sequence, and record exceptions that statement data alone cannot settle.
7 min read
- Exportprocess
Bulk bank statement conversion: review before batch export
Upload bounded groups of PDFs, review and approve each document, then create a paid workspace batch for a combined CSV, XLSX, or OFX export before the earliest document expires.
7 min read
- Developarticle
Bank statement extraction API: from draft rows to approved data
An extraction response is evidence for review, not an export authorization. Use a workspace API key to inspect, correct, approve, and convert the revision you checked.
7 min read
- Reviewtutorial
How to Reconcile a Bank Statement and Resolve Differences
A bank reconciliation explains why the balance on the bank statement differs from the balance in your records on the same date. Match the lines that appear in both, adjust the bank side for deposits in transit and outstanding payments, record bank-only items such as fees and interest in your books, and keep the result with the statement.
7 min read
- Reviewarticle
Bank statement conversion for bookkeepers: protect the handoff
Separate each client’s evidence, verify the drafted transactions against the PDF, then map and review the approved export in the destination system.
6 min read
- Converttutorial
How to convert a bank statement PDF to CSV
If your bank offers a CSV download for the period you need, use it. When you only have the PDF, extract the rows, check each one beside its source page, approve the result, and download a UTF-8 CSV with signed amounts, separate debit and credit columns, balances, currency, and the source page of every row.
6 min read
- Convertreference
Free bank statement converter: what is free and what to check
Fulla converts one page per IP address per rolling 24 hours without an account, and five shared pages per rolling 24 hours in a free registered workspace, with no card required. Free conversions get the same source-linked review, 24-hour retention, and CSV, XLSX, and OFX downloads for single statements. Before trusting any free tool, check where the file goes, how long it stays, whether you can review rows against the page, and what you can download.
6 min read
- Exporttutorial
CSV to QBO: format a bank CSV for QuickBooks Online
QuickBooks Online imports bank CSV files directly through Upload from file, so you rarely need to turn a CSV into a .qbo file. Trim the CSV to Date, Description, Amount or Date, Description, Credit, Debit, keep dates in one format, leave zero cells blank, stay within 1,000 lines and 350 KB, then map the columns and check the signs before importing.
6 min read
- Preparechecklist
How to choose a bank statement converter: a buyer’s checklist
The best bank statement converter is the one whose output you can verify quickly and hand to the next system without retyping. Test a few options on your own difficult statements and score them on review, traceability, file handling, formats, retention, pricing, and automation, including the option of not using a dedicated converter at all.
6 min read
- Exportarticle
Convert PDF to OFX: Fulla Ledger now exports reviewed bank statements as OFX
Fulla Ledger can now convert PDF to OFX. After you review and approve a statement, Download OFX creates an OFX 1.0.2 file with posted dates, signed amounts, the statement balance and a stable transaction ID for every approved row, ready for the bank statement import in QuickBooks Online or Xero.
7 min read
- Exporttutorial
How to upload bank statements to QuickBooks Online: PDF, OFX or CSV
QuickBooks Online accepts a bank statement as a PDF or image, or as a list of transactions in .csv, .txt, .qbo or .ofx. This guide compares the routes, shows how to turn a reviewed PDF into an OFX file with Fulla Ledger, and walks through Upload from file, including file limits and common errors.
8 min read
- Exporttutorial
Import bank statement into Xero: how to load a PDF statement as OFX
Xero imports bank statements as OFX, QFX, QBO, QIF or CSV files, and recommends OFX where possible. When you only have a PDF, review it in Fulla Ledger, download an OFX file, and import it through the bank account’s Import a Statement option, then reconcile.
7 min read
- Exportarticle
OFX vs QFX vs QBO vs CSV: which bank file format should you use?
OFX is the open standard for bank statement data. QFX is Quicken’s Web Connect variant, QBO is QuickBooks’ Web Connect file, and CSV is a plain table with no fixed columns. Match the file to the program that will import it.
7 min read
- Exportarticle
PDF to QBO converter: what QuickBooks Online actually needs from a PDF statement
A PDF to QBO converter search usually starts with QuickBooks Online, which accepts .ofx, .csv and even PDF statements, so a .qbo Web Connect file is not required. QuickBooks Desktop is different: it reads only .qbo Web Connect files from your bank. Here is how to choose, and how to turn a PDF into a reviewed OFX file.
7 min read
- Reviewtutorial
Reconcile Bank Statements in Excel and Review Duplicates
Put statement rows and ledger entries on separate sheets. Use formulas to find match candidates, then confirm one-to-one matches with source references. Adjust bank cash for timing items and book cash for supported bank-only items or errors; both adjusted balances should agree.
9 min read
- Convertreference
Can ChatGPT convert bank statements to Excel?
Yes, for some PDFs, with caveats. OpenAI says ChatGPT can analyze uploaded PDFs, create tables and produce downloadable spreadsheets. It also says ChatGPT may not reliably extract exact values from scanned files or complex layouts, and that you should review its outputs before relying on them. For a bank statement, check every row and the closing balance against the PDF whichever tool you use. Disclosure: Fulla Ledger, which publishes this guide, makes one of the tools compared here. There are no affiliate links.
8 min read
- Protectreference
Is it safe to upload bank statements to an online converter? 8 questions to ask
It can be, if you know where the file goes, who can read it and when it is deleted. A bank statement shows names, account numbers, balances and spending, so ask any converter the eight questions below before you upload your own or a client’s statements. Fulla Ledger, which publishes this guide and makes a converter, gives its own answers in the last column of the table: it deletes the PDF, extracted rows and exports 24 hours after the upload starts, sends statement pages to one named AI service with zero data retention, and lets support open a statement only with your consent. It does not publish a SOC 2 report.
8 min read
- Reviewchecklist
How accurate are bank statement converters? How to check a converted statement
No converter gets every statement right, and an advertised accuracy figure tells you little about your own bank’s PDFs. A closing balance that matches is a useful check but not proof that every row is right: two errors can cancel each other out, and a wrong date or description does not change the balance at all. Check page coverage, totals, signs, dates and the running balance against the original PDF before you use the data.
8 min read
- Reviewreference
What Is a Bank Reconciliation? Formula and Example
A bank reconciliation is a short internal document that compares the ending balance on your bank statement with the cash balance in your own records on the same date, lists every item that explains the gap, and shows that both adjusted balances agree. It is a routine control for catching errors, unrecorded fees and fraud. Items the bank has not processed yet adjust the bank side; items only the bank knows about adjust the book side and need a journal entry.
8 min read
- Reviewtutorial
Bank reconciliation examples: four solved problems from simple to hard
A bank reconciliation example starts with the statement ending balance and the book balance on the same date, adjusts the bank side for deposits in transit, outstanding checks and bank errors, adjusts the book side for fees, interest, NSF checks and book errors, and ends with two equal adjusted balances. The four solved problems below grow harder in steps, and every number is fictional.
12 min read
- Reviewprocess
Bank reconciliation journal entries: which items need one, with debits and credits
Bank reconciliation journal entries are needed only for book side items: things the bank recorded that your books have not, such as service fees, interest earned, NSF checks, automatic payments and electronic deposits, plus your own posting errors. Deposits in transit, outstanding checks and bank errors need no entry. After posting, the cash account should equal the adjusted bank balance.
8 min read
- Reviewreference
Outstanding checks: what they are, how to treat them in a bank reconciliation, and what to do with old ones
Outstanding checks are checks you have written and recorded in your books that the bank has not paid by the statement date, usually because they are still in the mail or the payee has not deposited them yet, so the bank balance is higher than your book balance. In a bank reconciliation, list each one by number and amount and subtract the total from the bank statement balance. Carry the list forward each month, take checks off when they clear, and follow up on any that stay open for months: contact the payee, void and reissue if needed, and check your state’s unclaimed property rules before you write anything off.
8 min read
- Reviewreference
Deposit in Transit and Outstanding Deposits
A deposit in transit, also called an outstanding deposit, is a deposit already recorded in your bank-account books but not yet posted on the statement at cutoff. Add it to the bank side of the reconciliation, then trace its clearance in the following period. An ordinary timing difference does not create a new journal entry.
7 min read
- Reviewchecklist
Month-End Close Process and Downloadable Checklist
The month-end close process is the set of tasks you finish after each month ends so the books for that month are complete, reconciled and locked: gather statements for every account, record and categorize transactions, reconcile bank and card accounts, review receivables and payables, post adjustments, review the reports, then lock the period. A small business can usually plan it across the first five business days of the next month.
10 min read
- Prepareprocess
Catch up bookkeeping: a month-by-month plan to get your books current
To catch up on bookkeeping, start from the last month your books were reconciled, gather the bank and card statements for every account since then, get each month’s transactions into your software, categorize them, and reconcile one month at a time, oldest first, until you reach the current month. Then keep a weekly and monthly routine so you do not fall behind again.
10 min read
- Exportreference
What is an OFX file? The Open Financial Exchange format, tag by tag
An OFX file is a plain-text file in the Open Financial Exchange format that carries bank or credit card transactions, the account they belong to and a balance, so accounting or budgeting software such as QuickBooks Online, Xero or GnuCash can import every transaction without anyone retyping it. Intuit, Microsoft and CheckFree created OFX in 1997. It is a data file for software, not a document like a PDF or a spreadsheet like Excel.
10 min read
- Exportreference
What is a QFX file, and how do you open one?
A QFX file (Quicken Financial Exchange) is a bank or credit card transaction file that you download from your bank’s website and import into Quicken, a method Quicken calls Web Connect, so your dates, amounts, descriptions and balances arrive without manual entry. It is a variant of the OFX format. Quicken validates the file online when you import it, and a file from a bank that no longer supports Web Connect cannot be authorized.
7 min read
- Exportreference
What is a QBO file, and what application opens it?
A QBO file is a bank or credit card transaction file with a .qbo extension that you download from your bank and import into QuickBooks Desktop or QuickBooks Online, a method Intuit calls Web Connect, so the transactions arrive without manual entry. It uses the OFX format. QuickBooks Desktop needs a .qbo file for Web Connect, while QuickBooks Online also accepts .ofx and .csv. Do not confuse it with QBO, the common abbreviation for QuickBooks Online.
8 min read
- Reviewreference
What Does a Bank Statement Look Like? Business Example
A bank statement looks like a formal letter or PDF with the bank’s name, your name and address, a partly hidden account number and the statement period at the top, then an account summary of opening balance, money in, money out and closing balance, then a dated list of every completed transaction. Layouts vary by bank, but those parts are nearly always there. Below is an annotated fictional statement, a part by part reading guide, how checking, savings and credit card statements differ, and what a landlord or lender looks for when you hand one over.
8 min read
- Preparetutorial
How to get old bank statements, including from closed accounts and years ago
To get old bank statements, sign in to online banking and open the statements or documents section, which at banks such as Chase and Wells Fargo holds up to seven years for many accounts, or order copies by phone, at a branch or in writing when the month is older or the account is closed. Federal rules require banks to keep most deposit records for five years, so statements from 20 years ago are usually gone. This guide covers where to ask in each situation, what it may cost, and how to get old statements into your books.
8 min read
- Protectreference
How long to keep bank statements: IRS periods, FTC guidance and a simple schedule
Keep bank statements for as long as they support something: at least 3 years after filing for statements behind your tax return, 6 years if you left out income that is more than 25% of the gross income shown on your return, 7 years for a bad debt or worthless securities claim, and indefinitely if you did not file or filed a fraudulent return, per the IRS. The FTC lists bank statements among the documents to keep for a year. Statements that support property costs or employment taxes have their own longer periods, covered below.
7 min read
- Converttutorial
Copy a PDF Table into Excel: Methods and Limits
The cleanest way to copy a table from a PDF to Excel is Excel’s own import, available in Excel for Microsoft 365 on Windows: select Data, Get Data, From File, From PDF, pick the table in the Navigator and select Load, and Excel loads it as rows and columns. Plain copy and paste often lands everything in one column because a PDF stores text by position, not in cells. This guide gives exact steps for four methods, explains why pasting breaks, and shows how to fix merged columns, numbers stored as text, negatives in parentheses and dates.
9 min read
- Preparetutorial
How to download a Capital One bank statement
Start with the statement for the right account and period. Capital One can combine account sections in one document, so a file name alone is not enough to identify the rows you need.
4 min read
- Preparetutorial
How to download a Chase bank statement
For a personal Chase account, use Statements & documents and select the account and year. Keep the saved PDF tied to its statement period before using it in a spreadsheet workflow.
4 min read
- Preparetutorial
How to download a Bank of America statement
First look for the issued statement in the account’s document area. If it is outside the available list, Bank of America has a separate statement-copy request process.
4 min read
- Preparetutorial
How to download a Wells Fargo bank statement
Select the issued statement when you need a completed period. Wells Fargo’s Account Activity screen serves a different purpose and may include pending transactions.
4 min read
- Preparetutorial
How to download a Chime bank statement
Choose the account and month in Chime’s statement area, then check the sections inside the document. Checking, savings and Credit Builder records should not be treated as interchangeable.
4 min read
- Exporttutorial
Import a bank statement CSV into Google Sheets
Start with the original CSV and import it into a separate sheet. Check that Google Sheets has interpreted the records correctly before combining them with your existing work.
4 min read
- Preparereference
PayPal statements and activity reports: which file to download
Choose the report that answers your question. A monthly balance statement, an activity export and a bank statement showing PayPal transfers describe different parts of the payment history.
4 min read
- Preparereference
Bank Statement vs Transaction History
A statement describes an issued period. A transaction-history view helps inspect account activity, often across a different range. Align their dates and statuses before calling a difference an error.
4 min read
- Preparereference
When Bank Statements Are Available and Early Requests
There is no single release day for every bank account. Check the completed period, the account’s statement schedule and its document area before treating a statement as missing.
4 min read
- Reviewreference
Bank Statement Abbreviations and POS Entries
POS usually means point of sale, commonly a card purchase. ATM and ACH describe different transaction channels. Bank-specific labels vary, so preserve the original description and confirm the reference, direction and supporting receipt before interpreting a row.
4 min read
- Reviewreference
Bank statement vs credit-card statement: choose the right document
A checking statement describes money held and moved through a deposit account. A credit-card statement describes a borrowing account and its billing activity. Identify the account before interpreting balances or preparing transaction data.
4 min read
- Reviewtutorial
Bank Transactions, Debits, Credits and Signed Amounts
For the deposit-account examples here, money entering the account is positive and money leaving it is negative. Confirm the source labels and receiving format, apply the rule once, and check the resulting balance movement.
4 min read
- Exporttutorial
Open Bank Statement CSV in Excel Without Damaging Data
If your bank already supplies a CSV, start with that file. Use an import preview, preserve identifiers as text, check dates and amounts, and save a separate XLSX working copy after validating the result.
4 min read
- Exportchecklist
Fix Bank Statement CSV Dates in Excel
A date such as 04/05/2026 can represent two different days. Keep the original text, establish the source’s date order, and import with an explicit interpretation. Changing the displayed format cannot repair a date that was parsed incorrectly.
4 min read
- Exporttutorial
Fix CSV Files Opening in One Column in Excel
When each CSV record appears in one Excel column, the separator may not match the import setting. Inspect the raw file, choose its delimiter in the preview, and check descriptions, dates and amounts before saving.
4 min read
- Exportchecklist
Avoid duplicate bank transactions in QuickBooks Online uploads
A manual file and a later bank-feed update can cover the same transactions. Compare the account and date range before uploading, then confirm suspected duplicates against the statement instead of removing rows based only on matching amounts.
4 min read
- Exportchecklist
Find missing bank statement lines in Xero after an import
Compare the same account and date first. Narrow the first balance difference to a short period, check the source rows and Xero’s statement exceptions, then address the confirmed cause instead of uploading the whole statement again.
4 min read
- Developreference
OFX FITID: transaction IDs and duplicate imports
FITID identifies a transaction within the OFX account context. It can help an importer recognize a repeated record, but it is not an accuracy certificate or a universal match across bank feeds, re-uploads and newly saved revisions.
4 min read
- Reviewreference
Statement period vs calendar month: avoid gaps and overlaps
A statement labeled February may cover dates in both January and February. Build your coverage list from printed start and end dates, then check the requested period before combining or filtering transaction rows.
4 min read
- Preparechecklist
Check a bank statement PDF for missing pages before conversion
A PDF can open normally while containing an incomplete statement. Compare its page count with printed numbering, follow transaction continuations, and obtain a complete source before treating extracted rows as a full record.
4 min read
- Reviewreference
What Is a General Ledger? Accounts and a Worked Example
A general ledger is the collection of accounts that records a business’s assets, liabilities, equity, income and expenses. Journals record transactions in date order; posting groups their debits and credits by account in the ledger. The account balances then feed a trial balance and financial statements.
6 min read
- Reviewreference
Debit Memo vs Credit Memo: Bank and Invoice Examples
On a deposit-account statement, a debit memo generally reduces the customer’s bank balance and a credit memo increases it. In seller-issued invoicing, a credit memo reduces what the customer owes; a debit memo increases it. Always identify the issuer, affected account and reason before deciding the accounting entry.
5 min read
- Reviewprocess
Account Reconciliation: Process and Worked Examples
Account reconciliation compares a general-ledger balance with reliable supporting evidence at the same cutoff date, explains differences, and records approved corrections. Cash uses a bank statement and timing items; other balance-sheet accounts need evidence such as invoices, schedules, contracts or subledgers.
6 min read
- Reviewtutorial
NSF Check: Meaning, Bank Reconciliation and Journal Entry
An NSF check is a check returned for nonsufficient funds in the payer’s account. When your deposited customer check is returned after you recorded its receipt, reduce book cash and normally restore the customer receivable. Record any actual bank fee separately. It is not an ordinary outstanding-check timing difference.
5 min read
- Reviewprocess
General Ledger Codes and Mapping: A Worked Example
General ledger coding assigns transactions to approved accounts in a chart of accounts. General ledger mapping connects source fields or source-system accounts to those destination accounts. Amount direction and merchant text are clues, not sufficient evidence of the correct classification.
5 min read
- Reviewtutorial
How to Balance a Checkbook: A Worked Reconciliation
To balance a checkbook, update the register with every deposit, payment and bank charge, mark items that appear on the statement, and reconcile pending items at the statement cutoff. The adjusted bank balance should equal the corrected register balance; it need not equal the unadjusted statement balance.
5 min read
- Reviewreference
Cash Book: Single-Column and Petty-Cash Examples
A cash book records cash receipts and payments and the resulting balance. A single-column cash book tracks cash amounts without separate bank or discount analysis columns. A petty cash book tracks a small controlled fund and its vouchers. Neither replaces the business’s other general-ledger accounts.
6 min read
- Reviewreference
Cash Receipts and Cash Disbursements Journals
A cash receipts journal records incoming cash, normally with a debit to Cash. A cash disbursements journal, also called a cash payments journal, records outgoing cash with a credit to Cash. The other account explains why money moved: receipts are not always revenue and disbursements are not always expenses.
5 min read
- Reviewreference
General Ledger vs Journal, Subledger and Trial Balance
A journal records transactions in date order; the general ledger groups postings by account. A subledger supplies detail behind a control account, a trial balance lists net ledger balances at a date, and the chart of accounts defines the available account codes. These are connected records, not competing names for one report.
6 min read
- Reviewchecklist
Accounting Errors, Transpositions and Suspense Accounts
Accounting errors must be corrected from evidence of what should have been recorded, compared with what was actually posted. A balanced trial balance can still contain omissions, duplicates and wrong accounts. A suspense account is a temporary controlled holding account, not permission to hide an unexplained difference.
6 min read
- Preparereference
Opening Balance and Opening Balance Equity Explained
An opening balance is the supported account balance at the date you start recording activity. Opening Balance Equity in QuickBooks is a setup offset used when entering opening balances; it is not automatically new income or the correct permanent equity classification. Reconcile the full opening records and have the responsible accounting reviewer resolve the offset.
6 min read
Put the reading to work
Try it with one statement page.
Use a one-page PDF: one free page every 24 hours, no account needed.