Posted on

When a Bookkeeper Isn’t Just a Bookkeeper

start your own bookkeeping business registered BAS agent business

Why NOW is the time to become a work-for-yourself bookkeeper

start your own bookkeeping business registered BAS agent business
Bookkeeping is a career that keeps on growing as you grow you and your client’s business.

THERE ARE UMPTEEN REASONS why starting a bookkeeping business is a great low-cost venture for people looking to take a step back from the corporate world, or even for those looking to do quite the opposite by working from home so they have the flexibility they need as parents to young children.

If you’re a subscriber of this blog, then you’ve read posts about National Bookkeeping, the company EzyLearn has partnered with to deliver training courses to people who become National Bookkeeping licensees.

However, I’m going to talk about it again because there are still too many talented people out there who don’t think they have what it takes to go into business for themselves. And I’m here to tell you, you do, and we’ll help you!

Register as a National Bookkeeping licensee before 30 June

As it’s nearing June 30 and the end of this current financial year, it’s a great time to kick-start your own business, by registering to become a National Bookkeeping licensee. Their license fee is a hundred percent tax deductible due to the large component of training courses included in the fee, so if you register before the end of June, it can go towards reducing your taxable income straight away.

The reason I became interested in National Bookkeeping is because I felt it provided just enough structure for new business owners to get their business off the ground, but also the right amount of flexibility for those business owners with the desire to take their business (and incomes) to the next level by providing addition services, such as content marketing, virtual assistant services, or even financial planning.

I think that in order to be successful in business and for your business to have longevity, you need to be open to new opportunities and to be able to constantly update your business model and offerings. Particularly now that we’re in an age of great technological change, staying abreast of changes to the way people work and do business is the key to staying in business, period.

…Now that we’re in an age of great technological change, staying abreast of changes to the way people work and do business is the key to staying in business, period.

New technologies mean new opportunities

There are many business analysts and economists who see the reduction of permanent jobs as a bad thing – and to some extent, they’re probably correct – but I see it as an opportunity. New technologies have made it easier for people to work at home, wherever their home may be – a city, a beachside town, outback Australia – so long as they have access to a reliable Internet connection.

Now, people who have previously been excluded from the job market have an opportunity to earn an income. That’s great news for workers and for the economy, and it’s why the government has spearheaded a move to encourage working from home, or teleworking as it’s officially known, among businesses and their staff.

We continue to need bookkeepers

Bookkeeping is a necessity for all Australian businesses, as it’s a fundamental requirement of Australian tax law to keep accurate business records. Hiring a contract bookkeeper to take care of their business’s bookkeeping allows business owners to go out and find more work and grow their business, rather than having to worry about keeping up with all of their administration and book work.

With continued training your business grows as your client’s business does too

As their business grows, the bookkeeper will become busier too and they may even be asked to provide more services – BAS services, tax services, financial planning and advice, even one-to-one training — the list goes on. The more training you have, the better you’ll able to service this client yourself and the more business you’re business will grow as a result. (Want to read more about what’s required to become a registered BAS agent?)

It’s not uncommon for a bookkeeper to start out providing simple data entry and reconciliation services to business, and then wind up providing full financial advice and planning services, providing, of course, they’re qualified to do so. And these are qualifications you can acquire while already providing services to clients and earning an income.

When you become National Bookkeeping licensee, you’re free to continue your studies so you can eventually progress from a bookkeeper through to a financial planner and adviser, and with clients to help them grow their business, just as you did yours.

National Bookkeeping even provides you the blueprint for doing it by offering the EzyLearn Small Business Management Course, (our EzyStartUp Course) which has been augmented to help bookkeepers develop a business plan specifically for a bookkeeping business.

With National Bookkeeping you’re not just a bookkeeper

ato tax concessions for small business under $25mAs a National Bookkeeping licensee you’ve got the tools and the support to build a successful, sustainable small business that can provide an array of services, beyond those of the typical bookkeeper.

So if you’ve been thinking about starting your own business, register with National Bookkeeping before June 30 so you can claim it as a tax deduction right away; alternatively, to learn more, visit their website or continue reading our blog.


 

Posted on

When It’s Good to Offer Free Bookkeeping Help

woman working as a bookkeeper for free

Providing an initial consultation free of charge

woman working as a bookkeeper for free
No one should expect you to do work for free, but spending time getting to know your clients will help distinguish you from a bar of soap!

IT’S NEVER REALLY a good idea to work for new client or potential new clients for free, particularly if you’re an established business. But it’s also difficult getting a client to feel comfortable that you’ll do a good job for them, when they don’t know you from the proverbial bar of soap.

Rather than working for free or charging less than the minimum wage for your bookkeeping services a better idea is to spend some time with your client, either in-person or over the phone, to go through your processes and procedures before you commence work for them. It’s also important that you make your clients aware of value adds you’re providing to them.

Schedule a consultation with prospects

If you take the lead and schedule a an initial consultation call or meeting with your new clients or prospects, you get to control how the working relationship progresses. This gives you the opportunity to set some ground rules around the assignment of work, turn around times, payment terms, and so on. 

Aside from making you look professional and organised, it’ll also make your job easier because you’ve clearly outlined how you operate, what’s expected from the client in order for you to do your job, and what happens after you’ve finished your work.

For example, is BAS lodgement included in your fees, or is that additional? Do you follow up late payers on your client’s behalf or is that additional?

Read more about what you can cover at an initial consultation

Do some needs analysis

It’s a good idea to look at how much knowledge your new clients have of bookkeeping and the software you’ll be using (Xero, MYOB, QuickBooks, etc). Carry out some quick needs analysis during your consultation, so that if there are any areas they are unfamiliar with you’re both prepared and able to give them a quick overview. Further, in-depth training is a potential source of additional revenue, so be careful not to spend too much time here. All of this will help you form your bookkeeping business strategy and, in particular, ensure your rates are competitive, yet sustainable. 

Read more about what you can cover at an initial consultation

***

Start a bookkeeping business today

Start a bookkeeping business not a franchiseIf you’d like to start a bookkeeping business, then visit our online bookkeeping directory, National Bookkeeping. You can find information about how to start your own bookkeeping business, promote yourself through our directory or become a licensee.

As a licensee with National Bookkeeping, you’ll have access to EzyLearn training courses (which also means the license fee is one hundred percent tax deductible. Visit the National Bookkeeping website today and register your interest online.


 

Posted on 1 Comment

Is Xero Better than MYOB for Bookkeeping Businesses?

Bookkeeping Incumbent, MYOB Versus Cloud Innovator, Xero

MYOB or Xero online accounting course training videosMYOB HAS LONG BEEN the preferred accounting software of choice for accountants, but a lot of small business owners have now come to prefer Xero. It’s easier to use, and they can access it anywhere — their desktop PC, tablet or smartphone.

Meanwhile, the rise of cloud-based accounting software, which was pioneered by Xero, has made it a lot easier for bookkeepers to base themselves from home. Throw in other technological innovations — cloud storage, bank feeds — and a remote Xero bookkeeper has become the more appealing choice for businesses, too.

Good bookkeepers have a corporate background

Many experienced bookkeepers (around level three upwards) have a corporate background. They’ve typically worked for big accounting firms, and are possibly qualified accountants or BAS and tax agents, familiar with all the available ERP systems on the market.

As much as they know MYOB as the big robust accounting software for medium-sized businesses, a lot of these ex-corporate bookkeepers are also well aware of how Xero benefits small-to-medium businesses: It’s less confusing to use and it’s cloud based; things that make the bookkeeper’s job easier, too. But there’s no guarantee they’ll recommend Xero purely because of that.

Their experience with a range of different ERPs, makes them just as likely to have a subscription to more than one accounting software so they can recommend, with firsthand knowledge, the right accounting software for your business — be it Xero or QuickBooks or, yes, even MYOB.

Bookkeepers can grow their business

National Bookkeeping - How to Earn More MoneyOf course, one reason Xero has become the preferred accounting software, over MYOB or QuickBooks, for a lot of ex-corporate bookkeepers is because of the Xero partner program which enables them to earn ongoing income by recommending Xero to their clients.

Billed as a way for Xero bookkeepers to grow their business, the program lists certified partners in the Xero Advisor directory, which is used by businesses looking for a Xero-certified bookkeeper to manage their accounts. To become a Xero partner, bookkeepers must successfully complete a Xero skills test. When they do, they’re listed on the directory.

The more Xero clients a bookkeeper brings in under the Xero Partner program, the higher their status and the greater their rewards — free Xero memberships, marketing help, and big discounts on subscriptions for their clients.

It’s incredibly appealing for ex-corporates who want the flexibility of self-employment, but want to grow their business with a client-base of substantial mid-sized businesses — and fast. So the more business a bookkeeper can bring Xero, the more business Xero can bring the bookkeeper. At least, that’s how it’s supposed to go.

Universal access with Xero

But Xero Partner or not, far and away Xero’s popularity is really due to its technology — and its commitment to using technology to improve the way businesses stay compliant with the tax office.

That all started with universal access. Businesses that use Xero can invite anyone in their team — their admin assistant, bookkeeper, accountant, their entire sales team — anytime they like, as part of their Xero subscription. Here are a few more reasons:

  • Invoices can go out as soon as a project is finished or a sale is made; likewise for estimates and customer statements.
  • It also means that a business owner can monitor their cash flow in real time, while their bookkeeper is keying transactions and their sales people are sending off invoices.
  • And because the software is in the cloud, these people don’t even need to be in the same building, never mind the same city, state or country! (Xero is the rare low-cost accounting program that supports multi-currency.)

It’s all about the Xero tech

Xero also integrates with more than 500 third-party apps. Some popular integrations include Gmail and Hubspot, the marketing and sales platform. These two integrations alone turn Xero into a complete business management platform and enable it to scale up to the services provided by mid to large sized ERP systems.

Businesses can import data to Hubspot based on customer spend or products and services sold, and send those customers tailored marketing messages. The Gmail integration gives users a complete snapshot of previous conversations with customers — salespeople can see if there are outstanding invoices, or problems with a customer’s account, for example.

Gold standard in bank feeds

Although bank feeds are accurate most of the time, they’re not perfect. MYOB has been know to be particularly temperamental, but Xero has a reliable bank feeds function. Again, that’s a lot to do with Xero’s commitment to tech. 

Setting up bank feeds in any accounting software is as simple as clicking a few buttons, giving a few permissions, and voila! Your bookkeeper has just saved themselves hours each month. Bookkeepers much rather spend as little time as they can keying and coding transactions.

[box type=”info”] This time is better spent doing bigger jobs — lodging activity statements, reporting, payroll — so they’re going to recommend an accounting program with bank feeds.[/box]

Plus, business owners won’t have to wait for their bookkeeper to enter their transaction data each fortnight or month to see how their cash flow is tracking: Bank feeds give business owners a complete picture of their business’s cash flow and financial health because transactions are imported in real-time.

Xero courses provide Bookkeeper CPD points

EzyLearn Online Course CPD points for bookkeepers and marketing professionalsEzyLearn gets lots of enrolments in our Xero training courses and we’re an accredited training provider with the Institute of Certified Bookkeepers. The ICB requires its bookkeepers to continue developing their skills and knowledge as a bookkeeper in order to retain their membership (this is known as continuing professional development, or CPD).

Many bookkeepers and accountants do EzyLearn’s Xero courses to earn their annual CPD points. EzyLearn offers a number of different training courses as continuing professional development (CPD) for bookkeepers, including our Microsoft Excel, Xero or MYOB training courses.

Our Bookkeeping Academy training courses start at $99 — for Xero or MYOB — and allow you to learn what you want, when you want, entirely at your own pace. Visit the Bookkeeping Academy website for more information or to enrol.


 

Posted on

How Bookkeepers Can STOP Losing Out to Accountants

Junior level 1 bookkeepers good cheap local bookkeeping services - Natbooks

Or is it just BAS Agents who are losing out?

Good experienced Xero, MYOB Finance Manager and bookkeeper for local bookkeeping - Natbooks LogoTHE BURDEN ON Australian small businesses to stay compliant with the ATO is immense. A lot of that is to do with the Government not distinguishing between a small business with upwards of 20 staff, and a micro business which may have 5 or fewer staff — sometimes even no staff.

All of this compliance — bookkeeping, activity statements, payroll, superannuation, and so on — is costly and time consuming, so most business owners outsource this work to a professional contractor. Before the Government changed the tax laws, it was bookkeepers who small or micro business turned to.

Prior to 2010, a bookkeeper could complete and lodge your BAS and tax returns without needing any formal qualifications — that’s since changed.

Accountants kill two birds with one stone

Even though few small or micro businesses actually need the services a financial accountant provides — financial planning, say — a lot of tax accountants are picking up clients that would have, prior to the law change, gone to a bookkeeper, and it’s usually because they are scared of getting something wrong and then getting slapped on the wrist about it. 

Small businesses (SME’s) want the cheapest and easiest way to stay compliant, and dealing with one person is easier than dealing with multiple people, especially if there are any issues with how one person has worked, and the business owner winds up stuck in the middle.

If a business is large enough, a Finance Manager can be employed to systemise the work and then manage the low cost junior bookkeeper, and the accountant and provide the business owner with the results and reports they need and want. 

[box] In the new bookkeeper induction for new members of National Bookkeeping we take students through the formalities of signing up a new client, defining the type of clients they want and the category of bookkeeper they want to be and we find it helps them get into the systemising mindset.[/box]

 

BAS agents and accountants charge the same

If you’re only hiring an accountant to complete and lodge your activity statements, they’ll only charge you to do that. This rate is similar to what most BAS agents charge, only BAS agents generally charge a lot less for bookkeeping tasks, while in my experience accountants charge BAS service rates for more junior bookkeeping tasks.

If you’re only hiring an accountant to complete and lodge your activity statements, they’ll only charge you to do that. This rate is similar to what most BAS agents charge, only BAS agents generally charge a lot less for bookkeeping tasks, while in my experience accountants charge BAS service rates for more junior bookkeeping tasks.

Junior bookkeepers can win business they’d normally lose to an accountant by becoming a qualified BAS agent, or going to work for an accountant where they’re allowed to perform all of the bookkeeping and BAS work because they’re being “supervised” by an accountant.

Finding the middle ground

The middle ground for people who want to start their own bookkeeping business and become a contract bookkeeper is often to perform bookkeeping tasks that involve more than just data entry, but less than the tasks covered under the tax act as a BAS Service, like credit management. It’s also important to be emotionally intelligent.

This involves data entry and accessing customer information but also communicating with late payers, difficult customers and problem solving for complex sales transactions. This work requires a bit more bookkeeping experience AND life experience and it’s very important to the financial health of the business.

***

To learn more about the kind of accounting professional your business needs, visit the National Bookkeeping website.

You will find a number of professionals — from bookkeepers to BAS agents, to Chief Financial Officers — who can provide the right accounting services for your business at an affordable price.

Posted on

Do You Need a Bookkeeper or an Accountant? Or Someone Else?

There are many finance professionals — who does your business need?

find a good local bookkeeper
Does your business need a bookkeeper, accountant or perhaps just a BAS agent – or a little bit of everyone?

WE’VE MENTIONED PREVIOUSLY THAT finding a bookkeeper, when you may not know much about bookkeeping, can be a difficult task.

In fact, a lot of new business owners assume their accountant will take care of everything for them, which may be costly if their accountant has to perform a year’s worth of bookkeeping in order to file the business’s tax return. But bookkeepers and accountants can work harmoniously in your business.

As a general rule, every business needs at least two finance professionals working on their business accounts, but which two professionals you’ll need to hire depends on your business needs. If you’re not sure who you need to hire for your business, here’s a cheat sheet to help you out.

Bookkeepers (not registered with the TPB)

An independent bookkeeper not employed by an accountant and not registered with the Tax Practitioner’s Board (TPB) may only perform basic bookkeeping services, such as the entering of receipts, coding financial transactions, generating invoices and, possibly, some accounts receivable work. If you hire this type of bookkeeper, you’ll still need an accountant.

BAS agents

BAS agents must, by law, register with the Tax Practitioner’s Board (TPB), which certifies that they are qualified and have completed the necessary continuing education requirements to perform the tasks of a BAS agent, which involves carrying out most of the bookkeeping tasks mentioned above, in addition to preparing and lodging business activity statements on a business’s behalf.

If your business is registered for GST, you will need to file regular activity statements. If you hire a BAS agent, you’ll also need an accountant. In some instances, you may find a BAS agent who’s also a registered tax agent and vice versa, who may be able to take care of all your taxation needs.

Tax agents

Although tax agents, like BAS agents, must also register with the Tax Practitioner’s Board (TPB), a tax agent is focused on income tax — how much income you have to declare, how much you can claim back, etc.

This is distinct from a BAS agent who is concerned with the day-to-day financial tasks of your business (bookkeeping and BAS lodgements). That said, some tax agents will also perform some the basic bookkeeping tasks on a regular basis, though they primarily specialise in lodging tax returns.

If you’re not registered for GST, and your tax agent will also perform regular bookkeeping tasks (or you can do it yourself), you may not need to hire an accountant. In some instances, you may find a tax agent who’s also a registered BAS agent and vice versa, who may be able to take care of all your taxation needs.

Accountants

An accountant is mostly concerned with planning and strategy. Unlike bookkeepers and BAS or tax agents, an accountant will assess and advise you on what actions you should take to maximise your income. Great accountants will get involved with planning the direction of your business and ensure it’s been structured properly and that you’re meeting any additional tax obligations.

They’ll also help you to make strategic purchases for equipment and machinery, and work with your BAS agent or bookkeeper to ensure these decisions are reflected in your daily financial records. An accountant is also able to prepare and lodge tax returns on your behalf.

How much should I pay a bookkeeper?

Check out the National Bookkeeping Directory, which features the details of bookkeepers, capable of doing data entry and clerical tasks, through to high-level accounting work as undertaken by BAS agents, accountants and CFOs.

You can also see the National Bookkeeping rates page to find out what level bookkeeper your business needs.


cashflow reports in xero and excel

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

Top 3 Expense Applications for Xero, QuickBooks and MYOB

Get your financial software working harder

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

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

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

Xpenditure (QuickBooks, Xero, Fresh Books)

It’s a little more expensive than Expensify, but you also get a little more bang for your buck. From around $4 a month, you can scan 200 receipts per month, plus all of Xpenditure’s core features, such as expense rules, real time reporting, accounting integration, and mileage tracking. Speaking of which, Xpenditure tracks your mileage using Google Maps, which as discussed previously, isn’t the the most accurate way to do it.

However, it does calculate the estimated cost of each trip using the current “mileage rate” — or kilometre rate for Australians — set by the Tax Office. It’s mobile app, however, only has an average 1 star rating in the Australian Apple App Store, while it’s currently rates at 3.5 stars in the Google Play store, so it appears it’s best served on an Android platform.

Abacus (Xero, QuickBooks)

At $9 a month for up to 50 users, it’s on the pricier side for small businesses. And although Abacus lets you give your accountant or tax agent free access to your Expensify account, it doesn’t really make up for the higher price tag (we happen to think the point of an expense app is that you only need to give your accountant or tax agent access to your accounting software).

Yes, it includes all the standard features, such as receipt scanning, real time reporting, multi-level approval workflows, and automatic approvals — plus, an EzyLearn favourite: automatic direct deposits for reimbursing employees once an expense is approved — but features like mileage tracking are absent. It’s rated 4 stars on the Google Play app store, but unrated in the Apple App Store.

Squirrel Street (Xero, QuickBooks, MYOB)

Formerly known as Shoeboxed (they explain name change on their website), Squirrel Street is a rather expensive way to track your expenses and store your receipts. Plans start at $26.95 a month for 50 receipt uploads and 2-5 day turnaround, which explains the steep price: This is a software application that relies on manual labour, rather than machine learning, to import expense data. As a consequence, there’s no other features of note — no real time reporting, no expense reports, no automatic approvals.

There is also a “forever free” five document per month DIY plan available. Of course, they are an Australian owned and operated business, but it’s still not the best service for your dollar. It’s rated 4 stars on the Apple App Store and 4.5 stars on Google Play.

By keeping an eagle eye on your expenses using an expense app that integrates with your cloud accounting software, 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 online courses in Xero, MYOB and Quickbooks will show you how to track expenses and connect third party apps to your account. Read more about cloud accounting.


learn to use excel online training course videos cheap best

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!


 

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

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

Use DropBox to Store Your Tax Records Digitally

In a previous post we 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.

 

Posted on

Working Out Job Costs and How to Charge Your Clients

Why You’re Underselling Yourself with Fixed Price Quotes

bookkeepers fixed price quotes
There are many reasons why you may lose out when fixed price quoting.

I’ve written a number of blogs on how bookkeepers can work out their fees and what good local bookkeepers generally charge. However, now we examine the nitty gritty of determining your on-the-job costs so you can clearly see what your hourly rate should be.

When it comes to working out fees, most business owners go: “Well, the average market rate for my profession is X per hour and this job should take around Y hours” and off they go and give their client a quote that, in today’s small business parlance, is frequently referred to as being a fixed-price quote or the project fee.

This would be fine except that you’re essentially working on an hourly rate, without the benefit of being able to charge the client if you run over your allocated timeframe. Continue reading Working Out Job Costs and How to Charge Your Clients

Posted on

What Bookkeepers Can Learn From Real Estate Agents: Facebook Advertising

Facebook – Great for Local Marketing

using facebook for bookkeeping marketing
Facebook can be extremely useful for marketing to a local audience.

In its decade of existence, Facebook has built up a wealth of data about its users, data that it likes to sell back to those who need it, in the form of targeted advertising. Facebook advertising, though similar in its approach, is very different to Google Ads in what it delivers.

Real estate agents discovered the value of Facebook advertising early, and have used a combination of images and videos to successfully deliver their marketing messages and sale pitches directly to their target market and in order to set their prices. Continue reading What Bookkeepers Can Learn From Real Estate Agents: Facebook Advertising

Posted on 1 Comment

What Bookkeepers Can Learn From Real Estate Agents: Using Video and Images

Focusing on Education Rather than Sales

how bookkeepers can use videoTHE INTERNET HAS CHANGED the way businesses market their services to prospects, from a simple sales message to an educational one.

Real estate agents caught onto this shift in buyer trends early and started creating online content to cater to these buyers.

Visit the website of any real estate agent and you’ll find lots of images and videos educating potential buyers about their services, previous sales and the local area they represent.

Continue reading What Bookkeepers Can Learn From Real Estate Agents: Using Video and Images