Free Income and Expense Spreadsheet for Freelancers (Excel)
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)
Shaded cells are for you to fill in; the totals work themselves out.
| Date | Type | Category | Description | Client or vendor | Amount | Business purpose |
How to use the income and expense spreadsheet
- Download it and open it in Excel, or upload it to Google Drive and open it with Google Sheets.
- 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.
- Type amounts as positive numbers. The Type column says whether money came in or went out.
- 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
- Free profit and loss statement template: a monthly P&L in Schedule C categories.
- Free mileage log template: record business driving for the mileage deduction.