Template library
73 templates in this category.
Accounting & BookkeepingPetty Cash Log
Track small cash expenses with automatic date ranges and running balance calculations.
- Automatic date range headers with MIN/MAX functions
- Running balance calculation with error handling
- Subtotal formulas for expense summaries
Accounting & BookkeepingPetty Cash Reconciliation Template
Track and reconcile petty cash transactions with automatic balance verification and variance detection.
- Automatic balance calculations with SUM formulas
- Variance detection between expected and actual cash
- Transaction logging with date and amount tracking
Accounting & BookkeepingPetty Cash Template V13
Track and reconcile petty cash expenses with integrated chart of accounts and weekly balance verification.
- Chart of Accounts reference for expense categorization
- Daily transaction log with date, receipt, and description fields
- Weekly reconciliation sheet with calculated vs. checked balance verification
Accounting & BookkeepingProfit and Loss Statement
Track monthly income and operating expenses with automated net income calculations and visual charts.
- Multi-sheet structure (Income, Operation Expenses, Summary)
- Automated net income calculations with SUM and SUBTOTAL
- Monthly column breakdown (Jan–Dec)
Accounting & BookkeepingProfit and Loss Statement
Track revenue, expenses, and net profit across quarterly periods with automated calculations.
- Quarterly income and expense sections
- Automated net profit calculation
- Percentage-of-sales analysis for benchmarking
Accounting & BookkeepingProfit and Loss Statement
Track revenue, costs, and net profit over time with automated P&L calculations.
- Automated subtotals and net profit calculation
- Revenue and expense categorization
- Flexible period tracking (monthly or yearly)
Accounting & BookkeepingProfit and Loss Statement
Track revenue, expenses, and net profit with automatic calculations for monthly or yearly periods.
- Automatic revenue and expense totals
- Net profit calculation with conditional formatting
- Customizable company name and reporting period
Accounting & BookkeepingPTA Reimbursement Form
Track and process PTA expense reimbursements with requestor details and automatic calculations.
- Requestor name and contact fields
- Request date tracking
- Itemized expense entry with amounts
Accounting & BookkeepingQuarterly Cash Flow Projections
Project and track quarterly cash inflows and outflows to forecast liquidity and plan for operational needs.
- Monthly breakdown within quarterly periods
- Estimate vs. actual comparison columns
- Variance tracking to measure forecast accuracy
Accounting & BookkeepingReal Estate Profit and Loss Template
Track rental property income and expenses with automated monthly P&L statements for real estate investors.
- Monthly P&L columns with automated date calculations
- Pre-built income and expense categories for real estate
- Automated net income calculations with SUM and IF formulas
Accounting & BookkeepingRental Property Income and Expenses Model
Track monthly rental income and operating expenses across 12 months with automatic totals.
- Monthly income and expense breakdown
- Automated total calculations per month
- Transaction categorization and dating
Accounting & BookkeepingRental Property Income and Expenses Tracker
Track monthly rental income and expenses across 12 months with automated totals and categorization.
- Month-by-month income and expense separation
- Automated total income calculations per month
- Transaction categorization and date tracking
Accounting & BookkeepingSales Profit and Loss Statement Template
Track company revenue, expenses, and profitability with a structured P&L statement covering a defined period.
- Pre-structured P&L format with revenue and expense sections
- Automated SUM formulas for profit calculations
- Company name and period fields for clear identification
Accounting & BookkeepingSelf Employed Profit & Loss Template
Track income and expenses monthly to calculate self-employed business profit or loss.
- Monthly P&L columns with automatic date calculations
- Company name and logo header
- Full financial year layout (12 months)
Accounting & BookkeepingSimple Cash Flow
Track incoming and outgoing cash across periods to maintain healthy liquidity and forecast cash availability.
- Current period vs previous period comparison
- Company and manager identification fields
- Automatic SUM calculations for cash totals
Accounting & BookkeepingSimple Cash Flow Statement for Small Business
Track cash inflows and outflows with indirect, direct, and simplified methods for accurate financial reporting.
- Three cash flow methods (indirect, direct, simple)
- Period-ending statement headers with date fields
- Automatic SUM formulas for activity categories
Accounting & BookkeepingSimple Cash Flow Template
Track incoming and outgoing cash across periods to forecast liquidity and manage working capital.
- Period-by-period cash tracking
- Current vs. previous period comparison
- Manager and completion tracking
Accounting & BookkeepingSingle-Step Income Statement Template
Track revenue, expenses, and net income with a simple single-step income statement format.
- Company name and date fields
- Single-step revenue minus expenses calculation
- Automatic net income computation
Accounting & BookkeepingSmall Business Cash Flow Projection
Project monthly cash inflows and outflows to forecast balance and identify cash shortages ahead.
- Monthly cash inflow and outflow tracking
- Ending cash balance calculation by month
- Minimum balance alerts and visual warnings
Accounting & BookkeepingSmall Business Cash Flow Projection
Project cash inflows and outflows to maintain healthy reserves and avoid cash shortages.
- Monthly cash inflow and outflow tracking
- Automatic cash on hand calculation with SUM formulas
- Visual combination chart comparing projected cash to alert thresholds
Accounting & BookkeepingSmall Business Profit and Loss
Track revenue, expenses, and net income to understand your business profitability.
- Automatic net income calculation
- Revenue and expense categorization
- Time period tracking
Accounting & BookkeepingSmall Business Profit and Loss Template
Track revenue, expenses, and net profit with a professional P&L statement for your business.
- Automated revenue and expense calculations
- Professional P&L layout with period ending date
- Built-in formulas using IF and SUM functions
Accounting & BookkeepingT Account Ledger
Track debits and credits with running balance in traditional T-account format for accurate bookkeeping.
- Debit and credit columns in T-account layout
- Automatic running balance calculation
- Sample data for Contoso Ltd
Accounting & BookkeepingTrial Balance Worksheet
Track debits and credits to verify accounting accuracy and identify posting errors quickly.
- Account type classification (Asset, Liability, Equity, etc.)
- Automatic SUM calculations for debit and credit columns
- Beginning balance tracking