Posted on 1 Comment

Cash Flow Forecasting and Reporting Apps for Xero

Do you know how happy your business is?

running cashflow reports in xero and exporting to excel
Cash flow is THE key indicator of your business’ health and happiness so it pays to know the tools that will help you run regular cash flow reports.

AS WE’VE WRITTEN NUMEROUS times before, cash flow is the best indicator of financial health. A cash flow report takes into account the money you have in the bank after you’ve paid all your suppliers, employees, made your loan repayments.

With cloud accounting software you can work remotely from home or anywhere and have up-to-date information. Continue reading Cash Flow Forecasting and Reporting Apps for Xero

Posted on 1 Comment

Top 3 Expense Applications for Xero, QuickBooks and MYOB

best-apps-for-myob-xero-quickbooks

Get your financial software working harder

best-apps-for-myob-xero-quickbooks
There are a number of apps which link with Xero, MYOB and Quickbooks to help you closely and seamlessly track ALL your business expenses.

WE PREVIOUSLY WROTE ABOUT using Expensify and Xero to do the grunt work of your account reconciliations. We’ve also touched on how Expensify works for retail shops, online shops and hospitality businesses.

This time we’re looking at other expense applications that not only integrate with Xero, but other platforms like MYOB and QuickBooks, too. (For the record, every transaction Expensify does with Xero, it also does with QuickBooks; and also for the record, we not only provide online training in Xero [all levels for one low cost] but MYOB and Quickbooks too.)

Here are some other expense tracking app integrations.

Continue reading Top 3 Expense Applications for Xero, QuickBooks and MYOB
Posted on 1 Comment

Expensify, Xero and Your Retail Shop

Record retail inventory quickly

using-expensify-and-xero-for-a-retail-shop-outlet
Keeping track of expenses just got a whole lot easier.

IN A PREVIOUS POST we discussed how Expensify, an app which you can link to your Xero accounting software, can help businesses like yours’ keep track of expenses easily, accurately, and securely.

And while it’s a great expense app for professional services businesses or tradespeople, Expensify is also great for retail and online shops or hospitality businesses.

Input data and send to Xero

Shops and hospitality businesses require inventory or stock — and lots of it. But it results in an accounting and bookkeeping nightmare at the end of the month when it needs to be entered into Xero and then recorded against sales. Of course, we suggest business’ try to reconcile their transactions more regularly than just at the end of every month.

Take a photo of bills and invoices from suppliers and upload them to Expensify, which will input all of the data and then send it through to Xero.

Create expense reports

Online and offline retailers don’t have to worry about this too much unless they also produce their own products, but for cafes and restaurants that host functions or cater for events, separating the expenses directly related to those functions and events is an important way to track their profitability.

Automatic approvals cut bookkeeping time

By turning on the automatic approvals feature and setting expense rules, you can cut your bookkeeping time by having recurring or trivial expenses automatically approved and sent to Xero, so you can spend more time on the complicated ones that require closer inspection.

By keeping an eagle eye on your expenses using Xero and Expensify you’ll be able to see precisely where your business is most profitable and where it’s not so you can modify it accordingly.

***

Our Xero training courses will show you have to track expenses in Xero and how to connect third party apps to your Xero account. We offer ALL SKILLS LEVELS for ONE LOW PRICE. Find out more.


Social Media and Digital Marketing online training course_comp

Are you in business as a bookkeeper, tradesperson, retailer, trainer or real estate agent and want to stand out from the crowd? We can teach you the online marketing techniques to help you do just this! Check out what’s included in our comprehensive Social Media and Digital Marketing online training courses.


 

Posted on 2 Comments

Financial Reporting with Expensify and Xero

How Expensify can link with Xero

learn xero online training learning videos
Are you deducting everything you could be? Perhaps you need an app to help you.

WE’VE TALKED IN THE past about what a life saver daily reconciliations can be, and why some businesses could benefit from reconciling their account daily, twice weekly, or at least, on a more regular basis than once a month.

The expenses your business incurs form deductions that reduce your taxable income, so making sure you’re recording them accurately — and then storing them securely too — is an important part of your business remaining compliant.

An online software program like Xero will enable you to enter your expenses and transactions; and you can also use an app to automate the process for you, like Expensify. Bank Feeds also make this task easier and enable you to work remotely from home. Continue reading Financial Reporting with Expensify and Xero

Posted on

Are You Making these GST Mistakes in Your Bookkeeping?

find a good local or remote bookkeeper

Being Jack of All Trades can land you in hot water with BAS

find a bas agent in your local area
Don’t submit inaccurate financial documents by trying to do everything yourself by way of bookkeeping.

IT’S PERHAPS EASIER TO do your own bookkeeping these days than it used to be; particularly if you’re using a cloud accounting program like MYOBXero or QuickBooks, which are among the easiest, yet robust, accounting applications currently on the market.

But even so, there are many aspects of Australian tax that, while accounting software makes it possible to carry them out yourself (like business activity statements, for example), it’s not a good idea unless you really know what you’re doing. Here are the three GST mistakes nearly every business owner makes in their bookkeeping.

Continue reading Are You Making these GST Mistakes in Your Bookkeeping?
Posted on 2 Comments

Using Excel for Client Databases

Excel does great CRM

learn excel cheap online learning training course videos
Managing large amounts of client and business data is not only possible, but also something you can learn fast and with ease with the help of our comprehensive range of online Excel training courses – covering all skills levels.

MICROSOFT EXCEL IS THE most widely-used spreadsheet application in modern computing. It’s ubiquity means most people use Excel on a regular basis, despite never having had any formal training in its many, many, MANY functions.

While updating the content for our Excel training courses recently, we were reminded of just how powerful Excel remains, and in particular, how useful it is for small businesses.

With its 2013 release, Excel got a serious update, which made it the perfect application to create and manage client and customer databases. Although there are many CRMs available on a subscription that provide the same functions of a database created in Excel, just in a more visually appealing format, they often lack reporting and analysis functions, requiring you to export your data in a Excel sheet anyway.

Flat file databases

Excel’s original ‘flat file’ database still remains the easiest and most basic database to set up and manage, and depending on your business and how you’ll use your database, a flat file database may be all you’ll ever need. If set up correctly, a flat file database will allow you to easily import your customer data into Word, your accounting software, an email marketing service, and so forth.

Relational databases

A relational database is a database that’s structured to recognise relations among the information stored in them. Microsoft offers a relational database program, called Access, which is available with Microsoft Office Professional or higher, or can be purchased separately.

Alternatively, you can create your own relational database in Microsoft Excel, providing you have the 2013 version or newer. When Excel got its update in 2013, it became easier to link charts and cells and to perform searches — all essential features if you’re working with large amounts of business data.

Correct Excel set up is crucial

Once Excel has been set up, it’s as easy as it is powerful to use. Of course, the key is to set it up correctly, so you can avoid errors or having to re-enter large amounts of data to make the format suit another third party software application.

***

Creating and managing databases is included as part of our Advanced Microsoft Excel training courses — and you receive access to ALL OF OUR COURSES, including ALL SKILLS LEVELS for ONE LOW PRICE. You can even start your Excel journey with our FREE Beginners’ Excel Course Workbook. Read more about our beginners’, intermediate and advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow!


learn to use excel online training course videos cheap best

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.


 

Posted on

A Close-Up Look at a Listed Company and How it’s Performing

We show you what financial data really reveals

how to read financial reports
There’s more to profit and loss than meets the eye: Sometimes a company’s losses outweigh its revenue, but it doesn’t mean that company is in a bad position.

AS A BUSINESS OWNER you’ll need to run regular financial reports (never more so than at the end of financial year) to ensure your business is in good shape. Understanding what each element of a financial report means is critical to your business’s financial health.

You’ll learn to run and interpret financial reports in our Xero, MYOB and Quickbooks training courses, but we’re just going to look at a couple of areas of most importance.

Close up: BuyMyPlace’s financial results

BuyMyPlace is an ASX-listed service that allows property owners to sell their properties without a real estate agent. Because it’s a publicly-listed company, they have to make all of their financials public too.

As such, we got hold of their most recent financial results for the first half of financial year 16/17.

It’s not the most detailed financial report, probably because the company itself is still in its early stages — there’s actually a good argument against early stage ventures listing on the stock exchange, but that’s fodder for another post.

Revenue vs. losses for the period

The good news for BuyMyPlace is that its revenue increased 129 percent on the prior comparative period (PCP) to $1 million for H1 FY16/17, up from $133,518 in H1 FY15/16.

That’s an impressive leap in revenues in just 12 months, however, the BuyMyPlace financial results also reveal that the business made an even greater loss of $1.7 million, an increase of 1205 percent on the PCP.

A closer look at the report shows that, while the losses increased more than a thousand percent, it was due to an increased investment in marketing and advertising — principally on TV spots which totalled $517,723 compared with $98,578 the year prior.

This resulted in an 80 percent increase in the number of listings on the site (that is, the number of people using BuyMyPlace to sell their home), while order value increased 27 percent (people who were choosing more expensive packages).

BuyMyPlace is in good health

Although this business recorded losses that outweighed its revenue, BuyMyPlace is still in good financial health.

The report also shows that it has over $4 million in cash and cash equivalents, and only a little over $600,000 in liabilities. Although the liabilities have increased, it’s not due to taking on any additional debt — indeed, BuyMyPlace has paid down all of its loans — but was instead due to a 786 percent increase in staff salaries and, as a consequence, an increase in staff provisions and benefits — i.e., sick and annual leave.

Strategy for future growth

Not many homeowners actually want to sell their properties themselves — one estimate puts it at around 7 percent of the total number of homeowners. However, most people do want greater clarity around how the process works (including fees and commissions) — even if they still want assistance selling their homes.

Perhaps realising this, or perhaps in response to increased competition in the fixed-fee real estate services (see: Purplebricks, Settl, etc), BuyMyPlace also launched its own full service package, giving homeowners access to a real estate agent to sell their home for a fixed fee.

This will enable BuyMyPlace to capture a greater volume of homeowners, who are looking for a low cost alternative to sell their homes, but who don’t want to do it entirely themselves.

The other strategy for growth: increasing listing depth revenues.

At some point, BuyMyPlace will stop growing its market share. Or, in other words, the market of people looking for a low-cost option to sell their home will be tapped out.

But as a business, and as a publicly listed one, BuyMyPlace will need to keep growing its revenue, not merely keep it steady. It’ll need to do as other real estate services, such as REA Group and Domain have done, and increase listing revenue depths, by selling more expensive packages to customers.  

BuyMyPlace will need to find additional value it can sell to customers, without necessarily increasing its own expenses to do so — or putting up its prices, which a business can usually only do once it’s cornered about 65 percent of the market, and BuyMyPlace is a long way off that yet.

***

That’s a lesson for every business owner out there. And it’s something we cover in our online Business StartUp Course.

You’ll learn how to run and understand the financial reports for your business in our Xero and MYOB training courses. You can also learn about strategies for business growth in our Business StartUp Course. Or for more information, visit our website.


learn to use excel online training course videos cheap best

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.


 

Posted on

Self Managing Your Superannuation in Excel

Skipping super can be a thing of the past

super payments xero online training learning course videos
We feel your pain! Often businesses lack the cash flow to make super payments, but you always have to pay them in the end…

WHEN YOU’RE SELF EMPLOYED you are responsible for managing your taxes and your superannuation — the latter of which many business owners let go by the wayside. It’s almost always because they don’t have the cash reserves to contribute to their super fund regularly enough.

Just as you would create a budget to make a business investment or asset purchase, you can use Xero and Excel to determine how much super you should contribute on your behalf, and then make the payments.

Run a cashflow report

You’ll learn how to run a cashflow report in our Xero training courses. This report will show you the periods when cashflow is liquid and when it isn’t. Run a cashflow report for a couple of different periods, and export them into Excel. This will give you a better idea of trends and cycles in your business.

You can also use a cashflow report to determine your income before taxes, expenses, and so forth. Superannuation is determined based on gross earnings — or revenue — so you should use this figure to work out your super contributions. This is especially important before end of financial year!

Determine super contributions

At time of writing, the superannuation guarantee is 9.5 percent of your gross revenue, before taxes, expenses, etc. If you set your prices correctly, you should have already factored this 9.5 percent into your prices or hourly rate. If you haven’t, you ought to consider revising what you charge customers and clients.

If you were an employee of a business, your employer would be required to make super contributions on your behalf, at least each quarter. Because you’re self-employed and self-managing your super contributions, you can make them as frequently or infrequently as you like, so long as you’re contributing the correct amounts. (Speak to your accountant or financial advisor, however, if you’re salary sacrificing above the minimum amount — this may affect your tax.)

Make super contributions

Once you’ve determined how much you should contribute to your super fund each quarter, refer back to your cashflow report and to the periods where your cashflow is especially liquid. Are you able to make your contributions each quarter easily, and without compromising your business’s liquidity? Would it be easier to make smaller, more regular contributions?

The decision is yours.

Use Xero to make your super contributions. Xero is connected to a superannuation clearing house, and if you’ve been using to Xero to pay yourself a wage, it’s the easiest way to do so. If you’re not using your accounting software to pay yourself a wage, you can make the payment directly out of your bank account, however, you’ll need to track this in Xero for taxation purposes.

***

Our Xero training courses will show you how run cashflow reports and make wage and super payments, while our Excel training courses will also teach you how to create business budgets and forecasts. Visit our website for more information.


learn xero myob excel cheap online training courses videos

At EzyLearn we offer online training courses to help you up-skill and find employment. Choose from our range of cloud-based online accounting software courses, to business start up and management courses, to marketing and sales courses, or update and further your skills in a range of Microsoft Office programs (ExcelPowerPointWord) or social media and WordPress web design). 


 

Posted on

How to Make a Capital Purchase That Won’t Affect Your Cash Flow

A Chattel Mortgage Can Help Keep Your Business Cashflow Under Control

chattel mortgage learn xero online training course
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.

***

You’ll learn how to record an capital purchase, whether it’s been bought on hire purchase or a chattel mortgage, in our Xero Daily Reconciliations Course. You can find out more or enrol today.

Xero online training course

At EzyLearn we offer many online training courses to help you up-skill and find employment.

Choose from our range of cloud-based online accounting software courses, to business start up and management courses, to marketing and sales courses, or update and further your skills in a range of Microsoft Office programs (ExcelPowerPointWord) or social media and WordPress web design


 

Posted on

Announcement: Xero Bank Recs and Journal Entries

Bank Recs are a pain in the !@Accounts#$

Bank Statement for Bank Reconciliation Courses in MYOB, Quickbooks and XeroAlthough the daily data entry is a frustration for many business owners and manager, particularly if you are quoting, ordering and invoicing regularly, the bank reconciliation is the most frustrating for bookkeepers, BAS agents and accountants because they need to make sense of EVERY transaction and make sure it is accounted for correctly. Xero bank reconciliations are made easier with bank feeds and today we announce that this course is available as part of our All Xero Courses for 1 Price Offer!

Bank Statements Reveal Much

We base our bank reconciliation course development (for Xero and Quickbooks) on our MYOB Bank Reconciliation Course and I was reviewing the contents of this course a couple weeks ago.

The thought that stuck in my head the most was “Wouldn’t it be great to design my own bank statement! A bank statement that I would like to see for my business each month” but that is a topic for another “business development and goal setting type blog”.

The important thing for bookkeeping students is that this bank statement includes most of the transactions that you’ll come across each month including interest, capital purchases, loans etc that you’ll probably need to check and make sure they’re coded correctly.

Xero and all cloud accounting programs make bank reconciliation easier because they enable you to import bank feeds directly from your bank. This saves a lot of the typing involved in data entry but you still have to get the codes right.

Xero 513 Bank Reconciliation Course

Learn more about what is included in this course at our Xero Bank Reconciliation Course landing page. In this course we introduce a new “character” in our course design – Jerry. Jerry is an ordinary man who decides to go into business because he loves talking to and helping other people but he’s not that tech savvy (or accounting savvy) so he makes a lot of the mistakes that many other business people make when they are starting out for the first time.

If you are an existing student enrolled into our Xero Courses, just contact support and ask them to enrol you into the Xero 513 (Bank Recs) course – there’s not charge for you if you are within the 12 months course access period.

Stay tuned for more updates to our Xero and Quickbooks Training Courses.

Posted on 2 Comments

Video: Receive an Automatically Discounted Price for Online Course Enrolments!

Specials and Summer Training

2016-12-20 How to use the EzyLearn website to get discounts and special pricingIt’s Christmas time and we’ll be open every day (except the public holidays) which means you can make contact with questions or support during your course.

But best of all, we’re offering a fabulous special offer with a saving of over $300. Check out the quick video below which shows you how to get $663 dollars worth of training for just $296a saving of $337!

All you have to do is choose your courses at our Online Course Enrolment page and the discounts will be applied automatically.

Get New Skills for A New Year!

discounted Myob QuickBooks online courseWith the New Year coming fast we find most of our students are looking to change careers and/or up-skill so as to feel confident with their computer skills in job interviews and the like, so our current special offers will train you up to be your best, cheaply. Here’s all you need to do:

  1. Choose Microsoft Excel course (12 month’s access, all 9 courses and Certificate).
  2. Scroll down to the discounted courses section to see the Xero Training Course available for $30 less.
  3. Scroll down further to see the Microsoft Word Course (12 month’s access, all 9 courses and Certificate), which is normally $267 is now FREE
  4. Tick the box next to “Yes, I have a discount voucher code” and enter 8881818 to receive a further $70 discount off the Microsoft Excel course!

If you don’t have the time right now, don’t worry, you’ve got 12 months to complete all these courses at your own pace — so just enrol now to get the current special offers.

Watch this video to see how to get the discounts

New Online Courses for the New Year

It’s been a very busy year for new course creation and we’ve just launched two new courses that are all based on new online cloud-based services in bookkeeping and marketing/advertising. Read about them here:

QuickBooks Online

Provide quotes on your tablet computer, convert them to invoices when you get the order and take photographs of your receipts for expenses — works on your smartphone too. These are the features of America’s most popular accounting software program that is now aggressively promoting itself to Australian small businesses.

And what do we think? We believe QuickBooks is good software — find out more about our Intuit QuickBooks Daily Transactions Course.

Our New Digital & Social Media Marketing Course

Facebook and social media online training course
Tired of struggling to post consistently on Facebook and other social media sites? We’ve had a WordPress course for several years to teach you how to create your own website and blog, edit images, and optimise it for search engines (like Google). But if you’ve ever struggled with fleshing out a Facebook Page, or want to start promoting yourself or your business in social media, try our Digital Business and Social Media Marketing Courses.

We show you what you should include on a modern day website as well as including Facebook Page, Content Marketing and Facebook Advertising training (which we used to help Derek Farmer show up on Page 1 in Google for the competitive Cammeray Real Estate Agent search query).

***

Most of all, from all of us here at EzyLearn, HAVE a FANTASTIC and SAFE Christmas — doing things you love!

Online computer training Christmas specials_comp

 

Posted on

Is Your Resume Costing You a Bookkeeping Job?

It’s easy to spot bad Microsoft Word skills

203 Microsoft Word Beginners Courses for sales letter, flyers, resumes, cover letters and tender proposalsWe’ve had several hundred bookkeepers Pre-Qualify for our National Bookkeeping, Bookkeeper Directory and most of them upload a resume demonstrating their qualifications, experience and references but I’m baffled at how bad the formatting is in these resumes!

To help our students do the best job presenting themselves on paper we’re including the Microsoft Word Course for free when you enrol into either the MYOB Courses or Microsoft Excel Courses (when you choose the all courses and 12 months access with Certificate option). That’s a saving of $267!

Resume writing tips for bookkeepers

Here are some tips we’ve published in the past:

The problem with making mistakes with your Microsoft Word formatting is that questions could come up in an interview. The Interviewer might throw in a question about software skills, particularly if you’ll be writing some detailed reports or proposals, forecasts etc. in the new job.

Online Training Course special offers for MYOB, Xero, Excel, Word and more
Click the image to see our current special offers!

Here are some extra tips for Bookkeeper resumes

Most of the Microsoft Word skills you need to write a good resume are covered in our Word Intermediate Courses, but we’re including the entire 9 courses so you can become a power Microsoft Word user! Here are a couple other things to think about when writing you resume:

  1. Include an image – it makes you stand out and brings the reader closer (make it a selfie where you’re smiling 🙂
  2. Use tables or “Set tabs” to make columns line up
  3. Headers and Footers demonstrate a sophisticated knowledge of Word
  4. Include your full name and desired role in the filename (we’re all using files these days! use it to your advantage)

The last one about filenames is a big one because if interviewers are like me they’ll put all the resumes for one role into a folder and I find myself renaming most of them!

FREE Microsoft Word Workbook

We spend a lot of time on marketing so I assume that you know we offer free samples of our training material, but I should mention again that the Microsoft Word sample is actually the entire Word Beginners Course 201 Training Workbook, make sure you get it! Get it now.

Quickbooks Course Update

intuit-quickbooks-accounting-software-training-courses-logoIt’s been a while in the making, but we have the final draft of our Quickbooks Course workbook! Unlike some training companies, we write up a detailed course story based on a real business scenario and use that as the basis for recording our screen videos that demonstrate how to use the software. We’ve had a huge number of Course Alert Registrations and they’ll ALL receive a free copy of the workbook, so if you haven’t already registered do it NOW!

EzyLearn Wholesale Partner Update

earn money working from home using and teaching how to use MS Office, MYOB, WordPress, Facebook, Xero and moreI made a brief reference to our new Enrolment Voucher system in a recent post about BAS deadlines and we’ve got an update. The new enrolment voucher system is now in beta testing which means we’ll shortly be inviting EzyLearn students who love our courses to receive a massive wholesale discount on selected courses. Make sure you register your interest.

Posted on 1 Comment

Bad Payers Cost 12 Working Days to Collect $13,200

flowchart of the cash conversion cycle

Credit Management is an Extra Job

credit-management-training-assessment-management-and-enforcement

I’ve always believed that as soon as you offer credit you’ve got yourself another business – a credit management business.

When we first created our MYOB Daily Transactions course we designed it to take students through the cashflow process of where money goes when it first leaves your bank account and these are the main steps:

  1. Money in the bank (cash asset)
  2. Buy stock (inventory asset)
  3. Products sold on account (accounts receivable asset – Trade Debtors)
  4. Customer pays their account (cash asset)

The interesting part of this business process to me is the marketing (choosing the products, pricing, marketing message and advertising) and the credit management to get the money back.

Continue reading Bad Payers Cost 12 Working Days to Collect $13,200
Posted on 1 Comment

BAS Service deadline looming – BAS Audits, self assessment and benchmarks

BAS Service, compliance anxiety and cash-flow

MYOB GST, reporting and BAS training coursesIt’s that crazy time when the end of financial year TAX and quarterly BAS periods combine to cause compliance anxiety for business owners and managers if they don’t have a handle on their bookkeeping processes and accounts. This is often caused by not having the best team available for all the tasks required and I spent some time during the week speaking with Tracey our MYOB, Xero and Quickbooks Trainer from Rockingham in WA about the different levels of bookkeepers and whether they could complete tasks relating to a BAS Service. Here’s some of the information that I thought you’d find useful.

Getting receipts as evidence

The biggest issue that many bookkeepers experience is getting information from business owners, particularly small businesses that are stretched between:

  • the work they need to do every day
  • Keeping and filing the financial records like receipts
  • Getting the financial records to a bookkeeper or accountant

I’ve written in the past about the ways that small businesses file their receipts as well as cloud technology like Shoeboxed (who now seem to prefer selling their services to accountants and bookkeepers and have removed the educational video that demonstrated how the software works!), but Quickbooks Online has a downloadable app that enables business owners to capture a photo of each receipt for each transaction and if business owners utilise this function they can save a lot of money in data entry and evidence of expenses that could be expected as part of a BAS audit by a BAS agent.

BAS Audits, red flags and tricky GST codes

I’ve mentioned in a previous blog that you can hire a cheap bookkeeper to take care of your data entry and only use the services of a more expensive bookkeeper (ie. BAS agent) for purposes of confirmation of expenses and the GST components of these expenses. In this case a simple BAS audit involves witnessing these source documents to confirm that there is no error in calculating the money owed to the ATO. If you’ve had any of the following transactions you’ll probably need to pay close attention to the information in your BAS lodgement and mention them to your bookkeeper:

  • Purchasing a motor vehicle
  • Motor vehicle expenses
  • Real property purchase
  • Any purchase coded as a GST-Free transaction
  • Low value purchases (under $82.50) that are coded as GST free
  • Purchase of second hand trading stock
  • Hire Purchase contracts
  • Local fees and handling charges for imp

Learn more about BAS Audits by BAS Agents and the benchmarking and self assessment that ATO use and recommend

TIP!: Bank feeds can cause more work!

I’ve written a lot about bank feeds in the past and included a blog post about how bank feeds work in MYOB and Xero. Bank feeds can be a real time saver because they automatically bring your bank transaction records into your accounting software, but Tracey mentioned that in MYOB you should bring them in BEFORE you do any reconciliation tasks otherwise you may need to undo any reconciliation work you’ve already done so watch out for that!

Need One-to-One training or a QuickFix on MYOB, Xero or Quickbooks?

We did a lot of one-to-one training when we operated our physical training centres in Sydney and the training was often completed at our training centre (because we had it!). Now I’m thrilled to advise that we’re helping local bookkeepers in your area deliver MYOB and Xero training according to our profession course structures! To learn more visit the National Bookkeeping training page. You’ll also discover that our bookkeepers area also available to fix problems or lack of knowledge with the QuickFix service so check that out.

Coming up..

Here is what we are currently working on and what will soon be published or made available at our LMS.

  • Guide to Credit Management (aspects of a business and your accounting software where you can tighten your credit management processes). We’re creating this guide in conjunction with the local bookkeeper at National Bookkeeping
  • Xero Course training material update (workbooks and videos are being updated and added as we speak so stay tuned for more announcements soon
  • Wholesale training course and partner offer – we’ve beefed up our Enrolment Voucher system to help more business buy cheap courses
Posted on 1 Comment

Xero now looks like Quickbooks Online and MYOB needs an upgrade

Xero, Quickbooks and the plus button

xero-dashboard-is-starting-to-look-like-the-quickbooks-online-dashboard-xero
The Plus button in Xero

We’re currently completing new, updated content for our Xero courses and one thing stood out more than anything else – the PLUS button in the top right hand corner! If you are familiar with Intuit Quickbooks you’d immediately recognise that their PLUS in the top centre of the screen is how you access most of the software’s features and I’ve always liked how easy it makes navigating the software. If you compare the two of them you may think that the Xero software still has some way to come.

The other thought I had about this change is “how much will Xero change its user interface”? People get used to how to navigate around a software program (User Experience) and don’t want things to change too much and that has been a great feature about MYOB – their navigation has remained fairly consistent for two decades.

Will cloud services be upgraded like their computer software peers of the naughties?

Microsoft might be the inspiration for change for Xero because although most of the formulas and functions in Microsoft Excel remain the same, the way you navigate around the software changes every 3-6 years. This is a boon for the larger software training companies that charge extra for courses in the different versions (we include all versions for the one price of course 😉 but it can be frustrating for staff who have to re-learn how to navigate the software and their spreadsheets when the office software is updated.

xero-dashboard-is-starting-to-look-like-the-quickbooks-online-dashboard-quickbooks
The PLUS menu in Quickbooks has more features

While we are on the topic of upgrades and how annoying they are I received an email from my accountant to upgrade the MYOB version that we share so that she can access the files to work on them! I can say for sure that I once again felt that MYOB are behind the timeline as they fight to stay in control when looking at how they develop their software compared to the other accounting programs like Xero and Quickbooks where the software is updated and live.

Testimonials for Xero, MYOB and Microsoft Excel courses

On a different note, I asked our web guy to get some information about where our students are located around Australia and at the same time get some of their testimonials quotes onto our website. He’s not finished yet, but when I see the different suburbs from all over Australia I reflect on the same picture over 10 years ago when we were operating physical training centres in Sydney’s North Shore, Northern Beaches and Parramatta and our students were located within 20kms of each centre.

It’s a wonderful feeling to see students doing our courses from all over Australia but it’s even better when we see enrolments from UK, Canada, US and Hong Kong because it shows the true power of cloud based services.

When you want to become a Registered BAS Agent

Start a bookkeeping business not a franchiseLast week I wrote about starting a bookkeeping business while you are working your day job and I just want to add a note that may be very useful for those who want to become a registered BAS agent. National Bookkeeping offer a BAS lodgement service through our licensees and it is a great way for qualified bookkeepers (who have their Cert IV in Bookkeeping or Accounting) to work with an organisation and build up the hours they need to register as a BAS agent via the Tax Practitioners Board.