PO Funds Depletion Report

This report (Reports > Billing > Funds Depletion > PO Funds Depletion Report) produces data regarding funds depletion on purchase orders.

This report produces the following columns:
  • Budgeted Amount section
    • Department
    • Worker
    • Supplier
    • Requisition #
    • Requisition Type
    • Start Date
    • Estimated End Date
    • End Date
    • Bill Rate
    • Currency
    • Initial Budget Amount
    • Estimated MSP Up Fee
    • Budget Adjustment
    • 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
  • PO section
    • PO # - Additional detail for the purchase order, broken down by PO Line #.
      • Requisition #
      • PO Line #
      • UOM
      • Worker
      • Supplier
      • Requisition Type
      • Start Date
      • Estimated End Date
      • End Date
      • Bill Rate
      • PO Amount
      • PO Available Amount
      • PO Billing to Date - Sum of Bill Client Amount for all processed billings.
      • Average Weekly Billing
      • PO Est. Wks Remaining
      • PO % Of Funds Used - All values used in this calculation are pulled from the individual PO # (this section). Calculated as PO Billings to Date / PO Amount + Additional Fund Amount * 100.
      • Additional Fund Amount - All values used in this calculation are pulled from the individual PO # (this section). Calculated as Available Amount + Billing Date - PO Amount. This value is calculated from processed billing items only.
      • PO Total Amount - All values used in this calculation are pulled from the individual PO # (this section). Calculated as Available Amount + Billing Date. This value is calculated from processed billing items only.
    • Currency
    • PO Amount
    • PO Available Amount
    • Billing to Date - Sum of Bill Client Amount for all processed billings.
    • Average Weekly Billing
    • Est. Wks Remaining
    • % Of Funds Used - Calculated as Billing to Date / PO Amount + Additional Fund Amount * 100.
    • VAT to Date
    • PO Start Date
    • PO End Date
    • Primary
    • Status
    • Additional Fund Amount - Calculated as (Available Amount + Billing to Date) - Initial Amount.
    • PO Total Amount
Field Description
ClientFrom the drop down, select the client organization to filter results by.
Type of Funds Use the drop down to select the type of funds to report on.
WorkerEnter the name of the worker(s) whose data is included in the report. This field is set to 'All' by default.
Manager DelegateIf the report is being run by the client manager delegate, then the delegate can select additional client manager delegate assigned by the delegating client manager.
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 by active purchase orders only.
Primary PO's Only Select the check box to filter by primary purchase orders only.
Select ColumnsSelect the columns to include in the report.