Small Business Income & Expense Tracker – Excel & Google Sheets

Simple bookkeeping for freelancers and small businesses.

Know exactly what you earn, what you spend and what you keep. This income and expense tracker spreadsheet for Excel and Google Sheets turns your transactions into a monthly dashboard, a full profit and loss statement and a quarterly tax estimate. No accounting software, no subscription.

What's inside

• Business dashboard: pick a month and see revenue, expenses, net profit, margin and how much to set aside for tax, plus year-to-date totals and your best month.
• Income log: clients, categories, invoice numbers and payment method, with Paid / Unpaid status.
• Unpaid invoice tracker: every open invoice and how many days it's been waiting.
• Expense log: vendors, categories and a receipt checkbox for tax time.
• Profit & Loss: every income and expense category, every month, with totals and profit margin.
• Tax summary: quarterly profit, tax to set aside and deductible expenses.
• Charts: income vs expenses and profit by month, and where your money went.

Made to be easy

• Works in Microsoft Excel (Mac & PC) and Google Sheets
• Your own income and expense categories
• Any currency, any year
• Step-by-step "Start Here" guide and a filled-in example

Great for

Freelancers, designers, consultants, coaches, creators, Etsy and online sellers, and any small business that wants clear numbers without complicated software.

How you get it

This is a digital download. Nothing is shipped. Right after checkout you'll get a download link by email.

For your own business use. Tax figures are estimates, not tax advice.