Posted on

Reporting in QuickBooks Just Got a Whole Lot Better!

running cashflow reports in xero and exporting to excel

Quickbooks now providing superior options for filtering and scheduling bookkeeping reports

Xero online training course bank feedsONE OF THE BEST THINGS about cloud accounting software is that your data is live, which means, providing your reconciliations are up-to-date, you get a complete snapshot your business’s performance and financial health regardless of the day, week or month you run those reports.

Running regular finance reports is the key to ensuring your business maintains a healthy cashflow, which is also linked to your credit management process and procedures. Previously, the main gripe many bookkeepers and business owners had about QuickBooks was that it lacked the reporting functionality of other apps, like Xero and MYOB.

That’s all changed now that the reporting features in QuickBooks have been given a major upgrade, giving business owners more power and flexibility to monitor their business’s performance. Here are just a couple of the things you can — and should! — do with the updated reports feature in QuickBooks.

Filter sales by services / products

If you’re like a lot of businesses, you probably offer a couple of different products or services, and, like a lot of businesses, there are certain products or services that are more profitable to your business — and, therefore, should be a major focus — to sell.

Now that QuickBooks offers the ability to customise and save any of its reports into your management reports tab, you can filter your customer sales reports by services or products, and also run them across multiple periods. If you have multiple sales people, you can also filter your reports by sales people, too.

Schedule email reports

In addition to being able to customise and save your management reports, so you don’t have to keep filtering out the data you don’t need and adding in the stuff you do, you can also setup a schedule so your preferred reports are automatically emailed to you (and your business partners or other stakeholders) as required.

QuickBooks gives you the option to select which reports you’d like to see, and the frequency at which you’d like them — daily, weekly, monthly, twice a month, or custom. This’ll mean you won’t have to keep asking your bookkeeper to run them for you, nor will you need to go in to run them manually yourself. It’ll also give you a better idea of whether or not your bookkeeper is really paying close attention or not!

Familiarise yourself with customisation options

Here at EzyLearn, we believe Quickbooks has a lot to offer small business and bookkeepers alike. The reporting functions in QuickBooks now offer up seemingly unending possibilities by giving you the flexibility to filter and  customise your reports by any number of variables — sales person, periods, services, etc. Sometimes you don’t know the kinds of reports you need for your business until your go in and have a play yourself, so that’s exactly what you should do.

Maybe you haven’t taken a good look at the capabilities of Quickbooks for a long time — check out the options available with our Quickbooks online training courses to take you up to speed. Alternatively, you can ask your bookkeeper, and they should be able to customise, save and schedule a report that suits your needs to a tee.


What Do You Want to Learn Today?

running cashflow reports in xero and exporting to excel

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, real estate and investment management courses, to marketing and sales courses, or update and further your skills in a range of Microsoft Office programs, (including Excel, PowerPointWord) or social media and WordPress web design). 


 

 

Posted on

A Close-Up Look at a Listed Company and How it’s Performing

We show you what financial data really reveals

how to read financial reports
There’s more to profit and loss than meets the eye: Sometimes a company’s losses outweigh its revenue, but it doesn’t mean that company is in a bad position.

AS A BUSINESS OWNER you’ll need to run regular financial reports (never more so than at the end of financial year) to ensure your business is in good shape. Understanding what each element of a financial report means is critical to your business’s financial health.

You’ll learn to run and interpret financial reports in our Xero, MYOB and Quickbooks training courses, but we’re just going to look at a couple of areas of most importance.

Close up: BuyMyPlace’s financial results

BuyMyPlace is an ASX-listed service that allows property owners to sell their properties without a real estate agent. Because it’s a publicly-listed company, they have to make all of their financials public too.

As such, we got hold of their most recent financial results for the first half of financial year 16/17.

It’s not the most detailed financial report, probably because the company itself is still in its early stages — there’s actually a good argument against early stage ventures listing on the stock exchange, but that’s fodder for another post.

Revenue vs. losses for the period

The good news for BuyMyPlace is that its revenue increased 129 percent on the prior comparative period (PCP) to $1 million for H1 FY16/17, up from $133,518 in H1 FY15/16.

That’s an impressive leap in revenues in just 12 months, however, the BuyMyPlace financial results also reveal that the business made an even greater loss of $1.7 million, an increase of 1205 percent on the PCP.

A closer look at the report shows that, while the losses increased more than a thousand percent, it was due to an increased investment in marketing and advertising — principally on TV spots which totalled $517,723 compared with $98,578 the year prior.

This resulted in an 80 percent increase in the number of listings on the site (that is, the number of people using BuyMyPlace to sell their home), while order value increased 27 percent (people who were choosing more expensive packages).

BuyMyPlace is in good health

Although this business recorded losses that outweighed its revenue, BuyMyPlace is still in good financial health.

The report also shows that it has over $4 million in cash and cash equivalents, and only a little over $600,000 in liabilities. Although the liabilities have increased, it’s not due to taking on any additional debt — indeed, BuyMyPlace has paid down all of its loans — but was instead due to a 786 percent increase in staff salaries and, as a consequence, an increase in staff provisions and benefits — i.e., sick and annual leave.

Strategy for future growth

Not many homeowners actually want to sell their properties themselves — one estimate puts it at around 7 percent of the total number of homeowners. However, most people do want greater clarity around how the process works (including fees and commissions) — even if they still want assistance selling their homes.

Perhaps realising this, or perhaps in response to increased competition in the fixed-fee real estate services (see: Purplebricks, Settl, etc), BuyMyPlace also launched its own full service package, giving homeowners access to a real estate agent to sell their home for a fixed fee.

This will enable BuyMyPlace to capture a greater volume of homeowners, who are looking for a low cost alternative to sell their homes, but who don’t want to do it entirely themselves.

The other strategy for growth: increasing listing depth revenues.

At some point, BuyMyPlace will stop growing its market share. Or, in other words, the market of people looking for a low-cost option to sell their home will be tapped out.

But as a business, and as a publicly listed one, BuyMyPlace will need to keep growing its revenue, not merely keep it steady. It’ll need to do as other real estate services, such as REA Group and Domain have done, and increase listing revenue depths, by selling more expensive packages to customers.  

BuyMyPlace will need to find additional value it can sell to customers, without necessarily increasing its own expenses to do so — or putting up its prices, which a business can usually only do once it’s cornered about 65 percent of the market, and BuyMyPlace is a long way off that yet.

***

That’s a lesson for every business owner out there. And it’s something we cover in our online Business StartUp Course.

You’ll learn how to run and understand the financial reports for your business in our Xero and MYOB training courses. You can also learn about strategies for business growth in our Business StartUp Course. Or for more information, visit our website.


learn to use excel online training course videos cheap best

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