How it Works

The Trio Company will work with your IT department to ensure a secure and seamless transfer of the required electronic data needed for our electronic file review. We have identified the necessary fields needed to maximize the success of our accounts payable review and pricing analysis. Typically there are standardized reports in your current operating system that take minimal time to run and forward the data to us for review. Depending on which option works best for your company, we can receive the electronic data by means of the following options.

1. Uploaded through our Secure Integrated AJAX File Upload API.

  • We will assign your company a user name and password to access our FTP site / AJAX Upload API.
  • Prepare the required files with the requested fields.
  • Transmit the files via your preferred FTP software program, or we can provide you with a software program via a CD or through our website. The file name should include your facility name and be placed in the folder bearing your company’s name.

icon-file-upload

2. Zip file and e-mailed to our IT Department at: mlee@thetriocompany.com

Data Extraction Information:

The Trio Company can accept the required data fields in any of the following formats:

  • Delimited Text
  • Microsoft Access
  • Microsoft Excel
  • Report Format
  • Readable PDF
  • CSV – Comma Separated Values
  • Fixed Length Text

Please ensure that the file or files include the following information:

  • All stopped, cancelled, and/or void checks
  • A separate file of outstanding checks

Minimum Data fields required for disbursement review:

  • Vendor Number
  • Vendor Name
  • Check Date
  • Check Number
  • Check Amount
  • Invoice Date
  • Invoice Number
  • Invoice Amount
  • Discount Field
  • Purchase Order Number

Minimum Data fields required for pricing review:

  • Vendor Number
  • Vendor Name
  • Check Date
  • Check Number
  • Check Amount
  • Invoice Date
  • Invoice Number
  • Invoice Amount
  • Purchase Order Number
  • Product Number
  • Product Description
  • Quantity Received
  • Quantity Paid For
  • Unit of Measure
  • Price Paid Per Unit of Measurement

Note: All data transmission should include a record layout.

Industries We Serve

wordcloud-industries-served-sm

icon-circle-logoWe Recover What is Rightfully Yours™

The Trio Company is a National Cost Recovery management Firm specializing in purchase & disbursement audit recovery programs, Contract Pricing Analysis, and Accounts Payable Productivity enhancement programs.