A Profit and Loss is a list of what the business earned and what it spent over a period, with the difference at the bottom. If you kept no books, every one of those numbers still exists: it is sitting on your bank and card statements. Building the statement from them is tedious rather than hard, and this guide walks through the way a careful bookkeeper would do it by hand, so you know what a good one looks like whether you do it yourself or not.
What you need before you start
Every statement for every account the business used, for every month of the period, as PDFs (or exports) from the bank’s own website. Checking, savings, each credit card, any loan or line of credit. A month missing from one account is a hole in the year, and the first thing a reader will ask about. See which statements you need for the full checklist.
The method, in six steps
1. List every transaction
Open a spreadsheet with four columns: date, description, amount, account. Enter every line from every statement. Money in is positive, money out is negative. Do not skip the small ones; the point of the exercise is that the list is complete, and the next step depends on it.
2. Prove each statement against itself
For each statement, the beginning balance plus everything you entered must equal the ending balance, to the cent. If it does not, a line is missing, duplicated, or has the wrong sign. Find it before going on. This is the single check that separates a Profit and Loss someone can rely on from a guess, and it is the check a lender’s analyst or a tax preparer will perform themselves if you have not.
3. Take out the money that only moved
A payment from checking to your credit card appears twice: as money out of checking and money into the card. It is not an expense; it is a transfer. The same goes for moving money between checking and savings, or paying down a loan’s principal. Mark every pair so neither side lands on the Profit and Loss. Counting transfers as expenses is the most common reason a do-it-yourself statement overstates spending.
4. Take out the money that was yours
Anything you paid yourself, or spent on personal things from the business account, is an owner draw, not a business expense. Anything you put in from your own pocket is an owner contribution, not revenue. Both belong on the Balance Sheet, in equity, and neither belongs on the Profit and Loss. If personal and business spending share one account, this step is where most of the work is; this guide covers it.
5. Put a category on everything that is left
Revenue on one side; expenses by kind on the other: rent, contract labor, advertising, insurance, software, supplies, meals, bank fees, and so on. Use the categories your tax return uses if you can; Schedule C has a line for most of them. Be consistent: the same payee gets the same category every month unless you know why it should not.
6. Total it
Total revenue, total expenses, and the difference is net income. A month-by-month version, twelve columns, is worth the extra effort if someone will read it closely, because it shows where the year turned.
The three places it goes wrong
- Transfers counted as income or expense. The card payment, the savings sweep, the loan principal. Each one inflates both sides of the statement by the same amount and distorts every category it lands in.
- Owner draws counted as expenses. They make the business look less profitable than it was, which is the wrong direction for a loan application and the wrong direction for your own understanding of the year.
- A missing month. Usually a card statement that cuts across the year end, or an account that was forgotten. The Profit and Loss will still add up; it will just be wrong, and nothing on the page will tell you.
What the statement will not show
Built this way, the Profit and Loss is on the cash basis: it records money when it moved, not when it was earned or owed. It will not show invoices customers have not paid, bills you have not paid, inventory on the shelf, or this year’s depreciation. For most sole proprietors and small LLCs that is exactly the basis their tax return uses; a preparer adds the rest. More on cash basis here.
Or let the sorting be done for you
Rekonix Lite does steps one through five from the statements: it reads every transaction, proves each statement against its printed balances, matches transfers, and puts a first category on everything, which you then check and change. You see the whole Profit and Loss and Balance Sheet before paying anything; the download is $49.99. You can try it with a single month’s statement right now, below, with no account.