Spreading a borrower starts with clean numbers, and borrower bank statements arrive as PDFs. Upload one here and download structured Excel or CSV with deposits, withdrawals, and running balances your analysts can spread. The data prep, not the decision. Start free, no credit card.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Spreading is the process of moving a borrower financial statements, tax returns, and bank statements into a standardized template so a credit analyst can calculate cash flow, ratios, and trends. The slowest part is getting transaction data out of PDF bank statements, which analysts often retype by hand. BankXLSX is the data-prep step: upload a borrower PDF and download a clean Excel or CSV with dated, signed deposit and withdrawal lines and running balances, ready to paste into your spread template or your spreading software. It does not make the credit decision.
Financial statement and tax return spreading has decent tooling. Bank statement data is where analysts still lose hours, because it starts as an unstructured PDF and has to be normalized before any ratio can be computed.
Transaction data lives in a PDF, so an analyst keys deposits and balances into the spread by hand. It is slow and every typed figure is a chance to introduce an error the review has to catch.
A single commercial deal can carry a year or two of statements across operating, payroll, and personal accounts for several entities. The keying multiplies fast.
Layouts differ by bank, some statements are scanned images, and multi-column running-balance formats do not paste cleanly into a template. There is no single shape to work from.
Before spreading, dates have to be consistent, credits and debits signed correctly, transfers flagged so they are not double counted, and balances tied out. Raw text does none of that.
Enterprise spreading tools auto-spread tax returns and financials well, but the raw transaction data from bank statements still has to be keyed or imported. That ingestion is the gap.
A mistyped deposit total flows into average monthly income, DSCR, and the recommendation. Catching it late means re-spreading, which is exactly what slows a decision.
Upload the borrower PDF and the converter reads the transaction table rather than the page layout, then writes a clean Excel or CSV your analyst can spread without retyping a line.
Every deposit lands on its own dated row, so an analyst can sum monthly deposits and average them for the qualifying-income calculation in seconds.
Money in and money out are unambiguous, so cash-flow math and a running total behave correctly in the spread.
Balances carry through so an analyst can read average daily balance, minimum balance, and any negative days directly.
Convert a stack of twelve or twenty-four monthly PDFs across several accounts into continuous, consistent rows.
Clean, stable columns drop into your own spread workbook, or import into your spreading platform, without reshaping.
256-bit encryption in transit and you can delete borrower files whenever you want.
No software to install and no credit card to start.
Drop in the statement, or a whole stack of monthly PDFs, and download the result as Excel or CSV.
Tip: Convert every account in the file.
Check the deposits, flag transfers between the borrower own accounts so they are not double counted, and confirm the balances tie out.
Tip: Exclude one-off and non-operating deposits.
Paste the clean data into your spread template or import it into your spreading software, then compute income, DSCR, and the metrics your policy requires.
Tip: The decision stays with your analyst.
Anyone who spreads a borrower to make a credit decision, at institutions where bank statement data still gets keyed by hand before the analysis can start.
Turn a stack of borrower PDFs into rows you can spread, instead of keying deposits into a template line by line.
Speed up C&I and small-business underwriting where the deposit history is the core of the analysis.
Prepare deposit and balance data for cash-flow and DSCR analysis on 7(a) and conventional business loans.
Get clean daily balances, deposit counts, and NSF visibility fast on short-turnaround files.
Last updated July 2026
Spreading is the process by which a credit analyst moves data from a borrower financial statements, tax returns, and bank statements into a bank standardized template, so that cash flow, ratios, and period-over-period trends can be calculated and compared. It is the foundation of commercial credit analysis. Financial statement spreading and tax return spreading are the classic forms; bank statement spreading is the narrower task of extracting transaction-level data from deposit accounts, used heavily when tax returns understate a borrower true operating cash.
A spreading analyst extracts financial data from a borrower documents and enters it into the standardized spread that credit analysis runs on. That means pulling several years of financial statements and tax returns plus the recent bank statements, normalizing the figures, and keying them into the template so ratios and cash flow can be computed. It is widely described as one of the most time-consuming steps in underwriting, and the bank statement portion is the piece that resists automation because it starts as a PDF.
When spreading a business borrower, analysts commonly read the average monthly deposits, the consistency and trend of those deposits, the count and size of individual deposits with any large or one-off amounts flagged, the number of NSF and overdraft events, days with a negative balance, the average daily balance, and the ending balance each period. They also separate operating deposits from transfers and non-operating inflows so revenue is not double counted. Every one of those figures is easier to compute from structured rows than from a PDF.
| Metric | What it measures | Read from |
|---|---|---|
| Average monthly deposits | Operating cash flow into the business | Summed, dated deposit rows |
| Average daily balance | Liquidity cushion | Running balance column |
| NSF and overdraft count | Cash-flow stress, a common red flag | Flagged fee and negative lines |
| Negative days | How often the account ran dry | Daily ending balances |
| Large or unusual deposits | Non-recurring inflows to exclude | Sorted deposit amounts |
No, and it is not meant to. Enterprise spreading platforms such as Moody CreditLens, Baker Hill, Abrigo, and nCino run the analysis, risk rating, and portfolio work. They auto-spread tax returns and financial statements well, but the raw transaction data from bank statements still has to be keyed or imported. BankXLSX sits upstream of all of them: it converts the borrower PDF into clean, structured rows so that data goes into your platform, or your own spread workbook, without retyping. Think of it as the data-prep step, not the decisioning engine.
For a self-employed or business borrower, qualifying income is typically the sum of eligible deposits over 12 or 24 months, reduced by an expense factor, then divided by the number of months, and adjusted for ownership share. A common default expense factor is around 50 percent on a business account, and a CPA letter or a profit and loss statement can substitute a lower documented figure. The how much you can borrow guide works the math, and the expense ratio letter post covers documenting a lower factor. These figures are program specific, not a single federal standard.
Converting the statement is the first step; the analysis is yours. Once the rows are clean, the transaction categorization page helps separate operating deposits from transfers, running balance extraction preserves the daily balances the spread needs, and the bank statement converter for lenders covers the wider underwriting workflow. For the borrower question of what gets checked and why, see what underwriters look for in bank statements and how lenders verify bank statements. Starting from just the PDF? Use the bank statement converter.
A full credit file is more than bank statements. Pay stubs, tax returns, and financial statements all have to be read and entered too, which teams handling volume do by extracting the data from those documents automatically rather than keying each one.
Spreading is moving a borrower financial data, including bank statements, into a standardized template so a credit analyst can compute cash flow, ratios, and trends. Bank statement spreading is the specific task of extracting transaction-level data such as deposits, balances, and NSF events from deposit accounts, which is used heavily when tax returns understate a borrower true operating cash.
A spreading analyst extracts financial data from a borrower statements and tax returns and enters it into the bank standardized spread for credit analysis. It involves pulling several years of financials plus recent bank statements, normalizing the numbers, and keying them in. The bank statement portion is the slowest part because it starts as a PDF.
No. BankXLSX is the data-prep step. It converts a borrower PDF bank statement into clean, structured Excel or CSV rows so your analysts can spread and underwrite. All analysis, risk rating, and the lending decision stay with your team and your policy.
No. Those enterprise platforms run the analysis and risk rating and auto-spread tax returns and financials. They still need the raw bank statement data keyed or imported. BankXLSX sits upstream and produces that clean data, so it complements a spreading platform rather than replacing it.
Commonly the average monthly deposits and their trend, the count and size of deposits with large one-off amounts flagged, NSF and overdraft counts, negative days, average daily balance, and ending balances. They also separate operating deposits from transfers so revenue is not double counted. Structured rows make each of these fast to compute.
Qualifying income is typically eligible deposits over 12 or 24 months, reduced by an expense factor often around 50 percent on a business account, divided by the number of months, and adjusted for ownership share. A CPA expense ratio letter or a profit and loss statement can substitute a lower documented factor. Exact figures are program specific.
Yes. Upload a stack of 12 or 24 monthly PDFs across operating, payroll, and personal accounts and download continuous, consistently formatted rows. That covers a full commercial review period without keying each statement by hand.
Uploads use 256-bit encryption in transit, you can delete borrower files at any time, and the data is not resold or shared. The converter runs in your browser with nothing to install.
Keep the daily balances the spread needs.
Summaries and totals from a statement.
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 |
