Accurately entering progress data is crucial for getting paid correctly and on time. This guide covers best practices for entering work completed and materials stored on your pay applications.
Understanding the G703 Columns
The G703 continuation sheet tracks progress across several columns. Understanding each column helps you enter data correctly.
| Column | Name | Description | Editable |
|---|---|---|---|
| D | Work Completed - Previous | Cumulative value from prior billing periods | No (auto-calculated) |
| E | Work Completed - This Period | Dollar value of work done this period | Yes |
| F | Materials Presently Stored | On-site materials not yet installed | Yes |
| G | Total Completed and Stored | D + E + F | No (auto-calculated) |
Column Math
Entering Work Completed
Method 1: By Dollar Amount
The most precise method - enter the exact dollar value of work completed:
- Click in the "This Period" column for the line item
- Type the dollar amount (e.g., 5000 or $5,000)
- Press Tab or Enter to move to the next item
Method 2: By Percentage
Alternatively, you can enter a target percentage complete:
- Click the percentage toggle on the line item
- Enter your target completion percentage (e.g., 75%)
- RIVET calculates the dollar amount needed to reach that percentage
When to Use Each Method
Materials Stored Best Practices
What Qualifies as Materials Stored
Materials can be billed when stored if:
- They're physically on the job site (not at your warehouse)
- They're specifically allocated to this project
- Your contract allows billing for stored materials
- You can document their presence (photos, delivery tickets)
What Does NOT Qualify
- Materials at your shop or warehouse
- Materials ordered but not delivered
- Tools and equipment (not consumed in the work)
- Materials not specific to this project
Documentation Required
Moving Materials to Work Completed
When you install materials that were previously stored, the value moves from Column F to Column E:
- Reduce Materials Stored by the installed amount
- Add that amount to Work Completed This Period
- The Total (Column G) stays the same
Example
Tracking Percentage Complete
The 95% Rule
Many GCs won't approve billing beyond 95% until punchlist is complete. Consider stopping at 95% completion and billing the final 5% after punchlist acceptance.
Progressive Percentages
Your percentages should always increase or stay the same - never decrease (unless work was actually removed). Example progression:
| Pay App | Percentage | Notes |
|---|---|---|
| #1 | 15% | Initial work |
| #2 | 35% | Continuing |
| #3 | 55% | Past halfway |
| #4 | 75% | Progressing well |
| #5 | 90% | Near completion |
| #6 | 95% | Awaiting punchlist |
| Final | 100% | Complete |
Be Realistic
Entry Validation
RIVET validates your entries to catch common errors before you submit:
| Validation | What It Checks |
|---|---|
| Over-billing Prevention | Total cannot exceed scheduled value |
| Negative Progress | Work completed cannot be negative |
| Percentage Limits | Capped at 100% per line item |
| Backward Progress | Warns if percentage decreases from prior period |
Quick Entry Tips
Tab Navigation
Bulk Entry
Copy Previous Pattern
Common Mistakes to Avoid
- Billing ahead of work - Never bill more than you've actually completed
- Ignoring materials movement - Remember to move stored materials to work completed when installed
- Inconsistent percentages - Percentages should progress logically each period
- Missing documentation - Have backup for your progress claims ready
Next Steps
Once you've entered all your progress, review the summary and submit to your GC.
Need Help?