You can track business expenses for free with three things you already have: a spreadsheet, your monthly bank and card statements, and your phone's camera for receipts. Spend ten minutes a week tagging new charges and photographing receipts, then check the month against the statement. No app subscription is needed.
What do you need to track business expenses for free?
To track business expenses for free, you need a spreadsheet program, access to your bank and card statements, a phone camera and a cloud folder. Excel, Google Sheets or Numbers all work. The statements give you every charge with a date and amount, and the photos give you the proof behind each one.
The statement does most of the heavy lifting. The IRS notes on its page about what kind of records to keep that the business checking account is the main source of entries for most small businesses. It also lists account statements, credit card statements and receipts among the documents that support an expense, and says the support should identify the payee, the amount, proof of payment and the date.
A statement covers payee, amount and date. A receipt or invoice covers what was bought. Together they make a complete record, which is why this method pairs them.
What you do not need:
- A paid app. It saves time only at higher volumes.
- A scanner. A phone photo of a flat receipt in good light is enough.
- Daily entry. Weekly tagging plus a monthly check catches everything.
Setting up a free business expense tracking sheet
A free business expense tracking sheet needs one row per expense and seven columns: date, account, vendor, amount, category, receipt and note. Put your category list on a second tab and use data validation so every row picks from it. A third tab totals each category by month.
Here is a sample of the main tab with six rows. The vendors, amounts and categories are examples.
| Date | Account | Vendor | Amount | Category | Receipt | Note |
|---|---|---|---|---|---|---|
| 2026-04-02 | Business card | Web host | 24.00 | Software and hosting | Yes | Monthly plan |
| 2026-04-03 | Checking | Office supply store | 41.75 | Supplies | Yes | Printer paper, ink |
| 2026-04-07 | Business card | Design software | 22.99 | Software and hosting | Yes | |
| 2026-04-10 | Checking | Courier | 18.50 | Postage and shipping | No | Ask courier for invoice |
| 2026-04-14 | Business card | Restaurant | 58.00 | Meals | Yes | Client, A. Chen, project kickoff |
| 2026-04-21 | Checking | Trade association | 120.00 | Dues and subscriptions | Yes | Annual membership |
Choosing categories
Keep the category list short, around ten to fifteen names, and base it on the expense lines of the tax form you file. That way year-end totals carry straight across. Resist adding a new category for every new vendor. "Software and hosting" can cover a dozen subscriptions.
The totals tab
On the totals tab, list categories down the side and months across the top. A SUMIFS formula per cell adds the amounts for that category and month. With that in place, you always know where the year stands.
The same category totals, a year at a time, are the starting point for planning. A small business budget template built from last year's rows turns them into next year's spending plan.
A weekly ten-minute business expense tracking habit
The weekly business expense tracking habit is a ten-minute session on the same day each week: look at the past week's charges in your banking app, add the business ones to the sheet, photograph or save any receipts, and note anything unclear. Doing it weekly means you still remember what each charge was.
A weekly checklist:
- Open your banking and card apps and look at the last seven days.
- Add each business charge to the sheet with its category.
- Photograph paper receipts and save emailed receipts into the month's folder, named by date, vendor and amount.
- Mark the receipt column yes or no.
- Write a note for anything a stranger could not work out: who the client lunch was with, which project the supplies were for.
Then, once a month, replace the weekly entries with the statement itself, or check them against it. The statement is the complete list. Weekly entries catch the context; the monthly check catches anything you missed.
If your bank only gives PDF statements, the monthly check is quicker with the rows in a spreadsheet. CheapBankConvert, getting ready to launch, converts a PDF statement into CSV or Excel with one payment per statement and no monthly plan. You can sign up to hear when it opens.
When a week gets skipped
A missed week is not a problem as long as the monthly check still happens. Do not try to reconstruct the skipped week from memory. Wait for the statement, add the missing business rows from it, and use your email and calendar to fill in the notes. The routine survives a missed week; what it does not survive is a missed quarter, because by then the receipts are harder to find and the reasons for each charge are gone.
If you find yourself skipping often, move the session rather than shortening it. Ten minutes on a Monday morning with coffee tends to last longer than ten minutes squeezed in on a Friday evening.
Business expenses that never appear on a bank statement
Some business expenses never appear on a bank statement: cash purchases, business miles driven in a personal car, and the business share of home costs. They are easy to forget because nothing reminds you of them. Each needs its own small log, kept alongside the main sheet.
Cash purchases. Parking meters, market stalls and tips paid in cash leave only an ATM withdrawal behind. Log each cash purchase with the date, amount and purpose, and keep the receipt if there is one.
Mileage. If you drive your own car for business, the expense is the business miles, not any single charge. Keep a mileage log with the date, destination, purpose and miles for each trip. The fuel charges on your statement are not the same thing and may not be what you deduct.
Home office and shared bills. The business share of rent, utilities, phone or internet is a split of a personal bill. Record the bill once and the business share in a separate column, with a note on how you worked out the percentage.
Bank fees and interest. These do appear on the statement but are easy to skip because they look like noise. Add them anyway, and ask your preparer how fees on a business account should be treated.
How do you check that tracked business expenses are complete?
You check that tracked business expenses are complete by comparing the sheet against each statement once a month. Every business row on the statement should appear in the sheet, and nothing in the sheet should be missing from a statement unless it was paid in cash. Totals that differ point to a missing or extra row.
A monthly completeness check:
- Count the business rows on the statement and in the sheet for that account and month. The counts should match.
- Total both lists. If the totals differ, sort both by amount and look for the odd one out.
- Look for recurring charges that should be there every month, such as hosting or software, and confirm each one is present.
- Check the receipt column for any "No" above your threshold, and request or recreate those receipts.
When a receipt cannot be found, the statement row is still part of the evidence. Lost receipts for taxes: use your bank statement explains what to do with the gaps and how to build a substitute record.
Incoming money deserves the same check from the other side. If you invoice clients, an invoice tracker spreadsheet matched to bank deposits marks each invoice paid from the statement, so income is as complete as expenses.
Free business expense tracking mistakes that cost deductions
The free business expense tracking mistakes that cost deductions are tracking only what you remember, leaving categories vague, and skipping the context note. Each one makes an expense harder to claim or easier to miss. They cost nothing to fix if you catch them in the weekly session rather than in April.
- Tracking from memory instead of the statement. Small recurring charges are the first to be forgotten, and they add up over a year.
- Using "miscellaneous" as a category. A preparer cannot do much with it, and large miscellaneous totals invite questions.
- No note on meals and travel. These are the categories where the business purpose matters most, and the purpose is the part you forget.
- Mixing personal charges in. If personal spending slips into the sheet, your deductions are overstated.
- Stopping in the busy season. The weeks you are too busy to track are often the weeks with the most expenses.
- Deleting the statements once the sheet is filled. The sheet is a summary; the statements and receipts are the support.
Keep the sheet, the statements and the receipt folder together, and back them up once a quarter. That is the whole system, and it costs nothing but ten minutes a week.