Posted on

What Does Lifetime Access Mean for Xero and Excel Courses?

Receive updated course content — for life!

learning how to use excel and xero with online training
We are one of the only online learning centres offering access to course updates for the rest of your working life with our Lifetime Access option.

ONE OF THE GREAT THINGS about Excel is that it has so many applications. It can be used to create financial budgets and forecasts, monitor stock levels in a retail shop, roster staff, and also determine how much money an investor can borrow to buy a property.

A lot of the time, however, people enrol in an Excel online training course or Xero online training course because they need to refresh a specific set of skills for their job, which means they don’t have the time to focus on other areas that don’t have an immediate relevance for their work.

Upskill at your own pace

With our Lifetime Access courses for Excel and Xero and many other online cloud accounting and business options, students can continue learning in their own way and at their own pace, either as part of continuing professional development or for their own personal interest — our course content includes real-world case studies, like building a granny flat, to give context to the functions of Excel.

Keep up-to-date across all software versions

The other benefit of our Lifetime Access for Excel online training courses and Xero online training courses is that it means you can quickly brush up on where functions have been moved to when new versions of Xero and Excel are released.

We update our course content every time a new version of software is released, and with Lifetime Access, you’ll be able to access all of this new content, along with previous versions of course — so you can keep learning on the most current versions of Excel and Xero.

***

Stop wasting time, and start learning for less. Visit our website for more information about Microsoft Excel training courses and our Xero training courses, and to enrol.


Don’t miss out on our terrific Spring specials

learn online training Xero courses videos for less

We are constantly refreshing the content of our online training courses so that you can benefit from all the new information that is always coming in about being in business, or running your own business as a bookkeeper or looking for bookkeeping work.

Our Xero online training courses include EVERYTHING for ONE LOW PRICE. Furthermore, if you select our Lifetime Membership option, you’ll have LIFETIME access to our ongoing course updates. All EzyLearn courses are accredited by the Institute of Certified Bookkeepers (ICB) and can be counted towards Continuing Professional Development (CPD) points. Find out more about our Xero online training courses.


 

Posted on

Is Xero Really All It’s Cracked Up To Be?

How does Xero stack up in the cloud accounting game?

xero learn online xero course training videos cheap
Xero CEO, Rod Drury

WHEN XERO FIRST ENTERED the accounting space, it gave MYOB a real run for its money — something Xero continues to do to this very day.

When Xero first entered the market, it was with a bang. You see, even though  Xero and MYOB share many of the same features, Xero was cheaper and easier to use than MYOB, but perhaps even more so, it was also cloud-based. Being cloud-based meant you didn’t have to buy and install pricey software that would be out-of-date within 12 months. A huge advantage.

Since then, however, a number of cloud-based accounting applications have entered the market — QuickBooks Online (now distributed by their US-based parent company Intuit), Reckon One, Saasu, Zoho, and so on.

As business owners have more choice than ever before, it’s got a lot of people wondering about whether the two market leaders (Xero and MYOB) are really all they’re cracked up to be, Xero in particular.

Missing a dropdown menu

Even though Xero was hailed as a breath of fresh air when it first entered the market, it is still a little more complicated to use when compared with other cloud accounting apps, like QuickBooks and Reckon One. For instance, the purchase orders feature is still hidden behind bills, when it could easily be access via a dropdown menu. But it’s not a major quibble.

Xero’s contact profile misses a beat

Although Xero allows you to assign customer numbers for your suppliers or customers in the contact profile, it doesn’t have the functionality to record customer numbers assigned by supplier or customer.

If you’re trying to get in touch with Telstra, for example, with whom you’ll have been assigned a customer or account number, you’ll have to dig around for the paper bill to find that customer or account number.

It’s easy to file bills, though

This feature is available in QuickBooks, and it’s also available in MYOB, but as is often the case with MYOB, it requires more steps to do what you can in Xero in just a few clicks. Rather than keep paper bills on hand, Xero allows you to attach them to you transactions, so you never have to go hunting around for a bill again (very useful given the contact profile issue mentioned above).

In MYOB, you must upload your bills to your in-tray, and then link them to your transactions. This is annoying, because it requires you to leave the transaction window and open the in-tray one.

***

Remember that when you select a cloud accounting package for your business, do not choose solely based on price. Make a list of the needs of your business and the functions you’ll require, and then select the accounting package that suits your needs the most. Ask your bookkeeper and other business friends for their recommendations as well.


Announcement: Microsoft Excel 2016 Beginners’ to Advanced courses now available!

learn to use excel online training course videos cheap best

At EzyLearn we include all versions of a software program in our training courses. That means when you enrol into Excel you get 2016 — AND — the older Excel courses which include version 2013, 2010, 2007 and even 2003 (if you really need it).
When you enrol in Lifetime Course Access you get access to ALL versions and ALL FUTURE VERSIONS as we continually update them — at no extra cost!

Posted on

Should You Buy Commercial Property Outright or Get a Mortgage?

The power of using Excel and Xero combined

Excel and Xero combined importing_comp
Our courses cover how to import from Excel into Xero and visa versa, for purposes such as working out depreciation on a business premises.

THERE ARE MANY UPSIDES to buying a commercial property for your business and if you’re able to buy an industrial unit like a Cubbyhole, it can also be a lot cheaper than renting premises.

Buying outright

If you’re in the financial position to buy your business premises outright, it may seem like a no-brainer to do this instead of getting a mortgage. However, there are some things you need to consider:

  • You’ll lose liquidity on the assets in your property, which means you won’t be able to tap into any equity in the property, unless you take out an equity loan against the property.
  • You’re tying all your cash to one asset class, which may limit your ability to make other investments and prevent your business from expanding. This could run counter to your reasons for making the property purchase in the first place.

Getting a mortgage

When you get a mortgage, you have the benefit of being able to access equity in the property, which will enable to invest elsewhere. Of course, there are still factors to keep in mind:

  • You’re spreading the payments over many years, which ties you to paying down that asset for the foreseeable future.
  • You’re paying interest, which although it’s a tax deduction, will significantly inflate the price of the property.

Work out the best way in Excel

Using the data from your Xero accounting software package, Microsoft Excel can help you determine whether your business will be financially better off buying its premises outright or getting a mortgage.

You can also create a financial forecast in Excel. Using Excel, you can calculate the depreciation amounts, which can then be entered into Xero. We cover how to deal with aspects like depreciation in our Xero Bank Reconciliation Course, because many businesses own, or will own, a capital asset at some point.

***

Check out our new Cash Flow Reporting, Budgets and ROI Course for Xero which shows you how to deal with an asset purchase like a business premises in Xero. Remember, you get access to ALL our Xero courses for ONE LOW COST. Visit our website for more information on our suite of online training courses or enrol today!


learn to use excel online training course videos cheap best

Importing from Xero to Excel and back again is included as part of our Advanced Microsoft Excel training courses — and you receive access to ALL OF OUR COURSES, including ALL skill levels for ONE LOW PRICE. You can even start your Excel journey with our FREE Beginners’ Excel Course Workbook. Read more about our beginners’, intermediate and advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow!


 

Posted on

Importing Bank Statements into Xero

Making bookkeeping easier, faster and more accurate

importing bank statements into Xero online learning course training videos
You’d be surprised how many business owners don’t even know how to import their bank statements into their accounting software. Are you one of them?

WE HAVE CREATED A brand new Cash Flow Reporting, Budgets and ROI Course for Xero and one of the things you’ll learn is how to import your bank statements into Xero.

The sales spiels of many of the notable online accounting software packages like QuickBooks, Wave Accounting, Outright, Kashoo, LessAccounting, Clearbooks and even Xero, claim that this feature will save you time and effort as it imports your bank transactions. The truth is, this is not foolproof and won’t work 100 percent of the time (even if it’s just a matter of not being able to get your software and your bank to “connect” just as your mobile phone connection inexplicably doesn’t work sometimes).

Therefore, always double check your bank transaction data has been imported accurately. This said, importing your bank statement into Xero (or whatever accounting software you use) is a really important step in the bookkeeping process that a lot of business owners forget or don’t know how to do. And the technology is only going to get better!

Using the correct format

To import your bank statement into Xero, you must ensure it’s in the correct format. Xero can only work with a CSV file of your bank statement. Depending on your bank, you might be able to download your bank statement as a CSV file from your internet banking, or you will have to create one from scratch.

Creating one from scratch isn’t too difficult. If your bank doesn’t give you the option of downloading a bank statement as a CSV file, you can create one yourself in Microsoft Excel.

You can download an Excel template from Xero. It includes the recommended fields and is already set up as a CSV file, so all you need to do is add in your data.

Set transaction rules

Once you’ve created and uploaded your bank statement to Xero, you’ll need to set up transaction rules for recurring expenses. You’ll learn how to do this in our Cash Flow Reporting, Budgets and ROI Xero Course.

Setting rules for recurring transactions helps speed up the reconciliation process, which depending on the type of business you operate and how often you reconcile your account, can be the most time-consuming part of the process.

Importing your bank statement and creating rules for transactions that occur each week, month fortnight, year, etc, greatly speeds up this process.

No CSV? Use bank feeds

If your business has lots of expenses every week, and your bank doesn’t let you download your bank statement in a CSV format, you may find that manually creating one in Excel each month is too time consuming.

Set up bank feeds instead. Bank feeds is the process of linking all of your business accounts, whether they’re credit cards or bank accounts, to your accounting software, so that each time you make an electronic purchase, it’s automatically imported into your accounting software.

This will allow you to reconcile your account each fortnight, week or more frequently, if you desire, than once a month when your bank statement comes in.

***

Bank feeds save your business time and money. Find out more about setting up automatic bank feeds in Xero and importing bank statements into Xero. You can also read more about our new Cash Flow Reporting, Budgets and ROI Course for Xero, visit our website or enrol today!


learn to use excel online training course videos cheap best

Learn Microsoft Excel from scratch or brush up your Excel skills, at your own pace, with our affordable Excel online training courses — where you get THE LOT (that’s 9 courses in total) for ONE LOW PRICE — everything included! Volume corporate discounts are available and our courses count towards CPD Points. NOW is the time to learn to use Excel, one of the most-used software applications in the world.


 

Posted on

3 Things You MUST Do in Excel!

Business owners and job seekers take note!

learn xero myob excel online training course videos
Excel isn’t just for budding bookkeepers; it’s a great tool for all business owners to know.

MICROSOFT EXCEL IS THE most widely used spreadsheet application in modern computing. That said, it’s also one of the more difficult programs of the Microsoft Office Suite to learn, which is why we recently updated the content of our Excel training courses.

A lot of people do our Excel training courses to help them “skill up” to find a job, find a position better suited to them, or develop their career path. However, Excel is a fantastic tool for small business owners as well.

But whether you use Excel to create a pivot table or a database, there are a few things you should do each time you open an Excel document. Here we present you with three:

1. Vertical align: always centre

Always align the text in the cells of your Excel spreadsheet to the centre, or the top in certain circumstances. But never, ever align it to the bottom. It’s hard on the eyes and, when you’re looking at lots and lots of data in lots and lots of cells, it becomes difficult to know which row, column, etc, you’re looking in. Centre alignment, always.

2. Build error-checking into formulas

There should never be an instance where one of your workbooks is showing a #DIV/0, #N/A, #REF, #NAME?, #NUM!, or #NULL! error. This is especially true if you’re sharing these workbooks with your business partners or accountant or whomever.

Seeing an error in a financial report may cause the reader to doubt the accuracy of the entire workbook, so ensure your workbooks remain error free by using the simple IFERROR() error-checking function in Excel.

3. Print preview your work

Again, if you intend to share workbooks with other people, you should always ensure that your Excel workbooks can be printed nicely and easily, even if you don’t intend to ever print the document yourself. This is easy enough to do via File > Print Preview and adjusting the print margins before sharing (or printing) the document.

However, judging by the number of times I’ve printed an Excel document only to collect 87 sheets of paper off my printer to read the contents one 4×4 table, the function is seldom used by anyone else but me!

***

For more Excel formatting tips and tricks, download our FREE Beginners’ Guide to Excel, or enrol in our intermediate or advanced online Excel training courses to learn how to create databases, pivot tables, charts, graphs, and much more…

Read more about our beginners, intermediate and advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow!


learn xero myob excel cheap online training courses videos

At EzyLearn, we’re committed to helping students of our MYOB, Xero and Quickbooks courses gain employment as a bookkeeper or even start their own bookkeeping business; it’s why we provide you with lifetime access to our online cloud-accounting training courses as part of our commitment to continuing professional development


 

Posted on 1 Comment

Cash Flow Forecasting and Reporting Apps for Xero

Do you know how happy your business is?

running cashflow reports in xero and exporting to excel
Cash flow is THE key indicator of your business’ health and happiness so it pays to know the tools that will help you run regular cash flow reports.

AS WE’VE WRITTEN NUMEROUS times before, cash flow is the best indicator of financial health. A cash flow report takes into account the money you have in the bank after you’ve paid all your suppliers, employees, made your loan repayments.

Cash flow represents money in the bank

If, after paying your suppliers, employees, making loan repayments, cash outlays, and so forth, you don’t have any money in the bank (or you can’t make all of your obligations) this is negative cash flow.

Negative cash flow indicates a problem. There’s either a failing in one or more of your processes — your credit management procedures, for instance — or you’re simply spending more money than you’re making.

Cash flow forecasting is critical

You can create a cash flow forecast report in Xero by running a number of cash flow reports and importing them into Excel for analysis. (We’ve written before about how to link a financial forecast created in Excel with your Xero accounting information.) Linking the two in this way is a highly customisable method for seeing what you’re spending your money on, and when. You’ll also be able to track your clients’ payment patterns, so you can put processes in place to speed up the time it takes to get paid.

Forecasting and reporting apps

This Xero-Excel method for creating a cash flow forecast report can be time consuming, however. It also requires a good knowledge of Excel so you can set up formulas that will allow you to forecast 12 months ahead. 

For smaller businesses or sole traders — or even large businesses that just want to glance quickly at their cash flow — a dedicated cash flow app is a good way to track and forecast your business’s cash flow — and in real time. In our last blog we covered some of our favourite expense apps and why we like them.

Float

Float expense tracking app logoAt $79 a month for a basic (or “medium”) plan, Float is on the pricier end of cash flow apps, but its many features — in particular, the ability to create “scenarios” that allow you to determine the outcome of a particular business decision, such as employing two staff members instead of one — make up for it.

Float quickly learns trends in your business and will be able to anticpate upcoming payments, bills, etc. It also integrates with Xero, QuickBooks and even FreeAgent, the free cloud-based accounting app for small businesses.

FUTRLI

Futrli Expense App logoFormerly known as CrunchBoards, this British app, which has expanded into Australia and the U.S., features predictive alerts, KPI dashboards, tax forecasting (so you can accurately estimate your tax bill), trend indicators, forecasts for the next ten years (if you want), scenario planning, and a heap more.

It doesn’t, however, learn from your business, so it can’t predict upcoming payments and bills. FUTRLI will set you back $59 a month, regardless of whether you’re a startup, growing business or established enterprise. It integrates with Xero and QuickBooks.

Spotlight

Spotlight_Reporting-logoA lot simpler than FUTRLI, but with fewer features (although you could argue, it’s a spotlight on the *only* features you need), Spotlight will let you import all your budget data, create scenarios, and create KPIs for your business, making forecast reporting a cinch, but it doesn’t learn from your business.

This means it can’t anticipate upcoming payments from clients or bills coming due, leaving you to create forecasts based on past trends, rather than upcoming ones. Spotlight integrates with Xero.

***

Understanding your business’s cash flow is critical to its ongoing financial health, and to your ability to make sound business decisions. Our Xero training courses will show you how to run financial reports, including cash flow statements that you can use to create forecasts in Excel. Visit our website for more information.


cashflow reports in xero and excel

Our Xero online training courses include EVERYTHING for ONE LOW PRICE. Furthermore, if you select our Lifetime Membership option, you’ll have LIFETIME access to our ongoing course updates. All EzyLearn courses are accredited by the Institute of Certified Bookkeepers (ICB) and can be counted towards Continuing Professional Development (CPD) points. Find out more about our Xero online training courses. 


 

Posted on

EXCEL: Other Data Sources You Can Use to Create a Pivot Table

The latest versions of Excel are jam-packed with new features!

learn online training excel cheap best online training excel course videos
How are your Excel skills? Brushing up or learning how to use Microsoft Excel as a business tool could see you brimming from ear to ear too.

WE’RE ALWAYS UPDATING OUR Excel training courses, and as we do so, we’re reminded of just how useful Excel continues to be for small business owners — particularly the latest versions of Excel which include a boatload of new features that make it easy to create and manage relational databases, which you can also use as the data source for a pivot table.

But supposing, for whatever reason, you don’t want to use an Excel database as your pivot table’s data source? Well, there are some other options to create a pivot table without manually entering the information into Excel first. Here are a few more data sources that you can use to create a pivot table in Excel.

Office data connection files

The office data connection (ODC) file extension was created by Microsoft and contains properties to connect to and retrieve data from an external data source. It contains a connection string, data queries, authentication information and other settings. Microsoft recommends that you retrieve external data for your pivot tables and reports using ODC files.

External relational databases

If, for instance, you’re using another relational database program, like Microsoft Access or Filemaker Pro, you can also import data directly from these programs into your pivot table, rather than manually entering the data into an Excel worksheet. In the case of connecting data from an MS Access database, you can do this quite simply by selecting Access from the ‘data source’ dialog box. For all other external databases, you would select the ‘from other sources’ dialog box and follow the steps in the data connection wizard.

Using another pivot table

Each time that you create a new pivot table, Excel stores a copy of the data for the report in memory, and saves this storage area as part of the workbook file. To use one pivot table as the source for another, both must be in the same workbook. If the source pivot table is in a different workbook, copy the source to the workbook location where you want the new one to appear. Keep in mind that when you refresh the data in the new pivot table, Excel also updates the data in the source pivot table, and vice versa. When you group or un-group items, or create calculated fields or calculated items in one, both are affected.

Create a database in Excel first

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

***

Creating databases and pivot tables are part of our advanced Microsoft Excel training course, but you can start your Excel journey with our FREE beginners’ Excel course. Read more about our beginners, intermediate and advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow!


learn Xero online learning videos cheapest

Our Xero online training courses include EVERYTHING for ONE LOW PRICE. Furthermore, if you select our Lifetime Membership option, you’ll have LIFETIME access to our ongoing course updates. All EzyLearn courses are accredited by the Institute of Certified Bookkeepers (ICB) and can be counted towards Continuing Professional Development (CPD) points. Find out more about our Xero online training courses. 


 

Posted on 1 Comment

Explaining Why Excel’s Pivot Tables are So Mighty!

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

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

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

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

What are pivot tables used for?

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

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

Pivot table data sources

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

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

Create a database in Excel first

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

***

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

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


learn xero myob excel cheap online training courses videos

At EzyLearn we offer online training courses to help you up-skill and find employment. Choose from our range of cloud-based online accounting software courses, to business start up and management courses, to marketing and sales courses, or update and further your skills in a range of Microsoft Office programs (ExcelPowerPointWord) or social media and WordPress web design). 


 

Posted on 2 Comments

Using Excel for Client Databases

Excel does great CRM

learn excel cheap online learning training course videos
Managing large amounts of client and business data is not only possible, but also something you can learn fast and with ease with the help of our comprehensive range of online Excel training courses – covering all skills levels.

MICROSOFT EXCEL IS THE most widely-used spreadsheet application in modern computing. It’s ubiquity means most people use Excel on a regular basis, despite never having had any formal training in its many, many, MANY functions.

While updating the content for our Excel training courses recently, we were reminded of just how powerful Excel remains, and in particular, how useful it is for small businesses.

With its 2013 release, Excel got a serious update, which made it the perfect application to create and manage client and customer databases. Although there are many CRMs available on a subscription that provide the same functions of a database created in Excel, just in a more visually appealing format, they often lack reporting and analysis functions, requiring you to export your data in a Excel sheet anyway.

Flat file databases

Excel’s original ‘flat file’ database still remains the easiest and most basic database to set up and manage, and depending on your business and how you’ll use your database, a flat file database may be all you’ll ever need. If set up correctly, a flat file database will allow you to easily import your customer data into Word, your accounting software, an email marketing service, and so forth.

Relational databases

A relational database is a database that’s structured to recognise relations among the information stored in them. Microsoft offers a relational database program, called Access, which is available with Microsoft Office Professional or higher, or can be purchased separately.

Alternatively, you can create your own relational database in Microsoft Excel, providing you have the 2013 version or newer. When Excel got its update in 2013, it became easier to link charts and cells and to perform searches — all essential features if you’re working with large amounts of business data.

Correct Excel set up is crucial

Once Excel has been set up, it’s as easy as it is powerful to use. Of course, the key is to set it up correctly, so you can avoid errors or having to re-enter large amounts of data to make the format suit another third party software application.

***

Creating and managing databases is included as part of our Advanced Microsoft Excel training courses — and you receive access to ALL OF OUR COURSES, including ALL SKILLS LEVELS for ONE LOW PRICE. You can even start your Excel journey with our FREE Beginners’ Excel Course Workbook. Read more about our beginners’, intermediate and advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow!


learn to use excel online training course videos cheap best

Learn Microsoft Excel from scratch or brush up your Excel skills, at your own pace, with our affordable Excel online training courses — where you get THE LOT (that’s 9 courses in total) for ONE LOW PRICE — everything included! Volume corporate discounts are available and our courses count towards CPD Points.


 

Posted on

What to Do When You Have More than One Income Stream

Why it’s important to track your income streams

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

IF YOU’RE AN INDEPENDENT contractor, or you’re a full-time employee about to start up a side business, then you need to be able to keep a good track of all your income streams. There are a couple of reasons for this and both of them relate to tax. 

Basically, income is income, regardless of how you earned it, and you’ll pay tax on the total amount. As an employee of another business, you’re likely to be earning money through your tax file number. Each week, your employer will withhold tax commensurate with how much money your employer has paid you. But this doesn’t take into account any other income.

If you’re also earning money from a side business, using an ABN, there’s no one to withhold tax on your behalf, so you need to keep a close eye on your income to ensure you have enough money in the bank to pay your tax bill — which you will get, I’m afraid — after your tax return has been filed.

Two tax returns? Use Excel

Although income is income, you will still have to file two tax returns, one for each income stream. That’s why you need to keep an eye on your accumulative income, and not just the money earned through your business.

There are lots of personal finance and budget apps that help you to track and manage your income, but the easiest, most flexible and most straightforward way to do this is to create an Excel spending or expense sheet, which our Excel training courses will teach you how to do.

Reasons why people have two income streams

It’s not just full time employees who are starting their own side business that have two income streams. Plenty of freelancers and independent contractors earn money through their ABN and TFN.

There are some businesses that prefer to put contractors on the payroll, usually because they’ll be working on a regular basis, onsite, and it’s just easier for the business to employ them as casuals. Often for insurance purposes, but it’s also because the work involved doesn’t conform to the definition the ATO uses for an independent contractor.

Other times, it’s because the contractor or freelancer is working in an entirely different industry on the side — hospitality or retail, for example — to supplement their freelance income, which is how a lot of people get businesses off the ground.

Focus on how to earn money

The main take away from all of this, is that when you’re tracking your income, focus on the ways to earn more income. If you discover that each month, you have a week where your income is lower, there’s an opportunity to fill that gap with another job or other income stream.

***

You can learn how to create and manage your expenses or spending in our Excel training courses, where you’ll be able to create your own spending or expense sheet, and how to perform daily bank reconciliations in MYOB or Xero in our cloud accounting training courses. For more information, visit our website.


learn to use excel online training course videos cheap best

Learn Microsoft Excel from scratch or brush up your Excel skills, at your own pace, with our affordable Excel online training courses — where you get THE LOT (that’s 9 courses in total) for ONE LOW PRICE — everything included! Volume corporate discounts are available.


 

Posted on 1 Comment

Thinking of Starting a Second Business? Introducing Jerry

Case Study: Costs for starting up a second, related business

microsoft excel starting a second business
Contemplating starting a second business, related in some way to your first? Excel can help you forecast start up costs.

A LOT OF BUSINESS OWNERS branch out into related fields when their flagship business becomes successful enough (just look at Jim’s Mowing). However, this can be a bit dicey if the business owner doesn’t properly forecast all the start up costs. Not doing so can not only have an adverse impact on the new venture, but also on the existing business.

In this case study, we’re going to look at the start up costs associated with starting a real estate sales business.

Meet Jerry, our budding entrepreneur

Jerry is a male in his 40’s, currently working as an agent for a local asbestos removal company, earning a commission for helping the company make sales. In this role, he works as an independent contractor, invoicing the asbestos removal company at the end of the month. Because of the work he does, Jerry meets with lots of homeowners (and business owners too) who are renovating their home in preparation to put it on the market for sale or rent out.

Because of the client contact base Jerry is always developing, and knowing that there is no conflict of interest, Jerry decides he’d like to branch and become a real estate salesperson.

Budgeting for a new business from home

Jerry decides to operate his real estate sales business from home, as he plans to operate it as a side business, at least initially. Jerry won’t need to lease office space, but there are the following costs he will need to budget for. The costs he foresees are approximate:

  • Real estate license training course: $2,250
  • Website setup costs: $300 + training (if required)
  • G Suite account: $5/month upwards + training (if required)
  • Mobile phone: $55/month upwards
  • Business cards, flyers, other marketing materials: $99 upwards

Jerry’s ad-hoc operational costs

Although the majority of Jerry’s operational expenses will be reimbursed by the vendor once the property is sold — property marketing, auctioneer costs, etc. — Jerry will need to ensure he has enough capital to cover these operational costs. Property marketing costs are determined based on a percentage of the property’s value, usually 1 percent but sometimes lower. The median price of property in Jerry’s area is $440,000.

Because Jerry is already working as an independent contractor, he doesn’t have to incur any other operational costs (office furniture, internet, information technology, etc.), however his bookkeeper may apportion these costs differently now that Jerry is operating an additional business.

Determining upfront capital required

Jerry already has two homeowners who are thinking of selling their home in the next 12 months. He estimates that based on the value of each property, he will need to spend $5,000 each on property marketing. Therefore, he’ll need at least $13,370 in startup capital to fund his new venture for the next 12 months — although he knows that the initial $20,000 in property marketing will be reimbursed to the business within 6 months.

How Jerry will measure his success

Jerry is located in Newcastle in the Hunter region of New South Wales. Clearance rates in this region hover around 70 percent and properties spend an average of 50 to 70 days on the market, as property is typically sold by private treaty rather than auction. These two metrics will be used to determine Jerry’s success. Price is not a good indicator, as the nature of property sales means Jerry should be valuing property accurately with only a 10 to 15 percent difference in the final sale price.

Jerry should also research other real estate agents selling similar property in his local area to determine how many sales they are writing each calendar year. This can become another benchmark for Jerry’s success, although only a peripheral one, as Jerry is still only operating his real estate business on the side.

***

You can use Excel to work out a budget for the start up costs for your second business, and use accounting software like Xero, MYOB or QuickBooks to forecast whether your existing business will have the capital to fund your new venture.

Our Excel training courses will teach you how to create budgets and forecasts and our cloud accounting training courses will show you how to determine the financial health of your business.


Social Media and Digital Marketing online training course_comp

Successfully promoting your business products and services to clients these days requires a sound knowledge of how to spread the word via social media. Whatever your field, we can teach you the online marketing techniques to stand out from the crowd and build your customer base! Check out what’s included in our comprehensive Social Media and Digital Marketing online training courses.


 

Posted on

Should You Take Out a Loan to Avoid Delaying Payroll Payments?

Repayments on a business loan may be less than super and PAYG combined

Small business loan to finance PAYG and super
It’s not uncommon for small businesses to take out a business loan to meet their super and PAYG obligations – but this should never be a knee-jerk reaction to lean times.

IN A PREVIOUS POST we talked about taking out a business loan to cover payroll if you anticipate that you won’t have enough funds to do so otherwise.

Naturally, it’s always better to use your business’ own funds to meet your obligations, whether it’s paying staff or suppliers. This said, getting a business loan to cover payroll can be a good idea for small and growing businesses in certain circumstances. We look at these now.

Loan repayments are usually small

Depending on how many employees work for you, the repayments on a business loan are typically smaller than all of your payroll obligations — this includes superannuation and PAYG — combined. If you get a loan to fund 12 months of your business, payable over a 24 or 26 month period, the repayments will be far easier to manage each month.

Interest is usually a tax deduction

Businesses are able to claim the interest from any business loan as a tax deduction, so even if the annual percentage rate (APR) adds a few additional thousands of dollars to your capital amount over the period it takes to pay the loan back, the interest will still go towards reducing your taxable income.

This is a more favourable option to delaying payment to your employees (illegal) and delaying payment of PAYG and superannuation withholdings, which could incur a Failure To Lodge (FTL) penalty, plus a general interest charge (GIC). Note: Fines and penalties cannot be claimed as a tax deduction and are therefore dead money.

Do your sums first

taking out a small business loanDon’t forget that, while a business loan to cover payroll for 12 months will be easy to repay initially, your business’s profits will need to improve substantially over the next year so that you can continue to meet your loan repayments AND your payroll obligations for that year.

***

You can easily work this out using Microsoft Excel. Our Intermediate Microsoft Excel training courses show you how to determine if you can afford to take out a mortgage, but because all of our fields remain “unlocked”, you can easily modify them to suit a business loan scenario. Visit our website for more information on all of our Excel training courses.


 

learn excel online training course
Our online training courses feature real-life case studies to make our learning more relevant and true to life.
Posted on 1 Comment

Turn Your Wage Payments into a Business Loan

Only Managing Payroll on an Ad Hoc Basis? We Show You How

managing ad hoc payroll
If you know that you can’t quite make payroll, a short-term business loan may see you through and avoid penalties.

WE’VE RECENTLY UPDATED THE course content in our Intermediate Microsoft Excel training courses to include a workbook and spreadsheet (that you can use in your own business) showing you how to manage ad hoc payroll using Microsoft Excel. This will enable you to calculate your PAYG and superannuation obligations in Excel.

Using Excel to work out your PAYG and super obligations is a great way for small businesses, with a small number of employees, to save money. It saves you having to purchase this extra module in MYOB or Xero, for instance, when you may rarely use it. Saving money for small business is crucial as often it’s these same small businesses that have trouble making payroll payments each week, fortnight or month — and then wind up incurring further fees from the ATO when they’re late with their reporting and payments. It’s a vicious cycle.

When you can’t make payroll

If you’re finding it a stretch to make payroll payments, don’t worry, you’re not alone. Lots of business owners have trouble making payroll. But there are things you can do about it. We find that it frequently comes down to poor credit management processes or perhaps a downward trend in a business’ cycle that’s been missed due to poor or inefficient accounting processes. All of these can be rectified.

If the reason your business can’t make payroll is due to one or more shortcomings in your business’ operations, remedy the problems now. Similarly, if credit management is the issue, and late-paying clients are partially to blame, then tighten up or implement a credit management process. If it’s the result of bookkeeping that’s not up-to-date, find a bookkeeper to manage this for you.

How you can make payroll when cash is tight

Get financing. There are lots of ways to do this, but a common method, particularly if you need access to funds quickly, is to get a short-term business loan. Many short-term business loans don’t require businesses to have a great credit score, and will offer funding of as little as $5,000 right up to $500,000.

You’d have between 3 and 36 months to pay back the loan, but you need to be aware — the annual percentage rates (APR) are usually high. Most lenders require the business to have been active for a minimum of 9 months, and have revenue of more than $75,000 per annum. However, if paid off quickly, these can be an alternative to incurring penalties — it will obviously depend on your business’ individual circumstances.

Keep on top of bookkeeping

If you stay on top of your bookkeeping, you’ll either reduce the likelihood that you won’t make payroll, or as a worst case scenario, be able to foresee the periods when you won’t be able to, and be able to arrange finance in time to cover it.

***

Use the Ad Hoc Payroll Guide 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. Visit our website for more information on our entire suite of Excel training courses.


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

All of our online training courses can also be counted towards Continuing Professional Development points.


 

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

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.