Turn PDF bank statements into a categorized income statement in Excel or CSV. Upload one month or a full year, totaled into revenue, expenses, and net profit.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
BankXLSX converts a PDF bank statement into a profit and loss statement by reading every transaction, sorting deposits into income and payments into expense categories, then totaling them into revenue, expenses, and net profit you can download as Excel or CSV. Upload a single month or a full year and the tool merges them into one P&L. Because a profit and loss statement reports only income and expenses, transfers between accounts, loan proceeds, and owner draws stay out of it, so your P&L will not match your bank balance line for line, and that is correct.
Three groups need a P&L built from bank statements: businesses that never kept books during the year, owners assembling a loan or lease package, and bookkeepers taking on a client mid-year with nothing but PDFs. In all three cases the source data is the same, a list of dated deposits and payments, and the work is deciding which lines belong on an income statement and which do not. Roughly a fifth of the transactions on a typical business account are transfers, card settlements, loan proceeds or owner money that must be kept off the P&L entirely. Miss them and both revenue and expenses come out inflated.
Creating a P&L from bank statements manually presents several challenges:
Manual processes require significant time investment and are prone to errors, making automated conversion a valuable solution for businesses and accounting professionals.
A Profit & Loss statement requires structured financial data:
Our system intelligently categorizes transactions and structures them into a proper P&L format suitable for professional use.
Automatically categorizes transactions into income and expense categories based on merchant names, transaction descriptions, and patterns.
Structures your data into a proper Profit & Loss statement format with revenue, expenses, and net income calculations.
Bank-level security with OCR accuracy. Your financial data is processed securely and never stored longer than necessary.
Generate monthly or quarterly P&L statements without hiring a bookkeeper. Understand your profitability at a glance.
Track income and business expenses for tax purposes. Generate P&L reports for loan applications or client reporting.
Save hours of manual data entry. Convert client bank statements to P&L format quickly and accurately.
Upload your PDF bank statement from any bank. We support all major banks and credit unions.
Our system extracts all transactions, categorizes them, and structures them into P&L format automatically.
Download your Profit & Loss statement in Excel (XLSX) or CSV format. Ready to use for accounting, taxes, or analysis.
A profit and loss statement (also called an income statement) turns a list of transactions into the one number owners care about: net profit. To build one from a bank statement, you group every deposit and payment by category, total each group, then subtract total expenses from total revenue. Here is the workflow accountants use, and the part BankXLSX does for you.
Upload the PDF and the tool extracts each transaction into a date, description, and amount row. A clean table is the foundation; you cannot total what you cannot read. If you only need the raw spreadsheet first, use the bank statement PDF to Excel converter.
Code every deposit to a revenue line (sales, services, other income) and every payment to an expense line (rent, payroll, software, fees). BankXLSX labels common merchants automatically, and you can categorize the transactions further or save a template so the same rules apply every month. To capture every deductible cost, digitize paper receipts with a receipt OCR tool and fold them into the same expense categories.
Money moved between your own accounts, loan principal you received, and personal draws are not income or expenses; they belong on the balance sheet. Leaving them in inflates both revenue and spending. The converter flags transfers so you can keep them off the P&L.
Sum each category (a SUMIF in Excel, or done for you here), add up total revenue and total expenses, then apply the formula: Total Revenue minus Total Expenses equals Net Profit. If you sell products, subtotal cost of goods sold first so you also see gross profit.
A short month of activity, sorted into the income statement lines a lender or accountant expects:
| Bank statement line | P&L category | Amount |
|---|---|---|
| Customer deposit, Stripe payout | Sales revenue | +8,400.00 |
| Consulting check deposit | Service income | +2,150.00 |
| Office rent ACH | Rent expense | -1,800.00 |
| Gusto payroll | Payroll expense | -3,300.00 |
| Adobe, QuickBooks subscriptions | Software expense | -145.00 |
| Monthly bank service fee | Bank fees | -35.00 |
| Transfer to savings | Excluded (balance sheet) | n/a |
| Net profit | Revenue 10,550 minus expenses 5,280 | +5,270.00 |
Notice the transfer to savings is left out. That is why a profit and loss statement and a bank statement never match line for line, and why an underwriter reviewing a bank statement for loan underwriting reads the categorized P&L, not the raw balance. If your books live in QuickBooks, you can send the same statement straight to a bank statement to QuickBooks converter and run the P&L inside your accounting file, or build the full report with our profit and loss report generator. For the underlying spreadsheet, the bank statement converter handles every bank.
A lender will accept a P&L built from bank statements as long as the deposits reconcile to the statements themselves and the non-revenue money has been stripped out. Underwriters do not take gross deposits at face value. They recalculate what they call true revenue by removing transfers between your own accounts, loan proceeds, owner contributions and refunds, then compare the result against what you claimed. Handing them a P&L that already does that math is the difference between a clean file and three rounds of questions.
Historical financials means your completed prior years, normally a full-year profit and loss statement and balance sheet that tie to the business tax return. Year-to-date means the current partial year through the most recent closed month, so a package assembled in August 2026 would show January through July 2026. When a lender asks for both, they are checking two things: that the business was profitable historically, and that it still is right now. If you only have bank feeds and no accounting file, the year-to-date P&L is exactly what you build from converted statements. Most lenders want the year-to-date figures current to within a quarter and will ask for a refresh if the file sits too long.
Start from total deposits for the period, then subtract every deposit that is not earned revenue. The table below lists what underwriters routinely back out. Work down it in order against your converted spreadsheet, tagging each deposit, and the remainder is your true revenue.
| Deposit type | Counts as revenue? | Why |
|---|---|---|
| Customer payments, card settlements, invoices paid | Yes | Money earned from operations |
| Transfers from your other business or personal accounts | No | Double counts money already banked once |
| Loan proceeds, lines of credit, merchant cash advances | No | Creates a liability, not income |
| Owner capital contributions and funding injections | No | Equity, belongs on the balance sheet |
| Refunds, chargeback reversals, returned payments | No | Reverses an earlier transaction |
| Expense reimbursements from a client | Depends | Revenue only if you also expensed the original cost |
| One-off large deposits with no traceable source | Questioned | Underwriters ask you to document these individually |
Be aware that many business bank statement loan programs then apply an expense factor on top of your figures, commonly treating around half of business account deposits as operating costs unless you supply a P&L or an accountant letter showing your real margin. That default is why submitting an actual categorized profit and loss statement matters: a business running at a 25 percent expense ratio is penalized badly by a 50 percent assumption, and the P&L is what overrides it. If your expense ratio is unusually low, expect to be asked for an expense ratio letter to support it.
A deposit or turnover report is a month-by-month summary of qualifying deposits, net of internal transfers, usually covering the last 3, 6 or 12 months. Build it by converting every monthly statement for the period into one spreadsheet, tagging each deposit against the table above, then totaling qualifying deposits per calendar month. Equipment lessors and short-term lenders often want 3 to 6 months; term lenders and SBA packages typically want 12 to 24 months plus year-to-date financials. Present it with a monthly column so the reviewer can see consistency and seasonality, and keep the source PDFs, since an underwriter will spot-check your totals against the statement summary. Converting a year of statements at once with bulk bank statement conversion keeps the periods aligned and the running totals consistent.
It depends on the product. Merchant cash advances and short-term working capital lenders typically ask for the 3 to 6 most recent months. Equipment leases commonly land in the same range. Bank term loans and SBA packages usually want 12 to 24 months of statements alongside historical financials and a year-to-date P&L. Whatever the number, provide complete statements including every page, since a missing page in the middle of a period is one of the fastest ways to have a file returned. Our converter for lenders is built around exactly this review workflow.
Upload the statement and the tool extracts every transaction, codes deposits as income and payments as expenses, then totals them into revenue, expenses, and net profit. Download the finished P&L in Excel or CSV. Review the categories, exclude transfers and owner draws, and your income statement is ready for taxes or a lender.
A profit and loss statement, also called an income statement, summarizes your revenue, expenses, and net profit over a period such as a month, quarter, or year. Businesses use it to measure profitability, prepare taxes, and support loan applications. It reports only income and expenses, not account balances or transfers.
They are not supposed to match. A P&L counts only income and expense activity, while your bank balance also moves with transfers, loan proceeds, owner draws, and credit card payments that never touch the income statement. A correct P&L leaves those out, so the two totals will always differ.
For taxes, use a full year. Most small businesses build a P&L monthly or quarterly to track profitability. Lenders vary: SBA and bank loans often want one to three years, while alternative lenders may accept 6 to 12 months of statements in place of a formal P&L.
Yes. Self-employed borrowers often qualify with a P&L built from business bank statements, and many lenders run P&L or bank statement loan programs for exactly this. Convert your statements into a categorized P&L so an underwriter can read average monthly income and expenses at a glance.
Yes. Upload several months and the tool merges them into a single profit and loss statement covering the whole period, which is what you need for quarterly, annual, or loan reporting. Categories stay consistent across every statement so the totals add up correctly.
Yes. Files are encrypted in transit, processed securely, and stay in your account until you delete them. We never share or sell your data, so you can prepare a P&L without leaving your finances on a third-party server.
Cancel anytime from your account settings · refund policy
Get started converting bank statements to spreadsheets.
USD
per month
per month
$288 charged today
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
per month
$888 charged today
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
per month
$ charged today
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
Try it once, free: sign up and convert up to 15 pages (5 per statement) with no credit card. The demo does not renew.
