
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
| Date | Description | Category | Income | Expense paid | Business use % | Business portion | Receipt reference |
|---|---|---|---|---|---|---|---|
| 10/05/2026 | Client payment | Services | $650 | $0 | — | $0 | Invoice 105 |
| 10/06/2026 | Business supplies | Supplies | $0 | $45 | 100% | $45 | Receipt 201 |
| 10/07/2026 | Mobile service | Communications | $0 | $80 | 60% | $48 | Statement 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 item | Formula |
|---|---|
| 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:
- Compare entries with bank and platform statements.
- Locate missing receipts or invoices.
- Review categories and mixed business and personal costs.
- 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.