Posted on 1 Comment

There’s So Much Cool Stuff You Can Do With PowerPoint

PowerPoint: The Great Visual Aid to What You’re Saying

PowerPoint online training course
Save densely-worded slides for university lecture rooms: keep PowerPoint slides concise and use your presentation as a way of illustrating or highlighting what you’re saying.

Many people don’t realise what an excellent design tool PowerPoint is. It can be used for a lot more than just creating slideshows and presentations and is a great marketing and design tool for all kinds of business functions.

Generally speaking, when using PowerPoint, you should feature only one idea to a slide. A PowerPoint presentation is not an essay. It shouldn’t be filled with verbose text (unless perhaps you’re in a university lecture). In fact, as you will learn in our updated PowerPoint Training Course, sometimes a PowerPoint slide shouldn’t contain any text at all, or at least, very little. Continue reading There’s So Much Cool Stuff You Can Do With PowerPoint

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 4 Comments

Bet You Didn’t Know the Many Wonders of PowerPoint!

PowerPoint: The Great Untapped Design Tool

learn PowerPoint online training course
Wow – this PowerPoint presentation really is AMAAAZING!!

You know what PowerPoint is. It was installed on your computer when you bought Microsoft Office. You hate it. But have you thought that the reason you hate it is because a) you’ve never learned how to use it properly, and b) you associate it with boring corporate meetings and seminars?

If you answered YES to one or both of those questions, read on. If you answered NO, still read on! Continue reading Bet You Didn’t Know the Many Wonders of PowerPoint!

Posted on 2 Comments

The Wonders of Microsoft Excel’s 3D Formulas

Excel’s 3D Formulas Work Across Worksheets

Excel formulas online training courseWe’ve recently updated our Microsoft Excel Training Course content, because it remains one of the most indispensable tools for small businesses — and we’ve included a new exercise workbook which takes you through all the steps involved in developing a financial forecast for an investment.

We used a granny flat project as the case study in our financial forecasting workbook, but the beauty of Excel is that, once you get the formulas right, they can be replicated for any kind of investment, not just one for building a granny flat.

The wonderful 3D formula

3D formulas are one of the other many wonders of Excel. A 3D formula is basically a reference to the same cell or a range of cells within multiple Excel sheets. They’re a convenient way to reference several worksheets that follow the same pattern, with cells that contain the same type of data.

All functions work with 3D formulas

3D formulas can be used with all Excel functions — SUM, AVERAGE, PRODUCT, etc — which means that, using a 3D formula, you can easily create a financial forecasting sheet for any stage of an investment, and easily reference that data in another financial forecasting sheet. This is invaluable because there are very few projects or investments that can be contained in just one Excel worksheet.

A project like the granny flat case study in our online Excel Training Course, contains many moving parts — there’s the initial construction, then there’s the ongoing maintenance, and the rental income to manage. It would be impractical to keep all of this information contained within the one Excel worksheet.

3D formulas can be modified with time

The best part about using 3D formulas is that you only need to specify the start and end sheets (which for ease-of-use, you could just label ‘start’ and ‘end’) and the formula will reference all the worksheets between the start and end sheets, including those two sheets.

This means that, as your investment or project grows, once you’ve got the 3D formulas set up correctly, you can just add and subtract worksheets as necessary, and the calculations will update automatically.

***

Once you understand how to create and work with 3D formulas, you can use them for any project or investment that you create a financial forecast for — be it for a granny flat project, business investment or anything else that requires you to make a financial decision.

Visit our website for more information on our Microsoft Excel Training Course, which covers 3D formulas.

***

online bookkeeping courses to earn 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 1 Comment

Use DropBox to Store Your Tax Records Digitally

In a previous post I suggested it’s a good idea to create a digital filing system for your business receipts and tax records. Storing tax records digitally is not just a space saver — it’s also an efficient way to share information with your accountant and bookkeeper, especially if you’re working with a remote bookkeeper, as it’ll speed up the process.

Our Xero Bank Reconciliations and Journal Entries Course will also show you how to record these transactions in Xero. 

Continue reading Use DropBox to Store Your Tax Records Digitally
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 5 Comments

Performing Weekly Reconciliations in Xero

Why it Pays to do Regular Bank Reconciliations

bank reconciliations weekly
Doing regular weekly bank reconciliations will help avoid confusion or errors later on.

In our Xero Bank Reconciliations and Journal Entries Course, you’ll learn how to carry out each step in the reconciliation process, in particular how to set up bank feeds. Bank feeds are an important function that allows transactions on your linked bank account or credit card to automatically show up in Xero, so you (or your bookkeeper) don’t have to spend time entering the details from scratch.

Both contract bookkeepers working from home or employees working remotely or in the office can log in and perform bank recs using bank feed data. Continue reading Performing Weekly Reconciliations in Xero

Posted on 2 Comments

How Bank Feeds Save Time and Money

Making Light Work out of Bank Reconciliations

Xero bank feeds
Incorporating Xero bank feeds will save you time, money and stress.

Cloud accounting software’s greatest innovation was not putting the software in the cloud; it was introducing bank feeds. You’ll learn how to set up bank feeds in the latest version of Xero in our Xero Bank Reconciliations and Journal Entries course. For now however, we’re going to explain why you should — whether you’re a business owner doing your own bookkeeping or whether you’re a bookkeeper employed to do it for your clients — be using bank feeds.

Bank feeds in brief

A bank feed is an automatically created list of the transactions (spent and received) in your bank account that is imported into your Xero accounting software. For this to occur, you have to give Xero permission to access your account. Some people feel funny about this, but bank feeds have been around for so long now that, just like online shopping, there’s really nothing to worry about. I won’t go into how the technology works, but I will say that no one looks at your account data; you’re just allowing the free flow of information between your bank and Xero.

Direct bank feeds save time (and indirectly, money)

There was a time when you or your bookkeeper had to wait until your bank statement arrived before any transactions could be reconciled in your accounting software, usually at the end of the month. For businesses with a lot of transactions, either in the form of receivables or payables or both, reconciling a month’s worth is a finicky job that’s prone to errors.

With bank feeds, transactions will show up in your accounting software as soon as the payment leaves your account or credit card. If you (or your bookkeeper) get in the habit of reconciling your account on a daily, twice weekly or weekly basis, it makes it easier to accurately code each transaction because you’re only dealing with a few at a time. This results in fewer errors and fewer hours spent fixing them, and that saves money (read: time = money).

The Xero online courses we offer

Xero online training course bank feedsBank feeds are an important aspect of reconciling your (or your client’s) accounts. Our Xero Bank Reconciliations and Journal Entries Course covers setting up bank feeds, plus much much more. Alternatively, to take it back a step, you can learn about invoicing, credits and reporting in our Xero Day-to-Day Transactions Course.

Using an old version of Xero?

You might like to read this prior post we wrote explaining how you can add bank links on an older version of Xero or enrol for our Xero courses here.

 

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.

I’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. Continue reading Working Out Job Costs and How to Charge Your Clients

Posted on

What Bookkeepers Can Learn From Real Estate Agents: Facebook Advertising

Facebook – Great for Local Marketing

using facebook for bookkeeping marketing
Facebook can be extremely useful for marketing to a local audience.

In its decade of existence, Facebook has built up a wealth of data about its users, data that it likes to sell back to those who need it, in the form of targeted advertising. Facebook advertising, though similar in its approach, is very different to Google Ads in what it delivers.

Real estate agents discovered the value of Facebook advertising early, and have used a combination of images and videos to successfully deliver their marketing messages and sale pitches directly to their target market and in order to set their prices. Continue reading What Bookkeepers Can Learn From Real Estate Agents: Facebook Advertising

Posted on 1 Comment

What Bookkeepers Can Learn From Real Estate Agents: Using Video and Images

Focusing on Education Rather than Sales

how bookkeepers can use videoTHE INTERNET HAS CHANGED the way businesses market their services to prospects, from a simple sales message to an educational one.

Real estate agents caught onto this shift in buyer trends early and started creating online content to cater to these buyers.

Visit the website of any real estate agent and you’ll find lots of images and videos educating potential buyers about their services, previous sales and the local area they represent.

Continue reading What Bookkeepers Can Learn From Real Estate Agents: Using Video and Images

Posted on 1 Comment

What Bookkeepers Can Learn From Real Estate Agents: Sales Pitches

Never Fear: A “Sales” Pitch Can Really Just Be a Conversation

bookkeeping sales pitch
You actually don’t need to be ‘salesy’ at all; just find out how your services match another person’s needs.

After you’ve set the correct prices for your bookkeeping services, it’s time to perfect your sales pitch. It’s good to think about the way real estate agents sell a property to prospective buyers: Good sales agents don’t pitch to the buyer at all. Instead, they get to know the buyer and their needs.

If that happens to suit the property they’re selling, they tell them so. If it doesn’t they tell them that too. Often, they’ll mention another listing they have that might better suit the buyer.

Continue reading What Bookkeepers Can Learn From Real Estate Agents: Sales Pitches

Posted on 3 Comments

What Bookkeepers Can Learn From Real Estate Agents: Setting Prices

Don’t Reinvent the Wheel: Glean Relevant Info from the Property Industry

how much to charge as a bookkeeper
As a bookkeeper you can learn much from the humble, or not so humble, real estate agent!

As a bookkeeper, or someone thinking about becoming a bookkeeper, you may be surprised how much you can learn from real estate agents. For an example, take the way a real estate agent has to price a property for sale.

The key to selling a property quickly and efficiently, is setting the right price. A real estate agent who sets a price that’s too high for the market, isn’t doing her or his job properly. In such cases, the property will sit around for many weeks, or possibly even months, until the price is eventually reduced to one the market will bear, sometimes to well below market value.

Continue reading What Bookkeepers Can Learn From Real Estate Agents: Setting Prices

Posted on

There is No Official Diploma in Xero

Nationally Recognised Courses in Quickbooks, MYOB and Xero Courses do NOT Exist

Federal Government Department of Education and Training myskills website check on RTOs and accredited coursesA lot of our enquiries regarding MYOB, Xero and Quickbooks courses are from students looking for a bookkeeping job or start a bookkeeping business so when they ask about accredited or certified courses in accounting programs its because they want a qualification or because of what they’ve read on training websites – some of them are very confusing. The biggest confusion that I’ve come across lately has been about a Diploma in Xero! it doesn’t exist.

The best place to find out the truth about Nationally accredited courses is at the official government websites: http://training.gov.au/Home/Tga and https://www.myskills.gov.au/ and if you do a search at either of these sites for Xero,MYOB or Quickbooks and you’ll find there are no results and the reason is simple – bookkeeping skills are the same regardless of which software program you use.

When the Department of Education & Training began the process of regulating the education industry last decade I explored the options of applying to turn EzyLearn into an RTO and decided against it because of the red tape and high compliance costs. I’ve since spoken to managers at some VERY large companies that initially decided to jump on the RTO bandwagon only to discover many years later that it was all a huge cost for very little benefit. This doesn’t mean that RTO’s are bad, it’s just that the business owner needs to go through an evaluation process to see if it is financially viable. Here’s some recent news about RTO’s that have experienced financial difficulty.

Nationally Accredited-Certificate-IVin-Bookkeeping-online-training-course

EzyLearn has Partnered with an RTO for Cert IV in Bookkeeping!

EzyLearn creates, delivers and supports short courses, often called night courses, in the popular accounting software programs for a low cost and with the flexibility of online delivery so you can start quickly anytime (no waiting for a course schedule) and then progress at your own pace. See our Cloud Accounting Courses here.

If you’re looking for a Nationally Accredited Bookkeeping Certificate then learn more about what’s included and the costs for a Cert IV in Bookkeeping.

Compliance Requirements for RTO’s

A great example of one very onerous compliance task for RTO’s is that they need to keep student records for 30 years, 30 years! That’s more onerous that the 7 long years a business needs to keep tax records for the ATO! If you are really interested, take a detailed read of Standard 3 the site that governs RTO’s in Australia, Australian Skills Quality Authority (scroll down just past half way).

ezylearn-MYOB-training-workbooksEzyLearn has always been a creator of training course content and we focus on keeping our content up to date, marketing it, delivering it via an LMS and supporting students – that includes delivering exceptional value for a low price and using as many learning tools as we can (workbooks, exercise files, training workbooks, knowledge reviews).

When students ask us whether we are accredited or whether our certificates are accredited we try to find out what is most important for them: to get software skills and experience or to get a nationally accredited certificate – there is a MASSIVE difference in price and I’ve written this blog to help you find the right course for your circumstances.

Nationally Accredited Courses and RTO’s

Here are a couple things that will help you find the right course and the right training company.

  • Only an RTO (Registered Training Organisation) is able to deliver nationally accredited courses and more specifically the assessments that deem whether you are Competent or Not Yet Competent.
  • RTO’s can only deliver Courses based on the subjects available from a Nationally Accredited Library of subjects

If you are thinking about doing a Nationally Accredited Course check out whether that training provider is listed at this site: http://training.gov.au/Search. While you are at it see if the course they advertise is also listed.

Diplomas are Available for Accounting: Check your RTO

Satisfaction and Labour marketing information for bookeeping jobs if you have a Cert IV in BookkeepingSee if you can find a Diploma in Xero, or MYOB or Quickbooks? The answer is no, because their isn’t one. What some training companies offer is a Cert IV in Bookkeeping or a Diploma in Accounting and they may focus on using Xero or MYOB or other software but if that is the case you should delve a little deeper into the RTO and see how good they really are. If you search the training.gov.au website you’ll be able to see all of the information about every RTO. The Investment Banking Institute in Melbourne is a highly regarded RTO for the provision of financial services and bookkeeping courses and when you visit their Official Organisation Details page you can see the courses on their “scope”, their contact details and if there are any restrictions on the training they deliver.

If you are really that interested in learning more about accreditation and accredited courses you should take a look at the Cert IV in Bookkeeping. There are 24 available courses but an RTO only needs to deliver 13, of which 6 are core units. That means that apart from the core subjects EVERY RTO is able to mix and match with 18 of the potential elective subjects. I’m not the best at statistics but this means there are LOTS of potential combinations of subjects that can make up a Cert IV in Bookkeeping.

See my conclusion and references for examples of the type of information a good RTO will make available about the student satisfaction (Quality Reporting Indicators).

Accreditation by the Software Company: MYOB, QuickBooks, Xero

Online bookkeeping cloud accounting services using MYOB, Quickbooks and XeroAnother type of accreditation are those offered by the software companies but let’s be honest, these services are revenue raising “partner” programs and the more “paying” partners a software company has the more money they earn and the more exposure to clients they have. I recall when MYOB was in it’s early days (and still called Data Tech) that the main requirements to become a partner where to do at least 3 installations – but there was not training or quality control beforehand, it was almost like you had to wing it and if you did 3 then you were rewarded with a partner status!

In those early days EzyLearn delivered MYOB courses and some of the students who came along shared experiences about “MYOB Certified Consultants” who just flew in, set everything up and then flew out leaving a mess that often they wouldn’t fix. These consultants made themselves appear like super heroes who could only possibly come for one day at a time (they were booked out for months of course and charged a fortune). The company’s accountant or accounting staff were usually left to clean up the mess and make everything right. Sure,things may have changed these days and the standards imposed by the software companies are much higher but to me this accreditation is one of the last places a bookkeeper should turn to – and the last accreditation an employer should look for.

The best accreditation in my mind is accreditation (or certification) by the industry and that’s normally delivered by not-for-profit associations that aim to increase the education and compliance of their members.

Accredited by the Industry

Accredited online MYOB training course and support institute of certified bookkeepersThere are several associations for bookkeepers who want to become Registered BAS Agents but the most progressive is the Institute of Certified Bookkeepers. This organisation came from the UK where they are still a leading member group, when the Australian Bookkeeping Industry began the process of regulation and they recognised the benefit of letting their partners use their logo to demonstrate their membership status.

We spend over $1000 pa on this membership but we do it because our students are then able to join the Institute as student members.

Conclusion

Firstly,I did NOT see myself writing all this.

Secondly if it’s important for you to receive a nationally accredited qualification do some basic research in the company delivering the courses and make sure they are an RTO and not just using words like Diploma in Xero to confuse you and finally check out the subjects that they include in their Cert IV, you may find one company’s Cert IV is better than another.

MYOB Training Courses with 30 Day money back guaranteeFinally, If you decide you just want to learn how to use the software using practical exercises and following step by step processes that are performed in most companies everyday then enrol into one of our EzyLearn courses. The Certificate we provide is a Certificate of Completion once all our Knowledge Reviews have been completed successfully and these knowledge reviews are at the end of each section of each course. In the MYOB course we have 5 courses.

The best guarantee I can offer is a 30 day money back guarantee. Happy Learning

 

Some other references you may find interesting:

 

Posted on 1 Comment

Running Your Business from Your Mobile Phone

Millennials Driving SmartPhone Usage

Can you send an invoice using sms text message from Quickbooks, Xero or MYOBI WAS TALKING to a tradesperson in his mid twenties and how he wants to start his own business.

The more we spoke, the more I realised that this bloke runs his life almost entirely from his mobile phone — and doesn’t have a computer or laptop!

After having spoken to a few tradies in the last 6 months, I realise that this is the case for many of them. In large part, it’s because the nature of their work is outdoors and requires them to focus on what they’re doing there and then on a work site.

What this guy is very good at doing is replying to SMS text messages and using Facebook Messenger. This made me think about how much of your business you can actually do with a smart phone and via text messaging.

(It also made me think about how much business we might all be doing via Facebook whether we like it or not, but that is a topic for another blog post!)

How do you use your SmartPhone?

I am an Android / Google person through and through because I like their open source model and low priced (OK, cheap) solutions. Way back in 2012 I wrote about how the smartphone could replace your computer.

What I didn’t realise at the time is that most people want to run their business while they are doing it — ON THE GO — rather than have to plug it into a big screen and keyboard when they got home or to the office.

If you are interested in ways of using your SmartPhone as your office computer check out these sites!

I use my smartphone for:

  • emails
  • texting
  • calendar scheduling
  • checking online support and chat activity
  • reading the news
  • checking website analytics
  • taking photographs
  • internet banking (using CBA Netbank)
  • a street directory
  • real estate property searches
  • research on any of the projects I’m working on
  • making and receiving phone calls.

The things I don’t do on my phone are:

  1. writing and publishing blog posts
  2. transferring funds using NAB (because their Internet banking is sad)
  3. accounts and bookkeeping (interesting, huh?)

Thoughts of what we do with our smartphones made me explore a little deeper into something very simple that I think most tradies would like to do — “Send invoices by SMS”

This is what I found out:

 

It seems like much of the functionality that people are starting to want is available as a paid extra. However, what doesn’t make sense is the fact that I can send an unlimited number of text messages as part of my mobile plan.

Can’t these modern accounting programs just take advantage of that feature?

***

I’m very interested in hearing back if you have a real world experience where you’re using a smart phone to do something you would normally do from a desktop or laptop computer. Drop me a line at sales@ezylearn.com.au! I’d love to talk about you and your business in the blog.

Posted on 2 Comments

MYOB, Xero or QuickBooks: Which Suits Your Business Best?

Which is the Pick of the Bunch?

xero myob or quickbooks which is best
It’s a competitive accounting software market place out there … which is the pick of the bunch for you?

IN A PREVIOUS POST, we highlighted some of the biggest differences between QuickBooks and MYOB

However Xero is also a serious competitor to MYOB (and QuickBooks to a lesser degree).

So let’s take a look at the different capabilities of each accounting application and the kinds of businesses they best suit.

Continue reading MYOB, Xero or QuickBooks: Which Suits Your Business Best?