Bank Statement Converter for Medicaid Look-Back

Why the Medicaid Look-Back Buries Staff in Paper

The legal strategy is the expertise. Reading five years of a client's statements to find every questionable transfer is not, and it is where these cases lose their first days.

Sixty Months, Every Account

Most states look back 60 months from the application date, across checking, savings, money market, and CDs, so a single applicant can arrive with dozens of monthly PDFs to read.

Closed Accounts Still Count

The look-back includes accounts closed within the five years, so statements for accounts that no longer exist still have to be gathered and reviewed line by line.

Transfers and Gifts Trigger Penalties

A gift or below-market transfer during the look-back creates a penalty period, so every large debit has to be found, explained, or documented before the application goes in.

The PDF Will Not Paste as Rows

Copy a statement into Excel and the columns collapse into one cell, so building a five-year transaction history by hand means retyping every line.

Deposits Have to Be Sourced

Caseworkers question unexplained deposits, so you need every deposit in a row to identify the source before a reviewer asks about it.

Scanned Statements From the Family

Families photograph or rescan old statements, leaving image-only PDFs you cannot select, which stalls the whole file until someone keys them in.

How BankXLSX Turns Five Years of Statements Into Reviewable Data

Upload the statements for every account across the look-back, and the converter writes each transaction into spreadsheet columns you can sort, filter, and trace for the caseworker.

One Row Per Transaction

Each line becomes a row with date, description, amount, and running balance, so every transfer and withdrawal across five years is ready to sort and trace.

Find Large Transfers Fast

With amounts in a column, sort or filter to surface every large debit at once, so gifts and below-market transfers do not slip past the review.

Spans the Full 60 Months

Convert five years of statements in one workflow and stack them into a single continuous history the caseworker can follow from the first month to the last.

Reads Scanned Statements

OCR pulls the numbers off image-only statements a family photographed or rescanned, so a photocopied old statement still becomes rows you can work with.

Running Balance Preserved

The statement balance carries through every row, so the account balances tie back to the statements the state reviewer is holding.

Private by Default

256-bit encryption in transit and you can delete uploads whenever you want, which matters for a client file full of names, account numbers, and balances.

Prepare Medicaid Look-Back Statements in 3 Steps

No software to install and no credit card to start.

1

Gather the Statement PDFs

Collect statements going back 60 months for every account, open or closed, from the client, family, or online banking.

Tip: Ask the bank for statements on accounts closed within the last five years.

2

Upload

Drag the statements into the box above. The converter reads each one, scans included, and writes every transaction to a row.

Tip: Upload all accounts so you can trace transfers between them.

3

Download and Review

Save the result as XLSX or CSV, then sort by amount to surface large transfers and filter deposits to confirm each source.

Tip: Flag anything that looks like a gift so you can document it before filing.

Who Converts Statements for Medicaid Planning

Anyone assembling a long-term care Medicaid application works from years of a client's statements, so the people converting them are the professionals who plan and file these cases.

Elder Law Attorneys

Attorneys filing long-term care applications convert five years of statements to trace transfers and build a defensible record for the caseworker.

Medicaid Planners

Planners running spend-down and eligibility analysis turn a client's statements into rows so they can model the look-back without keying every line.

Paralegals and Case Managers

The staff who assemble the application convert the statement stack in bulk so the review starts from clean data instead of a pile of PDFs.

Families and Fiduciaries

An adult child or appointed agent gathering a parent's records converts the statements to hand an organized history to the attorney.

Common Search Terms

bank statement converter for medicaid medicaid look-back bank statements to excel 5 year look-back bank statements medicaid application bank statements spreadsheet elder law bank statement conversion 60 month look-back statements medicaid spend down bank statements

Transaction Types We Handle

Large withdrawals and transfers

Gifts to family members

Below-market asset transfers

Deposits needing a source

Recurring care and living expenses

Account closing balances

Transfers between the client's accounts

Running balance

How many months of bank statements does Medicaid require?

Up to 60 months for every account. Most states apply a five-year look-back to long-term care Medicaid, counting back from the application date, and they can ask for statements on every checking, savings, money market, and CD account, including accounts closed within those five years. California and New York run on different rules, so confirm the requirement for the state where the client applies. Whatever the count, the task is the same: convert each statement to rows, trace the transfers, and document the sources so the figures match the statements the state reviewer is holding.

What is the Medicaid look-back period?

The look-back period is the window of time before a Medicaid application during which the state reviews financial transactions for gifts and below-market transfers. In most states it is 60 months. If a caseworker finds an uncompensated transfer during that window, it creates a penalty period, a stretch of time the applicant is ineligible even though they are otherwise financially qualified. That is why the review matters: every large debit across five years has to be found and either explained as a legitimate expense or documented, and doing that from raw PDFs is slow. The table below shows which transactions typically draw questions.

Transaction on the statement	Why a caseworker asks about it
Large check or transfer to a relative	Possible gift that triggers a penalty period
Cash withdrawal with no clear purpose	Unexplained outflow that needs documenting
Transfer between the client's own accounts	Not a gift, but must be shown as an internal move
Deposit from an unknown source	Income or asset the state will want identified

How do you trace transfers across five years of statements?

Put every transaction in a spreadsheet, then sort by amount to bring the largest debits to the top and filter the description column to group them. With the whole look-back in rows you can total the outflows to family members, confirm which transfers moved between the client's own accounts, and isolate the deposits that need a source. Once the transactions are in a sheet, categorizing the transactions separates ordinary living and care expenses from the transfers that need an explanation, so the file you hand the caseworker is already organized.

Documenting the record for the caseworker

A Medicaid application stands or falls on documentation, so the goal is a clean, continuous transaction history the reviewer can follow without gaps. Converting each statement and stacking the results gives you that history in one file, with the running balance tying each month to the next. For accounts that are closed, request the statements from the bank and convert them the same way so the closed-account activity sits in the same sheet. The general PDF bank statement to Excel converter handles every US bank, and to tie the reported balances back to the source, preserving the running balance keeps each figure traceable to the statement it came from.

BankXLSX converts documents to spreadsheets. It does not give legal, tax, or Medicaid planning advice and does not determine eligibility. Look-back rules and penalties vary by state and change over time, so follow the current rules for your state or consult a licensed elder law attorney.

Why Elder Law Teams Pick BankXLSX

60 months

of statements in one continuous sheet

Scans

image-only old statements read by OCR

Under 1 min

to convert a monthly statement

Security & Privacy

256-bit encryption on every upload
Delete your files at any time
No reselling or sharing of client data
Reads the statement as is, never alters the figures

Bank Statements for Medicaid: Common Questions

Up to 60 months. Most states apply a five-year look-back to long-term care Medicaid and can request statements for every checking, savings, money market, and CD account, including accounts closed within those five years. California and New York use different rules, so confirm the requirement for the state where the client applies.

It is the window before a Medicaid application, generally 60 months, during which the state reviews transactions for gifts and below-market transfers. An uncompensated transfer found in that window creates a penalty period during which the applicant is ineligible, which is why every large transfer across the five years has to be found and documented.

Yes. OCR pulls the numbers off image-only statements that were photographed or rescanned, so a photocopied statement from years ago still becomes rows you can sort and trace for the look-back review.

Convert every statement to a spreadsheet, then sort by amount to bring the largest debits to the top and filter the description column to group them. That surfaces gifts and below-market transfers at once instead of reading each PDF line by line.

Yes. The look-back includes accounts closed within the five years, so request those statements from the bank and convert them the same way. The closed-account activity then sits in the same sheet as the open accounts for a complete history.

Uploads use 256-bit encryption in transit, you can delete files at any time, and data is never resold or shared. The conversion runs without installing anything, which matters for a client file that lists names, account numbers, and balances.

No. BankXLSX converts statement PDFs to spreadsheets and nothing more. It does not give legal, tax, or Medicaid planning advice and does not determine eligibility. Look-back rules vary by state, so follow the current rules for your state or consult a licensed elder law attorney.

Try BankXLSX Free | Browse All Resources | View Pricing

Other Bank Statement Converters

ICICI Bank JPMorgan Chase Bank of America Citigroup Wells Fargo Goldman Sachs Morgan Stanley U.S. Bancorp PNC Financial Services Truist Capital One TD Bank Charles Schwab Fidelity Vanguard E*TRADE TD Ameritrade Bank of New York Mellon State Street BMO USA Ally Financial Regions Fifth Third Bank Huntington KeyBank Citizens Financial Group First Citizens Synchrony Financial M&T Bank First Horizon Cathay Bank USAA Navy Federal Comerica Zions Bank East West Bank First National of Nebraska Frost Bank BOK Financial Fulton Financial Associated Banc-Corp Valley National Wintrust Financial First Midwest Bancorp Commerce Bancshares UMB Financial Pinnacle Bank Webster Bank Cadence Bank Old National First Interstate BancSystem Umpqua Bank First Hawaiian Bank Prosperity Bank SouthState First Merchants First Bank Holding Glacier Bank First Financial Bancorp Independent Bank Columbia Banking System Western Alliance Pacific Premier Bancorp Bank OZK United Community Banks Customers Bank Texas Capital SVB Financial Group Signature Bank First Republic Bank New York Community Bancorp Sterling Bancorp First Bank Bank United First Commonwealth Financial Flagstar Bank Synovus Bank Santander Bank Commonwealth Bank (CommBank) ANZ Bank Westpac NAB ServisFirst Bancshares Renasant Corporation Simmons First National Trustmark Corporation First Busey Community Bank System First Mid Bancshares Ameris Bancorp Hancock Whitney First BanCorp Third Coast Bancshares Home Bancshares Byline Bancorp Simmons Bank United Bankshares Peoples United Financial American Express HSBC Bank USA

Base AI Faster	2,500 pages
Pro AI Best accuracy	500 pages

Base AI Faster	10,000 pages
Pro AI Best accuracy	2,000 pages

Base AI Faster	pages
Pro AI Best accuracy	pages

Bank Statement Converter for Medicaid: 5 Years of PDF Statements to Excel

PDF, JPG, PNG, BMP, HEIC, TIFF, MT940

How do you prepare bank statements for a Medicaid look-back?