Posted on 1 Comment

The July Launch of Cloud Accounting System, Wiise: What’s in Store for MYOB and Xero?

man thinking wiise accounting software learn study online training courses

Should all good bookkeepers be getting wise to Wiise?

man thinking wiise accounting software learn study online training courses

THIS JULY A NEW ACCOUNTING SYSTEM is attempting to lure Aussie businesses away from the incumbent cloud accounting majors MYOB, Xero and QuickBooks, with the promise of “access to big-end-of-town technology,” according to a report in The Australian Financial Review.

Wiise, which is owned by the deep pockets of KPMG and will operate under a strategic partnership with Microsoft and the Commonwealth Bank, will combine cloud accounting, job costing, workflow scheduling and inventory management, payroll, sales and marketing and customer relationship management into one system.

Pricing hasn’t been confirmed, but it’s understood Wiise will operate a tiered model, costing businesses between $60 and $200 a month.

The software will integrate with all major Australian banks, but added functionality will be given to CBA customers, such as access to working capital and financing options.

Businesses that have outgrown their cloud accounting system

Although Wiise will target SMEs; founders KPMG, Microsoft and CBA say the software isn’t competing with MYOB, Xero or QuickBooks for customers.

Rather, the Wiise software will suit complex businesses that have outgrown traditional cloud accounting systems, because their business operates in more than one location, has a complex supply chain, various legal entities or high transaction volumes.

The Wiise software will suit complex businesses that have outgrown traditional cloud accounting systems.

Wiise will also appeal to businesses that want to use one piece of business software, rather than multiple separate systems or cloud-accounting add-ons.

That said, it’s probably a worry to MYOB, which signalled it would grow market share by pursuing bigger and more complicated businesses; acquiring the enterprise reporting system Greentree in 2016.

What does this mean for bookkeepers?

So while contract bookkeepers should remain competitive by keeping abreast of new technologies, is Wiise yet another cloud accounting system bookkeepers, tax agents and accountants will need to learn how to use? Well, that depends on how quickly it penetrates the market. And if it penetrates the small business market in any significant way.

As a general rule, most small businesses want to spend as little time worrying about compliance as possible, which is as it should be. Simple businesses with straightforward tax and compliance requirements typically stick with simple cloud accounting systems.  

So there’s value in bookkeepers that typically services larger, more complicated businesses learning more about Wiise, but probably not for bookkeepers that look after smaller, straightforward businesses.

***

Who’s Managing Your Business Accounts?

expense apps for self employed peopleIf you’re a business owner trying to decide on an accounting system, speak with your bookkeeper or tax agent to determine the best option for your business.

If you’re looking for a reliable bookkeeper or tax agent to manage your business accounts, visit the National Bookkeeping website to find someone professional, able to work in your office, or remotely,  to suit the needs of your business.


 

Posted on

MYOB, Xero, QuickBooks and the Cloud Accounting Ecosystem

smart woman realising xero most popular accounting software program in australia and nz

How accounting is becoming more simplified:

And how bookkeepers and accountants can become a “one-stop-shop” for those needing help with their finances (Part 1 of 2)

smart woman realising xero most popular accounting software program in australia and nz

EARLIER THIS YEAR, Intuit, the parent company of cloud accounting system QuickBooks, announced it had acquired U.S.-based time-tracker platform, TSheets, in a deal worth $340 million U.S.. This was part of Intuit’s strategy to expand its offerings to small businesses and the self-employed. (In the U.S. and Canada, Intuit also operates a cloud software package called TurboTax, which lets individuals file their own federal taxes.)

What the TSheets acquisition means

The TSheets acquisition makes a lot of sense, and provides a good guide to the kinds of businesses cloud accounting firms look to acquire. For example, TSheets and QuickBooks already shared 12,000 customers worldwide, and TSheets had been developed to integrate specifically with QuickBooks (though it also works with Xero and Reckon). It also brings Intuit and QuickBooks in line with one of its competitors, Xero, which acquired a similar project management system WorkflowMax back in 2012.

For TSheets, being part of a big global brands means it’ll be able to innovate faster, with access to the Intuit technology and product team; for Intuit, it’s an additional source of revenue and market share. (Although a privately held company prior to the acquisition, TSheets had been valued at around $40 billion US.)

The cloud accounting ecosystem

Intuit’s TSheets acquisition signals that both Xero and QuickBooks intend to push further into the cloud accounting ecosystem, by partnering with, acquiring, or developing integrations that simplify the accounting process and expand their product offering.

Intuit’s TSheets acquisition signals that both Xero and QuickBooks intend to push further into the cloud accounting ecosystem, by partnering with, acquiring, or developing integrations that simplify the accounting process and expand their product offering.

Xero’s latest suite of products

In 2017, Xero introduced a new suite of products — Xero Expenses, Xero Projects, Xero HQ App Suite, Xero HQ Ask, and Xero Discuss — all aimed at providing SMEs with the technology generally reserved for big enterprises, only far cheaper.

Xero already has an app ecosystem of more than 600 certified app partners and 40,000 developers. And since Xero migrated its platform to Amazon Web Services, the subsidiary of Amazon that provides cloud-computing platforms to companies, Xero has been developing its machine learning (ML) and artificial intelligence (AI) capabilities in a push towards completely code-free accounting; in March 2017, Xero released a code-free invoicing and bank transactions feature. (MYOB previously released a similar feature called SmartBills two years earlier.)

Xero has been developing its machine learning (ML) and artificial intelligence (AI) capabilities in a push towards completely code-free accounting.

The company’s chief executive Rod Drury said that the move towards automation “will be bigger than the move to the cloud.” He also said the company was working on a feature that would automate invoices entirely.

What else has Intuit acquired?

On Intuit’s part, it’s Asia Pacific arm of the businesses has made a number of acquisitions over the last few years to beef up its product offering, some of them you might not even be readily aware of — like the 2014 acquisition of Invitco, which created a product called Invitbox that extracts data from PDFs, and operates behind the scenes to extract data from bills and receipts uploaded to the QuickBooks system.

Intuit Asia Pacific also acquired the document management company Fifo in 2013.

Next blog: We look at how the cloud accounting ecosystem has paid off and how and why bookkeepers and others working in the accounting space must continue to up-skill.

***

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

Why Do You Want Xero and MYOB for Free?

If money is an issue there are alternatives when it comes to accounting software programs

WaveApps Transaction journal in the free accounting software competitors to Xero, QuickBooks Online and MYOB with receipt scanning built inWE’RE OFTEN ASKED whether Xero, MYOB and QuickBooks software is provided free with our training courses.

Unfortunately, we’re not given free access to accounting software, so we can’t pass free software access onto our students either. However, we do let you know where you can access trial or student versions while you complete our courses.

It made me wonder: Who’s driving the demand for these programs? It turns out, it’s usually someone’s bookkeeper or accountant recommending them. And this is usually because they’ve done a training course and learnt how to use one or more of the major accounting packages.

Does your bookkeeper or accountant disclose whether they’re earning a commission?

Some bookkeepers take a 15 percent cut of the monthly subscription fee because they’re a certified MYOB / Xero / QuickBooks consultant — and that’s why they recommend a particular package. I personally think that bookkeepers or BAS agents who do this should disclose that they are earning an ongoing commission — just as real estate agents need to make these declarations in their agency agreements.

Businesses don’t know any alternatives  

It also happens that a lot of business owners don’t know about alternative accounting packages. Therefore they simply choose the brand name they’ve heard about the most. I discovered this with real estate agents when it comes to who they choose for their social media marketing services — most of them ask what software or which person Joe Blow uses and then assume it’s good enough for them.

Selecting an accounting package to use is often one of the first things a new business owner does. At this stage, however, they may not even be aware of what they require from an accounting package; never mind what sorts of alternatives they should be looking at. When first starting out, they’re just anxious to be able to invoice and get paid by their first client.

Freshbooks, Zoho, WaveApps alternatives to Xero & QuickBooks Online

Three low cost alternatives to the “three brand names”

Zoho, Freshbooks and Wave are three other accounting packages that are either free or very inexpensive.

These three also include many of the same features you’ll find in the three big name accounting packages — MYOB, Xero and QuickBooks.

Zoho: Free invoicing software allows one user, invoice up to five customers; paid subscriptions from $7 U.S. per month; add extra features (expenses, subscription management, inventory management) as required. Pricing for Zoho Books, the complete accounting package, start at $9 U.S. per month for 2 users, 50 contacts, 5 automated workflows.

Freshbooks: Complete accounting software includes unlimited invoices, accept online and credit card payments, multiple devices, reports, payment reminders, notifications when clients have received, viewed, paid invoices; pricing starts at $15 U.S. per month for 5 active contacts (customers).

Wave: Forever free invoicing and accounting software includes unlimited estimates and invoices, generate reports, scan receipts, bank feeds (accounting package), and more; accept credit card and online payments for a fee (1.75 percent for ever 30 cents AUD); payroll $36 AUD per month.

Consider your business needs first

We recommend either Wave or Zoho for small but growing businesses, looking for a cheap or free accounting solution. Wave, in particular, provides a fairly robust accounting package that’s entirely free, and remains so if you don’t intend to take credit card or online payments (lots of businesses do, but many more don’t). In fact, they even have their own smartphone apps to capture receipts and create invoices while you’re at a clients!

If you anticipate you might want to add other productivity apps, like a CRM, inventory management, IT helpdesk, recruitment tools, or collaborate in a team project, Zoho is a good place to start, as these features can be turned on and off as required.

Of course, these accounting packages are rarely used or recommended by accountants or bookkeepers, who prefer to work with Xero, MYOB or QuickBooks because they provide the functionality needed to complete and lodge activity statements. If you’ll be working with a bookkeeper or accountant, it’s best to stick with one of the brand name three.

***

If you need training in MYOB, Xero and QuickBooks, our online training courses will show you how to set up and use various aspects of the software. More importantly, they will take you through detailed case studies where you can enter all the transactions performed by various different business types eg. professional services, trades and even the sale of inventory products. Visit our website for more information or to enrol.

 

Ref: #715

Posted on

MYOB or WordPress for your new business website?

I recommend WordPress (and our online courses) over MYOB Atlas website builder any day

Is MYOB doing too little of too much?

I recommend WordPress (and our online courses) over MYOB Atlas website builder any dayEvery business needs a web presence, and it’s become a lot cheaper and easier to get one. Where it once could cost many thousands of dollars to have a web designer get your business online, you can now build your own website yourself, quite cheaply.

That’s due to the number of cheap open-source content management systems that have come the market, like WordPress (by far, the market leader), then there is Wix, Squarespace, and even Google Sites (part of Google’s G Suite productivity apps for business). Our online WordPress Training Courses include the basic creating and editing of website pages and blogs posts to more advanced features only available to WordPress Site Admins. 

You might find it interesting that MYOB offers a website service and it makes me wonder whether MYOB has the single focus on building the best accounting software for small business or jumping into any and every new technology it can to see which one sticks.

MYOB is also into websites

About five years ago, MYOB, in partnership with Google, launched a website creation tool called Atlas as part of an initiative called “Getting Business Online.” Atlas enables MYOB customers to create a business website, get a domain name, connect an e-commerce site, and social media platforms for $30 a month. 

Learn about domains, DNS, hosting, Websites and WordPressI put together a series of emails which explains in a logical order how domain names, hosting & websites work…
and it’s free so check it out if you want to learn on that technical stuff!

Because they’ve partnered with Google, the sites promise to “rank well on Google search,” but there’s no flexibility to manage your SEO or integrate with any SEO tools. In fact, for your $30 a month, you don’t get much flexibility at all — not in the choice of themes (they’re limited), adding corporate branding, to connect email marketing services, template changes, and so on.

Carmel Crane ERP Specialist National Bookkeeping_3_comp
Learn more about ERP system from a specialist

MYOB wants to be the ERP platform for small business

Back when the internet was still fairly new, MYOB used to have a partner program in place with hosting companies to help their clients run multi-user programs in the cloud. When MYOB realised they could be earning that money themselves, they shut the program down and did what they have often done — disregarded their partners and their businesses completely. 

MYOB have gained a bit of a reputation for this sort of thing — starting up, and then abandoning, partner programs. Over the years, perhaps due to the complexity of their software, they’ve tried to establish themselves as the enterprise reporting planning (ERP) software of choice for mid-size businesses, but they’ve struggled with already established specialist brands. The MYOB Atlas website creation tool is another example of just that.

The cloud, focus and commitment

 With established platforms like WordPress, which is easy and cheap to use, and highly customisable, this might just be another missed opportunity for MYOB. These website design platforms are built around the concept of open source software and WordPress is surrounded by thousands of theme and plugin developers which provide the integration for some pretty advanced features in an easy to use interface. We made the change to WordPress after going with a Site Builder program which ended up closing down and no longer being supported – it’s a huge waste of energy and resources when you have to start all over again!

Unlike MYOB, Xero realised early that online software is about being a specialist in a given field, so they integrate with lots of different specialist platforms and systems so small businesses can connect the applications they need. I’ll be writing about some of these Xero integrations soon.

Ref:#714

Posted on 1 Comment

Is Xero Better than MYOB for Bookkeeping Businesses?

Bookkeeping Incumbent, MYOB Versus Cloud Innovator, Xero

MYOB or Xero online accounting course training videosMYOB HAS LONG BEEN the preferred accounting software of choice for accountants, but a lot of small business owners have now come to prefer Xero. It’s easier to use, and they can access it anywhere — their desktop PC, tablet or smartphone.

Meanwhile, the rise of cloud-based accounting software, which was pioneered by Xero, has made it a lot easier for bookkeepers to base themselves from home. Throw in other technological innovations — cloud storage, bank feeds — and a remote Xero bookkeeper has become the more appealing choice for businesses, too.

Good bookkeepers have a corporate background

Many experienced bookkeepers (around level three upwards) have a corporate background. They’ve typically worked for big accounting firms, and are possibly qualified accountants or BAS and tax agents, familiar with all the available ERP systems on the market.

As much as they know MYOB as the big robust accounting software for medium-sized businesses, a lot of these ex-corporate bookkeepers are also well aware of how Xero benefits small-to-medium businesses: It’s less confusing to use and it’s cloud based; things that make the bookkeeper’s job easier, too. But there’s no guarantee they’ll recommend Xero purely because of that.

Their experience with a range of different ERPs, makes them just as likely to have a subscription to more than one accounting software so they can recommend, with firsthand knowledge, the right accounting software for your business — be it Xero or QuickBooks or, yes, even MYOB.

Bookkeepers can grow their business

National Bookkeeping - How to Earn More MoneyOf course, one reason Xero has become the preferred accounting software, over MYOB or QuickBooks, for a lot of ex-corporate bookkeepers is because of the Xero partner program which enables them to earn ongoing income by recommending Xero to their clients.

Billed as a way for Xero bookkeepers to grow their business, the program lists certified partners in the Xero Advisor directory, which is used by businesses looking for a Xero-certified bookkeeper to manage their accounts. To become a Xero partner, bookkeepers must successfully complete a Xero skills test. When they do, they’re listed on the directory.

The more Xero clients a bookkeeper brings in under the Xero Partner program, the higher their status and the greater their rewards — free Xero memberships, marketing help, and big discounts on subscriptions for their clients.

It’s incredibly appealing for ex-corporates who want the flexibility of self-employment, but want to grow their business with a client-base of substantial mid-sized businesses — and fast. So the more business a bookkeeper can bring Xero, the more business Xero can bring the bookkeeper. At least, that’s how it’s supposed to go.

Universal access with Xero

But Xero Partner or not, far and away Xero’s popularity is really due to its technology — and its commitment to using technology to improve the way businesses stay compliant with the tax office.

That all started with universal access. Businesses that use Xero can invite anyone in their team — their admin assistant, bookkeeper, accountant, their entire sales team — anytime they like, as part of their Xero subscription. Here are a few more reasons:

  • Invoices can go out as soon as a project is finished or a sale is made; likewise for estimates and customer statements.
  • It also means that a business owner can monitor their cash flow in real time, while their bookkeeper is keying transactions and their sales people are sending off invoices.
  • And because the software is in the cloud, these people don’t even need to be in the same building, never mind the same city, state or country! (Xero is the rare low-cost accounting program that supports multi-currency.)

It’s all about the Xero tech

Xero also integrates with more than 500 third-party apps. Some popular integrations include Gmail and Hubspot, the marketing and sales platform. These two integrations alone turn Xero into a complete business management platform and enable it to scale up to the services provided by mid to large sized ERP systems.

Businesses can import data to Hubspot based on customer spend or products and services sold, and send those customers tailored marketing messages. The Gmail integration gives users a complete snapshot of previous conversations with customers — salespeople can see if there are outstanding invoices, or problems with a customer’s account, for example.

Gold standard in bank feeds

Although bank feeds are accurate most of the time, they’re not perfect. MYOB has been know to be particularly temperamental, but Xero has a reliable bank feeds function. Again, that’s a lot to do with Xero’s commitment to tech. 

Setting up bank feeds in any accounting software is as simple as clicking a few buttons, giving a few permissions, and voila! Your bookkeeper has just saved themselves hours each month. Bookkeepers much rather spend as little time as they can keying and coding transactions.

[box type=”info”] This time is better spent doing bigger jobs — lodging activity statements, reporting, payroll — so they’re going to recommend an accounting program with bank feeds.[/box]

Plus, business owners won’t have to wait for their bookkeeper to enter their transaction data each fortnight or month to see how their cash flow is tracking: Bank feeds give business owners a complete picture of their business’s cash flow and financial health because transactions are imported in real-time.

Xero courses provide Bookkeeper CPD points

EzyLearn Online Course CPD points for bookkeepers and marketing professionalsEzyLearn gets lots of enrolments in our Xero training courses and we’re an accredited training provider with the Institute of Certified Bookkeepers. The ICB requires its bookkeepers to continue developing their skills and knowledge as a bookkeeper in order to retain their membership (this is known as continuing professional development, or CPD).

Many bookkeepers and accountants do EzyLearn’s Xero courses to earn their annual CPD points. EzyLearn offers a number of different training courses as continuing professional development (CPD) for bookkeepers, including our Microsoft Excel, Xero or MYOB training courses.

Our Bookkeeping Academy training courses start at $99 — for Xero or MYOB — and allow you to learn what you want, when you want, entirely at your own pace. Visit the Bookkeeping Academy website for more information or to enrol.


 

Posted on

Accounting Software or ERP System?

enterprise resource planning systems learn myob xero quickbooks online training course videos

Are you BIG enough yet?

I’VE BEEN IN BUSINESS since my early twenties but it wasn’t until my late twenties that I had any clue about how larger companies use and pay for software. I was going through the process of selling a water filter business that I’d been operating in Sydney’s Dee Why when I had the pleasure of meeting the owner of Fountainhead Water Company, Mark Darling.

Fountainhead used a specialised accounting system for the bottled water business which did everything from receipts for each delivery to capturing bottle deposits, tracking rental coolers and more — and they were paying hundreds of dollars per month for this software. It was a far cry from purchasing the MYOB software for a couple hundred dollars and NEVER upgrading (no payroll at the time).

Now I understand the importance of Enterprise Resource Planning (ERP) systems and how they are almost sewn into the fabric of the procedures for medium to large businesses. I was contacted by someone at Sage, asking if EzyLearn had ever thought about offering training in Sage One, their software for their smaller clients. I replied by saying: “Yes, but what is the demand?” I never heard back from this person (might be a good tactic for you if you get too many cold calls!)

SAP one can cost you $600 per month so don't complain about $70 per month for Xero

Getting Setup Using an ERP System

This Sage person piqued my interest so I did a bit of research.

I soon realised that these ERP systems are sold almost exclusively through ‘integrators’ or channel partners who visit your business and really get into the nitty and gritty of the procedures and processes.

They perform their analysis and then set about a plan to implement the new software in the business using deft project management and people skills to CHANGE the way the business works.

These ERP system integrators get very involved in the operations of these larger companies and they get to see the BIG mistakes that small businesses make when dealing with them and know how easy these problems are to fix.

One such person is Carmel Crane, Finance Manager and ERP Specialist at National Bookkeeping, with specialist knowledge of midsize businesses in the mining and related industries. Carmel points out that tier one ERPs, such as SAP, JDE and Oracle are “large, expensive and all-encompassing software systems that tend to be implemented by large, multi-currency organisations.”

In a way, even small business software programs like MYOB, Xero, QuickBooks are ERPs but no one really uses that term and the process of getting set up is often much less formal and done by a high-level bookkeeper like a Finance Manager or accountant. 

The most interesting aspect of my research was when I came to the site of Leverage Technologies and found their sign up form for Sage One. I thought back to those days of working with Mark Darling, but more importantly, how true ERP systems don’t just do invoicing and payments but manage:

  • job costing
  • distribution
  • e-commerce — and even —
  • CRM.

These are services that “integrate” with software like Xero and Quickbooks.

What are tier one and two ERPs?

When you start delving deeper into ERP’s you realise there are different tiers of software which depend on the size of the company using them. Tier one ERPs are relatively inexpensive but fairly flexible applications that enable small businesses to manage their accounting and operational needs. But larger midsize businesses will have different needs that will exceed the capabilities of a tier three software like MYOB or Xero.

“Tier two is aimed at mid- to -large companies — I have a lot of mining companies in this space,” she tells EzyLearn, “and would include [software such as] Pronto, Sage and Green Trees.”

“This software has more modules than tier three, but it’s not as complex as tier one. Tier three is for small businesses, [and they] focus on the accounting side of business with simple relationships across modules.”

Tier three software is for small business and focuses on the accounting side of business.”

— Carmel Crane, ERP Specialist, National Bookkeeping

How to know if you need a tier one or two ERP? 

Any midsize business — so if you’re running a mining company, a substantial wholesale business or manufacturing or retail business — would need to work with at least a tier two ERP. And for the implementation of a tier two ERP like Sage or Pronto, Carmel strongly suggests engaging the services of an ERP specialist rather than just seeking input from the ERP company. 

“An ERP specialist understands the relationship between the modules,” Carmel says. “They can direct you in how purchasing will affect inventory and how plant maintenance will affect asset values — there is a holistic view of transactions.”

“And they know that when a problem occurs, a simple fix may just cause further error down the track. It’s important to understand the big picture.” Carmel Crane, ERP Specialist

Selecting the right ERP for your business

Just as small businesses would select a tier three ERP based on their requirements and the cost of the system, businesses selecting a tier one or two ERP do the same.

“The software is selected based on requirements, scope and cost,” Carmel notes. “Coca Cola are likely to run SAP or JDE, whereas a local operation with branches across Australia is more likely to go with Pronto or Sage.”

But she adds: “That said, just to contradict myself, I spoke with a company last week that had received an implementation quote from JDE for $1.8 million, and when I asked Pronto for the same requirements, they came back with a ballpark of $1.6 million. However, the quotes were for 30 licenses; most mid-range businesses will only use 10-15 licenses, so it would cost less.”

***

To select the right ERP — and for the right price! — engage an ERP specialist. Their knowledge of how various elements of your business operations — inventory or machinery maintenance — will affect your business, combined with their in-depth knowledge of ERP systems make them an invaluable resource.

Carmel Crane ERP Specialist National Bookkeeping_3_comp

How to find an ERP Specialist

Carmel Crane specialises in ERP systems for businesses in the mining and related sectors. Her knowledge of Xero & MYOB enables smaller businesses to get set up and systemised so they are better equipped to deal with larger clients.

She is also available for face to face training in Xero & MYOB.

As a Finance Manager, she works with businesses in the Atherton Tablelands, Cairns, Chillagoe to Charter Towers regions, Dalby through to Dubbo (including Broken Hill, Cobar and surrounds), and the Riverina, Wagga Wagga and Wyalong areas.

Carmel is looking to expand her list of clients in these and surrounding areas. If your business is in need of an experienced finance manager for managing Xero or MYOB or even a mid sized business looking for an ERP specialist, you can contact Carmel through the National Bookkeeping website.


 

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

Why are there More Expense Tracking Apps for Xero than MYOB?

Less complicated accounting software, like Xero, connects better with mobile apps

accounting-apps-that-link-with-xero-and-quickbooks
The robust nature of MYOB can make it harder to link with mobile apps that track your expenses and cash flow and the like.

WE RECENTLY PUBLISHED A blog examining the different expense tracking apps you can connect with Xero, MYOB and QuickBooks, but during our research it became clear that most expense apps integrate with Xero or QuickBooks, but not MYOB.

That’s not to say there are no expense apps that integrate with MYOB. There are. Receipt Bank is one, Squirrel Street is another, and there are probably a lot more on the MYOB marketplace (or add-ons page). Probably the best expense tracking application we found is ExpenseManager, and it only integrates with MYOB.

MYOB is a robust, yet complicated system

As anyone who’s ever used MYOB can attest, it’s a complicated piece of software to navigate, even if it is a robust one. When Xero came along, it aimed to be both robust and easy-to-use, and for the most part it succeeded (it’s probably not as easy as QuickBooks, but then QuickBooks isn’t quite as robust).

Behind the scenes, there’s also a lot of complicated code driving MYOB that’s not easy to integrate with, unlike QuickBooks and Xero which rely on third-party integrations to deliver payroll and other services, so Xero and QuickBooks can keep the cost of their platforms down.

MYOB is used by accountants and bookkeepers

MYOB doesn’t really go after to same market that Xero and QuickBooks do (small and micro businesses), which is reflected in MYOB’s price. It’s aimed at medium sized businesses, which employ accountants and bookkeepers, and that’s not really the market expense apps like Expensify and Xpenditure are targeting.

Xero is one of our most popular training courses

That’s why Xero has become one of our most popular training courses. It’s robust and once you understand the principles of bookkeeping, fairly easy to use. And it integrates with a tonne of third party applications developed to make the life of the small business owner much easier and more efficient.

Keep an eagle eye on your expenses by using Xero and an expense app, and you’ll be able to see precisely where your business is the most profitable and where it’s not, so you can modify it accordingly.

***

Our Xero training courses will show you have to track expenses in Xero and how to connect third party apps to your Xero account. You can also brush up your MYOB skills or learn how to use MYOB with our MYOB online training course, incorporating 5 courses and 12 months’ access — all for one low cost. Visit our website for more information covering our ONE LOW COST for ALL LEVELS course options.


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

Top 3 Expense Applications for Xero, QuickBooks and MYOB

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

Xpenditure (QuickBooks, Xero, Fresh Books)

It’s a little more expensive than Expensify, but you also get a little more bang for your buck. From around $4 a month, you can scan 200 receipts per month, plus all of Xpenditure’s core features, such as expense rules, real time reporting, accounting integration, and mileage tracking. Speaking of which, Xpenditure tracks your mileage using Google Maps, which as discussed previously, isn’t the the most accurate way to do it.

However, it does calculate the estimated cost of each trip using the current “mileage rate” — or kilometre rate for Australians — set by the Tax Office. It’s mobile app, however, only has an average 1 star rating in the Australian Apple App Store, while it’s currently rates at 3.5 stars in the Google Play store, so it appears it’s best served on an Android platform.

Abacus (Xero, QuickBooks)

At $9 a month for up to 50 users, it’s on the pricier side for small businesses. And although Abacus lets you give your accountant or tax agent free access to your Expensify account, it doesn’t really make up for the higher price tag (we happen to think the point of an expense app is that you only need to give your accountant or tax agent access to your accounting software).

Yes, it includes all the standard features, such as receipt scanning, real time reporting, multi-level approval workflows, and automatic approvals — plus, an EzyLearn favourite: automatic direct deposits for reimbursing employees once an expense is approved — but features like mileage tracking are absent. It’s rated 4 stars on the Google Play app store, but unrated in the Apple App Store.

Squirrel Street (Xero, QuickBooks, MYOB)

Formerly known as Shoeboxed (they explain name change on their website), Squirrel Street is a rather expensive way to track your expenses and store your receipts. Plans start at $26.95 a month for 50 receipt uploads and 2-5 day turnaround, which explains the steep price: This is a software application that relies on manual labour, rather than machine learning, to import expense data. As a consequence, there’s no other features of note — no real time reporting, no expense reports, no automatic approvals.

There is also a “forever free” five document per month DIY plan available. Of course, they are an Australian owned and operated business, but it’s still not the best service for your dollar. It’s rated 4 stars on the Apple App Store and 4.5 stars on Google Play.

By keeping an eagle eye on your expenses using an expense app that integrates with your cloud accounting software, you’ll be able to see precisely where your business is most profitable and where it’s not so you can modify it accordingly.

***

Our online courses in Xero, MYOB and Quickbooks will show you how to track expenses and connect third party apps to your account. Read more about cloud accounting.


learn to use excel online training course videos cheap best

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!


 

Posted on

Paying Several Employees With One Payroll Payment

MYOB and Xero now make payroll easier to manage

myob and xero online payroll management
Struggling to manage your online payroll management? Our Xero and MYOB courses will help you get the most out of this software so you can manage payroll in house.

MANY COMPANIES OUTSOURCE PAYROLL because it contains many moving parts. For instance, there’s the payment of wages each week or fortnight or month, sure. But there’s also superannuation contributions, PAYG obligations, annual and sick leave accrual. 

Fortunately, most accounting apps like Xero and MYOB have made payroll easier to manage, particularly if you only have a handful of employees.

Superannuation clearing houses

Nearly every major cloud accounting package has a connected superannuation clearing house within its payroll package. Xero and MYOB are both SuperStream compliant, a government initiative to help business owners tell which accounting software apps will let them make electronic superannuation payments. And QuickBooks uses a partner payroll system which is also SuperStream compliant.

Batch wage payments

Electronic superannuation payments are one way that paying staff is made easier, but paying a dozen or so employees individually each week or fortnight can be tedious. Fortunately, both Xero and MYOB have a ‘pay run’ function that lets you make batch wage payments. This eliminates the tedium of paying employees individually, as well as the potential for error.

Accounting software calculates entitlements

MYOB, Xero and QuickBooks, if you’ve set up your employees correctly and have the appropriate payroll subscription, will also calculate your employees’ sick and annual leave entitlements, also reducing the time it takes to process payroll and the potential for error.

Our MYOB training courses and our Xero training courses both cover payroll, where you’ll learn how to set up employees correctly, process wage payments and more. Using a cloud accounting program for payroll, saves time and reduces errors. Visit our website for more information.

EzyLearn courses now include real life case studies

managing ad hoc payrollAt EzyLearn we are constantly refreshing the content of our online training courses. Relevant to those of you doing Payroll, might be our Excel Ad Hoc Payroll case study which is part of our Intermediate Excel Online Training Courses. Where possible, we draw on real-life case studies as examples, to help you learn, and apply your skills, in a relevant way that makes sense. Visit our Micro Courses page to learn more.


 

Posted on

EOFY: Remember to Deduct Your Prepaid Expenses

The Cut-Off for Claiming Deductions is Looming

reduce-your-taxable-income-with-expenses-Xero-and-MYOB
Dive deep into your claimable expenses and don’t forget all those smaller prepaid expenses like magazine subscriptions or domain name registrations – you can only claim all of these during the period in which they occurred.

WE’RE IN THE LAST QUARTER of the 2016/17 financial year, so now is the time to dive in deep and check you’ve included every single business expense — prepaid or otherwise — to ensure all your expenses are in order.

We’ve previously posted about writing off stock and inventory and the reports you’ll need to file your activity statements and tax returns: all of these you’ll learn how to run in our MYOB BAS Reporting and GST online training course or our Xero GST, Reporting and BAS training course.

Expenses reduce your taxable income

We all know this, but remember, they can only be claimed for the period in which they occurred. If you forget to claim a major business expense in the financial year that it occurred, you can’t make it up by claiming it the next year.

It’s really important you thoroughly check your credit cards and business accounts to make sure you’ve accounted for each expense. The final quarter of the financial year is also a good time to make any purchases for your business, because you can claim them straight away.  

Prepaid expenses are often forgotten

what are some claimable expensesMagazine or journal subscriptions, domain name registrations, business name registrations, car registrations, website fees, insurances — collectively they add up, but they’re also the easiest to forget.

These deductions are often prepaid and may not come up on your radar and may certainly not show up on your final quarter bank statements.

Make a list and check it twice

Over the next month or so, make a list of all of your expenses as you think of them. This makes it easy to spot them when you’re going through your bank and credit card statements and checking them against the expenses in your accounting software.

***

Learn how to run the reports you’ll need for EOFY with our MYOB BAS Reporting and GST online training course or our Xero GST, Reporting and BAS training course.


learn PowerPoint online training course

Want to make your business presentations and publications more eye catching? 

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 inductionFind out more about our 2016 version PowerPoint courses


 

Posted on 2 Comments

EOFY: Get Your Business Expenses In Order

bookkeepers fixed price quotes

We Show You 2 Steps You Can Take — Right Away!

WE’VE ENTERED QUARTER 4 for the 2016/17 financial year, so we’ve been writing about the things your business should be doing this quarter in preparation for the end of the financial year. In our last post we wrote about writing off stock and inventory. Now we’re looking at business expenses.

Our MYOB BAS Reporting and GST online training course or our Xero GST, Reporting and BAS training course will show take you through the necessary steps in your accounting software. 

Here’s what you can do now to make sure you’re prepared come tax time? Continue reading EOFY: Get Your Business Expenses In Order

Posted on 1 Comment

End of Financial Year: Writing Off Stock

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

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

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

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

Understanding your inventory’s performance

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

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

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

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

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

Inventory reporting

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

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

Stock write offs and future orders

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

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

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

Act NOW for EOFY

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

***

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


find a local bookkeeper

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


 

Posted on 4 Comments

Basic Bookkeeping Reports in Xero: Profit and Loss

Learn How to Run a P&L Using Xero

Profit and Loss statement
Profit and loss statements should be run by businesses regularly and are required by law.

A basic, yet vitally important, report for every business owner is a profit and loss (P&L) statement. A profit and loss statement, as the name suggests, shows whether a business is running at a profit or a loss over a given period. We’ve written about why running multi-period P&Ls before in QuickBooks and MYOB is a good idea for businesses with inventory, but single period P&Ls are equally important for all businesses.

If you’re a bookkeeping newbie, a profit and loss statement, which sometimes goes by other names — income statements, earning statements, revenue statements, operating statements, statement of operations, or statement of financial performance — is a basic report you’ll learn to run in our Xero Daily Reconciliations Course. If you’re planning to work as a contract bookkeeper, you should get in the habit of running P&L statements for your clients regularly (if you’re a business owner, ask your bookkeeper to run them).

P&Ls are required by law

Depending on how a business is structured, it may be required by law to complete a P&L. A P&L shows how the revenue of the business is turned into net income by subtracting all expenses from income. They’re also useful for understanding a business’ net income, which helps with the decision making processes. A business will also need a P&L if they’re applying for a small business loan.

The contents of a P&L

profit and loss statements P&LsAlthough the process of running a P&L differ between accounting software packages, they usually all contain the same elements, depending only on the business itself. In the first section, the cost of sales is subtracted from the revenue, which highlights gross profit. The business’ operating expenses are then subtracted from the gross profit, which leaves the operating profit. Now, all of the non-operating revenues and expenses must be factored into account, after which the business’ profit or loss will be displayed.

***

Because P&L statements are often used by a business’ owner to make financial decisions, to inform shareholders of the business’ performance, apply for a business loan, or as proof of income in the sale of a business, it’s important that you understand how to create one correctly. Our Xero Daily Reconciliations Training Course covers P&L statements, and much more. Visit our website to learn more or to enrol.

***

online bookkeeping courses to earn cpd points

 

Did you know that EzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants?We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.

 

 

 

 

Posted on 1 Comment

Calculating PAYG Obligations Without a Payroll System

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

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

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

PAYG and the businesses it applies to

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

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

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

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

Superannuation contributions

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

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

Using tax tables to calculate wages

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

***

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

***

online bookkeeping courses to earn cpd points

 

EzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants. We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.

 

 

 

 

 

Posted on 1 Comment

How and What Kind of Receipts Do You Need to Keep?

Xero course online receipt keeping

Online Receipt Keeping is the Way to Go

A HUGE PART of reconciling your bank account involves coding business expenses or purchases. You then need to keep a record of those expenses in the event you’re ever audited.

Our Xero Bank Reconciliations and Journal Entries Course covers how to code an expense or purchase in Xero, and it’s important to also store your receipts and get them to your bookkeeper if they’re working remotely.

Many people have used Dropbox to capture images of receipts but there are even better ways. Continue reading How and What Kind of Receipts Do You Need to Keep?