|
Ultimate Excel Budgeting, Forecasting and Reporting Solutions for MYOB
Automate your Excel Board and Management Reports, Departmental Budgets and Forecasts and Consolidated Financial Statements with MYOB Accounting data exactly the way you want them.
At Accounting Addons, we provide Excel solutions that link with and enhance the functionality of MYOB Accounting software. Our products and services are innovative, flexible, powerful and easy to use.
Our Solutions include:
If your Solution
is not listed above, please
click here
to enquire
Enterprise level Solution automates
your Board and Management Reports, and your Budgeting and Forecasting
requirements, customised to exactly the way your management team want
them, in Excel. Some of the features include:
-
Captures budget data by Company,
Job, Account, Year and Month
-
Allows multiple Versions
and Years of Budgets
-
Allows Job Manager, Contacts
and alternative Job Hierarchies
-
Consolidates Profit and Loss
and Balance Sheet Reports
-
Handles multiple dimensions
of data, allowing reporting not possible from pivot tables
Our clients who turn over more than
$2m, such as mining companies and Not For Profit organisations, experience
the following Benefits:
-
Their existing reports (previously
updated manually in Excel) are now fully automated, providing reduced
risk of re-keying errors and corrupt spreadsheet formulas.
-
They can generate their reports
for management on demand without delay.
-
Reduced recurring cost of
generating reports, as preparation time is significantly reduced ?
from hours or even weeks, to only minutes each month.
Having all the Features and Benefits
of BudgetLink-Enterprise Solution (refer above), some additional features
of this version include:
-
Allows you to implement the
standard Chart of Accounts to account for multiple projects
-
Automates acquittal forms
-
Industry-standard P&L
reports and forecast charts in Excel designed specifically for Not-For-Profit
organisations; easily and fully customizable.
Automate the process of creating
an ABA file to debit money directly from your customers? bank accounts
and credit cards. It works by:
-
Automating Customer Payments
in MYOB
-
Generating the ABA file or
Credit Card file to upload to the bank.
-
Similar operation to MYOB?s
electronic payments function, except it facilitates instructing the
bank to collect money from customers (as opposed to paying money to
suppliers).
Our clients who have over 1000 recurring
customer payments each month, such as associations and security companies,
enjoy the following benefits:
-
Reduced time of recording
customer payments
-
Automated accounts receivable
process
-
Keep the process in house
and significantly reduce transaction costs
-
Improved cash flow by controlling
when customers pay
Automates the process of collecting,
authorising and recording timesheets into MYOB.
-
Employees/Contractors record
times in a normal Excel timesheet
-
This can be your existing
Excel Timesheet
-
Jobs and activities can be
selected from drop down lists
-
Timesheets are sent to the
Payroll Manager for review
-
Payroll Manager imports timesheets
directly into MYOB with the click of a button
-
Can allocate employees?
wages expense across multiple Profit and Loss Accounts
Our clients who have more than 50
employees who complete timesheets manually or in Excel experience the
following benefits;
-
Assurance that timesheets
are completed correctly
-
Automated payroll calculations
simplify the checking and authorising process
-
Saved time as no need for
Payroll Manager to re-enter timesheets
-
Eliminate Data Entry Errors
-
More visibility and control
with wages expenses
Automates the process of recording
recurring invoices in MYOB with rules that vary each month. Some of
the features include:
-
Ability to modify existing
recurring transactions with rules
-
Ability to update item prices
in recurring sales in bulk
-
Ability to change the header
to describe product or service for period
-
Automatic association of
products and prices to card custom lists
Our clients who have over 1500 recurring
sales each month, such as associations and security companies, have
the following benefits:
-
Avoid updating and editing
every invoice individually each month
-
Reduced errors
-
Reduced stress
-
Ability to generate invoices
on time
We can automate your repetitive
tasks in MYOB that cannot be achieved using import and export including
-
Deleting old Jobs and Items
-
Deleting identifiers in cards
-
Changing the recurring transaction
types
Our clients who have tasks to be
repeated over 1000 times such as organisations with a large customer
database or many jobs:
-
Avoid the tedious task of
editing thousands of existing records manually
-
Avoid hours of frustrating
labour time
-
A web enquiry form is added
to your website that sends leads to you via email
-
The leads data received in
Outlook is written into the database automatically
-
Provides reports that calculate
the quantity of leads from different sources
-
Converts lead information
into useable format
-
Allocate leads to Call Centre
Staff to follow up / action
-
Reports that help to measure
the performance of marketing and Call Centre Staff
Our clients who have a website with
a web enquiry form that forwards contacts via email to their Call Centre
enjoy the following benefits:
-
Eliminate the process of
typing up contact information
-
Gain control of leads processes
to ensure customer contact is timely and consistent
-
Monitor the effectiveness
of marketing campaigns
BudgetLink
- Excel
Account
Budgets for MYOB
, integrates your
MYOB General Ledger data
with Microsoft Excel, the ultimate budgeting platform, to create powerful,
flexible and easy to use account
budgeting and forecasting solutions.
BudgetLink
- Excel
Job
Budgets for MYOB
, integrates your
MYOB Job Profit and Loss
data with Microsoft Excel, the ultimate budgeting platform, to create
powerful, flexible and easy to use job
budgeting and forecasting
solutions.
Our Excel related services include:
MYOB Addon Solutions Development
We custom build unique MYOB-integrated business solutions. We specialise in developing Excel Add-Ins and Workbooks with Macros that integrate with MYOB using either the MYOB ODBC driver or MYOB reports to meet your specific requirements. Our main focus is creating budgets and reports that you can work with in Excel.
Excel Function Add-Ins
Customised Excel Add-Ins that provide you with functions in Excel to automate calculations or return data into your spreadsheets from lists or reports. Can be inserted into your spreadsheet the same way as the sum or subtotal functions in Excel
Excel Macro Development
Customised Excel Add-Ins that provide you with tools to automate repetitive tasks in Excel such as formatting a report, merging data, deleting duplicates from lists etc.
Excel Consulting
Provide assistance with complex formulas, merging lists, extracting data from lists etc.
Benefits to You:
-
Enable MYOB to grow with you:
MYOB is a fantastic off-the-shelf accounting software package and goes a long way to making business processes easier. However, it cannot be all things to all people and remain easy to use. We provide solutions so that it can
be all things to you - now and as you grow and evolve. As you reach the limits of MYOB, choose to add-on to its functionality, rather than incur the time and cost of converting to a new accounting software package.
Why use Excel:
Software is developed by creating and manipulating objects. An object can be a worksheet, a row or a cell. Excel makes available its vast array of objects for us to manipulate. There is no need to recreate them. For example, by programming within Excel we can read data from MYOB reports, create a new worksheet, insert a row and enter data or formulas into cells.
The benefits to you are that Excel solutions can be created faster costing you less and have more power, functionality and flexibility than would be possible if creating them from scratch using a programming language (i.e. Visual Basic).
Our experience includes:
-
Developed MYOB BASLink version 1 while employed
as a Business Analyst / Developer at MYOB
-
MYOB Certified Consultant
-
Financial Modeller for Aerospace Industries
Ecommerce
consultant at Strate
For additional information:
Please click on the links above or contact
us on
Tel:
08 8377 2144 or 0419 862 410
Email: jeff@accountingaddons.com.au
|
