FREE Xero Training Video: How Often Should You Check Your Inventory in Xero?

The key to cutting down discrepancies is consistency

IF YOU RUN A SHOP or business that holds stock, you should be in the habit of checking your inventory regularly. A lot of retail stores only check their inventory every quarter; others every year. This is usually because a stocktake is a big job.

Stock and inventory stocktake and count - inventory in Xero & MYOB Advanced Certificate Training CoursesThe case for a monthly stocktake

The inventory feature in Xero was a functionality that was missing for many years — but then Xero caught up.

Running an inventory report in Xero is pretty easy. The hard work sets in when you have to count your inventory to account for any discrepancies. There are usually always differences between what Xero says you should have in stock, and what you actually have on hand. The more frequently you run them, the fewer discrepancies you’ll find.

Like anything in the bookkeeping process, the more frequently you do something — be it reconciling your account or chasing up late payers — the easier and quicker it is. Where a quarterly or yearly stocktake could take half a day or more, a monthly one may only take you a couple of hours.

Understand trends in your business

A monthly stocktake is a good way to get to know your business, and understand its certain trends and idiosyncrasies. In particular, it helps you with ordering and making related business decisions.

A shop selling food, for example, needs to be wary of ordering stock that doesn’t sell quickly and ultimately goes out of date. A monthly stocktake will help you keep track of this, and monitor which items sell quickly and which don’t. Likewise, a monthly stocktake of a furniture shop lets you determine which pieces spend long periods in storage, and manage your ordering accordingly.

Run inventory reports in Xero

Free Xero Training Course video about inventory reporting
Click Image to see FREE Xero Training Course video

Do a monthly stocktake by running your inventory reports in Xero. You’ll be able to work out whether your stock:

  • is ageing (for technology retailers)
  • is going off (food)
  • costs more money to store (furniture); and, subsequently, how long it can take to sell before it’s costing you money. 

If you are new to bookkeeping it’s probably a good idea to learn more about some of the basic Xero reports you can produce for a business.

MYOB or Xero online accounting course training videos***

If you only have a very basic knowledge of Xero, cloud accounting or bookkeeping, and you’re looking to gain a better understanding of basic bookkeeping terminology, get our free Basic Bookkeeping Guide

You’ll learn how to run reports in Xero, in particular inventory reports, in our Xero training courses. Visit our website for more information or to enrol and see course prices.


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.


 

End of Financial Year: Writing Off Stock

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

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

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

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

Understanding your inventory’s performance

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

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

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

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

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

Inventory reporting

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

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

Stock write offs and future orders

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

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

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

Act NOW for EOFY

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

***

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


find a local bookkeeper

We feature our own online directory of local bookkeepers looking to add to their customers. Visit National Bookkeeping to find a suitable and experienced person available to work in your area, or able to work anywhere in the cloud. Alternatively, if you are a bookkeeper looking to expand your client list or find contract work, you can register and become part of our network for free