How to track business expenses: 8 steps and a spreadsheet you can build today

The short answer: to track business expenses, open a separate account or card, save a record of every purchase and log each one the same week with its date, vendor, amount, category and payment method. Once a month, match the log to your bank statement.

• Setup: about an hour
• Weekly: 10 to 15 minutes to log receipts
• Monthly: about 30 minutes to reconcile and total categories
• Match your categories to your tax form
• Next step: Plan it with the Business Income & Expense Tracker ($7.99).

To track business expenses, open a separate bank account or card for the business, save a receipt or record for every purchase, and log each expense the same week with its date, vendor, amount, category and payment method. Once a month, match your log against your bank statement and total each category. That's the whole system: one place where money goes out, one log, and one monthly check. A simple spreadsheet handles it for most side hustles, freelancers and small shops.

This guide walks through the setup in eight steps, shows you how to make a business expense spreadsheet from a blank file (with the exact columns and formulas), and covers the weekly and monthly routine that keeps it from piling up before tax season.

Why tracking business expenses matters

Every dollar you spend to run your business is a dollar you may be able to deduct, but only if you can prove it. The IRS says you can use any recordkeeping system suited to your business as long as it clearly shows your income and expenses. Your supporting documents should identify the payee, the amount paid, proof of payment, the date and a description that shows the purchase was for the business.

Good tracking also answers the everyday questions:

• Did the business actually make money last month, or did it just feel busy?
• Which costs are creeping up, like software subscriptions or shipping?
• How much should you set aside for taxes?
• Can you afford that new piece of equipment?

Without a log, you're guessing. With one, you're deciding.

How to track business expenses in 8 steps

Step 1: Separate business and personal money

Open a business checking account, or at least a dedicated card, and run every business purchase through it. The IRS notes that for most small businesses, the business checking account is the main source of entries in the books. When personal groceries and business supplies share one card, every statement becomes a sorting project.

If you're a sole proprietor just starting out, a second personal checking account used only for the business works too. The point is one clean stream of business transactions.

Step 2: Choose your tracking method

You have three realistic options. Pick the simplest one that fits how much activity you have.

For most one-person businesses, a spreadsheet is the sweet spot. It costs little, it's private, and you can see exactly how every total is calculated.

Step 3: Set up your expense categories

Categories turn a long list of purchases into numbers you can use. If you file Schedule C as a sole proprietor or single-member LLC, use category names that match the expense lines on that form, so tax time is a matter of copying totals.

Keep the list short. Ten to fifteen categories is plenty. Our small business tax deduction checklist explains what usually counts in each one.

Step 4: Decide how you'll capture receipts

Pick one capture habit and use it every time:

• Phone photos: Snap the receipt right after you pay, and save it to a folder named by year and month.
• Email folder: Forward digital receipts to one email folder, such as "Business Receipts 2027."
• Paper envelope: Drop paper receipts into a monthly envelope until you log them.

The IRS suggests organizing supporting documents by year and type of income or expense. Our guide on how to organize receipts walks through a simple folder system for both paper and digital copies.

Step 5: Log every expense the same week

Set a 15-minute appointment once a week, the same day each time. Open your receipts folder and bank activity, and add each business expense to your log. Weekly logging is short enough that you still remember what each charge was for.

Each entry needs:

1. Date
2. Vendor (who you paid)
3. Description (what it was and why the business needed it)
4. Category
5. Amount
6. Payment method (business card, business checking, cash)
7. Receipt saved? (yes or no)

Step 6: Track mileage separately

If you drive for the business, keep a mileage log with the date, starting point, destination, business purpose and miles for each trip. Mileage is easy to forget and hard to rebuild later. Our mileage log for taxes guide shows exactly what to record and how the deduction is figured.

Step 7: Reconcile once a month

Once a month, put your bank and card statements next to your log and check them line by line.

• Every business charge on the statement should be in the log.
• Every log entry should match a statement line or a cash receipt.
• Personal charges that slipped onto the business card get marked and moved out.

Then total each category for the month and subtract total expenses from total income. That's your monthly profit, the number that tells you how the business is really doing.

Step 8: Set aside money for taxes

Self-employed people don't have an employer withholding tax from their pay. The IRS explains that if you're in business for yourself, you generally need to make estimated tax payments, which cover income tax and self-employment tax. The year is split into four payment periods, each with its own due date.

A simple habit: each month, after you reconcile, move a set percentage of that month's profit into a separate savings account for taxes. Use last year's return or your tax preparer's advice to choose the percentage. When a quarterly payment is due, the money is already there. Our guide on how to pay quarterly taxes covers the due dates and payment options.

How to make a business expense spreadsheet

You can build a basic business expense spreadsheet in Excel or Google Sheets in about 30 minutes. Here's how.

1. Create three tabs

• Transactions: every expense and income entry, one row each.
• Categories: your category list, used for the dropdown.
• Summary: monthly totals by category and profit.

2. Add the column headers on the Transactions tab

Freeze the header row so it stays visible as the list grows. In Excel, use View > Freeze Panes. In Google Sheets, use View > Freeze > 1 row.

3. Add a category dropdown

Type your categories in column A of the Categories tab. Then select column E on the Transactions tab and add data validation with a list from that range. In Excel, it's Data > Data Validation > List. In Google Sheets, it's Data > Data validation > Dropdown (from a range). A dropdown keeps "Supplies," "supplies" and "Supply" from becoming three different categories.

4. Build the Summary formulas

On the Summary tab, list categories down column A and months across row 1 (as real dates, such as 1/1/2027 for January). In cell B2, this formula totals one category for one month:

=SUMIFS(Transactions!$F:$F, Transactions!$E:$E, $A2, Transactions!$B:$B, "Expense", Transactions!$A:$A, ">="&B$1, Transactions!$A:$A, "<"&EDATE(B$1,1))

Copy it across and down. It works the same way in Excel and Google Sheets. Add a Total Expenses row with =SUM() under each month, a Total Income row using the same SUMIFS with "Income" as the type, and a Profit row that subtracts expenses from income.

5. Test it with a sample month

Enter a few sample rows and check that the totals match what you'd add up by hand. Here's what one month might look like:

Example figures only. Use your own numbers.

Once the totals check out, delete the sample rows and start logging for real.

Prefer to skip the build?

If you'd rather start logging today, our free business expense template is a basic version with a transaction log, a category dropdown and a summary tab. When you want the spreadsheet to do more of the bookkeeping, the Business Income & Expense Tracker ($7.99, Excel and Google Sheets) adds a monthly profit and loss, a mileage log, a tax set-aside estimate and a dashboard, with formulas already built in. A Start Here tab walks you through setup.

Setting up your spreadsheet for tax time

A few small choices now make tax season much easier:

• Match your categories to your tax form. If you file Schedule C, use its expense line names as your categories, as in Step 3.
• Add a business-use column for items you use partly for personal reasons, like a phone. Log the full amount and the business percentage.
• Keep one tab per year. Start a fresh Transactions tab or file each January, and keep the old one.
• Save the receipts, not just the log. The log is the summary. The receipts, statements and invoices are the proof.
• Make a year-end copy. After you file, save a read-only copy of the spreadsheet with that year's receipts folder.

When tax season comes, hand your preparer the Summary tab's yearly category totals and keep the receipts ready if questions come up. Our tax documents checklist covers everything else to gather.

How long to keep business expense records

The IRS says you generally must keep records that support income, deductions or credits on a tax return until the period of limitations for that return runs out. In many cases, that means keeping records for 3 years after you file, but some situations call for longer:

Your insurance company or lenders may want you to keep records longer, so check before you shred. Our guide on how long to keep documents covers household papers too.

A weekly and monthly routine that sticks

The system only works if it's routine. Here's a rhythm that takes well under an hour a week:

Before HomeBase, I worked as an executive assistant, keeping other people's calendars and details in order. The habit behind this routine is one I lean on everywhere: big changes come from small, repeatable steps, not a heroic catch-up session. If you miss a week, don't start over. Log two weeks next time and keep going. A plan you can pause and pick back up beats a perfect plan you quit in February.

Common mistakes when tracking business expenses

• Mixing personal and business purchases. It's the number one reason logs get messy. Use one account or card for the business.
• Waiting until tax season. Rebuilding a year from bank statements takes far longer than 15 minutes a week.
• Logging without receipts. A spreadsheet entry alone doesn't prove the expense. Keep the document.
• Too many categories. If you're not sure where something goes, your category list is too long.
• Forgetting small recurring charges. App subscriptions and processing fees add up. Check your statement for them each month.
• Skipping mileage. If you drive for the business, log trips as they happen.

Track it once, use it all year

Tracking business expenses isn't about becoming an accountant. It's about knowing your numbers well enough to make good decisions and having the proof ready when you need it. Start with a separate account, a short category list and a weekly logging habit. The spreadsheet does the rest.

If you want everything set up for you, the Business Income & Expense Tracker ($7.99) logs income, expenses and miles in one place and shows your monthly profit, category totals and tax set-aside. Browse our other budget spreadsheets for Excel and Google Sheets, or start with the free small business expense spreadsheet and upgrade when you're ready.

Running rental property too? Our guide to tracking rental property income and expenses uses the same habits. And if you reimburse helpers or employees, see our small business expense reimbursement policy guide.