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

EXCEL: Other Data Sources You Can Use to Create a Pivot Table

The latest versions of Excel are jam-packed with new features!

learn online training excel cheap best online training excel course videos
How are your Excel skills? Brushing up or learning how to use Microsoft Excel as a business tool could see you brimming from ear to ear too.

WE’RE ALWAYS UPDATING OUR Excel training courses, and as we do so, we’re reminded of just how useful Excel continues to be for small business owners — particularly the latest versions of Excel which include a boatload of new features that make it easy to create and manage relational databases, which you can also use as the data source for a pivot table.

But supposing, for whatever reason, you don’t want to use an Excel database as your pivot table’s data source? Well, there are some other options to create a pivot table without manually entering the information into Excel first. Here are a few more data sources that you can use to create a pivot table in Excel.

Office data connection files

The office data connection (ODC) file extension was created by Microsoft and contains properties to connect to and retrieve data from an external data source. It contains a connection string, data queries, authentication information and other settings. Microsoft recommends that you retrieve external data for your pivot tables and reports using ODC files.

External relational databases

If, for instance, you’re using another relational database program, like Microsoft Access or Filemaker Pro, you can also import data directly from these programs into your pivot table, rather than manually entering the data into an Excel worksheet. In the case of connecting data from an MS Access database, you can do this quite simply by selecting Access from the ‘data source’ dialog box. For all other external databases, you would select the ‘from other sources’ dialog box and follow the steps in the data connection wizard.

Using another pivot table

Each time that you create a new pivot table, Excel stores a copy of the data for the report in memory, and saves this storage area as part of the workbook file. To use one pivot table as the source for another, both must be in the same workbook. If the source pivot table is in a different workbook, copy the source to the workbook location where you want the new one to appear. Keep in mind that when you refresh the data in the new pivot table, Excel also updates the data in the source pivot table, and vice versa. When you group or un-group items, or create calculated fields or calculated items in one, both are affected.

Create a database in Excel first

The easiest and 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.

***

Creating databases and pivot tables are part of our advanced Microsoft Excel training course, but you can start your Excel journey with our FREE beginners’ Excel course. Read more about our beginners, intermediate and advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow!


learn Xero online learning videos cheapest

Our Xero online training courses include EVERYTHING for ONE LOW PRICE. Furthermore, if you select our Lifetime Membership option, you’ll have LIFETIME access to our ongoing course updates. All EzyLearn courses are accredited by the Institute of Certified Bookkeepers (ICB) and can be counted towards Continuing Professional Development (CPD) points. Find out more about our Xero online training courses. 


 

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 1 Comment

Explaining Why Excel’s Pivot Tables are So Mighty!

No amount of data is too big for Excel’s pivot tables

using microsoft excel 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.

***

Creating databases and pivot tables are part of our advanced Microsoft Excel training course, but you can start your Excel journey with our FREE Beginners’ Excel Course. Read more about our Beginners’, Intermediate and Advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow! We cover ALL levels for ONE LOW COST.

And with EOFY looming, be sure to take advantage of our specials!


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 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

What to Do When You Have More than One Income Stream

Why it’s important to track your income streams

keep-track-of-more-than-one-income-stream-using-excel-myob-xero-learn-online-training-course-videos
It can be easy to lose track of separate income streams; Excel is a great tool for monitoring which work your income is coming from.

IF YOU’RE AN INDEPENDENT contractor, or you’re a full-time employee about to start up a side business, then you need to be able to keep a good track of all your income streams. There are a couple of reasons for this and both of them relate to tax.  Continue reading What to Do When You Have More than One Income Stream

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 1 Comment

Keeping Tabs on those ‘Little’ Monthly Expenses

Why Excel is Great for Keeping Track of Your Spending if You’re Self Employed

excel online training course using excel for monthly expenses sheet
That take away coffee that you buy each morning should be added to your business expenses sheet; even if not claimable it shows where your money is going.

WHETHER YOU’RE ABOUT TO start your own bookkeeping business, or whether you work as an independent contractor (even if you’ve been doing this for a while), it’s really important to know how much you’re spending each month.

Your Xero, MYOB or QuickBooks accounting software will help you with some of this, but the very best way is to create an expense or spending sheet in Excel — which we teach you how to do in our Excel training courses — as this gives you a far more detailed look at your expenses and spending.

Not all your expenses are 100% business ones

Sometimes you can’t claim 100 percent of your expenses as business ones — the costs of running your car, home internet, rent, utilities, etc — but you should nevertheless keep track of your spending on these items because it will affect your cash flow.

That’s why keeping an Excel spending or expense sheet is a good idea for contractors and home-based business owners. You don’t want to enter your home internet into your accounting software as a business expense, if only 30 percent of it is used for business purposes, but you still need to keep track of it, so you can manage your cashflow.

Monitor frivolous spending

One of the things we love about using Excel to track your expenses and spending is that every little expenditure is right there, in plain view.

This isn’t the case with Xero or MYOB or other accounting software. Your expenses are hidden away, and you have to run a report to get a good breakdown on where your money is going.

Not so with Excel,. If you buy a coffee every morning, it’s right there, in a category you can label as “coffee”.

Now, we’re not saying that coffee is frivolous. Far from it. Many of us need coffee just to function (!) but there are lots of small things we spend money on every day, week, month that add up. When you’re self-employed you need to keep an eye on these “little” things.

Sometimes, you’ll find that you’re spending lots of money each month on subscription services that you’re not even using. Eliminating $15 a month here and there makes a big difference.

Create as many categories as you need

That’s the other great thing about using Excel to track your spending: You can create all the expense categories you like.

Of course, not everyone wants to track each and every expense right down to their last bag of jelly beans — that actually would be a little ridiculous — and for most the most part, you can lump your groceries into a category for discretionary spending, but there are some things you might want to separate out — movie tickets, money spent on lunches and dinners, and so forth.

These things tend to add up, and if you want to keep an eye on them, separating them out is the easiest way to do that.

Back to those business expenses

Each fortnight or month or however regularly you complete your bookkeeping, you can easily add in those business expenses into your accounting software — or your bookkeeper can.

Remember, if you spend $60 a month on internet, but only 30 percent of its use is for business purposes, you should only add $18 a month as a business expense in your accounting software. In your Excel expense or spending sheet, however, you’ll put the full $60 in, as you need to have the money in the bank to cover this expense each month.

***

You can learn how to create and manage your expenses or spending in our Excel training courses, where you’ll be able to create your own spending or expense sheet. Visit our website for more information.


learn Xero online learning videos cheapest

Our Xero online training courses include EVERYTHING for ONE LOW PRICE. Furthermore, if you select our Lifetime Membership option, you’ll have LIFETIME access to our ongoing course updates. All EzyLearn courses are accredited by the Institute of Certified Bookkeepers (ICB) and can be counted towards Continuing Professional Development (CPD) points. Find out more about our Xero online training courses. 


 

Posted on

Recording BAS Refunds is a Cinch in Xero

Understanding BAS refunds

accounting for BAS refunds with Xero_comp
No need to be puzzled: Our online Xero courses can walk you through how to account for a business loss or BAS refund from the ATO.

IF YOUR BUSINESS RECORDS a loss for a quarter, you may be entitled to a BAS refund from the ATO. In a new workbook in our Xero training courses, we look at what happens when a business changes strategy and when this change results in a loss. 

Businesses that record a loss sometimes receive a BAS refund from the ATO. You may have the full amount returned to you, or part of the amount.

Are you receiving a full BAS refund?

When you lodge your BAS paperwork, you either owe money (a tax debt) or the ATO owes you money (a refund). Sometimes you mightn’t receive a refund or the refund may be less than you thought.

This could happen if the refund is offset against a tax debt you already owe, or perhaps the refund is being retained by the ATO until you provide further information — which could be as simple as providing the correct bank account details. The ATO provides information about both of these scenarios on their website. Regardless of whether the whole amount, or part of the amount is returned, you’ll need to account for this in Xero.

Create a ‘receive money transaction’

If you do receive a BAS refund, you’ll need to record this money (that isn’t due to a sale) by creating a ‘receive money transaction’ in Xero. Our Xero training courses show you how to do this.

***

Our online Xero training courses show you how changing your business strategy could result in your business making a loss — and how you can account for this. Our Xero courses also walk you through how to lodge and record BAS refunds. For more information, visit our website or go direct to the courses.


learn Xero online learning videos cheapest

Our Xero online training courses include EVERYTHING for ONE LOW PRICE. Furthermore, if you select our Lifetime Membership option, you’ll have LIFETIME access to our ongoing course updates. All EzyLearn courses are accredited by the Institute of Certified Bookkeepers (ICB) and can be counted towards Continuing Professional Development (CPD) points. Find out more about our Xero online training courses.


 

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

Marketing for When Your Business Strategy Changes

Where lead generation services are useful

lead generation services
Using a dedicated lead generation service can be more useful than advertising but the quality of the leads may be questionable.

CHANGING YOUR BUSINESS STRATEGY to include additional services will require an additional investment in marketing if you are to make this successful. In terms of simply paying money to advertise your additional services, as you’re probably already aware, advertising doesn’t always yield immediate results. Therefore you might consider spending money on a lead generation service.

We cover how to account for marketing and lead generation costs in our Xero training courses, which includes a new workbook that looks at what to do when your business strategy changes. Continue reading Marketing for When Your Business Strategy Changes

Posted on

When Your Business Strategy Changes

There are websites that make it easy to change your business name

changes in business strategy xero cheap online learning course
Having a plan rather than changing your business strategy in an ad hoc fashion, ensures greater success of your business going forward.

PLENTY OF BUSINESS OWNERS change their business strategy, but what makes this successful? We say, above all, planning and a willingness to change the ordinary operations of your business. In a new workbook contained in our Xero training courses, we take you through the steps you would take in Xero to affect a change in business strategy.

In this blog post, we’re going to look more generally at some of the things you might need to do if you were making a change to your business strategy — even before you would start making these changes in your accounting software.

Business name change

A change of business strategy and direction may warrant a business name change. As a basic example, a builder who begins offering plumbing, electrical, and handyman services should change their business name from John’s Building Services, for example, to John’s Building and Home Maintenance Services.

If considering a business name change, visit the ASIC website. There you’ll be able to register a new business name and make sure one you’re thinking of doesn’t already exist. ASIC doesn’t allow you to update or change your business name, but provided you’re operating your business under the same structure — i.e., sole trader — there’s no limit to the number of business names you can register and assign to your ABN.

In April this year, the business.gov website launched a new Business Registration Service, which although still in Beta, allows you to easily and quickly apply for a business name, ABN, company, and tax registrations for free. At the moment it’s only available for new businesses — whether they’re sole traders, partnerships, companies or joint ventures — but it’ll soon be rolled out to existing businesses, trusts, and superannuation funds.

Registering for GST

Many contractors don’t register for GST because they do a combination of contract work on their ABN and TFN. Provided their business doesn’t generate $75,000 per year or more, they won’t have to register for GST, even if they do earn more than that by also working as a contractor on their TFN.

If the change in business strategy means your business is going to generate substantially more than $75,000 per year, or even if your suspect it may get close to it, you should register your business for GST.

You can register for GST via the ATO’s Business Portal. Registering for GST does mean your business will need to lodge regular business activity statements. This is additional compliance that can yield fines for late or inaccurate lodgements.

If you’d like to try and defer registering for GST for as long as possible, run a profit and loss statement in Xero and compare your current revenue with the estimated additional revenue your new business strategy will generate.

If there’s good, safe margin between your projected income and the $75,000 GST threshold, you can hold off.

You can learn what you need to implement the financial side of your changed business strategy, plus how to run profit and loss statements, complete and lodge business activity statements and much more in our Xero training courses. For more information, visit our website.


learn Xero online learning videos cheapest

At EzyLearn you can choose from a range of XERO online courses, depending on your skill level — or you can access ALL courses for ONE LOW PRICE. All our courses are accredited by the Institute of Certified Bookkeepers (ICB) and can be counted towards Continuing Professional Development (CPD) points. Find out more about our Xero online training courses. 


 

Posted on

A Great Trick for Getting Rid of Nerves on a Job Interview

Who’s interviewing whom?

The truth is that you’re interviewing the company as much as they are interviewing you. When you look at it this way, the job interview suddenly becomes less daunting.

DO YOU KNOW THERE is no reason to find a job interview nerve wracking, even though so many people do. It’s simple enough to understand why. People put a lot of pressure on themselves to give the best impression and come out as the successful candidate. And look, these things are important, no argument there, but together the pressure to give a good impression AND win the job itself, can conspire to turn you into a “yes man” (or woman).

A job interview is about finding a suitable candidate for a position available at a company. This is not a one way street. As much as you need to give a good impression, so does the company, and if you look at it that way — that you’re interviewing them as much as they are you — it takes the pressure off A LOT.

Ask questions

I don’t just mean at the end when they ask if you have any questions — honestly, you’re probably not likely to have any questions by this point, because if you’ve been paying attention, you should have covered any of questions you had going in.

When you’re asked how you would handle a particular situation or what your approach to something might be, ask for more information if you need or qualify the situation they’re referring. People are often afraid to do this in case they look silly, when actually it makes you look quite smart, and show that you’re not afraid of authority.

Take your time

using audio in powerpointDon’t rush to answer a question. There’s no real way to prepare for an interviewer’s questions, and they know that. However, your answers should also be rooted in some previous experience you’ve had, so while it may take you a while to wrack your brains for a previous example, you shouldn’t be unable to answer either. If you can’t think of an exact experience, discuss a similar one and how you handled that.

Be yourself and relax

This is so important, because as much as the interviewer may be looking for the most skilled candidate, they’re also looking to make sure you’re not a robot. Show your personality, show you’re a human, establish some rapport with your interviewers. Some of the interview process is confirming you are what you say you are, but mostly it’s finding out if you’re someone they want working for them.

In the IT and engineering industry, interviews aren’t even set up to determine skill sets, but rather personality traits, because many companies today are looking for programmers and engineers who can communicate to stakeholders in plain English, rather than tech talk.

***

Remember, who you are in the interview should reflect and expand on who you are in your resume and cover letter. You can learn how to use PowerPoint to create a resume in our PowerPoint training courses. For more information, visit our website.

You can also brush up on Word for your resume presentation by enrolling in our Microsoft Word online training courses. You’ll be amazed at the things you can create with a comprehensive understanding of Word.


learn PowerPoint online training course

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.


 

Posted on

The Do’s and Don’ts of a Compelling Resume and Cover Letter

Is your resume up to speed?

do's and dont's of writing a great resume
If you thought you’d never have to write another resume as a contractor or self-employed business person, then think again.

STARTING YOUR OWN BUSINESS does not mean you’ll never need to write a resume or cover letter again. We’ve written about this topic before — indeed, when you first start your own business you’ll probably spend a lot of your time applying to work with other businesses directly or through a recruiter.

And the truth about being a freelancer or contractor is that you’ll most likely spend the rest of your working life applying for work. If you don’t like the idea of this, well then maybe being self-employed isn’t for you! Why? Because in order to find the best work; the kind that you’ll love, you need to be always looking for it — or always be closing, if there any fans of Glengarry Glen Ross in the house tonight.

The truth about being a freelancer or contractor is that you’ll most likely spend the rest of your working life applying for work. 

Do pay attention to design

I’m choosing to exclude the “grammar, spelling and punctuation” portion of this list, because if you don’t already know that’s important by now, then oh boy, I can’t help you. But formatting and design are important, whether you’re looking for work in a creative industry or not.

The key is to grab attention in less than half a minute. You can use different fonts, for instance, a larger plain font for headings and a smaller (perhaps serif) font for the body text. You can type your resume up in Word or use PowerPoint or some other design tool. But just don’t get ahead of yourself and use something too fancy that you don’t have a proper grasp of and end up with a resume that is hotchpotch and messy.

These days, some recruiters will even upload your resume into their own “system” which “parses” your content and basically re-formats it all into plain text. If this happens, your gorgeous CV will look very different on the screen of the employer. The simpler the design and layout of the original resume, the easier it will be for them to read if they indeed use this system for getting through the applications of hundreds of job applicants. But don’t feel disheartened, there are others ways to get spotted amongst the crowd.

Don’t use jargon

The next hurdle, once you’ve got the recruiter or hiring manager reading your resume or cover letter, is to urge them to call you. Do not, I repeat, do not use jargon of any kind in either your resume or cover letter. The minute someone reads a sentence that starts with or contains “experienced in”, “team player”, “responsible for”, etc, etc, they switch off.

These phrases mean literally nothing. Nothing. Telling someone you’re a team player: redundant. Everyone should be a team player, and there is no one, not a single person ever, who has written on their resume that they’re not one. Instead, tell the employer what you like about working in a team. (On a similar note, also avoid the term “able to work autonomously” by explaining the times you’ve had to and how that’s gone.)  

When you go to use the words “experienced in” try to remind yourself that this is something that happens to you — not something you proactively go out and do. Instead refer to your background in terms of achievements. Search “typical jargon to avoid on a resume” for more.

Do show your personality

Remember that employers are people too. Work culture is important to lots of businesses, so they need to know that any potential new hire, freelance or otherwise, will be able to fit in and work with them. And if you can make the person reading your resume laugh, oftentimes you’ll get a call back.

Don’t list silly interests

I should add a qualifier to that, which says that it’s okay to list a really silly interest if you know and make a point of noting that it’s a silly interest. This makes you seem thoughtful, and definitely not as dumb as a person who says they like reading or sports on their resume. Reading what? It implies novels, but it could also mean signposts, Aldi catalogues, Post It Notes. And if you like playing cricket more than once a year on Boxing Day, then for the love of all that is holy (cricket on Boxing Day), say that. Otherwise, put down interests that you actually are interested in — they reveal a lot about the type of person you are, which again, goes to help with the point above.

***

If you’d like to learn how to create a resume in Microsoft Word or PowerPoint, or if you’d like to learn more about starting your own business, you can be enrolling in our PowerPoint training courses or our online Word training courses, or our Business Start Up Course.


learn xero online training course videos

At EzyLearn you can choose from a range of XERO online courses, depending on your skill level — or you can access ALL courses for ONE LOW PRICE. All our courses are accredited by the Institute of Certified Bookkeepers (ICB) and can be counted towards Continuing Professional Development (CPD) points. Find out more about our Xero online training courses.