by martieLast Updated : Jun-19-2023
Is your team still using Spreadsheets for creating and tracking purchasing orders?
Most Biotech or Pharma companies start their purchasing process with emails and spreadsheets.
In the beginning, there are only a few scientists, and then the lab grows, and you need to purchase more lab supplies and capital equipment to run the experiments.
At some point, the email-based approvals for purchases become unsustainable.
Moreover, investors require better cost controls and visibility for compliance purposes.
If you are a CFO/controller of the company, you probably have the following questions and concerns:
If you are thinking about these questions, you are not alone.
We have helped many Biotech companies’ finance teams answer these questions and gain better cash flow visibility.
In this article, you will learn:
Are you struggling to track the purchase orders of your company? If so, we highly encourage you to download a free copy of our order tracking sheet to help you centralize your order tracking in a single place!
Let’s get started.
The main issue with the manual spreadsheet process is the loss of efficiency and your inability to track expenses unless the books are closed at the month-end.
Let’s first look at a typical process, where the choke points for efficiency are, and what we can do to unplug those efficiency blocks.
We assume lab technicians are requesting a purchase that lab managers and finance approved.
The current process looks like this:
If you have an approval process for purchasing lab supplies, the first step is for the lab technician to request the purchase.
Spreadsheets could do this, or you probably have a requisition form that needs to be attached to the request for purchase.
Most companies resort to just sending purchase requests via email.
You must first visit different vendor websites, find what you are looking for, enter that information in a requisition form, and then request approval.
The challenge here is not that the request process is manual. It also takes more time to have the purchase request approved because the lab manager might not have enough information to approve the request.
Once the request is ready for approval, the request is sent for approval before the lab technician can place the order for lab supplies.
There are a couple of challenges with this manual approach:
Due to these reasons, email-based approvals are not effective
Once all the approvals are in place, the lab technician must place the order with the vendor.
There is a duplicate effort here:
First, the lab technician has to go to a vendor’s website, find what they want to purchase, get the total cost, and send it for approval.
And once it is approved, the same effort must be duplicated on the vendor’s website to place the order.
Some vendors don’t have online ordering and request a purchase order.
That is another additional step; you must create a purchase order on a spreadsheet if you don’t have a purchasing system.
Once you have placed the purchase order, you need to track the purchase order, and that becomes another spreadsheet!
Here are the things that need to be tracked:
After receiving the purchase order, the next step is to let the AP team know you have received it so they can pay the vendor on time.
You got the product; now you need to track what has been consumed and what is being used by whom.
Theft is not an issue for many companies, but if you are not keeping track of what is being used and by whom, there is a potential for theft.
If you don’t have an inventory system, you probably have another spreadsheet for tracking the lab inventory.
You, of course, need to track who is using what inventory, but you also want to track the date of expiry and lot numbers to trace back the usage to the lot number easily.
Tracking inventory also allows you to book costs for different experiments.
So if your finance team wants granular spend visibility, they probably want to track expenses at different projects/experiments.
Looking for a better way to automate the purchasing process for your lab supplies? Click here to see ProcureDesk in action.
So how do you go about simplifying the lab supplier’s purchasing process?
The sections below will cover a step-by-step process and show how to improve the lab’s productivity. Specifically how a purchasing system can help simplify the process for lab purchases and order tracking
The first is automating the purchase requisition process so that you do not spend endless hours chasing the managers for approval.
Here are the key ingredients of a purchase requisition process.
The following screenshot shows how a requisition would look like in a purchase requisition process:
On average, companies can have up to 12 -24 hours long purchase order approval cycles. The longer the approval process, the more time it takes to place the purchase order and receive the products.
Here are some ideas on how to reduce the purchase approval cycle time:
Here is an example of an effective workflow:
CFOs care about cost control, and so should you 🙂
The finance team monitors the cash flow so you don’t run out of money. The finance team must review large purchases in advance to control the purchase order timing based on the projected cash flow.
So how do you involve finance in the approval process?
Here is how to include finance in the approval process:
The other benefit of involving finance in the approval process is that they can validate the chart of accounts assigned to the purchase.
This allows for the cost and accurate financial accounting to be booked to the right account.
Why spend time entering purchase requisition data when you can choose what you want to purchase?
If it is no different from the online shopping experience that you use for personal purchases.
There are primarily two types of catalogs that you can leverage
With external catalogs, you can browse the vendor’s catalog and pick what you want to purchase. This is called a punch-out catalog
Here is an example of a punchout catalog:
Once you have decided what to purchase, you can transfer the shopping cart to your purchasing system.
You can even automate the coding of the purchase requisitions so that the technicians don’t have to worry about entering the correct cost codes.
If you are concerned about limiting the purchase to selected items, a punchout can also handle that. You can ask the vendor to limit the number of items or the type of item that is available for purchase.
Not all vendors can’t support a punchout catalog.
It could be that they don’t have the infrastructure to support it, and some vendors probably won’t issue you a punchout because your purchasing volume is low.
In that case, you can ask the vendor to provide you with commonly purchased products or services, and you can create your catalog.
Here is an example of an internal catalog:
Internal catalogs give you better cost control because you can limit what you show in the internal catalog and adjust pricing as needed.
Once you have placed the order with the vendor, you need to track the lifecycle of the purchase order.
Now it is more important than ever to track the purchase order because of the uncertainty in the supply chain.
With a purchasing system, you can centralize the order tracking once the order is placed.
Here are a couple of ways:
Here is an example of how you can track purchase orders:
So far, we have covered the process for ordering the lab supplies.
But how do you keep track of that?
How do you know what you have in Inventory at any time? What lots have expired and can’t be used?
You need to know all this important information to manage the inventory effectively.
Here is what we recommend for tracking the inventory of lab supplies.
You can maintain different locations in an inventory system if you have multiple labs.
However, you might also want to arrange inventory by different bins/locations within the same lab.
By organizing the inventory in different locations, it is easy to track and report on inventory. For example:
This also allows you to easily transfer the inventory between different locations to make effective use of inventory.
Let’s say you have excess inventory at one location and a nearby location needs the same product; then, it is easy to transfer and keep track of the transfer.
How do you track who is using what product in the lab?
That is where a release management process comes into the picture.
A release management process not only helps you track inventory that is being released for consumption but also allows you to track the following:
You get accurate usage reports and cost allocation to different projects.
Want to know how much inventory you have at hand and the total value of the inventory?
That is where inventory valuation comes into the picture.
With the built-in Inventory reports, you can easily track how much inventory you have and the total inventory cost.
For example, if you group up your inventory into different categories, for example, Chemicals, beakers, etc., then you also track the inventory value by these categories.
Here is a sample inventory valuation report:
In this article, we have covered an end-to-end process to help you reduce the time spent purchasing and tracking inventory.
By leveraging this process, most of our clients have seen results like this:
Curious to see how ProcureDesk can help you achieve these results?
Click on the button below to schedule a demo and see for yourself.
What you should do now
Whenever you’re ready… here are 4 ways we can help you scale your purchasing and Accounts payable process.