Skip to main content

RedTeam Go - Budget Worksheet

When moving a project to In Progress, your first stop is the Budget Worksheet to go through project buy-out and issue cost commitments.

The Budget Worksheet is where you set up and manage the construction budget for a RedTeam Go project once it is In Progress. From one screen you can adjust funds between cost items, award and terminate subcontracts, see what is committed, and forecast changes before you make them.

Open the Budget Worksheet

Step 1: Select the project, then click Commitments > Budget in the left menu.

The buttons at the top of the worksheet are Add Cost Items, Adjustment Log, Export and, before the budget is locked, Lock Budget. Use the search box to find a cost item or subcontractor, and the filter (All, Labor, Material, Subcontractor, Other) to show one cost category. Tour walks you through the screen.

Move a project to In Progress

A project moved forward from Pending goes straight to In Progress, and its Budget Worksheet opens unlocked.

  1. On the Projects list, click the project's ⋯ menu and select Set to In Progress.

  2. Check the contract value in the Update Bid Status window. If it matches your owner contract, click Contract Value is Correct. If it doesn't, click Return to Bidding and correct the estimate.

  3. Fill in the project details (Project Manager, Accountant, Substantial Completion, Job Number, Contract Agreement Date and retainage), then click Set to In Progress.

  4. Choose who receives the Job Set to In Progress email and click Proceed. The Job Setup report is attached to the email.

If the project has a signed owner contract, you are warned before the totals can change. A GC signature can be removed in Administration > Unlock/Unsign > Owner A/B Contracts. To remove an owner's signature from a fully executed contract, the owner must give Client Support written permission.

Decide where markups go (Markup Tool)

If the estimate included Labor Burden or Sales Tax, the Markup Tool opens the first time the Budget Worksheet loads. If neither was used in Bidding, you go straight to the worksheet.

  1. Read the Adjust Markups introduction and click Next.

  2. In Manage Markups : Labor Burden, every cost item is checked by default. Checked items keep their markup on the cost item. Uncheck any item whose markup should move to 1-998.OH General Costs.

  3. Click Save to apply your choices, or Skip to move all Labor Burden to General Costs.

  4. Click Proceed to confirm, or Cancel to go back and change your choices.

  5. Repeat the same steps in Manage Markups : Sales Tax.

Your decisions are recorded in the Adjustment Log. General Costs also holds any General Liability markup from the estimate.

Why move markups to General Costs? Moving Labor Burden and Sales Tax out of the cost items keeps each cost item at its base cost and pools the markup in 1-998.OH General Costs. You can then use that pool as a flexible fund and move money from it to whichever cost items need it as the project goes on.

What each column shows

Column

What it shows

Bid Amount / Owner Amount

Before the budget is locked, the column is Bid Amount: the estimate amount, including the markups kept on the cost item. After the lock it becomes Owner Amount: the original estimate plus approved owner change orders. It is the only column that shows owner values.

Budgeted

What you planned to spend on the cost item, as set up before the lock (including Markup Tool choices, Buy Out from Bidding and your edits). While the budget is unlocked, it is also the buyout amount awarded on the subcontract. It cannot be edited after the lock.

Changes

Budget adjustments and approved change order amounts after the lock, including funds moved automatically when a cost goes over budget.

Current

Budgeted + Changes: what is in the cost item now. After the lock, subcontract amounts come from this column. It matches the last column of the Budget Report.

Actuals

Costs recorded against the cost item, such as approved time and expenses.

Potential COs

Pending amounts that may change the cost item, such as posted PCOs and unapproved change orders.

Forecast

Your own what-if amounts. Shown only when Forecast On is selected.

Projected

Current + Potential COs + Forecast.

Over/Under

Owner Amount − Projected. A negative amount means the cost item is projected to cost more than the owner is paying for it.

Contract

The subcontractor and contact awarded the cost item.

Set up the budget (unlocked)

While the budget is unlocked, you can change how funds are spread across cost items, add cost items, and write subcontracts and purchase orders.

While the budget is unlocked, the Budgeted column works as your buyout amount. The Budgeted amount of a subcontract cost item is what is awarded to the subcontractor and filled in on the subcontract. After the budget is locked, the subcontract amount comes from the Current column instead.

  • To change a budget, click the cost item's Budgeted amount, type the new amount and press Tab. The change saves right away and is recorded in the Adjustment Log.

  • To move money between cost items, lower one Budgeted amount and raise another. Profit changes between the two edits, so make both together.

Step 1: To add cost items, click Add Cost Items, search for the cost item, and click + next to it. Enter an Amount if you want to fund it now (you can leave it at 0), then click Save Cost Items.

Funds for a new cost item come out of profit unless you lower another cost item by the same amount.

Lock the budget

Locking the budget marks the point where the budget is final. Once buyout and your budget adjustments are done, you lock it to say: this is the budget we are working with. From then on, every change goes through a change order or a logged budget adjustment, and billing opens for the project.

Locking the budget opens Changes and Billing for the project and emails the Budget Report. You can award subcontracts while the budget is unlocked, but subcontractors can't bill until the budget is locked.

  1. Click Lock Budget.

  2. In Confirm Budget Lock, click Proceed. From now on, changes are logged as budget adjustments or change orders.

  3. Choose who receives the Budget Report email (the project's accountant is selected) and click Proceed.

After the lock, Bid Amount becomes Owner Amount, Budgeted can no longer be edited, the Changes and Potential COs columns appear, and the Forecast On / Off toggle is added.

Use the Cost Item Menu

Step 1: Hover over a cost item and click the blue arrow next to its name.

The options depend on the cost category and the project status:

  • Duplicate Cost Item: adds a copy of the cost item with its own description, amount and a reason.

  • Subcontract Management: award the cost item to a subcontractor (.S cost items).

  • Reassign Project Contact: change the subcontractor's contact for the awarded cost items.

  • Terminate Subcontract: shown once the subcontract for the cost item is locked.

  • View Adjustments: opens the Adjustment Log filtered to this cost item.

  • View Item Details: shows the bidding markups and the owner amount for the cost item.

View item details

View Item Details shows the Bidding Mark-ups (Labor Burden, Sales Tax, General Liability, Overhead and Profit) and how the Owner Amount is built: the estimate total plus any owner change orders. Click a change order to open it.

Move funds between cost items (locked budget)

Step 1: Click the blue Current amount of each cost item you want to change. The Budget Adjustments panel opens with a row for each one.

Step 2: Enter the amounts to move (for example, -500 on one cost item and 500 on another), type a Reason, and click Save. Click Revert/Cancel to discard the changes.

The amounts show in the Changes column and in the Adjustment Log. A cost item with a locked subcontract shows Current as plain text; change its amount with a change order instead.

Forecast changes without moving funds

Step 1: Click Forecast On, then enter a positive or negative amount in the Forecast column.

Projected and Over/Under update, and a Forecast Budget line appears in the summary. Forecast amounts are a what-if only: they don't move funds. To make a change real, use a budget adjustment or a change order. Click Off to hide the column. Your forecast amounts are kept and come back when you click Forecast On again.

The summary lines at the bottom show the cost item total, overhead, profit, contract total and cost per square foot:

  • Original Budget: the totals when the project started.

  • Current Budget: the totals of the Current column.

  • Forecast Budget: shown when Forecast On is selected.

  • Projected Budget: current totals plus potential change orders and forecast amounts.

Award a subcontract

Step 1: Open the Cost Item Menu on a .S cost item and select Subcontract Management. Tip: select Subcontractor in the filter to show only subcontract cost items.

Step 2: Select a subcontractor from the list. Use Search to find one, or + Create New Company to add one.

Step 3: Under Assign To, select the contact. Under Additional Task Performed, check any other cost items you want to award to the same company. Then click Award Task(s).

The right side shows the subcontractor's rating, contact details, Qualifications (insurance dates, approval, bonding capacity), other cost items they can take (Additional Task Performed) and their Ongoing Projects with you. A contact terminated on another project is marked (Terminated). The subcontractor appears in the Contract column, and a draft subcontract is added under Commitments > Subcontracts.

All the cost items you award to one company are compiled onto one subcontract, and that is the subcontract the company signs. You can also award different cost items to different contacts at the same company, for example people working in different divisions: select the right contact under Assign To for each award.

You can award subcontracts before or after the budget is locked. Subcontractors can bill only after the budget is locked.

Terminate a subcontract

Note: A termination creates and signs a negative subcontractor change order. It can't be undone.

Step 1: Open the Cost Item Menu on the awarded cost item and select Terminate Subcontract. All the subcontractor's cost items on the project are listed with their Awarded Amount, Billed, Pending Bills and Balance.

Step 2: Enter the amount to take away in Terminate Amount. It always becomes a negative amount, and Remainder To Bill updates.

Step 3: Check the box to acknowledge that your signature goes on the change order, then click Terminate.

Step 4: Click Terminate again to confirm, choose who is notified, and click Proceed.

The signed negative change order is listed in Changes > Change Orders under Subcontractor Only, the subcontract is marked (Terminated), and the Adjustment Log records the termination.

Re-award a terminated amount

Step 1: Click the blue Current amount of the terminated cost item.

If the cost item has change orders, Adjust Award Amount opens. Enter the Award Adjustment (+/-) and a Reason, then click Update. Otherwise the Budget Adjustments panel opens. Both show Committed Amounts to Terminated Subcontractors: what stays with the terminated subcontractor after a partial termination.

Then award the amount to a new subcontractor with Subcontract Management. Larger changes are made with change orders.

Review the Adjustment Log

The Adjustment Log is the record of every budget change: budget edits and adjustments, Markup Tool decisions, the budget lock, over-budget adjustments, terminations and change orders.

Step 1: Click Adjustment Log. Filter by Start Date, End Date, Cost Item or Cost Category. To see one cost item's history from the worksheet, use View Adjustments in the Cost Item Menu.

Step 2: Hover over a row and click the blue arrow to show the Reason.

How change orders affect the worksheet

  • A posted PCO or an unapproved change order shows its subcontractor price in Potential COs.

  • When an owner change order is approved, its Owner Price is added to Owner Amount, and its Sub Price moves from Potential COs to Changes and Current.

  • If the Sub Price on an owner change order is $0.00, the owner's money goes to profit instead of the cost item.

  • A subcontractor-only change order adds to Changes and Current and comes out of profit, because there is no owner amount.

  • When a purchase goes over the cost item's budget, the difference is moved from profit into the cost item automatically. It is listed under Internal Change Orders in Changes > Change Orders.

Budget Report

The Budget Report uses the same columns as the worksheet: Owner Amount, Budgeted, Changes and Current, with overhead, profit and contract totals. It is emailed when you lock the budget. To see the original bid amounts, use View Item Details or the bidding reports under Reports.

Did this answer your question?