Xero Accounting software offers inventory management features in their standard software but it has never been spectacular for companies where solid inventory management matters.
I saw that first hand when I was speaking with the owner of a Boating Sales, Repair and Retail business. That business ended up migrating AWAY from Xero and started using QuickBooks Online instead. This changes everything.
Continue reading Finally, Xero Acquires an Inventory Management Software Add-on in the US
In 2015 I wrote about Xero’s inventory management when it was released and how important it was to make it competitive with MYOB AccountRight. These days however it seems that Xero hasn’t done much more and they’re a bit behind Intuit’s QuickBooks Online which has a lot of inventory and stock management features.
I’ll explain and drill down a bit.. Continue reading Inventory and Stock is more beautiful using QuickBooks than Xero
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.
The case for a monthly stocktakeThe 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.
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.
Do a monthly stocktake by running your inventory reports in Xero. You’ll be able to work out whether your stock:
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.
***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.
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.
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.
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:
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.
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.
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.
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.
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.
