Posted on 1 Comment

Explaining Why Excel’s Pivot Tables are So Mighty!

No amount of data is too big for Excel’s pivot tables

using microsoft excel pivot tables
Go You Excel Pivot Table! Excel’s signature function, the pivot table, is still as useful for making sense of large amounts of data as it ever was.

WE’VE RECENTLY BEEN UPDATING the content for our Excel training courses and were reminded of just how useful Excel is for small businesses. In Excel, you can easily create and manage client databases and then export part or all of that data into a Word document, your accounting software, an email marketing service, or use it in other Excel documents, such as a pivot table.

A pivot table is Excel’s signature, and most powerful, feature — Microsoft trademarked the words ‘pivot’ and ‘table’ in their compound form PivotTable back in the 1990s. So if you intend to use Excel in any meaningful way for your business, knowing how to create and work with pivot tables is an essential skill, one which we cover in our newly-updated, advanced Excel online training courses.

What are pivot tables used for?

A pivot table is a way to quickly summarise and analyse large amounts of data, and the pivot tables you can create in Excel are especially designed for:

  • Subtotalling and aggregating numeric data
  • Summarising data by categories and subcategories
  • Creating custom calculations and formulas
  • Expanding and collapsing levels of data
  • Drilling down on details from summary data
  • Filtering, sorting, grouping and conditionally sorting data
  • Presenting concise, attractive, and annotated reports
  • Moving rows to columns and vice versa (‘pivoting’) to see different summaries of source data.

Pivot table data sources

There are a few ways that you can create a pivot table, though the most common way is to use an existing Excel worksheet — a database, for example — as a data source. Here are a few ways to create a pivot table in Excel:

  • Excel tables: Excel tables are already in list format and are good candidates for pivot table source data. When you refresh the pivot table report, new and updated data from the Excel table is automatically included in the refresh operation.
  • Using a dynamic named range: To make a pivot table easier to update, you can create a dynamic named range, and use that name as the pivot table’s data source. If the named range expands to include more data, refreshing the pivot table will include the new data.

Create a database in Excel first

The most efficient way to create a pivot table is to create a database in Excel first. Here, you can update and manage as much information about your business — including customer data and financial data — and then use that as a data source for a pivot table.

***

Creating databases and pivot tables are part of our advanced Microsoft Excel training course, but you can start your Excel journey with our FREE Beginners’ Excel Course. Read more about our Beginners’, Intermediate and Advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow! We cover ALL levels for ONE LOW COST.

And with EOFY looming, be sure to take advantage of our specials!


learn xero myob excel cheap online training courses videos

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 1 Comment

End of Financial Year: Writing Off Stock

We show you how to write off stock and inventory before the EOFY

how to write off stock before eofy in xero myob
Do you know how to make inventory adjustments? Our Xero and MYOB BAS and GST Reporting courses can show you how.

IT’S A GOOD TIME TO START  looking at any slow-moving or obsolete stock that your business (or your client’s business) may be holding, as we’ve reached the end of Quarter 3 and have now started Quarter 4 for the 2016/17 financial year — which means the end of the financial year is fast approaching.

Writing off stock in MYOB or Xero is known as making an inventory adjustment, and our MYOB BAS Reporting and GST or Xero GST, Reporting and BAS training courses take you through the steps to do this. But first, you need to identify which items aren’t selling. We’ve created this case study to help you understand how.

Understanding your inventory’s performance

Every business needs to understand how their inventory is performing, and how it impacts their business. If the business owner is too busy to stay on top of this, then they should employ a bookkeeper to help.

A good example of why understanding inventory is important to a business is to look at an air conditioning company. This business makes money two ways:

  1. Selling air conditioning units
  2. Installing / maintaining air conditioning units

The margin on the sale of an air conditioning unit is not much, a few percent on top of the wholesale price. Where the business makes its money is in the installation or maintenance of the units it sells.

The business purchases three dozen units, of varying brands, models, price points, etcetera. It now needs to know which units are most popular with customers and why; which units aren’t popular with customers and why; whether it’s profitable for the business to continue to stock the unpopular units; or, conversely, whether it’s profitable for the business to continue stocking the popular units.

Inventory reporting

The business’s bookkeeper regularly runs a number of reports in their accounting software, including profit and loss reports and stock-on-hand reports. These reports are used to identify which units sell quickly, as well as the units that take longer to sell, and the profit margins on each.

The units that sell quickly don’t require a technician to install them. Although they’re responsible for the majority of sales, they don’t generate more revenue for the business. The units that sell slowly, do generate more revenue as they require installation and maintenance, however too many units were ordered and they’ve now been discontinued by the manufacturer. Some units have hardly sold, and, although not discontinued, have been superseded by newer models.

Stock write offs and future orders

Because the bookkeeper regularly runs these reports, s/he has been able to export them into Excel for further analysis. By the end of Q3, the bookkeeper can make suggestions to the business owner about the future of the business.

In particular, the bookkeeper suggests that the units that have been superseded are marked down to clear as much stock as possible, and cease any new orders. Likewise, the discontinued models will be marked down.

Orders for the units that replaced the discontinued models will halve the order volume. Likewise, order volumes for the top selling units will reduced. The profit margin on these units is very low and they result in no additional revenue from installation or maintenance. The profit that would be earned on the additional units is negligible, however by reducing the unit volumes, the business improves its cash flow.

Act NOW for EOFY

If your business sells stock or a combination of stock and services, like the air conditioning business does above, start looking at your inventory now. Markdown any slow-moving stock at the end of Q3, to give your business time to move the remainder of it. If it doesn’t sell, write it off at EOFY.

***

Our MYOB and Xero training courses have recently been updated to include a workbook on how to write off inventory. Learn more about our MYOB BAS Reporting and GST or Xero GST, Reporting and BAS training courses at our website.


find a local bookkeeper

We feature our own online directory of local bookkeepers looking to add to their customers. Visit National Bookkeeping to find a suitable and experienced person available to work in your area, or able to work anywhere in the cloud. Alternatively, if you are a bookkeeper looking to expand your client list or find contract work, you can register and become part of our network for free


 

Posted on 4 Comments

Basic Bookkeeping Reports in Xero: Profit and Loss

Learn How to Run a P&L Using Xero

Profit and Loss statement
Profit and loss statements should be run by businesses regularly and are required by law.

A basic, yet vitally important, report for every business owner is a profit and loss (P&L) statement. A profit and loss statement, as the name suggests, shows whether a business is running at a profit or a loss over a given period. We’ve written about why running multi-period P&Ls before in QuickBooks and MYOB is a good idea for businesses with inventory, but single period P&Ls are equally important for all businesses.

If you’re a bookkeeping newbie, a profit and loss statement, which sometimes goes by other names — income statements, earning statements, revenue statements, operating statements, statement of operations, or statement of financial performance — is a basic report you’ll learn to run in our Xero Daily Reconciliations Course. If you’re planning to work as a contract bookkeeper, you should get in the habit of running P&L statements for your clients regularly (if you’re a business owner, ask your bookkeeper to run them).

P&Ls are required by law

Depending on how a business is structured, it may be required by law to complete a P&L. A P&L shows how the revenue of the business is turned into net income by subtracting all expenses from income. They’re also useful for understanding a business’ net income, which helps with the decision making processes. A business will also need a P&L if they’re applying for a small business loan.

The contents of a P&L

profit and loss statements P&LsAlthough the process of running a P&L differ between accounting software packages, they usually all contain the same elements, depending only on the business itself. In the first section, the cost of sales is subtracted from the revenue, which highlights gross profit. The business’ operating expenses are then subtracted from the gross profit, which leaves the operating profit. Now, all of the non-operating revenues and expenses must be factored into account, after which the business’ profit or loss will be displayed.

***

Because P&L statements are often used by a business’ owner to make financial decisions, to inform shareholders of the business’ performance, apply for a business loan, or as proof of income in the sale of a business, it’s important that you understand how to create one correctly. Our Xero Daily Reconciliations Training Course covers P&L statements, and much more. Visit our website to learn more or to enrol.

***

online bookkeeping courses to earn cpd points

 

Did you know that EzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants?We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.

 

 

 

 

Posted on 1 Comment

How and What Kind of Receipts Do You Need to Keep?

Xero course online receipt keeping

Online Receipt Keeping is the Way to Go

A HUGE PART of reconciling your bank account involves coding business expenses or purchases. You then need to keep a record of those expenses in the event you’re ever audited.

Our Xero Bank Reconciliations and Journal Entries Course covers how to code an expense or purchase in Xero, and it’s important to also store your receipts and get them to your bookkeeper if they’re working remotely.

Many people have used Dropbox to capture images of receipts but there are even better ways. Continue reading How and What Kind of Receipts Do You Need to Keep?

Posted on

Working Out Job Costs and How to Charge Your Clients

Why You’re Underselling Yourself with Fixed Price Quotes

bookkeepers fixed price quotes
There are many reasons why you may lose out when fixed price quoting.

We’ve written a number of blogs on how bookkeepers can work out their fees and what good local bookkeepers generally charge. However, now we examine the nitty gritty of determining your on the job costs so you can clearly see what your hourly rate should be.

When it comes to working out fees, most business owners go: “Well, the average market rate for my profession is X per hour and this job should take around Y hours” and off they go and give their client a quote that, in today’s small business parlance, is frequently referred to as being a fixed-price quote or the project fee.

This would be fine except that you’re essentially working on an hourly rate, without the benefit of being able to charge the client if you run over your allocated timeframe.

Quite simply, this is an inefficient way to set prices for your business. It’s an even more inefficient way to quote clients, because you’re either going to rush through their work in order to make it cost effective for you, or you’re going to increase your prices the next time around. Instead, you should factor job costings — that is, how much it will cost you to complete the job — into your prices. Here’s how:

Working out the direct costs of each job

This seems obvious, but countless new and established business owners overlook the direct costs of their services when setting their prices. Ask yourself how much, in a take home hourly rate, you can reasonably live on — is it $20 an hour? $25? $30? $35, perhaps?

Once you’ve settled on a rate, you then need to add in all the other costs associated with being employed in Australia. Tax is a big one. If you’ve been working for a while, you should have a fairly good idea of how much you will pay in tax based on how much you paid last year. If you’ve just started out, try and base it on an average number of hours you’d like to work per week for the next 12 months. Got that figure? Now go onto the ATO website and work out the rate of tax you’ll pay for each dollar you’ll earn. Add that to your hourly rate.

Do the same for sick leave, annual leave and superannuation, because if you’re going to work for yourself, you should have the same benefits as you would as an employee. Now add those on top of your hourly rate.

Working out the indirect costs of each job

We’re still not done with that hourly rate yet. It’s now time to work out the other costs, like wages office expenses. Think about the services you provide and what they entail. Is there travel involved — to your client’s office, for example — because you should add that in. Allocate both the time to get there and the approximate cost in mileage (note: some invoicing software, like QuickBooks’s self-employed app works out the cost of your business travel based on the ATO’s tax rates to give you an approximate dollar figure for each business trip you make). Also factor in other costs, such as parking, even though it’s a tax deduction, and add those costs to your hourly rate.

Now work out your fixed-price quote or project fees

Your hourly rate will now be significantly higher than the amount you need to live on, and it may even be higher than your competitors, but that’s okay. You’re not working on an hourly rate, remember. You’re creating a fixed-price or project fee, so you can choose to itemise your project fees however you like in the estimate you provide to clients. For example, if your hourly rate is now $50 but your competitors charge $35, take $15 for each hour you’ve allocated to the project and assign it as some other ancillary task. This is precisely how manufacturing businesses set the prices for the products they sell, and it’s no different for businesses, like law firms and advertising agencies, in the service industry.

***

Learn how to set the correct prices for your business, plus everything else you need to know about starting and operating a small business in our EzyStartUp Business Course. Visit our website for more information and to view all of our special offers to save money on your next EzyLearn training course.  

Posted on 2 Comments

Is QuickBooks Better than MYOB for a Small Business?

How Does QuickBooks Really Stack Up Against MYOB?

compare QuickBooks and MYOB
QuickBooks is a much simpler accounting package to use than its rival, MYOB.

WE RECENTLY INTRODUCED our QuickBooks Online Daily Transactions Course because we can see that QuickBooks is fast becoming a serious and respected rival to the more established accounting software packages.

We recently wrote about how QuickBooks uses the SuperStream-compliant service KeyPay to deliver payroll services because QuickBooks itself isn’t actually SuperStream compliant. Currently, the payroll feature in QuickBooks is free for all Small Business plans, as the company further positions itself as the low-cost accounting software option for Aussie small businesses.

Continue reading Is QuickBooks Better than MYOB for a Small Business?

Posted on

Are You a Bookkeeper Who Needs More Clients? Want My Advice?

FINDING PROSPECTS AND converting them into clients involves selling and most of us hate doing it, but wait…

If you are a bookkeeper, selling online MYOB training courses to your clients could be the perfect complement to your business.
If you are a bookkeeper, selling is as important to you as it is to, say, a real estate agent.

For those of us in small business, be it as a bookkeeper, real estate agent, sales rep or the like, most of us are selling every day of our lives.

This means we get pretty good at it. We develop techniques that we can replicate and that become part of our daily lives.

The process of selling is really no longer about selling per se; it becomes about a systemised process of:

  • sourcing new leads (using content marketing, networking and advertising)
  • educating those leads about their services (using websites, social media, white papers, property reports)
  • understanding whether the lead would in fact be a good buyer or potential client (using face-to-face meetings, phone conversations and emails)
  • closing the sale (via offer and acceptance, funds transfer, receipts and after sales support).

With the growing power of modern cloud-based technologies, more people are taking the plunge to start their own businesses, but people who do so must constantly:

  • stand out from their competitors (say, other bookkeepers) to get discovered by people needing help with their books, either remotely or in their home/office
  • do an efficient job in managing their schedule and dealing with clients, and
  • market their services effectively.

Content Marketing takes the “salesy” out of selling

I’ve written a lot about content marketing lately because content marketing is simply imperative for anybody looking to sell their products and services and source new clients.

The beauty of content marketing is that, as a system to source new leads, you can cover all the steps of the selling process without it seeming like a chore and, best of all, without feeling “salesy”, cheesy or inauthentic. It’s focus is about the potential client — it’s about providing them with relevant information that will benefit them — not ramming a sales pitch down their throat.

Good sales people realise that sales and the very process of selling is not about just “closing” a sale. Rather, it’s about understanding what the customer needs, seeing if your product is a good fit and then offering a solution to a customer’s problem.

content marketing is most of the new sales funnel for real estate agentsHow much of sales is Content Marketing?

To this end, content marketing is about 80% of the selling process or 80% of the sales funnel (as corporate sales people like to call it).

This is because content marketing involves information gathering; it involves seeing if your product and YOU are a good fit for your client.

These are the content marketing stages:

  • creating relevant and interest website content
  • ‘call to action’ that results in email or mobile number capture
  • email or SMS marketing
  • social media profiles to engage with your prospects
  • CRM’s to manage the final parts of the selling process.

When you implement these systems you can sit back and watch it work and then focus on your conversion rate or what industry experts call CRO – Conversion Rate Optimisation.

Do you really want to be an online marketing professional? Let us manage it for you

Start a bookkeeping business not a franchiseMost of our students are looking for bookkeeping work, or want to start a bookkeeping service business — that’s why they use our services for MYOB Training Courses, Excel Training Courses, Xero Courses and Small Business Management Training.

Our recently updated bookkeeping directory is matching small business people to bookkeepers for a fair rate (for instance, if you want a level 3 bookkeeper, you pay for a level 3 bookkeeper). The National Bookkeeping directory is aimed at helping people (our students primarily) find bookkeeping work or start a bookkeeping business, but it’s also a great way for small businesses to find bookkeepers located close by, or who have the skills they require but who don’t necessarily need to come into the office and can assist them in the cloud.

To find out how you can be more than just a bookkeeper, and start your own bookkeeping business and promote your valuable bookkeeping services to a wider circle of potential clients via content marketing, read about listing yourself on National Bookkeeping or becoming a licensee.

 

 

Posted on

Why Partnerships Can Be Risky Business

An Understanding of Business Partnerships is Essential

business-partnerships-training-course-online
Structuring your business as a partnership doesn’t have to be risky business if you arm yourself with the right information first.

As we mentioned in our previous post about doing the necessary actions to start your new business now, rather than in January, there are lots of tasks to carry out before your business will be ready to commence trading. The first, most important thing you should do, is register for an ABN.

There are lots of services available that, for a fee, will register your business name, company structure, domain name, email hosting, and even register your business for GST and PAYG. But do you really need to use these services? Well, it depends. 

You might if:

1. You need your ABN or business name registered NOW

A few years ago, we wrote about a service called e-companies, which provides all the registration services mentioned above using its direct portal to ASIC and the ATO. As a result, many company registrations are completed within five minutes, while ABN registrations are completed in fifteen minutes, providing aren’t flagged for further checks by the ATO.

2. Your business structure is complicated

The most straightforward business structure to set up and manage is a sole trader, but they’re not suitable for every business, particularly where more than one person will be running the business or where income from the business will be distributed to family members or other beneficiaries.

In such circumstances, you may need to structure your business as a trust or partnership. If you already know how trusts and partnerships work, you may choose to use a service to register your business structure, so you don’t miss any important steps along the way. Otherwise, you may need to engage a solicitor to structure your business.

Or — 3. Learn about partnerships and do it yourself

If you’re structuring your business as a partnership, a partnership agreement is crucial to your business’s success. It’s particularly necessary for businesses that intend to use PayPal, as PayPal will withhold your income until you provide a copy of your partnership agreement. Services that register business structures do not provide any guidance on how to draw up a partnership agreement, and so many businesses go without one, which can be disastrous if a partner ever wishes to leave the business or the business is later sold.

We created our Partnership Agreement Course because a partnership is the most risky business structure. The Partnership Agreement Course, which now costs just $48 (down from $97) provides you with a template, explanatory notes, and all the standard clauses, including exit clauses for when the partnership needs to be dissolved. Once you’ve drawn up your partnership agreement, you’ll also be able to access lower tax rates with the ATO.

Read more about what’s included in our Partnership Agreement Course or enrol today, and you start the course by 5pm tomorrow.

Posted on

The Secret to an Error-Free BAS Report

What To Do So You Don’t Lose Money When Doing Your BAS

lodging correct business activity statements
Why pay more money to the ATO at your expense? A good bookkeeper may save you money when it comes time to lodge your BAS.

If your business is registered for GST, it means you have to file regular activity statements with the ATO, usually each quarter. A lot of business owners export their Business Activity Statement (BAS) data straight from their accounting software, like MYOB or QuickBooks, and quickly prepare their BAS’ that way. But this is an imprecise method, and one that could be costing you money.

Tracey Marino, an experienced bookkeeper based in Rockingham, WA, knows how important it is that businesses of all sizes keep their Business Activity Statements error-free so as not to end up costing business owners money. 

An Error-Free BAS in 6 Steps

Here’s six steps you can take for an accurate BAS:

  1. Check to ensure all bank, credit card, overdraft, loan, and petty cash accounts are reconciled with the original bank statements at the end of every BAS quarter.
  2. Print your monthly profit and loss (P&L) report for the respective BAS quarter, and check for abnormalities in income or expenditure over the three months. You should also compare this quarter’s P&L report with the P&L report from the previous quarter (in the same financial year), as well as the P&L report from the same quarter in the previous financial year to detect any unexpected transactions.
  3. Print out the balance sheet as at the end of the BAS quarter. Note the balances for the wage and salary, payroll, payable, super expense and payable, and PAYG and GST accounts, and investigate any abnormalities.
  4. Generate the general ledger exceptions report to review any abnormal transactions. This report will indicate any differences in the GST codes for the same types of purchases or sales by comparing the current transactions with previous transactions.
  5. Print your BAS and compare with it with last quarter’s BAS, as well as the BAS from the same quarter of the previous year, and ensure that your GST, PAYG, sales, and purchases are consistent across all three BAS’.
  6. Lodge and pay your BAS on time to avoid penalties, and remember to record the BAS payment in your accounting software.

Although this may appear to be ‘double handling’, in fact, it eliminates double handling by ensuring that the activity statements you lodge with the ATO are correct and error-free. Typically, the mistakes this method turns up are ones that would be of benefit to the ATO and not to the business owner. So rather than give the ATO more money than you need to, make sure you follow this method for an error-free BAS lodgment.

An Experienced Bookkeeper in WA

bookkeeper-rockingham-wa
Tracey Marino is available to provide bookkeeping services in the Rockingham area of WA.

Looking for a reliable and accurate bookkeeper to manage your business’ daily or weekly bookkeeping and accounts, either in the cloud (remotely) or in-person?

Tracey Marino is available to service businesses located in Port Kennedy, Warnbro, Baldivis, Secret Harbour, Golden Bay, Safety Bay, Shoalwater, Rockingham and Cooloongup, WA. Tracey is a an expert in MYOB AccountRight, QuickBooks and Microsoft Excel and can prepare and lodge your company’s BAS, set up credit management systems, along with carrying out all manner of day-to-day accounting functions for small to medium businesses. Find out more about Tracey’s experience at her profile page.

Our National Bookkeeping website has recently undergone a significant upgrade so keep a look out for more stories about featured bookkeepers in forthcoming blogs. Join now and we can feature YOU in our articles too.

Posted on

Why Use a Bookkeeper?

Bookkeeping may be getting easier but do you really want to do it?

MYOB bookkeeper
You don’t need to be a BAS agent to be a successful and profitable bookkeeper.

EVEN WITH THE LATEST accounting programs, like Xero and MYOB Account Right Live making it easier for small business owners to manage their bookkeeping themselves, a bookkeeper is still an invaluable asset to any business. (It’s also the truth that, as much as companies like Xero tell you they make it a cinch to do your own bookkeeping, online account-keeping software programs are still complex and time-consuming to learn to use properly.)

We wrote a post recently about why contract bookkeeping is a good business venture for people looking to start a low-risk business. 

Here we certainly addressed the reasons bookkeeping is a good professional pursuit, but now it’s time to look at the benefits hiring a bookkeeper has to a business owner.

A bookkeeper makes a good, legal sense

The most obvious benefit, of course, is that by having someone to take care of your bookkeeping it frees you up to concentrate on the aspect of your business that you’re best at. But aside from being a legal requirement for every business to keep accurate records, it also helps you to monitor how well your business is performing.

A bookkeeper will work on your bookkeeping every week or even a few times a week, depending on your business needs, enabling you to monitor your daily income and expenditure, and if your accounting software has bank feed enabled, you can monitor it in real-time, too. This is crucial for businesses with many expenses or running costs – businesses that purchase stock or employ staff, for instance – to be able to manage their cash flow.

Paying a bookkeeper can save you money

But having your bookkeeping kept up-to-date also has other benefits, particularly in relation to regulations such as when you need to register for GST, and so forth. Here are five more benefits to your business if you hire bookkeeper to look after your books:

  1. Keeps your tax bill down: Businesses that don’t have someone taking care of their bookkeeping end up spend more with their tax accountant, so it’s really false economy if you think you’re saving money by going without a bookkeeper. It also potentially costs you money in other aspects of your business too, as you’ll find out.
  2. Can manage invoicing: Sure, it’s super easy to invoice your customers and clients now that most good cloud-accounting programs have apps for smartphones and tablets, but there are still plenty of businesses that don’t use the accounting apps on their phones or tablets because of the complex nature of their business. A bookkeeper can take care of this.
  3. To take care of your payroll: When you hire employees or sub-contractors, you’re entering a whole new realm of business. There are superannuation contributions, payroll tax, and a heap of other regulations that bookkeepers have to stay up on, but you don’t.
  4. You’ll avoid ‘late’ penalties: The ATO takes late lodgments pretty seriously, and the penalty for the late lodgment of a BAS or tax return can be up to $850 for each late lodgment. If you’re consistently late lodging your BAS or tax returns, then a bookkeeper basically pays for itself, because unlike fines or penalties, which are not tax deductible, the services of a bookkeeper are.
  5. Chasing unpaid invoices: The reality of running a business, unfortunately, is that a lot of people you’ll do work for won’t pay you on time. Chasing unpaid invoices is a delicate and time-consuming process, particularly when it starts to affect your cash flow and prevents you from taking on more work – buying stock or supplies, for example. It’s always a good idea to separate the face of business from debt collection. It helps keep the client relationship warm and fuzzy, while cash continues to come in the door.

Now that cloud-accounting programs have made it more possible for bookkeepers to work from home and contract their services to many different clients, making it easier and more affordable for small businesses to retain a bookkeeper.

— EzyLearn is Behind a New Bookkeeping Initiative 

find a local bookkeeper

EzyLearn now features the National Bookkeeping Directory, a service which connects businesses owners with bookkeepers, based on their business needs or location. If you’re looking for a qualified, local bookkeeper to manage your books, visit the National Bookkeeping website.

Alternatively, if you’re thinking of starting your own bookkeeping business, National Bookkeeping is looking for smart entrepreneurs to become licensees.

National Bookkeeping provides full access to the entire suite of EzyLearn training courses, including our MYOB training courses and Small Business Management Course, in addition to providing help getting business leads. For more information, visit the National Bookkeeping website or read the FAQs page.


 

Posted on

5 x MYOB Training Courses and 12 Months Access

MYOB Training Courses delivered in Sydney, Melbourne, Brisbane, Adelaide, Perth, Darwin and HobartMYOB Courses

Because it’s the beginning of the year we are receiving a lot of calls from students who are looking to do an MYOB Course so we are thrilled to confirm that we offer access to ALL of our MYOB Courses for one low price and 12 months course access.

When we say ALL, we mean

Why All MYOB Courses for One Price?

You can follow our journey from operating training centres in Sydney’s Dee Why, to the decision to go 100% online at the About EzyLearn page on our website, but I’ll sum it up in 1 paragraph here:

We can guarantee consistent course content to every student, with MYOB Course content developed over 15 years in teaching people how to use MYOB and from some of the best MYOB Trainers in Australia. By creating our own MYOB courses and updating them we are able to focus on the content of our courses as well as the systems to support it online rather than paying for office rent, computers and software licences, trainers and advertising.

MYOB Course Options

The only decision you need to make is whether you want an MYOB certificate and 12 months or lifetime course access. Remember that unlike some MYOB course providers our students can move freely from one course to the next as they please and use the course as a resource while at their new job or operating their own bookkeeping business.

MYOB Videos, Training Workbooks and Knowledge Reviews

With a 100% focus on MYOB Course content we create every form of training material for MYOB accounting software: Videos, Workbooks (with step-by-step exercises) and Knowledge Reviews that test your skills. You can watch a video and try to replicate it with the free MYOB software or follow the exercises in the MYOB Trainingg Workbooks to perform tasks that bookkeepers perform every day in their working environment.

Money-back Guarantee

When we were the first training company to offer MYOB courses online in 2008 we offered the money-back guarantee because not everybody had great broadband Internet speeds, not everyone knew how to navigate around websites and online learning management systems and people where generally scared to use their credit card online. Now-a-days we find that the biggest reason some students find it a comfort is because many students are Mac users and are not sure that they would learn by using MYOB Course content created for the Windows versions of the MYOB software.

Why Thousands of Students Choose EzyLearn for MYOB EVERY Year

We use the Content Marketing approach to building our brand and product awareness and it takes a lot of effort to put the amount of detail we put on our website and in our blog posts. We do it because it shows an ongoing commitment to openness but also to leave no doubt as to exactly what we offer and how we support it. If you want to get to know more about us read some of our blog posts or watch some sample videos. If you are ready to enrol into an online MYOB course then enrol now online and start by 5pm next business day!

Posted on

So You Think You Can Be an Entrepreneur?

entrepreneur
Entrepreneurs are strong-minded individuals – but we’ve found there are at least 5 other qualities they tend to possess that leads to their business success.

In running our Small Business Management Course and MYOB Training Courses, one of most common reasons we find that people want to start their own businesses is to be their own boss. This is a perfectly understandable sentiment — but it’s not necessarily conducive to making a small business work.

Entrepreneurs are known to be people who manage starting up and/or bringing to fruition their own businesses and ventures, but entrepreneurs are a certain breed and as many find out the hard way, self-employment is not for everyone.

The Qualities of Entrepreneurs

Mental Fortitude

Even just having a brilliant idea and passion isn’t quite enough — although they’re two fantastic qualities to get you off to a flying start. To start your own business you need to be mentally strong so you can face the various disappointments that sometimes come with self-employment and come out the other side.

We have found in our experience that mental fortitude seems to go hand in glove with 5 other qualities possessed by successful entrepreneurs:

1. You don’t waste time with self-pity: entrepreneurs don’t have the time to waste feeling sorry for themselves when something doesn’t work out the way they hoped — they emerge from trying situations with self-awareness and gratitude and soldier on even after a failure. Indeed, I’ve heard one successful entrepreneur say that in order to attain his successes, he probably first failed more than anyone he knows.

2. You don’t give away your power: entrepreneurs avoid spending time with people who make them feel inferior because they understand they’re in control of their actions and know that their strength is in their ability to manage the way they respond.

3. You’re excited by change: entrepreneurs embrace change — and in some cases, even seek it out. In fact, becoming complacent is probably one of their biggest fears and so they seek out new challenges regularly.

4. You don’t make the same mistakes over and over: a good entrepreneur takes full responsibility for past behaviour and is willing to learn from mistakes. They don’t repeat the same actions, hoping for a different result.

5. You know the world doesn’t owe you anything: So the economy is bad — that doesn’t mean anyone owes you anything, least of all a living. Entrepreneurs know this; they know that their success is entirely dependent on their drive, ambition and motivation to do well in their lives and careers.

***

So do you feel you have what’s needed to take the plunge and start running your own, or someone else’s, small business? Perhaps you believe you have the mental strength to succeed in your own venture but could do with some more direction by others who have proved they have what it takes to launch and maintain successful businesses of their own?

Then take a look at our Small Business Management Course — it takes you through every aspect of managing a small business and introduces you to successful entrepreneurs and like-minded business people: invaluable resources for seeing to it that you can truly succeed in your own small business. What are you waiting for!

Posted on 1 Comment

Invoice Your Customers Directly Using PayPal

We were recently surveying our PayPal account and discovered that you can now invoice customers directly using PayPal. While it doesn’t eradicate the need for a good piece of accounting software, this facility makes it very easy for people to get started in business — particularly businesses with very few expenses.

PayPal 2014 Screen - Manage Invoices - New Invoice Screen

It’s a Great Time to Start a Business!

If you’ve been thinking about starting a business, then there has never been the more perfect time to do it. Really, we mean that! In fact, it’s why we started developing our digital business course, because there are now so many online tools to help people get a small business off the ground — it’s just a case of knowing what those tools are and how to use them.

EzyLearn Digital Business Course

This is where we come in. Our Digital Business Course is designed to take you through every step involved in starting an online business — from creating a website to understanding how to manage and operate a small business.

One great facility for any online business, whether you’re selling products or services, is having a PayPal account, which allows you to accept payments from customers all over the world.

The Benefits of PayPal for Your Business

Using PayPal for your business transactions also enables you to expand your business networks right around the globe. You can tap into the global marketplace of remote workers and ensure your transactions are safe and secure every time.

With PayPal as your primary method for accepting payments from customers, you’re able to invoice clients and offer them the option of paying by credit card for free. As a remote worker, this is an easy way to send invoices and reconcile payments all in the one place.

But say you’re not just an online business. Say you’d like to be able to take credit card payments in person too. Well, PayPal also offers a service, called PayPal Here, which allows you to turn any smartphone into a credit card processing terminal, so it doesn’t matter where you are — you can always get paid.

***

There really has never been a better time to start a business than now, so if you would like more information on our Digital Business Course or our Small Business Management Course which equips you with the knowledge you need to run your own or someone else’s small business (plus you conclude the course with a comprehensive business plan), then contact our team today — we’ll help you get started!

Posted on

Does Your Bookkeeper Have a Clue?

bookkeeper induction program
Having a bookkeeper induction program will add value to your business.

Having accurate business records is vitally important for any business — and most of that hinges on accurate account keeping. If you’re a small business looking to hire a bookkeeper, you want someone who’ll be able to manage all of the data entry and coding for your company accurately and efficiently. The best way to ensure this is to have a bookkeeping induction program.

The Benefits of Induction

We’ve written about induction programs before, where we talked about how induction programs help boost morale and keep staff engaged. But they’re also important to ensure that each new employee understands what’s expected of them, what they can expect of you as an employer, and what your company’s processes and procedures are.

Employing an MYOB bookkeeper is a good start — particularly if you employ an ex-EzyLearn student. This is because our MYOB training courses act as a quasi induction program to bookkeeping.

But by establishing a bookkeeper induction program at your company, you can make certain that each new bookkeeper, whether they’re a contractor or a permanent employee, will manage your accounts the same way.

Low Cost Online Induction Program Options

At EzyLearn, we offer low-cost online induction program options that are perfect for small businesses. Depending on your requirements, you can create your induction program in PowerPoint and upload it to a learning management system.

From here, you’re able to update and add to it as frequently as you like. Best of all, you can create as many induction training courses as you like. You can separate contractor inductions from new employee inductions, accounting inductions from admin inductions, and so on.

***

It’s important to have systems in place for your business, and an induction program allows you to easily train staff in your company’s processes and procedures. It adds value to your business as well. If you’d like to learn more about our induction programs, visit our website or contact our team.

 

Posted on

The EzyLearn MYOB Course Community

At EzyLearn we offer a handful of online training courses: Microsoft Office (Excel, Word, PowerPoint and Outlook), MYOB Accounting, and WordPress website design and blogging. There are many companies who promote courses online and that’s just what they do — promote courses online — but we try to be a little different.

Here’s why:

  • We offer only a handful of courses and we do them very well
  • Our courses come with LIFETIME Membership
  • As a student you receive fresh, new content without paying extra
  • Where possible, we provide real life exercise files so you can work with the software.

Our Online Community

Our experience with thousands of students has taught us that some students need more interaction than just the videos. They also like to bounce off other people to better understand the software they are learning.

That’s why we provide our Student Community and Tutor Support — to provide our students with the ability to communicate with fellow students, as well as ask questions of our experienced community moderators. It’s like having your own tutor that you can ask questions to who can provide quality answers based on their own experience in their relative industries.

Our students range from job seekers to small business owners and existing bookkeepers wanting to learn more, to accountants who may be thinking of leaving the corporate world and setting up a small business for themselves (or even seeking greater work-life balance).

Qualified Moderators

Our student support community is moderated by our MYOB Bookkeeper and Registered BAS agent, giving students the benefit of both communication with other course attendees (to socialise and to learn) as well as obtain answers to specific questions.

Annual Membership

Our Student Community and Tutor Support is provided on a yearly membership basis and you can continue or opt-out as you please each year. The service is available to existing EzyLearn students or new students enrolling into any one of our courses.

Posted on

Will vs Skill: How Desirable are Your Employees in the Workplace?

Employees possessing both will and skill are the most desirable in the workplace.
Employees possessing both will and skill are the most desirable in the workplace.

At EzyLearn, our flagship training course is the MYOB training course, which is sort of like an induction into the role of a bookkeeper in that it provides students with an overview of the duties typically carried out by a bookkeeper. Most of our students take our MYOB training course because they both want and need to know how to use the software in order to find work as a bookkeeper.

In the world of business training and coaching, this is called the Will vs. Skill Matrix. Employees who have both the will to succeed and the skill to succeed are highly desirable in the workplace.

Transparency, Will and Skill

Employees who have only one of those attributes, however, are less desirable. Helping staff maintain both the will and the skill to succeed in their jobs has a lot to do with how transparent you are as an organisation.

We’ve mentioned transparency in business before, notably in relation to induction training programs. Induction training programs are a highly efficient way to communicate easily and efficiently with your staff, while also testing their will and skill to succeed at their jobs.

While most induction training programs are used to merely address the requirements of the Work Health and Safety Act, or to induct contractors and consultants to a business’ premises, induction training programs can also be used to further your employees’ professional development.

Furthering your employees’ professional development can be done by providing your staff with online training courses that are relevant and useful to their jobs, such as a Word or Excel training course. By delivering this content online, it allows your staff to complete the course at their own pace, in an informal environment – at home or at their desk at work, rather than in a dedicated training centre on a dedicated day – and it also allows you to monitor their progress.

As the business owner, by being able to see how your employees are getting on with the training courses can illuminate areas where your staff could benefit from further training; it can also highlight those staff member who possess the will and the skill to succeed.

Those staff members who are have both the will and the skill to succeed in their jobs also happen to be highly engaged, and as we mentioned in a previous post, more productive.

***

If you’re looking for ways to keep your staff highly engaged with your business, we can help you tailor and deliver highly engaging induction training courses to your staff. Visit our website for more information, or contact us today for a quote.