0 ITEMS
ControllingSpreadsheets related to controlling tasks
Job Cost Tracker – Excel Template
A straight forward dashboard tool that helps any organization track hours / billings across multiple crews / crew members.
Inventory Valuation Using FIFO – Automatically Calculate COGS Accordingly
Any accountant that needs to comply with IFRS will have to use the FIFO valuation method for calculating their cost…
Countback method for DSO – DIO – DPO Best Practice (Includes countforward method!)
The right way to compute DSO DIO DPO - Using the countback method, fully automated!
Price Volume Mix Charts and Analysis – On revenue and Gross Profit by Product
Best practice model for a complete Price Volume Mix (PVM) analysis on revenue and on gross profit by product.
Inventory Management and Analysis Model Excel Template
Inventory Management and Analysis Dashboard. Useful to the Management team, financial controller as well as to external financial analyst.
Recurring To-Do List Manager – Google Sheets
An automated tracker of recurring to-do items. Visuals included.
Zoo/Aquarium or Park: 5-Year Excel Financial Planner
Comprehensive financial model to plan out the cash requirements of a Zoo, Aquarium, or Park. Includes construction and on-going operations.
Ratio-Based SaaS Model – Smarter Scaling Logic
This model makes it easier to forecast the scaling out of a SaaS model that is dependent on Account Executives…
General Use 3 Statement Financial Model – With Exit Assumptions
Monthly and annual summaries of the income statement, balance sheet, and statement of cash flows. Easy user entry on schedules.
Inventory Re-Order Level – Available in Excel and Google Sheets
This is a useful tool for anyone managing inventory purchasing. You can run the model, daily, weekly, or, monthly based…
Cash Flow Statement Template with Budget Versus Actuals Analysis Excel
Cash Flow Projection Template Highlights One-year Cash Flow Projection template is a useful tool for cash flow forecasting and for…
Tracking KPI Performance: Scoring by Performance Category
This template is a ready-to-use KPI tracker that displays performance over a 12-month period. Grades on a scale of 1…
Make Scheduling Easy – Excel Template
This is a weekly schedule builder. It works in excel, but there is also a google sheet version in the…
Sales Pipeline Financial Model Bundle
A collection of financial model templates in a bundle for Sales Pipeline. Included in the bundle are the following templates:…
Revenue Goal Tracker – Actual vs. Plan
Track the annual value of your contracts based on YTD billings and current year remaining billings.
Client Pipeline Manager with Up to 6 Stages
This template makes it easy to always have a current snapshot of all your clients and where they are in…
Re-Stocking / Re-Supply Inventory: Cash Flow Planning
A 12-month inventory cash requirement forecast based on varying lead times and re-purchase rates.
Apartment Complex Cash Flow and Valuation
A nice deal builder for valuing and analyzing apartment building cash flow.
Manufacturing 5-year Template – Customer Repurchase Rate Logic
A versatile template to forecast out a manufacturing or retail sales business that is built around customer re-purchases.