Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Standard Operating Procedure for Uploading Subcontractor Payments

*indicates required fields

  1. Open Excel Worksheet Listing Payments to Entry

  2. Log into the HUB Administration Page

  3. Click Subcontracting > Add a New Transaction

  4. Enter Voucher Search Fields from Excel Worksheet

    • “CONTRACT NUMBER” FROM EXCEL > “PURCHASE ORDER NUMBER“ FIELD *

    • 09 01 2023 INTO “EARLIEST VOUCHER DATE” FIELD *

    • “SUB VENDOR ID” FROM EXCEL > “SUBCONTRACTING VENDOR ID” FIELD *

    • “PAYMENT AMOUNT” FROM EXCEL > “PAYMENT AMOUNT“ FIELD *

  5. Click Retrieve Vouchers

  6. Click Apply Next to the Voucher that Matches “Voucher Number” in the Excel Worksheet

    • IF THERE IS NO MATCH, SELECT THE VOUCHER WITH THE “VOUCHER DATE“ THAT IS CLOSER TO THE “AUDIT DATE“ IN THE EXCEL WORKSHEET

  7. Click Update Record

  8. Green Text Should Appear at the Top of the Page Confirming the Update

  9. Click Add a New Transaction Record to Upload a New Payment

Tip

“Voucher Number” not matching Tip

If the “Voucher Date“ and “Audit Date” are different, select the voucher with the date AFTER the audit.