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:
- 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 |
---|---|
Client | From 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 |
Worker | Enter the name of the worker(s) whose data is included in the report. This field is set to 'All' by default. |
Requisition Type | Select the engagement type. This field is set to 'All' by default. |
Requisition Status | Select the status of the engagement to report on. |
Invoice Option | Select the invoice option for the engagement. This field is set to 'All' by default. See c_invoicing.html. |
Percentage Used Greater than | Use 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 by | From the drop down, select how to summarize the output columns in the report. |
Select Columns | Select the columns to include in the report. |