|37768|Search Criteria|

|20207|Display Options|

|48001|About this Report|

|13990|WIP Analysis|

|20208|Shows WIP balances across each project in detail. Run this report only if you selected to Track WIP in GL in the GL Tracking Options.|

  • |13994|As Of Date| — |48730|the point in time the work-in-progress balances are measured against.|
  • |48731|Scope it down| — |48732|filter by GL company, office, client, or account manager.|
  • |48733|Aging periods| — |48734|set the first, second, and third aging buckets (in days) to age WIP balances.|
  • |48735|On screen or export| — |48736|open the interactive drill-down on screen, generate a PDF, or download an Excel workbook.|
Sample report output
|14804|Account Summary| |14805|Project Details|
Labor
{{:@WIPLaborAssetAccount:s}}
{{:@WIPLaborAssetAccountAmount:n}}
{{:@WIPLaborWOAccount:s}}
{{:@WIPLaborWOAccountAmount:n}}
Unposted Labor
{{:@UnbilledLabor:n}}
Other Expenses
{{:@WIPExpenseAssetAccount:s}}
{{:@WIPExpenseAssetAccountAmount:n}}
{{:@WIPExpenseWOAccount:s}}
{{:@WIPExpenseWOAccountAmount:n}}
Unposted Expenses
{{:@UnbilledOtherExpenses:n}}
Production Expenses
{{:@WIPVoucherAssetAccount:s}}
{{:@WIPVoucherAssetAccountAmount:n}}
{{:@WIPVoucherWOAccount:s}}
{{:@WIPVoucherWOAccountAmount:n}}
Unposted Expenses
{{:@UnbilledProductionExpenses:n}}
Media Expenses
{{:@WIPMediaAssetAccount:s}}
{{:@WIPMediaAssetAccountAmount:n}}
{{:@WIPMediaWOAccount:s}}
{{:@WIPMediaWOAccountAmount:n}}
Unposted Expenses
{{:@UnbilledMediaExpenses:n}}
@ProjectFullName @UnbilledLabor:n2 @UnbilledProductionExpenses:n2 @UnbilledMediaExpenses:n2 @UnbilledOtherExpenses:n2 @UnbilledTotal:n2
@ProjectFullName @Unbilled30:n2 @Unbilled60:n2 @Unbilled90:n2 @Unbilled90P:n2 @UnbilledLabor:n2 @UnbilledProductionExpenses:n2 @UnbilledMediaExpenses:n2 @UnbilledOtherExpenses:n2 @UnbilledTotal:n2