Budgeted Funds Depletion Report

This report (Reports > Billing > Funds Depletion > Budgeted Funds Depletion 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:
  • Worker
  • Supplier
  • Requisition #
  • Requisition Type
  • Start Date
  • Estimated End Date
  • End Date
  • Bill Rate
  • Currency
  • Initial Budgeted Amount
  • 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.
  • 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
ClientFrom the drop down, select the client organization to filter results by.
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.
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 c_invoicing.html.
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).

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.