Tag: Spreadsheets to Software
Purchasing the Wrong Mix of Merchandise
You lack inventory visibility—you are not aware of what is currently on the shelves, etc. Your current method of viewing inventory levels is inefficient, and it is difficult to determine what to order. You order often, but a high percentage of the time, your orders are inaccurate. This has a negative, costly impact. You have inaccurate sales history/data. Your current method of receiving sales history/data is inefficient. You use this data in various ways, but it is often inaccurate. However, it is also difficult to determine whether it is inaccurate, and if it is, there are negative consequences. It is…
Read More »Time and Cost to Manage Vendors and Purchases
You spend a lot of time managing low dollar purchases. A high percentage of your transactions are under $2,500, and a high percentage of those transactions are of your total dollar spent for those small purchases. Too much time is spent on purchase requisitions, purchase orders, and invoicing. It is a manual, paper-based process, and your cost/transaction is too high. You manually track merchant data. You do not have easy access to tax information. It is difficult to track purchases made with each merchant, and you are unable to negotiate special pricing based on volume purchases. You think you may…
Read More »Risk Non-Compliance
You do not have support for multiple types of pay. You need to classify multiple types of pay as the same type, i.e. hourly if using paid time off, etc. This makes it difficult to get detail on type of pay. You need to setup multiple types of deductions/benefits as the same type. This makes it difficult to get detail on type of deductions/benefits. You need to manually update tax tables as new rates are released from the Federal or State. This takes too much time, and sometimes there are errors. This has had a negative impact and has resulted…
Read More »Time and Cost to Manage Payroll
Your payroll applications only support a finite number of employees, and this number is too low. If you went beyond it, there would be a negative impact. You do not have support for multiple types of pay codes. You need to classify multiple types of pay as the same type, i.e. hourly if using paid time off. This makes it difficult to get detail on type of pay. You need to setup multiple types of deductions/benefits as the same type. This makes it difficult to get detail on type of deductions/benefits. Your payroll application does not support direct deposit and…
Read More »Late and Inaccurate Payroll
You do not have support for multiple types of pay. You need to classify multiple types of pay as the same type, i.e. hourly if using paid time off, etc. This makes it difficult to get detail on type of pay. You need to setup multiple types of deductions/benefits as the same type. This makes it difficult to get detail on type of deductions/benefits. Your payroll is not integrated with your financials and banking applications. You have to send reports back to the general ledger clerk to make transactions to track cash flow in bank reconciliation and cash flow. This…
Read More »Difficulty with Order Fulfillment
It is difficult to check the status of a PO, and the way you do so is inefficient. You need to manually track quotes or use third-party software. You manually enter transactions to accept deposits and have to manually update the general ledger accounts. You manually track orders and may use a program such as Excel. It is difficult to tell whether or not items are in stock. You need to wait until the stock is replenished and manually enter the order at that time. You have to wait until the order is filled and then manually update inventory. That…
Read More »Fines and Lawsuits
Your current method of compiling information for W2s is inefficient. If it is a manual process, it takes too long and it is a challenge to complete them on time as required by law. Sometimes, to have to redo them due to inaccurate numbers, and you cannot produce the new year’s payroll without having finalized W2s, etc. from the previous year. It takes too long to create required quarterly reports for workers’ compensation and unemployment. They may not be accurate the first time. You have to pay unemployment. Your current approach to tracking/paying your unemployment is inefficient. You have to…
Read More »Inventory and Order Processing
The order desk is unaware of promotions or special discounts for customers. This has cost your business too many times, and customers get upset if they don’t get the best price. Customers don’t always know the part numbers to order. This happens often, and it is difficult and time consuming for you to determine what they want to order. Customers get frustrated, and the order desk sometimes orders the wrong item. As a result, customers get upset, and they think your company is difficult to do business with. The order desk takes orders for items that are out of stock…
Read More »Management Payroll
You either manually update general ledger accounts with payroll information or are using some type of export from one system and import into your financial system. Whoever does this uses a process that takes too much time. The cost associated with this process is high, and it causes inconsistency between systems or errors. You do not have a system to manage HR processes, such as recruitment/applicant tracking. Your HR and Payroll systems are either integrated, or if not, it takes too much time to reenter shared data. You have inconsistencies, and too much time is spent trying to reconcile and…
Read More »Inventory Control Issues
You have too much inaccurate inventory and do not do physical cycle counts often enough. You have to shut down the warehouse and this costs too much. The delta between actual inventory is too high of a percentage, and the system says you have something that you don’t too often. This may be because of damaged items, theft, and/or internal usage. It is difficult to track items. You need to identify specific inventory by lot or serial numbers but you do not assign your own serial numbers. If you do, it is a manual process that takes too much time…
Read More »