Free spreadsheet examples

Spreadsheet templates for cashflow and team workflows

Start with a Google Sheets copy or download an XLSX file. Every template uses synthetic example data, and its formulas have been checked in Google Sheets.

Actual Google Sheets rental property balance sheet showing assets, liabilities, and owner equity

Property planning

Rental property balance sheet

Record assets, outstanding liabilities, and calculated owner equity for one property as of a specific date. Includes synthetic balances, tenant deposits, and editable inputs. This is a point-in-time planning example, not a cashflow report or independently audited accounts.

Personal cashflow template open in Google Sheets

Personal finance

Personal cashflow planner

Plan six months of income, essential and flexible expenses, and a tax reserve. Monthly surplus and six-month totals recalculate from the editable inputs.

Sales deal tracker template open in Google Sheets

Sales operations

Sales deal tracker

Track synthetic deals by stage, amount, probability, expected close date, and owner. Includes an import-and-model exercise that maps by deal ID and checks duplicate IDs. Weighted pipeline is separate from the unweighted scheduled deal forecast; neither represents collected cash.

Spreadsheet practice data and QUERY exercise in Google Sheets

Learning

Spreadsheet practice data

Practice removing whole blank rows, preserving record relationships, copying results as values, comparing frozen expense snapshots with live totals, and using SUMIFS. The Google Sheets copy includes a QUERY exercise; the XLSX download uses portable formulas and sample source data.

Apps Script recipient planning template open in Google Sheets

Workflow planning

Apps Script recipient planner

Estimate planned recipients and headroom using editable example caps. The examples do not establish current quotas or reset timing; check Google’s current documentation for your account.

Google Sheets cleanup controls showing preserved records and reconciled amounts

Data cleanup

Transaction cleanup at 10,000 rows

Identify wholly blank rows without discarding incomplete records. Compare record counts and amount totals before and after cleanup, with separate checks for zero, whitespace, and formulas that display an empty string.

Google Sheets audit showing recipient occurrences, distinct addresses, and quota warnings

Workflow planning

Recipient audit at 10,000 rows

Screen synthetic To, CC, and BCC recipient rows, compare daily example caps, and flag messages with too many recipient rows. Repeated addresses across messages remain separate recipient occurrences. Syntax checks do not establish deliverability or live sending quota.

Google Sheets cost calculator showing missing prices and an incomplete forecast

Cost planning

Monthly automation cost forecast

Open Cost calculator to separate subscription, API, Cloud and external-provider forecasts. Unknown prices keep the total incomplete. Uses a USD subscription benchmark and synthetic workload; amounts are before tax, not cash paid. The XLSX contains the cost tab only.

The examples contain synthetic data only. The spreadsheet practice template’s QUERY exercise is for the Google Sheets copy; the XLSX download contains the practice data and portable formulas.