It’s Christmas season once more and you can even get a great deal on your MYOB Business Lite or Pro accounting software if you have an eligible Westpace account.
There are some exceptions, however, and these exceptions show where all the accounting software vendors are making their money: Payroll, Inventory and deeper functionality through integrations.
This is not the first time MYOB have partnered with a major corporation to get its software promotions sold. The last one I wrote about was when Telstra was pimping it last year. This offer is different..
One of the most common questions we get asked by students when they enrol into an online course relates to access to the software.
Years ago you could buy the MYOB AccountRight software from Officeworks for $10 and use it forever but online software like Xero, QuickBooks Online and MYOB Business Essentials are all subscription based and offer a 30 day free trial.
Although 30 days doesn’t seem like a long time if you are enrolled into a MYOB or Xero course that provides 12 months course access, there are ways you can still make VERY good use of these trial periods.
No amount of data is too big for Excel’s pivot tables
Go You Excel Pivot Table! Excel’s signature function, the pivot table, is still as useful for making sense of large amounts of data as it ever was.
WE’VE RECENTLY BEEN UPDATING the content for our Excel training courses and were reminded of just how useful Excel is for small businesses. In Excel, you can easily create and manage client databases and then export part or all of that data into a Word document, your accounting software, an email marketing service, or use it in other Excel documents, such as a pivot table.
A pivot table is Excel’s signature, and most powerful, feature — Microsoft trademarked the words ‘pivot’ and ‘table’ in their compound form PivotTable back in the 1990s. So if you intend to use Excel in any meaningful way for your business, knowing how to create and work with pivot tables is an essential skill, one which we cover in our newly-updated, advanced Excel online training courses.
What are pivot tables used for?
A pivot table is a way to quickly summarise and analyse large amounts of data, and the pivot tables you can create in Excel are especially designed for:
Subtotalling and aggregating numeric data
Summarising data by categories and subcategories
Creating custom calculations and formulas
Expanding and collapsing levels of data
Drilling down on details from summary data
Filtering, sorting, grouping and conditionally sorting data
Presenting concise, attractive, and annotated reports
Moving rows to columns and vice versa (‘pivoting’) to see different summaries of source data.
Pivot table data sources
There are a few ways that you can create a pivot table, though the most common way is to use an existing Excel worksheet — a database, for example — as a data source. Here are a few ways to create a pivot table in Excel:
Excel tables: Excel tables are already in list format and are good candidates for pivot table source data. When you refresh the pivot table report, new and updated data from the Excel table is automatically included in the refresh operation.
Using a dynamic named range: To make a pivot table easier to update, you can create a dynamic named range, and use that name as the pivot table’s data source. If the named range expands to include more data, refreshing the pivot table will include the new data.
Create a database in Excel first
The most efficient way to create a pivot table is to create a database in Excel first. Here, you can update and manage as much information about your business — including customer data and financial data — and then use that as a data source for a pivot table.
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.
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.
A HUGE PART of reconciling your bank account involves coding business expenses or purchases. You then need to keep a record of those expenses in the event you’re ever audited.
Our Xero Bank Reconciliations and Journal Entries Course covers how to code an expense or purchase in Xero, and it’s important to also store your receipts and get them to your bookkeeper if they’re working remotely.
When it comes to working out fees, most business owners go: “Well, the average market rate for my profession is X per hour and this job should take around Y hours” and off they go and give their client a quote that, in today’s small business parlance, is frequently referred to as being a fixed-price quote or the project fee.
QuickBooks is a much simpler accounting package to use than its rival, MYOB.
WE RECENTLY INTRODUCED our QuickBooks Online Daily Transactions Course because we can see that QuickBooks is fast becoming a serious and respected rival to the more established accounting software packages.
We recently wrote about how QuickBooks uses the SuperStream-compliant service KeyPay to deliver payroll services because QuickBooks itself isn’t actually SuperStream compliant. Currently, the payroll feature in QuickBooks is free for all Small Business plans, as the company further positions itself as the low-cost accounting software option for Aussie small businesses.
FINDING PROSPECTS AND converting them into clients involves selling and most of us hate doing it, but wait…
For those of us in small business, be it as a bookkeeper, real estate agent, sales rep, virtual assistant or the like, most of us are selling every day of our lives.
This means we get pretty good at it. We develop techniques that we can replicate and that become part of our daily lives.
The process of selling is really no longer about selling per se; it becomes about a systemised process of:
There are lots of services available that, for a fee, will register your business name, company structure, domain name, email hosting, and even register your business for GST and PAYG. But do you really need to use these services? Well, it depends.
What To Do So You Don’t Lose Money When Doing Your BAS – 6 steps
If your business is registered for GST, it means you have to file regular activity statements with the ATO, usually each quarter. A lot of business owners export their Business Activity Statement (BAS) data straight from their accounting software, like MYOB or QuickBooks, and quickly prepare their BAS’ that way. But this is an imprecise method, and one that could be costing you money.
Bookkeeping may be getting easier but do you really want to do it?
You don’t need to be a BAS agent to be a successful and profitable bookkeeper.
EVEN WITH THE LATEST accounting programs, like Xero and MYOB Account Right Live making it easier for small business owners to manage their bookkeeping themselves, a bookkeeper is still an invaluable asset to any business. (It’s also the truth that, as much as companies like Xero tell you they make it a cinch to do your own bookkeeping, online account-keeping software programs are still complex and time-consuming to learn to use properly.)
Here we certainly addressed the reasons bookkeeping is a good professional pursuit, but now it’s time to look at the benefits hiring a bookkeeper has to a business owner.
A bookkeeper makes a good, legal sense
The most obvious benefit, of course, is that by having someone to take care of your bookkeeping it frees you up to concentrate on the aspect of your business that you’re best at. But aside from being a legal requirement for every business to keep accurate records, it also helps you to monitor how well your business is performing.
A bookkeeper will work on your bookkeeping every week or even a few times a week, depending on your business needs, enabling you to monitor your daily income and expenditure, and if your accounting software has bank feed enabled, you can monitor it in real-time, too. This is crucial for businesses with many expenses or running costs – businesses that purchase stock or employ staff, for instance – to be able to manage their cash flow.
Paying a bookkeeper can save you money
But having your bookkeeping kept up-to-date also has other benefits, particularly in relation to regulations such as when you need to register for GST, and so forth. Here are five more benefits to your business if you hire bookkeeper to look after your books:
Keeps your tax bill down: Businesses that don’t have someone taking care of their bookkeeping end up spend more with their tax accountant, so it’s really false economy if you think you’re saving money by going without a bookkeeper. It also potentially costs you money in other aspects of your business too, as you’ll find out.
Can manage invoicing: Sure, it’s super easy to invoice your customers and clients now that most good cloud-accounting programs have apps for smartphones and tablets, but there are still plenty of businesses that don’t use the accounting apps on their phones or tablets because of the complex nature of their business. A bookkeeper can take care of this.
To take care of your payroll: When you hire employees or sub-contractors, you’re entering a whole new realm of business. There are superannuation contributions, payroll tax, and a heap of other regulations that bookkeepers have to stay up on, but you don’t.
You’ll avoid ‘late’ penalties: The ATO takes late lodgments pretty seriously, and the penalty for the late lodgment of a BAS or tax return can be up to $850 for each late lodgment. If you’re consistently late lodging your BAS or tax returns, then a bookkeeper basically pays for itself, because unlike fines or penalties, which are not tax deductible, the services of a bookkeeper are.
Chasing unpaid invoices: The reality of running a business, unfortunately, is that a lot of people you’ll do work for won’t pay you on time. Chasing unpaid invoices is a delicate and time-consuming process, particularly when it starts to affect your cash flow and prevents you from taking on more work – buying stock or supplies, for example. It’s always a good idea to separate the face of business from debt collection. It helps keep the client relationship warm and fuzzy, while cash continues to come in the door.
Now that cloud-accounting programs have made it more possible for bookkeepers to work from home and contract their services to many different clients, making it easier and more affordable for small businesses to retain a bookkeeper.
— EzyLearn is Behind a New Bookkeeping Initiative —
EzyLearn now features the National Bookkeeping Directory, a service which connects businesses owners with bookkeepers, based on their business needs or location. If you’re looking for a qualified, local bookkeeper to manage your books, visit the National Bookkeeping website.
Alternatively, if you’re thinking of starting your own bookkeeping business, National Bookkeeping is looking for smart entrepreneurs to become licensees.
Because it’s the beginning of the year we are receiving a lot of calls from students who are looking to do an MYOB Course so we are thrilled to confirm that we offer access to ALL of our MYOB Courses for one low price and 12 months course access.
You can follow our journey from operating training centres in Sydney’s Dee Why, to the decision to go 100% online at the About EzyLearn page on our website, but I’ll sum it up in 1 paragraph here:
We can guarantee consistent course content to every student, with MYOB Course content developed over 15 years in teaching people how to use MYOB and from some of the best MYOB Trainers in Australia. By creating our own MYOB courses and updating them we are able to focus on the content of our courses as well as the systems to support it online rather than paying for office rent, computers and software licences, trainers and advertising.
MYOB Course Options
The only decision you need to make is whether you want an MYOB certificate and 12 months or lifetime course access. Remember that unlike some MYOB course providers our students can move freely from one course to the next as they please and use the course as a resource while at their new job or operating their own bookkeeping business.
MYOB Videos, Training Workbooks and Knowledge Reviews
With a 100% focus on MYOB Course content we create every form of training material for MYOB accounting software: Videos, Workbooks (with step-by-step exercises) and Knowledge Reviews that test your skills. You can watch a video and try to replicate it with the free MYOB software or follow the exercises in the MYOB Trainingg Workbooks to perform tasks that bookkeepers perform every day in their working environment.
Money-back Guarantee
When we were the first training company to offer MYOB courses online in 2008 we offered the money-back guarantee because not everybody had great broadband Internet speeds, not everyone knew how to navigate around websites and online learning management systems and people where generally scared to use their credit card online. Now-a-days we find that the biggest reason some students find it a comfort is because many students are Mac users and are not sure that they would learn by using MYOB Course content created for the Windows versions of the MYOB software.
Why Thousands of Students Choose EzyLearn for MYOB EVERY Year
We use the Content Marketing approach to building our brand and product awareness and it takes a lot of effort to put the amount of detail we put on our website and in our blog posts. We do it because it shows an ongoing commitment to openness but also to leave no doubt as to exactly what we offer and how we support it. If you want to get to know more about us read some of our blog posts or watch some sample videos. If you are ready to enrol into an online MYOB course then enrol now online and start by 5pm next business day!
Entrepreneurs are strong-minded individuals – but we’ve found there are at least 5 other qualities they tend to possess that leads to their business success.
This is a perfectly understandable sentiment — but it’s not necessarily conducive to making a small business work.
Entrepreneurs are known to be people who manage starting up and/or bringing to fruition their own businesses and ventures, but entrepreneurs are a certain breed and as many find out the hard way, self-employment is not for everyone. Continue reading So You Think You Can Be an Entrepreneur?
We were recently surveying our PayPal account and discovered that you can now invoice customers directly using PayPal. While it doesn’t eradicate the need for a good piece of accounting software, this facility makes it very easy for people to get started in business — particularly businesses with very few expenses. Continue reading Invoice Your Customers Directly Using PayPal
Having a bookkeeper induction program will add value to your business.
Having accurate business records is vitally important for any business — and most of that hinges on accurate account keeping. If you’re a small business looking to hire a bookkeeper, you want someone who’ll be able to manage all of the data entry and coding for your company accurately and efficiently.
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…
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. 
