Template library

Cash Flow Tracker

Monitor and forecast your business cash position with automated calculations and real-time balance tracking.

Automated SUM calculations for cash totals
Running balance tracking
Pre-formatted cash flow summary section

Cash Flow Tracker Template

Track monthly cash inflows and outflows to understand your liquidity position and cash movements.

Monthly period tracking with date functions
Automated calculations using SUM formulas
Pre-built sections for operating, investing, and financing activities

Cash Receipt Template

Track cash payments received with customizable receipts and carbon slip copies.

Customizable company name and details in Settings sheet
Auto-populated dates using TODAY() function
Conditional receipt numbering with IF/ISBLANK logic

Cash Receipts Template

Log and validate cash receipt transactions with automated amount verification and data validation.

Automated amount validation using IF and OR formulas
Receipt numbering system
Date tracking for each transaction

Cashflow Matrix

Track daily cash positions across multiple accounts with rolling date columns and automated summation.

Auto-incrementing date columns (EDATE formulas)
Row summation across accounts or cost centers
Conditional lookup with HLOOKUP and ISNA error handling

intermediate.xlsx

Catholic Church Budget Template

Plan and track church finances with dedicated sections for tithes, donations, operational costs, and ministry expenses.

Auto-calculated budget totals with SUM formulas
Visual charts comparing revenue and expenses
Dedicated sections for donations and tithes

Business Planning & Strategy

CFROI Holt Valuation Model

Calculate cash flow return on investment and enterprise valuation using the Holt CFROI framework with discount rate analysis.

Multi-period cash flow projections with discount rate application
Gross CFROI and investment return calculations
Cost of capital and project lifecycle configuration

advanced.xlsx

Marketing

Channel Marketing Budget

Plan and track marketing spend across channels with monthly sales forecasts and budget allocation.

Channel-based budget rows for different marketing channels
Monthly columns for sales and spending data
Anticipated Sales Total calculation with SUM formulas

Channel Marketing Budget

Plan marketing spend across channels with monthly budget tracking and sales projections.

Monthly budget columns by channel
Anticipated sales total row with calculations
Rate and allocation labels

Chart of Accounts

Organize and track all your business accounts with a structured accounting framework.

Account number assignment system
Account name and description fields
Account type classification

intermediate.xlsx

Check Register

Track all checks written and deposits made with automatic balance calculations.

Automatic running balance calculation
Check number and date logging
Transaction description field

Check Register

Track checks written with automatic balance updates and transaction reconciliation.

Automatic running balance calculation
Check number and date tracking
Debit/credit transaction columns

Check Register with Transaction Codes

Track checks, debits, and payments with coded transactions and running balance calculations.

Transaction code legend for fast data entry
Running balance calculation with auto-update
Subtotal functions for transaction type summaries

Checkbook Register

Track deposits, withdrawals, and balance in your checking account with categorized transactions.

Automatic running balance calculation
Customizable transaction categories
Payee tracking and lookup

Education & Academic

Child Attendance Sheet

Track daily attendance records for classroom or childcare settings with automatic counting.

Daily attendance columns by date
Student name roster
Automatic attendance counts

Human Resources

Childcare & Gym Attendance Sign In Sheet

Track child check-ins and check-outs with parent details and time logs for childcare and gym facilities.

Separate sheets for childcare and gym sign-ins
Child and parent name fields
Time in and time out tracking

Human Resources

Childcare Sign In Sheet

Track child check-ins and check-outs with parent details and timestamps for daycare or gym facilities.

Child name and parent name fields
Time in and time out tracking
Date field for each sign-in session

Chore Chart

Assign household chores by person and day to keep everyone accountable and tasks organized.

Day-by-day chore assignment grid
Task and assignee columns
Weekly rotation view

Chore Chart Template

Weekly chore assignment tracker to distribute household tasks fairly among family members.

Day-by-day task columns
Clear task descriptions
Flexible for any household size

Chore Chart Template

Assign household tasks to family members by day of the week for organized shared responsibilities.

Day-by-day task assignment grid
Family member name rows
Task columns for each day of the week

Chore Chart Template

Assign weekly household chores by day and person to keep everyone accountable.

Day-by-day task breakdown
Person assignment columns
Kitchen and common area tasks

Christmas Gift Planning Table

Track Christmas gift budgets by recipient and organize spending limits for holiday shopping.

Recipient name list
Individual gift budget amounts
Automatic total spending calculation

Calendars & Scheduling

Christmas Potluck Sign Up

Coordinate your holiday potluck with an organized sign-up sheet for dishes, guests, and assignments.

Automatic RSVP count with COUNTIF
Event details section (date, time, location)
Guest name and dish tracking

Church Budget Template

Plan and track your church's annual finances with built-in categories and visual charts.

Pre-built expense categories
Automatic sum calculations
Visual budget charts