Posted on 1 Comment

Achieve Your Financial Goals: Microsoft Excel Graphs & Charts Course Show Costs of Food and Petrol – Your Personal Budget

mybudget excel training course files to achieve your financial goals - online Excel Training Courses

If you are feeling the pinch financially right now it would be good to find out why. It’s easy to make a statement like “petrol and food prices are through the roof” but the truth might be a bit different when you get all your expenses into a spreadsheet.

Interest rates have gone up a LOT in the last few months so your mortgage payments might be chewing up most of your disposable income. If you have a car loan, personal loan or other debts where the interest rates are much higher you might find that you need to “consolidate” your debts to make ends meet.

A household budget exercise file is included in the Excel Intermediate Training Course 306 and a similar exercise file is available in the Excel Intermediate Training Course 305. The goal is to help you visualise the changes in your costs and expenses.

Continue reading Achieve Your Financial Goals: Microsoft Excel Graphs & Charts Course Show Costs of Food and Petrol – Your Personal Budget
Posted on

Xero Bookkeeping using Value-Based Pricing – Learn from your kid & their chores

Weekly and Daily Chores for Kids using Value-based rewards - Online Microsoft Excel Training Courses

I participated in an interesting project this week that clearly defined Performance Based Pricing. It came about because paying a flat wage just didn’t produce the desired outcome. Let’s just say that the kids didn’t complete all their chores and their mum got tired of paying pocket money while having to chase them up every day – sound familiar?

Xero have always promoted Performance Based Pricing (also known as Value-based pricing) as the best way to run a bookkeeping business but have the flexibility to operate your own hours. It’s based on paying for outcomes rather than time. It encourages workers to use technology to be more productive.

Continue reading Xero Bookkeeping using Value-Based Pricing – Learn from your kid & their chores
Posted on 2 Comments

Household Budget using Microsoft Excel Course: Track Interest Rates, Expenses & Income

Learn how to use Microsoft Excel in our Beginners, Intermediate and Advanced Excel Training Courses

A household budget can keep you sane in times when major expenses are fluctuating. It is a requirement if you are applying for a housing loan and if you want to borrow to invest in an online business but it can also show you very clearly if you need to find new sources of income or get rid of some expenses.

If you have found yourself subscribed to too many online streaming services or software programs that you just don’t need or use your budget can help you identify those expenses.

Same goes with debt repayments for phones, household items or motor vehicles.

There are two budget templates in the Microsoft Excel Intermediate Training Course – one for your personal income and expenses and one for starting a small business.

Continue reading Household Budget using Microsoft Excel Course: Track Interest Rates, Expenses & Income
Posted on

Microsoft Excel Intermediate Training Course Case Study: Working out Commission Payable to Sales Reps

Learn how to use Intermediate Microsoft Excel Skills to produce reports with complex formulas. Online Training Courses

Sales is an interesting career path which includes everything from real estate agents, account managers to direct sales people who walk from door-to-door or make calls on the phone.

Being a Sales Representative is something that every bookkeeper does if they have their own bookkeeping business. You speak with prospects, find out what they want, see if you can do the work for them and then sign them up and start working. You’re helping to match a business with a customer.

I’m often fascinated at how many Bookkeepers HATE hearing the word “sales” associated with any part of their work and as a result they act like a ROBOT when they speak to potential clients, but I’m digressing and that’s a topic for another blog post!

The benefit of being in sales is that you can earn a commission which is often much larger than your base salary – but keeping track of commissions payable each month can be complicated and we teach you how to use Excel to make it EZY.

Continue reading Microsoft Excel Intermediate Training Course Case Study: Working out Commission Payable to Sales Reps
Posted on

Microsoft Excel & Xero Bookkeeping COMPLETE Training Course Package is Now Here

Training Course ad in Manly Daily for Microsoft Excel, Website Design, MYOB - Ezylearn

You may be asking WHY it has taken us so long to create this training course COMBINATION package considering that Xero and Excel go hand in hand for all things financial and accounting?!

Xero is fantastic for keeping track of all of your financial transactions for a business and Microsoft Excel is still the preferred choice by most bookkeepers and accountants for producing reports and working with the data that comes out of Xero.

The versatility of Excel as a spreadsheet means that you can do so much more with it than just make sense of the financial information from your Accounting software. One case study in our Microsoft Excel Courses comes from our own experience about scheduling courses, trainers and training rooms for enrolments when we had a training centre in Dee Why NSW.

Continue reading Microsoft Excel & Xero Bookkeeping COMPLETE Training Course Package is Now Here
Posted on

Payroll Training Course: Employee changes are being tracked

1-Learn-Beginner-Level-Payroll-skills-with-Trim-and-Styles-Hairdressing-salon-Payroll-training-course-and-Certificate-using-QuickBooks-Xero-and-MYOB-1024x684

Xero led the way in online cloud accounting software that enables anyone to access their accounting software from anywhere. This means that small business owners, staff and their bookkeeping advisors can all access different parts of the software at anytime to perform their work. A far cry from the clunky way that MYOB AccountRight managed multiple users in an office environment a decade ago.

This amazing flexibility enables contract bookkeepers to perform credit control and end of month bank reconciliation tasks working from home, will office support staff are working on quotes, invoices and payments to suppliers. All of these transactions can add up very quickly and soon you can have hundreds of transactions. What if you had to find something, fix something that was entered incorrectly? That’s when you need an audit trail.

Xero just announced Payroll History and it’s designed to keep track of what happens with your payroll records.

Continue reading Payroll Training Course: Employee changes are being tracked
Posted on

Pick and Choose from Ideal Bookkeeping & Office Admin Jobs Everyday via Email

early-bird-bookkeeping-job-hunt-job-site-alerts-Indeed-Seek-Office-Admin-Bookkeeping-Accounts-Jobs-Online Training Courses in Xero, MYOB & Microsoft Excel

There are dozens of new office admin & bookkeeping job ads EVERY day, even for remote workers! Find out how to get them via email

When you’re serious about finding a good office administration or bookkeeping job it pays to have alerts set up on the most popular job search sites. Job alerts save you a lot of time by not having to manually search the same criteria each day, and ensure that you automatically receive email notifications as soon as new jobs become available.

Job alerts also allow you to find out what employers are looking for right now and which tasks they need their job seekers to perform.

With this information you can refine your searches even further to find the jobs most suited to your skills and experience, and then use the criteria to match skills in your resumé and job applications.

Continue reading Pick and Choose from Ideal Bookkeeping & Office Admin Jobs Everyday via Email
Posted on 1 Comment

Xero Prices Increase By $2 Again But No New Features – Are They Desperate for Cash?

One of Australia’s most popular small business accounting software has upped its pricing again, but with no new major added features for users (like when they included Hubdoc features in a previous hike).

Xero has announced that from September 1, 2022, three of its plans will increase in price, with the smallest increase at $2/month through to a $14/month hike.

So why are Xero prices increasing and what does it mean for users?  Xero has some pretty expensive recent purchases, and their share price is still declining, so could this spell financial troubles for Xero?

Continue reading Xero Prices Increase By $2 Again But No New Features – Are They Desperate for Cash?
Posted on 1 Comment

If ANZ Bank Buys MYOB will you EVER need to reconcile again?

One of the more time-consuming and tricky parts of catchup bookkeeping is reconciling your bank account and bank statement – which means going between your accounting software and bank.

In software like MYOB, even if you use bank feeds to import your transactions into your accounting software, you still need to make sure these match your bank’s records.

But what if your accounting software got the information directly from your bank daily?  With ANZ in talks to buy MYOB, here’s what you need to know about where banking and accounting software meet:

Continue reading If ANZ Bank Buys MYOB will you EVER need to reconcile again?
Posted on

NEW “Bookkeeping Basics” Training Course Covers Beginner Level Xero, MYOB & QuickBooks Online

bookkeeping-basics-training-course-for-Xero, MYOB and QuickBooks online cover-300x201 EzyLearn Bookkeeping Career Academy

Bookkeeping is an essential part of business, not just to keep track of financial activities for the business’ sake, but also to meet obligations from the ATO.  It’s nothing ground-breaking to highlight the importance of bookkeeping, but lots of businesses might start operating without considering the necessity of bookkeeping. 

If you’re a business owner who doesn’t have a background in accounting or bookkeeping, then you’ll want to learn at least the basics quickly – even if you intend to hire accounts staff, it’s great to understand the bookkeeping tasks that need to be completed.

EzyLearn has you covered with out new Bookkeeping Basics Training Course.  Let’s break down how you’ll learn the foundational aspects of bookkeeping with this course:

Continue reading NEW “Bookkeeping Basics” Training Course Covers Beginner Level Xero, MYOB & QuickBooks Online
Posted on

Square Afterpay or PayPal Pay in 4: Which BNPL Service Your Business Should Use

Buy now pay later (BNPL) services are growing in popularity for many retailers.  If you’ve been in store recently, or even online shopping as you go to click ‘proceed to checkout’, you might have noticed a poster or button that advertises how you can pay for your purchase in easy instalments.

Afterpay and PayPal are just two companies that provide BNPL options for customers.  We’ve started to make all our MYOB, Xero and Excel courses available on PayPal’s Buy Now Pay Later platform: PayPal Pay in 4

The best part is that you can use the discount coupons to reduce the price of each course and then pay it on instalments!

Continue reading Square Afterpay or PayPal Pay in 4: Which BNPL Service Your Business Should Use
Posted on

Planday for Xero or Square Team Management: Which Should Your Business Use?

Physical timesheets and all the manual data entry of employee scheduling is a hassle.  Even with technology like email and text, it’s always a task to try and figure out who swapped shifts with who and coordinate a schedule that works for all your employees.

Workforce management software like Planday and Square Team Management have become popular alternatives.  Planday is now owned by Xero, and Square Team Management is a service offered by digital payment company Block Inc. (formerly known as Square Inc.)

But which one should your business use? Let’s go through some of the main features you’d expect of a workforce management software, and see how Planday and Square Team Management compare:

Continue reading Planday for Xero or Square Team Management: Which Should Your Business Use?
Posted on

Payroll Training Course Integrations: Square Payroll versus Xero?

Now that paying by card is the norm, retailers have needed to adapt to the cashless customer.  If you’ve been to some local markets recently, maybe a sporting club canteen or even your regular café, you may have noticed that you’re tapping your card on a little white square instead of an EFTPOS machine.

Block Inc. – previously known as Square Inc – is a point-of-sale (POS) system winning over retailers and enterprises across the world.  And it’s not just little white payment terminals, Square offers a range of technology and services that range from POS to payroll to inventory to marketing, AND, they recently purchased AfterPay!

Square integrates with Xero, and considering its popularity, let’s break down what Square is and how it compares to other Xero integrations like Planday.

Continue reading Payroll Training Course Integrations: Square Payroll versus Xero?
Posted on

STP Phase 2 Training Added to Xero Payroll Course – Learn ALL Payroll Courses Across Multiple Software in Advanced Certificate in Payroll Administration

STP-Phase-2-Xero-Payroll Training Course

EzyLearn had added Single Touch Payroll (STP) Phase 2 Training to our Xero Payroll Administration Training Course.

As Xero continues to be one of the leading accounting program for Aussie small businesses, we’ve been updating our courses to stay up to date with changes.  We’ve also recently added Xero My Payroll content to this course.

The Australian government launched STP in 2016, where employers with over 9 employees must report their payroll information for each pay run to the ATO.  When the ATO introduced STP Phase 2 earlier this year, some of the reporting obligations changed.

Here’s what you need to know about STP Phase 2 reporting in Xero, and how EzyLearn’s got you covered with the training.

Continue reading STP Phase 2 Training Added to Xero Payroll Course – Learn ALL Payroll Courses Across Multiple Software in Advanced Certificate in Payroll Administration
Posted on

Are You Complying With Your Fringe Benefits Tax Liability of up to 47% (especially COVID-19 related ones)?

Do you provide your employees with gym memberships or concert tickets?  Or maybe you work for a company that provides you with a vehicle or accommodation? There are lots of perks that business can provide to their employees outside of salaries and wages – and these are called fringe benefits and they may apply to you if you worked at home due to COVID-19.

FBT is not as simple as handing out freebies.  Employers have to pay tax on these benefits they provide, and the amount can depend on the type of fringe benefit they’re providing. 

We’ve written before about how fringe benefits tax is important to consider when you engage a new worker, but let’s look more in-depth into what fringe benefits are all about, and how to ensure you comply with your liabilities:

Continue reading Are You Complying With Your Fringe Benefits Tax Liability of up to 47% (especially COVID-19 related ones)?
Posted on

Why is Xero Saying Your PayPal Bank Connection Needs Updating?

If you’ve connected PayPal with Xero, and have been using it for quite a while, it might come as a bit of a surprise when you get an email from Xero telling you that your existing PayPal direct bank connection will no longer be supported and will stop importing transactions into Xero.

Why is Xero emailing you this?  Especially considering there’s a timeframe in which you need to switch to the new PayPal bank connection, you’re probably eager to figure out what it all means.

Don’t stress, here’s what you need to know.

Continue reading Why is Xero Saying Your PayPal Bank Connection Needs Updating?