Creating new progress bills manually

In the Current Stored column, you can enter the amount of material currently being stored. When you create the next application, Sage 100 Contractor moves the costs from the Current Stored column to the Previous Stored column. As you complete work, remove the costs for items no longer being stored. To remove costs, enter the costs as a negative amount.

To create a new progress bill manually:

1. Open 3-7 Progress Billing.
2. In the header:
   1. In the Job text box, enter the job number.
   2. If the job uses phases, enter the phase number in the Phase text box.
   3. In the Description text box, enter a brief statement about the work completed.

   4. If you want this billing to include all the phases for the job, select the Combine phases into single application checkbox before you import the budget or proposal.

      Note: Costs for all phases will be combined when you update costs.

   5. If you want to include this progress billing in the 6-12 Project Work Center, select the Hot List checkbox.
   6. In the Application# text box, enter the number of the application you are submitting.
   7. In the Billing Date text box, enter the date ending the period for which you are submitting the request.

   8. In the Billing Cycle text box, enter the billing cycle.

      In Sage 100 Contractor, a cycle is represented by ##DY (a number of days), ##MO (a number of months), and ##TH (a specified day every month). For example:

      • 30DY means due every 30 days.
      • 02MO means due every two months.
      • 25TH means due on the 25th day of each month.

   9. Under Billing Basis, select the Cost Codes or Divisions option.
3. On the Options menu, click Setup, and then enter the appropriate information in the Progress Billing Setup window.
4. After entering the information, from the File menu, click Save.
5. In the grid, for each item
   1. Depending on the billing basis, right-click the Cost Code or Divisions text box, and select Display Picklist Window.
   2. Create a Picklist of cost codes or divisions, and then click the check mark button to insert the list into the grid.
   3. If a vendor is associated with the item, enter the vendor number in the Vendor text box.
   4. In the Scheduled text box, enter the scheduled amount.
   5. In the Current Completed text box, you can enter the costs incurred. If you provide the costs incurred, do not provide the percent of work completed in the % Completed text box.
   6. In the Retention Rate text box, you can accept the default primary rate from the Progress Billing Setup window, or you can enter a different rate for the item.
   7. In the Current Stored text box, enter the current cost of materials stored for the job.
   8. In the % Completed text box, you can enter the percent of work completed. If you provide the percent of work completed, do not provide the current costs incurred in the Current Completed text box.
   9. In the Taxable text box, type Yes if the item is taxable or No if the item is non-taxable.
6. On the menu bar, click Calculate to select one option in the Calculate Grid window, then click [Calculate].
   1. Calculate the Current column based on the amounts entered in the Percentage column (this is based on the amount entered in the % Completed text box in step 10e).
   2. Calculate the Percent column based on the amounts entered in the Current and Stored columns (this is based on the amounts entered in the Current Completed and Current Stored text boxes in step 10a and 10c, respectively)