Search Results for:

Posted on by — 1 Comment

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 by

Are You Making these GST Mistakes in Your Bookkeeping?

find a good local or remote bookkeeper

Being Jack of All Trades can land you in hot water with BAS

find a bas agent in your local area
Don’t submit inaccurate financial documents by trying to do everything yourself by way of bookkeeping.

IT’S PERHAPS EASIER TO do your own bookkeeping these days than it used to be; particularly if you’re using a cloud accounting program like MYOB, Xero or QuickBooks, which are among the easiest, yet robust, accounting applications currently on the market.

But even so, there are many aspects of Australian tax that, while accounting software makes it possible to carry them out yourself (like business activity statements, for example), it’s not a good idea unless you really know what you’re doing. Here are the three GST mistakes nearly every business owner makes in their bookkeeping.

Continue reading Are You Making these GST Mistakes in Your Bookkeeping?
Posted on by — 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 (Excel, PowerPoint, Word) or social media and WordPress web design). 

 

Posted on by

What to Do When You Have More than One Income Stream

Why it’s important to track your income streams

keep-track-of-more-than-one-income-stream-using-excel-myob-xero-learn-online-training-course-videos
It can be easy to lose track of separate income streams; Excel is a great tool for monitoring which work your income is coming from.

IF YOU’RE AN INDEPENDENT contractor, or you’re a full-time employee about to start up a side business, then you need to be able to keep a good track of all your income streams. There are a couple of reasons for this and both of them relate to tax.  Continue reading What to Do When You Have More than One Income Stream

Posted on by

When Your Business Strategy Changes

There are websites that make it easy to change your business name

changes in business strategy xero cheap online learning course
Having a plan rather than changing your business strategy in an ad hoc fashion, ensures greater success of your business going forward.

PLENTY OF BUSINESS OWNERS change their business strategy, but what makes this successful? We say, above all, planning and a willingness to change the ordinary operations of your business. In a new workbook contained in our Xero training courses, we take you through the steps you would take in Xero to affect a change in business strategy.

In this blog post, we’re going to look more generally at some of the things you might need to do if you were making a change to your business strategy — even before you would start making these changes in your accounting software.

Business name change

A change of business strategy and direction may warrant a business name change. As a basic example, a builder who begins offering plumbing, electrical, and handyman services should change their business name from John’s Building Services, for example, to John’s Building and Home Maintenance Services.

If considering a business name change, visit the ASIC website. There you’ll be able to register a new business name and make sure one you’re thinking of doesn’t already exist. ASIC doesn’t allow you to update or change your business name, but provided you’re operating your business under the same structure — i.e., sole trader — there’s no limit to the number of business names you can register and assign to your ABN.

In April this year, the business.gov website launched a new Business Registration Service, which although still in Beta, allows you to easily and quickly apply for a business name, ABN, company, and tax registrations for free. At the moment it’s only available for new businesses — whether they’re sole traders, partnerships, companies or joint ventures — but it’ll soon be rolled out to existing businesses, trusts, and superannuation funds.

Registering for GST

Many contractors don’t register for GST because they do a combination of contract work on their ABN and TFN. Provided their business doesn’t generate $75,000 per year or more, they won’t have to register for GST, even if they do earn more than that by also working as a contractor on their TFN.

If the change in business strategy means your business is going to generate substantially more than $75,000 per year, or even if your suspect it may get close to it, you should register your business for GST.

You can register for GST via the ATO’s Business Portal. Registering for GST does mean your business will need to lodge regular business activity statements. This is additional compliance that can yield fines for late or inaccurate lodgements.

If you’d like to try and defer registering for GST for as long as possible, run a profit and loss statement in Xero and compare your current revenue with the estimated additional revenue your new business strategy will generate.

If there’s good, safe margin between your projected income and the $75,000 GST threshold, you can hold off.

You can learn what you need to implement the financial side of your changed business strategy, plus how to run profit and loss statements, complete and lodge business activity statements and much more in our Xero training courses. For more information, visit our website.

learn Xero online learning videos cheapest

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 by

A Great Trick for Getting Rid of Nerves on a Job Interview

Who’s interviewing whom?

The truth is that you’re interviewing the company as much as they are interviewing you. When you look at it this way, the job interview suddenly becomes less daunting.

DO YOU KNOW THERE is no reason to find a job interview nerve wracking, even though so many people do. It’s simple enough to understand why. People put a lot of pressure on themselves to give the best impression and come out as the successful candidate. And look, these things are important, no argument there, but together the pressure to give a good impression AND win the job itself, can conspire to turn you into a “yes man” (or woman).

A job interview is about finding a suitable candidate for a position available at a company. This is not a one way street. As much as you need to give a good impression, so does the company, and if you look at it that way — that you’re interviewing them as much as they are you — it takes the pressure off A LOT.

Ask questions

I don’t just mean at the end when they ask if you have any questions — honestly, you’re probably not likely to have any questions by this point, because if you’ve been paying attention, you should have covered any of questions you had going in.

When you’re asked how you would handle a particular situation or what your approach to something might be, ask for more information if you need or qualify the situation they’re referring. People are often afraid to do this in case they look silly, when actually it makes you look quite smart, and show that you’re not afraid of authority.

Take your time

using audio in powerpointDon’t rush to answer a question. There’s no real way to prepare for an interviewer’s questions, and they know that. However, your answers should also be rooted in some previous experience you’ve had, so while it may take you a while to wrack your brains for a previous example, you shouldn’t be unable to answer either. If you can’t think of an exact experience, discuss a similar one and how you handled that.

Be yourself and relax

This is so important, because as much as the interviewer may be looking for the most skilled candidate, they’re also looking to make sure you’re not a robot. Show your personality, show you’re a human, establish some rapport with your interviewers. Some of the interview process is confirming you are what you say you are, but mostly it’s finding out if you’re someone they want working for them.

In the IT and engineering industry, interviews aren’t even set up to determine skill sets, but rather personality traits, because many companies today are looking for programmers and engineers who can communicate to stakeholders in plain English, rather than tech talk.

***

Remember, who you are in the interview should reflect and expand on who you are in your resume and cover letter. You can learn how to use PowerPoint to create a resume in our PowerPoint training courses. For more information, visit our website.

You can also brush up on Word for your resume presentation by enrolling in our Microsoft Word online training courses. You’ll be amazed at the things you can create with a comprehensive understanding of Word.

learn PowerPoint online training course

Gone are the days of excruciatingly dull PowerPoint slide presentations… Nowadays PowerPoint is the hidden gem used to generate animations, videos, movies, advertising and graphics. It’s a great ally to the marketer or social media person in your organisation. This creative program can also be used to conjure up the most beautiful and modern pictorial slides to enhance any presentation or induction.

Find out more about our 2016 version PowerPoint courses.

 

Posted on by

Online Training: A Cost Effective Way to Train and Motivate Your Staff

Take an online course to build will AND skill

online training for staff morale
It’s a real buzz when you learn something new: a great way to up-skill your staff members and keep people interested at work is to provide them with online training course material.

OUR MYOB TRAINING COURSE is basically 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 versus 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.

Help your staff upskill with a Word or Excel course

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. You’ll be surprised how many tasks can be done with these software applications — and therefore how empowering this knowledge becomes!

boosting staff morale with online training courseOnline delivery of this content 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.

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.

learn xero online training course videosAt 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 by — 2 Comments

Should You Start a Business That You LOVE or a Business YOU CAN DO?

Pairing knowledge with a gap in the market

how to find the right career path
I love watching TV. And I have an opinion on many things. Doesn’t mean I can monetise the pairing of these two. Or can I? Did somebody say Gogglebox? 

CONFUCIOUS ONCE SAID: “FIND a job you love and you’ll never have to work a day in your life”. That’s good advice, although it’s not always practical.

After all, I love watching television, but it’s probably impractical to try and monetise that to start a business — not impossible; but it is impractical.

A better measure of finding something you can turn into a business idea, and then a business, is to find something you’re good at, that also addresses a gap in the market. In other words, put your existing skills and work experience to use in a new, different way. Continue reading Should You Start a Business That You LOVE or a Business YOU CAN DO?

Posted on by

PowerPoint Case Study: Selling Safety and Compliance Systems

How PowerPoint helped sell a solution to major hospitals

Using powerpoint for sales presentations
We show you how PowerPoint presentations explained the problem, risks and THE SOLUTION successfully to major Australian hospitals.

A WELL-CRAFTED POWERPOINT presentation can turn your staff into salespeople — and turn your salespeople into sales superstars!

Our PowerPoint online training courses will show you how to create your own persuasive and compelling PowerPoint presentations. In this PowerPoint case study, we’re going to show you what our partner, EzyAccess, included in their sales presentations. These sales presentations were then shown to chief executive and senior managers at some of Australia’s largest hospitals.

Explaining “The Problem”

Hospitals are busy places that have lots of people coming and going every day, and a very ad-hoc way to manage them. In most cases, few hospitals policed their visitor and contractor management policies, which exposed them to many risks.

Explaining “The Risk”

Almost anyone could walk into a hospital and have access to its most sensitive areas — operating rooms, for example.

Likewise, contractors hired to perform work could subcontract it out to a person or entity unknown to the hospital and unqualified to perform that work. If that subcontractor or someone else — a patient, say — was injured, the hospital would held responsible.

Explaining “The Solution”

EzyAccess provided a cloud-based safety and compliance system that businesses could use to track visitors and contractors who were visiting their premises. It enabled businesses to stay compliant with Australia’s WHS laws, and to also ensure each person was familiar with the business’s own process and procedures to eliminate the business’s liability if someone was injured.

Chief executive-level presentations

Directors and chief executives are primarily interested in increasing their business’s efficiency and reducing financial risk to the company.

EzyAccess’s chief executive-level presentations explained how the EzyAccess safety and compliance system helped hospitals stay compliant with Australia’s WHS laws, kept their hospitals safe from unknown, unqualified entities, increased employee efficiency and reduced the financial risk of litigation.

Senior manager-level presentations

Unlike chief executives, who could be held personally liable if the business was found in breach of Australia’s WHS laws, senior managers were concerned with how implementing a new system would help (or potentially, impede) their direct reports.

Every business is resistant to change, particularly the implementation of new technologies that could require more time and effort on the part of their staff than the previous system. If this were to occur, there’s the additional risk that adoption would be slow.

The EzyAccess presentations to senior managers explained the adoption strategy in full, and how the system improved staff efficiency by eliminating the need to contact contractors about compliance documents.

Tailor presentations to stakeholders

Just as it’s important to target your ideal customer with your PowerPoint presentations, it’s also important that you target particular stakeholders within a business to ensure they see the value your product or service brings them.

It’s no use focusing an entire presentation to a chief executive on how easy the system is to use — this will certainly be a consideration for any chief executive, yes, but it won’t be the primary one. Just as it’s no good telling the staff on the frontline — the employees actually using the system — how much money and potential litigation it’ll save the company.

Our PowerPoint training courses will teach you how to create persuasive PowerPoint presentations that you can use to target key stakeholders within a business, to help you make a sale or get hired. Alternatively, our sales training courses will show you how to identify and target your ideal customer.

learn powerpoint online training videos
Our course content includes real life case studies to make learning more fun and relevant.

 

At EzyLearn we are constantly refreshing the content of our online training courses. Where possible, we draw on real-life case studies as examples, to help you learn, and apply your skills, in a relevant way that makes sense. Visit our Micro Courses page to learn more.

 

Posted on by — 2 Comments

Xero’s Reports to Help Decide Whether to Buy or Rent

Xero’s reports can help you decide to buy or rent your business premises

learn xero online training course
There are pros and cons to owning your business premises depending on your circumstances, but appreciation is a significant benefit.

A BIG DECISION FOR A NUMBER of business owners is whether they should buy their own premises. And because there are upsides and downsides to both owning and renting your business’s premises, we’re going to look at some of the considerations you should take into account first.

Buying is an appreciating asset

The biggest advantage to buying is that it’s an asset that appreciates over time. As such, purchasing a property can provide your business with an additional source of income that, over time, will allow you to grow your business.

Buying also gives you access to equity that will allow you to use the property as a guarantee when you’re striking deals with potential suppliers and clients.

There are also tax advantages and deductions you wouldn’t ordinarily have by renting, something we discussed in a recent blog post about investing in a granny flat.

There are upfront costs to buying

That said, you shouldn’t overlook the upfront costs associated with buying. In particular, you’ll need to ensure you have the appropriate amount of capital available before you can buy.

There are certain reports you can run in your accounting software, which will provide you with a clear picture of your business’s financial health and help you determine whether buying is the best option for your business. We always suggest running regular reconciliation reports, even weekly, in say, Xero to help you know the true financial picture of your business.

Our online Xero training courses show you how to run reports that will help you make the vital business decisions; particularly relating to how a capital outlay like buying commercial premises would likely impact your cashflow.

Renting is flexible

If your business is relatively new or it’s generally difficult to predict your future growth over the next five to ten years, renting may be a more viable option. This allows your business to remain agile and offers flexibility that buying doesn’t.

Renting, for example, offers a better range of property types of locations that mightn’t be within your price range if you were to buy.

Furthermore, shared office spaces or co-working spaces are good options for businesses with a small, mostly virtual team, or startups looking for meet like minded individuals.

You miss out on equity gains when renting

The main downside to renting your business premises is that, over time, it is your landlord’s equity you are contributing to, rather than building your own asset.

***

Using your accounting software to determine the financial health of your business will help you to make important business decisions. Our Xero training courses will teach you how to run different financial reports. Visit our website for more information.

online bookkeeping courses to earn cpd pointsEzyLearn 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 by

Paying Several Employees With One Payroll Payment

MYOB and Xero now make payroll easier to manage

myob and xero online payroll management
Struggling to manage your online payroll management? Our Xero and MYOB courses will help you get the most out of this software so you can manage payroll in house.

MANY COMPANIES OUTSOURCE PAYROLL because it contains many moving parts. For instance, there’s the payment of wages each week or fortnight or month, sure. But there’s also superannuation contributions, PAYG obligations, annual and sick leave accrual. 

Fortunately, most accounting apps like Xero and MYOB have made payroll easier to manage, particularly if you only have a handful of employees.

Superannuation clearing houses

Nearly every major cloud accounting package has a connected superannuation clearing house within its payroll package. Xero and MYOB are both SuperStream compliant, a government initiative to help business owners tell which accounting software apps will let them make electronic superannuation payments. And QuickBooks uses a partner payroll system which is also SuperStream compliant.

Batch wage payments

Electronic superannuation payments are one way that paying staff is made easier, but paying a dozen or so employees individually each week or fortnight can be tedious. Fortunately, both Xero and MYOB have a ‘pay run’ function that lets you make batch wage payments. This eliminates the tedium of paying employees individually, as well as the potential for error.

Accounting software calculates entitlements

MYOB, Xero and QuickBooks, if you’ve set up your employees correctly and have the appropriate payroll subscription, will also calculate your employees’ sick and annual leave entitlements, also reducing the time it takes to process payroll and the potential for error.

Our MYOB training courses and our Xero training courses both cover payroll, where you’ll learn how to set up employees correctly, process wage payments and more. Using a cloud accounting program for payroll, saves time and reduces errors. Visit our website for more information.

EzyLearn courses now include real life case studies

managing ad hoc payrollAt EzyLearn we are constantly refreshing the content of our online training courses. Relevant to those of you doing Payroll, might be our Excel Ad Hoc Payroll case study which is part of our Intermediate Excel Online Training Courses. Where possible, we draw on real-life case studies as examples, to help you learn, and apply your skills, in a relevant way that makes sense. Visit our Micro Courses page to learn more.

 

Posted on by

What Does a Typical Staff Roster Look Like?

What Does a Staff Roster Need to Include?

staff roster sheets
Staff roster sheets have come a long way since the time of punch in-punch out cards; let us show you how to create intricate rosters that include RDOs, leave, breaks and so forth. 

IF YOUR BUSINESS RELIES on staff to work different shifts, then you’ll need to provide them with a staff roster. We’ve written about the three ways you can create staff rosters for free before.

One of the exercises in our Microsoft Excel Training Course shows you how to create your own staff roster, so we’re not going to do that here. Instead, we’re going point out the things you need to include in a staff roster.

Different employment types

If your business employs a combination of full time, part-time and casual staff, you’ll need to prioritise the full time first, then the part time staff, as by law, they’re guaranteed a certain number of hours each week — 38 hours for full time staff, fewer than 38 hours for part time staff.

Employee RDOs, leave

A rostered day off (RDO) is a day in a roster period that an employee doesn’t have to work and these can be paid or unpaid depending on individual agreements. Both full time and part time staff members will have annual and sick leave entitlements. Make sure you mark these up on your rosters. It’s not just easier to schedule the rest of your employees when you can see who’s working and who’s not working, but it’s also useful for the rest of your team to know this as well.

Staff breaks

Depending on the modern award and the duration of the shift, certain staff members will be entitled to different kinds of breaks — two 15 minute breaks and one 30 minute lunch break, is common in retail, for example. Mark these break times up in your staff roster, so the staff member can see when they’re due for breaks.

Employee signature

Leave a column on your roster, so each employee can sign off at the end of each week to confirm they worked their rostered shifts. This is important, particularly if any of your employees ever claim a discrepancy in their pays due to shift changes, etc.

*** 

Our Microsoft Excel training courses will show you how to modify margins and set up templates, skills you can use to create your own free staff roster in Excel — or Google Docs, if you prefer. Visit our website for more information on our suite of Excel online training courses.  

learn excel online training course

At EzyLearn we are constantly refreshing the content of our online training courses. Where possible, we draw on real-life case studies as examples, to help you learn, and apply your skills, in a relevant way that makes sense. Visit our Micro Courses page to learn more.

And of course, all of our online training courses can be counted towards your Continuing Professional Development (CPD) points!

 

 

 

 

 

 

Posted on by

Why Your Business Needs a Bookkeeping Procedures Manual

Documenting procedures helps keep your bookkeeping up to speed

bookkeeping procedures manual rescue bookkeeping work
Rescue bookkeeping is not ideal – it’s often expensive and shows you’re not in control. A bookkeeping procedures manual will outline what bookkeeping needs to be done, when.

IN A PREVIOUS POST we talked about how to tell when you need rescue bookkeeping, which is basically when a business is behind on its bookkeeping by three months or more and the deadline is looming to lodge their activity statements.

Rescue bookkeeping work costs more than having your bookkeeping taken care of regularly, because it’s often messy and there are no procedures in place to manage the bookkeeping efficiently.

What’s a bookkeeping procedures manual?

bookkeeping procedures manualA bookkeeping procedures manual clearly identifies the regular tasks and activities your bookkeeper needs to take each week, fortnight, month or quarter to ensure your bookkeeping is kept up-to-date. This not only gives you the peace of mind that your bookkeeper is staying on top of your books, but it also helps you to understand what’s going on with your business.

If you require regular P&L statements or balance sheets, having a procedures manual to clearly outline how frequently they’ll be created helps you to stay on top of your business’ financials.

A typical procedures manual will include:

  • Simple steps that are easy-to-understand and succinct
  • Tasks are written up in a step-by-step style, so they can be followed logically
  • References, links or examples are included to help readers understand
  • Contain a number of formats — written steps, flow charts or checklists.

Rather than leaving your bookkeeping to the last minute, so you’re always operating your business in dark, organise to have bookkeeper create a procedures manual to regularly take care of your business’s bookkeeping.

We Can Help You Find a Good Local Bookkeeper

find a local bookkeeper

We have bookkeepers, BAS agents and accountants located across Australia, available to help businesses in need of rescue bookkeeping work. Visit our online bookkeeping directory, 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. 

Go to National Bookkeeping for more information, to see our rates or to request a quote.

Online bookkeeping accounting training courses for CPD points

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 by

We Don’t Lock Our Microsoft Excel Course Content

You Can Use the Calculation Fields in our Excel Exercises as Often as You Like!

learn Excel online training course unlocked calculations and formulas
We keep all the calculation fields in our Excel course exercises unlocked so you can play around with different figures of your own as often as you like.

DESPITE THE POPULARITY OF cloud-based accounting software applications like Xero and MYOB, Excel still remains one of the most indispensable software programs for businesses and individuals alike. That is why we always make it a priority to constantly update our Microsoft Excel Training Course.

You can apply Excel to so much

Accounting software, even robust packages like MYOB, only allow you to perform a finite number of functions that relate to business accounting. However, Excel can be used for a multitude of different purposes — both business and personal, merely one of which is to develop a financial forecast for an investment.

EzyLearn courses provide real-life case studies

learn excel online training course

Our Intermediate Excel Training Course uses the construction of a granny flat for investment purposes as a case study example. We chose a granny flat for the case study because most people construct them as an investment, whether they’re in business or not, so it’s a good real-world example.

It also deals with depreciation, which you can claim in your tax, regardless of whether you’re in business or not.

Our calculation fields remain “unlocked”

But even though, with the current property booms in our major cities, granny flat construction has become more common, it is not so common that every person taking our Excel courses is planning to build a granny flat for their next investment. That’s why we decided not to lock our course content.

What does this mean? It means that all the calculation fields in the exercise files of our Excel training courses are unlocked, so that your education remains unlocked too. You’re free to play around and replicate them as you need, so you can get a proper handle of how to use Excel in business or for work.

***

Visit our website for more information on our Microsoft Excel Training Course, with its new granny flats case study. We provide a range of online Excel training courses for beginners’, intermediate and advanced students.

Online bookkeeping accounting training courses for CPD points

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 by

EOFY: Organise Your Reports and Records

We Show You The Reports to Generate Now for End of June

profit and loss statements P&Ls
Now’s time to take stock of the reports that need to be generated to keep you GST and tax compliant.

THE LAST QUARTER OF the 2016/17 financial year is upon us, so now is the time to organise your reports and records; including Profit and Loss Statements, Accounts Receivable and Payable, PAYG and Super payments. We’ve previously written about writing off stock and inventory and getting your business expenses in order. In this post we’ll take a look at the reports and records you’ll need for EOFY, which you’ll learn how to produce in our MYOB BAS Reporting and GST or Xero GST, Reporting and BAS training courses.

Profit and loss statement

Depending on the structure of your business, you may be legally required to include a P&L statement with your tax return or activity statements. Your tax agent will be able to advise you if your business will be required to file a P&L, which  requires all of your bookkeeping to be up-to-date before you can run it.

Even if you don’t have to file one with your activity statements or tax returns, it’s still a good idea to run a P&L for your own sake. A P&L statement identifies whether your business has made a profit or loss and which accounting period these occurred.

Accounts receivable, payable

Find out who owes money to your business and to whom your business owes money. This is obviously part of the credit management process, which any good business will have in place already, but it’s a good idea to keep a steady eye on what’s coming in and what’s going out as EOFY approaches.

PAYG, superannuation

The end of each quarter brings a lot of PAYG and superannuation reporting, but EOFY brings a double whammy of activity statements tax returns and PAYG and superannuation compliance. You’ll need to run these reports so your bookkeeper can complete the payroll component of your returns.

Inventory stocktake

If you sell goods, you’ll need to complete a stocktake of your business’s inventory so that any missing stock can be written off, and to ensure you’re starting a clean slate for the new financial year.

***

Learn how to run the reports you’ll need for EOFY with our MYOB BAS Reporting and GST online training course or our Xero GST, Reporting and BAS training course.

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 (Excel, PowerPoint, Word) or social media and WordPress web design).