top of page

The Profit First method, created by Mike Michalowicz in his 2014 book of the same name, is a cash management system that flips the traditional accounting formula. Instead of Sales − Expenses = Profit, you allocate every dollar of revenue into separate bank accounts the moment it arrives (Profit, Owner's Pay, Tax, and Operating Expenses), so profit is paid first and operating expenses are forced to fit what's left. The goal is simple: make profit a non-negotiable habit instead of an accidental leftover.


Profit First works because it removes willpower from the equation. When the money isn't in your operating account, you can't spend it on operating.


If you've ever ended a strong revenue month and somehow still had nothing to pay yourself, the issue isn't your income. It's the order of operations. Most business owners pay everyone and everything else first, then hope profit shows up at the end. Profit First reverses that order on purpose.


By the end of this post you'll know exactly how the Profit First framework works, the five accounts it uses, the allocation percentages by revenue tier, who it's a good fit for, the most common mistakes that derail it, and how it compares to other systems including the conscious spending approach I use inside Money Mastery.


Woman business owner planning Profit First allocation system in calm sunlit home office

The Core Idea Behind Profit First


Traditional accounting treats profit as a residual. You earn revenue, you pay your expenses, and whatever is left at the bottom of the page is your profit. The problem is that human behavior treats whatever sits in the operating account as available, so expenses quietly expand to consume every available dollar. Parkinson's Law, applied to small business cash.


Profit First rewrites the formula. Instead of:


Sales − Expenses = Profit


You operate by:


Sales − Profit = Expenses


The mechanism that makes this work isn't the math. It's the separation. Profit, owner pay, and taxes get physically moved into different bank accounts the moment revenue arrives. What's left in the operating account is what the business has to work with, full stop. There's no debate, no willpower test, no end-of-month math. The system enforces itself.


According to data from the U.S. Bureau of Labor Statistics, about 50% of small businesses fail within five years, and SCORE attributes 82% of those failures to poor cash flow management. Profit First was designed specifically to address that cash flow gap, and it has become one of the most widely adopted small business finance frameworks in North America since its release.


The Five Profit First Accounts


The full Profit First system uses five business bank accounts, each with a clear job. Some owners run a lighter version with three. Here's what each account does.


1. Income


Every dollar of revenue lands here first. Nothing is paid from this account. It exists only to receive money and then distribute it on allocation day (typically the 10th and 25th of each month). Think of it as a holding tank.


2. Profit


A percentage of every income deposit moves into this account. Quarterly, you take 50% of the Profit account balance as a profit distribution (the reward), and the other 50% stays as a reserve. This is the account that makes the system worth doing.


3. Owner's Pay


The percentage allocated here funds your regular paycheck. For most solo operators and small teams, this is twice-monthly transfers from Owner's Pay into your personal checking account. Owner pay is not the same as profit, and conflating the two is one of the most common errors. (Our guide on how to pay yourself as a business owner goes deep on this distinction.)


4. Tax


A percentage moves here every time revenue arrives. This account exists for one reason: to make quarterly estimated tax payments without panic. When the IRS sends the bill, the money is already waiting. (This is educational, not tax advice. Consult a CPA or Enrolled Agent for your specific situation.)


5. Operating Expenses (OpEx)


Whatever percentage is left after Profit, Owner's Pay, and Tax allocations funds the actual operation of the business. Software, contractors, marketing, supplies, rent, everything. The constraint is the entire point. If OpEx can't cover the bill, the bill is too big.


Two of these accounts (Profit and Tax) ideally live at a different bank from your main operating bank. The friction of having to log into a separate institution to access them is a feature, not an inconvenience. It prevents the casual raid.


The Profit First Method Explained Allocation Percentages


Michalowicz's original book includes a table of suggested allocation percentages organized by annual revenue tier. The percentages assume a service-based business with relatively low cost of goods. Product-heavy businesses adjust based on their cost structure.


Here are the target allocations as published in Profit First. These are starting points, not laws.


Annual Revenue

Profit

Owner's Pay

Tax

OpEx

$0 – $250K

5%

50%

15%

30%

$250K – $500K

10%

35%

15%

40%

$500K – $1M

15%

20%

15%

50%

$1M – $5M

10%

10%

15%

65%

$5M – $10M

15%

5%

15%

65%

$10M – $50M

20%

0%

15%

65%


Two things matter more than the exact numbers. First, the percentages assume revenue, not profit. They apply to every dollar of top-line income that hits the Income account. Second, you don't start at the target. You start at your current allocation (whatever it actually is right now) and shift one or two percentage points per quarter until you reach the target. Trying to jump straight to the goal almost always breaks the system.


If your current reality is that 95% of revenue goes to OpEx and 5% goes to owner pay, your first move isn't to jump to 30% OpEx. It's to move profit from 0% to 1% next quarter. Slowly. Sustainably.


Modern Profit First allocation dashboard showing four account splits for small business revenue

How a Typical Profit First Month Actually Flows


Here's what the system looks like in practice for a service-based business owner doing about $180,000 in annual revenue, using the first-tier allocations.


A $5,000 client payment lands in the Income account on June 8. Nothing happens immediately. The money sits. the profit first method explained


On June 10 (the first of two monthly allocation days), the owner logs in and distributes everything in Income according to the percentages: 5% ($250) to Profit, 50% ($2,500) to Owner's Pay, 15% ($750) to Tax, and 30% ($1,500) to OpEx.


Between June 10 and June 25, additional client payments land in Income and wait. On June 25, the second allocation runs, and everything in Income gets distributed using the same percentages.


On the 1st and 15th, Owner's Pay transfers a set amount into the owner's personal checking. On the 15th of the quarter-end month, the Tax account pays the IRS estimated quarterly payment. At the end of each quarter, the owner takes 50% of the Profit balance as a profit distribution (yes, a celebration, ideally something tangible, not a debt payment) and leaves the other 50% as a building reserve.


OpEx is the only account being actively spent down throughout the month. When OpEx is tight, the business makes a decision: cut an expense, raise prices, or wait. What it does not do is silently pull from Profit or Tax. Those are off-limits by structure, not by discipline.


Who Profit First Works Best For


Profit First isn't universally the right fit. It works exceptionally well for some businesses and creates unnecessary friction for others.


It works best for service-based businesses with relatively predictable revenue (consultants, agencies, coaches, designers, accountants), product businesses with healthy margins, and owners who have struggled with the "I made money but I have nothing to show for it" pattern. The structural constraint is the medicine.


It works less well for very early-stage businesses where revenue is too low or too erratic to slice into five accounts (you'll spend more time managing transfers than running the business), product businesses with thin margins and high cost of goods (the OpEx percentage breaks the math), businesses with very irregular revenue cycles, and owners who are already disciplined cash managers and don't need the structural enforcement.


If your revenue is wildly irregular, you may need to combine Profit First with a different income-smoothing approach. Our guide on how to budget with irregular income walks through the most common adjustments.


The prerequisite for any version of Profit First is clean separation between business and personal accounts. If those are still mixed, the allocation system won't work. Start there first.


Common Profit First Mistakes That Sabotage the System


The framework is simple. The places where it breaks are predictable.


Starting at the target percentages instead of your current reality. If you jump from 0% profit to 5% profit overnight, the OpEx account will run dry within a month and you'll raid Profit to cover it, which trains you to ignore the system. Always start one or two percentage points above where you actually are.


Skipping the bank separation. Keeping all five "accounts" as line items in one bank account or one spreadsheet defeats the purpose. The whole mechanism relies on physical separation creating friction. Sub-accounts inside the same bank are acceptable. A single account with mental categories is not.


Treating Owner's Pay and Profit as the same thing. Owner's Pay is your salary, the compensation for the work you do in the business. Profit is the return on owning the asset. Two different things. Conflating them means you never actually feel profitable.


Raiding the Tax account. The Tax account is not a slush fund for slow months. The IRS does not care that June was slow. Touching this account is the single fastest way to create a tax-time crisis. (For more on this, our post on credit card payments and what isn't actually an expense covers a related accounting trap.)


Allocating on a random schedule. The 10th and 25th aren't arbitrary. Twice-monthly allocations create a rhythm that twice-yearly check-ins never will. Pick two days. Put them on the calendar. Don't move them.


Forgetting to take the quarterly profit distribution. Half the point of the system is that profit becomes tangible. If the Profit account just keeps growing and you never actually take the distribution, you've recreated the original problem.


Profit First vs. Conscious Spending vs. Traditional Budgeting


Profit First is one of three major frameworks small business owners typically encounter. They aren't mutually exclusive, and they solve different problems.


Approach

What It Optimizes For

Best For

Main Limitation

Traditional Budgeting

Predicting and constraining spend

Stable income, predictable expenses

Breaks the moment reality deviates from forecast

Profit First

Forcing profit and tax discipline

Service businesses, owners who underpay themselves

Rigid for irregular revenue, requires multiple accounts

Conscious Spending (Money Mastery)

Visibility, decision-making, full-life alignment

Owners who want clarity across business and personal

Requires a weekly review habit


Conscious spending, which is the framework I use inside Money Mastery, doesn't replace Profit First. For some clients, we layer the two: Profit First handles the structural cash flow at the bank level, and the Money Mastery conscious spending system handles the visibility, weekly review rhythm, and decision-making across both business and personal finances. The accounts enforce the discipline. The system shows you what the discipline is producing.


The reason I lean toward conscious spending as the default is that Profit First is excellent at one thing (paying yourself and saving for tax) but doesn't tell you which clients are profitable, which expenses are creeping up, or how your business numbers connect to your personal life. Those are the questions most women business owners are actually trying to answer.


How Money Mastery Helps You Run Profit First (or Outgrow It)


Inside Money Mastery, you can run a full Profit First setup if that's the structure that fits your business, and the system tracks each account, and quarterly distribution inside the same weekly fifteen-minute review you'd be doing anyway. You don't have to choose between Profit First and clarity. You can have both.


For owners who try Profit First and find it too rigid for their revenue patterns, the conscious spending framework inside Money Mastery achieves the same outcome (profit paid first, taxes set aside, owner pay protected) without requiring five separate bank accounts or twice-monthly allocation days. The weekly review surfaces the same signals the account separation would have surfaced, just through visibility instead of physical friction.


Download the free Money Mastery Net Worth Tracker at https://moneymastery-system.com/free. It puts your personal and business accounts side by side across sixty account types and twelve tabs, and it stays yours.



How to Actually Get Started With Profit First This Month


If you've read this far and Profit First sounds like the right fit, here's the smallest viable starting point. Don't overhaul everything this weekend.


Open one new account this week: a separate Profit account at a different bank than your operating bank. Just one. Don't open all five yet.


On your next deposit, transfer 1% to the Profit account. One percent. Not five. Not ten. One. The goal of month one is to prove the system works at all, not to hit the target allocation.


At the end of the quarter, take 50% of the Profit account as a distribution. Spend it on something tangible that has nothing to do with the business. The point of this exercise is to feel profit as real money, not just a number.


The next quarter, add a Tax account and start allocating 10 to 15% there. The quarter after that, add Owner's Pay. By the end of a year, you have the full system running, and you got there without breaking anything in the process.


Slow is the speed that lasts.


Your Next Step


Profit First is a structural answer to a behavioral problem. It works because it removes the moment of decision that derails most business owners. But the structure only matters if you build it in the right order, at the right pace, with the right honesty about where you're actually starting.


Pick one account. Pick one percentage. Pick one allocation day. Start there.


Get the free Net Worth Tracker here: https://moneymastery-system.com/free


Woman at sunlit window holding coffee mug embodying calm from Profit First financial structure

Frequently Asked Questions


What is the Profit First method in simple terms?


Profit First is a cash management system created by Mike Michalowicz that pays profit, owner pay, and tax from every dollar of revenue before paying operating expenses. You set up multiple bank accounts (typically five) and allocate every income deposit into them by percentage on fixed days each month. What's left in the operating account is what the business has to spend. The structural separation removes willpower from the equation, which is why it works for owners who have repeatedly tried and failed to "save more" or "spend less."


How does Profit First work for small businesses?


Every dollar of revenue lands in an Income account first. On two allocation days each month (typically the 10th and 25th), the owner distributes that balance by percentage into Profit, Owner's Pay, Tax, and Operating Expenses accounts. Quarterly, half of the Profit account is taken as a distribution. The system forces operating expenses to fit what's left after profit, owner pay, and tax are set aside, which reverses the usual pattern of profit being whatever happens to remain at the end of the month.



For businesses earning under $250,000 in annual revenue, the suggested starting allocations are 5% Profit, 50% Owner's Pay, 15% Tax, and 30% Operating Expenses. Percentages shift as revenue grows: Owner's Pay decreases and Profit and OpEx generally increase. These are starting points, not laws, and they assume a service-based business. Product businesses with high cost of goods need to adjust. Most importantly, you don't start at the target percentages. You start where you actually are and shift one or two points per quarter.


Is Profit First worth it for a new business?


Profit First works best for established businesses with somewhat predictable revenue. For very new businesses (under a year, or with highly irregular income), the system can create more friction than benefit because revenue is too low or too erratic to meaningfully split into five accounts. Newer owners are often better served by starting with basic separation (business vs. personal), a simple monthly review habit, and a single profit savings account. Once revenue stabilizes, Profit First becomes a natural next step.


How is Profit First different from conscious spending or Money Mastery?


Profit First enforces discipline through bank account separation. Conscious spending, which is the framework inside Money Mastery, achieves similar outcomes (profit prioritized, tax set aside, owner pay protected) through visibility and a weekly review habit rather than multiple bank accounts. Profit First is rigid by design, which is its strength. Conscious spending is flexible by design, making it a better fit for owners with irregular revenue or those who want a single system that covers both business and personal finances. The two approaches can be layered, and many Money Mastery clients do exactly that.


If you would like to talk it through with someone, Donna Roggio is a business coach with fifteen years of experience helping women sort this out, and a first call with her is free.


Related Posts


Neither wins outright. Put fixed bills that carry a late fee or credit risk on autopay: mortgage or rent, loans, insurance and your credit card minimum. Pay variable bills, and anything you might cancel, by hand, because paying is the moment you actually see the amount. Most people do best with a mix, sorted bill by bill.


Self-employed woman reviewing autopay versus manual bill pay options on phone and notebook

The cost of autopay is attention. In a 2022 C+R Research survey, people guessed they spent about $86 a month on subscriptions. When they added them up, the real figure was $219, a gap of $133 a month, or roughly $1,600 a year. Most of those people had their subscriptions on autopay.


Autopay vs manual pay: the pros and cons


Autopay protects you from forgetting. Manual pay protects you from not noticing. Which one matters more depends on the bill.


Factor

Autopay

Manual pay

Late fees

Almost never, as long as the money is there

Possible if you forget

Credit score

Protects payment history, the biggest factor in your FICO score (35%)

Equally good if you never miss

Seeing price rises

Easy to miss: the bill pays itself

You see the amount every time

Overdraft risk

Higher if the date doesn't match when your income lands

You choose the day

Time and mental load

Low

Higher

Discounts

Some lenders cut your rate for autopay

None

Stopping a charge

You have to act to stop it

You simply don't pay


A few details that matter:


  • Late isn't the same as "on your credit report." Miss a due date and you'll usually pay a late fee. Creditors generally don't report the late payment to the credit bureaus until it's at least 30 days overdue. Autopay's real job is to make sure you never get anywhere near that. Payment history is 35% of a FICO score (myFICO), and here's more on how payment history works in your score.

  • The autopay discount is real for some loans. Federal student loans give 0.25% off the interest rate for autopay. Check StudentAid.gov for any current promotions on your own loan. Some private lenders and insurers offer smaller autopay discounts too.

  • Manual pay's real advantage is timing. If a $400 bill is due on the 5th but your biggest client always pays on the 10th, paying by hand on the 8th keeps you out of overdraft. Changing the due date with the biller does the same job, as long as they'll let you.


Tech data visualization of bill payment methods compared routing autopay versus manual bill pay

Bill pay, autopay and recurring payments: what's the difference?


The difference is who starts the payment. With autopay, you give the company permission to pull the money from your account or card on a set date. With your bank's bill pay, you tell your own bank to push a payment to the company, once or on a schedule. Both can be automatic, but only bill pay keeps the controls in your hands.


The terms you'll see:


  • Autopay / automatic payment / auto-draft / direct debit. The company takes the payment. "Draft payment" and "auto-draft" are older names for the same thing. You set it up on the company's website, and to change it you usually go back to the company.

  • Bank bill pay. You send the payment from your bank's website or app. You can make each payment by hand or schedule it to repeat. To stop it, you change it in your bank's bill pay, without needing to call the company.

  • Recurring payment. A general term for any charge that repeats. It's often used for a subscription billed to your card. It's still the company charging you, so it behaves like autopay.


For a fixed bill, scheduled bank bill pay gives you most of the convenience of autopay and keeps you in charge. The trade-off is timing: a bank bill-pay payment can take a few business days to arrive, so schedule it ahead of the due date. (The CFPB explains the difference the same way.)


The four groups of bills, and how to decide for each


Every recurring bill fits one of four groups, and each group has a sensible default.


Group

Examples

Default

Why

Fixed essential

Mortgage, rent, auto loan, student loan, fixed insurance premium

Autopay

The amount doesn't change, and missing it costs the most

Variable essential

Electric, gas, water, phone with overages

Manual, or autopay plus read every statement

The amount itself tells you something

Subscription

Streaming, software, gym, apps

Manual, or autopay with a quarterly review

Highest risk of price creep and of being forgotten

Discretionary recurring

Wine club, meal kit, monthly box

Manual

It should be re-decided, not paid on autopilot



Credit cards get their own hybrid: set autopay for the minimum payment, then pay the full balance by hand each month. The autopay means you can never be late. The manual payment makes you look at what you spent and keeps you from paying interest. Here's why the minimum alone keeps you stuck.


If a bill doesn't fit neatly, ask three questions:


  1. Does the amount change month to month? Fixed amounts are safe to automate because there's nothing to notice. A variable bill is worth seeing, since a water bill that doubles is a leak and an electric bill that spikes may be failing equipment.

  2. What does missing it cost? A late mortgage or card payment costs money and, past 30 days, can mark your credit file. Automate those first. A subscription that lapses costs you nothing but the service.

  3. Would you notice if the price went up? If not, move it to manual, or put a reminder in your calendar to check the amount twice a year.


The overdraft risk when your income is irregular


Autopay assumes your money arrives on a schedule. If yours doesn't (a $4,000 invoice paid on the 3rd, nothing until the 22nd, then $8,000 on the 24th), an autopay that lands on the wrong day can overdraw an account that would have been fine three days later.


Overdraft fees are smaller than they used to be, but they haven't gone away. Bankrate's 2025 survey put the average overdraft fee at about $27, and most accounts it looked at still charge one. A few large banks have dropped overdraft fees altogether. Across banks with more than $1 billion in assets, consumers still paid about $5.8 billion in overdraft and NSF fees in 2023, according to the CFPB.


The fix is to line up every autopay date with a day you know the money will be there. Many billers, especially card issuers, utilities and insurers, will let you choose or change your due date if you ask. If mid-month is when client payments reliably land, move your autopays to the 20th. And keep a small buffer in the bill-paying account so one late client doesn't set off a chain of fees. A weekly 15-minute money check catches the timing problems early. For the bigger picture of budgeting on irregular income, start here.


Manual vs automatic withdrawal: can you stop an autopay, and is it safe?


Yes, you can stop an automatic withdrawal even if the company won't cooperate. Under federal rules (Regulation E), you can tell your bank to stop a preauthorized debit as long as you give notice at least three business days before it's scheduled. Stopping the payment doesn't cancel the bill or the contract, so cancel with the company too.


What that looks like in practice:


  • Cancel at the source first. Turn off autopay on the company's site or ask them in writing.

  • Then tell your bank if you're worried they'll charge anyway. You can do it by phone, in person or in writing, at least three business days ahead. Your bank may ask for written confirmation, may charge a stop-payment fee, and the order may only last a few months.

  • Watch the next statement to confirm the charge stopped.


Is autopay safe? The money moves securely. The risk is in where it comes from. Withdrawals pulled straight from your checking account take real cash out the moment they happen, and protection for unauthorized debit transactions depends on how quickly you report them. On a credit card, federal law caps your liability for unauthorized charges at $50 (FTC), and a disputed charge doesn't empty your checking account while it's sorted out. That's why many people put subscriptions and other recurring charges on a credit card they pay in full, and keep autopay from checking for a short list of essentials.


The hybrid system that works


It takes about an hour to set up.


  1. List every recurring charge from your last three months of statements, personal and business. If you want a running list, here's the simplest way to track recurring bills.

  2. Sort each one into the four groups above.

  3. Autopay the fixed essentials only. Mortgage or rent, loans, fixed insurance.

  4. Credit cards: autopay the minimum, pay the full balance by hand.

  5. Line up every autopay date with your income. If you're self-employed, this step isn't optional.

  6. Review on a schedule. Do subscriptions once a quarter, and use your monthly financial review to glance at variable bills. Once a year, go through every autopay on every account and card and ask three questions. Am I still using this? Is the price what I expect? Is it charging the right account? Don't forget yearly bills, which need a monthly set-aside, not a surprise.


Confident business owner completing a quarterly audit of bill payment methods compared

Bills drift over time, and that's normal. A gym from two moves ago or a business tool you stopped needing are just what a review is for. Autopay vs manual pay isn't a debate to win. It's a decision to make per bill, on purpose.


Autopay vs manual bill pay for business accounts


For a business account, put fixed obligations on autopay and keep anything variable or negotiable on manual pay. The difference from a personal account is timing: business cash comes in on your clients' schedule, so the question isn't only "is this bill predictable?" but "will the money be there on the day it's taken?"


Three business bills belong on autopay almost every time. Loan and financing payments, because a missed one can reach your credit file. Insurance, because a lapse can leave you uncovered at the worst moment. And the software your work depends on, because losing access mid-project costs more than the subscription.


Three belong on manual pay. Anything with a variable amount, so you see the figure before it leaves. Anything on vendor terms you could renegotiate, because paying automatically removes the moment you'd have asked. And anything you're still deciding whether to keep.


There's a bookkeeping reason to care too. Automatic payments leave without a moment of attention, so they're the charges most likely to sit uncategorized or in the wrong place for months. If business and personal money share an account, the fix starts with separating business and personal expenses in one account.


Start free with La Soglia


If you'd like company while you sort your bills and keep an eye on them, the Money Mastery System gives you five connected workbooks, Clarity AI, and the Money Mastery Collective, a community of people doing the same work beside you. Start free with La Soglia.


Frequently asked questions


Does autopay help your credit score?


Autopay doesn't raise your score directly. It protects it. Payment history is the biggest part of a FICO score (35%), and autopay makes sure you never fall 30 days behind, which is roughly when creditors report a late payment. If you reliably pay by hand on time, your score is the same either way.


Should I autopay my credit card in full or just the minimum?


For most people, autopay the minimum and pay the rest by hand. The minimum autopay means you're never late. The manual payment makes you look at the statement and lets you pay in full to avoid interest. Autopaying the full balance works too, if you still read the statement before it's taken.


Is it better to put autopay on a credit card or a checking account?


For subscriptions and other recurring charges, a credit card you pay in full is usually safer. Your liability for unauthorized credit card charges is capped at $50, and a disputed charge doesn't drain your checking account. Loans and rent often have to come from checking, so keep a small buffer there.


How do I stop autopay from causing an overdraft?


Line up each autopay date with when money reliably lands in that account. Many billers let you change your due date if you ask. Keep a small buffer in the bill-paying account, and move variable bills to manual pay so a big one can't arrive before your income does.


How do I cancel an automatic payment?


Cancel with the company first, either online or in writing. If you think they'll charge anyway, tell your bank to stop the payment at least three business days before it's due. A stop-payment order stops the money, not the debt, so make sure the account or service is actually closed.


How often should I review my autopay charges?


Review subscriptions quarterly and do a full autopay review once a year, checking every account, card and digital wallet. For each charge, ask whether you still use it, whether the price is what you expected, and whether it's charging the right account.

To create a live profit and loss statement in Google Sheets, keep every transaction on its own tab with a date, a category and an amount. Then build the P&L with SUMIFS formulas that total each category for each month. Put categories down the rows and months across the columns. Add a transaction and the statement updates by itself.


Woman business owner reviewing profit and loss spreadsheet from the Money Mastery System on laptop in sunlit home office

A P&L is arithmetic: income minus expenses. Everything else is formatting. Setup takes about twenty minutes, and after that, each month is mostly categorizing.


What a profit and loss statement tells you


A P&L, also called an income statement, answers one question for a period, usually a month: did the business make money? Income goes at the top, then what it cost to deliver (if you sell products), then operating expenses, and net profit or loss at the bottom. The layout is the same for a one-chair studio and a large company. Only the size of the numbers changes. If you run a salon, here's how to read a salon P&L and the six numbers to check.


Why Google Sheets is a good place to start


It's free, it works on your phone, and you can share it with your bookkeeper or CPA without exporting anything. The formulas you learn here work the same in Excel. And because you categorize every transaction yourself, you actually look at your numbers, which is the whole point. If choosing categories is where you get stuck, start with these 20 business expense categories for a service business.


Before you build


Have three things ready:


  1. A month of transactions from every business account and card, downloaded as CSV files. Export the same report each month so the columns always line up.

  2. A rough category list. You'll refine it, so don't agonize.

  3. Business and personal money kept apart. If they're mixed, the P&L will be wrong before you start, so separate business and personal finances first.


How to build a live P&L in Google Sheets, step by step


You'll make three tabs: Categories, Transactions and P&L. You only ever type into the first two. The P&L fills itself in.


Step 1: The Categories tab


In column A, list every category, one per row, starting in A2. If you'd like a starting structure, here's how to build a simple chart of accounts. In column B, give each category a type: Income, Cost of sales, Expense or Exclude. "Exclude" is for money that moves but isn't profit or loss: transfers between accounts, credit card payments, owner's draws and loan principal. These stay off the P&L entirely.


Step 2: The Transactions tab


Set up these columns, with headers in row 1:


A

B

C

D

E

Date

Description

Amount

Account

Category


Enter money in as a positive number and money out as a negative number, which is how most bank exports already show it. Then make Category a dropdown, so names always match exactly. Select column E, choose Data → Data validation → Add rule, set the criteria to Dropdown (from a range), and enter Categories!A2:A as the range.


Step 3: The P&L layout


On the P&L tab:


  • Header: A1 is your business name. A2 is Profit and Loss Statement. A3 says Year, and in B3 you type the year (for example, 2026).

  • Months: row 5 holds the months. In B5 enter =DATE($B$3,1,1). In C5 enter =EDATE(B5,1) and copy it right to M5. Select B5:M5, choose Format → Number → Custom number format, and type mmm so they show Jan, Feb, Mar. In N5 type Year total.

  • Rows: down column A, put your Income categories in rows 7 to 10 and Total income in row 11. Put Cost of sales categories in rows 12 to 15, Total cost of sales in row 16 and Gross profit in row 17. Put Expense categories in rows 20 to 35, Total expenses in row 36 and Net profit (loss) in row 38. Add rows if you need more. Each category name must match the Categories tab exactly.


Step 4: The one formula that makes it live


In the first income row, cell B7, paste:


=SUMIFS(Transactions!$C:$C, Transactions!$E:$E, $A7, Transactions!$A:$A, ">="&B$5, Transactions!$A:$A, "<"&EDATE(B$5,1))


It reads: add up the amounts where the category matches this row and the date falls in this column's month. Copy it across to M7 and down through every income row. The dollar signs keep the references pointing the right way as you copy.


For cost of sales and expense rows, put a minus sign in front, because spending comes in as negative numbers and you want it to show as a positive cost. For the first expense row, B20, that's:


=-SUMIFS(Transactions!$C:$C, Transactions!$E:$E, $A20, Transactions!$A:$A, ">="&B$5, Transactions!$A:$A, "<"&EDATE(B$5,1))


Refunds come in as positive numbers and reduce the cost automatically.


Step 5: Totals and net profit


  • Total income (row 11): =SUM(B7:B10)

  • Total cost of sales (row 16): =SUM(B12:B15)

  • Gross profit (row 17): =B11-B16

  • Total expenses (row 36): =SUM(B20:B35)

  • Net profit (loss) (row 38): =B17-B36, which is gross profit minus total expenses. If you have no cost of sales, it's simply total income minus total expenses.

  • Year total (column N): =SUM(B7:M7) on each row.


You can also add a Profit margin row under net profit with =IFERROR(B38/B11,""). Here's what a healthy profit margin looks like for a service business.


Step 6: Add a safety check and format


Below net profit, add an Uncategorized row with this formula in column B, copied across to M:


=SUMIFS(Transactions!$C:$C, Transactions!$E:$E, "", Transactions!$A:$A, ">="&B$5, Transactions!$A:$A, "<"&EDATE(B$5,1))


If it isn't zero, some transactions still need a category, and the month isn't finished. Then format the numbers as currency (Format → Number → Currency). Color net profit with Format → Conditional formatting: green if greater than 0, red if less than 0. To keep the months visible as you scroll, click any cell in row 5 and choose View → Freeze → Up to row 5.


That's a live P&L. From now on, the only monthly job is adding transactions and picking their categories.


Should months go in rows or columns?


On the P&L, put categories down the rows and months across the columns. That's how financial statements are read, and it lets you compare January to June along a single row. On the Transactions tab, use one row per transaction and never a column per month. A single long list is what SUMIFS needs to work.


Two practical reasons this layout wins. Adding a new category means adding one row, not reshaping the sheet. And a long Transactions list can grow for years without breaking any formula, whereas a sheet with a column per month has to be rebuilt every January.


What the finished P&L looks like


Here's an example for a small service business. Only June (column G) is shown filled in. Every other month column fills in the same way as transactions are added.


Row

A

B

…

G

1

Your Business Name




2

Profit and Loss Statement




3

Year

2026



5

Category

Jan

…

Jun

6

INCOME




7

Client retainers



$8,400

8

Project work



$3,200

9

Course sales



$950

11

Total income



$12,550

19

EXPENSES




20

Software and subscriptions



$487

21

Contractors



$2,100

22

Marketing and advertising



$640

23

Professional fees



$350

24

Education



$197

25

Office supplies



$84

26

Travel



$312

27

Meals (business)



$76

28

Bank and merchant fees



$148

29

Insurance



$220

36

Total expenses



$4,614

38

Net profit (loss)



$7,936


There are no cost-of-sales rows in this example, so net profit is total income minus total expenses. The layout is meant to be boring. Boring is what makes a financial statement easy to read.


How to feed the P&L from your bank's CSV export


Download the month's CSV from each account, paste the rows under the existing ones on the Transactions tab, and fill in the Category column for the new lines. The P&L reads the whole tab, so it updates the moment the last category is filled. Google Sheets can't connect to your bank on its own. The CSV export is the bridge.


Three things break this setup, and all three are easy to prevent:


  1. Signs flipped. Some banks and most card statements export spending as positive numbers. If yours does, flip them before pasting: put the amounts in a spare column, use =-C2 beside them, then paste the results back as values. Otherwise your expenses will show up as income. If your bank exports separate Debit and Credit columns, make the Amount column =Credit-Debit.

  2. Dates that aren't really dates. If imported dates sit on the left of the cell, Sheets is reading them as text and SUMIFS will skip them. Select the column and choose Format → Number → Date. If that doesn't fix it, check that File → Settings → Locale matches your bank's date format.

  3. Columns that move. Paste the same export every month, in the same column order. If a bank changes its format, rearrange the columns before pasting, not after.


Also, a credit card payment will show up in your checking export. Give it a category with the Exclude type, such as Transfer. The purchases are already on the card's export, and counting the payment too would count them twice. And if one charge covers several categories, like a warehouse-store run, split it across categories before you move on.


Where DIY P&Ls go wrong


Counting credit card payments as expenses. The expense happened when you used the card. The payment just moves money between accounts. Categorize it as a transfer.


Mixing personal spending into business categories. Your gym membership isn't professional development. A grocery run after a client meeting isn't a business meal.


Recording owner pay the wrong way. It depends on how your business is set up. If you're a sole proprietor or single-member LLC, money you take out for yourself is an owner's draw. It isn't an expense, so give it the Exclude type (IRS Publication 334). If your business is taxed as an S corporation and you pay yourself a salary through payroll, that salary is a wage expense and belongs on the P&L. Distributions on top of it don't.


Meals at full value, deducted at half. Record the whole business meal on the P&L. Generally only 50% of a business meal is deductible (IRS Publication 463), and your tax preparer applies that limit when the return is done.


Changing category names. If June says "Marketing," July says "Advertising" and August says "Promo," you can't compare months. The dropdown from Step 2 prevents this.


Not checking against the bank. Each month, compare the Transactions tab with your statement's total money in and money out. If they don't tie, the P&L isn't finished.


This is general education, not tax advice. A CPA or Enrolled Agent can advise on your situation.


How to use your P&L once you have it


  • Run it on the same day each month. The first business day works for most people.

  • Compare three months side by side. That's built in now that months run across the columns. Trends and seasonality show up in a way one month never shows. Here's how to read a profit and loss statement line by line.

  • Ask one question a month. Pick the one line that surprised you and look into it. Don't overhaul everything at once.

  • Share it with your accountant more than once a year. A quarterly look gives them time to suggest changes before the year closes, rather than after.


Woman at sunlit window holding coffee mug after completing monthly profit and loss review

You don't need the perfect spreadsheet tonight. You need a working one this week. The first imperfect P&L teaches you more than the tenth perfect one you keep meaning to start.


When the spreadsheet stops being enough


A P&L tells you that you made $7,936 in June. It doesn't tell you which clients or services produced it, which costs are creeping up, or how June compares with your personal finances, which is where most owner decisions actually get made. After a few months, many owners find the numbers are clear but the decisions still aren't. That's the point to add analysis, not more formulas.


A finished profit and loss report on screen

When you're ready for that next step, the Money Mastery System gives you five connected workbooks, Clarity AI, and the Money Mastery Collective, a community of people doing the same work beside you. Start free with La Soglia.


If you would rather allocate income into accounts than read it off a report afterwards, the Profit First method, explained, works from the same categories.


Once the P&L runs itself, the other number worth a monthly look is your net worth, checked monthly.


Frequently asked questions


What formula do I use for net profit in Google Sheets?


Net profit is one subtraction: total income minus total expenses. If total income is in B11 and total expenses in B36, the formula is =B11-B36. If you sell products, subtract cost of sales first to get gross profit, then subtract expenses. Format the cell as currency and make it bold.


Can Google Sheets pull my bank transactions automatically?


Not on its own. Google Sheets has no built-in bank feed, so transactions arrive by downloading a CSV export from your bank and pasting it into the sheet. Some paid add-on services connect banks to Sheets. Once your P&L reads a Transactions tab, the only recurring work is categorizing new rows.


What categories should a small business P&L include?


Start with the categories that match how you actually spend: software, contractors, marketing, professional fees, education, supplies, travel, business meals, bank and merchant fees, insurance and "other." Add cost of sales if you sell products. Consistency matters more than the exact list, so use the same categories every month.


What's the difference between a P&L and a cash flow statement?


A P&L shows whether the business made money over a period: income minus expenses. A cash flow statement shows when money actually moved in and out, including things that aren't on the P&L, like loan payments and owner's draws. A business can show a profit and still run short of cash. Most small businesses keep their books on a cash basis, and here's cash vs accrual in plain English.


Should I record owner pay on my P&L?


It depends on your business structure. For a sole proprietor or single-member LLC, what you take out for yourself is an owner's draw. It's not an expense and stays off the P&L. If your business is taxed as an S corporation and pays you a salary through payroll, that salary is a wage expense and belongs on the P&L.


Is Google Sheets good enough for a real business P&L?


For many small service businesses, yes, especially in the early years or if you want to understand your numbers from the ground up. It's free and easy to share. The limits show up when you want profit by client or service, automatic categorization, or reports you can hand off without maintaining formulas yourself.

bottom of page