Search Results for:

Posted on by — 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 by

How to Make a Capital Purchase That Won’t Affect Your Cash Flow

A Chattel Mortgage Can Help Keep Your Business Cashflow Under Control

chattel mortgage learn xero online training course
A chattel mortgage can tide your business over without having to dip into savings.

In our Xero Daily Reconciliations Course, you’ll learn how to set up a chart of accounts, among other things such as running balance sheets and Profit and Loss (P&L) statements. For the most part, daily transaction reconciliation is pretty straightforward, until you get to a capital purchase, which, if it’s over $20,000 or was purchased prior to May 2015, needs to be dealt with differently.

In most cases, when a business purchases major assets, such as a motor vehicles, it’s known as a capital purchase, which is made via a loan. There are two types of loans the business can take out: a hire purchase loan or a chattel mortgage.

Buying assets on hire purchase

This is an agreement between you and the lender to acquire a motor vehicle. During the hire period, the lender legally owns the car and you pay regular instalments to the finance company. For tax purposes you can claim depreciation, running costs and interest paid against your business income. When you pay off the loan in full, legal ownership is then transferred to you.

Buying assets on chattel mortgage

Chattel mortgage is essentially a mortgage over goods to be financed. Chattel mortgage is classed as a cash sale in that the goods automatically become your property on purchase and the finance company takes a mortgage over the chattels.

Just as a hire purchase you can claim depreciation, running costs and interest paid, against your business income. The chattel mortgage allows businesses to claim the full input tax credit from GST incurred expenses immediately (next BAS statement).

Chattel mortgages are more popular

Chattel mortgages became popular when BAS and GST was introduced, because businesses could claim the GST at the time of purchase, whether they ran a cash system or an accrual accounting system. Plus, under a chattel mortgage, the allowable depreciation and interest payment are also tax deductible.

How capital purchases affect cash flow

If a business doesn’t take out a loan to make a capital purchase, it will have to dip into its savings, which can adversely affect cash flow, especially on big ticket items. Taking out a chattel mortgage, however, helps to keep cash flow under control because the business can borrow the funds (and claim the interest back as a tax deduction) without any major impact on cash flow. You will also then be able to factor the repayments into your monthly forecast projection.

***

You’ll learn how to record an capital purchase, whether it’s been bought on hire purchase or a chattel mortgage, in our Xero Daily Reconciliations Course. You can find out more or enrol today.

Xero online training course

At EzyLearn we offer many 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

You Can Use PowerPoint to Create Online Induction Training

Create an Online Induction with PowerPoint

learn powerpoint online training course
When you have to train contractors or new staff about your policies and procedures, an online induction is the most efficient – and effective – way to go.

At EzyLearn we have a bit of a soft spot for PowerPoint. It’s the oft-overlooked program in Microsoft Office that is typically associated with slideshows and presentations, and often boring ones at that. But it can do so much more.

You can generate animations, videos, movies, advertising, web design embellishments and graphics using PowerPoint. It’s a great ally to the social media or design person in your organisation. This creative design program can also be used to conjure up the most eye-catching and modern pictorial slides to enhance any presentation and keep people absorbed.

But did you know PowerPoint can also be used to create an online training induction course? Induction training is imperative for any business that hires contractors to perform work for them, either onsite or elsewhere. Induction training is necessary that any contractor or employee understands your company’s policies and procedures, whether they’re going to be working at your premises or not.

Our PowerPoint Training Course takes you through how to create your own induction training course using PowerPoint, which you can then deliver to your staff and contractors using a learning management system, or we can deliver your induction training for you.

Simple inductions that work

The end goal of an induction course should be to have all your contractors complete it, and learn something from it. You need to strike a balance between an induction that includes every last bit of information about your business, how it functions, its policies and procedures, and one that only covers the bare essentials.

Use images to illustrate risks and scenarios, as opposed to describing them. This is easy when you’re using PowerPoint to create your induction training. And remember the PowerPoint golden rule: One idea per slide.

Authenticating students

After you’ve created your induction training course in PowerPoint, it’s vital that your contractors actually complete it. This is why it’s important to authenticate each contractor or student who takes your induction training course — it also helps if you include a short quiz at the end, so you can see whether they paid attention.

There are a couple of different ways you can authenticate students to ensure the correct person is taking the induction course (and not their mum or friend or partner, for example). We talk about the different authentication methods you can use on our website, but keep in mind that only inductions delivered to students via a learning management system can authenticate students.

***

learn PowerPoint online training course

PowerPoint is, quite simply, fabulous.

Brush up on your PowerPoint skills, or learn how you can use PowerPoint to create your own Online Induction training courses, with our PowerPoint training courses. Read more about PowerPoint and how it can help you with your social media and design work.

 

Posted on by

Hiring Someone New? Why You Need to Personally Check their References

Why It Pays to Call the Switchboard When Doing a Reference Check

reference checking
How do you really know the mobile numbers provided for references truly belong to who they say they are?

I recently had a conversation with a colleague who said she’d never once been asked to produce a copy of her university degree or her transcripts, despite stating on her resume that she’d graduated with a high distinction average.

Gee, I thought, not once? Not a single recruiter or employer had ever requested a copy of her degree? I found this fact astonishing, particularly since more professions require, by law, certain qualifications — as BAS agents are, for example. So how people know my friend wasn’t fibbing in her credentials? Fact is, they didn’t.

Check, even if you use a recruiter

I wrote a blog some time ago about recruiting on LinkedIn and why it’s so important to check references for yourself. People often underestimate the importance of checking a person’s credentials, so long as they get a reference from their last employer. Often, though, most people only provide a mobile number for their references, so whether you’re speaking to the candidate’s former employer, a co-worker, or their mum is sometimes anyone’s guess.

I was reminded of how important reference-checking is again, when I was reading a couple of articles on Longreads, and I found myself utterly fascinated by two of the biggest cases of journalistic fraud ever committed (though I admit to having never heard of them before the weekend, despite one occurring more than 30 years ago).

Sometimes people don’t just lie on their resume

In the first instance, a journalist named Janet Cooke fabricated a story for The Washington Post about an 8-year-old heroin addict. She won a Pulitzer Prize for it in 1981, and then had to give it back when it came out that there was no such 8-year-old. In the second case, Jayson Blair, a journalist for The New York Times, was found to have fabricated or plagiarised 36 out of 73 stories written over a 6-month period, in what turned out to be the biggest scandal in the newspaper’s hundred-plus year history.

What I found most intriguing, though, was that neither Cooke nor Blair had been properly vetted before their employers hired them. In fact, it was Cooke’s falsified resume that was ultimately her undoing when, after receiving the highest honour in the field of writing, a former employer noticed something was amiss with her Pulitzer biography — her education and professional achievements had been grossly overstated. (Rather ironically it was Bob Woodward, of Woodward and Bernstein — the journalists who uncovered the Watergate Scandal — who signed off on hiring Cooke.)

The same would prove true for Blair, who, it turned out, never graduated from university, and had a murky work history with the Times’ sister publication, The Boston Globe, where his superiors had been less than impressed with his less-than-high standard of work.

(Of course, the equally interesting case of Australian author, Helen Demidenko, who won the Miles Franklin Award in the early 1990s, only to later be dubbed by the Sydney Morning Herald as a ‘literary hoax’ also springs to mind.)

Benders-of-truth almost always get caught

Plenty of people lie or embellish on their resumes, and while a good majority of them go unnoticed, others are caught out — sometimes very publicly, and often only after the organisation has been very publicly embarrassed, as in the case of Cooke and Blair.

My advice, then, is to always check the references of new hires meticulously. Rather than calling the mobile numbers or direct lines of the candidate’s references, call the main switchboard and ask to speak to that person’s manager or superior.

And always ensure to ask for a copy of any credentials, like university degrees. If you’re employing someone where, by law, they’re required to hold a certain qualification — as is the case for BAS agents, for instance — it’s imperative you can verify the person’s credentials.

***

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). 

 

Posted on by

Excel Can Prove that Granny Flats Don’t Always Add Value

Using Excel to Financially Forecast the Viability of Your Investment

financial forecasts excel online training course
Excel is the tool you need for developing a feasibility study so you can assess the viability of any kind of investment.

When you are planning to invest in a project, you naturally have to weigh up the risks. One of the chief ways of doing this is to complete a financial forecast to determine the viability of your investment. One type of investment that has been exceedingly common and popular with the current property boom has been the investment in a granny flat.

Many homeowners and investors who own a property with adequate room and the right conditions, have chosen to build a granny flat on their existing property as a means of earning extra income.

In our Microsoft Excel Intermediate Training Course, we feature a brand new case study, using a granny flat as a way of demonstrating how you determine the viability of an investment.

Granny flats earn income, not add value

Of course, you need to consider whether you’re legally allowed to rent out a granny flat, which in some Australian states — Victoria, South Australia and Queensland — you aren’t. If you’re found renting a granny flat in any of those states, your local council can ask you to remove the granny flat from your property.

You may determine that a granny flat will earn around $12,000 a year in rental income, but it could take up to 10 years to break even on construction costs. Although some of those costs can be deducted as expenses and the dwelling depreciated over time, depending on where the property is located, property values may not increase by that much. This is amplified if you’ve just purchased the property, compared to a person who’s owned their property for 5 or 10 years.

Granny flats can reduce your rental return

Depending on how the granny flat has been constructed, its proximity to the main dwelling, and whether there are any shared or common areas, there’s also the potential to reduce the rental income on the principal dwelling. If the property has been previously tenanted, the shift from single to dual occupancy will reduce the rent of the principal dwelling. This could be offset by the existence of the granny flat, however, it moves the goalposts for your break even date. You may also experience more tenant churn, which will see more of your rental income going to real estate agents in letting fees, and greater wear and tear on the dwellings. You may also experience longer than average vacancy rates.

How to develop a financial forecast that can be used to determine the viability of a granny flat as an investment is covered in our Microsoft Excel Training Course, with its new Investing in a Granny Flat Case Study. Visit our website for more information on our full suite of online training courses. And don’t forget — EzyLearn online training courses can be counted towards your Continuing Professional Development Points! 

learn excel online training courseAt 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 — 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 by — 2 Comments

Which Transactions Affect Balance Sheets?

Avoid Any Nasty Surprises: Balance Sheets Matter!

EzyLearn Xero Balance SheetA business’s balance sheet is a snapshot of its financial position at a particular period of time, which is not to be confused with a profit and loss (P&L) statement. Unlike a P&L, which just shows whether the business is making a profit or loss during a given period, a balance sheet, will eventually, show nearly every activity that has occurred within a business.

However, there are some transactions that will show up immediately. You’ll learn how to run a balance sheet in our Xero Daily Reconciliations Training Course, but we wanted to show you the transactions to look out for and why.

profit and loss statement xero online training course
A balance sheet reveals the nitty gritty of your business’ transactions.

The purchase or sale of assets

When an asset, such as a car, is bought, it will reduce the cash account and increase the fixed-assets account. Both of these accounts are listed in the asset portion of the balance sheet, however, cash is part of the current assets section and fixed assets are part of the long-term assets section.

When an asset is sold, the way the cash is accounted for is a bit more difficult. Here, both the asset’s book value and any accumulated depreciation are removed from the books at the same time that the cash account is increased by the sales price. If the sales price does not equal the book value, the difference is accounted for as a gain or loss on the sale of equipment. This gain or loss is recorded on the P&L statement.

Purchases on credit

When a business purchases supplies or inventory on credit, the business will debit the asset account (supplies or inventory) and credit the accounts-payable account. Almost always, accounts payable are considered to be current liabilities and are shown at the top of the liabilities section of the balance sheet.

Debt and lease arrangements

When a business issues debt or enters into a leasing arrangement, a liability must be recorded in the long-term section of the company’s balance sheet. For example, if a company issues bonds for cash, the company would debit cash and credit bonds payable in the simplest bond-issuance scenarios.

Capital-lease transactions affect the balance sheet in a similar manner. When entering a capital-lease arrangement, the business will debit a fixed-asset account to show that the company has taken economic possession of the leased asset. At the same time, the business will credit a capital-lease obligation account to show the offsetting economic liability.

***

For a balance sheet to be correct, you must code each transaction correctly in your accounting software. Our Xero Daily Reconciliations Training Course covers balance sheets, and much, much more. Why not enrol today?

***

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

Which Granny Flat is a Better Investment?

A Real-Life Granny Flat Construction Scenario

learn excel online training courseChoosing between a one-bedroom and two-bedroom granny flat is a decision you’ll need to make early on in the project, and it’s largely a financial one.

EzyLearn’s Microsoft Excel Training Course includes a new case study, “Investing in a Granny Flat”, which uses the construction of a granny flat as a real life example to help you to better understand how to develop a financial forecast for an investment.

Determine construction and ancillary costs

How much it will cost to construct both a one-bedroom and two-bedroom granny flat is the first step. You need to work out how much it will cost to get each granny flat constructed to the point that someone can move in, as well as any ancillary costs, like council fees and levies, real estate management fees interest rates and so forth.

Determine rental income

Some granny flat companies will give you rental income estimates, but you’re encouraged to investigate this yourself. Rental incomes are heavily dependent on your local area and the demand for that type of property. In Sydney, the demand for rental property far outweighs the demand in regional NSW. Take into consideration vacancy rates in the area and the types of property that are in demand. Areas with high vacancy rates and low demand for one-bedroom units could indicate there’s little demand for a permanently rented one-bedroom granny flat, which will put the rent down.

Determine depreciation amounts

Both granny flats will be subject to the same depreciation rate, however the amounts will differ due to the differing value of each dwelling. In addition to an annual depreciation rate on the dwelling, consider other elements of the granny flat that will also be subject to depreciation. Floor coverings, for example, can be depreciated over time. Carpeting is typically depreciated at a rate of 20 percent, where tiles are depreciated at 2.5 percent because the latter has a longer lifespan.

Determine the best investment

Add all of these costs into Excel to determine the average annual rental yield, expressed as a percentage of the property value. Rental yields are used to show the return on an investment. The higher the rental yield, the better the return is. Taken in combination with your own personal circumstances and plans for the future should help you to determine which option represents the better investment.

***

Our Microsoft Excel training courses, featuring the new granny flat case study, go into much greater detail. Or view our full suite of training courses. 

***

learn excel online training course

At EzyLearn, we’re committed to helping students of all our courses find better employment opportunities, become their own boss and upskill. To this end, we constantly update our courses with new, highly relevant content — it’s why we provide you with the option of Lifetime access you can always refer back to our courses as you progress in your skills’ development. 

We’re thrilled to announce our new Micro Courses which are be added to our existing courses, or can be purchased alone. These are based on real-life case studies and relate to real people in genuine, real-life scenarios. Subscribe to our blog and be alerted of updates.

 

Posted on by — 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 by — 2 Comments

When Building a Granny Flat, Here’s What You Need to Consider

Excel Can Help You with Financial Forecasting

using excel for financial forecast granny flat
Excel is a great tool if planning a big ticket project like developing a granny flat on a property.

If you have the room, building a granny flat on your property can prove to be very lucrative. EzyLearn has recently created a new Microsoft Excel exercise, using the construction of a granny flat as a case study, as part of our Excel Training Course. It was created to help students understand how to use Excel for financial forecasting, but it’s also useful to those interested in constructing a granny flat on their property.

The first thing to consider is whether it’s viable to borrow money to fund your entire granny flat project. Most people add a granny flat to their property to earn an additional income by renting it out. If this is your intention, then you need to determine whether the granny flat will become a positive cash flow investment or a negative one.

The existing property

To begin, you must determine the value of the dwelling or existing property on the land you own. Is it brand new, relatively new, older style, or very old? You should have a quantity surveyor determine the value of the existing dwelling, to determine how much of the entire property’s value — that is, the house and land — is based on land value. In most cases, land value will far exceed the value of the dwelling, however many people are surprised to learn by how much, especially if the dwelling isn’t very old. Once you know the value of the dwelling, you may be able to claim depreciation as a tax deduction.

Development costs

You should now start to factor in the development costs associated with the project. This includes the cost of demolishing any existing structures — a garage or shed, for example — and remediation of the site in the event asbestos is present. You should also have a fairly good idea of what it will cost to construct the granny flat up to the stage where you can move in. Not all granny flat construction companies take you up to this stage, often exiting at lock-up stage instead. Don’t forget to include any council fees or levies associated with constructing your granny flat.

Expected income

In the Microsoft Excel case study, both the existing dwelling and the new granny flat will be rented out as investment properties. However, you may not do the same. You need to determine how much rental income you can reasonably expect to earn from your granny flat. You should also determine whether you’re located in a region with low rental vacancy rates and high demand for long term rentals. This will determine not just the net weekly income you can expect to receive, but also the frequency at which it will be occupied, which will also factor into your bottom line.

***

Considering each of these areas is just the first step in developing a comprehensive financial forecast of your granny flat project. Our Microsoft Excel Training Course, with its new granny flats case study, goes into much greater detail. Bookkeepers can also keep up their certification and earn CPD points with our Excel, MYOB and Xero courses. Visit our website for more information on our full suite of training courses. 

Posted on by — 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 by

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 by

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 by — 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 by

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

Announcement: Social Media Marketing Course

EzyLearn Social Media & Digital Marketing Training Course logo image only

Social Media Marketing Course for 2017

EzyLearn Social Media & Digital Marketing Training Course logo image onlyDigital marketing is one of those fine arts that sometimes takes many attempts to get right and I’m guilty of that myself. I wrote a couple blogs recently about content marketing because I spend a lot of my time creating and modifying strategies, optimising and planning the content that my team creates for EzyLearn and other websites. However, I think many people are unfamiliar with what the term “content marketing” means — my mistake! I should have used the words that most small businesses associate with online and digital marketing: “SOCIAL MEDIA”!

Social Media Course — We Include EVERYTHING

So, now that I know social media is the keyword, I’m going to explain how every course we offer ties into your Facebook advertising and Facebook Page and why all of these aspects are important to you if you are going to spend more time and money building a strong online brand.

Content Marketing

virion and 123ezy social media course and content marketing catalogue No matter who you are or what you do you will need content and you will use that content to promote you and the services you provide. I have been using all of these tools to help convert EzyLearn into an “online only” training company in 2006 but I was able to explore how to provide these services to real estate agents when I managed the social media strategy for Derek Farmer, a real estate agent in Cammeray at the time. Here are the content options we had to play with:

Photographs and Images

Images are used in Instagram, Facebook, Linkedin and on your blog (if you have one). They are used to make a blog easier to read and in industries like real estate where good photography is important to get a high price and make a successful sale they are used to showcase the product being sold. I recently spoke to an asbestos removal company and photographs of what they do and how they do it are also an important part of their “content”.

We show you how to include images in blogs and even include fundamental image editing skills using GIMP (it’s very powerful and it’s free!)

Video Marketing

property marketing, video marketing, Facebook Page, Facebook Ads, Youtube and video marketingEzyLearn has several hundred videos as part of our online training courses and sometimes we use them to give prospective students examples of our training, explanations about how our special offers work or even videos of me explaining the EzyLearn journey since the late 1990’s! Real estate agents like Derek Farmer use video to help educate property sellers about the various aspects of the property selling process and what to look out for.

We show you how to get your video up to YouTube, or more professional services like Wistia and show you the analytics you can get about your video viewers and how to make a better video next time — it’s all about drop off rates. We also show you how to get a Call-To-Action within the video itself.

Blog Marketing

Blog marketing is my personal favourite because I love writing; you can really play with the keywords that Google loves so much and you can fill a website up with content that shows you are active.

We teach you how to create a website, create web pages AND blog posts, how to optimise them for the keywords you want to be discovered for and how to measure and understand the visitor analytics.

Facebook Pages, Timeline Posts, Advertising and Remarketing

This is the one that EVERYONE is interested in and for good reason; the demographic targeting is fantastic. Facebook is becoming increasingly important for real estate agents to promote themselves — indeed, Social Estate and BuddyBid are just two companies getting in early to earn a couple of hundred dollars a month for each real estate agent they take on board.

Note: This is something that any work at home mum (or dad) can do! You just need to understand how to generate new content or “republish” other interesting content on a Facebook Timeline and how to create a Facebook Ad. We cover all of this in our Social Media Marketing Course.

Facebook Pages

Our written guide and training course videos show you how to set up a Facebook Page for a local business (ideal for tradies, service providers like accountants or bookkeeper and of course real estate agents). By using a Facebook page you can assign the administration of that page to someone who simply schedules posts — that someone can be YOU.

Most people with a Facebook Page then need to make sure their Timeline is filled with content so that they pop up regularly in local news feeds.

Feeding Your Facebook Timeline

Real Estate Agent Facebook Page, timeline posts and ads help property and brand marketingMost people think it’s important to create a Facebook post every day but that’s hard to do if you need to generate original content. Instead most people re-post other content that is relevant to the audience — this is often referred to as curated content (for instance, where you make a comment or affirm your belief in an article).

Real estate agents often simply refer to the plethora of real estate blogs available and here are some examples used by David Howe, an honest and diligent McGrath agent in Northbridge, Sydney, who asked our designer team to create a website for him:

  • http://www.smartpropertyinvestment.com.au/how-to-maximise-profit-without-it-costing-you-a-cent
  • http://www.dailytelegraph.com.au/lifestyle/food/sydney-taste/sydney-eat-street-10-things-to-try-in-crows-nest/news-story/
  • http://www.apimagazine.com.au/2016/11/debt-retirement-worries-high/
  • https://www.buzzfeed.com/markdistefano/too-real-estate
  • http://www.homestolove.com.au/how-to-design-the-perfect-laundry-4236
  • http://blog.templeandwebster.com.au/work-the-trend-the-new-natural/
  • http://www.afr.com/real-estate/residential/dont-want-to-move-want-a-reno-architecture-awards-show-how-to-do-it-20161104-gshwue
  • http://davidhowe.com.au/david-howe-real-estate-agent-northbridge/

This method of posting other people’s content is good enough to show that your Facebook Page is active. However, from an internet marketing perspective it tends to send people away from your Page and onto other websites where your competitors might advertise — especially if you report material by ratemyagent, openagent, realestate.com.au or domain!

In our social media marketing course we show you how to make a post like this and schedule them all in advance but also how to get your own unique content and how to link to content where none of your competitors are listed.

Facebook Advertising

Facebook Ad Views for individual property advertisement - Clarence TownFacebook ads are relatively simple to create so there is NO reason to get someone else to do them (particularly if they’re going to charge you the equivalent of 4 hours’ labour!). The key elements of a Facebook Ad are their structure: Campaigns, Adsets, then individual ads and once you get that right and understand how it works, creating a Facebook Ad can be done by someone in your office or who you trust (again, a work at home mum).

We show you the type of posts and ads that Derek Farmer paid to promote in his local area, why he chose to do it, how much he paid and what his viewer and reader statistics were. We’ll also show you how to advertise to your own client base in their Facebook Feeds and how to remarket to people who’ve been to your website or Facebook Page.

WordPress, Hosting, User Management etc

I believe that your own website is the best “landing page” for any marketing money spent because YOU OWN IT. The more traffic you direct to your own website and the more content you put there that is valuable to your customers and future potential customers the more valuable YOU and YOUR WEBSITE will become.

WordPress online training course and social mediaIn our Social Media Marketing Course we include every aspect of how to manage your own website using the very popular WordPress Content Management System. This includes having multiple users be able to publish content. We also teach you how to optimise your blogs and pages for important keywords using tags and categories, how to use meta tags on your pages and even on images so everything gets indexed by Google and how to make your website look fantastic with professional themes (templates).

Lead Capture and Email Marketing

Having a call to action on your website or Facebook Page is critical to truly analyse it’s effectiveness and understand it’s success — what’s working and what needs to change. A very important part of that is to capture the email address of people who visit your site and most websites do that using a giveaway, free reports, white papers etc. Once you have a potential clients email address you effectively have permission from them to send them email messages.

We use a number of different email marketing solutions including Campaign Monitor and Aweber, and these are very similar to MailChimp, GetResponse, Constant Contact and a plethora of other email marketing solutions. We’ll show you how to use these systems to capture website visitor details and send them messages automatically. 

Capturing, Analysing and Understanding visitor traffic

Video visitor Analytics - property marketing video for real estate agentsGoogle Analytics is the most popular website traffic analysing system and you can use it to measure the effectiveness of your website day-by-day, week-by-week and for specific date ranges.

We show you how to implement the code on your website, how to access the visitor traffic information on your PC and even your mobile phone and what elements to look for to understand what your website is doing. 

Conclusion about Social Media Marketing Course

We do all of this using our own website examples as well as Derek Farmers website so you can see what real businesses do to succeed online. Whether you want to do all of this yourself, hire an experienced internet marketer or find a suitably qualified work at home mum (or dad) this course will give you an abundance of knowledge and strategies to manage what you do.

See what’s included in our Social Media Marketing Course and enrol today at a huge launch discount!

[button link=”http://ezylearnonline.com.au/courses/marketing-training-courses/digital-marketing-social-media-courses/” color=”orange”] Social Media Marketing Course Contents[/button]