Free profit & loss template
A self-calculating P&L spreadsheet built by a licensed CPA: type your transactions on one tab and the monthly P&L builds itself, with the excluded-items section most free templates leave out.
- One Excel file, free, no email required. Works in Excel, Google Sheets, and Numbers.
- Type transactions on one tab; twelve monthly P&L columns calculate themselves with formulas.
- Category dropdowns use a real chart of accounts: income, cost of goods sold, and 18 operating expense categories.
- A dedicated section keeps transfers, card payments, owner draws, and loan principal out of profit, which is where most homemade P&Ls go wrong.
- Twelve industry versions below preload examples for your trade.
- If typing a year of statements sounds like a weekend lost: RapidPnL does the same job from your statement PDFs in minutes, reconciled to the penny, for $49.
Excel format (.xlsx), about 25 KB. Imports cleanly into Google Sheets.
Download free P&L templateWhat's inside
Three tabs. Start here explains the method in plain words. Transactions is where you type or paste each line from your bank and card statements: date, description, a category picked from a dropdown, and the signed amount. P&L is the finished statement: set your first month in one cell and twelve monthly columns fill themselves from your transactions, with income, cost of goods sold, gross profit, operating expenses, and net profit each computed by formula. You never type a number on the P&L tab.
The category list is the same chart of accounts RapidPnL uses for paid reports: three income categories, cost of goods sold, and eighteen operating expense categories from advertising to vehicle and fuel. It also includes the categories that do NOT belong on a P&L: transfers between accounts, credit card payments, owner draws and contributions, and loan principal. Those get their own excluded section at the bottom of the statement, so the cash is tracked but profit stays honest.
How to use it
- 01Download the monthly PDF statements for every business account you want covered: checking, savings, and any business credit cards.
- 02On the Transactions tab, enter each statement line: money in as a positive number, money out as a negative number, exactly as printed.
- 03Pick the closest category from the dropdown on each row. When two could fit, pick one and stay consistent from month to month.
- 04Set your first month on the P&L tab (one date cell). The twelve columns and every subtotal update themselves.
- 05Check your work: for each account and month, the beginning balance plus everything you entered must equal the printed ending balance. If it does not, a line is missing, duplicated, or mistyped.
When a template is enough, and when it is not
A template is a fine answer when you have one account, a light month of activity, and time to be careful. The math is simple; the work is data entry and judgment. It stops being a fine answer when the volume grows: a year of statements across a checking account and a card is commonly 1,500 to 3,000 lines, each needing a category, and a single missed or duplicated deposit quietly corrupts the totals with nothing to warn you.
That reconciliation check in step five is the honest test. If you do it and the numbers tie, your template P&L is credible. If you skip it, what you have is an estimate. RapidPnL exists for the people who need the credible version without the weekend: it reads the statement PDFs, categorizes every line, runs that exact balance check on every statement, and flags anything uncertain for review instead of guessing. $49 covers 3 statement-months, and if a statement cannot be reconciled you get a full refund.
Industry versions
Same engine, preloaded with example transactions and category guidance for your trade.
- Cleaning business template →
- Contracting business template →
- Restaurant template →
- Food truck template →
- E-commerce business template →
- Landscaping business template →
- Trucking business template →
- Salon template →
- Consulting practice template →
- Handyman business template →
- Photography business template →
- Auto repair shop template →
Upload the PDFs and get a management-use profit & loss in minutes, with every statement reconciled to the penny. $49 for 3 months, then $9 each additional month. Full refund if we can't reconcile.
The free statement is read, categorized, and reconciled on screen before you pay anything. One per person; no card required.
Common questions
Yes. No email address, no signup, no watermark. Download the file and use it. It is the same category structure RapidPnL uses in its paid reports, so if you ever switch from typing transactions to uploading statements, everything carries over.
Yes. In Google Sheets, choose File, then Import, then Upload, and pick the downloaded file. The month columns, category dropdowns, and formulas carry over. Numbers, Excel on the web, and LibreOffice open it too.
The template uses signed amounts: money in is positive, money out is negative, exactly as your bank statement shows them. That convention lets every total be a plain sum, makes refunds behave correctly in both directions, and matches how accountants check work against statements.
Transfers between your own accounts, credit card payments from checking, owner draws and contributions, and loan principal are real cash movements but not income or expenses. Counting them is the most common DIY error and it inflates or deflates profit. The template gives them their own section so they are tracked without touching the P&L.
The template is you doing the data entry: reading each statement line, picking a category, typing the amount. RapidPnL reads the statement PDFs for you, categorizes every transaction, proves each statement reconciles to the penny, and delivers the finished P&L in minutes for $49 covering 3 statement-months.
Written by a licensed CPA. This guide is general information, not tax, legal, accounting, or financial advice, and does not create a professional relationship. Lender requirements and bank websites change; confirm specifics with your lender and financial institution. RapidPnL reports are cash-basis summaries generated from customer-provided data for management use only, not audited or CPA-reviewed. © 2026 RapidPnL LLC.