Immediate benefits for your business:

If you use MYOB and have 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 budgets in Excel

• Create budgets from templates that integrate with MYOB as quickly and simply as possible.

Benefits include:

For all Businesses using MYOB

• Create Monthly General Ledger Account Budgets in Excel instead of, and faster than, the time taken to enter them into MYOB.

• Have the ability to report 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.

• Have the ability to create account based departmental budgets and analysis reports. (is Cost Centres, Stores, Bars / Gaming Departments)

• Budget for both Profit & Loss and Balance Sheet accounts.

• 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

• Quickly create monthly General Ledger Account budgets and analysis reports from templates that are professionally designed for businesses using MYOB.

• Easy to add and link new General Ledger Accounts in your budget.

• 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

• Link your existing budgets in Excel with MYOB to automatically update the Actual columns of your budgets with MYOB Data.

• Extend the functionality your existing budgets by including Last Year, Year To Date and Average analysis columns.

How it works:

'BudgetLink - Account 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 Account Number, Year and Month. The functions calculate and return values when you open or recalculate your worksheet.

The functions provided include:

AccountActivity(Account,Year,Month)

This function returns the Actual account activity for a selected Account, Year and Month

BudgetLink Integrates with:

MYOB Premier v5, v6 v7,v8 v9, v10 & v11

MYOB Accounting Plus v11, v12, v13, v14, v15, v16 & v17

MYOB Accounting v11, v12, v13, v14, v15, v16 & v17

Minimum System Requirements:

Windows XP or Vista.

Excel 2003 or Excel 2007.

Version 6 or higher of Microsoft Internet Explorer.

(MYOB ODBC Driver license is included.)

Licence

'BudgetLink - Account Budgets' is sold with a 3 user licence. Additional user licences are available upon request.

Support Options

Consulting is provided on a time and materials basis.

Other Budgeting Products

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.

For more information

Contact Jeff Stephenson by:

Phone +61 08 8377 2144
Mobile 0419 862 410
Fax: +61 08 8311 1718

Email enquiries@accountingaddons.com.au