Free Business Income and Expense Tracker (Excel & Sheets)

What's in the income and expense tracker

The workbook has three tabs. Income logs every payment received: date, client/source, category and amount. Expenses logs every purchase with a category dropdown (Supplies, Software, Marketing, Travel, Contractors, Rent & utilities, Insurance, Other) and a running category-total breakdown underneath.

P&L is a 12-row monthly rollup with each calendar month's period start and end dates pre-filled - income, expenses and net profit for that month total automatically from the Income and Expenses tabs, with year totals at the bottom.

This is one file that works for a simple daily tracker AND a category-tagged profit-and-loss view - competitors like Shoeboxed split solo/1099 filers into a separate, simpler file instead of covering both cases in one download.

Built for solo and 1099 filers, not just payroll businesses

Shoeboxed's strongest free spreadsheet explicitly tells solo and 1099 filers 'this isn't the sheet for you' because it's scoped to businesses running payroll or paying contractors. This tracker has no payroll complexity built in at all - it's just income, expenses, categories, and a monthly P&L, which is exactly what a freelancer or solo operator needs without extra tabs they'll never use.

It works equally well for a small business with several expense categories to watch, since the category-total breakdown on the Expenses tab shows where spending concentrates without a separate report.

Monthly profit and loss, calculated automatically

Each P&L row's period boundaries (first and last day of the month) are pre-filled for the calendar year, so income and expenses roll up automatically the moment you log entries with dates in that month - no manual monthly totals.

Driversnote's free version gives you flat income and expense tabs with no profit and loss summary at all - you'd build that yourself. This template calculates it for you, every month, automatically.

No SaaS upsell funnel

Driversnote and Shoeboxed both position their free spreadsheet as a lead magnet toward their own paid app (mileage tracking, receipt scanning). This is the whole tool - no in-file nudge toward a separate paid product, no app signup required to keep using it.