Bookkeepers Need to Know All Cloud-Accounting Systems

GONE ARE THE DAYS when a bookkeeper only needed to know their way around MYOB. Since the internet democratised the accounting software market, abundant MYOB rivals have appeared.

But while there are close to a dozen cloud accounting systems on the market, most bookkeepers — thankfully — will only need to know their way around three: Xero, MYOB and QuickBooks. If you’re looking for a course or training resource on these programs we have a combo offer.

Continue reading Bookkeepers Need to Know All Cloud-Accounting Systems

Bookkeeping Basics: Payroll and Paying People

EOFY is nearly here — can you manage payroll?

woman studying myob payroll xero payroll quickbooks payroll online training courseIN OUR FREE, EDUCATIONAL GUIDE, Bookkeeping Basics, we feature a section that briefly discusses payroll, which we thought was worthy of being expanded upon on here. You might also like to go back and revisit our other blog post that complements the guide, Bookkeeping Basics: Cash vs. Accrual Systems, if you haven’t already.

Paying your employees

Before you employ staff, you need to determine how they will be employed. Are you going to use casual or permanent employees? If you’re employing the latter, will they be employed on a full-time or part-time basis? As the business owner and employer, you must also ensure that you’re paying your staff the correct rate of pay, as well as any entitlements — such as, sick leave, annual leave, overtime, etc — that may be owed to them.

This blog post isn’t going to go into the intricacies of how to work out what you should pay your employees, nor will the Bookkeeping Basics guide, as it generally falls outside the scope of the role of a bookkeeper, however, you can use the Fair Work Ombudsman’s (FWO) Pay Calculator to work out the following:

  • Base pay rates
  • Allowances
  • Overtime and penalty rates
  • Pay rates per hour
  • Pay rates per shift
  • An employee’s employment status (i.e., full time, part time, casual).

Record keeping

If you employ staff under a modern award or agreement (virtually all Australian businesses do), you have a legal requirement to keep accurate and correct time and wage records, in addition to issuing payslips to all of your staff — failure to issue pay slips incurs harsh penalties if it comes to the attention of the Fair Work Ombudsman. You must also keep your each staff member’s time and wage records for, at least, seven years and make sure they’re stored somewhere that’s always accessible, should they ever need to be inspected.

Although you don’t have to keep all employee records, it’s best practice to keep the following records for seven years, even after the employee has left the business, in case they ever file a complaint with the Ombudsman or the Tax Office ever does an audit:

  • Employee resume and application details
  • Employee workplace performance records
  • Employee trade certificates or registration certificates.

For tax purposes, all employee and contractor records must be kept for five years, but most businesses keep them for seven years, in case an enquiry is made by the FWO.

Deducting tax from an employee’s pay

Under the Pay As You Go (PAYG) withholding rules, you are legally obliged to collect tax from employee payments so they can meet their end-of-year tax liabilities. In order to do so, you must first register with the ATO for PAYG withholding, which you can do online, over the phone or through your BAS or tax agent.

You must also provide your employees with a tax file declaration form, which you can also obtain from the ATO, and must be completed by an employee if they want to:

  • Claim an entitlement to tax offsets by having a reduced amount withheld from payments made to them
  • Advise you of changes to their:
    • tax-free threshold
    • residency status
    • HELP, Trade Support Loan or Financial Supplement debt.

You must then determine how much to withhold your employee’s pay, which you can do by referring to the ATO’s Tax Tables or the Tax Withheld Calculator.

If you have staff that are under 18 years of age

You do not have to withhold amounts from payments to employees under 18 years of age if those amounts are not more than:

  • $350 per week
  • $700 per fortnight
  • $1,517 per month.

Employees with HELP, TSL or Financial Supplement debts

If an employee has indicated they have a HELP, TSL or Financial Supplement debt, you should use the HELP/TSL or Student Financial Supplement Scheme tax table on the ATO website to work out how much extra to withhold for these debts. Add this to the amount withheld shown in the relevant tax table.

Your superannuation obligations

As an employer, you also have an obligation to make super contributions for each of your employees. You must also ensure that you:

  • Offer eligible employees a choice of super fund (temporary residents are eligible to choose)
  • Pay the minimum amount, called the super guarantee (SG), which is currently 9.5 per cent of ordinary time earnings
  • Make your super contributions on the required dates as set by the ATO.

If you don’t pay the super guarantee for your employees, you will have to pay the super guarantee charge, which is not tax deductible.

Which employees are eligible for the SG?

Generally speaking, all employees are eligible if they are paid $450 or more (before tax) in any calendar month. You must pay super for all employees who:

  • Are full-time, part-time or casual
  • Receive a super pension or annuity while still working — including those who qualify for the transition-to-retirement measure
  • Are a temporary resident — when they leave Australia, they can claim the payments you made through a ‘departing Australia superannuation payment’
  • Are a company director
  • Are a family member working in your business — provided they are eligible for SG
  • Are over 70 years of age
  • Some contractors, even if they quote an ABN — visit the FWO website for more information.

Final things to consider

Not all bookkeepers offer payroll services, because it can be time consuming and it’s always in flux (new software enters the fray, employees come and go, and each time that occurs, it results in more work). Additionally, the minimum wage is regularly reviewed and increased, which is something that needs to be monitored to ensure your employees continue to be paid correctly. If you decide to hire a bookkeeper to manage your accounting, and you’d also like them to handle your payroll, be sure to clarify how they’ll bill for payroll services and what your obligations are to ensure you’re not paying too much.

We provide online training courses in Payroll for MYOB, Xero Payroll and Quickbooks. Find out more about our industry-endorsed online training courses and videos.

***  ***  ***

Need help managing your bookkeeping system?

the perfect administrative executive assistant office manager learn online courses trainingIf you’re looking for a reliable bookkeeper to manage your bookkeeping system, who also specialises in payroll services, is highly qualified, or even a registered BAS agent?

See our bookkeeping directory, National Bookkeeping, for more information on the hundreds of bookkeepers listed who are available to work all around Australia. 


Remember, you can download our educational guide, Bookkeeping Basics, for free from the EzyLearn website.


Online bookkeeping accounting training courses for CPD points

Find out more about Continuing Professional Development with EzyLearn


 

 

 

 

Xero Training Course May 2018 UPDATE

Cloud Accounting Software is CONSTANTLY Updated – SO IS OUR XERO COURSE

Xero Product Releases, LIFELONG Learning, LIFETIME Course access, Updates, best Xero Training CourseWhen I made the decision to convert EzyLearn from a Bricks and Mortar training centre to an online only provider of training courses I realised that we were going to have to get good at:

  • online digital marketing,
  • online pre-sales and student support, and
  • course content creation.

EzyLearn has been in business helping job seekers, business owners, managers and clients of rehabilitation providers learn how to use software for over 20 years. Read our story here..

I’m lucky today to have a professional team who’s sole focus is on getting better at all of these tasks – every week! I guess this post is as much a thank you to all of them for their help as it is an announcement that ALL of our XERO courses have recently been updated!

Beginners Xero Payroll Administration Training Course to Advanced Xero Payroll online course dashboardBeginners and Advanced Xero Training Course updates

Almost every course has been touched in our latest updates but here is a summary:

One reason that students choose EzyLearn for their online training courses is because they receive access to new added content and course updates.

Available to New, Current Students and LIFELONG Students

The usual time to finish the COMPLETE set of Beginners to Advanced Xero Courses is 3 weeks but one of the reasons we offer 12 months course access (and the LIFETIME Xero Course Access) is so that students can go back and review the contents when they need it in their business or job.

EzyLearn Discount Voucher Coupons online training for Office, Excel, Xero, MYOB, Marketing courses 2Get all the Xero Course details at our FAQ’s.

Current Discounts for Xero Training Courses

If you’re interested in enrolling into a Xero course take a look at the current special offers and subscribe to our Discount Voucher program to receive the discount codes.

Profitable Businesses Suffer Poor Cashflow

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

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

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

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

Cashflow is the true indicator of success

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

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

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

P&L reports help determine causes of poor cashflow

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

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

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

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

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

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

Bookkeeper, BAS Agent or Finance Manager

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

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

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

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

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


 

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

How does Xero stack up in the cloud accounting game?

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

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

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

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

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

Missing a dropdown menu

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

Xero’s contact profile misses a beat

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

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

It’s easy to file bills, though

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

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

***

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


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

learn to use excel online training course videos cheap best

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

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. 


 

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!


 

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.

The OpenAgent example

Take OpenAgent. A core function of OpenAgent, the real estate agent comparison site and lead generator, is its customer reviews, which serve two purposes:

  • The first is to help consumers to make an informed decision when selecting a real estate agent
  • And the second is to recommend top rated real estate agents to new OpenAgent customers.

True and and real ratings and reviews for businesses, whether they’re real estate agents on the OpenAgent site or reviews for OpenAgent itself on third party review sites, are important, because they’re the basis for which many consumers make their decisions.

Check reviewers are real people

So how do you know which ratings and reviews you see online are true, and which ones aren’t? It’s something companies like Google and Amazon and TripAdvisor have had to grapple with, because there are ways that companies can game them.

Lots of review sites don’t allow anonymous reviews or reviews that are left by people who don’t verify their identity by signing in with their Gmail or Facebook account. The theory goes that people are less likely to leave false reviews if they’re using their own name, and can be easily identified.

You can test this further by checking how many reviews, and the kinds of reviews, certain individuals leave on sites such as Yelp and TripAdvisor.

If the same person shows up multiple times leaving only positive or only negative reviews for lots of different businesses, there’s a good chance this person isn’t real or they’re being paid to leave these reviews.

Likewise, a good test is to see how long the account has been active for. If it’s only recently been set up to give glowing (or negative) reviews to a new business, it’s likely there’s an ulterior motive at play.

Negative feedback is responded to

Not every business will be able to satisfy every customer or do everything right 100 percent of the time. But the businesses that make an effort to respond to negative reviews and criticisms, prove they’re committed to delivering the best possible service to all their customers, and also help show some reviewers for what they really are: baseless complaints or fakes.   

Also keep your eyes peeled for the language used in reviews on businesses websites. If all the reviews say mostly the same thing, mostly the same way, they’re more than likely not legitimate.

Reviews with full names and locations

We believe there’s many reasons you can trust the reviews provided at EzyLearn. All of our student testimonials 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 can trust they’re making the right choice. 

***

Looking to brush up your skills in cloud accounting software? Looking to progress to intermediate or advanced levels in MYOB, Microsoft Excel, Xero or another accounting package? Need help with social media? Take a look at our wide range of online course options


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.


 

Buying Real Estate For Your Business

The pros of buying a business property

xero reports to buy or sell business industrial unit business investment
Buying a premises for your business need not be cost prohibitive and you may enjoy good equity growth.

IN OUR NEW CASH FLOW reporting, Budgets and ROI course for Xero, we delve into the purchase of real estate for your business, which you may use as office space or as a warehouse or as a storage facility and workshop, depending on your line of work.

Why some businesses don’t like buying

Lots of businesses avoid buying premises for their businesses, because you’ll need to have a large capital injection right off the bat, and you may also incur land tax obligations, building insurance, and also be liable for maintenance and repairs.

Renting gives businesses, especially new ones, flexibility, as you’re only locked into a short term lease — not a multi decade mortgage. And if you decide to move or find new premises before your lease term is up, you can often minimise the costs by subletting the premises.

Buying as an investment strategy

However, buying your premises is a good investment strategy, as you’ll be able to access the equity and capital growth in the premises as property prices rise.

You’re also afforded greater freedoms and stability when you own your business’s premises — in particular, protections from rising rents — than you would have if you rented your premises. If you outgrow the space, you can always access the equity and may be able to buy adjacent premises, or rent out your existing ones while you upgrade, providing another valuable income stream.

Running the right reports to help you decide

Of course you can use a cloud accounting program like Xero to run reports that will help you decide whether to buy or rent your business premises and how such a decision will impact your cash flow. There will naturally be capital gains tax considerations and associated deductions. Our Xero training courses go through how to run these kinds of reports to ascertain the financial health of your business.

Low cost pathways to ownership

Industrial units are a good pathway into ownership for your business. If you don’t need to be right in the heart of the city or major town centre, you can often purchase an industrial unit for under $100,000.

In Newcastle in the Hunter region of New South Wales, you can purchase an industrial unit called a Cubbyhole, which can be used as a workshop, storage unit or office space for tradespeople, small and online businesses. These come with amenities such as toilets and showers, car parking (including visitors’ and disabled) and CCTV security, among other things and are worth checking out if you want to buy and only need a smaller business space. 

***

In our Cash Flow Reporting, Budgets and ROI course for Xero, you’ll learn how to deal with the purchase of business premises just like a Cubbyhole in Xero. Visit our website for more information on our variety of online training courses or enrol today!


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. 


 

Cash Flow Reporting in Xero

Show me the money!

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

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

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

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

The 3 cash flow categories

Cash flow reports are typically broken up into three categories:

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

Items in a cash flow report

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

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

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

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

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


cashflow reports in xero and excel

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


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.


 

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


 

New Financial Year, New Financial Habits

Help us help you get your business financials set up right

account set up with xero online training learning course
Taking time to set up your accounts correctly at the outset and recording your reconciliations regularly will save you time, money and a nasty, aching headache!

SO WE’RE INTO THE new Australian financial year. With the start of each financial year comes the chance to right last year’s financial habits and avoid repeating them again. You know what they say about people who repeat the same actions over and over again expecting different results …

If you had a crazy end of financial year, try starting off the next 12 months (well, 11 now, can you believe it!) on a positive footing, with these good financial habits.

Check your accounting software is set up correctly

Something that causes businesses and their owners countless headaches at tax time is accounting software that’s been setup incorrectly or not set up completely. Transactions that are coded wrong or bank feeds that are connected to the wrong account — or too few accounts — can leave you in the middle of a bookkeeping nightmare come June 30.

Spend some time sorting this out, or employ a bookkeeper to get you set up correctly. It’s worth that little bit of extra time now to get it right, truly!

Aim for daily reconciliations

Reconciling your business accounts regularly is important for a number of reasons, fostering good habits being chief among them. You may not need to reconcile your accounts each day, but it’s certainly a lot easier to find 10 or 15 minutes two or three times a week, rather than two or three hours once a month. The most often you do your bookkeeper the more unlikely it is that you’ll leave it pile up, eventually requiring costly rescue bookkeeping. You’ll also have a much better picture of your business’s performance with current accounting data.

Monitor cash flow

Positive cash flow is the marker of a healthy business. Negative cash flow is not. There are plenty of seemingly profitable businesses suffering negative cash flow that threatens to put them out of business. Don’t let yours be one of them. Create your own cash flow forecast reports in Excel or use a cash flow forecasting or expense app to determine if you’ll have enough money in the bank to meet your ongoing commitments (which includes paying yourself a living wage to meet your personal commitments).

***

Our cloud accounting training courses will show you how to set up your accounting software correctly. Learn how to use Xero, Quickbooks or MYOB with our online training courses and be able to invoice customers on time, reconcile your account and run financial reports, including cash flow statements. Visit our website for more information.


cashflow reports in xero and excel

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


 

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.


 

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

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.