A consumer bankruptcy case runs on bank statements: six full months for the means test, three to six months for the trustee, and more when a transfer needs explaining. BankXLSX converts every statement PDF into Excel or CSV with date, description, amount, and running balance in separate columns, so deposits total in one formula and a questioned transaction takes seconds to find. Start free, no credit card.
Last updated July 2026
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Plan on six months minimum. The means test uses your current monthly income for the six full calendar months before the month you file, which is the figure bank deposits have to support. Separately, most Chapter 7 trustees request three to six months of statements for every account before the 341 meeting, and some ask for twelve. If a large deposit, a transfer to a relative, or a payment to one creditor raises a question, the trustee can look back much further, since the federal fraudulent transfer look-back runs two years and payments to insiders can be examined for a year.
The petition itself is form work. The hours go into reading statements, totaling deposits, and explaining the three transactions the trustee circled.
A married couple with two checking accounts, a savings account, and a credit union account is eight to twenty four statement PDFs before anyone has added a single number.
Current monthly income on the means test is an arithmetic figure. Adding deposits by eye across six PDF statements invites the exact error that gets a case questioned.
A payment to a family member or a car title transfer looks like every other line in a PDF. In a spreadsheet you filter by payee or sort by amount and it surfaces immediately.
Statements arrive as phone photos, scans, and forwarded PDFs, in no order, sometimes missing a month. Getting them into a single consistent format is its own chore.
A follow up asking for two more months, or for a specific deposit explained, lands with a short deadline. Reconstructing that answer from PDFs under time pressure is where mistakes happen.
Business and personal activity in the same account means somebody has to separate them line by line to produce a defensible income figure.
BankXLSX does one job: it turns the statement PDFs in a client file into clean, sortable data so the income math and the transfer review are spreadsheet work.
Amounts come through as signed numbers, so summing six months of deposits per account is a SUMIF rather than a manual tally.
Filter by payee, sort by amount, or search a name across every month at once when the trustee asks about a specific payment.
Each row keeps the printed running balance, so the converted sheet foots to the statement and you can show your figures came from the record.
Clients rarely send clean PDFs. OCR tuned for statement layouts handles scanned and image-only statements.
Upload every account and every month in one pass. Consistent columns mean the sheets stack into a single income workbook.
256-bit encryption in transit, deletion on your schedule, and no reselling or sharing of uploaded data.
No software to install and no credit card to start.
Drag in six months for every account the debtor holds, joint accounts included. Scanned and photographed statements are fine.
Tip: Use the six full calendar months before the month of filing so the means test period is covered.
Confirm each converted sheet ends at the closing balance printed on its statement. That check proves no page or transaction was dropped.
Tip: A missing month shows up as a gap between one statement's closing balance and the next one's opening balance.
Sum deposits per month for the income figure, then filter for round-number withdrawals, transfers to individuals, and payments to any single creditor over the look-back windows.
Tip: Sort by amount descending to surface the transactions a trustee will ask about first.
Consumer bankruptcy runs on documentary proof of income and transfers, and both live in the statements.
Prepare the means test, schedules I and J, and the statement of financial affairs from the client's actual account activity rather than from memory.
Assemble the trustee document package for every account and month without retyping a line.
Separate business from personal activity for a self-employed debtor and produce a defensible monthly income figure.
Get organized, totaled statement data before the 341 meeting, then take it to a licensed attorney for the legal work.
People ask how many months of statements a bankruptcy needs and get four different answers, because four different rules are running at the same time. Each one measures from a different date and serves a different purpose.
| Window | Length | What it is used for |
|---|---|---|
| Means test income period | The 6 full calendar months before the month of filing | Calculating current monthly income and the presumption of abuse |
| Trustee document request | Commonly 3 to 6 months, sometimes 12 | Verifying schedules and spotting undisclosed assets or transfers |
| Preference period | 90 days for ordinary creditors, 1 year for insiders | Payments the trustee may recover and redistribute to all creditors |
| Fraudulent transfer look-back | 2 years under federal law, longer under some state laws | Property given away or sold below value before filing |
The practical consequence is that six months covers the routine case and nothing more. If the debtor sold a vehicle to a cousin eighteen months ago or paid off a loan from a parent last year, the relevant statements are older than anything the means test asks for, and having those months already converted is what makes the answer a two minute lookup.
A Chapter 7 trustee reviews statements to confirm the schedules are complete and to find recoverable assets. In practice that means a short list: account balances on the filing date that were not disclosed or exempted, deposits that do not match the income reported on the means test, transfers to relatives and business entities, payments that repaid one creditor ahead of the others, and accounts that appear on a statement but not in the petition. Large round-number withdrawals draw attention because they suggest cash moved somewhere the schedules do not show. None of these are automatically a problem, and most have ordinary explanations, but every one of them needs an explanation ready before the 341 meeting rather than improvised at it.
The meeting of creditors is typically held roughly 20 to 40 days after the petition is filed, and the trustee wants documents in advance. The Bankruptcy Code requires the debtor to provide a tax return, and trustees routinely request a standard package beyond that:
Requirements vary by district and by trustee, so the local trustee instructions govern. What does not vary is that the statements have to be complete: every page, every account, no gaps.
Current monthly income is the average of gross income received during the six full calendar months before the month of filing, from nearly every source, with Social Security benefits excluded by statute. Statements are how you sanity check the figure. Convert the six months, tag each deposit by source, and total per month. Payroll deposits are net of withholding, so gross has to come from pay stubs, but the deposit record catches what the pay stubs miss: side income, family support received, marketplace and gig payments, rent from a roommate, and one-off receipts. It also catches double counting, which is the most common error in a self-prepared case. Transfers between the debtor's own accounts, credit card cash advances, refunds, and loan proceeds are not income, and if they land in a deposit total they inflate the figure and can create a presumption of abuse that does not belong there. Tagging each row as income or transfer before totaling is the whole discipline, and the transaction categorization tool gives you a first pass to refine.
When a debtor runs a business through a personal account, the income figure has to be reconstructed rather than read off. The workable method is to convert every month, tag each deposit as business revenue, personal income, or transfer, tag each withdrawal as business expense, personal expense, or draw, then produce a monthly profit figure with the business expenses subtracted. Schedule I and the means test treat business income net of ordinary operating expenses, so the expense side matters as much as the deposits. Doing this in a spreadsheet also produces the working papers that answer the trustee's inevitable follow-up questions about which deposits were revenue. The bank statement to profit and loss workflow covers the totaling side, and the converter for freelancers and self-employed filers covers separating business from personal activity.
Online banking portals often show only a limited window of downloadable activity while archived PDF statements stay available for years, and a closed account may not be reachable online at all. For a closed account the bank will usually produce copies on request, frequently with a per-statement fee and a wait of a week or more, which is why the request should go out at the first client meeting rather than the week before filing. Whatever comes back, PDF or paper scan, converts the same way. The guide to retrieving old bank statements covers the retention windows and what to ask the bank for.
BankXLSX prepares the documents. It converts statement PDFs into accurate Excel or CSV so the income math, the transfer review, and the trustee response are spreadsheet work instead of transcription. It does not prepare a bankruptcy petition, it does not give legal advice, and it is not a bankruptcy petition preparer or a substitute for a licensed attorney in your district. Attorneys handling adjacent matters will find the same statement prep on the divorce financial disclosure page and the law firm converter page, creditors and lenders reviewing a debtor's file should see the lender converter, and the general bank statement converter reads statements from more than 90 US banks and credit unions, so a client file spanning four institutions still produces one consistent workbook.
Six months covers the routine case. The means test uses the six full calendar months before the month you file, and most Chapter 7 trustees separately request three to six months of statements for every account before the 341 meeting. Some trustees ask for twelve, and requirements vary by district, so follow the local trustee instructions.
Yes. The trustee reviews statements for every account you disclose, checking that balances, income, and transfers match your schedules and the means test. The review is a normal part of every case, not a sign of suspicion, and the statements are usually requested in advance of the meeting of creditors.
Usually three to six months for the routine document request. If something raises a question, the trustee can go back much further: payments to ordinary creditors are examinable for 90 days before filing, payments to insiders such as family for one year, and transfers of property for two years under the federal fraudulent transfer rule, with some state laws reaching further.
Undisclosed accounts and balances, deposits that do not match the income on the means test, transfers to relatives or business entities, payments that repaid one creditor ahead of others, and large round-number cash withdrawals. Most have ordinary explanations, but each one should have that explanation documented before the 341 meeting.
The means test income figure comes from all sources of gross income for the six full calendar months before the month of filing. Pay stubs supply gross wages, but statements catch what the stubs miss, including side income, family support, gig and marketplace payments, and one-off receipts. They also catch transfers and refunds that must not be counted as income.
Typically bank statements for every account covering three to six months, roughly sixty days of pay stubs, two years of filed federal tax returns, vehicle titles and registrations, and documentation for any transfer the trustee flags. The exact package is set by the trustee and the district, so check the instructions you receive.
Yes. Upload each statement PDF and BankXLSX returns every transaction as a row with date, description, amount, and running balance in Excel or CSV. Scans and phone photos are read with OCR, and you can batch every account and month in one upload so deposits total across the full means test period.
No. It converts statement PDFs into accurate Excel or CSV so the income math and the document review are spreadsheet work. It does not prepare petitions, does not provide legal advice, and is not a substitute for a bankruptcy attorney licensed in your district.
Financial disclosure statement prep.
The wider firm and matter workflow.
Separate business from personal activity.
Net a self-employed debtor's income.
Tag deposits as income or transfer.
From the same family of tools
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
