Posted on

Sometimes “Real World” Marketing, Not Digital, is More Appropriate

start your own business
It’s not unusual to obtain new work because people in need of your services spot you working on your current job. But chance is one thing – how can you improve the odds of making this happen?

IF YOU’RE A TRADIE, working as a plumber, builder or carpenter, handyman, gardener or electrician, then you probably already know that some of the best jobs come by referral.

Identify “real world” marketing opportunities

During my recent renovation of an investment property in Newcastle, most of the good tradies would tell me, “Someone you’re working on a job with on Monday will ask you to do a job for them somewhere else on Friday, or a neighbour of a client will ask you to do some work for them.” I soon saw from other tradespeople how “work can come to you just because someone happens to be walking by while you’re on the job” — gardeners get a lot of work this way, for example.

The important thing in this scenario is to act efficiently in finding out what the potential client needs, finding out what else is important, and then selling them on your services. I recently had the pleasure of interviewing Kristine Seymour, an experienced sales person and business builder, for the Sales Training Course at the Australian Small Business Centre (ASBC). She spoke in detail about how to act when your future income depends on how well you can sell. This Sales Training Course is available on the EzyLearn LMS.

Take advantage of business opportunities

This course is also available to new licencees for the National Bookkeeping Business Opportunity. The key to getting new clients is to be proactive and take advantage of these on-the-spot business opportunities by using some “real world” marketing tactics. These skills can be used even if you are just looking for part-time clients or doing bookkeeping or marketing as a side hustle — more on side hustles in a forthcoming blog. 

Some “real-world marketing” examples

Another good example of a real-world marketing tactic is to conduct a letterbox drop in the local area where you’ve just started work. Clearly, this lets residents in the area know you’re working there, what you do, and that you are available.

This alone may lead to thousands of dollars in additional revenue if even just a few people get in touch. But always, it’s vital to keep track of what marketing you do and where leads are coming from. It’s vital to schedule quotes and start dates for work and so forth, and have a handle on Office Productivity Software like Microsoft Office or Google G Suite. These will not only help you organise your workload, but you’ll also appear organised and professional to your clients.

***

Learn more about both digital and face-to-face (networking) marketing in our EzyStartup Training Course. Visit our website for more information or to enrol.


learn online training Xero courses videos for less

Our Xero online training courses include EVERYTHING for ONE LOW PRICE. Furthermore, if you select our Lifetime Membership option, you’ll have LIFETIME access to our ongoing course updates. All EzyLearn courses are accredited by the Institute of Certified Bookkeepers (ICB) and can be counted towards Continuing Professional Development (CPD) points. Find out more about our Xero online training courses.


REF #688

Posted on

How to Reduce Your Fail Rate in Business by 50%

What You Can Do this Christmas

business start up online training course christmas holidays2
There’s lots to do in preparation for starting a business and the summer holidays is a good time for the ground work.

DID YOU KNOW research shows that by taking just one short course on small business management, the chance a business will fail is reduced by as much as 50 percent.

This is because business mismanagement is the primary reason businesses fail; the other most common reason is because owner/s fail to implement appropriate credit management processes. In both cases, this failure has come about because the owners, directors, partners or managers lacked the appropriate management skills to make it a success.

Learn the basics in business

The Christmas holidays is a perfect time for taking the steps needed to start your small business. While everyone else has gone on holidays, you’ll be ready to take on your first client or customer by the time business really starts kicking off again at the end of January.

business start up online training course christmas holidaysSo let’s get to it: there’s work to be done. And this work generally requires some rudimentary knowledge of Australian tax law, copyright law, trademarks and patents.

You should also have knowledge of particular software applications, and digital marketing.

Other key areas of business you need to know

The key areas business owners should understand before starting a business include:

Ordinarily, to become skilled in each of those areas, a person would have to take, at least, five different training courses. But few people are ever likely to do this. Instead, they’d be more likely to cherry pick the areas they’re least familiar with, and fly blind with the others. Needless to say, that’s where people run into problems.

Take Advantage of our Christmas Savings!

We don’t want you to wing it or fly blind — our goal is to help small businesses succeed which is what we’ve been doing for nearly 20 years.

We cover what you need to set up a small business in our EzyStartUp Business Course, priced at just $297. This course covers each of the key areas mentioned above that a small business owner needs to be familiar with, in addition to the following:

  • Originating and developing concepts
  • Establishing legal and risk management
  • Product packaging
  • Marketing your business

***

When you enrol you will also receive FREE ACCESS to a bunch of our other online training courses, including Xero Set Up and Beginners’ Excel and Word.

Our Last Dasher Sale is also on now with special Christmas discounts on our online training courses in social media, and cloud accounting software (MYOB, Xero) and Excel, Word and WordPress.


Don’t Wait — Become the Head Honcho Today

Use your time off from work this summer to begin working on your new small business. All of our training courses are delivered online, and can be completed at your own pace, so you can complete them while you’re actually on holidays, or relaxing at home or at a cafe.

And since one of the best ways to start a new business is by operating it as a side project to your other job, if you get all the start up stuff out of the way while you’re on holidays, it’ll be ready to go by the time you back to work.

Learn more about the EzyStartUp Business Course at our website or view all of our special offers to save on your next EzyLearn training course.

start your own business online training course videosAnd as a gift to you, remember our Bookkeeping Basics Guide is yours’ for free!


 

Posted on 1 Comment

Is Xero Better than MYOB for Bookkeeping Businesses?

MYOB or Xero online accounting course training videos

Bookkeeping Incumbent, MYOB Versus Cloud Innovator, Xero

MYOB or Xero online accounting course training videos

MYOB HAS LONG BEEN the preferred accounting software of choice for accountants, but a lot of small business owners have now come to prefer Xero. It’s easier to use, and they can access it anywhere — their desktop PC, tablet or smartphone.

Meanwhile, the rise of cloud-based accounting software, which was pioneered by Xero, has made it a lot easier for bookkeepers to base themselves from home.

Throw in other technological innovations — cloud storage, bank feeds — and a remote Xero bookkeeper has become the more appealing choice for businesses, too.

Continue reading Is Xero Better than MYOB for Bookkeeping Businesses?
Posted on

3 Little Mistakes that Cost Thousands

online training learning tradesmen carpenter painter plumber electrician turning quote into sale

How tapping into your Smartphone can win you work

I RECENTLY WROTE about a Tradie Charging Too Little. In this I covered the four tell-tale signs, as told to me by a tradesperson friend of mine, that your prices are too low. But there are other business mistakes that owners, particularly tradespeople, make that can wind up costing them thousands in lost revenue — and when I say revenue I don’t just mean from existing clients but also past clients and new prospects! Continue reading 3 Little Mistakes that Cost Thousands

Posted on

How to Tell You’re Setting Your Prices Too Low

How to set prices in business

how to set prices in business
Don’t shoot yourself in the foot by pricing too low and only winning jobs that you make very little on!

AS ALL SMALL BUSINESS owners know, setting the right prices is a difficult task. And a lot of newbie business owners think that being cheap is the better than meeting the market, but that’s not always the case.

Take, for example, a tradesperson I met recently. This tradesman is a painter and he’d been in business for a while before he realised his prices were set too low, and despite all the business he was getting as a result, it was actually costing him money. (We cover more detailed, real-life case studies like this in our micro courses.) 

He shared with me the tell-tale signs that your prices are too low.

Lots of small, one-off jobs

Small jobs are important because they keep the home fires burning, so to speak. But you need a good balance of small jobs and bigger projects, with the small jobs being completed around or in the middle of the larger ones.

If you’re only getting lots of small, one-off jobs that you spend more time to travelling to than it takes to complete the work, this is a good indication that your prices are too low. For jobs like these, either charge for travel time or a call-out fee.

For small jobs … charge for travel time or a call-out fee.

You’re too busy to plan ahead

If you find that, in order to make ends meat, you need to keep yourself so busy that you don’t have time to plan your working week, then your prices are too low. You should be able to plan out your weeks so customers know when to expect you, and so you can be as productive and efficient as possible — if you have two jobs in the same area, for instance, planning ahead will allow you to go to those jobs on the same day.

Use a tool like Google Calendar from G Suite to organise your days, and keep in touch with customers along the way so they know to expect you.

You can’t afford to pay for help

Setting your prices lower than your competitors may be one way to win jobs, but the downside is that you’re constrained to completing the work entirely yourself. The tradesman, a painter, whom I was speaking with, told me about a time he couldn’t afford to find another painter to help prepare walls or pitch in with the painting because his prices were too low.

If you’re not able to pass jobs onto other businesses in your industry — subcontracting — and still clip the ticket, or you’re not able to afford to use a portion of the money you’d earn to hire someone to complete part of the job, you’re charging too little.

You’re too busy to invoice promptly

Just as it’s important to plan your work weeks in advance, it’s equally important that you invoice customers for the work you’ve completed in a timely manner. If you find that you often don’t have the time to invoice customers until a week or a month has passed, there’s a deficiency in your business processes. Use accounting software like Xero so you can invoice on the go.

***

We cover setting prices the market — and your business — will bear in our EzyStartup Course. Visit our website for more information and to enrol.


Check out our Spring Specials!

learning how to use excel and xero with online training

We have a host of online training course specials for the spring season — take a look!


 

Posted on

Finding Help with Your Bookkeeping

Why you should employ a bookkeeper to help manage the books

best way to find a bookkeeper myob xero quickbooks online
If you’re a small business owner, it shouldn’t be taking you an inordinate amount of time to keep your bookkeeping orderly and up to date. If it is, perhaps now is the time to get help.

PERHAPS YOU ARE a small business owner who is trying hard to keep up to speed with your regulatory bookkeeping requirements. But no sooner does one quarter end and another one seems to roll by with the commensurate paperwork due all over again. This is taking away from your regular work and you’re falling behind — and half the time you’re not even sure that it’s being done correctly. It sounds like you should be seriously considering finding a bookkeeper for your business.

Even if you have training in how to use Xero, MYOB or Quickbooks, or some other cloud accounting program, finding a great bookkeeper can make all the difference to your business. However, although there might seem to be plenty of “bookkeepers” around, finding the right one bookkeeper for your business is not an altogether easy thing to do. And if you’re financially challenged, you also need to find a bookkeeper who won’t break the bank.

Bookkeeper, accountant or tax professional?

These days, the term bookkeeper is almost an umbrella term for all the different types of accounting and tax professionals available to you, from basic data entry bookkeepers right through to specialised BAS and tax agents.

There are even some bookkeepers who are so knowledgeable in one particular accounting program that the software company has endorsed them as certified consultants or advisors, and some earn commission from accounting software companies, while there are others who aren’t beholden to any particular software company. We outline four steps you can take to narrow down the search.

Step One: What Kind of Bookkeeper Do You Need?

Think about your business and how it operates. Do you have lots of business purchases and transactions each week? Do you employ staff? Do you work in a specialised industry? Are you registered for GST? Do you require a bookkeeper to work onsite at your premises or can they work remotely?

Write down the needs of your business to help you determine the kind of financial help, and therefore, what kind of bookkeeper you need for your business.

Step Two: Research Local Bookkeepers in Your Area

Visit the websites of some local bookkeepers in your area, or search the National Bookkeeping Directory to find bookkeepers matching your requirements located near you. If you don’t require a bookkeeper to visit your premises, broaden your scope and research bookkeepers who can work remotely. Make a shortlist of potential bookkeepers.

Step Three: Check the TPB Register

BAS and tax agents are required, by law, to register with the Tax Practitioner’s Board (TPB), so if your business requires either a tax or BAS agent (or both), the TPB Register should be your first port of call to ensure the person who have in mind is currently registered to provide BAS or tax services.

Step Four: Interview Your Preferred Bookkeepers

During step two, you made a shortlist of potential bookkeepers, and, assuming your TPB search didn’t turn up anything to be wary of, you should now set about contacting each one to get to know more about the services they provide.

It’s a good idea to ask them how long they’ve been working as a bookkeeper for, the sorts of businesses they’ve worked with in the past, and any expectations they may have of you. You should also ask for a written quote for their services. This quote should form part of your professional services agreement.

***

Many bookkeepers will provide an initial consultation, and if not, ask them to. We outline a number of things you can expect and ask them at this first consultation.

If you need help making your small business dream become a reality — with business planning and templates, identifying target markets, with any form of marketing and advertising, including social media, even just setting up a great looking website — then check out our EzyStartUp Course or contact us for more information. 


 

Posted on

Don’t Wing It With Customer Service – Plan It

Great customer service doesn’t just happen.

learn online training videos about small business customer service
If you’re unsure about what makes up the kind of customer service people rave about, then perhaps you should look into our EzyStartUp Course.

HOW TO PROVIDE REALLY exceptional customer service is just one of the modules covered in our EzyStartUp Course which teaches you all about how to start up your own business.

We handpicked this inclusion as our experience is that, time and time again, good, nay excellent customer service goes a long way to ensuring a business has longevity. Continue reading Don’t Wing It With Customer Service – Plan It

Posted on

When Do You Need to Register as a BAS Agent?

Making the effort to specialise reaps rewards

becoming a registered BAS agent
Without BAS agent registration you may be limiting your options for employment as a bookkeeper.

BECOMING A REGISTERED BAS agent means you are permitted to lodge a client’s business activity statements (BAS) on their behalf, each month or quarter, or as determined by the ATO.

BAS agents are really bookkeepers; but they’re ones who have done some extra training and applied to the Tax Practitioner’s Board (TPB) for a BAS agent’s accreditation.

Not every bookkeeper has to register as a BAS agent, but those who do typically earn more as a registered BAS agent than a straightforward, no-frills bookkeeper does. That’s largely due to the way cloud-based software, like Xero and Quickbooks, has made it a lot easier for businesses to manage their own bookkeeping. But even just speaking generally, bookkeepers who have specialised skills always tend to earn more.

So when don’t you need to register?

You don’t need to register as a BAS agent if:

  • You’re an employee of a registered BAS agent, who pays you wages to help them with BAS services
  • You’re an employee of a business doing its BAS
  • You do the books for your own business – you prepare the activity statements for your own virtual assistant business
  • You don’t receive a fee or reward for the BAS services you provide – you’re helping a relative or in-law prepare their activity statements.

You may still need to register, however, even if the client lodges their own activity statements, simply because they relied on your advice or work relating to their BAS.

Who needs to register, then?

In a nutshell, if you provide BAS services that you are paid for – that is, you receive a fee or reward – then you need to register with the TPB.

Even if you’re being paid for your BAS work as part of other types of work (like a freelance office manager whose duties include providing BAS services, along with other duties, like customer service and general administrative tasks), you still need to register.

You’ll also need to register if you’re a contractor, providing BAS services to another registered agent. This applies even if you work at the registered agent’s office or premises and you’re not considered an employee of that agent (for further info, see the ATO’s guide to determining when someone is a contractor and not an employee).

Why register to be a BAS agent?

As we’ve said, there’s the legal requirement to register to be a BAS agent if you’re deriving an income, or some other form of remuneration, for providing BAS services to another business. But there are other reasons why a person with the knowledge and know-how of BAS should register as an agent.

Example:

Say you’re someone who doesn’t need to register, but you’d like to pick up extra work as a contract or freelance bookkeeper, being a registered BAS agent makes you more valuable to businesses; not just because you can complete and lodge their activity statements, but because you can also advise them on their BAS.

As noted above, even if you don’t lodge the activity statement because your client does, you may still need to register if they relied on any part of your work or advice. For your services to be clearly delineated from your client’s BAS, you’re only able to provide very basic data entry services.

becoming a registered bas agentIf you don’t register, it means you can’t:

  • Work out the codes for GST or FBT collection
  • Provide reconciliation, because it involves deciding on the tax codes to apply
  • Manage your client’s payroll

You wouldn’t even be able to set up a client’s accounting software for their business.

If you don’t register as a BAS agent

A bookkeeper that’s only able to provide very basic data entry services – which isn’t even a huge component of the bookkeeping job now that most accounting packages have the bank feeds feature – isn’t very valuable to a business, simply because they don’t add any value to their client’s business.

When people hire a freelancer or a contractor, they tend to hire someone who can fit one of two criteria; either they’re:

  • Highly skilled in their particular field; or
  • Inexpensive

If they want someone highly skilled, it’s usually because the project they’ll be working on is very important to them; if they hire someone inexpensive, it’s because the project isn’t particularly important, but does need to be done nevertheless.

You can probably see where we’re heading here. We happen to think bookkeeping is extremely important, because it indisputably has many far and wide ranging implications for all of our businesses.

How and with whom you need to register

First you need to have completed, as a minimum, a Certificate IV in Bookkeeping at a TAFE or another registered training organisation. Then you need to register with the TPB, which requires registrants to meet a certain criterion before they can be accredited as BAS agents.

Although it’s not a requirement, you’ll also need to know how to use some of the most popular accounting packages. At the moment, the three most popular accounting packages with both accountants and most business owners, are QuickBooks, MYOB and Xero, of which we offer online training courses in. All of these packages have pros and cons.

We say it’s not a requirement to know each of the above, because a Cert IV in Bookkeeping trains you in the intricacies of Australian tax law, but doesn’t teach you how to apply that in any accounting software; that’s something you have to learn yourself if you’re going to put your education into practice.

To read more about becoming a bookkeeper, and in particular how to start a bookkeeping business, continue reading or subscribe to our blog. Alternatively, to learn how to use MYOB or Xero, you can enrol in one of our many training courses online.

***

Read more about being a BAS agent

learn xero myob excel online training course videos

Starting your own bookkeeping business can provide a lucrative and flexible career option. As a BAS agent you can lodge Taxable Payments Annual Reports (TPARs) which are used in the construction industry. Also, don’t fear that you should automatically choose to affiliate with one accounting software application over another — oftentimes having a qualified BAS agent is far more valuable to a business than a certified consultant or advisor.  


 

Posted on

Is Xero Really All It’s Cracked Up To Be?

How does Xero stack up in the cloud accounting game?

xero learn online xero course training videos cheap
Xero CEO, Rod Drury

WHEN XERO FIRST ENTERED the accounting space, it gave MYOB a real run for its money — something Xero continues to do to this very day.

When Xero first entered the market, it was with a bang. You see, even though  Xero and MYOB share many of the same features, Xero was cheaper and easier to use than MYOB, but perhaps even more so, it was also cloud-based. Being cloud-based meant you didn’t have to buy and install pricey software that would be out-of-date within 12 months. A huge advantage.

Since then, however, a number of cloud-based accounting applications have entered the market — QuickBooks Online (now distributed by their US-based parent company Intuit), Reckon One, Saasu, Zoho, and so on.

As business owners have more choice than ever before, it’s got a lot of people wondering about whether the two market leaders (Xero and MYOB) are really all they’re cracked up to be, Xero in particular.

Missing a dropdown menu

Even though Xero was hailed as a breath of fresh air when it first entered the market, it is still a little more complicated to use when compared with other cloud accounting apps, like QuickBooks and Reckon One. For instance, the purchase orders feature is still hidden behind bills, when it could easily be access via a dropdown menu. But it’s not a major quibble.

Xero’s contact profile misses a beat

Although Xero allows you to assign customer numbers for your suppliers or customers in the contact profile, it doesn’t have the functionality to record customer numbers assigned by supplier or customer.

If you’re trying to get in touch with Telstra, for example, with whom you’ll have been assigned a customer or account number, you’ll have to dig around for the paper bill to find that customer or account number.

It’s easy to file bills, though

This feature is available in QuickBooks, and it’s also available in MYOB, but as is often the case with MYOB, it requires more steps to do what you can in Xero in just a few clicks. Rather than keep paper bills on hand, Xero allows you to attach them to you transactions, so you never have to go hunting around for a bill again (very useful given the contact profile issue mentioned above).

In MYOB, you must upload your bills to your in-tray, and then link them to your transactions. This is annoying, because it requires you to leave the transaction window and open the in-tray one.

***

Remember that when you select a cloud accounting package for your business, do not choose solely based on price. Make a list of the needs of your business and the functions you’ll require, and then select the accounting package that suits your needs the most. Ask your bookkeeper and other business friends for their recommendations as well.


Announcement: Microsoft Excel 2016 Beginners’ to Advanced courses now available!

learn to use excel online training course videos cheap best

At EzyLearn we include all versions of a software program in our training courses. That means when you enrol into Excel you get 2016 — AND — the older Excel courses which include version 2013, 2010, 2007 and even 2003 (if you really need it).
When you enrol in Lifetime Course Access you get access to ALL versions and ALL FUTURE VERSIONS as we continually update them — at no extra cost!

Posted on

Who Do You Trust More: Real Estate Agents or Tradies?

Still unsure whether you can trust online ratings and reviews?

trusting online reviews and ratings for tradesperson real estate agent online ratings and reviews
After a tradesperson? Sometimes asking a business person from a related business, such as a real estate agent, can be a good source for a recommendation.

IT CAN BE HARD to know whether you can really trust online ratings and reviews, whether these reviews and ratings are objective and even relevant and how they compare to recommendations and testimonials. By recommendations we mean word of mouth referrals from your friends and family and so forth, and testimonials that have been written by real people — with real names and real locations!

In our recent post about recommendations we suggested that you ask a friend, relative or colleague if they’ve ever had experience with a business you’re thinking of using — chances are, if your friends live locally they may well have; or if the business is a chain or franchise operating over a wide area.

Also ask other businesses

When seeking a professional recommendation you can also ask other businesses. Find out what their experiences have been, if any. Often businesses will have a relationship with each other even if it is not, at first, apparent.

For instance, a symbiotic relationship tends to exist between real estate agents and tradespeople. Agents will regularly draw up a list of preferred tradespeople that they work with and recommend to their tenants, landlords and vendors.

And there are plenty of tradespeople who do the same for real estate agents that they’ve had professional dealings with. There are plenty of other examples of these sorts of professional recommendations.

Beware professional bias

Of course, just as you should be wary of overly positive or negative ratings and reviews online, you should be likewise when soliciting professional reviews. If one business regularly referred work by another, even if they don’t think they’re a great business to deal with, neither party will necessarily say anything bad about each other.

In the end, when looking for a tradesperson, real estate agent or some other professional service, be sure to do all your research. Ask around for personal referrals, check them up online, and get in touch with each business directly to see which one is the best fit for you.

Real people, real locations

At EzyLearn we provide testimonials from our students, which include their full name and location, and why they chose EzyLearn to study in the first place. We also offer a money-back guarantee and free samples of our course content, so students know they can trust they’re making the right choice. Visit our website for more information and to see our wide range of courses.


Xero online training course

At EzyLearn we offer online training courses to help you up-skill and find employment. Choose from our range of cloud-based online accounting software courses, to business start up and management courses, to marketing and sales courses, or update and further your skills in a range of Microsoft Office programs (ExcelPowerPointWord) or social media and WordPress web design). 


 

Posted on

3 Things You MUST Do in Excel!

Business owners and job seekers take note!

learn xero myob excel online training course videos
Excel isn’t just for budding bookkeepers; it’s a great tool for all business owners to know.

MICROSOFT EXCEL IS THE most widely used spreadsheet application in modern computing. That said, it’s also one of the more difficult programs of the Microsoft Office Suite to learn, which is why we recently updated the content of our Excel training courses.

A lot of people do our Excel training courses to help them “skill up” to find a job, find a position better suited to them, or develop their career path. However, Excel is a fantastic tool for small business owners as well.

But whether you use Excel to create a pivot table or a database, there are a few things you should do each time you open an Excel document. Here we present you with three:

1. Vertical align: always centre

Always align the text in the cells of your Excel spreadsheet to the centre, or the top in certain circumstances. But never, ever align it to the bottom. It’s hard on the eyes and, when you’re looking at lots and lots of data in lots and lots of cells, it becomes difficult to know which row, column, etc, you’re looking in. Centre alignment, always.

2. Build error-checking into formulas

There should never be an instance where one of your workbooks is showing a #DIV/0, #N/A, #REF, #NAME?, #NUM!, or #NULL! error. This is especially true if you’re sharing these workbooks with your business partners or accountant or whomever.

Seeing an error in a financial report may cause the reader to doubt the accuracy of the entire workbook, so ensure your workbooks remain error free by using the simple IFERROR() error-checking function in Excel.

3. Print preview your work

Again, if you intend to share workbooks with other people, you should always ensure that your Excel workbooks can be printed nicely and easily, even if you don’t intend to ever print the document yourself. This is easy enough to do via File > Print Preview and adjusting the print margins before sharing (or printing) the document.

However, judging by the number of times I’ve printed an Excel document only to collect 87 sheets of paper off my printer to read the contents one 4×4 table, the function is seldom used by anyone else but me!

***

For more Excel formatting tips and tricks, download our FREE Beginners’ Guide to Excel, or enrol in our intermediate or advanced online Excel training courses to learn how to create databases, pivot tables, charts, graphs, and much more…

Read more about our beginners, intermediate and advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow!


learn xero myob excel cheap online training courses videos

At EzyLearn, we’re committed to helping students of our MYOB, Xero and Quickbooks courses gain employment as a bookkeeper or even start their own bookkeeping business; it’s why we provide you with lifetime access to our online cloud-accounting training courses as part of our commitment to continuing professional development


 

Posted on 2 Comments

Using Excel for Client Databases

Excel does great CRM

learn excel cheap online learning training course videos
Managing large amounts of client and business data is not only possible, but also something you can learn fast and with ease with the help of our comprehensive range of online Excel training courses – covering all skills levels.

MICROSOFT EXCEL IS THE most widely-used spreadsheet application in modern computing. It’s ubiquity means most people use Excel on a regular basis, despite never having had any formal training in its many, many, MANY functions.

While updating the content for our Excel training courses recently, we were reminded of just how powerful Excel remains, and in particular, how useful it is for small businesses.

With its 2013 release, Excel got a serious update, which made it the perfect application to create and manage client and customer databases. Although there are many CRMs available on a subscription that provide the same functions of a database created in Excel, just in a more visually appealing format, they often lack reporting and analysis functions, requiring you to export your data in a Excel sheet anyway.

Flat file databases

Excel’s original ‘flat file’ database still remains the easiest and most basic database to set up and manage, and depending on your business and how you’ll use your database, a flat file database may be all you’ll ever need. If set up correctly, a flat file database will allow you to easily import your customer data into Word, your accounting software, an email marketing service, and so forth.

Relational databases

A relational database is a database that’s structured to recognise relations among the information stored in them. Microsoft offers a relational database program, called Access, which is available with Microsoft Office Professional or higher, or can be purchased separately.

Alternatively, you can create your own relational database in Microsoft Excel, providing you have the 2013 version or newer. When Excel got its update in 2013, it became easier to link charts and cells and to perform searches — all essential features if you’re working with large amounts of business data.

Correct Excel set up is crucial

Once Excel has been set up, it’s as easy as it is powerful to use. Of course, the key is to set it up correctly, so you can avoid errors or having to re-enter large amounts of data to make the format suit another third party software application.

***

Creating and managing databases is included as part of our Advanced Microsoft Excel training courses — and you receive access to ALL OF OUR COURSES, including ALL SKILLS LEVELS for ONE LOW PRICE. You can even start your Excel journey with our FREE Beginners’ Excel Course Workbook. Read more about our beginners’, intermediate and advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow!


learn to use excel online training course videos cheap best

Learn Microsoft Excel from scratch or brush up your Excel skills, at your own pace, with our affordable Excel online training courses — where you get THE LOT (that’s 9 courses in total) for ONE LOW PRICE — everything included! Volume corporate discounts are available and our courses count towards CPD Points.


 

Posted on 1 Comment

Keeping Tabs on those ‘Little’ Monthly Expenses

Why Excel is Great for Keeping Track of Your Spending if You’re Self Employed

excel online training course using excel for monthly expenses sheet
That take away coffee that you buy each morning should be added to your business expenses sheet; even if not claimable it shows where your money is going.

WHETHER YOU’RE ABOUT TO start your own bookkeeping business, or whether you work as an independent contractor (even if you’ve been doing this for a while), it’s really important to know how much you’re spending each month.

Your Xero, MYOB or QuickBooks accounting software will help you with some of this, but the very best way is to create an expense or spending sheet in Excel — which we teach you how to do in our Excel training courses — as this gives you a far more detailed look at your expenses and spending.

Not all your expenses are 100% business ones

Sometimes you can’t claim 100 percent of your expenses as business ones — the costs of running your car, home internet, rent, utilities, etc — but you should nevertheless keep track of your spending on these items because it will affect your cash flow.

That’s why keeping an Excel spending or expense sheet is a good idea for contractors and home-based business owners. You don’t want to enter your home internet into your accounting software as a business expense, if only 30 percent of it is used for business purposes, but you still need to keep track of it, so you can manage your cashflow.

Monitor frivolous spending

One of the things we love about using Excel to track your expenses and spending is that every little expenditure is right there, in plain view.

This isn’t the case with Xero or MYOB or other accounting software. Your expenses are hidden away, and you have to run a report to get a good breakdown on where your money is going.

Not so with Excel,. If you buy a coffee every morning, it’s right there, in a category you can label as “coffee”.

Now, we’re not saying that coffee is frivolous. Far from it. Many of us need coffee just to function (!) but there are lots of small things we spend money on every day, week, month that add up. When you’re self-employed you need to keep an eye on these “little” things.

Sometimes, you’ll find that you’re spending lots of money each month on subscription services that you’re not even using. Eliminating $15 a month here and there makes a big difference.

Create as many categories as you need

That’s the other great thing about using Excel to track your spending: You can create all the expense categories you like.

Of course, not everyone wants to track each and every expense right down to their last bag of jelly beans — that actually would be a little ridiculous — and for most the most part, you can lump your groceries into a category for discretionary spending, but there are some things you might want to separate out — movie tickets, money spent on lunches and dinners, and so forth.

These things tend to add up, and if you want to keep an eye on them, separating them out is the easiest way to do that.

Back to those business expenses

Each fortnight or month or however regularly you complete your bookkeeping, you can easily add in those business expenses into your accounting software — or your bookkeeper can.

Remember, if you spend $60 a month on internet, but only 30 percent of its use is for business purposes, you should only add $18 a month as a business expense in your accounting software. In your Excel expense or spending sheet, however, you’ll put the full $60 in, as you need to have the money in the bank to cover this expense each month.

***

You can learn how to create and manage your expenses or spending in our Excel training courses, where you’ll be able to create your own spending or expense sheet. Visit our website for more information.


learn Xero online learning videos cheapest

Our Xero online training courses include EVERYTHING for ONE LOW PRICE. Furthermore, if you select our Lifetime Membership option, you’ll have LIFETIME access to our ongoing course updates. All EzyLearn courses are accredited by the Institute of Certified Bookkeepers (ICB) and can be counted towards Continuing Professional Development (CPD) points. Find out more about our Xero online training courses. 


 

Posted on

Marketing for When Your Business Strategy Changes

Where lead generation services are useful

lead generation services
Using a dedicated lead generation service can be more useful than advertising but the quality of the leads may be questionable.

CHANGING YOUR BUSINESS STRATEGY to include additional services will require an additional investment in marketing if you are to make this successful. In terms of simply paying money to advertise your additional services, as you’re probably already aware, advertising doesn’t always yield immediate results. Therefore you might consider spending money on a lead generation service.

We cover how to account for marketing and lead generation costs in our Xero training courses, which includes a new workbook that looks at what to do when your business strategy changes. Continue reading Marketing for When Your Business Strategy Changes

Posted on

The Do’s and Don’ts of a Compelling Resume and Cover Letter

Is your resume up to speed?

do's and dont's of writing a great resume
If you thought you’d never have to write another resume as a contractor or self-employed business person, then think again.

STARTING YOUR OWN BUSINESS does not mean you’ll never need to write a resume or cover letter again. We’ve written about this topic before — indeed, when you first start your own business you’ll probably spend a lot of your time applying to work with other businesses directly or through a recruiter.

And the truth about being a freelancer or contractor is that you’ll most likely spend the rest of your working life applying for work. If you don’t like the idea of this, well then maybe being self-employed isn’t for you! Why? Because in order to find the best work; the kind that you’ll love, you need to be always looking for it — or always be closing, if there any fans of Glengarry Glen Ross in the house tonight.

The truth about being a freelancer or contractor is that you’ll most likely spend the rest of your working life applying for work. 

Do pay attention to design

I’m choosing to exclude the “grammar, spelling and punctuation” portion of this list, because if you don’t already know that’s important by now, then oh boy, I can’t help you. But formatting and design are important, whether you’re looking for work in a creative industry or not.

The key is to grab attention in less than half a minute. You can use different fonts, for instance, a larger plain font for headings and a smaller (perhaps serif) font for the body text. You can type your resume up in Word or use PowerPoint or some other design tool. But just don’t get ahead of yourself and use something too fancy that you don’t have a proper grasp of and end up with a resume that is hotchpotch and messy.

These days, some recruiters will even upload your resume into their own “system” which “parses” your content and basically re-formats it all into plain text. If this happens, your gorgeous CV will look very different on the screen of the employer. The simpler the design and layout of the original resume, the easier it will be for them to read if they indeed use this system for getting through the applications of hundreds of job applicants. But don’t feel disheartened, there are others ways to get spotted amongst the crowd.

Don’t use jargon

The next hurdle, once you’ve got the recruiter or hiring manager reading your resume or cover letter, is to urge them to call you. Do not, I repeat, do not use jargon of any kind in either your resume or cover letter. The minute someone reads a sentence that starts with or contains “experienced in”, “team player”, “responsible for”, etc, etc, they switch off.

These phrases mean literally nothing. Nothing. Telling someone you’re a team player: redundant. Everyone should be a team player, and there is no one, not a single person ever, who has written on their resume that they’re not one. Instead, tell the employer what you like about working in a team. (On a similar note, also avoid the term “able to work autonomously” by explaining the times you’ve had to and how that’s gone.)  

When you go to use the words “experienced in” try to remind yourself that this is something that happens to you — not something you proactively go out and do. Instead refer to your background in terms of achievements. Search “typical jargon to avoid on a resume” for more.

Do show your personality

Remember that employers are people too. Work culture is important to lots of businesses, so they need to know that any potential new hire, freelance or otherwise, will be able to fit in and work with them. And if you can make the person reading your resume laugh, oftentimes you’ll get a call back.

Don’t list silly interests

I should add a qualifier to that, which says that it’s okay to list a really silly interest if you know and make a point of noting that it’s a silly interest. This makes you seem thoughtful, and definitely not as dumb as a person who says they like reading or sports on their resume. Reading what? It implies novels, but it could also mean signposts, Aldi catalogues, Post It Notes. And if you like playing cricket more than once a year on Boxing Day, then for the love of all that is holy (cricket on Boxing Day), say that. Otherwise, put down interests that you actually are interested in — they reveal a lot about the type of person you are, which again, goes to help with the point above.

***

If you’d like to learn how to create a resume in Microsoft Word or PowerPoint, or if you’d like to learn more about starting your own business, you can be enrolling in our PowerPoint training courses or our online Word training courses, or our Business Start Up Course.


learn xero online training course videos

At EzyLearn you can choose from a range of XERO online courses, depending on your skill level — or you can access ALL courses for ONE LOW PRICE. All our courses are accredited by the Institute of Certified Bookkeepers (ICB) and can be counted towards Continuing Professional Development (CPD) points. Find out more about our Xero online training courses. 


 

Posted on 1 Comment

Turning Your Business Idea into Income

How not to plunge into working for yourself — while working for yourself!

becoming an independent contractor_comp
You might have to supplement your income by working at a cafe or similar while you find your first clients.

IF YOU’VE DETERMINED THAT your business idea is viable and has the potential to generate revenue, then it’s time to start earning income from it.

We show you how to carry out market research and competitive analysis in our Business Start Up Course and this blog post will tell you the steps you should take to start deriving income from your business idea.

Have an income on the side

It’s unwise to plunge headfirst into self-employment. You need to have some income behind you while you’re getting your business off the ground. That may even mean leaving full time employment and taking up part time work in a cafe or retail shop. You have bills to pay and it’s neither fun nor productive being unable to. You do, however, need time to work on your business, so you can’t be so time poor and stressed that you can’t devote the necessary time to organising it.

You need to have some income behind you while you’re getting your business off the ground. That may even mean leaving full time employment and taking up part time work in a cafe or retail shop.

Start working as a contractor for other businesses

finding work as a contractor
Initially, be willing to work as a contractor while you build up clients for your own business.

Getting that first job or client is always the hardest part of starting any business. But it’s easier when your business is providing a service and you’re working as a contractor or freelancer.

Whether you’re a bookkeeper, virtual assistant, even a tradesperson, you can apply for jobs working with other businesses, rather than spending money you probably don’t have to market your business, while you wait for clients to find you.

Look for part time, contract or casual jobs you can apply to. If you see a company has been advertising for a full time employee for a while and it appears they’re having trouble filling the position, get in touch with them. Find out if there’s an opportunity for you to work with them on an ongoing freelance or part-time basis, or until they fill the position.

There are many businesses that would like to hire freelancers or contractors but don’t know where to find them, so they continue to employ by traditional means. If you can show them you’re capable, and that there are benefits to using a contractor or freelancer, then the job might just be yours.

Find a recruitment agency

The businesses that do like to hire contractors and freelancers, but don’t want to manage it themselves, go to recruitment agencies. If you’re in any kind of specialised or creative industry — IT, finance, business management, advertising, marketing, etc — then it’s a good idea to get a recruiter, maybe two. It won’t cost you anything, and it’s the best referral marketing a person can get. Plus, it’s always good to have someone in your corner when you’re just starting out, to ensure you’re getting fair market rates, conditions, and the like.

“Packaging” your services

Before approaching businesses or recruiters, you need to understand the value you bring. Sometimes this means combining a number of your skills and gaining other ones, to ensure you’re always in demand.

In business parlance, this is known as packaging your services, which we also cover in our Business Start Up course. To learn more, visit our website.


Social Media and Digital Marketing online training course_comp

Are you in business as a bookkeeper, tradesperson, retailer, trainer or real estate agent and want to stand out from the crowd? We can teach you the online marketing techniques to help you do just this! Check out what’s included in our comprehensive Social Media and Digital Marketing online training courses.