Updated October 2026 · 6 minute read
Whether you are pulling six months of income together for a bankruptcy attorney or catching up on a year of bookkeeping, the job is the same: get every transaction out of PDF statements and into a spreadsheet you can total and check. This guide covers the requirements that set the date range, three ways to convert statements, and the checks that catch errors.
- Means test: uses average monthly income from the 6 full months before you file.1
- Meeting of creditors: bring a statement for each bank and investment account covering the filing date, unless the trustee says otherwise.2
- Easiest source: CSV downloads from online banking. Next: Excel’s Get Data from PDF.3
- Always check: opening balance + deposits − withdrawals = closing balance, statement by statement.
- Scanned or messy statements need manual cleanup or a conversion service.
Why the date range matters
| Purpose | What it needs |
|---|---|
| Chapter 7 means test (Form 122A-1) | Average monthly income received during the 6 full months before filing1 |
| Meeting of creditors (Rule 4002) | A statement for each depository or investment account for the period that includes the filing date, unless the trustee instructs otherwise2 |
| Bookkeeping catch-up | Every month since the books were last closed, for every business account and card |
Your bankruptcy attorney or trustee may ask for more than this, so confirm the months and accounts with them before you start. This guide is about organising the data, not legal advice.
Three ways to get statements into Excel
| Method | Good for | Watch out for |
|---|---|---|
| CSV download from online banking | Recent months; clean dates and amounts | How far back your bank lets you download; no statement balances |
| Excel Get Data from PDF (Power Query)3 | Text-based PDF statements | Multi-line descriptions split into extra rows; page headers; not for scanned images |
| Manual entry or a conversion service | Scanned, photographed or very messy statements | Time, and typing errors if done by hand |
In Excel, the PDF connector reads tables from a PDF file and lets you load them or clean them first in the Power Query Editor. Microsoft notes that multi-line rows can be misread and may need cleanup.3
A layout that works
| Column | Example |
|---|---|
| Date | 2026-04-03 (a real date, not text) |
| Account | Checking …4821 |
| Statement period | Apr 2026 |
| Description | Payroll deposit, ACME LLC |
| Amount | 2,140.00 (deposits positive, withdrawals negative) |
| Balance | 3,912.55, if the statement shows it |
| Category | Wages, Transfer, Rent, Fuel… |
One row per transaction, one table for all accounts. Tag transfers between your own accounts as Transfer so they don’t count as income or spending.
Checks before you hand it over
- Balance check per statement: opening balance + deposits − withdrawals should equal the closing balance printed on the statement.
- Row count: compare the number of transactions to the statement, especially across page breaks.
- Dates are dates: sort by date; text dates sort in the wrong order.
- Signs: no withdrawals showing as positive.
- No missing months: list every account and month and tick each one off.
Total income by month
Add a Month column next to the date with =TEXT(A2,"yyyy-mm"), then, with each column set up as a named range or table column, total deposits that are not transfers:
=SUMIFS(Amount, Month, "2026-04", Amount, ">0", Category, "<>Transfer")
Repeat for each of the six months and average them. Your attorney will decide how each kind of income is treated on the forms; the spreadsheet just gives them clean, checked totals.
Hand over statements, get back a clean spreadsheet
We convert PDF and scanned bank statements into one checked Excel file, every statement balanced, with monthly totals ready for your attorney or bookkeeper.
Questions
How many months of bank statements do I need for bankruptcy?
It depends on your attorney and trustee, but two rules drive it. The Chapter 7 means test uses your average monthly income from the 6 full months before you file, and at the meeting of creditors you must bring a statement for each bank or investment account covering the filing date, unless the trustee says otherwise. Ask your attorney exactly which months to gather.
Can I convert a PDF bank statement to Excel for free?
Often, yes. Your bank’s online banking may let you download transactions as CSV, which opens in Excel. Excel’s Get Data from PDF can also pull tables out of text-based PDFs. Scanned statements, multi-line descriptions and running balances are where free methods usually need cleanup.
Why don’t my converted bank statement totals match?
Usually a missed or split line, a debit read as a credit, or a page header picked up as a transaction. Check that opening balance plus deposits minus withdrawals equals the closing balance on each statement before you use the data.
How do I total income by month from bank statements in Excel?
Add a Month column with =TEXT(A2,”yyyy-mm”) next to each date, then use SUMIFS to add deposits by month, and exclude transfers between your own accounts so income isn’t double counted.
Is a spreadsheet of bank transactions enough for my bankruptcy filing?
It is a working tool, not a filing. Your attorney decides what goes into the forms and may need the original statements too. Keep the PDFs with your spreadsheet.
Related guides
Sources
- U.S. Courts: Official Form 122A-1, Chapter 7 Statement of Your Current Monthly Income (PDF)
- Federal Rules of Bankruptcy Procedure, Rule 4002 (Cornell LII)
- Microsoft Learn: Power Query PDF connector
Tahir Abbas
Founder of Softotech Solutions. Tahir’s team converts bank statements and other PDFs into checked Excel files for bookkeepers, attorneys’ clients and small businesses. This guide is general information, not legal or tax advice.