Skip to content
The title slide and first slides of the Farm Income and Expense Tracker template

Farm Income and Expense Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Style
Modern
Difficulty
Beginner
Updated
November 15, 2026

Every slide (6)

Overview

Small farms, market gardens and hobby farms use this tracker for a year of seasonal income and costs in one file. The Sales tab records each sale by product, quantity, unit and price. The Expenses tab holds feed, seed, fuel, repairs and labor, each with a category and month. The Equipment tab lists machinery bought during the year. The Dashboard shows sales against expenses month by month, plus sales by product and spending by category.

Enter a sale when the buyer pays and an expense when you pay it, and pick the month each time. Farm income swings with the seasons, so the monthly chart shows when cash runs thin. Keep invoices for equipment and mark missing ones in red. At year end, give the totals and the equipment list to a tax professional who knows farm records.

Useful for

  • See which crops and animals earn the most
  • Plan for lean months using last year's monthly pattern
  • Collect sales, costs and equipment lists for a tax professional

What's included

  • 5 tabs: Dashboard, Sales, Expenses, Equipment, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Sales: a table
  • Expenses: a table
  • Equipment: a table
  • 3 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Sales tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What records should a small farm keep for taxes?

Write down every sale, every payment for feed, seed, fuel and repairs, and an invoice for equipment. Note the date and amount of each. This workbook organizes those records by month and category, so the totals are ready at filing time.

How do I track farm income by month?

Choose the month for each sale on the Sales tab. The Dashboard totals sales and expenses for every month in one table and a chart, so busy and quiet seasons stand out.

Where do equipment purchases go?

Enter them on the Equipment tab with the date, seller and cost. Whether a purchase is treated as a one-time cost or spread over several years is a tax question, so ask a tax professional and keep the invoice.

  • #tax-tracker
  • #farm-income-and-expense-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…