Posted on

MYOB Unlimited Offer Not Really Fair

MYOB, Xero & QuickBooks Online Courses for tradespeople
MYOB, Xero & QuickBooks Online Courses for tradespeople
Is MYOB mocking tradies in their new ad

I WAS DOING SOME research about MYOB’s large and confusing product suite recently, when I came across the word “unlimited”, followed by an asterisk.

I thought this was odd, since I didn’t think the word “unlimited” required much more explanation — doesn’t it, after all, mean inexhaustible, limitless, boundless, and so on?

It turns out there ARE limitations around MYOB’s products — and it relates to bank feeds. They are subject to a fair use policy, but the downloaded document doesn’t actually quantify what constitutes “fair use”, so our team had to go and do a little digging.

What is “fair use”?

The term “fair use” has been unusually co-opted by companies and businesses, usually telcos and ISPs, to put some limitations around their “unlimited” product plans. Traditionally, “fair use” referred to copyright, and the use of texts — be they music, films, books, etc — in a manner that is considered fair. I was involved in a VoIP telephone business when a company from the US called Fonality made a HUGE running dive into the Australian telecom market with fixed cost plans when it was still new to Aussies.

They offered an “Everything’s Included” package based on a fixed cost per line and it too was based around a “Fair Use Policy” which you had to dig really deep to find and understand. The most common example I’m aware of is for Internet access by gamers who use an incredible amount of download data compared to most people and I understand that their usage may be unfair but I also think this type of clause in a product offering is very UNFAIR — particularly on your competitors (who would probably happily match it!).

In copyright law, brief excerpts of copyrighted material may be used verbatim for the purposes of criticism, news reporting, teaching, and research without requiring the permission (or payment to) the copyright holder.

How does “fair use” apply to MYOB?

Click the image and then zoom in to see if you can see it.

In the case of MYOB’s not-unlimited bank feeds, there’s a monthly threshold, depending on the type of MYOB product or plan you’re on, and once you exceed that threshold, you’ll be charged a fee for each bank feed transaction you carry out that month.

It’s basically a reinterpretation of the “fair use” policy as it relates to copyright law, to suit MYOB’s purposes.

Although the document I was encouraged to download didn’t outline MYOB’s Bank Feeds Fair Use Policy, I managed to find it elsewhere on the MYOB site, which has been republished below (under the fair use policy for copyrighted material!).

So long as you don’t exceed the number of monthly bank feed transactions your plan permits, you should be fine, though the term “unlimited” is fairly misleading in this instance, since they have a clearly defined number of transactions they allow.

No Ambiguity with LIFETIME Access

EzyLearn Online Course Updates & Additions for latest versions of Xero, Excel & MYOB coursesEzyLearn has been in business since 1996 and online only since 2006. In 2011 we launched LIFETIME course access as an option for selected courses and we did it because we could!

We have the systems in place to track students enrolments so it’s something we feel very comfortable with and we’ve had many students ask us about it a couple years after doing their course — obviously they were thrilled that we still had their details on file and gave them access to the CURRENT course. Yes, when we offer lifetime course access it means you get to the NEW version of the software course as well as the older one. That’s part of our Update and Addition Policy.

You can learn more about bank feeds with MYOB and how to set them up in our MYOB training courses. Visit our website for more information or to enrol.


 

Posted on

Profitable Businesses Suffer Poor Cashflow

Xero Advanced Certificate Training Course cashflow-forecast-charts-reporting-budgets

Xero Course cashflow-forecast-charts-reporting-budgetsI’VE TALKED ABOUT CASHFLOW on this blog before, particularly as it relates to good credit management processes.

This time, however, we’re going to look at how profit differs from cashflow, even though the two are intimately related.

There is the perception that a profitable business can’t suffer from poor cashflow, but this is incorrect. There are plenty of profitable businesses that don’t have enough money in the bank at a given time to pay their outgoings because cashflow is lumpy.

We’re in business to make a profit, and yet the term ‘profit’ is really just an accounting concept. Profit is revenue minus expenses, but it doesn’t reflect our investment in capital assets, such as equipment or vehicles, nor does it take into account the liabilities we have funding our business (loans and hire purchases).

Cashflow is the true indicator of success

Cashflow, unlike profit, is about timing. Specifically, it’s about having money before you have to pay out money, something not identified by profit. Managing cash flow is one of the most stressful things about running a business, because many variables affect it.

Sure, not earning enough money or not having processes in place to make sure that money flows into your business in a timely fashion are part of it, but there are other factors too, such as:

  • Incorrectly priced products or services
  • High overheads
  • Holding too much stock
  • Large bills (tax bills)
  • Seasonal cycles
  • Large projects
  • Growing pains (putting on more staff, increasing stock levels)
  • Unrealistic forecasts.

P&L reports help determine causes of poor cashflow

Quite a few of the things that adversely affect a business’s cashflow can be determined by running regular Running Multi-Period Profit and Loss Statements], while others can be managed (or avoided) by implementing better processes or procedures for doing business.

Product based business which keep inventory can have their cashflow affected by:

  • incorrectly priced products and services
  • holding too much stock
  • seasonal sales cycles

and this evidence will show up when you run your P&L reports, as well as your inventory sales and stock-on-hand reports. If, for example, you identify that May, June and July is your busiest quarter, while November, December and January is your quietest, and where you struggle to meet your outgoings, you should implement strategies to better plan for that leaner period.

A seasonal period of downturn is common among most businesses. It’s how you manage and plan for that downturn that separates successful businesses from ones that aren’t. For example, it’s unwise for a sole trader to take a holiday March, a seasonally busy period for his business, when he could wait until June when it’s much quieter.  

Your bookkeeper will play a key role in how you plan and manage your cashflow. Ask them to run reports that will help you to identify any inefficiencies in your business that’s causing poor cashflow, and implement strategies to better manage it.

Bookkeeper, BAS Agent or Finance Manager

start a bookkeeping business & find a good bookkeeperIf you’re looking for a reliable bookkeeper to manage your daily or weekly bookkeeping and accounts, either remotely or in-person, Tracey from Rockingham is a highly qualified bookkeeper, who also has the practical experience of having operated her own business in the past. Tracey has a lot of experience in the day-to-day accounting functions of a small business and you can contact her directly as a fully licensed member from her profile page.

Our National Bookkeeping website has recently gone through a significant upgrade so watch out for more stories about featured bookkeepers in forthcoming blogs! Join and we can feature YOU in our articles too. Subscribe and stay tuned to learn about some new members who have moved from the corporate world to focus as Finance Managers for small to medium businesses. 

Learn How to use Xero EzyLearn Online CoursesXero for LIVE data and Accurate Reports

Xero enables business owners and their bookkeepers and financial managers to see what is going on RIGHT NOW and because it’s popularity is growing we’ve created a NEW Xero course which goes through a great example of the business decisions that a business owner makes about buying an investment property, figuring out which products/services provide a better Return On Investment (ROI) and more.

Check it out at Xero Cashflow Course and remember that existing EzyLearn students can get access to this course by just sending an email request to student support.


 

Posted on

How to Tell You’re Setting Your Prices Too Low

How to set prices in business

how to set prices in business
Don’t shoot yourself in the foot by pricing too low and only winning jobs that you make very little on!

AS ALL SMALL BUSINESS owners know, setting the right prices is a difficult task. And a lot of newbie business owners think that being cheap is the better than meeting the market, but that’s not always the case.

Take, for example, a tradesperson I met recently. This tradesman is a painter and he’d been in business for a while before he realised his prices were set too low, and despite all the business he was getting as a result, it was actually costing him money. (We cover more detailed, real-life case studies like this in our micro courses.) 

He shared with me the tell-tale signs that your prices are too low.

Lots of small, one-off jobs

Small jobs are important because they keep the home fires burning, so to speak. But you need a good balance of small jobs and bigger projects, with the small jobs being completed around or in the middle of the larger ones.

If you’re only getting lots of small, one-off jobs that you spend more time to travelling to than it takes to complete the work, this is a good indication that your prices are too low. For jobs like these, either charge for travel time or a call-out fee.

For small jobs … charge for travel time or a call-out fee.

You’re too busy to plan ahead

If you find that, in order to make ends meat, you need to keep yourself so busy that you don’t have time to plan your working week, then your prices are too low. You should be able to plan out your weeks so customers know when to expect you, and so you can be as productive and efficient as possible — if you have two jobs in the same area, for instance, planning ahead will allow you to go to those jobs on the same day.

Use a tool like Google Calendar from G Suite to organise your days, and keep in touch with customers along the way so they know to expect you.

You can’t afford to pay for help

Setting your prices lower than your competitors may be one way to win jobs, but the downside is that you’re constrained to completing the work entirely yourself. The tradesman, a painter, whom I was speaking with, told me about a time he couldn’t afford to find another painter to help prepare walls or pitch in with the painting because his prices were too low.

If you’re not able to pass jobs onto other businesses in your industry — subcontracting — and still clip the ticket, or you’re not able to afford to use a portion of the money you’d earn to hire someone to complete part of the job, you’re charging too little.

You’re too busy to invoice promptly

Just as it’s important to plan your work weeks in advance, it’s equally important that you invoice customers for the work you’ve completed in a timely manner. If you find that you often don’t have the time to invoice customers until a week or a month has passed, there’s a deficiency in your business processes. Use accounting software like Xero so you can invoice on the go.

***

We cover setting prices the market — and your business — will bear in our EzyStartup Course. Visit our website for more information and to enrol.


Check out our Spring Specials!

learning how to use excel and xero with online training

We have a host of online training course specials for the spring season — take a look!


 

Posted on

Don’t Wing It With Customer Service – Plan It

Great customer service doesn’t just happen.

learn online training videos about small business customer service
If you’re unsure about what makes up the kind of customer service people rave about, then perhaps you should look into our EzyStartUp Course.

HOW TO PROVIDE REALLY exceptional customer service is just one of the modules covered in our EzyStartUp Course which teaches you all about how to start up your own business.

We handpicked this inclusion as our experience is that, time and time again, good, nay excellent customer service goes a long way to ensuring a business has longevity. Continue reading Don’t Wing It With Customer Service – Plan It

Posted on

When Do You Need to Register as a BAS Agent?

MYOB and Xero Training Courses and becoming a registered BAS agent to start a bookkeeping business

Making the effort to specialise reaps rewards

BECOMING A REGISTERED BAS agent means you are permitted to lodge a client’s business activity statements (BAS) on their behalf, each month or quarter, or as determined by the ATO.

BAS agents are really bookkeepers; but they’re ones who have done some extra training and applied to the Tax Practitioner’s Board (TPB) for a BAS agent’s accreditation.

Not every bookkeeper has to register as a BAS agent, but those who do typically earn more as a registered BAS agent than a straightforward, no-frills bookkeeper does. That’s largely due to the way cloud-based software, like Xero and Quickbooks, has made it a lot easier for businesses to manage their own bookkeeping. But even just speaking generally, bookkeepers who have specialised skills always tend to earn more.

So when don’t you need to register?

Continue reading When Do You Need to Register as a BAS Agent?
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

Who Do You Trust More: Real Estate Agents or Tradies?

Still unsure whether you can trust online ratings and reviews?

trusting online reviews and ratings for tradesperson real estate agent online ratings and reviews
After a tradesperson? Sometimes asking a business person from a related business, such as a real estate agent, can be a good source for a recommendation.

IT CAN BE HARD to know whether you can really trust online ratings and reviews, whether these reviews and ratings are objective and even relevant and how they compare to recommendations and testimonials. By recommendations we mean word of mouth referrals from your friends and family and so forth, and testimonials that have been written by real people — with real names and real locations!

In our recent post about recommendations we suggested that you ask a friend, relative or colleague if they’ve ever had experience with a business you’re thinking of using — chances are, if your friends live locally they may well have; or if the business is a chain or franchise operating over a wide area.

Also ask other businesses

When seeking a professional recommendation you can also ask other businesses. Find out what their experiences have been, if any. Often businesses will have a relationship with each other even if it is not, at first, apparent.

For instance, a symbiotic relationship tends to exist between real estate agents and tradespeople. Agents will regularly draw up a list of preferred tradespeople that they work with and recommend to their tenants, landlords and vendors.

And there are plenty of tradespeople who do the same for real estate agents that they’ve had professional dealings with. There are plenty of other examples of these sorts of professional recommendations.

Beware professional bias

Of course, just as you should be wary of overly positive or negative ratings and reviews online, you should be likewise when soliciting professional reviews. If one business regularly referred work by another, even if they don’t think they’re a great business to deal with, neither party will necessarily say anything bad about each other.

In the end, when looking for a tradesperson, real estate agent or some other professional service, be sure to do all your research. Ask around for personal referrals, check them up online, and get in touch with each business directly to see which one is the best fit for you.

Real people, real locations

At EzyLearn we provide testimonials from our students, which include their full name and location, and why they chose EzyLearn to study in the first place. We also offer a money-back guarantee and free samples of our course content, so students know they can trust they’re making the right choice. Visit our website for more information and to see our wide range of 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). 


 

Posted on 1 Comment

Ratings, Reviews, Testimonials, Recommendations

Why you can’t beat old-fashioned word of mouth

social media ratings reviews online word of mouth referrals
Online ratings and reviews have a role to play in buying decisions, but sometimes you just can’t go past traditional word of mouth to find good workers.

ONLINE RATINGS AND REVIEWS ARE a great way to determine whether a business is trustworthy or whether they products and services they provide will suit your needs. TripAdvisor and Yelp have transformed the hospitality and accommodation industry, for example. And Airbnb is doing similar with short-term rentals.

But as we’ve previously discussed, online ratings and reviews can be easily faked and sometimes biased or devoid of useful information

Looking for a local? Ask around!

While recently working on a home renovation in Newcastle, I came across a carpenter who had seven employees working for him. Jimmy the Chippy in Belmont has been in business nine years, has no website or online presence — but his business is booming.

How does he do it?

The old fashioned way! He does exceptional work for his customers and clients, who hire him again and again and refer him to friends, relatives, colleagues and so on. He also made a point of networking with local builders and plumbers in the area, who contact him when they have work to do, and refer him to other builders and plumbers as well.

Use word of mouth

If you’re looking locally, and the online ratings and reviews of the businesses you’re trying to decide between aren’t helping, asking a friend, relative or work colleague if they know any of the businesses.

If no one in your social network knows the business, you can also google an online forum like Whirlpool, where members frequently provide fair and balanced opinions of businesses they’ve dealt with — and if they don’t, they’re usually called out for it.

Testimonials are helpful, too

Real estate agents, accountants and many other businesses — EzyLearn included — use testimonials rather than ratings or reviews (except on Facebook), so you shouldn’t discount these just because they’ve been vetted before going online.

And don’t be put off if a business has received the odd bad review. Look at why they’ve received the review and what the business has done or said to address the bad review. Some businesses with a less than perfect record may be more trustworthy than those with reviews and ratings moderated by the businesses themselves.

At EzyLearn we provide testimonials from our students, which include their full name and location, and why they chose EzyLearn to study in the first place. We ask each student whether it is ok to publish these beforehand. We also offer a money-back guarantee and free samples of our course content, so students know they can trust they’re making the right choice.

***

At EzyLearn, we’re committed to helping students of our online training courses, be it in in Xero, MYOB, Excelsocial media or other courses, gain employment as bookkeepers, generally better their businesses, or even start their own bookkeeping business. To this end, we provide you with a Lifetime Access option to our cloud accounting training courses.


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

What are Online Ratings Based On?

Reviews tell a whole lot more

online reviews and online ratings social media
Many people make buying decisions based on online reviews and ratings but how “real” are these? And how can you tell?

IT CAN BE DIFFICULT to tell whether online ratings and reviews are real or not. One easy way to get a pretty good idea of what’s real and what’s not is checking for a balance of positive and negative ratings and reviews that have been left by real people who’ve used their Gmail or Facebook account.

Reviews are better than ratings

If you’re a person who relies on ratings and reviews to make purchasing decisions, you’ll know you can’t really tell the trustworthiness of a businesses if it only asks customers to leave a rating (usually out of 4 or 5). Similarly it’s hard to tell what people really think of a business if they’ve only left ratings rather than reviews. 

Businesses with a good mixture of ratings and reviews, where a customer has been able to leave a comment justifying the rating they gave the business, make it much easier to make a decision.

Check the content of reviews

You don’t need to read thousands of reviews for a business, but it helps to read a few of them to see what customers are saying. This also helps determine whether these reviews are truly independent or not.

What are reviewers actually commenting on, and if they’re negative, is there a pattern? Is a local restaurant consistently understaffed or does a plumber often fail to turn up on time? Are the complaints about things that would concern you or are they petty — a long queue at a cafe that still serves good food and coffee, for example.

Positive reviews provide useful information

If the reviews of a business are mostly positive, do they provide any useful information? Hundreds and hundreds of reviews that simply say “great” or “fantastic” don’t tell you enough about what customers thought were great or fantastic about that business.

People might have really liked something that doesn’t suit your needs. It is also a good indicator that they’re not entirely true or real reviews either.

At EzyLearn we provide testimonials from our students, which include their full name and location, and why they chose EzyLearn to study in the first place. We also offer a money-back guarantee and free samples of our course content, so students know they can trust they’re making the right choice.

***

Want to brush up your skills in cloud accounting software? Ready to progress to intermediate or advanced levels in MYOBMicrosoft ExcelXero or another accounting package? Need help with social media? Take a look at our wide range of online course options or visit our website for more information.


learn online training Xero courses videos for less

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

Can You Trust Online Ratings and Reviews?

How to tell a review is authentic

online reviews are they real
If using online reviews to help you work out what to buy, you want to make sure you’re really hearing it from the horse’s mouth, and not just reading fake marketing guff.

IF YOU’RE ANYTHING LIKE most people, rating and reviews are how you probably make many of your purchase decisions. This can be for purchasing white goods, clothing, a holiday, or even choosing a real estate agent. Continue reading Can You Trust Online Ratings and Reviews?

Posted on 1 Comment

Cash Flow Reporting in Xero

Show me the money!

learn cashflow reporting in xero online training course videos
Creating a cash flow report in Xero will tell you more about the financial state of your business than profit and loss statements.

IN OUR BRAND NEW Cash Flow, Budgets and ROI Xero Training Course, you’ll learn how to generate a cash flow report for your business.

Cash flow reports show the money going in and out of the business, so they’re better indicators of a business’s overall financial health than a Profit and Loss statement (P&L).

A cash flow report enables you to make forecasts and budgets for your business based on previous trends — recurring expenses, average time to get paid, seasonal quiet periods, and so forth.

The 3 cash flow categories

Cash flow reports are typically broken up into three categories:

  1. Operating activities: cash flowing in and out of the business from revenue-generating activities
  2. Investing activities: cash flowing in and out of the business from the acquisition and sale of long-term assets
  3. Financing activities: cash flowing in and out of the business from borrowings and changes in equity.

Items in a cash flow report

In our Cash Flow, Budgets and ROI Xero Training Course, you’ll learn how to generate a cash flow report in Xero. That report will show every transaction that’s run in and out of your business, divided among one of the three categories.

In the operating activities category, you’ll typically find things like costs associated with any training courses or seminars, advertising and marketing expenses, income or commissions from your business, subscriptions to any magazines or periodicals, etc.

Under the investing activities category, you’ll find the cost of purchasing office or warehouse space and the capitalised borrowing cost, for example.

The financing activities category will show the loan you’ve taken out to purchase your business’s office or warehouse space.

You’ll learn how to generate and work with cash flow reports in our new Cash Flow Reporting, Budgets and ROI Training Course. ENROL now or read more about the benefits of cash flow reporting to your business. Are you a sole trader or contractor needing to record your ongoing expenses? We cover that too!


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. Or learn more about our entire suite of online software training packages and social media training packages.


Posted on 1 Comment

3 Things You MUST Do in Excel!

Business owners and job seekers take note!

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

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

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

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

1. Vertical align: always centre

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

2. Build error-checking into formulas

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

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

3. Print preview your work

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

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

***

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

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


learn xero myob excel cheap online training courses videos

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


 

Posted on

Are You Making these GST Mistakes in Your Bookkeeping?

find a good local or remote bookkeeper

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

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

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

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

Continue reading Are You Making these GST Mistakes in Your Bookkeeping?
Posted on 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

What to Do When You Have More than One Income Stream

Why it’s important to track your income streams

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

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