How to Sort Small Business Expenses Into Categories

By Cedar & Ledger

Sorting expenses into categories turns a pile of receipts into numbers you can use: how much went to supplies this month, whether shipping is creeping up, and what to hand your tax preparer at the end of the year. This guide covers how to pick a short category list, set up one row per receipt, handle unclear and mixed purchases, total each category for the month, and keep the receipts.

The shop, vendors and dollar amounts below are made-up examples, not typical costs. Which expenses are deductible, and how, depends on your situation and the tax rules, so ask a tax professional or check the IRS website (IRS Publication 334, Tax Guide for Small Business, is a plain starting point). This is general information, not tax, legal or financial advice.

Quick checklist

• ☐ Pick 8-12 plain expense categories
• ☐ Set up one row per receipt: date, vendor, amount, category, note
• ☐ Write a one-line rule for any vendor that could go in two places
• ☐ Log only the business part of mixed personal/business purchases
• ☐ Total each category once a month
• ☐ Keep every receipt where you can find it
• ☐ Check what lands in "Other" and fix the list if needed

The steps below walk through each one.

Step 1: Pick 8-12 plain categories

Start with a short list in plain words. Too few and everything ends up in "Other"; too many and you spend time deciding between two that mean the same thing. Example list for a made-up candle shop:

• Supplies & materials
• Shipping & postage
• Bank & payment fees
• Software & subscriptions
• Advertising
• Phone & internet
• Equipment
• Office supplies
• Vehicle & mileage
• Professional fees
• Other expense

That's 11. Your list should match what your business actually buys. A cleaning business might add "Cleaning products", a freelancer might not need "Shipping" at all. The category names on IRS business tax forms (for example, Schedule C) are a reasonable place to look for wording, and using similar names can make tax time easier, but your tax preparer can tell you what matters for you.

Step 2: One row per receipt

Make one row for each purchase with five columns:

One receipt, one row, one category. If a single receipt covers two categories (say, supplies and a box of printer paper), you can split it into two rows that add up to the receipt total.

Step 3: Write a rule for the unclear ones

Some purchases could go in two places. Instead of deciding again every month, write a one-line rule and stick to it. Examples:

• "Boxes and tape go in Shipping & postage, not Office supplies."
• "Monthly app plans go in Software & subscriptions, even if they're for design."
• "Selling-platform fees go in Bank & payment fees."

Keep the rules on a note at the top of the sheet. Being consistent matters more than picking the perfect category, because it's what makes this month comparable to last month.

Step 4: Handle mixed personal and business purchases

If one receipt has both personal and business items, log only the business part and say so in the note. Example (made-up numbers): a $54.00 craft store receipt has $38.00 of jars for the shop and $16.00 of personal items. Log $38.00 in Supplies & materials with the note "business part of a $54.00 receipt", and leave the $16.00 out.

If the whole receipt went on the business card or account, also note the personal part so the bank balance still matches your records; many people treat it as money they took out of the business or pay the business back. For things you use for both (a phone plan, a car), how to split the cost can have tax rules, so ask a tax professional how to work out the business share. Keeping business and personal money in separate accounts makes this much rarer; Separate Business and Personal Money for a Side Hustle walks through it.

Step 5: Total each category once a month

At the end of the month, add up each category. In a spreadsheet, a formula like =SUMIF(D:D,"Shipping & postage",C:C) adds every amount in column C whose category in column D is "Shipping & postage". Make one line per category and check that the category totals add up to the total of every row.

Example month (made-up numbers, 10 receipts in October):

The other five categories had no receipts this month, which is normal. Next month, put the two months side by side: if shipping goes from $54.00 to $90.00 while sales stay flat, that's worth a look. To turn these totals into a full month's profit, subtract them from income; Simple Profit and Loss Statement for a Small Business shows how.

Step 6: Keep the receipts

The spreadsheet is your summary; the receipt is the proof. Keep paper receipts in one envelope or folder per month, or snap a photo and save it in a folder named by month. Email receipts can go in one email folder. In the Note column, write where each one lives ("photo Oct folder", "email"). For a full setup, see How to Organize Business Receipts (Simple System).

How long to keep records depends on the situation. The IRS explains record keeping in Publication 583, Starting a Business and Keeping Records; check it or ask a tax professional rather than guessing.

Step 7: Check what lands in "Other"

"Other" should stay small. If it's a big share of the month, or the same kind of thing keeps landing there, give it its own category and move the old rows over so past months stay comparable. Also check for rows with no category at all; an empty category is easy to miss when you add things up.

A good time for this is a short weekly or monthly bookkeeping session. Weekly Bookkeeping Routine for a Small Business (20 Minutes) has a simple routine.

Common snags

• Too many categories. If you're unsure where something goes more than once a week, merge two of them.
• Changing categories mid-year. If you rename or split one, update the old rows too.
• Logging the receipt total for a mixed purchase. Log only the business part.
• Missing small charges. App plans, platform fees and bank fees are easy to forget; check the statement, not just your receipt folder.
• Treating "category" as "deductible". Sorting an expense into a category doesn't mean it's deductible. Ask a tax professional.

Renting out a property instead? How to Track Rental Property Income and Expenses has categories for landlords.

A simple way to track it

A plain spreadsheet with the five columns above works fine. If you'd like a head start, the Small Business Bookkeeping Spreadsheet ($12, Excel and Google Sheets) has a Setup tab with up to 20 expense categories you can rename (it starts with 18), a Transactions tab with category dropdowns and a "deductible?" column you fill in yourself, and a Profit & Loss tab that totals each category by month and warns you if a row is missing a category (details). You enter every expense yourself; it doesn't connect to your bank, and it's a record-keeping tool, not accounting software or tax advice.

Honest note: I make this template and sell it under Cedar & Ledger, so I'd earn from a purchase. General information only, not tax, legal or financial advice.

Try the free break-even calculator (profit per sale and sales needed) →

Related template: read about the small business bookkeeping template

See all Cedar & Ledger templates