Posted on

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

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 (ExcelPowerPointWord) or social media and WordPress web design). 


 

Posted on 1 Comment

End of Financial Year: Writing Off Stock

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

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

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

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

Understanding your inventory’s performance

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

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

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

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

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

Inventory reporting

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

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

Stock write offs and future orders

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

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

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

Act NOW for EOFY

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

***

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


find a local bookkeeper

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


 

Posted on 3 Comments

What Happens if You Have Backlog of PAYG and Super Payments?

Don’t get lumped with penalties when you don’t need to!

failure to lodge penalties how to manage payroll in Excel online training course
It’s not only frustrating and disheartening, but a waste of business funds to be penalised for lodging your financials too late.

A LOT OF SMALL BUSINESSES have trouble managing their payroll, especially when they only have a few employees and paying to access a payroll system in their accounting package is an unnecessary expense. You’ll learn how to use Excel to manage your PAYG and super contributions in our Intermediate Microsoft Excel Training Courses. However, sometimes you may have a backlog of PAYG and super payments. Let’s take a look at how to manage these.

Rescue bookkeeping

A backlog of PAYG and super payments that date back more than three months is known as rescue bookkeeping, although it can often include other bookkeeping issues, like bank accounts that don’t reconcile with statements.

PAYG payments

For businesses that only withhold up to $25,000 each year, you’re supposed to make PAYG payments and file a withholding report each quarter. You have 28 days from the end of the quarter to do so, after which time, you may incur a Failure To Lodge (FTL) penalty.

Superannuation payments

As with PAYG payments and reporting, you can also incur a FTL penalty for not lodging or paying your employees’ superannuation contributions in time. All businesses, regardless of size, have to make superannuation payments each quarter — the ATO sets out the due dates for each period on their website.

Lodging late PAYG and super payments

The ATO only applies penalties for failure to lodge reports or make payments for each period of 28 days (or part thereof) that a document or payment is overdue. Each period incurs one penalty unit for each document, up to a maximum of five penalty units.

From 2015 onwards, the value of a penalty unit is $180 (previously it was $170) for small businesses, which are defined as entities with an assessable income or GST turnover of no more than $1 million a year.

The maximum penalty a small business will pay is $900 for each document or payment that is overdue. Note too that FTL penalties will also incur a general interest charge (GIC), applied on top of the penalty.

Managing late PAYG and super payments

Use the Ad Hoc Payroll Guide, a new case study that is included in our Intermediate Microsoft Excel Training Courses to determine the rate of PAYG tax to withhold and the required super contribution amounts in Excel. Once you’ve worked out the required amounts (visit the ATO website for tax tables prior to 2017), lodge the necessary PAYG payments and reports to the ATO; pay super contributions using the SuperStream super clearing house.

The ATO will write to you if you are required to pay a penalty — sometimes they are waived for first-time offences, or if the amounts are small.

Our courses now include real-life case studies

learn excel online training course

Our Intermediate Microsoft Excel training courses will also teach you how to create a payroll spreadsheet from scratch to suit your own business, so you can easily work out your PAYG and super obligations. Visit our website for more information on all of our Excel training courses.


learn PowerPoint online training course

Create brilliant presentations and graphics for all kinds of business purposes.

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.


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

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 (ExcelPowerPointWord) or social media and WordPress web design


 

Posted on 1 Comment

Linking a Financial Forecast with Xero and Excel

Excel Will Help You Work Out the HOW of Depreciation

learn excel online training courseWe recently updated our advanced Microsoft Excel Training Course content. It now contains a case study, by way of an extra exercise workbook, using a granny flat building project to create a financial forecast.

We chose a granny flat building project for our case study because it’s an investment decision quite a lot of people with or without a business have made. It’s also a capital asset that can be depreciated over time. Therefore it has the potential to affect your taxes in lots of different ways.

Our Excel Training Course, with its granny flat financial-forecast case study, will teach you how to use Excel to create a financial forecast, which you can then replicate for your own investment — whatever that may be.

Your bookkeeper uses Excel to calculate depreciation

When you build a new structure, such as a granny flat, which you intend to rent out or use for businesses purposes — i.e., it’s an investment and not for your own personal use — the building can be depreciated along with some of the fittings and finishes (floorings, curtains, paint, etc). That’s despite the value of the land upon which the granny flat is constructed increasing in value over time.

Once you’ve set up your financial forecasting file in Excel using the correct formulas that will update as the investment progresses, you’ll be able to track all of the future costs, income and depreciation in that spreadsheet.

Input depreciation into Xero

Excel will calculate the depreciation amounts for you, which you should then enter into Xero. We cover how to deal with depreciation in our Xero Bank Reconciliation Course, because lots of businesses own, or will own, a capital asset at some point.

However, this doesn’t tell you how to determine the depreciation amounts, which most business owners have to get their bookkeeper to work out for them. Most bookkeepers work this out in Excel based on the depreciation rates provided by the ATO. However, if you have already created a financial forecast in Excel, you won’t need to get your bookkeeper to do this for you.

Individuals can claim depreciation too

Even if you’re not a business owner, but you’ve still built a granny flat that you intend to rent out, you can claim depreciation in your tax returns. Instead of entering the depreciation into Xero, you’d include it on your annual tax return, so it’s really important that you work this out in Excel first and regularly update it.

***

Once you know how to use Excel for financial forecasting, you can use the same formulas and modelling for any financial forecast — be it for a granny flat project, business investment, anything that requires you to make a financial decision. Visit our website for more information on our advanced Microsoft Excel Training Course, with its new granny flats case study.

Do you want to brush up your Xero skills? Or perhaps you use MYOB but want to get a handle on Xero? Check out our suite of Xero training courses — all available for one low price. 


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

Calculating PAYG Obligations Without a Payroll System

Third Quarter is Looming; Are You Up to Date with Payroll?

ad hoc payroll payments ExcelMost businesses using an accounting program like MYOB or Xero will use the included payroll package to manage their employees’ payroll. For businesses with only a few employees, however, the additional payroll function is an unnecessary expense.

In our recently updated Advanced Microsoft Excel training courses, we have included a micro course on ‘Ad Hoc Payroll’, featuring a detailed spreadsheet for calculating PAYG and superannuation obligations. In this instance, our micro course is a detailed spreadsheet based on a case study, so it’s relevant and applicable to real life.

PAYG and the businesses it applies to

Every Australian business with employees who are each paid more than the tax-free threshold has a legal obligation to withhold tax on their employees’ behalf. This is known as the PAYG System (or Pay As You Go), where amounts of tax are withheld from each employee’s wage payments.

Businesses that withhold up to $25,000 each year only need to make payments to the ATO each quarter; businesses withholding amounts greater than $25,001 may have to make payments to the ATO each month or as regularly as each week.

At the time of writing, the tax-free threshold is currently $18,200, which is equivalent to:

  • $350 a week
  • $700 a fortnight
  • $1,517 a month

Superannuation contributions

Again, any business that pays its employees more than $450 each month must also make regular superannuation contributions on their employees’ behalf. We’ve written in the past about the government’s clearing house called SuperStream, which allows you to easily make super contributions — for free.

But first, you need to work out how much super you need to contribute for your employees. The superannuation guarantee is currently 9.5 percent of your employees’ gross wages, which is payable on top of their wages — not deducted out of.

Using tax tables to calculate wages

Each year, the ATO produces a range of tax tables to help you work out how much to withhold from payments you make to your employees. In our Ad Hoc Payroll Micro Course, we’ve already added the most current tax tables to the accompanying payroll spreadsheet, as well as the superannuation guarantee tables.

***

We feature a number of real-life case studies, which we have turned into micro courses. You can use the Ad Hoc Payroll Micro Course to determine the rate of PAYG tax to withhold and the required super contribution amounts in Excel, rather than paying to access the payroll functions of MYOB or Xero. Our Intermediate Microsoft Excel training courses will also teach you how to create a payroll spreadsheet from scratch to suit your own business. Visit our website for more information on all of our Excel training courses.

***

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 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 Excel to Manage ALL Your Investments

Once You Master Excel You Can Do Anything!

using excel for financial forecast granny flat2
Excel is one powerful tool. Its formulas can be extrapolated to most any accounting software program.

In our Excel training Course there’s an exercise workbook on granny flat investments, which takes you through all the steps involved in developing a financial forecast for a granny flat. It can also be used to determine the financial forecast of any investment, not just granny flats.

Even though lots of cloud-based software applications have come along in recent years — Xero and MYOB and CRMs like Zoho — which have made it possible for lots of business owners to keep track of their financials and customer sales history without ever needing to open an Excel spreadsheet, Microsoft Excel is still the software used by accountants and analysts in nearly every profession.

Excel is flexible

Microsoft Excel may be difficult to master — indeed, it’s probably one of the most difficult in the entire suite of Microsoft programs — but it’s also the most flexible. The formulas sitting behind nearly every cloud-based accounting software can all be replicated and modified in Excel, where in MYOB or Xero, they can’t.

You can’t enter the details of your granny flat project or other investment into Xero and MYOB and create a financial forecast, even though near similar formulas are being used each time you run a profit and loss statement.

Cloud software is Excel plus PLUS

Before computers and Microsoft Excel came along, accountants used a pen and paper to keep track of their clients’ business financials. And before that, before the numeral system was invented, the abacus was the main accounting tool used by merchants and traders to keep track of their finances.

You probably have no use for an abacus anymore — although in some parts of Eastern Europe and Southeast Asia people still do — because, as an accounting tool, it’s too basic. But the same cannot be said about Excel, which is capable of handling complex formulas and rendering an answer.

Export accounting data into Excel

Because cloud-accounting software is essentially a very user friendly version of an elaborate, however inflexible, spreadsheet, it means you’re able to export your accounting data into Excel. Financial analysts and accountants do this when they need to carry out further analysis on a client’s financial data, and you can too.

Once you know how to use Excel for financial forecasting, you can use the same formulas and modelling for any financial forecast — be it for a granny flat project, business investment, anything that requires you to make a financial decision.

***

Visit our website for more information on our Microsoft Excel Training Course, with its new intermediate-level ‘Granny Flat Case Study’.

***

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

Announcement: Xero Bank Recs and Journal Entries

Bank Recs are a pain in the !@Accounts#$

Bank Statement for Bank Reconciliation Courses in MYOB, Quickbooks and XeroAlthough the daily data entry is a frustration for many business owners and manager, particularly if you are quoting, ordering and invoicing regularly, the bank reconciliation is the most frustrating for bookkeepers, BAS agents and accountants because they need to make sense of EVERY transaction and make sure it is accounted for correctly. Xero bank reconciliations are made easier with bank feeds and today we announce that this course is available as part of our All Xero Courses for 1 Price Offer!

Bank Statements Reveal Much

We base our bank reconciliation course development (for Xero and Quickbooks) on our MYOB Bank Reconciliation Course and I was reviewing the contents of this course a couple weeks ago.

The thought that stuck in my head the most was “Wouldn’t it be great to design my own bank statement! A bank statement that I would like to see for my business each month” but that is a topic for another “business development and goal setting type blog”.

The important thing for bookkeeping students is that this bank statement includes most of the transactions that you’ll come across each month including interest, capital purchases, loans etc that you’ll probably need to check and make sure they’re coded correctly.

Xero and all cloud accounting programs make bank reconciliation easier because they enable you to import bank feeds directly from your bank. This saves a lot of the typing involved in data entry but you still have to get the codes right.

Xero 513 Bank Reconciliation Course

Learn more about what is included in this course at our Xero Bank Reconciliation Course landing page. In this course we introduce a new “character” in our course design – Jerry. Jerry is an ordinary man who decides to go into business because he loves talking to and helping other people but he’s not that tech savvy (or accounting savvy) so he makes a lot of the mistakes that many other business people make when they are starting out for the first time.

If you are an existing student enrolled into our Xero Courses, just contact support and ask them to enrol you into the Xero 513 (Bank Recs) course – there’s not charge for you if you are within the 12 months course access period.

Stay tuned for more updates to our Xero and Quickbooks Training Courses.

Posted on 2 Comments

Video: Receive an Automatically Discounted Price for Online Course Enrolments!

Specials and Summer Training

2016-12-20 How to use the EzyLearn website to get discounts and special pricingIt’s Christmas time and we’ll be open every day (except the public holidays) which means you can make contact with questions or support during your course.

But best of all, we’re offering a fabulous special offer with a saving of over $300. Check out the quick video below which shows you how to get $663 dollars worth of training for just $296a saving of $337!

All you have to do is choose your courses at our Online Course Enrolment page and the discounts will be applied automatically.

Get New Skills for A New Year!

discounted Myob QuickBooks online courseWith the New Year coming fast we find most of our students are looking to change careers and/or up-skill so as to feel confident with their computer skills in job interviews and the like, so our current special offers will train you up to be your best, cheaply. Here’s all you need to do:

  1. Choose Microsoft Excel course (12 month’s access, all 9 courses and Certificate).
  2. Scroll down to the discounted courses section to see the Xero Training Course available for $30 less.
  3. Scroll down further to see the Microsoft Word Course (12 month’s access, all 9 courses and Certificate), which is normally $267 is now FREE
  4. Tick the box next to “Yes, I have a discount voucher code” and enter 8881818 to receive a further $70 discount off the Microsoft Excel course!

If you don’t have the time right now, don’t worry, you’ve got 12 months to complete all these courses at your own pace — so just enrol now to get the current special offers.

Watch this video to see how to get the discounts

New Online Courses for the New Year

It’s been a very busy year for new course creation and we’ve just launched two new courses that are all based on new online cloud-based services in bookkeeping and marketing/advertising. Read about them here:

QuickBooks Online

Provide quotes on your tablet computer, convert them to invoices when you get the order and take photographs of your receipts for expenses — works on your smartphone too. These are the features of America’s most popular accounting software program that is now aggressively promoting itself to Australian small businesses.

And what do we think? We believe QuickBooks is good software — find out more about our Intuit QuickBooks Daily Transactions Course.

Our New Digital & Social Media Marketing Course

Facebook and social media online training course
Tired of struggling to post consistently on Facebook and other social media sites? We’ve had a WordPress course for several years to teach you how to create your own website and blog, edit images, and optimise it for search engines (like Google). But if you’ve ever struggled with fleshing out a Facebook Page, or want to start promoting yourself or your business in social media, try our Digital Business and Social Media Marketing Courses.

We show you what you should include on a modern day website as well as including Facebook Page, Content Marketing and Facebook Advertising training (which we used to help Derek Farmer show up on Page 1 in Google for the competitive Cammeray Real Estate Agent search query).

***

Most of all, from all of us here at EzyLearn, HAVE a FANTASTIC and SAFE Christmas — doing things you love!

Online computer training Christmas specials_comp

 

Posted on 2 Comments

QuickBooks Isn’t SuperStream Compliant, But It Doesn’t Matter!

How QuickBooks Palms Off Payroll

quickbooks superstream compliant
Quickbooks is gaining traction in the Australian marketplace.

I’m a fan of QuickBooks as the functionality is excellent and the cost of the software is still low. I’m really pleased to announce that you can now enrol in our QuickBooks Online Daily Transactions Course — but does QuickBooks fulfil Australian legal obligations to be SuperStream compliant?

The background is that from July 1 this year, all Australian businesses with fewer than 20 employees were required, by law, to be SuperStream compliant.

SuperStream is a government initiative to improve the efficiency of Australia’s superannuation system, namely by making superannuation a totally electronic process.

Most cloud-accounting packages that have been developed for the Australian market (such as major applications, like MYOB, Xero, Reckon and so forth, but not smaller apps like Zoho or QuickBooks, which can be used in Australia but don’t interface well with Australian tax procedures) are now all SuperStream compliant, with one exception: QuickBooks. Continue reading QuickBooks Isn’t SuperStream Compliant, But It Doesn’t Matter!

Posted on

Understanding Image and Photo Rights for Content Marketing

Knowing How to Make Your Blogs Puhretty, Like

blogging-content-marketing
Blogging is the core component of content marketing.

So you want to digitise your business? Until I’m blue in the face, I keep telling anyone in business that content marketing is one of the most important online Digital marketing activities for businesses in operation today — particularly those with a website. Successful content marketing is about creating original, high quality content that’s relevant to your “potential” customers. It also needs to be high quality in every way (relevancy is integral to quality) and this involves every aspect of the content you’re creating — copy, layout and design. This ain’t always easy!

I’ve mentioned this elsewhere on this blog before, but I stand by my geeky analogy that great content is like an equilateral triangle, in that all parts must be equal. Copy, layout and design are the three sides of your content, and if you prioritise one aspect over one of the others, your content will be unbalanced, just as your triangle would be.

Blogging: The Staple of Content Marketing

How best to content market to your audience? Well, I’d go so far as to say that you can’t have effective content marketing without maintaining a blog. Setting up a blog is actually pretty easy, especially if you use a content management system like WordPress for your website and blog. With WordPress the the layout is pretty much taken care of for you — just choose a theme and away you go.

Many businesses outsource copywriting to a contractor or freelancer, which in our view, is a wise move. Unless you’re a clear writer who can articulate your point accurately and economically (a good writer will know that I’m talking about word count), then you should outsource it. You also have to rather enjoy doing it and be fast at it — otherwise, despite your best intentions, little will ever get published.

A Word on Google Images

So, to design. In the case of blogging, you usually select an image to illustrate your blog posts, which brings us to the subject of this blog post: understanding image rights. Unless you intend to use your own photos and images that you’ve taken or created yourself (hands down, one of the best ways to drive search engine rankings and increase reader engagement, just sayin’) and therefore own the copyright to, then you need to understand image rights first.

As a general rule, never ever use Google Images to find an image for your blog. That’s not to say that Google Images isn’t a great starting off point if you’re creatively spent and in need of some inspiration. I frequently punch a few keywords or phrases into Google Images to see if the results turn up, and then go back to my image library, which categorises images in a more literal sense than Google Images does.

******** SPECIAL LAUNCH OFFER ********

Derek Farmer real estate agent smiling portrait in selling your property educational training videoUPDATE: WordPress Courses, Content Marketing Course, Social Media Marketing, Facebook Pages, Updating the Facebook Timeline, Facebook Advertising, Facebook Pixel and Remarketing, Google Analytics and our Digital Business Course are now ALL included in our Digital & Social Media Marketing Course! That’s 6 courses for a VERY LOW price. Check it out and see the prices on our Enrolment Page so you can get a solid start to your digital marketing in 2017.

We showcase what we did at EzyLearn in 2008 and what we did for Derek Farmer (Cammeray Real Estate Agent) in 2015 to get onto page 1 of Google and in front of his entire database every day on Facebook

******** OFFER PRICE IS FOR A LIMITED TIME ONLY ********

This has a lot to do with indexing and keyword usage; put simply, think of Google Images as your own personal brainstorming team. Traditionally, brainstorming has always worked best when there was more one person, but if you’re on your lonesome, then this is where Google Images comes in handy.

You punch in a few key phrases or concepts and you can see how other people have illustrated their websites and blogs, based on those same phrases.

What makes the images from Google Images dicey is that, as a search engine, it’s not beholden to the laws of copyright usage and image licensing; it’s up to you to do your due diligence and find out what the terms of the image’s license are.

Image (Copy)Rights

Generally speaking, to use an image that you haven’t created, you must track down the creator and ask for permission to use it. Obviously, this would be a lengthy and arduous process if you had to do this for every image you found on the internet, so, thankfully, there are plenty of ways to find images where the copyright holder has already released the image with a license that allows specific uses.

Using an image in a way that isn’t allowed under the terms of its license is still considered copyright infringement, so make sure you’re certain you understand each image’s license before you use it on your blog or website.

Most online image libraries offer images with license terms that deal with:

  • Type of use: Commercial or non-commercial use, with the first being any use of an image to sell or promote a product, service, or idea.
  • Attribution: Credit may need to be given to the original creator of the image and required format (e.g. a link) specified.
  • Modification: The image may have to be used unchanged, or you may allowed to modify it and create new images or materials from it.
  • Number of uses: Some licenses may restrict the number of times an image can be used.

What license is offered depends entirely on the copyright holder or the creator. Some image libraries require the copyright holder to sign over certain rights of use to their images, while others don’t, which means you need to be vigilant by checking the terms of use for each image you use.

Of course, one way to avoid having to deal with image rights is to take your own pictures. As I said earlier, this not only gives your content its own personalised stamp of authenticity, but it also helps drive search engine rankings and reader engagement. This is very important in content marketing.

If you’re not able to take your own pictures, for whatever reason, then using an online image library is the best way to ensure that your content is not only looking great and will engage your customers, but that you’re also not contravening any copyright or licensing terms.

To learn more about content marketing, subscribe to our blog or register your interest in our forthcoming content marketing training course.  If you’re a bookkeeper looking to start out on your own, or start a small business, find out more about our bookkeepers’ directory, where we do the content marketing for you to help you find work.