← All resources

Free Google Sheet

Income & expense tracker

A simple way to keep track of what comes in and what goes out, without needing bookkeeping software.

Get the tracker

Opens a copy in your own Google Drive

What's inside

Eight tabs, and you only type in a few of them. The rest does the math for you.

  • Transactions. Log every money in and money out. Pick a category from the dropdown and it knows whether it's income or an expense.
  • Monthly summary. Your profit for each month, broken out by category, so you can see where your money is going.
  • Income by source. Name your services or sales channels and see which ones bring in the most.
  • Mileage log. Log your business drives and it figures the deduction at the 2026 IRS rates.
  • Home office. Compare the simplified method with a rough estimate of the regular one.
  • Tax set-aside. A monthly number to move into savings so tax time isn't a surprise.
  • Categories. Each one explained and matched to the Schedule C line your tax preparer uses.

How to get started

  1. Make your copy. Click "Get the tracker" and Google will ask you to make a copy. That copy is yours and lives in your own Drive.
  2. Fill in Start here. Add your business name and the tax year.
  3. Log as you go. Add transactions as they happen, or set aside a few minutes once a week. Blue cells are for typing. Gray cells take care of themselves.

One tip: record each transaction on the date the money actually moved. That keeps your numbers on a cash basis, which is what most small businesses use. Not sure which one you're on? Where did my money go? walks through it.

This tracker is for organizing your numbers. It isn't tax advice, so check with your tax preparer before you file.

Rather hand this off?

If logging transactions is the last thing you want to do, that's what we're here for. We'll keep your books up to date and send you clear monthly reports.

See If We're a Fit