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

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

Bulk Deletion and Merging of inactive MYOB Records We provide a service where by we can identify inactive record either by the inactive status and or last sale date and then proceed to either delete or merge those inactive cards or items

Identify and Remove Duplicate Cards – We can start by providing a list of cards that are possible duplicates based on Postcode, Name and Address for you to match, and then automate the process of deleting or merging the duplicates