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

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

Why Your Business Needs a Bookkeeping Procedures Manual

Documenting procedures helps keep your bookkeeping up to speed

bookkeeping procedures manual rescue bookkeeping work
Rescue bookkeeping is not ideal – it’s often expensive and shows you’re not in control. A bookkeeping procedures manual will outline what bookkeeping needs to be done, when.

IN A PREVIOUS POST we talked about how to tell when you need rescue bookkeeping, which is basically when a business is behind on its bookkeeping by three months or more and the deadline is looming to lodge their activity statements.

Rescue bookkeeping work costs more than having your bookkeeping taken care of regularly, because it’s often messy and there are no procedures in place to manage the bookkeeping efficiently.

What’s a bookkeeping procedures manual?

bookkeeping procedures manualA bookkeeping procedures manual clearly identifies the regular tasks and activities your bookkeeper needs to take each week, fortnight, month or quarter to ensure your bookkeeping is kept up-to-date. This not only gives you the peace of mind that your bookkeeper is staying on top of your books, but it also helps you to understand what’s going on with your business.

If you require regular P&L statements or balance sheets, having a procedures manual to clearly outline how frequently they’ll be created helps you to stay on top of your business’ financials.

A typical procedures manual will include:

  • Simple steps that are easy-to-understand and succinct
  • Tasks are written up in a step-by-step style, so they can be followed logically
  • References, links or examples are included to help readers understand
  • Contain a number of formats — written steps, flow charts or checklists.

Rather than leaving your bookkeeping to the last minute, so you’re always operating your business in dark, organise to have bookkeeper create a procedures manual to regularly take care of your business’s bookkeeping.

We Can Help You Find a Good Local Bookkeeper

find a local bookkeeper

We have bookkeepers, BAS agents and accountants located across Australia, available to help businesses in need of rescue bookkeeping workVisit our online bookkeeping directory, 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

Go to National Bookkeeping for more information, to see our rates or to request a quote.


Online bookkeeping accounting training courses for CPD points

EzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants. We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.


 

Posted on

EOFY: Organise Your Reports and Records

We Show You The Reports to Generate Now for End of June

profit and loss statements P&Ls
Now’s time to take stock of the reports that need to be generated to keep you GST and tax compliant.

THE LAST QUARTER OF the 2016/17 financial year is upon us, so now is the time to organise your reports and records; including Profit and Loss Statements, Accounts Receivable and Payable, PAYG and Super payments. We’ve previously written about writing off stock and inventory and getting your business expenses in order. In this post we’ll take a look at the reports and records you’ll need for EOFY, which you’ll learn how to produce in our MYOB BAS Reporting and GST or Xero GST, Reporting and BAS training courses.

Profit and loss statement

Depending on the structure of your business, you may be legally required to include a P&L statement with your tax return or activity statements. Your tax agent will be able to advise you if your business will be required to file a P&L, which  requires all of your bookkeeping to be up-to-date before you can run it.

Even if you don’t have to file one with your activity statements or tax returns, it’s still a good idea to run a P&L for your own sake. A P&L statement identifies whether your business has made a profit or loss and which accounting period these occurred.

Accounts receivable, payable

Find out who owes money to your business and to whom your business owes money. This is obviously part of the credit management process, which any good business will have in place already, but it’s a good idea to keep a steady eye on what’s coming in and what’s going out as EOFY approaches.

PAYG, superannuation

The end of each quarter brings a lot of PAYG and superannuation reporting, but EOFY brings a double whammy of activity statements tax returns and PAYG and superannuation compliance. You’ll need to run these reports so your bookkeeper can complete the payroll component of your returns.

Inventory stocktake

If you sell goods, you’ll need to complete a stocktake of your business’s inventory so that any missing stock can be written off, and to ensure you’re starting a clean slate for the new financial year.

***

Learn how to run the reports you’ll need for EOFY with our MYOB BAS Reporting and GST online training course or our Xero GST, Reporting and BAS training course.


Xero online training course

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

End of Financial Year: Writing Off Stock

We show you how to write off stock and inventory before the EOFY

how to write off stock before eofy in xero myob
Do you know how to make inventory adjustments? Our Xero and MYOB BAS and GST Reporting courses can show you how.

IT’S A GOOD TIME TO START  looking at any slow-moving or obsolete stock that your business (or your client’s business) may be holding, as we’ve reached the end of Quarter 3 and have now started Quarter 4 for the 2016/17 financial year — which means the end of the financial year is fast approaching.

Writing off stock in MYOB or Xero is known as making an inventory adjustment, and our MYOB BAS Reporting and GST or Xero GST, Reporting and BAS training courses take you through the steps to do this. But first, you need to identify which items aren’t selling. We’ve created this case study to help you understand how.

Understanding your inventory’s performance

Every business needs to understand how their inventory is performing, and how it impacts their business. If the business owner is too busy to stay on top of this, then they should employ a bookkeeper to help.

A good example of why understanding inventory is important to a business is to look at an air conditioning company. This business makes money two ways:

  1. Selling air conditioning units
  2. Installing / maintaining air conditioning units

The margin on the sale of an air conditioning unit is not much, a few percent on top of the wholesale price. Where the business makes its money is in the installation or maintenance of the units it sells.

The business purchases three dozen units, of varying brands, models, price points, etcetera. It now needs to know which units are most popular with customers and why; which units aren’t popular with customers and why; whether it’s profitable for the business to continue to stock the unpopular units; or, conversely, whether it’s profitable for the business to continue stocking the popular units.

Inventory reporting

The business’s bookkeeper regularly runs a number of reports in their accounting software, including profit and loss reports and stock-on-hand reports. These reports are used to identify which units sell quickly, as well as the units that take longer to sell, and the profit margins on each.

The units that sell quickly don’t require a technician to install them. Although they’re responsible for the majority of sales, they don’t generate more revenue for the business. The units that sell slowly, do generate more revenue as they require installation and maintenance, however too many units were ordered and they’ve now been discontinued by the manufacturer. Some units have hardly sold, and, although not discontinued, have been superseded by newer models.

Stock write offs and future orders

Because the bookkeeper regularly runs these reports, s/he has been able to export them into Excel for further analysis. By the end of Q3, the bookkeeper can make suggestions to the business owner about the future of the business.

In particular, the bookkeeper suggests that the units that have been superseded are marked down to clear as much stock as possible, and cease any new orders. Likewise, the discontinued models will be marked down.

Orders for the units that replaced the discontinued models will halve the order volume. Likewise, order volumes for the top selling units will reduced. The profit margin on these units is very low and they result in no additional revenue from installation or maintenance. The profit that would be earned on the additional units is negligible, however by reducing the unit volumes, the business improves its cash flow.

Act NOW for EOFY

If your business sells stock or a combination of stock and services, like the air conditioning business does above, start looking at your inventory now. Markdown any slow-moving stock at the end of Q3, to give your business time to move the remainder of it. If it doesn’t sell, write it off at EOFY.

***

Our MYOB and Xero training courses have recently been updated to include a workbook on how to write off inventory. Learn more about our MYOB BAS Reporting and GST or Xero GST, Reporting and BAS training courses at our website.


find a local bookkeeper

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


 

Posted on 3 Comments

What Happens if You Have Backlog of PAYG and Super Payments?

Don’t get lumped with penalties when you don’t need to!

failure to lodge penalties how to manage payroll in Excel online training course
It’s not only frustrating and disheartening, but a waste of business funds to be penalised for lodging your financials too late.

A LOT OF SMALL BUSINESSES have trouble managing their payroll, especially when they only have a few employees and paying to access a payroll system in their accounting package is an unnecessary expense. You’ll learn how to use Excel to manage your PAYG and super contributions in our Intermediate Microsoft Excel Training Courses. However, sometimes you may have a backlog of PAYG and super payments. Let’s take a look at how to manage these.

Rescue bookkeeping

A backlog of PAYG and super payments that date back more than three months is known as rescue bookkeeping, although it can often include other bookkeeping issues, like bank accounts that don’t reconcile with statements.

PAYG payments

For businesses that only withhold up to $25,000 each year, you’re supposed to make PAYG payments and file a withholding report each quarter. You have 28 days from the end of the quarter to do so, after which time, you may incur a Failure To Lodge (FTL) penalty.

Superannuation payments

As with PAYG payments and reporting, you can also incur a FTL penalty for not lodging or paying your employees’ superannuation contributions in time. All businesses, regardless of size, have to make superannuation payments each quarter — the ATO sets out the due dates for each period on their website.

Lodging late PAYG and super payments

The ATO only applies penalties for failure to lodge reports or make payments for each period of 28 days (or part thereof) that a document or payment is overdue. Each period incurs one penalty unit for each document, up to a maximum of five penalty units.

From 2015 onwards, the value of a penalty unit is $180 (previously it was $170) for small businesses, which are defined as entities with an assessable income or GST turnover of no more than $1 million a year.

The maximum penalty a small business will pay is $900 for each document or payment that is overdue. Note too that FTL penalties will also incur a general interest charge (GIC), applied on top of the penalty.

Managing late PAYG and super payments

Use the Ad Hoc Payroll Guide, a new case study that is included in our Intermediate Microsoft Excel Training Courses to determine the rate of PAYG tax to withhold and the required super contribution amounts in Excel. Once you’ve worked out the required amounts (visit the ATO website for tax tables prior to 2017), lodge the necessary PAYG payments and reports to the ATO; pay super contributions using the SuperStream super clearing house.

The ATO will write to you if you are required to pay a penalty — sometimes they are waived for first-time offences, or if the amounts are small.

Our courses now include real-life case studies

learn excel online training course

Our Intermediate Microsoft Excel training courses will also teach you how to create a payroll spreadsheet from scratch to suit your own business, so you can easily work out your PAYG and super obligations. Visit our website for more information on all of our Excel training courses.


learn PowerPoint online training course

Create brilliant presentations and graphics for all kinds of business purposes.

Gone are the days of excruciatingly dull PowerPoint slide presentations. Nowadays PowerPoint is the hidden gem used to generate animations, videos, movies, advertising and graphics. It’s a great ally to the marketer or social media person in your organisation.

This creative program can also be used to conjure up the most beautiful and modern pictorial slides to enhance any presentation or induction. Find out more about our 2016 version PowerPoint courses.


online bookkeeping courses to earn cpd pointsEzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants. We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.


 

Posted on 1 Comment

Linking a Financial Forecast with Xero and Excel

Excel Will Help You Work Out the HOW of Depreciation

learn excel online training courseWe recently updated our advanced Microsoft Excel Training Course content. It now contains a case study, by way of an extra exercise workbook, using a granny flat building project to create a financial forecast.

We chose a granny flat building project for our case study because it’s an investment decision quite a lot of people with or without a business have made. It’s also a capital asset that can be depreciated over time. Therefore it has the potential to affect your taxes in lots of different ways.

Our Excel Training Course, with its granny flat financial-forecast case study, will teach you how to use Excel to create a financial forecast, which you can then replicate for your own investment — whatever that may be.

Your bookkeeper uses Excel to calculate depreciation

When you build a new structure, such as a granny flat, which you intend to rent out or use for businesses purposes — i.e., it’s an investment and not for your own personal use — the building can be depreciated along with some of the fittings and finishes (floorings, curtains, paint, etc). That’s despite the value of the land upon which the granny flat is constructed increasing in value over time.

Once you’ve set up your financial forecasting file in Excel using the correct formulas that will update as the investment progresses, you’ll be able to track all of the future costs, income and depreciation in that spreadsheet.

Input depreciation into Xero

Excel will calculate the depreciation amounts for you, which you should then enter into Xero. We cover how to deal with depreciation in our Xero Bank Reconciliation Course, because lots of businesses own, or will own, a capital asset at some point.

However, this doesn’t tell you how to determine the depreciation amounts, which most business owners have to get their bookkeeper to work out for them. Most bookkeepers work this out in Excel based on the depreciation rates provided by the ATO. However, if you have already created a financial forecast in Excel, you won’t need to get your bookkeeper to do this for you.

Individuals can claim depreciation too

Even if you’re not a business owner, but you’ve still built a granny flat that you intend to rent out, you can claim depreciation in your tax returns. Instead of entering the depreciation into Xero, you’d include it on your annual tax return, so it’s really important that you work this out in Excel first and regularly update it.

***

Once you know how to use Excel for financial forecasting, you can use the same formulas and modelling for any financial forecast — be it for a granny flat project, business investment, anything that requires you to make a financial decision. Visit our website for more information on our advanced Microsoft Excel Training Course, with its new granny flats case study.

Do you want to brush up your Xero skills? Or perhaps you use MYOB but want to get a handle on Xero? Check out our suite of Xero training courses — all available for one low price. 


Online bookkeeping accounting training courses for CPD points

EzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants. We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.


 

Posted on 2 Comments

Which Transactions Affect Balance Sheets?

Avoid Any Nasty Surprises: Balance Sheets Matter!

EzyLearn Xero Balance SheetA business’s balance sheet is a snapshot of its financial position at a particular period of time, which is not to be confused with a profit and loss (P&L) statement. Unlike a P&L, which just shows whether the business is making a profit or loss during a given period, a balance sheet, will eventually, show nearly every activity that has occurred within a business.

However, there are some transactions that will show up immediately. You’ll learn how to run a balance sheet in our Xero Daily Reconciliations Training Course, but we wanted to show you the transactions to look out for and why.

profit and loss statement xero online training course
A balance sheet reveals the nitty gritty of your business’ transactions.

The purchase or sale of assets

When an asset, such as a car, is bought, it will reduce the cash account and increase the fixed-assets account. Both of these accounts are listed in the asset portion of the balance sheet, however, cash is part of the current assets section and fixed assets are part of the long-term assets section.

When an asset is sold, the way the cash is accounted for is a bit more difficult. Here, both the asset’s book value and any accumulated depreciation are removed from the books at the same time that the cash account is increased by the sales price. If the sales price does not equal the book value, the difference is accounted for as a gain or loss on the sale of equipment. This gain or loss is recorded on the P&L statement.

Purchases on credit

When a business purchases supplies or inventory on credit, the business will debit the asset account (supplies or inventory) and credit the accounts-payable account. Almost always, accounts payable are considered to be current liabilities and are shown at the top of the liabilities section of the balance sheet.

Debt and lease arrangements

When a business issues debt or enters into a leasing arrangement, a liability must be recorded in the long-term section of the company’s balance sheet. For example, if a company issues bonds for cash, the company would debit cash and credit bonds payable in the simplest bond-issuance scenarios.

Capital-lease transactions affect the balance sheet in a similar manner. When entering a capital-lease arrangement, the business will debit a fixed-asset account to show that the company has taken economic possession of the leased asset. At the same time, the business will credit a capital-lease obligation account to show the offsetting economic liability.

***

For a balance sheet to be correct, you must code each transaction correctly in your accounting software. Our Xero Daily Reconciliations Training Course covers balance sheets, and much, much more. Why not enrol today?

***

Online bookkeeping accounting training courses for CPD points

EzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants. We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.


 

Posted on 4 Comments

Basic Bookkeeping Reports in Xero: Profit and Loss

Learn How to Run a P&L Using Xero

Profit and Loss statement
Profit and loss statements should be run by businesses regularly and are required by law.

A basic, yet vitally important, report for every business owner is a profit and loss (P&L) statement. A profit and loss statement, as the name suggests, shows whether a business is running at a profit or a loss over a given period. We’ve written about why running multi-period P&Ls before in QuickBooks and MYOB is a good idea for businesses with inventory, but single period P&Ls are equally important for all businesses.

If you’re a bookkeeping newbie, a profit and loss statement, which sometimes goes by other names — income statements, earning statements, revenue statements, operating statements, statement of operations, or statement of financial performance — is a basic report you’ll learn to run in our Xero Daily Reconciliations Course. If you’re planning to work as a contract bookkeeper, you should get in the habit of running P&L statements for your clients regularly (if you’re a business owner, ask your bookkeeper to run them).

P&Ls are required by law

Depending on how a business is structured, it may be required by law to complete a P&L. A P&L shows how the revenue of the business is turned into net income by subtracting all expenses from income. They’re also useful for understanding a business’ net income, which helps with the decision making processes. A business will also need a P&L if they’re applying for a small business loan.

The contents of a P&L

profit and loss statements P&LsAlthough the process of running a P&L differ between accounting software packages, they usually all contain the same elements, depending only on the business itself. In the first section, the cost of sales is subtracted from the revenue, which highlights gross profit. The business’ operating expenses are then subtracted from the gross profit, which leaves the operating profit. Now, all of the non-operating revenues and expenses must be factored into account, after which the business’ profit or loss will be displayed.

***

Because P&L statements are often used by a business’ owner to make financial decisions, to inform shareholders of the business’ performance, apply for a business loan, or as proof of income in the sale of a business, it’s important that you understand how to create one correctly. Our Xero Daily Reconciliations Training Course covers P&L statements, and much more. Visit our website to learn more or to enrol.

***

online bookkeeping courses to earn cpd points

 

Did you know that EzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants?We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.

 

 

 

 

Posted on 1 Comment

Calculating PAYG Obligations Without a Payroll System

Third Quarter is Looming; Are You Up to Date with Payroll?

ad hoc payroll payments ExcelMost businesses using an accounting program like MYOB or Xero will use the included payroll package to manage their employees’ payroll. For businesses with only a few employees, however, the additional payroll function is an unnecessary expense.

In our recently updated Advanced Microsoft Excel training courses, we have included a micro course on ‘Ad Hoc Payroll’, featuring a detailed spreadsheet for calculating PAYG and superannuation obligations. In this instance, our micro course is a detailed spreadsheet based on a case study, so it’s relevant and applicable to real life.

PAYG and the businesses it applies to

Every Australian business with employees who are each paid more than the tax-free threshold has a legal obligation to withhold tax on their employees’ behalf. This is known as the PAYG System (or Pay As You Go), where amounts of tax are withheld from each employee’s wage payments.

Businesses that withhold up to $25,000 each year only need to make payments to the ATO each quarter; businesses withholding amounts greater than $25,001 may have to make payments to the ATO each month or as regularly as each week.

At the time of writing, the tax-free threshold is currently $18,200, which is equivalent to:

  • $350 a week
  • $700 a fortnight
  • $1,517 a month

Superannuation contributions

Again, any business that pays its employees more than $450 each month must also make regular superannuation contributions on their employees’ behalf. We’ve written in the past about the government’s clearing house called SuperStream, which allows you to easily make super contributions — for free.

But first, you need to work out how much super you need to contribute for your employees. The superannuation guarantee is currently 9.5 percent of your employees’ gross wages, which is payable on top of their wages — not deducted out of.

Using tax tables to calculate wages

Each year, the ATO produces a range of tax tables to help you work out how much to withhold from payments you make to your employees. In our Ad Hoc Payroll Micro Course, we’ve already added the most current tax tables to the accompanying payroll spreadsheet, as well as the superannuation guarantee tables.

***

We feature a number of real-life case studies, which we have turned into micro courses. You can use the Ad Hoc Payroll Micro Course to determine the rate of PAYG tax to withhold and the required super contribution amounts in Excel, rather than paying to access the payroll functions of MYOB or Xero. Our Intermediate Microsoft Excel training courses will also teach you how to create a payroll spreadsheet from scratch to suit your own business. Visit our website for more information on all of our Excel training courses.

***

online bookkeeping courses to earn cpd points

 

EzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants. We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.

 

 

 

 

 

Posted on 1 Comment

Use DropBox to Store Your Tax Records Digitally

In a previous post I suggested it’s a good idea to create a digital filing system for your business receipts and tax records. Storing tax records digitally is not just a space saver — it’s also an efficient way to share information with your accountant and bookkeeper, especially if you’re working with a remote bookkeeper, as it’ll speed up the process.

Our Xero Bank Reconciliations and Journal Entries Course will also show you how to record these transactions in Xero. 

Continue reading Use DropBox to Store Your Tax Records Digitally
Posted on 1 Comment

How and What Kind of Receipts Do You Need to Keep?

Xero course online receipt keeping

Online Receipt Keeping is the Way to Go

A HUGE PART of reconciling your bank account involves coding business expenses or purchases. You then need to keep a record of those expenses in the event you’re ever audited.

Our Xero Bank Reconciliations and Journal Entries Course covers how to code an expense or purchase in Xero, and it’s important to also store your receipts and get them to your bookkeeper if they’re working remotely.

Many people have used Dropbox to capture images of receipts but there are even better ways. Continue reading How and What Kind of Receipts Do You Need to Keep?

Posted on 5 Comments

Performing Weekly Reconciliations in Xero

Why it Pays to do Regular Bank Reconciliations

bank reconciliations weekly
Doing regular weekly bank reconciliations will help avoid confusion or errors later on.

In our Xero Bank Reconciliations and Journal Entries Course, you’ll learn how to carry out each step in the reconciliation process, in particular how to set up bank feeds. Bank feeds are an important function that allows transactions on your linked bank account or credit card to automatically show up in Xero, so you (or your bookkeeper) don’t have to spend time entering the details from scratch.

Both contract bookkeepers working from home or employees working remotely or in the office can log in and perform bank recs using bank feed data. Continue reading Performing Weekly Reconciliations in Xero

Posted on 2 Comments

How Bank Feeds Save Time and Money

Making Light Work out of Bank Reconciliations

Xero bank feeds
Incorporating Xero bank feeds will save you time, money and stress.

Cloud accounting software’s greatest innovation was not putting the software in the cloud; it was introducing bank feeds. You’ll learn how to set up bank feeds in the latest version of Xero in our Xero Bank Reconciliations and Journal Entries course. For now however, we’re going to explain why you should — whether you’re a business owner doing your own bookkeeping or whether you’re a bookkeeper employed to do it for your clients — be using bank feeds.

Bank feeds in brief

A bank feed is an automatically created list of the transactions (spent and received) in your bank account that is imported into your Xero accounting software. For this to occur, you have to give Xero permission to access your account. Some people feel funny about this, but bank feeds have been around for so long now that, just like online shopping, there’s really nothing to worry about. I won’t go into how the technology works, but I will say that no one looks at your account data; you’re just allowing the free flow of information between your bank and Xero.

Direct bank feeds save time (and indirectly, money)

There was a time when you or your bookkeeper had to wait until your bank statement arrived before any transactions could be reconciled in your accounting software, usually at the end of the month. For businesses with a lot of transactions, either in the form of receivables or payables or both, reconciling a month’s worth is a finicky job that’s prone to errors.

With bank feeds, transactions will show up in your accounting software as soon as the payment leaves your account or credit card. If you (or your bookkeeper) get in the habit of reconciling your account on a daily, twice weekly or weekly basis, it makes it easier to accurately code each transaction because you’re only dealing with a few at a time. This results in fewer errors and fewer hours spent fixing them, and that saves money (read: time = money).

The Xero online courses we offer

Xero online training course bank feedsBank feeds are an important aspect of reconciling your (or your client’s) accounts. Our Xero Bank Reconciliations and Journal Entries Course covers setting up bank feeds, plus much much more. Alternatively, to take it back a step, you can learn about invoicing, credits and reporting in our Xero Day-to-Day Transactions Course.

Using an old version of Xero?

You might like to read this prior post we wrote explaining how you can add bank links on an older version of Xero or enrol for our Xero courses here.