Enter Subcontract Invoice Information

Enter subcontract invoice information.

  1. Open the SL Worksheet form.
  2. Complete the JC Co# and Job fields.
  3. (Optional) Generate the SL Worksheet report and give it to your Project Managers to review and/or edit invoice information.
    1. Select Options > Reports > SL Worksheet w/ No SM (Initialized) or SL Worksheet w/ Stored Materials (Init) from the SL Worksheet form.
    2. Distribute the report to the Project Managers at your organization so they that can fill in the % complete and invoice amounts
  4. Use the upper portion of the form to enter invoice information on a subcontract.
    1. Open the Grid tab in the upper portion of the form and select a subcontract in the worksheet.
    2. Open the Info tab in the upper portion of the form and enter the invoice information on the subcontract. These fields will default based on the invoice information entered when the subcontract was added to the worksheet. Press F1 in any of these fields for more detailed information
  5. Use the lower portion of the form to enter invoice amounts on the subcontract items.
    1. Open the Grid tab in the lower portion of the form and select a subcontract item.
    2. Open the Info tab in the lower portion of the form.
    3. Determine the work complete retainage amounts for this invoice. You can enter a value in the WC Ret % or Retainage This Invoice fields, or accept the default.
    4. Determine the work complete amounts for the invoice. You can enter a value in one of the following Work Completed fields: % Complete To Date, Cost This Invoice, Units This Invoice, Cost To Date, and Units To Date. Once you enter a value in one field, the system automatically calculates the value for the other fields.
      Note: If the item’s unit of measure is lump sum, the Units This Invoice and Units To Date field amounts are in dollars. If the unit of measure is anything else, the Units This Invoice and Units to Date field amounts are in units, while the Cost fields calculate based on the unit price of the subcontract.
    5. If applicable, enter the amount of stored materials that the subcontractor purchased for this job in the Purchased This Invoice field. When entering an amount here, the system defaults the amount in the Net This Invoice display field.
    6. In the Installed This Invoice field, enter the amount of stored materials that the subcontractor installed during this billing cycle that you previously billed as purchased stored materials, if applicable. When entering an amount here, the system decreases the amount of stored materials to be invoiced for this billing in the Net This Invoice display field.
    7. Determine the stored materials retainage amount. You can enter a value in either the SM Ret % or the SM Ret This Invoice field. Once you enter a value in one field, the system automatically calculates the value for the other field.
    8. Repeat these steps on all of the items on the subcontract
    9. In the Installed This Invoice field, enter the amount of stored materials that the subcontractor installed during this billing cycle that you previously billed as purchased stored materials, if applicable. When entering an amount here, the system decreases the amount of stored materials to be invoiced for this billing in the Net This Invoice display field.
      Note: The system bills stored materials as a separate line on the AP invoice, with a description of “Stored Materials for Item ##” (where ## represents the subcontract item number).
    10. Determine the stored materials retainage amount. You can enter a value in either the SM Ret % or the SM Ret This Invoice field. Once you enter a value in one field, the system automatically calculates the value for the other field.
    11. Repeat these steps on all of the items on the subcontract.
  6. Repeat steps 4 and 5 for all subcontracts in the worksheet