Online training courses for Small Business Management, MYOB and Xero Accounting, Excel, Word and Powerpoint, plus WordPress for website and blogging and Google for advertising, online marketing and analytics.
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.
We show you how to write off stock and inventory before the EOFY
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:
Selling air conditioning units
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.
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.
Don’t get lumped with penalties when you don’t need to!
It’s not only frustrating and disheartening, but a waste of business funds to be penalised for lodging your financials too late.
A LOT OF SMALL BUSINESSES have trouble managing their payroll, especially when they only have a few employees and paying to access a payroll system in their accounting package is an unnecessary expense. You’ll learn how to use Excel to manage your PAYG and super contributions in our Intermediate Microsoft Excel Training Courses. However, sometimes you may have a backlog of PAYG and super payments. Let’s take a look at how to manage these.
For businesses that only withhold up to $25,000 each year, you’re supposed to make PAYG payments and file a withholding report each quarter. You have 28 days from the end of the quarter to do so, after which time, you may incur a Failure To Lodge (FTL) penalty.
Superannuation payments
As with PAYG payments and reporting, you can also incur a FTL penalty for not lodging or paying your employees’ superannuation contributions in time. All businesses, regardless of size, have to make superannuation payments each quarter — the ATO sets out the due dates for each period on their website.
Lodging late PAYG and super payments
The ATO only applies penalties for failure to lodge reports or make payments for each period of 28 days (or part thereof) that a document or payment is overdue. Each period incurs one penalty unit for each document, up to a maximum of five penalty units.
From 2015 onwards, the value of a penalty unit is $180 (previously it was $170) for small businesses, which are defined as entities with an assessable income or GST turnover of no more than $1 million a year.
The maximum penalty a small business will pay is $900 for each document or payment that is overdue. Note too that FTL penalties will also incur a general interest charge (GIC), applied on top of the penalty.
Managing late PAYG and super payments
Use the Ad Hoc Payroll Guide, a new case study that is included in our Intermediate Microsoft Excel Training Coursesto determine the rate of PAYG tax to withhold and the required super contribution amounts in Excel. Once you’ve worked out the required amounts (visit the ATO website for tax tables prior to 2017), lodge the necessary PAYG payments and reports to the ATO; pay super contributions using the SuperStream super clearing house.
The ATO will write to you if you are required to pay a penalty — sometimes they are waived for first-time offences, or if the amounts are small.
Create brilliant presentations and graphics for all kinds of business purposes.
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 induction. Find out more about our 2016 version PowerPoint courses.
WHEN IT COMES TO YOUR BUSINESS ACCOUNT KEEPING, unless you’re a bookkeeper, bookkeeping is probably your least favourite thing. However, it’s also a fundamentally important part of running a business.
However, not every business owner has the procedures in place to manage their bookkeeping regularly. It’s ok, it’s not your fault — you were meaning to, but you were busy running your business and time marched on. Now you have to lodge an activity statement, and you’ve just realised you haven’t done any bookkeeping for three months!
When you need rescue bookkeeping
If you have three months or more of bookkeeping to do before you can lodge an activity statement, then you’re in need of a bookkeeper who can perform rescue work. Some of the common bookkeeping problems rescue work covers includes:
Bank accounts or credit cards that don’t reconcile with statements
Old un-presented transactions in the bank account or credit card
Trade debtors and trade creditors don’t balance with the balance sheet
Dealing with outstanding invoices and bills that have already been paid, but still showing as outstanding
Incorrect previously lodged BAS
Incorrect information showing in payslips, tax tables, super guarantee contributions calculations, payment summaries, etc, due to payroll systems being set up incorrectly
Unreliable inventory figures.
Not all bookkeepers are able to take on rescue work, because it’s lumpy and it requires them to perform a lot of work in a short space of time, which can conflict with their other regular bookkeeping work.
Rescue bookkeeping is often more expensive
Because rescue bookkeeping requires a lot of manpower in a short period of time, it’s often a little more expensive than have your bookkeeping attended to on a regular basis. In most cases, you will be asked to prepay for a minimum of 10 hour’s work or however long it’s estimated it will take to get your bookkeeping up to speed.
Do you need help with rescue bookkeeping work?
We have bookkeepers, BAS agents and accountants located across Australia, available to help businesses in need of rescue bookkeeping work. Visit our online directory of local bookkeepers and bookkeepers who work ‘in the cloud’ at National Bookkeeping for more information. Here you will be able to see the different bookkeepers’ rates or request a quote.
A Chattel Mortgage Can Help Keep Your Business Cashflow Under Control
A chattel mortgage can tide your business over without having to dip into savings.
In our Xero Daily Reconciliations Course, you’ll learn how to set up a chart of accounts, among other things such as running balance sheets and Profit and Loss (P&L) statements. For the most part, daily transaction reconciliation is pretty straightforward, until you get to a capital purchase, which, if it’s over $20,000 or was purchased prior to May 2015, needs to be dealt with differently.
In most cases, when a business purchases major assets, such as a motor vehicles, it’s known as a capital purchase, which is made via a loan. There are two types of loans the business can take out: a hire purchase loan or a chattel mortgage.
Buying assets on hire purchase
This is an agreement between you and the lender to acquire a motor vehicle. During the hire period, the lender legally owns the car and you pay regular instalments to the finance company. For tax purposes you can claim depreciation, running costs and interest paid against your business income. When you pay off the loan in full, legal ownership is then transferred to you.
Buying assets on chattel mortgage
Chattel mortgage is essentially a mortgage over goods to be financed. Chattel mortgage is classed as a cash sale in that the goods automatically become your property on purchase and the finance company takes a mortgage over the chattels.
Just as a hire purchase you can claim depreciation, running costs and interest paid, against your business income. The chattel mortgage allows businesses to claim the full input tax credit from GST incurred expenses immediately (next BAS statement).
Chattel mortgages are more popular
Chattel mortgages became popular when BAS and GST was introduced, because businesses could claim the GST at the time of purchase, whether they ran a cash system or an accrual accounting system. Plus, under a chattel mortgage, the allowable depreciation and interest payment are also tax deductible.
How capital purchases affect cash flow
If a business doesn’t take out a loan to make a capital purchase, it will have to dip into its savings, which can adversely affect cash flow, especially on big ticket items. Taking out a chattel mortgage, however, helps to keep cash flow under control because the business can borrow the funds (and claim the interest back as a tax deduction) without any major impact on cash flow. You will also then be able to factor the repayments into your monthly forecast projection.
When you have to train contractors or new staff about your policies and procedures, an online induction is the most efficient – and effective – way to go.
At EzyLearn we have a bit of a soft spot for PowerPoint. It’s the oft-overlooked program in Microsoft Office that is typically associated with slideshows and presentations, and often boring ones at that. But it can do so much more.
But did you know PowerPoint can also be used to create an online training induction course? Induction training is imperative for any business that hires contractors to perform work for them, either onsite or elsewhere. Induction training is necessary that any contractor or employee understands your company’s policies and procedures, whether they’re going to be working at your premises or not.
Our PowerPoint Training Course takes you through how to create your own induction training course using PowerPoint, which you can then deliver to your staff and contractors using a learning management system, or we can deliver your induction training for you.
Simple inductions that work
The end goal of an induction course should be to have all your contractors complete it, and learn something from it. You need to strike a balance between an induction that includes every last bit of information about your business, how it functions, its policies and procedures, and one that only covers the bare essentials.
Use images to illustrate risks and scenarios, as opposed to describing them. This is easy when you’re using PowerPoint to create your induction training. And remember the PowerPoint golden rule: One idea per slide.
Authenticating students
After you’ve created your induction training course in PowerPoint, it’s vital that your contractors actually complete it. This is why it’s important to authenticate each contractor or student who takes your induction training course — it also helps if you include a short quiz at the end, so you can see whether they paid attention.
There are a couple of different ways you can authenticate students to ensure the correct person is taking the induction course (and not their mum or friend or partner, for example). We talk about the different authentication methods you can use on our website, but keep in mind that only inductions delivered to students via a learning management system can authenticate students.
Why It Pays to Call the Switchboard When Doing a Reference Check
How do you really know the mobile numbers provided for references truly belong to who they say they are?
I recently had a conversation with a colleague who said she’d never once been asked to produce a copy of her university degree or her transcripts, despite stating on her resume that she’d graduated with a high distinction average.
Gee, I thought, not once? Not a single recruiter or employer had ever requested a copy of her degree? I found this fact astonishing, particularly since more professions require, by law, certain qualifications — as BAS agents are, for example. So how people know my friend wasn’t fibbing in her credentials? Fact is, they didn’t.
Check, even if you use a recruiter
I wrote a blog some time ago about recruiting on LinkedIn and why it’s so important to check references for yourself. People often underestimate the importance of checking a person’s credentials, so long as they get a reference from their last employer. Often, though, most people only provide a mobile number for their references, so whether you’re speaking to the candidate’s former employer, a co-worker, or their mum is sometimes anyone’s guess.
I was reminded of how important reference-checking is again, when I was reading a couple of articles on Longreads, and I found myself utterly fascinated by two of the biggest cases of journalistic fraud ever committed (though I admit to having never heard of them before the weekend, despite one occurring more than 30 years ago).
Sometimes people don’t just lie on their resume
In the first instance, a journalist named Janet Cooke fabricated a story for TheWashington Post about an 8-year-old heroin addict. She won a Pulitzer Prize for it in 1981, and then had to give it back when it came out that there was no such 8-year-old. In the second case, Jayson Blair, a journalist for The New York Times, was found to have fabricated or plagiarised 36 out of 73 stories written over a 6-month period, in what turned out to be the biggest scandal in the newspaper’s hundred-plus year history.
What I found most intriguing, though, was that neither Cooke nor Blair had been properly vetted before their employers hired them. In fact, it was Cooke’s falsified resume that was ultimately her undoing when, after receiving the highest honour in the field of writing, a former employer noticed something was amiss with her Pulitzer biography — her education and professional achievements had been grossly overstated. (Rather ironically it was Bob Woodward, of Woodward and Bernstein — the journalists who uncovered the Watergate Scandal — who signed off on hiring Cooke.)
The same would prove true for Blair, who, it turned out, never graduated from university, and had a murky work history with the Times’ sister publication, The Boston Globe, where his superiors had been less than impressed with his less-than-high standard of work.
(Of course, the equally interesting case of Australian author, Helen Demidenko, who won the Miles Franklin Award in the early 1990s, only to later be dubbed by the Sydney Morning Herald as a ‘literary hoax’ also springs to mind.)
Benders-of-truth almost always get caught
Plenty of people lie or embellish on their resumes, and while a good majority of them go unnoticed, others are caught out — sometimes very publicly, and often only after the organisation has been very publicly embarrassed, as in the case of Cooke and Blair.
My advice, then, is to always check the references of new hires meticulously. Rather than calling the mobile numbers or direct lines of the candidate’s references, call the main switchboard and ask to speak to that person’s manager or superior.
And always ensure to ask for a copy of any credentials, like university degrees. If you’re employing someone where, by law, they’re required to hold a certain qualification — as is the case for BAS agents, for instance — it’s imperative you can verify the person’s credentials.
Using Excel to Financially Forecast the Viability of Your Investment
Excel is the tool you need for developing a feasibility study so you can assess the viability of any kind of investment.
When you are planning to invest in a project, you naturally have to weigh up the risks. One of the chief ways of doing this is to complete a financial forecast to determine the viability of your investment. One type of investment that has been exceedingly common and popular with the current property boom has been the investment in a granny flat.
Many homeowners and investors who own a property with adequate room and the right conditions, have chosen to build a granny flat on their existing property as a means of earning extra income.
Of course, you need to consider whether you’re legally allowed to rent out a granny flat, which in some Australian states — Victoria, South Australia and Queensland — you aren’t. If you’re found renting a granny flat in any of those states, your local council can ask you to remove the granny flat from your property.
You may determine that a granny flat will earn around $12,000 a year in rental income, but it could take up to 10 years to break even on construction costs. Although some of those costs can be deducted as expenses and the dwelling depreciated over time, depending on where the property is located, property values may not increase by that much. This is amplified if you’ve just purchased the property, compared to a person who’s owned their property for 5 or 10 years.
Granny flats can reduce your rental return
Depending on how the granny flat has been constructed, its proximity to the main dwelling, and whether there are any shared or common areas, there’s also the potential to reduce the rental income on the principal dwelling. If the property has been previously tenanted, the shift from single to dual occupancy will reduce the rent of the principal dwelling. This could be offset by the existence of the granny flat, however, it moves the goalposts for your break even date. You may also experience more tenant churn, which will see more of your rental income going to real estate agents in letting fees, and greater wear and tear on the dwellings. You may also experience longer than average vacancy rates.
At EzyLearn we are constantly refreshing the content of our 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.
Excel Will Help You Work Out the HOW of Depreciation
We recently updated our advanced Microsoft Excel Training Course content. It now contains a case study, by way of an extra exercise workbook, using a granny flat building project to create a financial forecast.
We chose a granny flat building project for our case study because it’s an investment decision quite a lot of people with or without a business have made. It’s also a capital asset that can be depreciated over time. Therefore it has the potential to affect your taxes in lots of different ways.
Your bookkeeper uses Excel to calculate depreciation
When you build a new structure, such as a granny flat, which you intend to rent out or use for businesses purposes — i.e., it’s an investment and not for your own personal use — the building can be depreciated along with some of the fittings and finishes (floorings, curtains, paint, etc). That’s despite the value of the land upon which the granny flat is constructed increasing in value over time.
Excel will calculate the depreciation amounts for you, which you should then enter into Xero. We cover how to deal with depreciation in our Xero Bank Reconciliation Course, because lots of businesses own, or will own, a capital asset at some point.
However, this doesn’t tell you how to determine the depreciation amounts, which most business owners have to get their bookkeeper to work out for them. Most bookkeepers work this out in Excel based on the depreciation rates provided by the ATO. However, if you have already created a financial forecast in Excel, you won’t need to get your bookkeeper to do this for you.
Individuals can claim depreciation too
Even if you’re not a business owner, but you’ve still built a granny flat that you intend to rent out, you can claim depreciation in your tax returns. Instead of entering the depreciation into Xero, you’d include it on your annual tax return, so it’s really important that you work this out in Excel first and regularly update it.
***
Once you know how to use Excel for financial forecasting, you can use the same formulas and modelling for any financial forecast — be it for a granny flat project, business investment, anything that requires you to make a financial decision. Visit our website for more information on our advanced Microsoft Excel Training Course, with its new granny flats case study.
Do you want to brush up your Xero skills? Or perhaps you use MYOB but want to get a handle on Xero? Check out our suite of Xero training courses — all available for one low price.
PowerPoint: The Great Visual Aid to What You’re Saying
Save densely-worded slides for university lecture rooms: keep PowerPoint slides concise and use your presentation as a way of illustrating or highlighting what you’re saying.
Many people don’t realise what an excellent design tool PowerPoint is. It can be used for a lot more than just creating slideshows and presentations and is a great marketing and design tool for all kinds of business functions.
Generally speaking, when using PowerPoint, you should feature only one idea to a slide. A PowerPoint presentation is not an essay. It shouldn’t be filled with verbose text (unless perhaps you’re in a university lecture). In fact, as you will learn in our updated PowerPoint Training Course, sometimes a PowerPoint slide shouldn’t contain any text at all, or at least, very little. Continue reading There’s So Much Cool Stuff You Can Do With PowerPoint
A business’s balance sheet is a snapshot of its financial position at a particular period of time, which is not to be confused with a profit and loss (P&L) statement. Unlike a P&L, which just shows whether the business is making a profit or loss during a given period, a balance sheet, will eventually, show nearly every activity that has occurred within a business.
However, there are some transactions that will show up immediately. You’ll learn how to run a balance sheet in our Xero Daily Reconciliations Training Course, but we wanted to show you the transactions to look out for and why.
A balance sheet reveals the nitty gritty of your business’ transactions.
The purchase or sale of assets
When an asset, such as a car, is bought, it will reduce the cash account and increase the fixed-assets account. Both of these accounts are listed in the asset portion of the balance sheet, however, cash is part of the current assets section and fixed assets are part of the long-term assets section.
When an asset is sold, the way the cash is accounted for is a bit more difficult. Here, both the asset’s book value and any accumulated depreciation are removed from the books at the same time that the cash account is increased by the sales price. If the sales price does not equal the book value, the difference is accounted for as a gain or loss on the sale of equipment. This gain or loss is recorded on the P&L statement.
Purchases on credit
When a business purchases supplies or inventory on credit, the business will debit the asset account (supplies or inventory) and credit the accounts-payable account. Almost always, accounts payable are considered to be current liabilities and are shown at the top of the liabilities section of the balance sheet.
Debt and lease arrangements
When a business issues debt or enters into a leasing arrangement, a liability must be recorded in the long-term section of the company’s balance sheet. For example, if a company issues bonds for cash, the company would debit cash and credit bonds payable in the simplest bond-issuance scenarios.
Capital-lease transactions affect the balance sheet in a similar manner. When entering a capital-lease arrangement, the business will debit a fixed-asset account to show that the company has taken economic possession of the leased asset. At the same time, the business will credit a capital-lease obligation account to show the offsetting economic liability.
Choosing between a one-bedroom and two-bedroom granny flat is a decision you’ll need to make early on in the project, and it’s largely a financial one.
EzyLearn’s Microsoft Excel Training Course includes a new case study, “Investing in a Granny Flat”, which uses the construction of a granny flat as a real life example to help you to better understand how to develop a financial forecast for an investment.
Determine construction and ancillary costs
How much it will cost to construct both a one-bedroom and two-bedroom granny flat is the first step. You need to work out how much it will cost to get each granny flat constructed to the point that someone can move in, as well as any ancillary costs, like council fees and levies, real estate management fees interest rates and so forth.
Determine rental income
Some granny flat companies will give you rental income estimates, but you’re encouraged to investigate this yourself. Rental incomes are heavily dependent on your local area and the demand for that type of property. In Sydney, the demand for rental property far outweighs the demand in regional NSW. Take into consideration vacancy rates in the area and the types of property that are in demand. Areas with high vacancy rates and low demand for one-bedroom units could indicate there’s little demand for a permanently rented one-bedroom granny flat, which will put the rent down.
Determine depreciation amounts
Both granny flats will be subject to the same depreciation rate, however the amounts will differ due to the differing value of each dwelling. In addition to an annual depreciation rate on the dwelling, consider other elements of the granny flat that will also be subject to depreciation. Floor coverings, for example, can be depreciated over time. Carpeting is typically depreciated at a rate of 20 percent, where tiles are depreciated at 2.5 percent because the latter has a longer lifespan.
Determine the best investment
Add all of these costs into Excel to determine the average annual rental yield, expressed as a percentage of the property value. Rental yields are used to show the return on an investment. The higher the rental yield, the better the return is. Taken in combination with your own personal circumstances and plans for the future should help you to determine which option represents the better investment.
At EzyLearn, we’re committed to helping students of all our courses find better employment opportunities, become their own boss and upskill. To this end, we constantly update our courses with new, highly relevant content — it’s why we provide you with the option of Lifetime access you can always refer back to our courses as you progress in your skills’ development.
We’re thrilled to announce our new Micro Courses which are be added to our existing courses, or can be purchased alone. These are based on real-life case studies and relate to real people in genuine, real-life scenarios. Subscribe to our blog and be alerted of updates.
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
Although 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.
Wow – this PowerPoint presentation really is AMAAAZING!!
You know what PowerPoint is. It was installed on your computer when you bought Microsoft Office. You hate it. But have you thought that the reason you hate it is because a) you’ve never learned how to use it properly, and b) you associate it with boring corporate meetings and seminars?
Third Quarter is Looming; Are You Up to Date with Payroll?
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.
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’ve recently updated our Microsoft Excel Training Course content, because it remains one of the most indispensable tools for small businesses — and we’ve included a new exercise workbook which takes you through all the steps involved in developing a financial forecast for an investment.
We used a granny flat project as the case study in our financial forecasting workbook, but the beauty of Excel is that, once you get the formulas right, they can be replicated for any kind of investment, not just one for building a granny flat.
The wonderful 3D formula
3D formulas are one of the other many wonders of Excel. A 3D formula is basically a reference to the same cell or a range of cells within multiple Excel sheets. They’re a convenient way to reference several worksheets that follow the same pattern, with cells that contain the same type of data.
All functions work with 3D formulas
3D formulas can be used with all Excel functions — SUM, AVERAGE, PRODUCT, etc — which means that, using a 3D formula, you can easily create a financial forecasting sheet for any stage of an investment, and easily reference that data in another financial forecasting sheet. This is invaluable because there are very few projects or investments that can be contained in just one Excel worksheet.
A project like the granny flat case study in our online Excel Training Course, contains many moving parts — there’s the initial construction, then there’s the ongoing maintenance, and the rental income to manage. It would be impractical to keep all of this information contained within the one Excel worksheet.
3D formulas can be modified with time
The best part about using 3D formulas is that you only need to specify the start and end sheets (which for ease-of-use, you could just label ‘start’ and ‘end’) and the formula will reference all the worksheets between the start and end sheets, including those two sheets.
This means that, as your investment or project grows, once you’ve got the 3D formulas set up correctly, you can just add and subtract worksheets as necessary, and the calculations will update automatically.
***
Once you understand how to create and work with 3D formulas, you can use them for any project or investment that you create a financial forecast for — be it for a granny flat project, business investment or anything else that requires you to make a financial decision.
Type the first 3 characters to discover courses, up-skilling programs and CPD articles.
EzyLearn's Career Academy
Enrolled into an EzyLearn course since 2013? Get access to new & updated course content and support by joining the EzyLearn Course Refresher Access membership Program. See how to extend your course life & support.
Xero is a great bookkeeping program for tradies who are on the go and using their phones (or a tablet) all the time. From receipts scanning to creating quotes and invoices, receiving payments and keeping track of project costs.
bookkeepercourse.com.au/produ…
EzyLearn Excel, MYOB and Xero online training courses count towards 
We recently updated our advanced 
A business’s balance sheet is a snapshot of its financial position at a particular period of time, 
Although 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. 
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. 
We’ve recently updated our 
