Budgeting Tool

Posted on February 21, 2019

Developed in Microsoft Excel, the Budgeting Tool generates projected financial statements.

Multiple Gross Profit Scenarios

  • Revenues
  • Cost of Goods
  • Variable Costs
  • Fixed Costs

Combine Gross Profit Scenarios per Month

  • By percent of capacity
  • By number of days
  • By any other unit of measure

Capital Expenditures

Recurring Transactions

Irregular Transactions

Project Financial Statements

Interactive drill-down to audit projected financial statements

  • Double-click any value to see where it originates.
  • Quickly isolate sources for busy accounts, like Cash.
  • Budgeting Tool - Drill-down Screenshot

Cascading Defaults

  • Minimizes inputs
  • Overriding defaults per month provides unlimited control when required.
  • Killer combination provides power and ease-of-use.

Developed on a tight deadline to replace the less-useful budgeting features in Quickbooks, the Budgeting Tool successfully produced projected financial statements within two weeks of the start of development.