The Bulk Labor entry tool provides a method for Accountants to quickly enter or adjust project labor costs in RedTeam Go by cost item. It provides an additional way to include labor cost in combination with or in place of entering Employee Time Cards. When used, both methods are displayed as committed costs across Budgets, Reports, the Job Costs Statement, and will also populate into compatible Owner Billing formats.
Bulk Labor in Accounting
To begin Go to:
Accounting>Time Cards>Bulk Entry>Add Labor Codes>Select Project Name
Only Accountants can enter Bulk Labor; the accountant role can be assigned to employees under GC Contacts.
This is to keep Labor Cost entry condition approval methods consistent, Timecards are already Approved by an Accountant and become a committed cost upon approval.
Bulk Labor entry amounts are applied as a committed cost on the project as soon as the entry is saved by the Accountant.
When the project name is selected, the Labor cost codes that are in the project will be displayed.
Enter the positive amounts for the labor cost codes desired and click Save
Negative amounts will not be permitted in the cells; any entry made in error must be deleted
Any entry that exceeds the available amount in the cost code will result in a Budget Adjustment, which will move the required funds from profit to cover the transaction and log it on the Budget Adjustment log for reference.
Once saved, the Bulk Labor entries will be logged and searchable by Date, Cost Items, and by Project Name from the Accounting area.
They can also be deleted from here if the Accountant finds they have made an error.
Bulk Labor Transactions in Project
Bulk Labor transactions will update all In Progress Budgets and Cost tracking reports in the manner as regular timecard entries. As labor costs accrue, they will continue to update the Owner Vs Actuals Report, Budget Worksheet, Budget Report, and the Job Cost Statement.
It will also update the Budget Worksheet in both the Unlocked status (when the Budget column is open and buyout is underway) and in the Locked status (when the Budgeted column is locked and funds are moved in the Current column). Examples of both statuses appear below.
Budget Worksheet Unlocked Status
When the Budget Worksheet is in the Unlocked state, Bulk Labor updates will appear in the Budgeted column. Below are screen shots of the labor cost codes before and after the example transactions were made.
The cost items with sufficient funds just post the amount committed in the Actuals column, while the cost items that do not have sufficient funds move extra from Profit via an Overbudget Adjustment. These show as a negative in the Over/Under column.
Before Bulk Labor Transactions were entered:
After Bulk Labor Transactions entered:
For cost items that exceed Budgeted amounts, Budget adjustments are added to the Logs
Owner Budget Vs Actual Cost Report
In the Actuals Column where the Committed Costs for a project show and hourly timecard entries will be listed, the bulk time entries will now also be added to the list. However these will appear with Bulk Labor Entry under the Company Employee cell and have Lump Sum under the hours worked.
Job Cost Statement (JCS)
On the Job Cost Statement, the Total Costs Committed column has been enhanced to display the breakout of individual labor costs details if they are using the RedTeam Go data. Bulk Labor costs will be listed in the same way timecard labor costs are displayed in the Actuals on the Owner Budget Versus Actual Costs report. Clicking on Total Man Hours will now open that detailed list of transactions for the labor cost code.
Budget Worksheet in Locked Status
When a Budget is Locked, Bulk Labor entries will update the Actuals column but if any Overbudget Adjustment is triggered, the updates will now appear in the Changes and Current columns.
When the budget is locked the Overbudget Entries on the Adjustment log are logged and numbered as ICO entries.
Deleted Bulk Labor
When a bulk labor entry is Deleted from Accounting>Timecards>Bulk Labor, it will be permanently removed from all of the corresponding financial reports. If an Overbudget transaction has been created it will be reversed and logged in the Budget Worksheet Adjustment log.
If the project is Unlocked the Voided transaction will be listed as Overbudget Preconstruction.
If the project is Locked, the Voided Overbudget transaction will display as Bulk Labor over Budgeted amount.
Owner Billing
For Owner Billing templates that pull in approved Labor costs on a project, bulk entries will appear along with (or in place of) any Time Card entries. Rather than displaying an Employee name, they will show ‘Bulk Labor Entry’ in the Employee column.
This is how they appear when all new grouped cost items first appear on an open bill:
Here is how they appear if you click on the blue hyperlink of the dollar amount that appears on the labor line item on the bill:
