Budgeted Funds Depletion Report

This report produces data regarding funds depletion for active engagements, by either purchase order or budgeted amount.

This report produces the following columns for budgeted amounts:
  • Manager
  • Operational Unit
  • Department
  • Worker
  • Supplier
  • Requisition #
  • Requisition Type
  • Start Date
  • Estimated End Date
  • End Date
  • Bill Rate
  • Currency
  • Initial Budgeted Amount
    • For Project requests, this is the total amount of the quote from request creation. Does not include the Estimated MSP Up Fee or the Budget Amount.
  • Estimated MSP Up Fee
    • Used in Project engagements for OpUnits where Funds Tracking='Budget'. Field is empty for other engagement types.
  • Budgeted Amount
    • Used in Project engagements for OpUnits where Funds Tracking='Budget'. Field is empty for other engagement types.
  • Total Budget Amount
  • Available Amount
  • Expires On
  • Billing to Date
  • Average Weekly Billing
  • Est. Wks Remaining
  • % Of Funds Used
  • VAT to Date
  • Additional Fund Amount - Calculated field ((Available Amount + Billing to Date) - Initial Amount).
This report produces the following columns for purchase orders:
  • PO #
  • Requisition # - This field is repeated per unique PO Line # / Requisition # combination.
  • PO Line # - This field is repeated per unique PO Line # / Requisition # combination.
  • UOM - This field is repeated per unique PO Line # / Requisition # combination.
  • Manager - This field is repeated per unique PO Line # / Requisition # combination.
  • Operational Unit - This field is repeated per unique PO Line # / Requisition # combination.
  • Department - This field is repeated per unique PO Line # / Requisition # combination.
  • Worker - This field is repeated per unique PO Line # / Requisition # combination.
  • Supplier - This field is repeated per unique PO Line # / Requisition # combination.
  • Requisition Type - This field is repeated per unique PO Line # / Requisition # combination.
  • Start Date - This field is repeated per unique PO Line # / Requisition # combination.
  • Estimated End Date - This field is repeated per unique PO Line # / Requisition # combination.
  • End Date - This field is repeated per unique PO Line # / Requisition # combination.
  • Bill Rate - This field is repeated per unique PO Line # / Requisition # combination.
  • PO Amount - This field is repeated per unique PO Line # / Requisition # combination.
  • PO Available Amount - This field is repeated per unique PO Line # / Requisition # combination.
  • PO Billing to Date - This field is repeated per unique PO Line # / Requisition # combination. This field is the sum of Bill Client Amount for all processed billing line items.
  • Average Weekly Billing - This field is repeated per unique PO Line # / Requisition # combination.
  • PO Est. Wks Remaining - This field is repeated per unique PO Line # / Requisition # combination.
  • PO % Of Funds Used - This field is repeated per unique PO Line # / Requisition # combination.
  • Additional Amount - This field is repeated per unique PO Line # / Requisition # combination. This is a calculated field ((Available Amount + Billing to Date) - PO Amount). Amount billed is based on processed billing items.
  • PO Total Amount - This is a calculated field (Available Amount + Billing to Date). Amount billed is based on processed billing items.
  • Currency
  • PO Amount
  • PO Available Amount
  • Billing to Date
  • Average Weekly Billing
  • Est. Wks Remaining
  • % Of Funds Used
  • VAT to Date
  • PO Start Date
  • PO End Date
  • Primary
  • Status
  • Additional Fund Amount - This is a calculated field ((Available Amount + Billing to Date) - Initial Amount. Amount billed is based on processed billing items.
  • PO Total Amount - This is a calculated field (Available Amount + Billing to Date) . Amount billed is based on processed billing items.
Field Description
Type of Funds Use the filter to select the type of funds to report on (Budget Amount or PO Amount
WorkerEnter the name of the worker(s) whose data is included in the report. This field is set to 'All' by default.
ManagerSelect the client manager name associated with the engagement. This field is set to 'All' by default.
Supplier Filter the report output by the supplier/vendor on the request/engagement. This field is set to 'All' by default.
Requisition TypeSelect the engagement type. This field is set to 'All' by default.
Requisition StatusSelect the status of the engagement to report on.
Invoice OptionSelect the invoice option for the engagement. This field is set to 'All' by default. See Invoicing.
Percentage Used Greater thanUse the drop down to select the amount of the budget used (percentage).

You can only select increments of 10 (10%, 20%, and so on).

Operational UnitFilter the report output for billing items submitted for a specific operational unit (OpUnit). This field is set to 'All' by default.
Undo Withdraw Filter the report output by items that have the 'Undo Withdraw' action applied. This field is set to 'All' by default.
<department> Filter the report output by a configured department in the client organization. This field is set to 'All' by default.
Active PO's Only Select the check box to filter the report output by active purchase orders.
Primary PO's Only Select the check box to filter the report output by primary purchase orders.
Summarize byFrom the drop down, select how to summarize the output columns in the report.
Select ColumnsSelect the columns to include in the report.