Template library
81 templates in this category.
Accounting & BookkeepingRental Property Income and Expenses Model
Track rental income and operating expenses with monthly budget vs. actual comparison for property investments.
- Income sheet with rental period date tracking
- Expense categorization and detailed logging
- Monthly budget vs. actual summary comparison
Accounting & BookkeepingRestaurant Monthly Profit and Loss Statement
Track weekly P&L performance across a month with automated sales, costs, and shareholder scoring.
- Five pre-built weekly P&L sheets
- Automated shareholder score calculations
- Sales and expense line items with formulas
Accounting & BookkeepingSaaS Cash Flow Forecast Template
Project 12-month cash flow and monitor actual vs. forecast performance for SaaS businesses.
- 12-month rolling cash flow projection sheet
- Separate cash flow statement for actual tracking
- Pre-built SUM and VLOOKUP formulas for automated comparisons
Accounting & BookkeepingSmall Business Cash Flow Forecast Template
12-month cash flow projection tool for small businesses to forecast revenue, expenses, and cash position.
- 12-month rolling forecast
- Automatic running cash balance calculation
- Sample business data included
Accounting & BookkeepingSpecial Journal Template V13
Track cash, purchases, and sales across linked journals with automated chart of accounts integration.
- Separate cash, purchase, and sales journal sheets
- Integrated chart of accounts reference
- Automatic date capture with MAX formulas
Accounting & BookkeepingStatement of Total Recognised Gains and Losses
Track annual recognised gains and losses to measure comprehensive financial performance.
- Year-ended date tracking
- Multi-period comparison columns
- Recognised gains and losses itemisation
Accounting & BookkeepingSupplier Reconciliation Template
Match supplier invoices to payments and resolve discrepancies with automated reconciliation.
- Automated supplier contact information pull-through from setup sheet
- Reconciliation comparison table for invoice and payment matching
- Formula-based discrepancy flagging with IF and AND logic
Accounting & BookkeepingTax Calculation & Lookup Reference Tool
Calculate income tax and retrieve company contact details using formula-driven lookups and conditional logic.
- VLOOKUP formula to search company by name and return contact details
- IF/THEN logic to compute progressive income tax rates
- Support for both single and married filing status
Accounting & BookkeepingUneven Cash Flow Calculator
Project and manage irregular cash inflows and outflows with date-based calculations and financial forecasting.
- Date-based period tracking
- PV/FV financial calculations
- Irregular income and expense scheduling