Category: Cloud Computing

hosted computing, Software-as-a-Service (SaaS), Cloud Computing

Posted on by

What are Online Ratings Based On?

Reviews tell a whole lot more

online reviews and online ratings social media
Many people make buying decisions based on online reviews and ratings but how “real” are these? And how can you tell?

IT CAN BE DIFFICULT to tell whether online ratings and reviews are real or not. One easy way to get a pretty good idea of what’s real and what’s not is checking for a balance of positive and negative ratings and reviews that have been left by real people who’ve used their Gmail or Facebook account.

Reviews are better than ratings

If you’re a person who relies on ratings and reviews to make purchasing decisions, you’ll know you can’t really tell the trustworthiness of a businesses if it only asks customers to leave a rating (usually out of 4 or 5). Similarly it’s hard to tell what people really think of a business if they’ve only left ratings rather than reviews. 

Businesses with a good mixture of ratings and reviews, where a customer has been able to leave a comment justifying the rating they gave the business, make it much easier to make a decision.

Check the content of reviews

You don’t need to read thousands of reviews for a business, but it helps to read a few of them to see what customers are saying. This also helps determine whether these reviews are truly independent or not.

What are reviewers actually commenting on, and if they’re negative, is there a pattern? Is a local restaurant consistently understaffed or does a plumber often fail to turn up on time? Are the complaints about things that would concern you or are they petty — a long queue at a cafe that still serves good food and coffee, for example.

Positive reviews provide useful information

If the reviews of a business are mostly positive, do they provide any useful information? Hundreds and hundreds of reviews that simply say “great” or “fantastic” don’t tell you enough about what customers thought were great or fantastic about that business.

People might have really liked something that doesn’t suit your needs. It is also a good indicator that they’re not entirely true or real reviews either.

At EzyLearn we provide testimonials from our students, which include their full name and location, and why they chose EzyLearn to study in the first place. We also offer a money-back guarantee and free samples of our course content, so students know they can trust they’re making the right choice.

***

Want to brush up your skills in cloud accounting software? Ready to progress to intermediate or advanced levels in MYOB, Microsoft Excel, Xero or another accounting package? Need help with social media? Take a look at our wide range of online course options or visit our website for more information.

learn online training Xero courses videos for less

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 by

Should You Buy Commercial Property Outright or Get a Mortgage?

The power of using Excel and Xero combined

Excel and Xero combined importing_comp
Our courses cover how to import from Excel into Xero and visa versa, for purposes such as working out depreciation on a business premises.

THERE ARE MANY UPSIDES to buying a commercial property for your business and if you’re able to buy an industrial unit like a Cubbyhole, it can also be a lot cheaper than renting premises.

Buying outright

If you’re in the financial position to buy your business premises outright, it may seem like a no-brainer to do this instead of getting a mortgage. However, there are some things you need to consider:

  • You’ll lose liquidity on the assets in your property, which means you won’t be able to tap into any equity in the property, unless you take out an equity loan against the property.
  • You’re tying all your cash to one asset class, which may limit your ability to make other investments and prevent your business from expanding. This could run counter to your reasons for making the property purchase in the first place.

Getting a mortgage

When you get a mortgage, you have the benefit of being able to access equity in the property, which will enable to invest elsewhere. Of course, there are still factors to keep in mind:

  • You’re spreading the payments over many years, which ties you to paying down that asset for the foreseeable future.
  • You’re paying interest, which although it’s a tax deduction, will significantly inflate the price of the property.

Work out the best way in Excel

Using the data from your Xero accounting software package, Microsoft Excel can help you determine whether your business will be financially better off buying its premises outright or getting a mortgage.

You can also create a financial forecast in Excel. Using Excel, you can calculate the depreciation amounts, which can then be entered into Xero. We cover how to deal with aspects like depreciation in our Xero Bank Reconciliation Course, because many businesses own, or will own, a capital asset at some point.

***

Check out our new Cash Flow Reporting, Budgets and ROI Course for Xero which shows you how to deal with an asset purchase like a business premises in Xero. Remember, you get access to ALL our Xero courses for ONE LOW COST. Visit our website for more information on our suite of online training courses or enrol today!

learn to use excel online training course videos cheap best

Importing from Xero to Excel and back again is included as part of our Advanced Microsoft Excel training courses — and you receive access to ALL OF OUR COURSES, including ALL skill 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 by — 1 Comment

Can You Trust Online Ratings and Reviews?

How to tell a review is authentic

online reviews are they real
If using online reviews to help you work out what to buy, you want to make sure you’re really hearing it from the horse’s mouth, and not just reading fake marketing guff.

IF YOU’RE ANYTHING LIKE most people, rating and reviews are how you probably make many of your purchase decisions. This can be for purchasing white goods, clothing, a holiday, or even choosing a real estate agent. Continue reading Can You Trust Online Ratings and Reviews?

Posted on by — 1 Comment

Buying Real Estate For Your Business

The pros of buying a business property

xero reports to buy or sell business industrial unit business investment
Buying a premises for your business need not be cost prohibitive and you may enjoy good equity growth.

IN OUR NEW CASH FLOW reporting, Budgets and ROI course for Xero, we delve into the purchase of real estate for your business, which you may use as office space or as a warehouse or as a storage facility and workshop, depending on your line of work.

Why some businesses don’t like buying

Lots of businesses avoid buying premises for their businesses, because you’ll need to have a large capital injection right off the bat, and you may also incur land tax obligations, building insurance, and also be liable for maintenance and repairs.

Renting gives businesses, especially new ones, flexibility, as you’re only locked into a short term lease — not a multi decade mortgage. And if you decide to move or find new premises before your lease term is up, you can often minimise the costs by subletting the premises.

Buying as an investment strategy

However, buying your premises is a good investment strategy, as you’ll be able to access the equity and capital growth in the premises as property prices rise.

You’re also afforded greater freedoms and stability when you own your business’s premises — in particular, protections from rising rents — than you would have if you rented your premises. If you outgrow the space, you can always access the equity and may be able to buy adjacent premises, or rent out your existing ones while you upgrade, providing another valuable income stream.

Running the right reports to help you decide

Of course you can use a cloud accounting program like Xero to run reports that will help you decide whether to buy or rent your business premises and how such a decision will impact your cash flow. There will naturally be capital gains tax considerations and associated deductions. Our Xero training courses go through how to run these kinds of reports to ascertain the financial health of your business.

Low cost pathways to ownership

Industrial units are a good pathway into ownership for your business. If you don’t need to be right in the heart of the city or major town centre, you can often purchase an industrial unit for under $100,000.

In Newcastle in the Hunter region of New South Wales, you can purchase an industrial unit called a Cubbyhole, which can be used as a workshop, storage unit or office space for tradespeople, small and online businesses. These come with amenities such as toilets and showers, car parking (including visitors’ and disabled) and CCTV security, among other things and are worth checking out if you want to buy and only need a smaller business space. 

***

In our Cash Flow Reporting, Budgets and ROI course for Xero, you’ll learn how to deal with the purchase of business premises just like a Cubbyhole in Xero. Visit our website for more information on our variety of online training courses or enrol today!

learn online training Xero courses videos for less

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

Cash Flow Reporting in Xero

Show me the money!

learn cashflow reporting in xero online training course videos
Creating a cash flow report in Xero will tell you more about the financial state of your business than profit and loss statements.

IN OUR BRAND NEW Cash Flow, Budgets and ROI Xero Training Course, you’ll learn how to generate a cash flow report for your business.

Cash flow reports show the money going in and out of the business, so they’re better indicators of a business’s overall financial health than a Profit and Loss statement (P&L).

A cash flow report enables you to make forecasts and budgets for your business based on previous trends — recurring expenses, average time to get paid, seasonal quiet periods, and so forth.

The 3 cash flow categories

Cash flow reports are typically broken up into three categories:

  1. Operating activities: cash flowing in and out of the business from revenue-generating activities
  2. Investing activities: cash flowing in and out of the business from the acquisition and sale of long-term assets
  3. Financing activities: cash flowing in and out of the business from borrowings and changes in equity.

Items in a cash flow report

In our Cash Flow, Budgets and ROI Xero Training Course, you’ll learn how to generate a cash flow report in Xero. That report will show every transaction that’s run in and out of your business, divided among one of the three categories.

In the operating activities category, you’ll typically find things like costs associated with any training courses or seminars, advertising and marketing expenses, income or commissions from your business, subscriptions to any magazines or periodicals, etc.

Under the investing activities category, you’ll find the cost of purchasing office or warehouse space and the capitalised borrowing cost, for example.

The financing activities category will show the loan you’ve taken out to purchase your business’s office or warehouse space.

You’ll learn how to generate and work with cash flow reports in our new Cash Flow Reporting, Budgets and ROI Training Course. ENROL now or read more about the benefits of cash flow reporting to your business. Are you a sole trader or contractor needing to record your ongoing expenses? We cover that too!

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. Or learn more about our entire suite of online software training packages and social media training packages.

Posted on by

Importing Bank Statements into Xero

Making bookkeeping easier, faster and more accurate

importing bank statements into Xero online learning course training videos
You’d be surprised how many business owners don’t even know how to import their bank statements into their accounting software. Are you one of them?

WE HAVE CREATED A brand new Cash Flow Reporting, Budgets and ROI Course for Xero and one of the things you’ll learn is how to import your bank statements into Xero.

The sales spiels of many of the notable online accounting software packages like QuickBooks, Wave Accounting, Outright, Kashoo, LessAccounting, Clearbooks and even Xero, claim that this feature will save you time and effort as it imports your bank transactions. The truth is, this is not foolproof and won’t work 100 percent of the time (even if it’s just a matter of not being able to get your software and your bank to “connect” just as your mobile phone connection inexplicably doesn’t work sometimes).

Therefore, always double check your bank transaction data has been imported accurately. This said, importing your bank statement into Xero (or whatever accounting software you use) is a really important step in the bookkeeping process that a lot of business owners forget or don’t know how to do. And the technology is only going to get better!

Using the correct format

To import your bank statement into Xero, you must ensure it’s in the correct format. Xero can only work with a CSV file of your bank statement. Depending on your bank, you might be able to download your bank statement as a CSV file from your internet banking, or you will have to create one from scratch.

Creating one from scratch isn’t too difficult. If your bank doesn’t give you the option of downloading a bank statement as a CSV file, you can create one yourself in Microsoft Excel.

You can download an Excel template from Xero. It includes the recommended fields and is already set up as a CSV file, so all you need to do is add in your data.

Set transaction rules

Once you’ve created and uploaded your bank statement to Xero, you’ll need to set up transaction rules for recurring expenses. You’ll learn how to do this in our Cash Flow Reporting, Budgets and ROI Xero Course.

Setting rules for recurring transactions helps speed up the reconciliation process, which depending on the type of business you operate and how often you reconcile your account, can be the most time-consuming part of the process.

Importing your bank statement and creating rules for transactions that occur each week, month fortnight, year, etc, greatly speeds up this process.

No CSV? Use bank feeds

If your business has lots of expenses every week, and your bank doesn’t let you download your bank statement in a CSV format, you may find that manually creating one in Excel each month is too time consuming.

Set up bank feeds instead. Bank feeds is the process of linking all of your business accounts, whether they’re credit cards or bank accounts, to your accounting software, so that each time you make an electronic purchase, it’s automatically imported into your accounting software.

This will allow you to reconcile your account each fortnight, week or more frequently, if you desire, than once a month when your bank statement comes in.

***

Bank feeds save your business time and money. Find out more about setting up automatic bank feeds in Xero and importing bank statements into Xero. You can also read more about our new Cash Flow Reporting, Budgets and ROI Course for Xero, visit our website or enrol today!

learn to use excel online training course videos cheap best

Learn Microsoft Excel from scratch or brush up your Excel skills, at your own pace, with our affordable Excel online training courses — where you get THE LOT (that’s 9 courses in total) for ONE LOW PRICE — everything included! Volume corporate discounts are available and our courses count towards CPD Points. NOW is the time to learn to use Excel, one of the most-used software applications in the world.

 

Posted on by — 1 Comment

Is a Certified Advisor or Certified Consultant Better Than a BAS Agent?

Finding the best bookkeeper for your business

find a good bookkeeper xero myob quickbooks learn online training course videos
A bookkeeper who’s certified in a particular accounting software may not mean that much for your business. Better to have someone who is simply a good bookkeeper. Period.

IT’S NOT ALWAYS EASY to find a bookkeeper who suits your business’s needs. This can be further complicated by the fact that a lot of business owners don’t know too much about bookkeeping.

Now that virtual bookkeepers have become more common, lots of business owners have started selecting bookkeepers based on their affiliation with an accounting application. Such bookkeepers are often called a Certified Advisor (Xero), Pro Advisor (QuickBooks) or Certified Consultant (MYOB). But are they really the best bookkeeper for your business?

What are Certified Advisors, Consultants and Pro Advisors?

In a nutshell, a certified advisor, consultant or pro advisor is just an individual who has been endorsed by a software company because they’ve demonstrated a high level of knowledge and skill with a particular accounting product.

Hiring a bookkeeper who’s been endorsed by MYOB, say, means you shouldn’t have to worry about whether your bookkeeper has set up your accounting package correctly, or whether they’re using the correct codes. What it doesn’t guarantee, however, is that each consultant or advisor is a highly experienced BAS agent, as the certification relates to their software knowledge only.

Certified Advisors and Pro Advisors go through their certificate, which is often free, because it elevates their own profile. It can also demonstrate that they are committed to that software program more than others. The Xero Certification training (at the time of writing) has a strong focus on understanding how to use the Xero Agent portal to bring clients onto the platform – and not so much about learning bookkeeping or to become a BAS Agent.

If you don’t have an accountant or BAS Agent then you should make that your starting point as everyone needs someone who can perform tasks that relate to tax and GST who acts on your behalf. If you have that setup already you can hire someone who has good bookkeeping skills using MYOB or Xero but is cheaper because they are not registered or licensed. This junior bookkeeper can perform your office admin, accounts and even customer service while your Registered BAS Agent or Tax Accountant can sign off on your financial figures.

Find a highly qualified BAS or tax agent instead

Sure, a bookkeeper who’s experienced in your accounting package is important. It’ll help keep your bookkeeping bill down because they’re able to perform certain functions quickly, while your accountant shouldn’t need to fix any errors, either. But that’s only providing that they’re as knowledgeable in Australian tax as they are MYOB or Xero or QuickBooks.

Unfortunately, however, the two aren’t mutually exclusive. So instead of focussing on a bookkeeper’s software experience, it’s more beneficial to ensure they’re qualified BAS and tax agents, with either a Certificate IV in Bookkeeping or higher.

If you don’t get a bad reference from their current and former clients, then there’s a pretty good chance they’re proficient in the major accounting packages, and if they’re not, most bookkeepers will tell you upfront.

Get the accounting package that’s best for your business, not your bookkeeper

There are lots of reasons a bookkeeper would choose to become certified with a software company, the biggest being that they get their accounting software for free and receive a commission for each new client they sign up to use the accounting package they’ve been certified with.

However, when you hire an independent bookkeeper who’s well-versed in a few different accounting packages, you’re more likely to get better advice about which accounting package is best suited to you and your business’s needs, rather than the accounting package that will generate income for your bookkeeper.

***

Are you looking to brush up your skills in cloud-accounting packages like XERO, MYOB or Quickbooks? We provide a range of online training courses in all of these packages at ONE LOW COST for ALL SKILLS LEVELS. Find out more.

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

3 Things You MUST Do in Excel!

Business owners and job seekers take note!

learn xero myob excel online training course videos
Excel isn’t just for budding bookkeepers; it’s a great tool for all business owners to know.

MICROSOFT EXCEL IS THE most widely used spreadsheet application in modern computing. That said, it’s also one of the more difficult programs of the Microsoft Office Suite to learn, which is why we recently updated the content of our Excel training courses.

A lot of people do our Excel training courses to help them “skill up” to find a job, find a position better suited to them, or develop their career path. However, Excel is a fantastic tool for small business owners as well.

But whether you use Excel to create a pivot table or a database, there are a few things you should do each time you open an Excel document. Here we present you with three:

1. Vertical align: always centre

Always align the text in the cells of your Excel spreadsheet to the centre, or the top in certain circumstances. But never, ever align it to the bottom. It’s hard on the eyes and, when you’re looking at lots and lots of data in lots and lots of cells, it becomes difficult to know which row, column, etc, you’re looking in. Centre alignment, always.

2. Build error-checking into formulas

There should never be an instance where one of your workbooks is showing a #DIV/0, #N/A, #REF, #NAME?, #NUM!, or #NULL! error. This is especially true if you’re sharing these workbooks with your business partners or accountant or whomever.

Seeing an error in a financial report may cause the reader to doubt the accuracy of the entire workbook, so ensure your workbooks remain error free by using the simple IFERROR() error-checking function in Excel.

3. Print preview your work

Again, if you intend to share workbooks with other people, you should always ensure that your Excel workbooks can be printed nicely and easily, even if you don’t intend to ever print the document yourself. This is easy enough to do via File > Print Preview and adjusting the print margins before sharing (or printing) the document.

However, judging by the number of times I’ve printed an Excel document only to collect 87 sheets of paper off my printer to read the contents one 4×4 table, the function is seldom used by anyone else but me!

***

For more Excel formatting tips and tricks, download our FREE Beginners’ Guide to Excel, or enrol in our intermediate or advanced online Excel training courses to learn how to create databases, pivot tables, charts, graphs, and much more…

Read more about our beginners, intermediate and advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow!

learn xero myob excel cheap online training courses videos

At EzyLearn, we’re committed to helping students of our MYOB, Xero and Quickbooks courses gain employment as a bookkeeper or even start their own bookkeeping business; it’s why we provide you with lifetime access to our online cloud-accounting training courses as part of our commitment to continuing professional development. 

 

Posted on by

New Financial Year, New Financial Habits

Help us help you get your business financials set up right

account set up with xero online training learning course
Taking time to set up your accounts correctly at the outset and recording your reconciliations regularly will save you time, money and a nasty, aching headache!

SO WE’RE INTO THE new Australian financial year. With the start of each financial year comes the chance to right last year’s financial habits and avoid repeating them again. You know what they say about people who repeat the same actions over and over again expecting different results …

If you had a crazy end of financial year, try starting off the next 12 months (well, 11 now, can you believe it!) on a positive footing, with these good financial habits.

Check your accounting software is set up correctly

Something that causes businesses and their owners countless headaches at tax time is accounting software that’s been setup incorrectly or not set up completely. Transactions that are coded wrong or bank feeds that are connected to the wrong account — or too few accounts — can leave you in the middle of a bookkeeping nightmare come June 30.

Spend some time sorting this out, or employ a bookkeeper to get you set up correctly. It’s worth that little bit of extra time now to get it right, truly!

Aim for daily reconciliations

Reconciling your business accounts regularly is important for a number of reasons, fostering good habits being chief among them. You may not need to reconcile your accounts each day, but it’s certainly a lot easier to find 10 or 15 minutes two or three times a week, rather than two or three hours once a month. The most often you do your bookkeeper the more unlikely it is that you’ll leave it pile up, eventually requiring costly rescue bookkeeping. You’ll also have a much better picture of your business’s performance with current accounting data.

Monitor cash flow

Positive cash flow is the marker of a healthy business. Negative cash flow is not. There are plenty of seemingly profitable businesses suffering negative cash flow that threatens to put them out of business. Don’t let yours be one of them. Create your own cash flow forecast reports in Excel or use a cash flow forecasting or expense app to determine if you’ll have enough money in the bank to meet your ongoing commitments (which includes paying yourself a living wage to meet your personal commitments).

***

Our cloud accounting training courses will show you how to set up your accounting software correctly. Learn how to use Xero, Quickbooks or MYOB with our online training courses and be able to invoice customers on time, reconcile your account and run financial reports, including cash flow statements. Visit our website for more information.

cashflow reports in xero and excel

Xero for less…

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 by

Why are there More Expense Tracking Apps for Xero than MYOB?

accounting-apps-that-link-with-xero-and-quickbooks

Less complicated accounting software, like Xero, connects better with mobile apps

accounting-apps-that-link-with-xero-and-quickbooks
The robust nature of MYOB can make it harder to link with mobile apps that track your expenses and cash flow and the like.

WE RECENTLY PUBLISHED A blog examining the different expense tracking apps you can connect with Xero, MYOB and QuickBooks, but during our research it became clear that most expense apps integrate with Xero or QuickBooks, but not MYOB.

That’s not to say there are no expense apps that integrate with MYOB. There are. Receipt Bank is one, Squirrel Street is another, and there are probably a lot more on the MYOB marketplace (or add-ons page). Probably the best expense tracking application we found is ExpenseManager, and it only integrates with MYOB.

Continue reading Why are there More Expense Tracking Apps for Xero than MYOB?
Posted on by — 1 Comment

Cash Flow Forecasting and Reporting Apps for Xero

Do you know how happy your business is?

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

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

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

Posted on by — 1 Comment

Top 3 Expense Applications for Xero, QuickBooks and MYOB

best-apps-for-myob-xero-quickbooks

Get your financial software working harder

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

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

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

Here are some other expense tracking app integrations.

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

Expensify, Xero and Your Retail Shop

Record retail inventory quickly

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

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

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

Input data and send to Xero

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

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

Create expense reports

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

Automatic approvals cut bookkeeping time

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

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

***

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

Social Media and Digital Marketing online training course_comp

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

 

Posted on by — 2 Comments

Financial Reporting with Expensify and Xero

How Expensify can link with Xero

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

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

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

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

Posted on by

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 by

Are You Making these GST Mistakes in Your Bookkeeping?

find a good local or remote bookkeeper

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

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

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

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

Continue reading Are You Making these GST Mistakes in Your Bookkeeping?