Free Income and Expense Spreadsheet for Freelancers (Excel)

By the JAJPO team · How we build our tools

A free income and expense spreadsheet for freelancers and side businesses. Add one row for each payment in or out, pick a category from the list, and the summary shows money in, money out and net profit by month and by IRS Schedule C category.

Free template

Free Income and Expense Spreadsheet (Excel)

Excel file (.xlsx) · opens in Excel, Google Sheets, Apple Numbers and LibreOffice · 4 sheets · formulas included

Shaded cells are for you to fill in; the totals work themselves out.

Preview: the Transactions sheet
Preview of the Transactions sheet
DateTypeCategoryDescriptionClient or vendorAmountBusiness purpose

How to use the income and expense spreadsheet

  1. Download it and open it in Excel, or upload it to Google Drive and open it with Google Sheets.
  2. On the Transactions sheet, add a row for each payment: the date, Income or Expense, a category from the drop-down, a short description and the amount.
  3. Type amounts as positive numbers. The Type column says whether money came in or went out.
  4. Open the Summary sheet for the year's totals, each month, and each category. Change the year at the top to see another year.

What's in the spreadsheet

  • A Transactions sheet with 300 rows, drop-downs for type and category, and a frozen heading row.
  • A Summary sheet: money in, money out and net profit for the year, a month-by-month table, and totals for every category.
  • A Categories sheet with the 24 categories and their Schedule C lines.
  • A "How to use" sheet.

Spreadsheet or online tracker?

The free Income & Expense Tracker does the same in your browser, with no formulas to look after. It also makes a profit and loss statement, imports and exports CSV files, and sends your profit to the 1099 Tax Calculator to estimate your tax.

Frequently asked questions

Which expenses can I deduct?

Ordinary and necessary business expenses are generally deductible, and the categories here follow Schedule C. Business meals are generally only 50% deductible, and personal costs aren't deductible. Keep receipts, and ask a tax professional if you're unsure.

What if I need more than 300 rows?

Insert rows above the last one on the Transactions sheet, then widen the ranges in the Summary formulas to match. Or start a new copy for each year.

Is the spreadsheet really free?

Yes. We ask for your email so we can send you tax-deadline reminders and new templates; you can unsubscribe at any time.

Related