How to turn a spreadsheet into a profit and loss statement
A profit and loss statement sounds like something only an accountant can make. It isn't. If you already have a spreadsheet with your income and expenses in it, you have almost everything you need. A profit and loss statement, also called a P&L or an income statement, is just a tidy summary that answers one question: over a set period of time, did the business make money, and how much?
This guide walks you through building one from a plain spreadsheet, step by step, in about twenty-five minutes. You'll list your income, group your expenses into a handful of categories, total each side, and subtract to find your profit. At the end we'll look at how accounting software builds the same report on its own once your records are in, so you never have to do it by hand again. No jargon, no special training, just the few moves that turn a list of transactions into a number you can actually use.
What a profit and loss statement actually is
Strip away the accounting language and a P&L is three things stacked on top of each other:
- Income. Everything the business earned in the period. For most small businesses this is sales or money from clients. It's sometimes called revenue or turnover.
- Expenses. Everything the business spent to earn that income, grouped into sensible categories so you can see where the money went.
- Profit. Income minus expenses. If it's positive, the business made money. If it's negative, it spent more than it earned, which is a loss. That's the whole point of the report.
Two things make a P&L a P&L rather than just a list. First, it always covers a set period: a month, a quarter, or a year. "Profit" only means something when you say profit over what stretch of time. Second, the expenses are grouped into categories instead of listed one by one, so you can see at a glance that fuel cost you more than materials, or that software subscriptions crept up over the year.
That's it. A P&L is a list of transactions, summarized by category, over a period, with one subtraction at the bottom. If your spreadsheet already records what came in and what went out, the rest of this guide is just reshaping it.
Step 1: list all your income for the period
Start by deciding the period. A calendar year is the most common for tax, but a single month is the easiest to start with and the fastest to check, so if this is your first P&L, do one month.
Now pull together every bit of income that came in during that period. If you keep a separate business bank account, your statement for the month is your income list: every deposit from a client or sale belongs here. From your spreadsheet, copy the income rows that fall inside your chosen dates into one column.
A few rules keep this clean. Use the date the work was invoiced or the sale was made if you're on what's called accrual accounting, or the date the money actually arrived if you're on cash accounting. Most small businesses use cash accounting, which means you count income when it lands in the bank, so go with that unless your accountant has told you otherwise. Don't include money that isn't really income: a loan, a tax refund, or your own money put into the business are not sales and don't belong on this line. Add up the income column. That single total is the top line of your P&L.
Step 2: group your expenses into categories
This is the step that turns a messy expense list into something readable. Instead of forty separate rows, you want a short set of buckets that match how your business spends. Most small businesses can cover everything with a handful:
- Materials and supplies for the things you buy to do the work.
- Vehicle and travel for fuel, mileage, parking, and trips.
- Software and subscriptions for recurring digital costs.
- Advertising and marketing for anything that brings in work.
- Fees, insurance, and professional costs for overheads and your accountant.
- Other for the odd thing that fits nowhere, kept small.
In your spreadsheet, add a column next to each expense and label it with its category. Go down the list once and tag every row. Keep the categories few: six clear buckets tell you more than twenty fussy ones, and the goal is a report you can read in ten seconds, not a perfect chart of accounts. If you carry stock, keep inventory purchases separate from general expenses, since those are a cost of goods sold and behave differently. Once every expense has a category, you're ready to total them.
Step 3: total each side and subtract
Now you total each category and stack the numbers up. For each expense bucket, add the rows tagged with that category. A spreadsheet does this for you: SUMIF adds every amount that matches a category label, so one formula per bucket gives you the category total. Then add the category totals together to get your total expenses for the period.
The last move is the subtraction that makes it a P&L: total income minus total expenses equals profit. If the number is positive, that's your profit for the period. If it's negative, that's a loss, and the categories above it show you where the money went so you can see what to change.
Lay it out top to bottom, income first, then each expense category, then the totals and the profit line. Here's what a simple monthly P&L looks like once it's done:
| Item | Amount |
|---|---|
| Income | $6,200 |
| Materials and supplies | $1,450 |
| Vehicle and travel | $540 |
| Software and subscriptions | $120 |
| Advertising and marketing | $300 |
| Fees, insurance, and professional costs | $390 |
| Total expenses | $2,800 |
| Profit | $3,400 |
That table is a complete profit and loss statement. Anyone, including your accountant or a lender, can read it in seconds and know exactly how the business did that month.
Step 4: check the numbers against your bank
A P&L is only as good as the data underneath it, so before you trust the bottom line, do a quick sanity check. The fastest one: your total income should roughly match the deposits in your business bank account for the period, and your total expenses should roughly match what left it. If the spreadsheet says you earned $6,200 but the bank shows $5,400 of deposits, something is missing or double-counted, and it's worth finding before you rely on the number.
Watch for the usual slips. A transaction recorded in the wrong month throws off both periods. A figure typed by hand with a transposed digit, $540 entered as $450, quietly changes the total. A category left blank means an expense that never got counted. A row copied twice inflates a bucket. None of these announce themselves; the formula keeps working and gives you a confident wrong answer.
This check is the part of doing a P&L by hand that nobody enjoys, because it means going line by line until the spreadsheet and the bank agree. It's also the part most likely to go wrong, which is exactly why the next section matters: software does this matching for you and removes the chance to mistype a number in the first place.
How accounting software builds a P&L for you
Everything you just did by hand, list income, group expenses, total each side, subtract, is exactly what accounting software does automatically. Once your income and expenses are recorded in a tool, the P&L isn't a thing you build; it's a report you open. You pick the period, and the software groups the categories, totals each one, and shows the profit line, recalculated every time a new transaction goes in. There's no manual SUMIF, no risk of a blank category, no typing a number twice.
The work shifts from building the report to just recording transactions, and even that gets lighter. The hardest part of moving off a spreadsheet is usually getting your existing data in, which is where an importer helps. Argo Books reads an Excel or CSV file and maps your columns to the right fields automatically, whatever order they're in and whatever you named them, so the spreadsheet you've been keeping becomes the starting data set rather than something you retype. From there it produces the profit and loss report on its own, for any period you choose.
This matters most at tax time and when you need to show your numbers to someone. A lender or an accountant asking for a P&L is a five-minute job when the software generates it, versus an evening of formulas and bank-checking when it's a spreadsheet. If you're doing a P&L more than a couple of times a year, or you've ever handed one over and worried it was wrong, that's the point where letting software build it pays for itself.
Is a spreadsheet P&L ever good enough?
Often, yes. If you do a P&L once or twice a year, your transaction volume is low, and you keep the spreadsheet current, a hand-built P&L is a perfectly valid report. Plenty of one-person businesses run on exactly this and never need anything more. There's no rule that a real business uses software, and a clean spreadsheet you understand beats a tool you ignore.
The spreadsheet stops being enough when the report gets demanding. If you need a P&L every month to watch cash flow, if your transaction count has climbed into the hundreds, if you're tired of the bank-checking, or if you've started doubting the numbers you produce, the manual version is costing more time and trust than it's worth. That's the moment software earns its place, not before. The goal of this guide isn't to push you toward a tool; it's to make sure you can produce a P&L you trust, by whatever method fits your business. For a lot of people, that's a spreadsheet. For a busy one, it's letting software do the totalling.
Frequently asked questions
There is no difference. Profit and loss statement, income statement, and P&L are three names for the same report. Some countries and some accountants prefer one term over another, but they all mean a summary of income minus expenses over a set period, ending in a profit or loss figure. If someone asks you for any of the three, the report described in this guide is what they want. Don't let the different names make it sound like three separate documents; it's one report with several labels.
Whatever period you need to understand. For tax, it's usually your full fiscal year, because that is what the tax return is based on. For running the business day to day, a monthly P&L is more useful, because it lets you spot a problem while you can still do something about it rather than discovering it a year later. Many small businesses do both: a monthly one to stay on top of things and a yearly one for tax. If this is your first P&L, start with a single month. It's the fastest to build, the easiest to check, and it teaches you the layout before you tackle a whole year.
It depends on which accounting method you use. On cash accounting, which most small businesses use, you only count income when the money actually arrives, so an invoice you have sent but not been paid for does not appear yet. On accrual accounting, you count income when the work is done or the invoice is raised, so unpaid invoices do count. Pick one method and stay consistent, because mixing them gives you a P&L that does not match either your bank or your invoices. If you are unsure which you are on, you are almost certainly on cash accounting, and your accountant can confirm.
This is common and usually means timing, not a mistake. A P&L tells you whether the business earned more than it spent over a period; it does not track when the cash physically moves. You can show a healthy profit while your account is low because money is tied up in unpaid invoices, because you spent on materials up front for work not yet paid, or because you took money out of the business or paid down a loan, neither of which appears as an expense on the P&L. Profit and cash are two different questions. A P&L answers the first; a cash flow view answers the second, and a growing business often needs to watch both.
Argo Books is mentioned, and yes, this is the Argo Books site, so read it with that in mind. But the steps in this guide don't need our tool. You can build a complete, valid profit and loss statement with nothing but the spreadsheet you already have and the four steps above, and for many businesses that is the right answer. We say plainly that a hand-built P&L is fine if your volume is low and you do it a couple of times a year. The tool comes up only because software genuinely removes the totalling and bank-checking once you are doing this often. If you take the method and never look at Argo Books, the guide did its job.