One-Person Income Ledger – Freelancer Income, Expense, Mileage & Tax Set-Aside Spreadsheet

Description

A clean, no-subscription spreadsheet for US freelancers, side hustlers and one-person businesses who want to know what they actually earned, what they spent, and how much to set aside for taxes. Log each payment, expense, business trip and invoice once — the dashboard does the math: income, costs and net profit by month with a chart, year-to-date totals, and expenses grouped by IRS Schedule C category so tax time is less painful. A quarterly helper applies your own set-aside % to the profit earned in each IRS estimated-payment period, and the invoice tracker counts days overdue automatically. Everything uses plain formulas and dropdowns — no macros, add-ons or accounts. It opens in Excel and imports cleanly into Google Sheets. Example rows show how it works and delete in seconds. It is an organizing tool, not accounting software or tax advice.

Features

- Monthly dashboard – income, fees, expenses, mileage, net profit and cumulative profit for each month, a chart, and YTD summary cards

- Income log – client/source, category, gross, fees, auto-calculated net, Paid? dropdown, payment method, invoice #

- Expenses log – 27 categories mapped to IRS Schedule C lines, receipt-link column, notes

- Mileage log – editable IRS standard-rate cells (pre-filled with 2026's midyear rate change; labeled “check current IRS rate”), deduction calculated per trip

- Invoices tracker – issued/due dates, status dropdown, automatic days-overdue with red highlight, outstanding total on the dashboard

- Quarterly tax set-aside helper – your chosen %, the four IRS estimated-payment periods and usual due dates, and a place to record what you paid

- Customizable dropdowns – edit categories and payment methods on the Lists tab; dashboard totals follow your changes

- Change one cell to view another tax year; frozen headers, filters, and 1,000 pre-formatted rows per log

What's included

- income-ledger.xlsx – the spreadsheet (8 tabs: Start Here, Dashboard, Income, Expenses, Mileage, Invoices, Tax Set-Aside, Lists)

- README.pdf – one-page quick start

Compatibility

- Microsoft Excel 2016 or newer, Microsoft 365 (Windows & Mac), and Excel for the web

- Google Sheets (upload, then File > Save as Google Sheets)

- LibreOffice Calc

- Apple Numbers can open it, but dropdowns and the chart may not behave exactly the same

- No macros, scripts or add-ons. Designed for US taxpayers (IRS Schedule C categories, US dollars)

Disclaimer – not tax advice

This spreadsheet is a record-keeping and budgeting tool. It does not calculate your tax liability and is not tax, legal or accounting advice. The set-aside % is a savings figure you choose, not an estimate of what you owe. IRS mileage rates, due dates and Schedule C line references can change. Check irs.gov and talk to a qualified tax professional.

Refunds

This is a digital download, so all sales are final. If the file won't open or something isn't working, contact me through Payhip and I'll help fix it.