Small Business Spreadsheet for Income and Expenses 2025 [Free]

Recording your business income and expenses is vital for every small business. But remembering to do so daily when you have multiple other things to do and run your business may be challenging.

Luckily, we’ve created an easy way for you to get started! No more money or time wasted, and no more headaches. 

Simply use our already set-up template (you’re welcome!).

Get the free small business spreadsheet for income and expenses

If you use an Excel spreadsheet or a Google Sheet, you can log your small business income and expenses on the go from your phone or computer. Prefer the analogue way? Print your template and keep it on your person, or fill it out at home daily.

Mileage tracking made easy

Trusted by millions of drivers

Automate your logbook Automate your logbook

Claim your deductions

Reclaim your time

Automatic mileage tracking and IRS-compliant reporting.

Get started for free Get started for free

How to use the income and expenses small business spreadsheet

An income and expense sheet is a monthly or yearly record of your business-related expenses that you will need to keep track of your small business expenses and income. 

It will come in handy at tax time when you can quickly review your money in and out for the previous year. Having a simple overview of your business’s financial situation is also helpful for your own benefit.

Remember to keep receipts and invoices of all business expenses so that you can claim them and lower your taxable income at tax time.

Are you self-employed? Learn how to keep track of all your business expenses.

Ready to go-template

The small business income and expenses template (in Google Sheets and Excel) contains a few examples of income and expenses. The formula in the Balance column is set to calculate the balance after each indicated transaction. Simply delete the examples already in the sheet and start adding your transactions. You can copy the sheet for each month or continue adding expense rows throughout the quarter or year.

If you wish to keep a paper log of your small business transactions, you can print the PDF template for income and expenses and fill it out manually.

Get an overview of all the tax deductions for self-employed. 

How to fill out the spreadsheet for income and expenses

The spreadsheet template allows you to add the date, type of count money when in or out from, a description of the transaction, and its amount (income or expense) The Balance column will automatically calculate the current balance for your small business.

Simplify other small business tasks

Small businesses require dedication and determination to become successful. Difficult tasks often take up precious time that you could instead spend working or developing your business.

Thankfully, many tools allow you to simplify or fully automate record-keeping and tax-related work.

Driving for work? Record all your mileage automatically with the Driversnote mileage tracker for an IRS-compliant mileage logbook. You will free up time for more important things, and make sure to maximize your mileage deductions at tax time! In our dedicated guide, find out more about claiming mileage from the IRS as a self-employed individual or a small business owner.

FAQ