Posted on 1 Comment

Should Your Bookkeeper Earn a Commission Off Your Software Subscription?

Is your bookkeeper’s bias disadvantaging you?

how to find a good local bookkeeper learn myob xero online accounting training course
Although a bookkeeper who is certified by a major accounting software company can be a good thing, you need to make sure their accounting package is best for your business.

SOME BOOKKEEPERS HAVE BEEN endorsed by software companies and are known as certified consultants or advisors. At EzyLearn we provide online training in Xero, MYOB and QuickBooks and we know that some people who hire bookkeepers aren’t aware of the benefits these certified consultants and advisors receive.

So what are some of the benefits? One; they get their accounting software for free, two; they receive a discount or commission for each new business they sign up to use that particular software.

Does this make certified consultants and advisors biased?

For a business owner, the upside to hiring a bookkeeper endorsed by a software company is that they will be able to work with that software application quickly and efficiently. The potential downside, however, is that the software application may not be especially suited to the business, but has been recommended anyway because the bookkeeper earns a commission for doing so.

Research first

A way around this is to do some research first. Compare a few different accounting applications before making contact with a certified consultant or advisor. Once you’ve decided on a particular software, you shouldn’t find yourself in any strife.

If, however, you contact a bookkeeper without doing your own research first, there are some things to be wary of, such as whose name the subscription will be in — failing to do so could prove to be a costly mistake.

Independent bookkeepers bring software skills and more

Most independent bookkeepers are usually proficient in a few of the major accounting applications, like Xero, MYOB and Quickbooks, rather than just one, so they’ll be able to recommend the software that suits you and your business needs the best.

They’re also able to set up your accounting software for you and provide training if necessary, just as a certified consultant or advisor can — only you’ll be in control of your subscription instead of your bookkeeper.

To ensure your independent bookkeeper is just as qualified as a certified consultant or advisor, ask to check their references. By law, a bookkeeper can’t perform BAS or tax services unless they’re registered with the Tax Practitioner’s Board (TPB) so you can check with them to ensure they are. If you’re worried about their software skills, ask if they’ve taken any short courses in a particular accounting application.

We want to help you get the best from your bookkeeper. Check out our recently upgraded National Bookkeeping directory which features bookkeepers from all over Australia. Or perhaps you’re after software training in MYOB, Xero and QuickBooks? We feature online training in these, and many other business-related courses: see our website for more


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

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

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

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

Is the ATO Getting into the Cloud Accounting Game?

The ATO is helping you keep track of deductions and expenses

ATO expense app learn xero online training course
The ATO’s recently launched app isn’t helping you invoice just yet, but it is good for keeping track of your business deductions.

ALL BUSINESSES CAN TAP into useful cash flow forecasting apps, whether they use Xero, Quickbooks or MYOB. There are also a host of basic expense and budgeting apps that sole traders and contractors can use for similar purposes.

The difference between the two boils down to price and functions: The more functions you need, the higher the price tag. Businesses that require high-level reporting and forecasting tools, such as a “scenarios” function that lets you determine the impact different business decisions would have on your cash flow, before you actually make them, would need to stump up, at a minimum, between $50 and $80 a month for this functionality.  

Free expense and budgeting apps would suit most contractors and sole traders who don’t require complex forecasting and reporting tools, but who do need to see when money is coming in and when it’s going out, and whether there are deficiencies.

The ATO’s tax and superannuation app

ato app my deductions learn xero online training course
Image: Courtesy of ATO website

Looking into the best expense and budgeting apps for small business, we came across the Australian Tax Office’s app, simply called ATO. It works on Windows phones, as well as iOs and Android devices, and it’s updated regularly by the ATO, so you know this isn’t just a passing fling.

Our post on cash flow reporting and forecasting for contractors and sole traders went through the app’s functions, including what we thought were some standout features:

  • Recording expenses and deductions
  • Tracking mileage
  • Inputting income
  • Tax calculators
  • Business performance calculator
  • Lodging income tax returns.

If these features sound familiar, that’s because they’re all the features you’ll find in a basic cloud accounting program, with the notable exception of invoicing. Electronic invoicing is not something the ATO is particularly concerned with because it’s not a requirement. Invoicing, of course, is a requirement, but how you do it — in person, by snail mail, email, etc — isn’t.

Cloud accounting still best and easiest

If the ATO app introduced a simple way to invoice customers, we’d say it was definitely muscling in on QuickBooks and Xero’s territory, since both programs appeal to the small business owner, QuickBooks in particular.

In absence of that, the ATO app is a great tool for contractors and small business owners to use to keep track of their expenses and deductions, and especially to calculate their tax rates (so as to properly keep money aside for tax, rather than being hit with a tax bill you have to pay off). For contractors with a very simply business model, it’s even useful for lodging your tax return.

But otherwise, cloud accounting applications are still the best and easiest way for businesses to run an efficient, compliant business. At the end of the day, for many small business owners, they’re not drawn to Xero or QuickBooks because they want to stay compliant, it’s because they want to be able to easily invoice customers and track their income — compliance is just an added bonus.

Our online Xero training courses meet all skills levels for ONE LOW COST. We will show you how to record deductions, invoice customers, run financial reports, and lodge activity statements and tax returns. Visit our website for more information about our range of online accounting, media and general business courses.


learn to use excel online training course videos cheap best

Need to brush up on Excel? 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! And all of our Excel courses can be counted towards CPD points.


 

Posted on 2 Comments

Cash Flow Forecasting for Sole Traders and Contractors

Great expense apps if you’re self employed

expense apps for self employed people
Are you busy and self-employed but can’t afford the higher price tag of some expense tracking apps? Don’t worry, there are cheaper options available.

AS WE’VE WRITTEN PREVIOUSLY, cash flow is one of the most accurate instruments for predicting your business’s financial health. It’s more accurate than profit and loss statements, which don’t take into account any cash outlays, and so don’t show a true picture of your business’s finances.

We have also checked out some of the latest cash flow forecasting apps that integrate with Xero and other accounting packages. These can be excellent tools for businesses that employ staff or are expanding rapidly, but there are still many business owners that don’t fit into that category, and although keeping an eye on their cash flow and forecasting trends remains critical to their financial health, they can’t justify the high price tag of an app like Spotlight or Float.

Expense and budgeting apps

What’s a cash flow app, if not a program that tracks your expenses and income and then tells you how much money you have left in the bank? That’s what FUTRLI and Spotlight, the apps we reviewed recently would do, and then also let you do other things, like create scenarios to determine the particular outcome of a business decision.

But there are other expense apps that sole traders and contractors can use for cash flow forecasting:

Pocketbook

Pocketbook, the Australian personal finances app recently acquired by ASX-listed ZipMoney, is free to use, although a recent deal with 1300HomeLoans means it may analyse your spending data to make commercial suggestions around your personal finances. (For the record, I have been testing it for months and hasn’t been subject to any such suggestions.)

Pocketbook lets you connect your bank account to the app so it can import your income and transaction data. Once you get some initial housekeeping — categorising your expenses and income — out of the way, you can then set up a safety spend limit based on Pocketbook’s analysis of your spending vs. income.

Pocketbook also learns from your transaction history, meaning it can predict upcoming income and bills. It’s very nifty for contractors or freelancers who have more than one income source that doesn’t always run through your accounting software — if you’re working on your TFN and ABN, for instance.

TrackMySpend

TrackMySpend expense apps for Xero online training courseThis free app, by ASIC MoneySmart, lets you connect your bank account to the app, categorise your expenses, nominate a spending limit, and create expense reminders that can be sent to as text messages ahead of their due date.

Like Pocketbook (but without the commercial overtones), TrackMySpend will also learn from previous trends in your income and expense data to predict future income and expenses. Best of all, TrackMySpend can be exported as an Excel file or connected to your accounting software. The iOS app is a bit out of date, though, so it won’t work on more recent Apple devices.

ATO

ato_mobile_app for Xero online training course videosIf you didn’t know it already, the Australian Tax Office has its own mobile app. It allows you to access the ATO’s online services, lodge and track your tax return (yes, right from your mobile phone), work out key tax dates and access tools and calculators.

Its most handy functions: being able to enter your expenses (including a photo of receipts and bills), track mileage, and record your income. It’s not automated, but it does propagate that info directly into your tax return, so you don’t have to do it later. It also accurately calculates your tax liabilities.

The ATO app’s best function, however, is its “business performance calculator”, which, using the data you input, will give you an indication of your business’s ability to pay its debts, as well as a comparison of its performance based on the ATO’s “small business benchmarks” data. Over time, it’ll also show whether your business has improved or declined since you last used the tool.

Understanding your business’s cash flow is critical to its ongoing financial health, and to your ability to make sound business decisions. Use one of these tools in conjunction with your accounting software to ensure your business is running on all cylinders.

***

Our Xero training courses, which provide training in EVERY LEVEL for ONE LOW COST, 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 about our online training courses.


Social Media and Digital Marketing online training course_comp

Are you in business as a bookkeeper, tradesperson, retailer, trainer or real estate agent and want to stand out from the crowd? We can teach you the online marketing techniques to help you do just this! Check out what’s included in our comprehensive Social Media and Digital Marketing online training courses.


 

 

nnn

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.

With cloud accounting software you can work remotely from home or anywhere and have up-to-date information. Continue reading Cash Flow Forecasting and Reporting Apps for Xero

Posted on 1 Comment

Top 3 Expense Applications for Xero, QuickBooks and MYOB

best-apps-for-myob-xero-quickbooks

Get your financial software working harder

best-apps-for-myob-xero-quickbooks
There are a number of apps which link with Xero, MYOB and Quickbooks to help you closely and seamlessly track ALL your business expenses.

WE PREVIOUSLY WROTE ABOUT using Expensify and Xero to do the grunt work of your account reconciliations. We’ve also touched on how Expensify works for retail shops, online shops and hospitality businesses.

This time we’re looking at other expense applications that not only integrate with Xero, but other platforms like MYOB and QuickBooks, too. (For the record, every transaction Expensify does with Xero, it also does with QuickBooks; and also for the record, we not only provide online training in Xero [all levels for one low cost] but MYOB and Quickbooks too.)

Here are some other expense tracking app integrations.

Continue reading Top 3 Expense Applications for Xero, QuickBooks and MYOB
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

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