We are pleased to announce that the ExcelReportLink List Reports now include a bulk jobs updater which allows you to make changes to jobs in bulk.

You can use it to quickly update all the job numbers or job names.

Click on images above to enlarge.

At this stage, it is only available in the Pro Edition.

In addition, we have included a Jobs List report which is available in All Editions.

To download the latest version of ExcelReportLink List Reports, go to the ExcelReportLink List Reports download page.

Jeff Stephenson
Managing Director | Solution Architect

Situation

MYOB has custom lists and these need to be udpated in bulk

Procedure
1) Export the list to Excel

2) Add the New Name in Column D

Save as text file and import back in.

Set import option to Update existing data

Match all fields

The list is now updated

MYOB have released the 2014.3 update of MYOB AccountRight live.

You will need to upgrade ODBClink:

• if you are using ANY version of MYOB AccountRight live on the cloud;
• if you are planning on upgrading to MYOB AccountRight live 2014.3 and are using it locally, on a server or in the cloud.

Upgrading ODBClink is FREE for all users. You can download the latest upgrade of ODBClink (v3.42.7.109) as well as read the terms from the following link.
http://accountingaddons.com.au/odbclink/upgrade

You can find the upgrade instructions on our wiki.
http://accountingaddons.com.au/wiki/budgetlink/index.php?title=Upgrading_ODBClink

For more information about ODBClink, go here.
ODBClink Home

We hope this update makes a difference.

Jeff Stephenson
Managing Director | Solution Architect

We give away functionality to solve the core accounting problems
Charge a low monthly fee for functionality that solves the complex problems
Assist you with high end consulting services at an hourly rate

Currently our reporting add-on software integrates with Xero Online Accounting.
It works by connecting to the Xero API

Our solutions integrate with the following MYOB accounting products, editions and versions:

MYOB AccountRight Live
All editions including AccountRight Live Basics, AccountRight Live Standard, AccountRight Live Plus
Version 2019 and all earlier versions including Version 2013.

MYOB AccountRight Classic
All editions with the MYOB ODBC Driver including AccountRight Enterprise, AccountRight Premier and AccountRight Standard
All versions up to v19.9

Steps to cleanse an MYOB AccountRight Classic data file

1. Contact us to discuss your data cleansing requirements.
   We will then provide an estimation
2. If you choose to proceed then we will forward an invoice for 50% of the minimum expected amount. Upon notification of payment we will schedule in a time to perform the processing. Typically this will be over the week end.
3. Optimise and backup your MYOB data file
4. Click this link to open Dropbox
5. Enter your Name and Email address
6. At Subject enter [Your Company Name] MYOB Data file
7. Select your zipped MYOB data file
8. Select any supporting documents required to match records. ie a list of matching duplicates
9. In the Notes field enter your MYOB Administrator Username and Password and confirm that the MYOB data file has been optimised. Also include any instructions on what you want us to do
10. Click Send it
11. Ensure that users do not make changes to MYOB during processing
12. When processing is complete an email will be sent with a link to a zipped copy of your cleansed MYOB Data file.
13. Download and unzip the MYOB Data file and make it the current version.
14. Check that the MYOB data file appears OK.
15. When OK advise users that they can log back onto MYOB.

BudgetLink – Specialised Functionality – Price on Application

Functionality that requires consulting to implement and may require some development depending on what is required.

• Simultaneous MYOB Category and Job budgeting and reporting
• Set up and monitor account ratios and KPI’s like Current and Debt to Equity ratio’s
• Publishing Scripts – Published sets of reports and distributes to users.
• Overnight Upload – Used if you have many or large data files or many users. Pulls data from from sources overnight so that reports are immediately available
• Company Eliminations using Categories – Track and eliminate inter-company transactions using categories.
• Data Archiving – Archive MYOB actual data to allow detailed reporting into historical years even when transactions are purged in MYOB.
• Consolidate data files across different accounting systems
• Quotes and Orders Version – Report in a profit and loss and balance sheet format. Combine with Actuals to create a forecast
• 13 4 weekly period reporting
• [4, 4, 5] weekly reporting periods
• Cash flow reporting by Job
• Benchmarking
• Cash flow Statements and Forecasts – Split by Operating, Investing and Financing Activities
• EBIT and EBITDA Reporting
• Job Linked Customer Hierarchy – Report Profit and Loss by Job Linked Customer
• Security – Setup users and restrict them from accessing selected reports and divisions (jobs)
• Integration with MYOB EXO

Download BudgetLink for FREE

BudgetLink Home

A comprehensive solution that solves your core reporting problems:

• Capture monthly budget data and compare with actuals by group, company, job and account
• Print a 12 monthly budget on one page
• Report variances (standard or impact) by month, range, year to date, annual forecast, last year comparison etc
• Generate forecasts with actuals to date and budget to the end of the year or beyond
• Apply ageing to budgets to generate cash flow forecasts.
• Compare balance for the current month vs the same month last year.
• Consolidate multiple (unlimited) data files. Report PL, BS & CF with companies across the page
• Report before last year and beyond next year. Report with years going across the page
• Report at account and job header levels or consolidate multiple jobs by selecting them
• Audit transactions not allocated to a job or category.
• Apply subtotals to values while maintaining variance formulas
• Show or hide accounts with or without budget and actual values.
• Report Profit and Loss with jobs across the page at any job level
• Report Profit and Loss and Balance sheet with years across the page.
• Generate Board-ready industry standard reports and financial statements out of the box
• Simplify your reporting. Generate many reports from a few flexible templates by choosing what data to display.
• Maintenance free. New companies, accounts and jobs are inserted automatically while maintaining formulas
• Analyse GL performance in the layout your choose using Pivot Tables, Query Tables and Charts
• Set up multiple (unlimited) instances of BudgetLink and configure for multiple groups of companies or accounting clients
• Streamline custom reporting by creating your own reporting databases that link with MYOB tables using ODBC
• Fully customisable and upgradeable. Choose columns to display. Change order by dragging and dropping in Excel.
• Utilise the inbuilt Excel functions to pull account movements and balances into your existing reports

Price – Free

Download BudgetLink for FREE

Back to BudgetLink Editions