Home›Templates›Accounting & Small Business Spreadsheets›Income & Expense Tracker
Preview of the Income & Expense Tracker template

Sample text in [brackets], replace with yours · Accounting & Small Business Spreadsheets

Free template

Small Business Income and Expense Tracker (Excel & PDF)

Record every sale and every bill on one sheet. The balance, profit, margin and totals by category update automatically.

✓ A4✓ Category dropdown✓ Auto profit & margin✓ Excel & PDF

Opens in your browser. No Excel needed, no signup.

Free for personal and commercial use · No watermark · Updated November 2026

Guide

About this income & expense tracker template

Most small businesses don't need accounting software to know whether they made money this month. They need one list of money in and money out. This tracker gives each transaction a row with the date, description, a category from a dropdown, and the amount as income or expense. The running balance updates as you type, and the summary beside it shows total income, total expenses, profit or loss, profit margin and the total for every category, so you can see at a glance that rent or stock is eating your margin. It suits shops, freelancers, home businesses and side hustles.

How to use this income and expense tracker

  1. 1

    Click "Edit online" to open it in your browser, or download the Excel file.

  2. 2

    Delete the sample rows and type your currency at the top.

  3. 3

    Add each sale or payment as a row: date, description, category, then the amount under Income or Expense.

  4. 4

    Watch the balance column and the summary update as you go.

  5. 5

    Start a new copy each month (or each year) to keep a clean history for tax time.

Tips for tracking business money

Record it the same day

Add receipts daily or weekly. Rebuilding a month from memory always misses small costs.

Keep personal money out

Pay yourself a fixed "owner's salary" from the business. Don't mix personal shopping into the sheet.

Keep the receipts

Scan paper receipts with the phone document scanner and store them as PDFs by month.

Watch the categories

If one expense category keeps growing faster than sales, that is where to cut or renegotiate first.

Frequently Asked Questions

Yes. Download the Excel or PDF version, or edit it online for free, with no signup and no watermark.

Profit = total income − total expenses. Profit margin = profit ÷ total income. Both update automatically from the rows you enter.

Yes. Edit the names in the "By category" table and in the dropdown list (Data > Data validation) so they match.

100 rows. For more, insert rows inside the table so the totals and category sums include them, or start a new sheet each month.

No. It is a simple record of money in and out. Your accountant or tax adviser can use it, but it doesn't handle tax returns.

Tools that help

📗

Excel to PDF

Convert Excel spreadsheets to PDF with all sheets preserved

Use Tool→
📊

PDF to Excel

Extract tables from PDF into editable Excel spreadsheets

Use Tool→
📷
New

Scan Document to PDF

Turn phone photos of documents into a clean, straightened PDF scan. Auto edge detection, filters, multiple pages.

Use Tool→
🗜️

Compress PDF

Reduce PDF file size without losing quality

Use Tool→

More accounting & small business spreadsheets

Expense Report template preview

Expense Report

Claim business expenses with category totals and advances.

ExcelPDF
Inventory / Stock Sheet template preview

Inventory / Stock Sheet

Stock in, stock out, closing stock and reorder alerts.

ExcelPDF
Monthly Business Budget template preview

Monthly Business Budget

Budget vs actual for income and expenses, with profit.

ExcelPDF
Cash Book template preview

Cash Book

Daily cash in and out with a running balance.

ExcelPDF
Price List template preview

Price List

Products and services by category, with discounts.

ExcelPDF
Daily Sales Report template preview

Daily Sales Report

Bills, payment methods and end-of-day cash check.

ExcelPDF
Salary Sheet (Payroll) template preview

Salary Sheet (Payroll)

Monthly payroll for all staff: gross, deductions, net pay.

ExcelPDF
Project Plan (Gantt Chart) template preview

Project Plan (Gantt Chart)

Tasks, owners, dates and a 12-week Gantt chart.

ExcelPDF
Profit and Loss Statement template preview

Profit and Loss Statement

Income statement with gross, operating and net profit.

ExcelPDF
Balance Sheet template preview

Balance Sheet

Assets, liabilities and equity with a balance check.

ExcelPDF
Trial Balance template preview

Trial Balance

Every ledger balance in debit and credit, with totals that must agree.

ExcelPDF
Trading Account template preview

Trading Account

Dr/Cr trading account that works out gross profit or gross loss.

ExcelPDF
Cost Sheet template preview

Cost Sheet

Prime cost to sales, with cost per unit at every level.

ExcelPDF
Cash Flow Statement template preview

Cash Flow Statement

Indirect-method cash flow: operating, investing and financing.

ExcelPDF
Bank Reconciliation Statement template preview

Bank Reconciliation Statement

Match the cash book to the bank statement, with an automatic check.

ExcelPDF
Ledger template preview

Ledger

Ledger account with running Dr/Cr balance, plus a T-format sheet.

ExcelPDF