Posted on

Exporting Employee information from MYOB

Export MYOB reporting data to Microsoft ExcelWe use this blog post to introduce new content for our online MYOB training courses as well as our Excel, Word and WordPress courses. This new content has been created after a MYOB Course Q&A Support request from Andrea in New Zealand.

We wrote a blog post in September 2011 about data file formats that are used in our MYOB Bank Reconciliation Training Course. In that blog post we wrote about exporting the accounts list that MYOB uses as the foundation for the company file and that all transactions are then based on. This accounts list is known in the accounting world as your Chart of Accounts.

Today we announce some new training videos for our MYOB Reporting and GST Course (code 504). It covers the exporting of Payroll information from MYOB of employee card files and Payroll information using both the Report Centre in MYOB AccountRight version 12 as well as the Import/Export wizard.

As an EzyLearn student you receive LIFETIME access to the MYOB Training Courses so feel free to login to the training site and go to the GST and Reporting Course to view videos 504301 and 504302. If you are not a student learn about what’s included in our training courses and see why hundreds of students enrol with us every year.

Posted on 1 Comment

Search our blog posts for your answers

Search the EzyLearn blog for PAYG and Microsoft ExcelWe’ve written over 200 blog posts since 2008 and we’ve found them to be very popular but some readers have mentioned that it is hard to go back and find ones that they were very interested in reading again so we’ve done something simple. Added a search box. I know, it seems simple but it took a reader to ask for us to implement it. Thank YOU 🙂

While we are on this topic, did you know that we use WordPress to manage our blog site? It’s a great blogging platform but even fantastic for just creating a normal website that you can edit and make changes to as you please. The best part is that it’s open source so effectively it’s free! All you have to do is learn how to use it and we have a course just for it, our WordPress Website Design Course and just like our MYOB Training Courses it comes with LIFETIME student access.

So, if you want to find out the blog post where we wrote about PAYG tax tables and how you can workout the taxes that you owe for employees doing a search for “payg excel” and you’ll come up with these results. See what else you can discover.

Posted on 1 Comment

Launch: Career Support Services for MYOB Certificate Students

Today we announce the official launch of our Student Career Support services. We have a new team member on board and her role is to help us provide extra support to help students find, apply for and get their next bookkeeping job.

When you enrol into our MYOB Bookkeeping Training Courses with the lifetime membership and certificate option you will now receive access to our Career Support Services for free. We’ll help you find bookkeeping jobs, prepare your resume and cover letters as well as follow-up letters and letters of recommendation for students who join our Bookkeeping Academy CPD program.

Not only will you learn new skills using Australia’s leading accounting software program, lifetime access to use the training material as your own personal resource and a Certificate, but we’ll help you refine your job seeking skills and tools to help you get your next bookkeeping job.

Posted on 1 Comment

Do an MYOB Training course and get webinars for free

Webinar for MYOB bookkeeping training courses and student support onlineAs part of the research into our Continuing Professional Development (CPD) program for MYOB training course students we are exploring different webinar platforms and we thought you’d be interested to learn about it. For existing EzyLearn students it will mean free MYOB Bookkeeping webinars in the coming months.

We’re proud of our online MYOB training courses and thousands of students are too, but we’ve found that students are interested in lots of other skills relating to earning money for themselves as either an employee or a contractor. Things like using Word to write a resume, using WordPress to manage their own website, how to use online CRM (Customer Relationship Management) programs to keep track of all their contacts etc. We mentioned in a early blog post about our plans to provide more training resources for working mums and we’re getting closer to our final goal.

The purpose of a webinar is to deliver educational content similar to what you would experience with a seminar except that you save on time, travel, money, petrol and you can even watch the presentation at a later date. Our team has been in contact with accountants, career professionals, online service providers and a host of other industry professionals who will be providing information, training and tips and tricks at our webinars and I hope you can join us in this journey.

If you are an existing student and have some idea or suggestions of topics that you would like us to cover, this is your chance. Send your suggestions to sales@ezylearn.com.au and we’ll discover the most popular and work on a schedule for the rest of the year. If you are not a student yet, this is the time to enrol. Stay tuned for more updates shortly.

 

Posted on

Google Maps makes you street smart

Google Maps and Computer Shops Parramatta MYOB training coursesHave you ever tried to use Google Maps to get directions to your next appointment? I had a recent experience that made me realise why Google Maps makes you street smart.

Many years ago when we had street directories we could see exactly where we needed to go. We could choose our own path based on our knowledge of the roads and of traffic patterns. Now Google gives you suggestions, but I am not sure they are always the best suggestions.

I’ve been using Google Maps to find local training companies around Sydney as well as computer shops, employment agencies, job network agencies and other companies in the career and recruitment fields so that I can tell them about our MYOB Bookkeeping Training Courses and bring them on board as partners. I know that many of us take it for granted these days, but I am reminded of how powerful our mobile phones and internet searching has become! I wrote about this for local business marketing back in 2010 in my personal blog.

I’ve gone to Google Maps on my Android Smartphone and searched for computer shops and up comes a map with a whole bunch of dots and placemarks (like in the image). If you click the place mark you get information about that business and can then call them directly from this information! Google users can also write reviews about your business so watch this space.

Google Android Screen shot of Google Maps local search info
Click on the image to see it enlarged on your screen…

You also have the ability to get directions and this is the part that I always find interesting. Having grown up in Sydney I know how to get around and often I am presented with driving suggestions that I don’t agree with. When I use my gut instincts I end up getting to the destination on time and without frustration and I wanted to share this with you because I think it demonstrates that technology is only here to make our lives easier. We still have to make the right decisions regarding the information that technology gives us.

In the end your own experience will tell you which way to go and there is no better feeling than using and trusting in your own instincts. Google Maps makes you street smart because your own local knowledge is often better than that of a machine and it’s always good to trust your own instincts.

PS. It’s interesting to see a photo for JB Hi-Fi that appears to be from someone’s bedroom…

Posted on

Where to go to help your bookkeeping clients?

Bookkeeping_Academy_CPD_program_for_MYOB_Training_CoursesAs part of our CPD program for bookkeepers we are discovering, compiling and happily sharing the results of our research. In this blog post we reveal a valuable link of essential tools for bookkeepers.

As a bookkeeper you help you clients with ABN information, Business Activity Statements, Payroll and PAYG Informtion and a host of other activities. It is also common for you to be more accessable than a business’s own accountant so you are often asked for official information relating to communications with the Australian Tax Office.

This link is an essential tool for bookkeepers because it contains a table of links and instructions about topics you may be asked about as a bookkeeper.

Posted on 2 Comments

Could Linkedin replace the written resume?

Linkedin hands searching for potential bookkeeping employeesI’ve written a series of blog posts about various aspects of resume writing and other tips you can use to help secure the next great job and it’s fitting that we explore why Linkedin is a serious place for you to promote your MYOB Bookkeeping skills.

I was fortunate enough to attend a social media club (Sydney) education event that was presented by the managing director of Linkedin and he went to great lengths to explain just how deep the company wants to go into the recruitment and talent market. Upon visiting various parts of the LinkedIn website I found some links that might further encourage you to recognise the importance of Linkedin in your employment or business building journey.

Linkedin has a page for talent departments and case studies for companies that have used their services and employers can even place recruitment ads within the site to clearly target the right job applicants.

We found a great article written by Susan Heathfield about how Linkedin is being used as a recruitment tool for the HR team at many businesses. Do you need help in your job searching strategy? Stay tuned.


We will shortly be announcing a fantastic special offer regarding Linkedin and resume writing for all students who take advantage of our forthcoming Bookkeepers’ Continuing Professional Development (CPD) Program. This program is a new service as part of our MYOB training courses. Make sure you subscribe to receive this information in your email inbox.

 

 

Posted on 1 Comment

ATO says write-off $6500 of capital purchases in the 2013 financial year

business asset depreciation for 2013 financial year with ATO and MYOB bookkeeping coursesThere have been some big tax changes this year and as part of our Bookkeepers Continuing Professional Development Program and our MYOB Training Courses we’re writing some short articles about key information that you can pass onto your customers or employers regarding their bookkeeping.

In conjunction with the recent announcements regarding the carbon tax, the ATO has made significant changes with regard to the Tax Free Threshold and Write-off for capital purchases.

Businesses with less than $2M turnover previously had to depreciate any assets which cost more than $1,000 over several years. From 1 July 2012 this has changed to a whopping $6,500. If you buy an asset valued at say, $5000, it can be “expensed” straight away, no need to include it in your depreciation schedule. It’s like an instant expense which reduces your taxable income .

The benefits are aimed towards smaller business owners as it affects their cash flow almost immediately, rather than being depreciated and split over a number of years. Want to receive these tips and tricks in your email inbox? Subscribe now and remain continually updated.

Would you like to see an example of how to manage asset depreciation and writing off assets using MYOB accounting software?

The ATO is allowing businesses to write-off more assets than before without having to depreciate them.We’ve added new training content to our MYOB Reporting course about how to handle these tasks at the end of each financial year as part of our constant content updates. Make sure you subscribe to this blog to be abreast of all new training content as well as some free tips and tricks.

To find out more, click the ATO’s link here: Small business concessions: changes to simpler depreciation rules apply from 2012-13

Posted on 4 Comments

Is being a work-at-home mum like being on holidays?

cloud based voip telephone systemsOne of the great benefits of being a work at home mum is being able to watch your kids grow up while you take some time out to do work. Since we operated computer software training centres in 1999 many of our students have been either working mums or mums returning to the workface after spending many years in babyland and for many it has been a difficult change.

We’ve always noticed that many mums look to enter the workforce in the bookkeeping field because the work is not time critical yet requires a good skill level that ends up paying well. The great news is that bookkeeping is moving further and further into the cloud so you can now literally do the books from your home.

We’re proud to say that we have a team of work at home mums keeping the engines running at EzyLearn Online. Our MYOB training courses are some of the most popular MYOB courses in Australia and we are able to provide them at their current prices because of the work-from-home mums that are part of our team.

Our business utilizes some state-of-the-art software as a service (SaaS) tools available today and we’re committed to helping all work-at-home mums learn the skills they need to ensure that they can have the work-life balance they are looking for. Our Work-at-home mums use VIRION business grade voip telephone services, HighRiseHQ online CRM, our online learning platform and our online student support system that manages queries from students.

Where you live has never been less important than now. As long as you have a good broadband internet connection and the skills to use cloud based applications you can earn a living while bringing up your children.

To those work at home mums reading this blog post we want you to know that we have some exciting announcements between now and the end of this year about the plethora of online software applications that enable you to earn a living from home while looking after your kids. If you haven’t subscribed yet, feel free to do so and receive updates as they are announced.

Stay tuned for announcements of new courses planned in the coming 6 months…

Posted on

Why spend in June if you’ll just owe in July?

MYOB Profit and Loss Report and balance sheet in reporting training courseConversations amongst business colleagues and business owners appear to suggest that many people are in a rush to spend before June 30. I spoke with someone who feverishly exclaimed that everyone should get private medical insurance! It’s all good and well to get in a panic before the end of the financial year but if you didn’t have the correct information before now and the decisions you make are not based on known facts then why make them?

It’s the time of year where all the data entry from Day-to-Day Transactions should be up to date, you should know the value of depreciation for your fixed assets and have a good idea of the value of your tax and GST liabilities. A profit and loss report and balance sheet will provide you with the information you need and if these figures are ready then spending decisions can be made. This is the time for reporting and reconciliation.

If you simply find yourself with money in the bank but don’t want it to go to the tax man think again, you might need it to pay your liabilities next month. For now, enjoy the bulging bank balance.

Remember. Compliance is the measure of success of your business plans so be compliant as soon as possible every month.

Posted on 1 Comment

Is the money really owed to you? Then pursue it!

Get paid on time using MYOB, Xero or SAASU - accounts receivable
Image from Sydney Morning Herald article about difficult payers on September 14th 2011

I was reading an article about difficult payers and the steps that some companies need to take to chase money that is owing to them and thought that this is something that every MYOB Bookkeeper needs to be aware of.

There seems to be perception (and most of the bad news seems to come from the building and construction industry) that payment of debts is something that should be stretched out as far as possible. I was discussing this concept with a colleague and was interested to find that this person believes that payments should be stretched out as long as practical. The interesting part of this conversation is that this person is a very reasonable man. He believes in long term investments and dealing with every person in a fair and reasonable manner, so it was strange for me to hear this mentality.

If you commission someone to do some work for you, shouldn’t they be entitled to be paid on the same terms that an employee is entitled to? I think so and you’ll find some skills to find out who owes you money in our MYOB Day-to-Day training course.

Here are the steps that are recommended:

  1. Charge in Advance if you can
  2. Chase money owing early
  3. Provide multiple payment options
  4. Be as up-to-date as possible
  5. Enforce your trading terms
  6. Be honest about non-paying clients
  7. Give customers an opportunity to complain
  8. Be polite
  9. Get heavy on time

A leading author of MYOB and Small Business “How to” books, Veechi Curtis says that the squeaky wheel gets the grease. So, chase money as soon as an account falls behind. Perhaps a more relevant saying is “work with the willing”. There are many people who value the work you do enough to pay you before the due date. There are customers who can afford what you do and want you to think positively of them so they pay as early as practical.

Find customers who want to be good to you!

This blog post is an introduction to articles that will be coming shortly for the continuing professional development of the bookkeeping academy so make sure you subscribe to receive updates via email.

References taken from an article in the Sydney Morning Herald on September 14th 2011.

 

Posted on

Don’t be afraid, connect with the ATO via Business Portal

ATO Business Portal to lodge your BAS online using MYOBAre you still receiving your Business Activity Statements via mail? We receive our notification that the BAS is ready at the ATO’s Business Portal but the Business Portal is much more useful than just a way to deliver your BAS.

There are some great features of online tax lodgement:

  1. You can lodge your BAS immediately online
  2. You can see historical lodgements
  3. You can change your contact details

The most complicated part of dealing direct with the ATO is the setting up of a digital certificate, but once that is sorted out you have all the convenience that you have come to expect from your internet banking and any other online service. All the information is there, you don’t have to rely on the mail to send or receive your BAS and you know exactly where you stand. If you have missed a lodgement you’ll also find that information at the portal.

The website address for the portal is https://bp.ato.gov.au/ so check it out and get through your compliance issues faster.

MYOB GST, reporting and BAS training coursesOur MYOB Reporting, GST and BAS course (which includes bank reconciliation) shows you how to get to the BASlink to produce a BAS using the data that you have already entered into MYOB. If you have entered everything correctly you will just need to complete your contact name and number and how long it took to complete. Then you can print that form out and keep it in your records. The information you see in the totals can then simply be entered in the Business Portal and submitted to lodge your BAS and get your compliance tasks out of the way so you can focus on running your business.

Posted on

Do you want to see the results of our online MYOB quiz attempts?

Learn how to make the most of MYOB bookkeeping softwareWe’ve made a simple online MYOB quiz available for anyone who wants to test their MYOB bookkeeping skills. It’s a very simple test designed to show people how online knowledge tests work and also have some fun and see how much they know. We did an export of all the results (minus the students details of course) and you can see them in our Microsoft Excel Training Course.

These test results show how long it took students to complete the test, their results, overall score and more and the datafile is available in our Microsoft Excel Course 308 which includes:

Understand 3D formulas between worksheets, cleaning up data using advanced filter, create a pivot table and change the value field settings, create a pivot chart to visually show the stats, using advanced functions like CHOOSE, VLOOKUP, HLOOKUP, MATCH and INDEX, look at advanced functions within functions (Nested Functions) and how to protect the worksheet and workbooks

The knowledge reviews in our online training courses are much bigger and more complicated and they provide us with a great tool to identify areas of difficulty for students and help us constantly update and improve our MYOB training courses.

Posted on 1 Comment

Does your business innovate or compete?

Red Ocean Blue Ocean from Dr Sarah Laytons Blog
Red Ocean Blue Ocean from Dr Sarah Laytons Blog

At a recent business owners breakfast I heard someone speak about blue ocean and red ocean strategies. I’m going to write some blog posts about how to build your business as part of our project to help our MYOB students start, maintain and build their own bookkeeping businesses and this article is a fitting way to start.

The Blue Ocean strategy involves finding new demand in an uncontested market which essentially means to innovate. This essentially means create something new, but I think for many small business it could means package your services so that you can demonstrate a difference between your bookkeeping business and others. The Red Ocean strategy is all about competing head to head with your competitors to try to get existing customers to move away from someone else to use your services. You can get a better idea of what Blue Ocean strategy is at their website.

We try to innovate in our services by offering lifetime access to all courses, provide all skill levels in one course (ie. beginners to advanced) so you don’t have to waste time trying to figure out which level you are at and provide different versions of training for Microsoft Word and Excel (ie. 2000, 2003, 2007 and 2010.

This table shows the key differences between the strategies. See which strategy you are pursuing.

Are you looking at starting or growing your business?

Cert IV small business management coming soonDo you want to start a business? Do you want to create a business plan? Does it all seem a bit daunting?

[quote]We are working with Maggie Richardson, author of “Starting a business in Australia” to get her Cert IV in Small Business Management online.[/quote]

This course not only gives you a well rounded education of the requirements to start and build a small business, but you will end up with one-to-one help in creating a business plan as part of the course! Read more..

Posted on 1 Comment

Should we offer MYOB Training Courses to group buying companies?

group-buying-sites-choice-review-discounted-MYOB-training-course
Image from Choice website

We’ve been approached by many different Groupon type companies. There seems to be hundreds of these sites popping up every day and they are famous for offering you almost unbelievable discount coupons for almost anything but most commonly services like pedicures, restaurant and cafe meals etc. We’ve always ensured our prices are competitive and bookkeeping students receive good value for money, but our Training Partners have tried them and we’ll share their opinions with you.

For business owners (or merchants as we are called) group buying sites promote the possibility of receiving hundreds of sales of your product (so you better make sure you can service the demand) but what do they want in return. Here’s a classic scenario:

Normal Price: $200

Group Buying Price: $100

Saving to you: $100

Margin that goes to the Group Buying Site is typically 50% of the discounted price, ie. $50

This means that a merchant that would normally receive $200 for something, will now receive $50! Is it worth it? Then why not just sell it on special for $100 and spend some money advertising it? As you can see, we are pessimistic about the future of group buying sites. Our training partners workface.com.au offered a discount on their Microsoft Excel training courses only to receive a handful of sales.

choice_group_buying_reviewAnd there are hundreds of these group buying sites. See if you can recognise some of these names: Cudo, Groupon, AlltheDeals, Spreets, Living Social, Grabone, BizzBuzz etc. At the beginning of 2011 a local Australian startup in the space was sold for $40M! If you have time read a review by Choice Magazine.

The main reason we don’t like the big group buying sites is because of some of the conditions imposed.

When you buy the discount voucher the group buying site earns the money. Some of the more selfish sites will then only pass this money to the merchant when the customer uses the voucher. In other words, if the  customer doesn’t use the voucher within the “valid period” the merchant earns nothing and the customer loses the benefit!

By the way, I was at a software training function last week and a birdy told me that consumer protection laws might come into affect that provides protection for buyers of these discount vouchers – if you buy a $50 product then you can receive $50 off after the offer period has expired. Watch this space…

As far as discount coupons, we make them available to you. Just tell us what you are looking for in a training course and you’ll automatically receive a discount coupon code for our MYOB, WordPress and Excel training courses.

Posted on 2 Comments

Discount code for online MYOB Bookkeeping and WordPress Website Design Courses

cheap MYOB training coursesWe recently wrote about why more and more mums are looking to work from home as a virtual assistant and perform bookkeeping tasks using MYOB. Mums are also becoming website designers using the free website building software called WordPress.

We just wanted to remind you that if you are a mother or a stay at home dad and you want to learn these programs so you can work from home while bringing up your children, we want to offer you a discount.

Just tell us what you are looking for in an online training course and instantly receive your discount to one of our online training courses.