Mileage & taxesUpdated for 2026

Small Business Income and Expenses Spreadsheet: A Practical Template

Build a simple income and expenses spreadsheet, organize receipts, and review your business finances with this practical small business template.

November 13, 20264 min read
Laptop spreadsheet, receipts and calculator for small business recordkeeping

A small business income and expenses spreadsheet helps you answer a basic question: what is happening to the money your business earns?

For independent drivers, freelancers, and service businesses, a simple spreadsheet can provide a useful starting point. It gives each transaction a place and makes monthly reviews easier.

What should your spreadsheet include?

Create columns that allow you to identify the transaction, understand its purpose, and locate supporting evidence.

The IRS permits a recordkeeping system suited to your business, provided it clearly shows income and expenses. Supporting documents remain important; the spreadsheet is an index and summary of your activity, not a replacement for evidence.

Copyable income and expenses template

DateDescriptionCategoryIncomeExpense paidBusiness use %Business portionReceipt reference
10/05/2026Client paymentServices$650$0—$0Invoice 105
10/06/2026Business suppliesSupplies$0$45100%$45Receipt 201
10/07/2026Mobile serviceCommunications$0$8060%$48Statement 10

Figures are fictional. The business use percentage is illustrative, not a standard allowance. The business portion column does not establish tax deductibility.

In this example, income totals $650, expenses paid total $125, and the identified business portions total $93.

Set up useful spreadsheet formulas

Using the column order above:

  • Column D contains income.
  • Column E contains expenses paid.
  • Column F contains the business use percentage.
  • Column G contains the calculated business portion.

Enter this formula in G2: =E2*F2

Format column F as a percentage and columns D, E, and G as currency.

For a simple summary covering rows 2 through 100:

Summary itemFormula
Income recorded=SUM(D2:D100)
Expenses paid=SUM(E2:E100)
Business portions recorded=SUM(G2:G100)

Treat these as management totals. They are not automatically your taxable profit or cash balance.

Keep money movements separate from operating activity

Add separate categories or tabs for owner contributions, transfers, borrowing, and other transactions that need individual treatment.

This prevents a transfer between accounts from looking like a new customer payment. It also makes it easier to ask your accountant about transactions that do not fit an ordinary income or expense category.

If your business holds inventory, purchases significant equipment, or has more complex accounting requirements, a basic cash spreadsheet may need additional schedules.

Handle driving costs carefully

For driving businesses, keep a mileage tab alongside the transaction sheet. A mileage log template gives that tab a consistent structure. Fuel purchases show cash spent; a mileage record explains vehicle use.

Keep the cash cost of running your vehicle separate from the tax deduction calculation. They answer different questions and should not be combined without reviewing the applicable vehicle expense method.

This distinction also helps you compare how much you are earning with what it costs to operate.

Review the spreadsheet every month

A practical monthly review takes four steps:

  1. Compare entries with bank and platform statements.
  2. Locate missing receipts or invoices.
  3. Review categories and mixed business and personal costs.
  4. Investigate unusual changes before moving to the next month.

Keep descriptions clear enough that another person can understand them. “Supplies for Client D project” is more useful than “card purchase.”

How Driver AI fits into your records

Driver AI includes mileage tracking, receipt scanning, business expense tracking, and report exports. These can support the driving and expense records you use alongside your spreadsheet.

Choose one main workflow so transactions are not entered twice when moving information between an app and a spreadsheet.

Use this template for a clearer financial overview, with Driver AI supporting your mileage and expense records. Use the organized totals to estimate your self employment taxes, after reviewing which expenses qualify.

Ready to make mileage tracking easier?

Bring your mileage, receipts, and business expenses together with DriverAI to support the records you maintain alongside your spreadsheet.

FAQ

Frequently asked questions

Either can support this layout. Choose the platform you can maintain and back up consistently.

No. Keep the documents supporting your entries.

No. Tax treatment may depend on the type of cost, business use, and applicable rules.