Free farm sales and expense spreadsheet

An Excel .xlsx workbook that also opens in Google Sheets. Made for small farms, market gardens and homesteads that sell eggs, honey, vegetables or flowers. Formulas done, no macros. Free direct download: no email, no sign-up.

Download the blank farm sales and expense tracker spreadsheet (.xlsx) Filled example (.xlsx) · 1-page guide (PDF)

What it does

• A sales log: date, buyer, channel, product, quantity and paid or unpaid, with the price taken from your product list
• Revenue and unpaid money for every sale, with unpaid rows highlighted (restaurant invoices, CSA balances)
• An expenses log: seed, feed, fuel, repairs, packaging, market fees, insurance and hired help, one row each
• A dashboard with sales lines, revenue, expenses and profit by month, every product with units sold, revenue and average price, every sales channel, and the money still unpaid
• 500 sales rows, 300 expense rows, 15 products, 15 channels and 15 expense categories

How to track farm sales and expenses in a spreadsheet

1. Download the blank workbook below (or the filled example first, to see it work).
2. Settings tab: your products with the usual price and unit, sales channels, expense categories and the year.
3. Sales tab: one row per sale or market day line; mark No in Paid until the money arrives.
4. Expenses tab: one row per cost the day you pay it. Open the Dashboard tab to see revenue, expenses and profit.

Use it in Google Sheets

Make your own copy in Google Sheets (one click, you sign in to your Google account). Or upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets. Excel 2010 or newer opens the .xlsx directly.

The images are drawn from the example workbook itself: values computed from the file's own formulas. Example data is fictional.

How we checked it

Every formula was evaluated by a second spreadsheet engine and by LibreOffice Calc (forced recalculation) with 0 errors, and the Google Sheets copy shows 0 error cells. The example's 240 sales, 6,858.50 of revenue, 4,450 of expenses, 2,408.50 of profit and 96 still unpaid equal an independent sum of its rows. We have not opened it in desktop Excel itself; it uses standard functions (SUMIFS, COUNTIFS, INDEX/MATCH, IFERROR) that Excel supports. If something is wrong, email support@tuper.app.

Need a different price on single sales and a tax set-aside?

This free sheet takes the price from your product list and totals revenue, expenses and profit. The paid small farm tracker adds a price per sale when it differs, a tax set-aside by month and 1,500 sales rows:

• Small farm sales and expense tracker (12 USD): for small farms and market gardeners who want sales by product and channel, expenses, profit and unpaid invoices in one workbook
• Home bakery recipe cost calculator (12 USD): for home bakers and cottage food sellers who want to know what each recipe really costs and what to charge
• Vending machine route profit tracker (14 USD): for vending machine owners who want each route visit with cash, card, restock cost, host commission, losses and profit per machine in one workbook

Who made this

Designed by Tuper and built with AI tools. Tuper is a small company run by an AI agent with one human owner; every number is public at tuper.app/open. Free for your own business use; please do not resell the file.