Date Created: January 16, 2024 Last Updated: April 30, 2024
Overview:
Cornell Retail Services uses NetSuite ERP system to order and receive merchandise, enter invoices and extract invoices for payment. NetSuite generates a payment file that is fed to KFS through an integration. Payments to vendors are processed in KFS by the central Shared Services Center procurement team. Segregation of duties exists between buyers, receiving and invoice processing
Criticality: High | Frequency: Other | Turnaround: Other |
Key Parties / Contacts:
Buying Team: Initiates new vendor setup in NetSuite, responsible for placing orders, monitoring inventory levels and reviewing any pricing or delivery discrepancies.
Warehouse Team: Receives product at the warehouse, verifies item counts and pricing on orders. Identifies items for return to vendors (damaged, wrong item, etc.) and creates a VRMA records in NetSuite to identify return and expected credits.
Vendor: Fulfills orders with reasonable accuracy, adheres to terms in PO and delivers items to CRS warehouse. Ensures invoicing processed promptly.
Financial Transaction Center (FTC): Compares invoice received from vendor to PO and receiving record in NetSuite, compares vendor credits to VRMA and item fulfillment record in NetSuite, communicates large discrepancies to unit. Creates weekly payment file to pay vendors for open invoices/credits and processes the integration with KFS. Addresses all requests regarding stale checks or unpaid balance inquiries.
Key Documents / Sources of Information:
- Buying Manual: Paying for Goods and Services that do not require a Purchase Order
- Buying Manual: Invoice Payments
- University Policy 3.14, Business Expenses: University Policy 3.14, Business Expenses
- University Policy 3.25, Procurement of Goods and Services: Procurement of Goods and Services (cornell.edu)
- University Policy 4.2, Transaction Authority and Payment Approval: University Policy 4.2, Transaction Authority and Payment Approval
- Standard Operating Procedures-Capital Assets Overview
- CU Learn: Accounts Payable -Spring 2023
- Invoices, credits, returns and packing slips from vendors
System Access Needed:
- NetSuite
- Kuali Financial System (KFS)
- SCL Accounts to KFS integration portal
- OAS Reporting Dashboard (KDW)
Common Problems or Issues Encountered:
- Credits and returns tracking
- Mismatch between PO/Receiving and vendor invoice
- After the fact purchases
Step by Step Procedures:
Ordering Product:
- The Buying Team places an order(s) with a vendor for inventory items to replenish what is sold based on inventory records in NetSuite, or orders special items.
- Buying team may need to source items not carried by established store vendors.
- If new vendor, buying team initiates vendor setup in NetSuite and notifies FTC to issue new vendor packet to the vendor. FTC issues new vendor packet.
- Once vendor returns the vendor packet, the FTC confirms the vendor is in KFS. If vendor is in KFS, FTC confirms if any updates are needed. If vendor is not in KFS, FTC sends vendor invite via PaymentWorks.
- FTC receives vendor number confirmation from KFS for any updates and new vendor setup. FTC enters the KFS vendor number in the vendor record in NetSuite to link to KFS.
- If orders exceed establish buying limits, orders are directed to a secondary approver.
- PO is submitted electronically to vendor through NetSuite.
- Vendor fulfills the PO order and delivers product to the CRS Warehouse.
- When orders are delivered, the product is checked against packing slips by warehouse staff to ensure accuracy of item SKU, pricing, UPC code and counts match.
- Warehouse staff enter quantities received on the order in NetSuite. NetSuite assigns a unique receiving number to the transaction and creates a GL entry to debit inventory and credit Accounts Payable based on quantity x unit cost on the PO.
- If PO does not match order as received, warehouse staff contact the Buying team to resolve with the vendor.
- Warehouse team identifies all product to be returned and Buying Team creates a VRMA in NetSuite that is available to match to the vendor credit.
- Vendor bills the store with hard copy or electronic invoicing. All vendors not enrolled in electronic invoicing, are instructed to submit invoices with purchase order reference via email to: The Cornell Store 150 Ho Plaza, Ithaca, NY 14850 Email: cbsbo@cornell.edu. Include the PO number on the subject line and may include instructions in the body of the email. The purchase order is the contractual basis on which the supplier is paid for merchandise furnished.
- Manual invoices are entered through the Bill Purchase Order process. Electronic billing is sent via SPS Commerce (EDI) and processed through a verification system before going through the Bill Purchase Order process. All Vendor credits are manually entered in Accounts Payable, via Refund VRMA process.
- In the event no purchase order is created for an invoice, (for example when Apple Inc bills the store for the purchase of parts used by the Computing Center for repairs made to student computers), the Enter Bills or Enter Credits process is used.
- FTC team verifies 3-way match of vendor invoices to the receiving documents and PO in NetSuite. If the item price or quantity billed differs from what was received, the item price or quantity may NOT be adjusted. Adjustments are only handled through the appropriate Expense account: quantity variance – Over/Short – Inventory; cost variance – COS – Vendor Price Variance. The adjustments are to be within the established threshold. Large discrepancies warrant discussion with Store team (buyers or receivers) and/or researched with the vendor for appropriate credits prior to invoice entry and payment.
- Freight and Tickets (tag costs, color charges) are entered as a line item to record the appropriate COS account. Note: Federal Interstate Commerce Commission / Department of Transportation regulations require that all invoices for freight be paid within fifteen (15) days. Failure to comply can result in termination of carrier service or possible court action against Cornell University. It is extremely important that all freight bills be processed promptly!
- FTC creates a weekly payment file to process invoices for payment and sends to KFS via an integration.
- Vendors are not paid if they have an outstanding credit balance or if a return has been made and the credit has not been received from the vendor.
- Payment file is reviewed & approved by FTC Financial Manager for all invoices. Any invoices over $200K will be approved by the Associate Director Financial Transaction Center. Copy of the approval for invoices over $25K will be attached in NetSuite on bill record. Approval for invoices under $25K will be saved in payment file record.
- Invoices over $1M need additional approval attached by the University Controller (Karen Mahalo) OR need to be processed in KFS though a DV so proper approval routing occurs per university and audit requirements.
- Invoices are paid according to payment terms established by the university.
Key Risks | Key Controls |
Risk of the same individual ordering and receiving product, allowing opportunity for fraud | 1. Ordering and receiving processes are segregated to two different teams in the Cornell Store (Buying Team and Warehouse Team). 2. Unit trains staff on proper procedures for purchasing in accordance with the Buying Guide and university policy. 3. Unit ensures that the intended purchase is an allowable business expense for which University funds may be expended. See University Policy 3.14, Business Expenses. 4. FTC reconciles PO and receiving document with vendor invoice. |
Conflict of Interest (COI), when staff is working closely with vendors, there are some inherent risks. There is a risk that staff does not self-disclose relationship with vendor. There is a risk that once the risk is disclosed that a unit does not follow up with staff to investigate the COI further. | 1. Unit trains staff on COI and self-disclosure; unit manages and investigates COI in accordance with University Policy 4.14, Conflicts of Interest and Commitment (Excluding Financial Conflict of Interest Related to Research): vol4_14.pdf (cornell.edu). 2. Annual certification and ethics training is required in the MOU for delegated spend. |
Risk that invoice has been submitted to Accounts Payable by vendor, department, or Shared Services Center previously for payment (duplicate payments). | 1. Unit reviews accounts and checks for potential duplicate payments. Kuali Financial System requires purchase order number, invoice number, invoice date, and amount for all payment requests and automatically checks for potential duplicates for purchase order payment requests; KFS cannot check for duplicates across payment methods. 2. Payment file is approved by the FTC Financial Manager up to $200K, the Assoc. Director up to $1M and the University Controller for invoices $1M and over. 3. Timely assurance audits identify duplicate payments made after the fact so reimbursement or credit memo can be requested. |
Returns may not be processed timely for credit | 1. Warehouse identifies items to be returned and creates a VRMA in NetSuite to track. 2. Accounts payable, clearing and accrued purchases are reconciled monthly. |
ATFPO’S | 1. Delegated spend purchases are required to go through the Buying Team. 2. Purchases of items outside of delegated spend are initiated on an IWant documents or through eshop. |
Unit signing contracts without delegated spend authority | 1. Director of the Store approves and acknowledges all IWant documents that are processed through KFS. 2. Unit trains staff on proper procedures for non-delegated spend. |
Metrics:
Cornell Finance Staff
- After-the-fact PO counts
- Budget vs Actual expense
- Reconcile Accounts Payable to the General Ledger monthly
- Reconcile clearing accounts to verify file loads processed as expected
- Monitor that vendors are paid as expected
- Transactions initiated, transactions approved, transactions paid, outstanding credits, monthly statements.
Glossary of Key Terms/Acronyms:
- KFS – Kuali Financial System
- NS – NetSuite ERP system
- OAS – Oracle Analytics Server, financial reporting tool (formerly known as OBIEE)
- GL – General Ledger
- FTC – Student and Campus Life Financial Transaction Center that processes financial transactions for Cornell Retail Services