How to make a P&L from bank statements
You do not need accounting software to produce a profit and loss statement. You need every transaction for the period, sorted into revenue and expense categories, with the totals tying back to the statements themselves — and, critically, with the deposits that were never sales taken out first. The bank statement is a complete record of what moved; turning it into a P&L is a question of reading and classifying, not of bookkeeping software.
What you need before you start
Every statement for every account the business used, covering the whole period, with no month missing. A gap is not a rounding error — a month you cannot account for is a hole in the revenue line, and whoever reads the statement will find it.
The format does not matter much: PDF, a scan, a CSV export, a spreadsheet, or a photograph of a paper statement all contain the same transactions. What matters is that the period is complete and that you know which account each file belongs to.
The mistake that ruins most of them
Treating every deposit as income. It is the single most common error in an owner-prepared P&L, and it is the one a lender or a preparer spots fastest, because it makes the business look larger than its tax return says it is.
Money arrives in a business bank account for many reasons that are not sales. An owner puts personal money in. A loan or a line of credit advances funds. A transfer moves cash between the business's own accounts. A supplier refunds an overcharge. A payment processor deposits a batch net of fees, so the deposit is smaller than the sales it represents. Each of these needs a different treatment, and none of them is revenue.
The same applies in reverse on the way out. An owner draw is not an expense. A loan principal repayment is not an expense — only the interest portion is. Money leaving the account is not automatically a cost of running the business.
What the finished statement has to show
Monthly columns rather than a single annual total. One lump sum for a year tells a reader nothing about seasonality, and the request behind most P&Ls is really a request to see the shape of the year.
Notes saying how it was prepared and on what basis. Cash basis — built from what actually moved through the bank — is normally what an owner-prepared statement is, and saying so plainly is better than leaving the reader to work it out.
A preparer line with a name on it, and the word unaudited somewhere visible. Neither of these weakens the document. They describe what it is, and a statement that quietly omits them invites the question of what else it is not saying.
Doing it by hand, or not
By hand this is a spreadsheet, a category list, and an evening per month of transactions — slow, but entirely possible, and for a small single-account business it is often the right answer.
It stops being the right answer when there are several accounts, a card processor netting fees, or twelve months to reconstruct at once. That is the point at which people get a bookkeeping quote, discover it runs into the thousands and takes weeks, and start looking for a third option.
Whatever produces it, the test is the same: can you explain every number to the person who asked for the statement. A figure you cannot defend is worse than no statement at all.
Upload a statement and read your own numbers before you decide. Start from your bank statements.
Questions people ask
Can you make a profit and loss statement from bank statements alone?
Yes, on a cash basis. The bank statement records every amount that moved, so a P&L can be built by classifying each transaction into revenue and expense categories and reconciling the totals to the statement itself. The work is in separating deposits that are not sales — owner contributions, transfers between accounts, loan proceeds, refunds — from actual revenue.
Which deposits should not be counted as income?
Owner contributions, transfers between the business's own accounts, loan and line-of-credit advances, and supplier refunds are not revenue. Payment-processor deposits are usually net of fees, so the deposit is smaller than the sales it represents and needs grossing up rather than recording as-is.
Does a P&L from bank statements need to say it is unaudited?
An owner-prepared statement should be marked unaudited and should say how it was prepared. It is a plain description rather than a disclaimer of quality, and omitting it tends to raise more questions from the reader than including it does.
Sources
- IRS — Recordkeeping for small business — that supporting records are what substantiate the figures on a return
- IRS — Publication 583, Starting a Business and Keeping Records — cash basis recordkeeping and what a business's books are expected to show
- IRS — About Schedule C (Form 1040), Profit or Loss from Business — the revenue and expense lines a sole proprietor's profit and loss maps onto
ONE CLICK P&L generates draft financial statements, not accounting, tax, or legal advice. Review the output with a licensed professional before you send it anywhere.