Manage Project Billing Transactions
- To transfer nonlabor billable project transactions to another project, configure an accounting adjustment date and an accounting adjustment reason.
- To enable transaction transfers within closed time periods, enable the tenant-wide optionAllow Transfers Within Closed Time Entry Periodson theProject Transfer Optionstab on theSet Up Project Billing Configurationtask.
- To enable the search promptsProject Assignable RoleandWorker for Assignable Rolefor theManage Project Billing TransactionsandTransfer Project Transactionstasks, enable theEnable Optimized Search by Project Assignable Role and Workeroption on theEdit Tenant Setup - Financialstask.
- Security:
- Manage: Billable Projectsdomain in the Projects functional area.
- Process: Project Billing - Coredomain in the Project Billing functional area.
- For project transfers in locked and closed periods:
- The user must also have access to theTime Tracking: Exempt from Lockoutdomain in the Time Tracking functional area.
- If theProject Transaction Adjustment Eventbusiness process:
- Is configured, the initiator of the project transfer must have access to theTime Tracking: Exempt from Lockoutdomain, or the business process does not advance.
- Is configured with approvers, the approvers must have access to theTime Tracking: Exempt from Lockoutdomain, or the business process does not complete.
- Set Up: Project Billing - Configurationsdomain in the Project Billing functional area (for theAllow Transfers Within Closed Time Entry Periodsoption).
You can use the Manage Project Billing Transactions task to review all transaction sources for your project billing transactions. Workday enables you to view aging transactions, view transactions that might require recalculation, and drill into transactions based on billing status.
You can view transactions from all transaction sources together, or grouped on tabs by transaction source.
You can also:
- Adjust transaction hours, rates, and amounts.
- Approve transactions for a project.
- Change the billing status of transactions.
- Create invoice proposals for transactions.
- Filter by and view previously invoiced billable transactions.
- Recalculate transaction amounts using billing rate sheets.
- Split nonlabor billable transactions into multiple transactions (when viewing by transaction source).
- Transfer billable transactions to another project, phase, or task (when viewing by transaction source).
- Access theTransfer Project Transactionstask from the summary page to transfer and split other transaction types.
You can add the
Manage Project Billing Transactions
worklet to your Home page to review project billing transactions.Note that contract line dates control whether transactions are billable or unbillable. Contract line dates also control the mapping to the project on the contract line. If transactions are unbillable, either the transactions are outside the contract line date range, or the billing schedule or contract contains incorrect information.
- Access theManage Project Billing Transactionstask.Workday displays the search criteria dialog with your previous search criteria saved each time you access the task.
- Complete the search criteria:At least one of these fields must be populated to perform a search:Project Hierarchy,Customer,Project Owner,Billable Projects.You can hide or require specific search prompts for theManage Project Billing Transactionstask, using theConfigure Optional Fieldstask. Select theProject Billing>Manage Project Billing Transactionsfunctional area, and select security groups to hide or require fields for. The configuration changes you make forManage Project Billing Transactionsalso apply to theTransfer Project Transactionstask.
Option Description Project HierarchySelect a project hierarchy to filter the billable projects to review.Project OwnerSelect a project owner to filter the billable projects to review.Project Assignable Role(Optional) Select an assignable project role, such asProject ManagerorProject Billing Specialist, to filter the billable projects to review.Workday saves your selection and uses it each time you access the task.If there have recently been new projects created or changes made to the project hierarchy structure, there can be a delay before those changes are reflected in the search results.TheProject Assignable Roleprompt does not support assignable roles associated with security groups with the access rightApplies to Current Organization and Subordinates to Level. If you select this type of assignable role, the search doesn't return any transactions.TheProject Assignable Roleyou select may be assigned to more than one role-based security group, and those security groups can each have a different setting forAccess Rights to Organizations.In this case, Workday applies access rights following this ranking order:- Rank 1:Applies to Current Organization and All Subordinates
- Rank 2:Applies to Current Organization and Unassigned Subordinates
- Rank 3:Applies to Current Organization Only
- Rank 4:Applies to Current Organizations and Subordinates to Level
Worker for Assignable Role(Optional) Select an individual named worker for the role selected in theProject Assignable Roleprompt, to filter the billable projects to review.When you select a value forProject Assignable Rolebut not forWorker for Assignable Role, the search results include projects that the current user has the selected project role for.Workday saves your selection and uses it each time you access the task.If there have recently been new projects created or changes made to the project hierarchy structure, there can be a delay before those changes are reflected in the search results.Billable ProjectsSelect the billable projects that you want to review.TheProject Assignable Role,Worker for Assignable Role,Project Hierarchy,Customer, andProject Ownerfields filter the projects available to select in theBillable Projectsfield.Workday saves your selection and uses it each time you access the task.Show Unbillable Transactions(Optional) Select to display transactions inUnbillablestatus.Workday saves your selection and uses it each time you access the task.Show Fixed Fee Transactions(Optional) Select to display theFixed Feecolumn on the project summary view, which shows the number of fixed fee project transactions within that transaction group.Workday saves your selection and uses it each time you access the task.Review Transactions by SourceSelect this option to view project billing transactions grouped by transaction source on the transaction details view.Workday saves your selection and uses it each time you access the task.Review Transactions in Detail(Optional) Select to navigate directly to the transaction details view.Workday saves your selection and uses it each time you access the task.Group Results By(Optional) Select an option to group the transactions by on the project summary view. Displays when you clear theReview Transactions in Detailcheck box.Workday saves your selection and uses it each time you access the task. - (Optional) Complete the Aging Summary section on the project summary view:CardDescriptionTransactions Awaiting ReviewReview work in progress (WIP) billable transactions. You can view billable transactions grouped by aging days, project, and currency.NotificationsDisplays when you modify the associated standard billing rate sheet rules on theMaintain Standard Billing Rates by Rulestask and have billable project transactions that might require recalculation.
- On the project summary view, select the projects that you want to either review in detail or perform mass actions on.You can approve the transactions, recalculate rates, create customer invoice proposals, mass modify amounts for billable project transactions, or initiate theTransfer Project Transactionstask. Consider:
Option Description Original Total Amount to BillThe total amount to bill, before mass modification adjustments.Transaction Types for Adjustment(Optional) Select the transaction types to be adjusted by mass modification. By default, this field is set toTimetransactions only, but you can add the other supported transaction types:Supplier Invoice,Expense, andMisc Expense.Daily Timetransaction adjustments are not supported.Eligible Amount for AdjustmentWorkday calculates the total amount available for adjustment based on the selections made in theTransaction Types for Adjustmentfield.New Total Amount to Bill(Optional) Enter the new amount you want to bill for the transaction line. The amount you enter is the amount for the entire row, not just for the transaction types selected in theTransaction Types for Adjustmentfield, but Workday prorates only the transaction types for adjustment to achieve the amount you enter.Adjustment % for Selected Types(Optional) Enter an adjustment percentage for the mass modification adjustment. Workday adds this percentage to theOriginal Total Amount to Billto calculate theNew Total Amount to Bill. A positive number increases the amount to bill, and a negative number decreases it. Only the transaction types selected in theTransaction Types for Adjustmentfield are included in the calculation.Adjustment Amount for Selected Types(Optional) Enter an adjustment amount for the mass modification adjustment. Workday adds this amount to theOriginal Total Amount to Billto calculate theNew Total Amount to Bill. A positive number increases the amount to bill, and a negative number decreases it. Only the transaction types selected in theTransaction Types for Adjustmentfield are included in the calculation.Zero Amount to Bill(Optional) Select this check box to set theNew Total Amount to Billto zero.ApproveClick to approve billable transactions at the project level. Workday updates the status ofAwaiting ReviewandOn Holdbillable project transactions toReady to Bill.Recalculate RatesClick to recalculate rates for billable transactions at the project level. Workday recalculates rates for billable project transactions inAwaiting Review,On Hold, andReady to Billstatus.Create Invoice ProposalClick to create customer invoice proposals for billable transactions at the project level. Workday creates customer invoice proposals for billable project transactions inReady to Billstatus.If you don't select any billable transactions before clicking this option, Workday opens theCreate Customer Invoice Proposaltask.Displays when you click theMorebutton.Submit Mass Modify AmountsClick to mass adjust amounts for billable transactions at the project level. Workday mass modifies amounts for billable project transactions:- For original and offset billable transactions.
- InAwaiting Review,On Hold, andReady to Billstatus.
- With negative and positive billable amounts.
This action applies to the transaction types that you configure with theTransaction Types for Adjustmentoption in theSet Up Project Billing Configurationtask. By default, you can adjust amounts for these transaction types: Time, Supplier Invoice, Expense, and Misc Expense transactions.Displays when you click theMorebutton.This option enables you to complete the same action as theModify Amountmass action on the transaction details view, but at the project level.Transfer ProjectClick to initiate theTransfer Project Transactionstask for transferring and splitting transactions.When you transfer project transactions during an open period, Workday runs time calculations for the time block and reevaluates the worktags. Workday resets any worktag values that workers overrode on the time blocks back to their default values.If you want to disable theTransfer Projectoption from theManage Project Billing Transactionstask's summary view, access theConfigure Optional Fieldstask, select theManage Project Billing Transactionsfunctional area, and select security groups to hide theSummary: Transfer Project Buttonfrom.Displays when you click theMorebutton. - (Optional) On both the project summary view and the transaction details view, click the icons at the upper-right corner of the grid to filter the grid data, reorder and hide columns, and toggle fullscreen mode.
- (Optional) As you complete the search criteria from the transaction details view, selectDo Not Billfrom theBilling Statusprompt to display transactions inDo Not Billstatus.
- Complete the header on the transaction details view:
Option Description Total Amount to BillThe sum of theAmount to Billfor the selected transactions.Or, when viewing by transaction source, the sum of theAmount to Billfor the selected transactions for each transaction source.CurrencyDisplays when the selected transactions have the same billing currency.Mass ActionSelect multiple transactions and then apply one of these actions to all selected transactions at once:- Project Transfer: Transfer transactions to another project, phase, or task. This option is available when viewing by transaction source.
- Change Billing Status: Change the billing status of transactions; for example, fromOn HoldtoReady to Bill.
- Exclude from Prepayment: Exclude transactions from prepayment consumption.
- Modify Amount: Modify the amounts to bill for the selected transactions. This action applies to the transaction types that you configure with theTransaction Types for Adjustmentoption in theSet Up Project Billing Configurationtask. By default, you can adjust amounts for these transaction types: Time, Supplier Invoice, Expense, and Misc Expense transactions.
Billing StatusSelect a new billing status for the selected transactions and clickApply.Displays when you selectChange Billing Statusfrom theMass Actionprompt.Original Amount to BillThe sum of theAmount to Billfor the selected transactions.Displays when you selectModify Amountfrom theMass Actionprompt.New Amount to Bill(Optional) Enter the amount you want to bill for all transactions you've selected in the grid. The transaction types that this action applies to are configured by theTransaction Types for Adjustmentoption in theSet Up Project Billing Configurationtask. By default, you can adjust amounts for these transaction types: Time, Supplier Invoice, Expense, and Misc Expense transactions.Enter a positive value if you want theBillable Amountto be positive, and a negative value for a negativeBillable Amount. Example: Enter -150.00 for a billable amount of (150.00).Workday determines the percentage of each transaction in relation to the total billable amount. Then, Workday applies that percentage to theNew Amount to Billthat you enter.Example: You select 2 Time transactions. Transaction 1 has aBillable Amountof $150. Transaction 2 has aBillable Amountof $480. The total billable amount for the 2 transactions is $630. Transaction 1 is 23.8% (150÷630) of the total billable amount and Transaction 2 is 76.19% (480÷630). You enter aNew Amount to Billof $500. Workday automatically populates theAmount to Billwith $119.05 for Transaction 1 and $380.95 for Transaction 2.Displays when you selectModify Amountfrom theMass Actionprompt.Zero Amount to BillSelect to update theAmount to Billto zero for the selected transactions.When you select this check box, Workday disables data entry for theNew Amount to Bill,Adjustment %, andAdjustment Amountfields.Displays when you selectModify Amountfrom theMass Actionprompt.Adjustment %andAdjustment Amount(Optional) Enter a number in one of these fields to adjust the amounts to bill for all transactions you've selected in the grid:- Adjustment %: Workday adds the percentage you enter in this field to theOriginal Amount to Billto calculate theNew Amount to Bill. A positive number increases the amount to bill, and a negative number decreases it.
- Adjustment Amount: Workday adds the amount you enter in this field to theOriginal Amount to Billto calculate theNew Amount to Bill. A positive number increases the amount to bill, and a negative number decreases it.
These fields display when you selectModify Amountfrom theMass Actionprompt.Adjustment ReasonWhen you leave this prompt blank, Workday populates the selected transactions with the default revenue adjustment reason that you configured on theMaintain Revenue Adjustment Reasonstask.When you click:- Apply, Workday prorates the adjustment amount across the selected transactions and populates the revenue adjustment reason on the transactions.
- Submit, Workday routes the transactions for review and approval using theAdjustmentbusiness process. You can drill down on theAdjustment Countcolumn to view the manual adjustments.
Displays when you selectModify Amountfrom theMass Actionprompt.Transfer To Project Plan Task (available when viewing by transaction source)Select an option to mass transfer Time or Daily Time transactions and clickApply.The prompt includes all tasks from all phase levels for the billable project.Displays when you selectProject Transferfrom theMass Actionprompt.Transfer to Project / Phase / Task (available when viewing by transaction source)Select an option to mass transfer nonlabor billable transactions and clickApply.When you transfer transactions to a:- Project plan task, Workday displays all tasks from all phase levels for the billable project.
- Project plan phase, Workday displays only top-level phases for the billable project.
Displays when you selectProject Transferfrom theMass Actionprompt. - (Optional) In the Project Transactions grid (on theBilling Reviewtab in tabbed view), you can change the billing status, hours to bill, rate to bill, and amount to bill for individual transactions. You can also filter by and view previously invoiced billable transactions and view billable transactions that require recalculation. Workday doesn't recalculate offset amounts or populate theRecalculatecolumn for usage-based transactions.
- Complete theProject Transfertab (available when viewing by transaction source in tabbed view):If you transfer ad hoc time transactions after they have already been costed, you will need to run theCreate Project Labor Cost Summarizationtask to reverse the previous accounting journals from the source project and create new journals for the target project.
Option Description Transfer To Project Plan TaskSelect project plan tasks to transfer individual transactions to.This field is available for Time transactions only, and displays all tasks from all phase levels for the billable project.Transfer To Project / Phase / TaskSelect projects, project plan phases, or project plan tasks to transfer individual nonlabor billable transactions to. This field is available for Expense or Supplier Invoice transactions.When you transfer:- Transactions to a project plan task, Workday displays all tasks from all phase levels for the billable project.
- Transactions to a project plan phase, Workday displays only top-level phases for the billable project.
- Paid nonlabor billable transactions, Workday creates an accounting adjustment line with details from the Supplier Invoice or Expense Report source transaction.
- Unpaid nonlabor billable transactions, Workday updates the Supplier Invoice or Expense Report lines on the source document with the new project worktag.
Split(Expense and Supplier Invoice) Click to allocate a percentage or amount to split the nonlabor billable transaction into multiple transactions without changing the original transaction amount.When you split:- Paid nonlabor billable transactions, Workday creates an accounting adjustment line with details from the Supplier Invoice or Expense Report source transaction.
- Unpaid nonlabor billable transactions, Workday creates a Supplier Invoice line split or an Expense Report itemization.
Transfer Reason(Expense and Supplier Invoice) Workday populates this field with the transfer reason that you configured on theSet Up Project Billing Configurationtask.Accounting Adjustment Date(Expense and Supplier Invoice) Workday populates this field with the date that you configured on theSet Up Project Billing Configurationtask.Displays on paid nonlabor billable project transactions only.Accounting Adjustment Reason(Expense and Supplier Invoice) Workday populates this field with the reason that you configured on theSet Up Project Billing Configurationtask.Displays on paid nonlabor billable project transactions only. - (Optional) View adjustment details of billable project transactions.When billable transactions have any adjustment history, such as transfers to another project, you can view the detailed activity to help you complete your billing review process more efficiently.Workday creates these activities when the billable transactions are initially submitted against a project or project phase/task, or if the transactions are modified from the source document. Users can see if any changes were made to certain specific transaction attributes, even if the transactions remained on the same project/task.Select the related actions icon for a billable transaction, and select theBillable Transaction Adjustment Activitytab. This tab displays summarized information about transaction adjustments for these transaction types:
- Time
- Expense
- Supplier Invoice
- Misc expense
- Ad hoc transactions from all sources
Click the magnifying glass in theActivitycolumn to view further details about that activity.Workday records activities only for transactions that are booked to a billable project when created.Examples:- If a transaction is initially created on a non-billable project and is later transferred to a billable project, you'll see only one activity in the activity history.
- If a transaction is transferred from a billable project to a non-billable project, and then transferred back to a billable project, Workday records both activities.
- If a time transaction (a worker time block or ad hoc time) is transferred from a billable project to a non-billable project, then to one or more other non-billable projects, and finally back to a billable project, Workday records the transfer to the first non-billable project, does not record any subsequent transfers to other non-billable projects, and resumes recording activities once the transaction is transferred back to a billable project. For non-labor transactions (supplier invoice and expense report transactions, including ad hoc) transferred from a billable project, Workday does record the non-billable to non-billable project transfers.
- (Optional) In the Project Transactions grid (on thePrepaidtab in tabbed view), exclude transactions from prepayment consumption.You can exclude transactions by selecting them individually using theExclude from Prepaymentcheck box, or by selecting multiple transactions and using theExclude from Prepaymentmass action.
- (Optional) In the Project Transactions grid (on theWorktagstab when viewing by transaction source in tabbed view), view prior and current worktags when you transfer or split nonlabor billable transactions.
- (Optional) In the Project Transactions grid (on theCustom Referencestab in tabbed view), edit ad hoc project transaction details for billing and reporting purposes.Workday displays this tab when you enable custom references for ad hoc project transactions.
- (Optional) Export project billing transactions to Excel.Export project billing transactions to Excel to analyze the data to better inform your billing decisions.
- Click theBillable Transactionsfield to open a read-only view of the transactions grid.
- From the read-only view, clickExport to Excelto download the transactions as an Excel worksheet.From this view you can also export to PDF, filter, and expand and collapse rows.
- Submit, recalculate rates, or create customer invoice proposals for the selected transactions.
Create:
- Customer invoice proposals for billable transactions.
- Customer invoices from contracts.
- Revenue installments for billable transactions.