Powerful, flexible and easy to use job budgeting solutions
'BudgetLink - Job Budgets' combines your MYOB Accounting data with Microsoft Excel, the ultimate budgeting platform, to create powerful, flexible and easy to use job budgeting and forecasting solutions.
Immediate benefits for your business:
If you have separate reporting entities (i.e. departments, cost centres or stores) use MYOB and have job budgets or analysis reports in Excel
Automate the process of entering actual values into those budgets at the end of each month.
If you use MYOB and want to create job budgets in Excel
Create job budgets from templates that integrate with MYOB as quickly and simply as possible.
Benefits include:
For all Businesses using MYOB
Create Monthly Job Budgets in Excel to budget for departments, cost centres or stores.
Have the ability to report Job Actual, Budget, Last Year, Year To Date and Average values for each month.
Have the ability to report Dollar and Percentage Variance analysis values each month.
The actual values in your budgets and analysis reports update automatically at the end of each month.
Links with your MYOB Accounting Data without additional licensing fees.
WORKS FAST. Budgets are updated in seconds, even with large Premier Data files.
Multi-user capabilities. Works across a network.
Create customised and automated analysis reports.
To have the ability to report at different levels of detail (like MYOB report levels 1,2,3 & 4).
Link multiple accounts to one budget row. ( ie link all MYOB Motor Vehicle expense accounts into one general Motor Vehicle row in your budget)
Have the flexibility to design budgets and analysis reports the way you want.
Create budgets for MYOB's Last Year and Next Year without rolling over your MYOB data file each time.
Create multiple versions of budgets to forecast the best case and worst case scenarios.
Having access all of Excels features ie Inserting and deleting rows, copying and pasting rows and cells, inserting formulas and functions, insert your logo and business colour scheme and much much more.
For Businesses starting a new Budget
To quickly create monthly job budgets and job analysis reports from templates that are professionally designed for businesses using MYOB.
Easy to add and link new accounts in your budget.
Easy to add new jobs to your budgets
To have the ability to lock the worksheet, allowing your to work while maintaining the integrity of formulas and functions.
For Businesses with existing Budgets in Excel
To link your existing job budgets in Excel with MYOB to automatically update the Actual columns of your budgets with MYOB Data.
To extend the functionality your existing budgets by including Last Year, Year To Date and Average analysis columns.
How it works:
'BudgetLink - Job Budgets' provides you with functions to paste into your budget worksheet cells. These functions calculate and return monthly actual values. The actual values are MYOB General Ledger Account Activity values for a selected Job, Account Number, Year and Month. The functions calculate and return values when you open or recalculate your worksheet.
The functions provided include:
JobActivity(Job,Account,Year,Month)
This function returns the actual account activity for a selected Job, Account, Year and Month
Version 4 or higher of either Microsoft Internet Explorer or Netscape Navigator
MYOB ODBC Driver license is included.
Licensing
'BudgetLink - Job Budgets' is sold with a 3 user licence. Additional computer licences are available upon request.
Support Options
We provide support on a time and materials basis.
Other Budgeting Products
BudgetLink - Account Budgets integrates your MYOB General Ledger Account data with Microsoft Excel, the ultimate budgeting platform, to create powerful, flexible and easy to use budgeting and forecasting solutions.
