Accountants use spreadsheets for a lot of different things and Microsoft Excel essentially allows one to organize data and make calculations. At the core, this is what we do in Accounting. The Excel templates below are built for specific tasks and activities that are common for the average accounting professional to do. Most of the other templates on this site are for pro forma creation / projections but below you will find something different. It is more along the lines of calculators and tools.
$249.00 USD
(Immediately Downloadable After Purchase)
Trackers and Tools
- Sale-leaseback Analysis - 4 points of view, NPV output, accounts for tax effects.
- Activity-Based Costing Model - Up to 23 activities, 30+ products, and simple inputs.
- 13-Week Cash Flow Planner - Budget vs actual, dynamic line items, waterfall charts.
- Financial Statement Generator - Monthly/QTR/Annual IS, BS, CF (accrual or cash).
- Accounts Receivable and Payable - Database entry for invoices + aging reports / summaries.
- 90-Day Cash Flow Manager - Designed for real-time use. Build a cash balance forecast.
- Depreciation Expense Tool - Track 95 fixed assets and their resulting depreciation expense.
- Budget vs Actual Tracking Template - General forecast for budget and actuals + variance.
- Profit / Loss - Enter revenue an expense items in a database, resulting Profit/Loss populates.
- Expense Tracker - Track monthly expenses and compare against a budget.
- To-Do List Tracker - Track how often you have done certain tasks and the due date per task.
- Task / Project Tracking - A Gantt style timing display to show projects happening in parallel.
- Financial Statement KPI Tracker - All logic and outputs for KPIs related to financial health.
- Tracking Billable Hours - A full system to track your billables hours by client. I use this.
- Job Costing - Track the hours and cost per job and report by crew, crew member, job type.
- Job Success KPI Dashboard - Track historical gross margins of construction jobs.
- Payroll KPI - Keep track of payroll budget vs actual, overtime hours / cost, and more.
- Side Gig Profit and Loss - Track multiple revenue streams, expenses, and cash flow.
Calculators
- Absorption Costing - Calculate cost per unit for each step of the manufacturing process.
- Discount Bond Model - Calculate interest income using effective interest rate method.
- Sales and Purchases on Account - 3-Statement Helper - Forecasting logic for A/R, A/P, more.
- General Loan Amortization - Two loan types (regular and line of credit), flexible scenarios.
- Job Bidding - Inputs for various wages / labor, other direct costs, and fees.
- Cost Segregation Study - Input data about all property types and compare tax savings.
- Equipment ROI - A cost benefit analysis with dynamic sensitivity tables, IRR, and more.
- Volume Discount Pricing - Plan discount curves, taking into account volume/margins.
- WACC Calculator - A simulation calculator with formulas on all WACC components.
- Payroll Calculator - Calculate and track payroll each period. Add a tab for each new period.
- FIFO COGS Calculator - Enter a log of purchases and a log of sales, this calculates COGS.
- Depreciation Recapture - Tax effects of depreciating an asset over time and selling.
- Cash Conversion Cycle - Calculates CCC days and allows one to track this over time.
- Royalty Licensing Analyzer - Compared fixe fee per sale to percentage per sale models.
Inventory
- Inventory Forecast - Based on payment terms, lead times, safety stock, sales history.
- Inventory Tracking: Multiple Locations - Shows unit counts per SKU per location.
- Inventory Reordering - Organize your reordering. Displays a 'hot list' and prioritization.
- G Sheets Inventory Management - Shows unit counts per SKU per location w/ database.
- Inventory Management Single Location - Track unit count / value of inventory per SKU.
- Inventory Template Simplified - A simple log of inventory in and out + balance per SKU.
- Simple Daily Tracker - Enter inventory received count and used count by day and by SKU.
Projection Models
- Loan Securitization Platform - Facilitator of deals, collects fees (upfront/ongoing).
- Loan Securitization - Model an underlying loan pool and 3 note offering tranches.
- Staffing Forecast - Plan your expected payroll expenses for up to 20 departments.
- Lending Business - Full financial model with financial statements for scaling loans.
- 3-Statement Model Template - General forecasting model with financial statements.
- Break-even Analysis - Enter fixed and variable costs to see resulting break-even revenue.
Other Helpful Templates
- Cabinet Job Estimator - Configure cabinet types, count, and produce job cost / invoice.
- Cap Table - Includes convertible note, 5 initial stakeholder groups, sensitivity table, more.
- Inventory in 3-Statement Model - Learn the accounting formulas for inventory forecasting.
- Manufacturing Sensitivity - 21 data tables with simple and complex underlying models.
- Loan Portfolio Analysis - Drop in your loan tape data and automatically produce KPIs.
Purchasing on a mobile device? No problem. You will receive an email with a download link for the purchased files that you can access on any spreadsheet friendly device later (desktop / laptop).
Check out all financial model templates in one bundle here. There are also great discounts when buying by category.
