Business owners can now get a discount on our MYOB & Xero and Microsoft Office COMPLETE courses if they don’t need a Certificate of Completion.
I recently wrote about the value of Certificates and who really needs one and we’ve discovered that most business owners prefer to focus on getting the knowledge to use their software better AND saving money – that’s why we introduced NoCert discounts.
Continue reading NoCert, saves money
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
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
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
IN A PREVIOUS POST we talked about taking out a business loan to cover payroll if you anticipate that you won’t have enough funds to do so otherwise.
Naturally, it’s always better to use your business’ own funds to meet your obligations, whether it’s paying staff or suppliers. This said, getting a business loan to cover payroll can be a good idea for small and growing businesses in certain circumstances. We look at these now.
Depending on how many employees work for you, the repayments on a business loan are typically smaller than all of your payroll obligations — this includes superannuation and PAYG — combined. If you get a loan to fund 12 months of your business, payable over a 24 or 26 month period, the repayments will be far easier to manage each month.
Businesses are able to claim the interest from any business loan as a tax deduction, so even if the annual percentage rate (APR) adds a few additional thousands of dollars to your capital amount over the period it takes to pay the loan back, the interest will still go towards reducing your taxable income.
This is a more favourable option to delaying payment to your employees (illegal) and delaying payment of PAYG and superannuation withholdings, which could incur a Failure To Lodge (FTL) penalty, plus a general interest charge (GIC). Note: Fines and penalties cannot be claimed as a tax deduction and are therefore dead money.
Don’t forget that, while a business loan to cover payroll for 12 months will be easy to repay initially, your business’s profits will need to improve substantially over the next year so that you can continue to meet your loan repayments AND your payroll obligations for that year.
You can easily work this out using Microsoft Excel. Our Intermediate Microsoft Excel training courses show you how to determine if you can afford to take out a mortgage, but because all of our fields remain “unlocked”, you can easily modify them to suit a business loan scenario. Visit our website for more information on all of our Excel training courses.
Most 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.
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:
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.
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.
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.
