Home / Guides

How to Do a Profit and Loss Statement, From Trial Balance to Finished

By Michael · August 28, 2026 · 10 min read

To do a profit and loss statement you close the period, reconcile every cash and card account, run a trial balance, map each revenue and expense account to a statement line, and then total four sections: revenue less cost of goods sold gives gross profit, less operating expenses gives operating income, plus or minus other income and expense gives net income before tax.

The arithmetic is the easy part and takes about ten minutes. The work is everything before it, which is why a statement produced from unreconciled books is a hypothesis rather than a statement. This page walks one month through all seven steps with the numbers shown. For the concepts, see profit and loss statement; for a blank form, the P&L template.

What are the seven steps?

  1. Close the period so the numbers stop moving.
  2. Reconcile every bank, card and merchant account.
  3. Run the trial balance and confirm it balances.
  4. Map each account to a statement line.
  5. Total the four sections.
  6. Tie the result to the balance sheet.
  7. Review it before you believe it.

Our worked company is Halcyon Fabrication LLC, month ended January 31, 2026. January is the first month of its fiscal year, so month and year to date are the same figures.

Step 1: close the period so the numbers stop moving

Set a closing date so nothing new can be posted into January. Without it, the statement you print on February 8 and the one you print on February 20 will differ, and nobody will know why.

Before you lock it, finish the entries that belong to January: supplier invoices received in February for January work, payroll accrued across the month end, depreciation, and any prepaid cost being spread. Under accrual accounting these belong in the month the activity happened rather than the month the paperwork arrived. Which basis you are on changes what qualifies, and IRS Publication 538, Accounting Periods and Methods sets out the difference. Our longer treatment is in cash vs accrual accounting.

Step 2: reconcile every bank, card and merchant account

Every account with a statement gets reconciled against it for exactly the same dates, and the difference has to be zero. An unreconciled cash account means nothing above it has been tested against a document your software did not generate, and the items missed most often are merchant processing fees and automatic payments: real expenses that never reach the statement if nobody enters them.

The bank reconciliation example works a full month through, with a copyable template alongside it. IRS Publication 583 puts it plainly: make the statement, the checkbook and the books agree, every month.

Step 3: run the trial balance

The trial balance lists every account with a balance and proves total debits equal total credits. It is the input to the statement, and if it does not balance nothing downstream is worth producing.

Halcyon Fabrication LLC, trial balance, January 31, 2026

Account Debit Credit
1010 Cash $58,420
1200 Accounts receivable $142,300
1250 Inventory $46,900
1500 Equipment $188,000
1510 Accumulated depreciation $62,400
2010 Accounts payable $88,600
2020 Credit card $9,240
2200 Payroll liabilities $7,180
2300 Sales tax payable $5,300
2500 Equipment loan $96,000
3010 Member contributions $40,000
3020 Member draws $36,000
3900 Retained earnings $147,000
4010 Product revenue $214,500
4020 Installation revenue $38,000
4900 Returns and allowances $2,100
5010 Materials $96,800
5020 Direct labor $58,400
5030 Subcontractors $14,200
5040 Freight in $3,900
6010 Salaries and wages $31,500
6020 Payroll taxes $2,950
6100 Rent $7,200
6110 Utilities $1,340
6200 Software subscriptions $1,180
6300 Advertising $4,600
6400 Professional fees $1,900
6500 Insurance $2,450
6600 Office supplies $620
6700 Travel and meals $880
6800 Depreciation $3,100
6900 Bank and merchant fees $2,240
7010 Interest income $180
8010 Interest expense $1,420
Total $708,400 $708,400

Both columns come to $708,400, so the ledger is internally consistent. Note what that does not prove. Every entry had a matching debit and credit, but nothing here shows anything was coded to the right account, and a transaction posted entirely to the wrong account balances perfectly.

Step 4: map each account to a statement line

The profit and loss statement uses only the income and expense accounts. In the numbering convention above, that is everything from 4000 up. The 1000s, 2000s and 3000s are balance sheet accounts and none of them appear.

Range Statement section
4000–4899 Revenue
4900–4999 Contra revenue, deducted from revenue
5000–5999 Cost of goods sold
6000–6999 Operating expenses
7000–8999 Other income and expense
9000–9999 Income tax

Three things to check while you map, because each one silently breaks a subtotal.

Member draws are not an expense. Account 3020, $36,000, is a distribution against equity and stays on the balance sheet. Booking it as an expense would understate profit by $36,000 and produce a statement that disagrees with the return.

Contra revenue is deducted, not added. Returns and allowances of $2,100 sits in the debit column and reduces revenue.

Direct costs belong above the gross profit line. Freight in, at $3,900, is part of what the goods cost. Put it in operating expenses and gross margin stops meaning anything, which matters because gross margin is the number worth watching.

Step 5: total the four sections

Halcyon Fabrication LLC, profit and loss statement, month ended January 31, 2026

Line Amount
Product revenue $214,500
Installation revenue $38,000
Less: returns and allowances ($2,100)
Net revenue $250,400
Materials $96,800
Direct labor $58,400
Subcontractors $14,200
Freight in $3,900
Total cost of goods sold $173,300
Gross profit $77,100
Salaries and wages $31,500
Payroll taxes $2,950
Rent $7,200
Utilities $1,340
Software subscriptions $1,180
Advertising $4,600
Professional fees $1,900
Insurance $2,450
Office supplies $620
Travel and meals $880
Depreciation $3,100
Bank and merchant fees $2,240
Total operating expenses $59,960
Operating income $17,140
Interest income $180
Interest expense ($1,420)
Total other income and (expense) ($1,240)
Net income $15,900

Gross margin is 30.8% ($77,100 ÷ $250,400), operating margin is 6.8%, and net margin is 6.3%.

There is no income tax line because Halcyon is an LLC taxed as a partnership, so income passes through to the members' personal returns rather than being paid by the business. A C corporation would carry a tax line immediately above net income. State franchise and gross receipts taxes usually sit in operating expenses either way, and where a specific tax belongs depends on your entity and your state, so confirm it with your preparer rather than with this page.

Step 6: tie it to the balance sheet

This is the step that catches a mapping error, and almost nobody does it by hand once software is producing both statements. Do it once so you know what the check is.

Amount
Total assets ($58,420 + $142,300 + $46,900 + $188,000 − $62,400) $373,220
Total liabilities ($88,600 + $9,240 + $7,180 + $5,300 + $96,000) $206,320
Equity: contributions $40,000, draws ($36,000), retained earnings $147,000, net income $15,900 $166,900
Liabilities plus equity $373,220

Assets equal liabilities plus equity, and the net income figure that makes it work is the same $15,900 the profit and loss statement produced. If those two numbers disagree, something on the income statement was classified as a balance sheet item or the reverse, and draws booked as an expense is the usual culprit.

Step 7: review it before you believe it

A finished statement is not a correct statement. Five questions, in order:

  1. Is anything in a suspense account? "Ask my accountant", "Uncategorized income", "Uncategorized expense". A P&L with a balance sitting in one of those is not finished, and every ratio above it is unreliable.
  2. Does any line read zero that should not? A missing rent charge or a missing insurance payment is much harder to see than a wrong one, because nothing draws your eye to a line that is not there.
  3. What moved more than about 10% against last month? Write down why for the two largest movers. If you cannot answer, that is the thing to investigate, not the bottom line.
  4. Did gross margin move? A drift from 30.8% to 27% over a quarter is a real problem that a rising revenue line hides completely.
  5. Would you show this to a lender? If the answer is no, name the reason. The reason is your next task.

How long should this take?

For a business the size of the example, with clean books and no surprises, steps 1 through 6 are a half day in the first few days after month end, and step 7 is thirty minutes belonging to the owner rather than the bookkeeper. The realistic target is the statement in your hands within a week or two of month end. An annual profit and loss statement produced in March for the year that ended in December is a compliance document, and by the time it shows a problem you have lived with it for a year.

What if you are doing it in a spreadsheet?

The steps do not change, and two get harder. Nothing enforces that debits equal credits, so add the total row and check it monthly. And nothing stops you editing a prior period, so keep each closed month as its own locked sheet.

If you are building the format from scratch, copy the P&L template rather than inventing line names, and read the Instructions for Schedule C once for the expense categories a US small business return expects. Matching your accounts to them loosely makes tax season mechanical instead of interpretive. The SBA's guide to managing your finances is a reasonable orientation if this is your first set of statements.

What to do next

Run the seven steps in order on your last closed month and stop at the first one you cannot complete honestly. That is your actual problem, and for most small businesses it is step 2.

If steps 1 to 6 are not happening monthly, that is the gap to close before anything else. Of the 27,281 US accounting firms we profile, 2,991 advertise financial statement preparation and 2,170 of those also claim CPA credentials. The distinction matters when the statement has an outside audience: monthly management reporting is different work from a compilation, review or audit, and only the latter group can perform the attest engagements a lender or investor may ask for. Browse bookkeeping services for the monthly close, and ask three questions of anyone you shortlist: what day of the month statements arrive, whether the P&L comes with a balance sheet, and whether a walkthrough is included or billed separately.

Method

Firm counts come from the AccountingNearYou dataset as of 28 August 2026: 27,281 US accounting firms profiled from their own public websites, of which 2,991 advertise financial statement preparation and 2,170 both advertise it and claim CPA credentials. A firm is counted as offering a service when it names it on the pages we crawled, so these are counts of what firms advertise rather than of everything they do, and a CPA claim is what the firm states about itself rather than a license we have verified for every entry.

Halcyon Fabrication LLC is illustrative. The figures are constructed to demonstrate the method, they are not benchmarks, and no margin above should be read as typical for any industry. This is general information about a reporting process, not accounting or tax advice. Entity treatment, which taxes belong where on the statement, and your eligibility for cash basis all depend on your structure and your state, so confirm them with a CPA.