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.
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.
Invoices can be a hassle for both businesses and their clients. There’s nothing fun about chasing up that client about their late payment, nor is it an efficient use of time to trawl through emails and inboxes trying to find that invoice from however long ago.
The Commonwealth Government is pushing ahead with an alternative, that looks like it will make things a bit easier for everyone.
eInvoicing is on the rise! And since software like Xero has jumped in on the change, it’s important for small businesses to know what eInvoicing is all about:
It’s not a stretch to say the last few years have been tough…especially for businesses. Through lockdowns and restrictions we’ve seen businesses struggle, falter, adapt, and survive.
Now that we’re in to 2022, and things are (fingers crossed) almost looking normal again, it’s exciting to see how businesses will recover and thrive.
Xero has released a guide to small business trends for 2022, based on surveys they conducted in 2021 of their subscribers in Australia, New Zealand, the UK, Singapore, Canada, and the US.
Here’s are 10 trends on the rise for small business this year:
Did you know that Afterpay (and ZipPay) and some other Buy Now Pay Later providers decline sellers? Most Afterpay transactions are centered around the selling of physical products that change ownership from the merchant to the customer. This evidence is enough to bind customers legally, but what happens if you provide professional services like bookkeeping or accounting?
Accountants and Bookkeepers, like many other professional service providers including Lawyers and solicitors charge for their time or defined outcomes (like fixed fees for a certain number of transactions).
Will Afterpay take you on as a client? We’ve heard that many industries are rejected but there are alternatives and Xero’s App Store can help.
In our educational guide, Bookkeeping Beginner Basics, which you can download from the EzyLearn website for free, you’ll learn how to record journal entries in your accounting software, whether you’re using MYOB, Xero or QuickBooks. Most bookkeeping newbies don’t know what a journal entry is, though, which is what this blog post – the latest in our Bookkeeping Beginner Basics guide companion series – is going to help you to understand.
The journal vs. the general ledger
An accounting journal is the record that keeps accounting transactions in chronological order (i.e., as they occur), while the general ledger is a record that keeps accounting transactions by the account – see our previous post on the chart of accounts [Bookkeeping Beginner Basics: The Chart of Accounts] if you need help understanding what the term ‘account’ means in this context. Before computers, bookkeepers used to log all the financial transactions of a business in paper journals, and then at the end of the month transfer these journal entries into the general ledger, which was divided into various accounts that is now called the chart of accounts, and all the transactions were posted to these accounts using a method called double-entry bookkeeping.
Journal entries using accounting software
Today, however, accounting systems, such as MYOB, Xero, QuickBooks and the like, will automatically record most business transactions into the ledger immediately after the software prepares sales invoices, issues cheques to creditors, or processes receipts from customers, and as such you don’t have to create journal entries for most of your business’s transactions.
That being said, some journal entries still need to be processed, in order to record transfers between bank accounts and to record adjusting entries. You would need to make a journal entry, for example, at the end of each month to record depreciation or to record interest accrued on a bank loan.
Double-entry bookkeeping
If journal entries and general ledgers and the double entry bookkeeping method sound a bit too much, and you think you’d rather stick to the cash-based accounting method instead, prepare yourself for bad news: all businesses, whether they use the cash-based accounting method or the accrual accounting method, use double-entry bookkeeping to keep their books, and all accounting software applications, by default, are set up to adhere to the double-entry method, too. The double-entry bookkeeping method reduces errors and also ensures that your books balance, so as complicated as it may seem, it’s much easier in the long run.
If you still feel a little out of your depth, however, you can hire a reliable bookkeeper to manage your bookkeeping system and deal with all the journal entries and double-entry business for you, instead. Visit the National Bookkeeping website for to find a highly qualified bookkeeper whose experience and skills suit your business needs.
This blog post is part of our Bookkeeping Basics series, which are being published to complement our new educational guide, also titled Bookkeeping Beginner Basics, which you can download for free from the EzyLearn website.
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.
A lot of the time, however, people enrol in an Excel online training course or Xero online training course because they need to refresh a specific set of skills for their job, which means they don’t have the time to focus on other areas that don’t have an immediate relevance for their work.
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.
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.
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!
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 Accessyou get access to ALL versions and ALL FUTURE VERSIONS as we continually update them — at no extra cost!
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.Continue reading Can You Trust Online Ratings and Reviews?
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.
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.
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.
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:
Operating activities: cash flowing in and out of the business from revenue-generating activities
Investing activities: cash flowing in and out of the business from the acquisition and sale of long-term assets
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.
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.
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.
A bookkeeper who’s certified in a particular accounting software may not mean that much for your business. Better to have someone who is simply a good bookkeeper. Period.
Now that virtual bookkeepers have become more common, lots of business owners have started selecting bookkeepers based on their affiliation with an accounting application. Such bookkeepers are often called a Certified Advisor (Xero), Pro Advisor (QuickBooks) or Certified Consultant (MYOB). But are they really the best bookkeeper for your business?
What are Certified Advisors, Consultants and Pro Advisors?
In a nutshell, a certified advisor, consultant or pro advisor is just an individual who has been endorsed by a software company because they’ve demonstrated a high level of knowledge and skill with a particular accounting product.
Hiring a bookkeeper who’s been endorsed by MYOB, say, means you shouldn’t have to worry about whether your bookkeeper has set up your accounting package correctly, or whether they’re using the correct codes. What it doesn’t guarantee, however, is that each consultant or advisor is a highly experienced BAS or tax agent, as the certification relates to their software knowledge only.
Find a highly qualified BAS or tax agent instead
Sure, a bookkeeper who’s experienced in your accounting package is important. It’ll help keep your bookkeeping bill down because they’re able to perform certain functions quickly, while your accountant shouldn’t need to fix any errors, either. But that’s only providing that they’re as knowledgeable in Australian tax as they are MYOB or Xero or QuickBooks.
Unfortunately, however, the two aren’t mutually exclusive. So instead of focussing on a bookkeeper’s software experience, it’s more beneficial to ensure they’re qualified BAS and tax agents, with either a Certificate IV in Bookkeeping or higher.
If you don’t get a bad reference from their current and former clients, then there’s a pretty good chance they’re proficient in the major accounting packages, and if they’re not, most bookkeepers will tell you upfront.
Get the accounting package that’s best for your business, not your bookkeeper
There are lots of reasons a bookkeeper would choose to become certified with a software company, the biggest being that they get their accounting software for free and receive a commission for each new client they sign up to use the accounting package they’ve been certified with.
However, when you hire an independent bookkeeper who’s well-versed in a few different accounting packages, you’re more likely to get better advice about which accounting package is best suited to you and your business’s needs, rather than the accounting package that will generate income for your bookkeeper.
***
Are you looking to brush up your skills in cloud-accounting packages like XERO, MYOB or Quickbooks? We provide a range of online training courses in all of these packages at ONE LOW COST for ALL SKILLS LEVELS. Find out more.
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.
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…
Help us help you get your business financials set up right
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).
Employer Recognised & Trusted Online Training Courses
Subscribe for news, updates, tips and tricks
Popular Online Courses
Real Estate Agent, Bookkeeper & Accountant CPD Courses
Use our informative and logical
training courses,
micro courses, and
case studies
to learn how to use software relating to your industry in small, well designed learning experiences and get the CPD points you need to remain professionally compliant with your industry association.