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

The Wonders of Microsoft Excel’s 3D Formulas

Excel’s 3D Formulas Work Across Worksheets

Excel formulas online training courseWe’ve recently updated our Microsoft Excel Training Course content, because it remains one of the most indispensable tools for small businesses — and we’ve included a new exercise workbook which takes you through all the steps involved in developing a financial forecast for an investment.

We used a granny flat project as the case study in our financial forecasting workbook, but the beauty of Excel is that, once you get the formulas right, they can be replicated for any kind of investment, not just one for building a granny flat.

The wonderful 3D formula

3D formulas are one of the other many wonders of Excel. A 3D formula is basically a reference to the same cell or a range of cells within multiple Excel sheets. They’re a convenient way to reference several worksheets that follow the same pattern, with cells that contain the same type of data.

All functions work with 3D formulas

3D formulas can be used with all Excel functions — SUM, AVERAGE, PRODUCT, etc — which means that, using a 3D formula, you can easily create a financial forecasting sheet for any stage of an investment, and easily reference that data in another financial forecasting sheet. This is invaluable because there are very few projects or investments that can be contained in just one Excel worksheet.

A project like the granny flat case study in our online Excel Training Course, contains many moving parts — there’s the initial construction, then there’s the ongoing maintenance, and the rental income to manage. It would be impractical to keep all of this information contained within the one Excel worksheet.

3D formulas can be modified with time

The best part about using 3D formulas is that you only need to specify the start and end sheets (which for ease-of-use, you could just label ‘start’ and ‘end’) and the formula will reference all the worksheets between the start and end sheets, including those two sheets.

This means that, as your investment or project grows, once you’ve got the 3D formulas set up correctly, you can just add and subtract worksheets as necessary, and the calculations will update automatically.

***

Once you understand how to create and work with 3D formulas, you can use them for any project or investment that you create a financial forecast for — be it for a granny flat project, business investment or anything else that requires you to make a financial decision.

Visit our website for more information on our Microsoft Excel Training Course, which covers 3D formulas.

***

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

Depreciation and Tax Deductions Associated with Granny Flats

Working Out Your Depreciations with Excel

excel online training course financial forecasting
Ok, so you may or may not have the room for a granny flat, but either way, Excel is the foremost tool for forecasting financial investments.

If you have the room, building a granny flat on your property can prove to be very lucrative. EzyLearn has recently created a new Microsoft Excel exercise, using the construction of a granny flat as a case study, which forms part of our online Excel Training Course.

It was created to help students understand how to use Excel for financial forecasting, but it’s also useful to those interested in constructing a granny flat on their property.

Costs that will be depreciated

In a recent post, we mentioned claiming depreciation on the property’s existing dwelling. If the existing dwelling on your property is rather old, it may not be able to be depreciated. Depreciation rates are determined by the ATO, while an quantity surveyor will be able to determine the value of your dwelling. The cost of the new granny flat will be depreciated over time. Keep in mind that individual elements of the granny flat, such as the floorings, can also be depreciated in addition to the capital structure.

Most expenses can be deducted

The ATO has a long list of expenses relating to rental properties that can be deducted. If you visit their website, you’ll find that most expenses relating to a rental property can be claimed as a tax deduction, depending on the type of rental property. If your granny flat is intended as a long term rental, as the granny flat in our case study is, then nearly all expenses, including the demolition of the old garage and other capital works can be deducted right away.

***

How you treat these expenses and depreciable assets is covered in the granny flats case study of our Microsoft Excel Training Course. Visit our website for more information on our full suite of training courses.

***

EzyLearn online training courses count towards 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 Excel to Manage ALL Your Investments

Once You Master Excel You Can Do Anything!

using excel for financial forecast granny flat2
Excel is one powerful tool. Its formulas can be extrapolated to most any accounting software program.

In our Excel training Course there’s an exercise workbook on granny flat investments, which takes you through all the steps involved in developing a financial forecast for a granny flat. It can also be used to determine the financial forecast of any investment, not just granny flats.

Even though lots of cloud-based software applications have come along in recent years — Xero and MYOB and CRMs like Zoho — which have made it possible for lots of business owners to keep track of their financials and customer sales history without ever needing to open an Excel spreadsheet, Microsoft Excel is still the software used by accountants and analysts in nearly every profession.

Excel is flexible

Microsoft Excel may be difficult to master — indeed, it’s probably one of the most difficult in the entire suite of Microsoft programs — but it’s also the most flexible. The formulas sitting behind nearly every cloud-based accounting software can all be replicated and modified in Excel, where in MYOB or Xero, they can’t.

You can’t enter the details of your granny flat project or other investment into Xero and MYOB and create a financial forecast, even though near similar formulas are being used each time you run a profit and loss statement.

Cloud software is Excel plus PLUS

Before computers and Microsoft Excel came along, accountants used a pen and paper to keep track of their clients’ business financials. And before that, before the numeral system was invented, the abacus was the main accounting tool used by merchants and traders to keep track of their finances.

You probably have no use for an abacus anymore — although in some parts of Eastern Europe and Southeast Asia people still do — because, as an accounting tool, it’s too basic. But the same cannot be said about Excel, which is capable of handling complex formulas and rendering an answer.

Export accounting data into Excel

Because cloud-accounting software is essentially a very user friendly version of an elaborate, however inflexible, spreadsheet, it means you’re able to export your accounting data into Excel. Financial analysts and accountants do this when they need to carry out further analysis on a client’s financial data, and you can too.

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 Microsoft Excel Training Course, with its new intermediate-level ‘Granny Flat Case Study’.

***

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

When Building a Granny Flat, Here’s What You Need to Consider

Excel Can Help You with Financial Forecasting

using excel for financial forecast granny flat
Excel is a great tool if planning a big ticket project like developing a granny flat on a property.

If you have the room, building a granny flat on your property can prove to be very lucrative. EzyLearn has recently created a new Microsoft Excel exercise, using the construction of a granny flat as a case study, as part of our Excel Training Course. It was created to help students understand how to use Excel for financial forecasting, but it’s also useful to those interested in constructing a granny flat on their property.

The first thing to consider is whether it’s viable to borrow money to fund your entire granny flat project. Most people add a granny flat to their property to earn an additional income by renting it out. If this is your intention, then you need to determine whether the granny flat will become a positive cash flow investment or a negative one.

The existing property

To begin, you must determine the value of the dwelling or existing property on the land you own. Is it brand new, relatively new, older style, or very old? You should have a quantity surveyor determine the value of the existing dwelling, to determine how much of the entire property’s value — that is, the house and land — is based on land value. In most cases, land value will far exceed the value of the dwelling, however many people are surprised to learn by how much, especially if the dwelling isn’t very old. Once you know the value of the dwelling, you may be able to claim depreciation as a tax deduction.

Development costs

You should now start to factor in the development costs associated with the project. This includes the cost of demolishing any existing structures — a garage or shed, for example — and remediation of the site in the event asbestos is present. You should also have a fairly good idea of what it will cost to construct the granny flat up to the stage where you can move in. Not all granny flat construction companies take you up to this stage, often exiting at lock-up stage instead. Don’t forget to include any council fees or levies associated with constructing your granny flat.

Expected income

In the Microsoft Excel case study, both the existing dwelling and the new granny flat will be rented out as investment properties. However, you may not do the same. You need to determine how much rental income you can reasonably expect to earn from your granny flat. You should also determine whether you’re located in a region with low rental vacancy rates and high demand for long term rentals. This will determine not just the net weekly income you can expect to receive, but also the frequency at which it will be occupied, which will also factor into your bottom line.

***

Considering each of these areas is just the first step in developing a comprehensive financial forecast of your granny flat project. Our Microsoft Excel Training Course, with its new granny flats case study, goes into much greater detail. Bookkeepers can also keep up their certification and earn CPD points with our Excel, MYOB and Xero courses. Visit our website for more information on our full suite of training courses. 

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.

Even though bank feeds can dramatically reduce the amount of time spent coding transactions in your accounting software, if your business has a lot of transactions each month, it’s a good idea to perform weekly — or even twice weekly — reconciliations. You’ll not only further reduce the potential for errors, but it’ll also help to give you a clearer picture of your finances.

Improved cashflow management

Even though internet banking allows you to look at how much money you have in the bank, this is an imprecise way of managing your cashflow. By reconciling your accounts on a weekly basis, you’ll be able to see what money’s gone out of your account, and what’s due to be coming in. If you have staff, this will eliminate a lot of the stress of wondering whether you’ll have enough money in the bank to make payroll, because you’ll know in advance if there’ll be any cash shortfalls.

Improved reporting

With weekly bank reconciliations, you’ll also find that your financial reports are greatly improved. This will enable you to make more correct sales forecasts, and to plan for machinery or equipment upgrades with a greater sense of accuracy. It’ll also help you to identify late paying clients and peak business cycles, so you can better manage your business operations — limit credit to late payers, hire more staff, etc. This type of financial information is the lifeblood of every successful business, so it has to be accurate.

If you’re hiring a bookkeeper to manage this for you, it’s worthwhile discussing whether they will perform this work once a week, or a couple of times each week. If your bookkeeper is contracted to perform a certain number of hours each week, they may decide to perform a few tasks a few times a week, so they’re more available to their other clients during the week. This is a bonus to the business owner, because it improves the accuracy of your reporting even further.

***

Weekly bank reconciliations is an important task for all businesses, not just large ones. Our Xero Bank Reconciliations and Journal Entries Course covers how to reconcile a bank account, 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

Or if you want to see why incorporating bank feeds might be useful for your business, read here.

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.

 

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

MYOB, Xero or QuickBooks: Which Suits Your Business Best?

Which is the Pick of the Bunch?

xero myob or quickbooks which is best
It’s a competitive accounting software market place out there … which is the pick of the bunch for you?

IN A PREVIOUS POST, we highlighted some of the biggest differences between QuickBooks and MYOB

However Xero is also a serious competitor to MYOB (and QuickBooks to a lesser degree).

So let’s take a look at the different capabilities of each accounting application and the kinds of businesses they best suit.

Continue reading MYOB, Xero or QuickBooks: Which Suits Your Business Best?

Posted on 1 Comment

Independent Contractor! PayPal Provides Instant Business Working Capital Finance

If you’re an independent contractor you’re a business owner

EzyLearn can help your business train WHS staff or provide credentialing and inductions.
EzyLearn can help your business train WHS staff or provide credentialing and inductions.

As an independent contractor, operating with an ABN, you’re effectively running your own small business (so working capital important), and that means you’re subject to some of the same reporting obligations for the ATO as other small businesses are. The only real difference is that as an independent contractor, your business model is a lot simpler to other ones.

For example, most independent contractors operate as sole traders, so while they have to withhold their own tax and manage their own superannuation contributions, they still pay the same rate of tax as an individual (or an employee) does, making them eligible to claim the tax free threshold, among other things.

But unlike an employee, an independent contractor has to bill their clients by issuing them with an invoice, and the simplest way to do that is to use a cloud-based accounting software. With the recent announcement that PayPal and QuickBooks had joined forces to offer low-cost cloud accounting software which allows businesses to accept PayPal payments, I’d say QuickBooks is likely to become the independent contractor’s cloud accounting software of choice.

PayPal will Loan Money for Working Capital Based on Cashflow

paypal working capital and intuit quickbooks online accounting softwareOn its own, the PayPal-QuickBooks syncing is a pretty compelling reason for every independent contractor to be using PayPal to accept payments from their clients, but there’s also another, better reason to be using PayPal: PayPal Working Capital.

Working Capital is PayPal’s latest foray into the small business money lending fray – complementing their other ventures, which include merchant services, card readers, and, of course, the QuickBooks deal – by offering business loans to businesses that already use PayPal to process their payment.

The application process is remarkably simple: use PayPal to accept payments, and you can apply for loan of up to 15 percent of the sales processed by PayPal in the last 12 months, up to a maximum of $85,000.

Repayments are made directly from your PayPal account, you decide the rate at which the loan will be repaid – 20 percent of each sale, for example – and are only paid when you are paid. There are no late fees or fees for missed payments, and you don’t pay interest on the loan – just one, simple fixed fee, based on your sales history and the amount you are loaned.

PayPal is selling their Working Capital service as the quick and simple way to grow your business, and it is. Suppose you need a new computer – or a couple of new computers – with a PayPal Working Capital loan, you only pay one fixed fee and you have the money in your PayPal account as soon as your application is approved. So here’s a thought..

Borrow money from Paypal at a fixed cost (not based on interest charges), pay it off from future sales and use it to make a capital purchase for machinery, equipment of a car and claim the cost of that asset purchase this financial year!

PayPal helps make you globally competitive

The real reason every independent contractor should be using PayPal to accept payment from their clients, though, is because it helps to make you globally competitive. With PayPal you can work with clients in different countries, without having to worry about whether they will be able to deposit money into your account, and what fees may be charged to your or your client that make you less competitive than other contractors.

Now that PayPal has inked a deal with QuickBooks, it also makes setting up a PayPal payment gateway and directly your clients to pay you with PayPal incredibly easy – just a few clicks of a button, in fact. This means, your clients can choose whichever payment method to pay your invoices, whether it’s by credit card, debit card or direct from their own PayPal account – so it’s not only easy for them, but quicker too.

And the quicker and easier it is for clients to pay you, the more likely they are to pay you on time, every time. 

You can read more about how PayPal is changing small business in Australia by subscribing to our blog. Alternatively, if you’d like to start your own business as an independent contractor, we’ve recently partnered with the StartUp Academy to help you do just that. Download our free guide to becoming an independent contractor or register your interest in one of the current business opportunities at their website.

Posted on 1 Comment

Is Xero really the easiest accounting software to use?

Xero was a market leader, but what do accountants think of it now?

xero cloud accounting software works on tablets phones and desktop computersWhen Xero was launched a few years ago, one of its selling points was that, compared with other accounting software – in particular, MYOB – Xero was incredibly easy to use, and it was also cloud-based, which meant you could access your accounts from any computer, any device, anywhere, anytime. This helped Xero to get a major foothold in the marketplace here in Australia, where MYOB had always reigned supreme.

But it wasn’t long before we started getting requests from bookkeepers and accountants for a Xero training course, in addition to our already existing MYOB training courses. It turned out that, as more businesses (tradies, for example) started using Xero because of its cloud functionality, their bookkeepers and accountants were finding that they needed training in some of Xero’s features and functions, despite Xero being billed as the easy alternative to MYOB.

Perhaps Xero isn’t that intuitive to use without a training course?

Since introducing our Xero training course, we’ve also noticed a significant upswing in enrolments, especially from bookkeepers, with many noting that the bank reconciliations and adjustments features in Xero are difficult to navigate. This got us wondering as to whether Xero really is that easy to use compared with MYOB, or whether it there might be an easier alternative out there, especially for small businesses managing all of their own accounts.

QuickBooks wants to be the small biz accounting software of choice

Since QuickBooks re-emerged in Australia, with full backing from their US-based parent company, Intuit, they’ve been cornering the small business market, with their inexpensive pricing plans and now by announcing a partnership deal with PayPal (paypal want you to be paid quicker) that enables a two-way flow of data between both QuickBooks and PayPal.

The QuickBooks-PayPal deal follows a similar union between Saasu and Westpac, which promises Saasu and Westpac customers with direct bank feeds to provide business owners with real-time insights into their cashflow. As one of the Big Four banks – and, quite often, the preferred bank for most Australian businesses – the union is hoped to give Saasu a leg up into the increasingly competitive cloud-accounting market, which saw the shuttering of the Australian-owned Reach Accounting earlier this year.

QuickBooks is well-placed to topple Xero

At more than half the price of Xero’s ‘standard’ plan (the starter plan at $25 per month is the most limited ‘starter’ plan I’ve seen), QuickBooks’s starter plan is already appealing to the money conscious small business owner; the PayPal deal only strengthens that.

Ever since PayPal spun off from eBay earlier this year, it’s been announcing new services that specifically target small business owners primarily doing business online – first by introducing inexpensive invoicing, card readers, and now by integrating with QuickBooks. As PayPal is the only online payment service operating in Australia, the two companies are now exceptionally placed to take the Australian small business market.

Perhaps losing the small business market isn’t a primary concern for Xero, which seems to be aligning itself to take the MYOB medium-sized business market, anyway. Regardless, QuickBooks is definitely a force to be reckoned with (forgive the pun) in the Australian cloud accounting space.

Join the wait list for our Quickbooks Online training course

We’re in the process of developing a QuickBooks training course, so if you’d like to register your interest to receive alerts and announcements about its progression, you can do so at our website. Alternatively, if you’re looking for training courses in either Xero or MYOB, you can enrol in either course online today and do your course over the Christmas and holiday season when you might have some time to do one while you reflect on your goals for 2016.

Posted on 3 Comments

QuickBooks and PayPal Want To Help You Get Paid QUICKER!

Quickbooks is stealthily forming partnerships to fight MYOB and Xero

Quickbooks Online is back and they want to beat MYOB and Xero

Small business owners know better than anyone the difference an an invoice paid on time (or early) can make to their cashflow. Yet, getting paid on time, never mind early, remains as elusive as a pot of gold at the end of a rainbow. A new union between PayPal and QuickBooks Online hopes to change that.

Since PayPal officially divorced from its parent company, eBay, earlier this year, the company has been edging closer and closer to the small business finance market, with products and services specifically aimed at small businesses that derive a good proportion of their business through online sales.

PayPal also seems to be fighting MYOB and Xero

In recent months, Paypal has started offering small business loans to businesses with an existing PayPal sales history, which serves to complement other, already existing services, such as PayPal Invoicing, PayPal’s Merchant Services, the PayPal Here card reader, and now the union with QuickBooks Online.

PayPal Invoicing vs. Quickbooks + PayPal

Item invoicing for free accounting using Paypal invoices, how will MYOB, Xero and Quickbooks Compete with freeIf you already use PayPal to accept payments from your customers, then you’re probably already familiar with PayPal’s invoicing service, which charges a small fee per invoice for the use of its service, rather than a monthly fee like most other accounting and invoicing packages do.

Until recently, PayPal’s invoicing service, as well as its card reader, has been of benefit to businesses that primarily sell goods on e-commerce sites like eBay, and don’t regularly invoice or accept payments in-person. The union with QuickBooks, however, changes that.

Now, businesses that primarily invoice their customers for good and services have access to the best of both worlds: an accounting package that’s inexpensive and the ability to allow customers to pay their invoices in just a few clicks using a credit card, debit card or PayPal.

How QuickBooks + PayPal works

Setting up a PayPal payment gateway within your invoicing or accounting software isn’t new; Zoho has been offering automatic payment gateways – using PayPal, Stripe or any other online payment service – for ages. But the QuickBooks union allows PayPal data to be automatically synced with QuickBooks, reducing all of the data entry associated with accepting payments with PayPal. In essence, it’s bank feeds for PayPal.

With QuickBooks and PayPal, business owners are able to send online invoices to their customers, who can then, with a few clicks of a button, pay them online using a credit card, debit card or PayPal account.

The idea is that businesses will be paid faster, because their customers are able to click a few buttons and pay invoices with greater number of payment methods. Of course, it relies on the customer already having a PayPal account.

What the QuickBooks-PayPal union really means for small business

What the QuickBooks and PayPal alliance really represents, however, is QuickBooks’s continued push into the accounting software market in this country, by aligning itself with a key player in the online payments space, which also happens to be going after small businesses with its own range of small business-centric services.

Currently, there are no other online payment services available in Australia (in the US there are a handful of alternatives, with Stripe being PayPal’s biggest competitor), so the QuickBooks-PayPal alliance gives the former a leg up over already-established competitors in the Australian marketplace, like MYOB and Xero.

Now that accounting software has entered the cloud, the marketplace has become a fairly crowded, cutthroat world, as the recent shuttering of Reach Accounting and the sudden introduction of Reckon One, by the very company that used to licence QuickBooks in Australia, has shown.

For small businesses, the Quickbooks-PayPal union may not mean getting paid faster, but it does represent a promise of continued flexibility in the way small businesses interact with their customers, whether it’s mostly in the form of regular online purchases, casual in-person payments, or mostly by invoicing for goods and services.

What’s your plan for 2016?

As 2015 comes to a close, you’re probably giving a lot of thought to your plans for next year and beyond. If those plans involve starting your own business and working from home, then start putting the wheels in motion NOW by enroling in our small business StartUp course or by visiting the StartUp Academy website and browsing the current business opportunities available.

EzyLearn partnered with StartUp Academy earlier this year to give our students and readers the opportunity to start their own business, while also having access to the training and guidance needed to make a new business a success. There are currently a number of business opportunities available across an array of different industries. Visit the website for more information and to register your interest.

Posted on 1 Comment

How Do You Earn $80 Per Hour as a MYOB Bookkeeper?

How much can you earn as a MYOB Bookkeeper?

FOR ANYBODY WHO DECIDES to be self-employed and own their own business, or who is doing so already, the question of how to match the hourly rate of someone working on salary while working in your pyjamas is one that frequently goes unanswered.

But ponder no more.

If you’re well versed in the advanced features of MYOB, Xero or Quickbooks, possess an accounting qualification and can operate your business as an independent contractor, you’re well on your way to earning the big bucks as a bookkeeping consultant.

Specialist skills earn you more money

Currently, bookkeepers with a good understanding of things like time billing, job reporting and forecasting, advanced payroll, end-of-period transactions and journal entries, as well as Australian tax, are highly sought after by other businesses to work as consultants.

Of course, you could also carve out a niche specialty for yourself if you happen to be highly skilled in a particular sector or industry.

MYOB Training Online

Our MYOB courses (offered for one low price and include lifetime access) cover 85% of the MYOB skills the majority of MYOB bookkeepers require to perform most bookkeeping tasks. For everything else, however, it’s a good idea to engage the services of a specialist who can provide a solution to your specific needs.

We also provide in-depth online training courses in Xero, Quickbooks, Small Business Management and start up and social media.


learn cloud accounting online training course videos xero excel myob quickbooks

At EzyLearn we include all versions of a software program in our training courses. When you enrol in Lifetime Course Access you get access to ALL versions and ALL FUTURE VERSIONS as we continually update them — at no extra cost!