The PC HelpSite
www.officehelp.biz
Office Tutorials & Software Solutions
Specializing in Advanced Spreadsheet & Office Macro Solutions.
BudGex - Budget Generator for Microsoft® Excel®

Application Microsoft Excel Version 1.00
Author OfficeHelp
Tested on versions: 2000 (9.0), XP (10.0), 2003 (11.0), 2007 (12.0), 2010 (14.0), 2013, 2016 - should work on any version from Office 97

Create your own adjustable Budgets and Profit statements for Microsoft® Excel® at the click of a button. All formulas are automatically generated. Define Income and Costs categories and click Run to generate the Budget file with all formulas includes. Automatic Total and Sub-Total Columns per Period (Quarter, Semester, Year) andCategory (Operational Income, Fixed Costs, Operational Costs). Fully Customizable look. Ideal for Small Business, Personal and Department level use.

Contact Us for Support

  FREE DOWNLOAD

Creating Budget files for Microsoft Excel ? Need to control Income / Expenses? Struggling with formulas?

Create your own Budget files without writing a single formula for Excel. Just define the Income & Cost categories and click the Run button.

BASED ONLY ON EXCEL - No installation or setup required. Just open in Excel and run!

The easy way to create budget files for Excel.

Screen Shot from the Microsoft® Excel Macro File

PIC. 1 - Screen Shot from the Macro File for Microsoft Excel (Click to Enlarge)

The system will generate a new workbook with the resulting Budget (PICs. 2). This new workbook HAS NO MACROS on it, just the resulting budget. Change, save and email it as any other regular file for Microsoft Excel.

Extremely Easy to Use - Just 4 Steps

  1. Define the Time Frame
  2. Enter product details like Name and Price
  3. Enter categories for Income, Fixed Costs and Overheads
  4. Click the Run Button
  5. Sit down and watch! – (Click here to download a FREE Demo)

Sample Budget File (with no data entered) -  (Click to open a full page PDF)

PIC. 2 - Sample Budget File (with no data entered) -  (Click to open a full page PDF)


Creating Excel Budget files? Need to control Income / Expenses? Struggling with Excel formulas?

Create your own adjustable Budgets and Profit statements for Microsoft Excel at the click of a button, without writing a single Excel formula. Just define the Income & Cost categories and click the Run button. All formulas are automatically generated.

Ideal for Small Business, Personal and Department level use:

  • Personal Finance - Keep track of your income and expenses. Know what you’re spending and keep within your limits.
  • Small / Personal Business - EASILY track your sales, costs & profits. Elaborate Budgets and Forecasts without an Excel master. Automatically calculate periodic totals (quarters, etc) and ratios (profit margin, etc):
    • Ebay sellers
    • Internet business
    • Personal business
  • Corporate Use at Department Level - Elaborate department level Budgets. Track personal or group expenses.

Click HERE for the FREE DOWNLOAD

EXCEL ONLY - No installation or setup required. Just open in Excel and run!


Excel / Office Consulting Services

Like this product but need a specialized version? Prefer to have the changes professionally applied? Need a completely different Excel product for your own purpose?

Contact us here with your request and we will issue a quick estimate. Estimates are free and do not constitute any obligation to purchase the service.

Services also available for other Microsoft Office applications like Outlook, Word, Powerpoint,etc.


Fully Automatic Calculations: No need to enter your own formulas

  • Automatic Variable Costs for Products
  • Automatic Sub-Totals per Category (Operational Income, Fixed Costs, etc )
  • Automatic Sub-Totals per Period (Quarters, Semesters, Years, etc)
  • Automatic Ratios & Averages
    • % of income that this Product / cost represent
    • COGS – Cost of Goods Sold
    • Gross & Profit Margin
    • Average daily sale in the period

Ratios and Sub-Totals

PIC. 3 - Ratios and Sub-Totals

All ratios and sub-totals are calculated by standard Excel formulas generated by the macro – they will recalculate immediately as numbers are entered on the budget files.

Easy to understand and track calculations – only standard Excel formulas are used on the generated Budget file.

Fully Customizable by Example (no complex settings)

Just format the sample cells on the Config sheet the way you want it. The Budget file will copy your formats you define to the corresponding cells on the final Budget file:

Sample Formating Cells (Config Sheet)

PIC. 4 - Sample Formating Cells (Config Sheet)

All text labels can be customized / replaced, from month names to labels like “Operational Income”, as well as columns widths


Creating Excel Budget files? Need to control Income / Expenses? Struggling with Excel formulas?

Create your own adjustable Budgets and Profit statements for Microsoft Excel at the click of a button, without writing a single Excel formula. Just define the Income & Cost categories and click the Run button. All formulas are automatically generated.

Ideal for Small Business, Personal and Department level use:

  • Personal Finance - Keep track of your income and expenses. Know what you’re spending and keep within your limits.
  • Small / Personal Business - EASILY track your sales, costs & profits. Elaborate Budgets and Forecasts without an Excel master. Automatically calculate periodic totals (quarters, etc) and ratios (profit margin, etc):
    • Ebay sellers
    • Internet business
    • Personal business
  • Corporate Use at Department Level - Elaborate department level Budgets. Track personal or group expenses.

Click HERE for the FREE DOWNLOAD

EXCEL ONLY - No installation or setup required. Just open in Excel and run!


Excel / Office Consulting Services

Like this product but need a specialized version? Prefer to have the changes professionally applied? Need a completely different Excel product for your own purpose?

Contact us here with your request and we will issue a quick estimate. Estimates are free and do not constitute any obligation to purchase the service.

Services also available for other Microsoft Office applications like Outlook, Word, Powerpoint,etc.


Contact Us for Support   FREE DOWNLOAD


Get FREE PC TIPS every month:

 

www.OfficeHelp.Biz

(c) 2004 - 2024 OfficeHelp.Biz