An in-depth view on how to get a better handle on managing fixed assets and the cost benefits of adding bar code data capture to improve tracking and power asset control through automation
by Mike Burnham, Panatrack
Many businesses, regardless of their industry, have the need to manage their fixed assets. Microsoft Dynamics GP offers strong fixed asset management capabilities. However, the upkeep and manual tracking of fixed assets can be unreliable and leave users with an inaccurate financial picture. Adding barcode data capture can dramatically improve their tracking efforts through automated data capture to create a simple and powerful platform for asset control.
Management challenges
Are you compromising the accuracy, completeness and uniformity of your asset records due to a manual record-keeping process? Without tools to easily tag and receive new assets, it is easy for asset management initiatives to fail. Asset tracking accuracy is further compromised without an effective tool to record when assets are moved, re-assigned, or disposed. Keeping an accurate register of your organization’s fixed assets can be a time-consuming task, especially when the number of items is in the hundreds or thousands.
Microsoft Dynamics GP Fixed Asset Module provides a centralized database for managing asset records and is tied directly to your GP financials. Not only does it provide the financial record keeping for your assets, it also offers fields to record where your assets are located at any given point in time, and who is in charge of them. There are fields to track key information about your assets outside of acquisition data and costs. However, the challenge for many organizations is keeping track of the physical location of the asset and its current custodian assignment. Without this up-to-date information, an asset ledger has little value. Some scenarios can be described as follows:
- you have Dynamics GP, but your company’s fixed asset information is housed in an Excel spreadsheet and remains separate from your financial data. Now you are wasting time reconciling your asset list to your financials
- your fixed asset log has not been updated since Bob in Accounting left the company. Your list is now badly out of date. Where do you start?
- the assets housed in a remote office were moved, and the new locale—and custodian— was never updated in the database
- your company has grown from 20 to 200 employees and your fixed assets have grown substantially. You’re not sure who has what or where it’s located. Now what?
- you have staff that manages assets, but they don’t have access to your financial database to update the asset record (nor do you ever want them to have that access).
Fixed assets
Let us start with some basics. In accounting terms, fixed assets are classified as items that fall under the Property, Plant and Equipment (PP&E) category. These are business assets that are not sold to an end user; rather they are used internally to keep the business operating.
Some examples are: technology hardware, such as computers, laptops, servers, routers · medical equipment, such as pumps, X-ray machines, diagnostic equipment, office furniture, desks, chairs, copiers, fax machines, phones, vehicles used for your business, plant equipment and machinery, valuable educational items loaned to students. Recently, some companies have failed an external audit review due to poor control over company assets. When dealing with larger volumes of moveable assets, tracking their movement and assignments becomes critical.
The advent of Sarbanes-Oxley (SOX) legislation in 2002 necessitates even greater accuracy and control over your financial records. The Sarbanes-Oxley Act places burdens on corporations, imposing strict penalties for non-compliance for the accuracy of their financial reporting. Compiling an accurate financial picture of a company requires accurate fixed asset records. Although SOX applies only to public companies, there are similar implications for private and nonprofit organizations.
Completing a physical verification of fixed assets—with ease— is a common issue. This becomes a futile exercise if the asset records are not continually maintained. By keeping fixed asset records up to date, companies can reduce expenses through loss prevention and improved equipment maintenance. They may also be able to reduce new and unnecessary equipment replacement purchases.
More importantly, accuracy saves you money. Fixed assets and their depreciation values can be written off at tax time. An accurate record of what you have is necessary for auditors to take full advantage of this write-off. Without accurate records, you put your credibility at risk.
Expensed assets
Many companies have a threshold amount for setting up depreciation of their assets. However, many organizations have assets they expense that they should still track, including cell phones, laptop computers, monitors, and small tools. You can use the same asset tracking infrastructure to manage these assets, regardless of your intent to depreciate these. For tracking within GP, consider setting up different asset classes. The asset class assignment can then identify if the assets are tracked financially as well as physically. When tracked physically, a check in/check out assignment can be put in place. By managing these ‘expensed’ assets, you manage where the asset is and who has it. This will add accountability across the organization and reduce the need to replace these items simply because there is no recorded accountability. You can even add a replacement value using one of the several user-definable fields available in GP. Adding the responsibility for items with an assigned replacement value will increase accountability across an organization.
Grouped assets
At first, it may appear to be easier to create a single asset record for a group of received assets. For example, if you receive 20 laptops, they will all start out with the same depreciation schedule. It may seem easier to create a single asset record for all 20 laptops (after all, there is a quantity field available). Each of those laptops will have a unique serial number. However, only one serial number can be associated with each asset record. Even if you are not tracking serial numbers (recommended whenever possible), each asset can only have one custodian and one physical location assigned to it. The goal is to keep track of each asset.
Only then can you ensure that its location and current custodian are known. Of course, more work should not be made for the financial team, so consider taking advantage of grouping assets, or the assignment of a Master Asset ID along with Asset Class assignments to handle managing the financial tracking of groups of assets put into service at the same time. This approach streamlines the financial control while providing tracking of individual assets.
Bar codes
Using bar code technology and asset ID tags simplifies the asset tracking process, and will maximize the value of the fixed asset module. Unlike spreadsheets or manual paper-based tracking, bar code technology is simple, efficient, and robust enough to keep apace with assets that frequently move and change hands. Bar code data capture decreases the margin for human error when updating a spreadsheet, while adding a measure of security by marking your asset ‘property of’.
Consider the following applications: a national professional sports team uses bar code technology to keep track of its office and training equipment; a hospice uses bar codes to monitor its fleet of wheel chairs and diagnostic equipment; an HVAC company keeps track of equipment and tools checked out to jobs; a communications company tracks equipment leased to its customers; a home-healthcare provider tracks equipment in use at patient’s homes; a technical college manages equipment loaned to students each semester; a legal-services firm manages the assignment of laptops and cell phones to its employees; an internet hosting company tracks its servers and networking equipment.
Point & Scan
You already have the tracking database for Fixed Assets available to you as part of GP, and anyone can put a label on an asset. Now you need a convenient way to scan that label and update your asset list. The PanatrackerGP fixed asset solution extends DynamicsGP’s Fixed Asset Module by adding bar code data capture. Physical characteristics of the assets can be captured from a handheld device using a simple-to-use interface and updated simply and directly, without messy data transfer steps. This allows for a seamless integration and eliminates ugly import and export requirements in order to keep GP updated. Organizations that currently use spreadsheets to track asset details can replace their separate tracking system with a tightly integrated solution.
Operating through the use of handheld mobile computers with integrated scanners, the system makes it easy to capture asset data housed in remote locations. Users can:
- add new assets. This creates a new asset record for GP. Simply affix and scan the bar code asset label to assign the ID and collect physical details about the asset such as serial number, short description, and location. If using GP purchase orders, assets can be easily received, creating both the receiving transaction and fixed asset record. The transaction is created directly in GP.
- record updates to asset location or custodian assignments as they occur. The user-defined fields within GP are also supported
- confirm the location of your assets with a physical verification. Users have access to the asset details and can determine assets not found. Assets found out of place can automatically be updated or log an exception report
- assign or reassign bar code labels to existing assets and filter based on location, class assignment or by scanning the serial number.
The fixed asset module updates asset information without accessing or altering any of the financial data that lives in Dynamics GP. This allows it to remain the central reporting database while providing a tool to maintain physical information about assets. The module also works in hosted environments and does not rely on a continuous network connection. Furthermore, solid asset management practices will save money and help avoid costly mistakes. by adding fast and clean data capture capabilities for fixed assets.