Self Employed Income & Expense Tracker

Know what you earned, what you spent and what to set aside, every month.

FEATURES

• Income log with Paid/Unpaid status (only paid income counts)

• Expense log with 12 editable categories (dropdowns); anything outside your list is totaled as 'Other' so totals still add up

• Business meals counted at 50% (editable) with a note; cash spent still shown in full

• 2026 IRS business mileage rates built in and applied by trip date: 72.5¢/mile Jan 1–Jun 30 and 76¢/mile from Jul 1 (rates current as of Oct 2026; confirm the current rate at irs.gov), editable for future years

• Monthly P&L dashboard for the tax year you choose (other years are left out and flagged), unpaid-invoice total and profit margin

• Quarterly estimated-tax view using IRS periods, with the usual due dates for your tax year and an estimated-payments log (paid vs set-aside)

• Mileage log also records parking & tolls and driver/vehicle; trips from other years are flagged

• Tax set-aside line based on a % YOU choose (we don't recommend a rate); the annual figure is your % × annual net profit

• Informational self-employment tax estimate (15.3% × 92.35% of net profit; a rough guide, not a tax calculation)

• Check columns flag typos (text miles, odometer end below start, bad dates) instead of silently counting them

• Formula cells locked against accidental edits (no password; unlock any time)

WHAT YOU GET

• 1 Excel (.xlsx) file, plus a PDF with a Google Sheets 'Make a copy' link and setup steps

• Works in Microsoft Excel (desktop, 2016 or later) and free Google Sheets (desktop recommended for setup)

• Instant digital download. No physical item will be shipped.

Payhip delivers this file under its standard End User Licence (payhip.com/terms/end-user). As the copyright owner, Sheetsmith Studio also grants you the additional rights below. If anything here conflicts with the End User Licence, these broader rights from Sheetsmith Studio apply.

LICENSE: One license = use by one person or one business (including its employees and contractors) for its own records. You may edit the file and send documents you create with it (invoices, quotes) to your clients. You may not resell, share, give away or redistribute the template or its 'Make a copy' link, in original or modified form, or use it to create templates for sale. Need it for multiple businesses? Message me for a multi-business license. © 2026 Sheetsmith Studio. All rights reserved.

RETURNS: Because this is a digital download, returns and exchanges aren't accepted. If your file won't open or something isn't working, message me and I'll fix or replace it, or help you get set up. This doesn't affect your statutory rights. Your download link appears right after payment and is also emailed to you.

TRADEMARKS: Microsoft Excel is a trademark of Microsoft Corporation; Google Sheets is a trademark of Google LLC. Other platform names mentioned are trademarks of their respective owners and are used only to describe compatibility. Sheetsmith Studio is not affiliated with, sponsored or endorsed by any of them.

AI disclosure: This template was designed with the help of AI tools (layout ideas, formula drafting and description writing). Every formula was then built, tested and checked by Sheetsmith Studio before listing.

Please note: This is an organizing tool, not tax, legal, accounting or financial advice, and it doesn't calculate tax owed. Results depend on the numbers you enter. Talk to a qualified professional about your own situation.