Template library
73 templates in this category.
Accounting & Bookkeeping12 Month Cash Flow Forecast
Project monthly cash inflows and outflows to manage liquidity and financial planning.
- 12-month rolling projection with expected vs actual columns
- Monthly period comparison structure
- Automated SUM formulas for period totals
Accounting & Bookkeeping12 Month Cash Flow Forecast
Project monthly cash inflows and outflows to manage liquidity and plan for operating expenses.
- 12-month rolling forecast with expected vs. actual columns
- Month-by-month cash inflow and outflow tracking
- Automatic SUM calculations for cash position
Accounting & BookkeepingABC Company Accounting Spreadsheet
Basic accounting template for small business with company details and sum functions for calculations.
- Company information header
- Pre-built SUM formulas
- Contact details field
Accounting & BookkeepingAccount Excel Starter Template
Manage invoices, receipts, and cash flow with built-in expense tracking and stock reports.
- Invoice and receipt templates
- Cash-in-hand dashboard (daily tracking)
- Product category expense sub-categories
Accounting & BookkeepingAccount Register
Track deposits, withdrawals, and balances with automatic calculations and visual charts.
- Automatic running balance calculation
- Transaction date and description fields
- Deposit and withdrawal columns
Accounting & BookkeepingAccounting Balance Sheet Template
Track assets, liabilities, and equity to measure your company's financial position at a glance.
- Automated SUM formulas for asset and liability totals
- Date stamping with TODAY function
- Clear section structure for assets, liabilities, and equity
Accounting & BookkeepingAccounting Spreadsheet
Track income, expenses, and financial activity with a basic accounting ledger framework.
- Auto-calculated totals with SUM functions
- Accounting period organization
- Business name and header fields
Accounting & BookkeepingAccounting Spreadsheet
Track financial records with basic SUM functions for period-based accounting entries.
- Business name field
- Accounting period header
- Automatic SUM calculations
Accounting & BookkeepingAccounting Worksheet
Track company financial transactions and balances with organized worksheets for ABC Company.
- Company header section
- Automatic SUM calculations
- Transaction tracking
Accounting & BookkeepingAccounts Payable Template
Track vendor invoices and payment obligations to manage cash flow and supplier relationships.
- Automated total calculation across all invoices
- Date tracking for payment deadlines
- Supplier name and invoice number organization
Accounting & BookkeepingAccounts Receivable Tracker
Monitor customer invoices by aging buckets to prioritize collections and improve cash flow.
- Customer invoice tracking
- Aging period buckets (0-30, 31-60, 61-90+ days)
- Amount columns by aging category
Accounting & BookkeepingAnnual Cash Flow Calculator
Track monthly cash inflows and outflows to project annual liquidity and cash position.
- 12-month cash flow projection by category
- Automatic monthly and annual summaries
- Year calculation from input date
Accounting & BookkeepingBalance Sheet Template
Track assets, liabilities, and equity with automated calculations for complete financial snapshots.
- Automated SUM formulas for asset and liability totals
- Assets, liabilities, and equity sections
- Built-in balance verification (Assets = Liabilities + Equity)
Accounting & BookkeepingBalance Sheet Template
Track assets, liabilities, and equity with a professional balance sheet that shows financial position across periods.
- Multi-period comparison columns
- Automatic SUM calculations for totals
- Professional formatting for balance sheet structure
Accounting & BookkeepingBusiness Bookkeeping Excel Spreadsheet
Track income, expenses, inventory, and sales tax with automatic calculations and setup guidance.
- Income transaction entry
- Expense tracking and categorization
- Inventory overview dashboard
Accounting & BookkeepingCash Advance Reconciliation Template
Track and reconcile cash advances by employee, ensuring accurate reimbursements and compliance.
- Employee and department tracking
- Advance amount vs. actual expense comparison
- Automated reconciliation calculations with SUM and IF logic
Accounting & BookkeepingCash Book Template
Track all cash receipts and payments with automatic totals for complete financial records.
- Dated cash receipt and payment columns
- Automatic SUM totals for receipts and payments
- Period comparison (current vs previous)
Accounting & BookkeepingCash Flow Diagram Generator
Create visual cash flow diagrams with automated calculations to track money movement and identify bottlenecks.
- Auto-calculated cash flow totals
- Visual flow diagram
- Inflow and outflow tracking
Accounting & BookkeepingCash 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
Accounting & BookkeepingCash 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
Accounting & BookkeepingCash 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
Accounting & BookkeepingCash 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
Accounting & BookkeepingCheck Register
Track checks written with automatic balance updates and transaction reconciliation.
- Automatic running balance calculation
- Check number and date tracking
- Debit/credit transaction columns
Accounting & BookkeepingCheck Register
Track all checks written and deposits made with automatic balance calculations.
- Automatic running balance calculation
- Check number and date logging
- Transaction description field