BioSource Automates Bulk Material Procurement, Logistics & Billing with a Custom Development Platform

The Solutions

Quickbase Became the Central Supply Chain Operations Platform

Quandary Consulting Group designed a custom Quickbase procurement and supply chain management environment around BioSource's end-to-end material lifecycle; Quickbase centralized:

• Customer information
• Vendor information
• Mill requests
• Existing agreements
• RFPs
• Vendor bids
• Purchase orders
• Deliveries
• Tonnage
• Request status
• Notifications
• Reporting

The platform created a single operational record connecting the activities surrounding every material request, which that instead of managing sourcing, logistics, and delivery as independent processes, BioSource could manage them as one connected transaction.

Creating a Centralized Request Intake Process

The new workflow gave BioSource a more structured and flexible approach to managing mill requests by establishing Quickbase as the centralized system for request intake and tracking.

Mill contacts could submit requirements for their location directly through Quickbase, while BioSource personnel could also enter requests received through email or other communication channels. Regardless of how a request originated, information could be captured within the same standardized workflow, creating a consistent record for subsequent processing and fulfillment.

Once submitted, automated confirmations notified mill contacts that BioSource had received their request, eliminating uncertainty and establishing transparency from the beginning of the process. Authorized mill users could also access Quickbase dashboards to review recent requests, monitor current statuses, and track progress without repeatedly contacting BioSource for updates.

By centralizing intake and providing self-service visibility, BioSource reduced unnecessary back-and-forth communication while giving both internal teams and mill contacts a clearer, more consistent view of every request; the result was a more transparent request lifecycle: Request Submission → Centralized Quickbase Record → Automated Confirmation → Status Tracking → Mill Visibility → Fulfillment

Automating Procurement Decisions and RFP Routing

Each material request entered a structured procurement workflow in Quickbase, giving BioSource a consistent process for determining the most efficient path from request to fulfillment. When a new requirement was submitted, BioSource could first evaluate whether an existing supplier agreement had sufficient capacity to satisfy the request. If adequate capacity was available, the requirement could move directly toward fulfillment without initiating an unnecessary sourcing process.

If an existing agreement could not meet the requirement, Quickbase automatically routed the request into the appropriate RFP workflow, ensuring the sourcing team could begin evaluating new supply options and the resulting decision path created a clear procurement process: Material Request → Existing Agreement Review → Capacity Available → Fulfillment

Centralizing RFP Creation and Vendor Bid Management

Quandary designed a centralized RFP and vendor bid management process in Quickbase, giving BioSource a structured environment for managing sourcing activity from initial request through purchase order issuance.

When additional sourcing was required, employees could create an RFP in Quickbase, distribute the opportunity to appropriate vendors, collect supplier bids, and consolidate vendor responses within the same procurement workflow. This replaced a more fragmented process with a centralized record of RFP activity, vendor participation, pricing, and sourcing decisions.

Once bids were received, BioSource could evaluate whether the responses provided sufficient supply, pricing, and capacity to satisfy the mill's requirements. If additional sourcing was necessary, the RFP process could continue until an appropriate solution was identified and when the requirements were met, BioSource could select the appropriate vendor and move the request toward purchase order issuance and fulfillment.

The completed procurement lifecycle followed a clear path: Material Request → RFP Creation → Vendor Distribution → Bid Collection → Bid Evaluation → Vendor Selection → Purchase Order → Mill Notification

Once the request was fulfilled, automated notifications could update the mill, providing greater visibility without requiring repeated emails or manual status inquiries. By centralizing RFP creation, vendor bid management, supplier selection, and purchase order activity in Quickbase, BioSource created a more consistent and transparent sourcing process while giving employees better visibility into every procurement request from initial demand through fulfillment.

Creating Real-Time Procurement Reporting

Quickbase dashboards and scheduled reports gave mill users and BioSource employees greater visibility into request status.

The system supported daily, weekly, and monthly reports showing open requests, closed requests, recent activity, and current statuses, which meant that instead of repeatedly requesting updates through email, stakeholders gained direct visibility into procurement activity; thus created a more transparent customer experience while reducing administrative follow-up for BioSource.

Automating Delivery Coordination and Material Receipt

Quandary extended the Quickbase solution beyond procurement and vendor selection to connect delivery scheduling, material receipt, and trailer pickup within the same operational workflow.

When a vendor scheduled a delivery, Quickbase could automatically notify the appropriate mill and provide visibility into the expected shipment. This gave mill personnel advance notice without requiring BioSource employees to manually coordinate routine delivery updates between suppliers, transportation providers, and individual locations. Once the trailer arrived and the material was unloaded, mill personnel recorded the actual delivered tonnage directly in Quickbase. That information became the authoritative record of the completed delivery, connecting the quantity received back to the original material request, vendor commitment, and procurement transaction

After unloading was confirmed, the workflow automatically notified the appropriate vendor that the trailer was empty and ready for pickup, eliminating another manual communication step from the logistics process. By connecting procurement with delivery coordination and material receipt tracking, BioSource reduced the need for employees to act as intermediaries between mills and vendors. Quickbase became the shared operational layer for communicating delivery activity, documenting actual quantities received, and keeping each party informed as materials moved from supplier to mill.

The resulting delivery workflow connected: Vendor Delivery Scheduled → Mill Notification → Material Delivered → Actual Tonnage Recorded → Delivery Confirmed → Vendor Pickup Notification.

Tracking Trailer Dwell Time and Improving Asset Utilization

The automated delivery workflow also gave BioSource greater visibility into trailer dwell time, helping teams identify transportation assets that remained onsite longer than necessary.

Once a mill confirmed that material had been unloaded and the trailer was ready for pickup, Quickbase could begin tracking the elapsed time between unloading and final trailer collection. This created a measurable record of how long transportation equipment remained at each mill after the delivery was completed. Weekly review processes could then surface trailers that had not yet been collected, allowing BioSource and its partners to proactively address delayed pickups rather than relying on emails, phone calls, or individual employees to identify outstanding equipment.

The workflow created a clear tracking process: Material Unloaded → Trailer Ready for Pickup → Vendor Notification → Dwell Time Tracking → Exception Identification → Pickup Confirmation

By turning trailer dwell time into structured, actionable data, BioSource established a stronger foundation for reducing unnecessary trailer delays, improving transportation asset utilization, identifying recurring pickup bottlenecks, and strengthening coordination between mills, vendors, and transportation providers.

Automating Vendor Bills in QuickBooks Online

One of the most valuable components of the solution was the integration between Quickbase and QuickBooks Online, connecting completed procurement activity directly with accounts payable.

Once a delivery was completed and the mill recorded the actual tonnage received, Quickbase could reference the predetermined contractual rate and calculate the amount owed to the vendor and using Quickbase Pipelines, the approved transaction data then flowed from Quickbase into QuickBooks Online, where the corresponding vendor bill could be created.

The automated accounts payable workflow became: Delivery Complete → Actual Tonnage Captured → Contract Rate Applied → Vendor Payable Calculated → Quickbase Pipelines → QuickBooks Online → Vendor Bill

This eliminated a significant manual handoff between operations and accounting. Employees no longer needed to reconstruct completed deliveries, manually calculate vendor charges, or repeatedly re-enter procurement information into the accounting system; the operational data captured during fulfillment became the foundation for the financial transaction, improving consistency between what was delivered and what BioSource owed its vendors.

Automating Customer Invoices at Month-End

Quandary extended the same automation to the accounts receivable side of the transaction, creating a more direct connection between completed deliveries and customer billing. At month-end, Quickbase could aggregate completed delivery activity for each mill using the actual tonnage and associated transaction information already captured throughout the procurement and logistics workflow.

Quickbase then generated the appropriate billing information, and Quickbase Pipelines transferred that data into QuickBooks Online to support creation of the corresponding customer invoice, following the appropriate approval process, invoices could then be automatically emailed to the relevant mill and the resulting workflow connected operational activity directly to billing: Completed Deliveries → Actual Tonnage → Monthly Aggregation → Quickbase → Quickbase Pipelines → QuickBooks Online → Customer Invoice → Mill

By automating the transition from delivery data to invoicing, BioSource reduced repetitive accounting work while creating a faster, more consistent path from material fulfillment to customer billing and revenue recognition.

Connecting Procurement, Logistics, and Accounting

The greatest value of the solution came from the fact that these workflows did not operate independently. Quandary designed an interconnected operational architecture spanning the entire procurement, sourcing, logistics, accounts payable, and customer billing lifecycle: Mill Request → Contract Review → RFP → Vendor Bid → Vendor Selection → Purchase Order → Delivery → Actual Tonnage → Vendor Payable → Customer Invoice

• Quickbase served as the operational system of record, managing requests, agreements, sourcing activity, vendor bids, purchase orders, deliveries, quantities, and fulfillment data.
• QuickBooks Online remained the financial system of record, managing vendor bills, customer invoices, and the accounting transactions associated with completed procurement activity.
• Quickbase Pipelines connected the operational and financial environments, automatically moving approved transaction data between the two systems.

This architecture meant BioSource no longer needed employees to manually reconstruct the financial story behind each transaction. The information captured during the original request, sourcing process, vendor selection, and delivery could flow directly into downstream accounting workflows.

By connecting Quickbase, Quickbase Pipelines, and QuickBooks Online, Quandary helped BioSource transform procurement activity into structured financial transactions—reducing manual data entry, improving operational-to-financial accuracy, and creating a more scalable foundation for managing growth.

The result was a connected process: Demand → Procurement → Sourcing → Fulfillment → Logistics → Accounts Payable → Accounts Receivable → Financial Visibility