Skip to content
  • There are no suggestions because the search field is empty.

How to track lump sum quantities

The Lump Sum Quantity Format setting controls how quantities for Lump Sum Pay Items are entered and displayed in a Project. You can choose Number, which is how Lump Sum quantities have always worked, or Percent, which shows a full Lump Sum as 100% and allows much smaller payment amounts on high-value items.

 Unit Price and Lump Sum Pay Items

Most construction Projects include two kinds of Pay Items:

  • Unit Price items are paid by the number of units completed. For example, a Stop Sign item is paid for each stop sign installed.
  • Lump Sum items are paid by the share of the overall scope that's complete. They usually have an Authorized Quantity of 100%, and portions are paid as the work progresses. For example, if about half of a Demolition of Structure item is done, 50% of the Lump Sum amount can be paid.

A Pay Item is treated as Lump Sum when its Unit of Measure is LS, Lump, L.S. or Lump Sum. All other Pay Items keep their normal quantity behavior, whichever format you choose.

 

Why This Matters

Quantities in FACS go up to four decimal places. In Number format, that limits how small a payment can be on a high-value Lump Sum item:

  • A $5,000,000 Lump Sum item with an Authorized Quantity of 1.0000
  • Smallest quantity you can record: 0.0001
  • Smallest payment: $500.00

To get around this, some Projects set up Lump Sum items with a Unit Price of $1.00 and an Authorized Quantity of 5,000,000. That works, but the item no longer looks the way the Owner expects a Lump Sum item to look.

Percent format solves this. The same $5,000,000 item shows an Authorized Quantity of 100%, and you can record as little as 0.0001%, a payment of $5.00.

 

Comparing the Formats

Number Percent
Full Lump Sum shown as 1.0000 100%
Quantity entered as A number, up to 4 decimal places A percent, up to 4 decimal places
Smallest quantity 0.0001 0.0001%
Smallest payment on a $5,000,000 item $500.00 $5.00

 

Setting the Format

You can choose the format when you create a Project, or later in Project Settings until the first payment is approved.

When creating a Project:

  1. In the Project Creation Wizard, go to the Payment step.
  2. In Lump Sum Quantity Format, select Number or Percent.
  3. Continue creating the Project.

For an existing Project:

  1. Go to Project Settings → Payment.
  2. In Lump Sum Quantity Format, select Number or Percent.
  3. Save your changes.

The field is required and defaults to Number. All existing Projects are set to Number, so nothing changes unless you choose Percent.

NOTE: Once the Project's first Payment entry is Approved, the Lump Sum Quantity Format is locked and can't be changed. Choose the format before approving your first Payment.

 

Entering Lump Sum Quantities in Percent Format

When a Project uses Percent format, Lump Sum quantities are entered and displayed as percentages:

  • Pay Item list: Authorized Quantity and Bid Quantity are entered and shown as percents. A full Lump Sum is 100%.
  • Item Details: Quantity Recorded is entered and shown as a percent. For example, enter 25% to record a quarter of the Lump Sum scope.

Example: A Traffic Control Lump Sum item has a Unit Price of $5,000,000 and an Authorized Quantity of 100%.

Quantity Recorded Payment
50% $2,500,000.00
1% $50,000.00
0.0001% $5.00

TIP: If your Project's Lump Sum items were set up as a $1.00 Unit Price with a large quantity, update them to the full Lump Sum Unit Price and an Authorized Quantity of 100% before switching to Percent format.

 

Where Percent Values Appear

In Percent format Projects, Lump Sum quantities display as percents throughout the Payment process, including:

  • Pay Item list, including its Excel export
  • Item Details
  • Payment entries, the Payment Report (on screen, Excel, and PDF), and the Payment Action Items dashboard widget
  • Entry PDF exports, prints, table exports, and entry history
  • Change Order entries: Quantity Recorded, Quantity Variance, and Quantity Change
  • Material Acceptance entries: Accepted Quantity, Recorded Quantity, and Remaining Quantity
  • Material Stockpile entries: Stockpile Unit Quantity, Item Quantity Recorded, Item Quantity Paid to Date, Item Quantity Remaining, and Stockpile Quantity Recorded
  • Reports (on screen, Excel, and PDF):
    • Item Details Report: Authorized Quantity and Quantity Recorded
    • Item Quantity Recorded Report: Authorized Quantity and Quantity Recorded
    • Item Variance Report: Authorized Quantity, Quantity Recorded, and Quantity Variance
    • Material Acceptance Usage Report: Authorized Quantity, Accepted Quantity, Quantity Recorded, and Material Acceptance Quantity Needed

 

Things to Keep in Mind

  • Only Lump Sum items change. Unit Price items and all dollar amounts work the same in both formats.
  • Existing quantities may be updated. If you change this setting after lump sum items have quantity recorded the amount recorded may need to be updated.
  • The setting is per Project. Each Project can use a different format.
  • It locks after the first approval. Once a Payment entry is Approved, the format can't be changed for that Project.

 

If you have any questions, or need additional assistance, please reach out to our support team at support@facsware.com and we will be happy to assist you.