The Free Income & Expense Tracker Spreadsheet, No Signup Required

What's in the free file

The free tracker is three sheets, built to be usable in about five minutes with nothing to configure:

• Start Here. A short setup guide, a Settings block where you can change the currency symbol used in every header on the sheet, and a plain-language rundown of what the paid toolkit adds if you outgrow this one.
• Transactions. One flat log with five columns -- Date, Type (a dropdown: Income or Expense), Category (a dropdown with eight generic categories covering both), Description, and Amount. There are 200 pre-formatted rows ready to fill in, five of them already filled with example data so you can see the pattern before you start typing your own.
• Summary. Six numbers that update themselves as you log transactions: total income, total expenses, and net, both all-time and for the current month. The this-month figures use a formula keyed off today's date, so they always reflect the month you're in when you open the file.

That's genuinely everything -- there's no hidden fourth tab, no locked cells waiting for a paid unlock. What you see in the download is the whole product.

How to use it in Excel

1. Download the file and open it in Excel like any other workbook.
2. Open the Start Here tab and set your currency symbol if you don't use $.
3. Go to the Transactions tab. Replace the five example rows with your own, or leave them as a reference and start adding new rows underneath.
4. For each row, pick Income or Expense from the Type dropdown, pick a Category from its dropdown, then fill in the date, a short description, and the amount.
5. Check the Summary tab any time -- the totals recalculate automatically, the same way any other Excel formula does.

How to use it in Google Sheets

The file isn't a native Google Sheet, but importing it takes under a minute and nothing about the formulas or dropdowns breaks in the process:

1. Open Google Sheets and go to File > Import.
2. Choose the Upload tab and select the .xlsx file you downloaded.
3. When prompted for an import location, choose Insert new sheet(s) (or "Create new spreadsheet" if you'd rather it live on its own) and confirm.
4. All three tabs come in together, along with the Type and Category dropdowns and every formula on the Summary tab -- nothing needs to be rebuilt.
5. From there it behaves like any other Google Sheet: log transactions on the Transactions tab, and the Summary tab keeps itself current.

What the free version leaves out

This is meant to be honest, not a teaser with the good parts hidden: the free tracker is a genuinely smaller product, not a crippled version of a bigger one. Specifically, it leaves out:

• A category-by-category dashboard. The free Summary tab totals income and expenses overall and for the current month. It doesn't break spending down by category or chart it month over month.
• Editable category lists. The eight categories here are fixed. The paid toolkit's Income & Expense Tracker lets you edit your own income and expense category lists, which then drive the dropdowns and the dashboard automatically.
• A tax set-aside calculator. Something that works out how much of each payment to move into a tax savings account as you log it.
• A rate calculator. A separate tool for working out the hourly and day rate you need to charge to hit a take-home income goal.
• A client & invoice tracker. Auto-numbered invoices, a due date that calculates itself, a status dropdown, and a dashboard of what's outstanding and overdue -- a different job than logging income and expenses, and a separate workbook in the full toolkit.

If any of those would actually get used, the Freelancer Finance Toolkit on Etsy bundles all of it together, including this tracker's bigger sibling with twelve monthly tabs and a full dashboard instead of one flat log.

Need something built around your exact business instead?

Neither version of this tracker is going to fit every business perfectly -- both are built around the generic shape of freelance income and expenses. If your business tracks something these sheets don't (inventory, multiple locations, a workflow that's specific to what you do), the custom spreadsheet service builds a workbook around your actual numbers instead of asking you to adapt to a template.