Maconomy Information Center

WIP Aging, by Account Manager Report

This section describes the fields and descriptions on the WIP Aging, by Account Manager report.

The WIP Aging, by Account Manager report displays the difference between entries (job entries) and invoices on jobs. Only jobs that are capitalized are included in the report.

WIP (work in progress) is calculated based on the following:

  • The entered cost, if the job is capitalized at cost
  • Revenue recognized, if the job is capitalized at billing

The WIP amounts are displayed in period intervals based on the setup of the aging principles for WIP Aging reports. The report also displays the net invoiced amount on account. In the following table, the column titles and explanations are just examples of how the columns would be if the aging periods were 30-day intervals.

  • You can drill down on the No & Name column to the customer and job.
  • The Total Balance column links to the WIP Transactions report.

The CPA solution uses the Purpose dimension for Client Manager , and in that solution this report is renamed to WIP Aging, by Client Manager. Thus, this report is a client manager focused version of the WIP Aging report.

This report has three tabs. The first tab displays similar columns as the WIP Aging report. The second and third tabs display the same columns, except that:

  • They do not offer drilling.
  • The second tab groups by the Purpose dimension and displays the name and number of the Client Level 1 instead.
  • The third tab groups by the Purpose dimension and the Client Level 1 dimension, and displays the name and number of the job instead.
Column Description
No & Name This column displays the number and name of the current drill-down level. The drill-down levels are:
  • Purpose
  • Customer Level 1
  • Customer Level 2
  • Job
WIP, Exposure This column displays the amount invoiced on account that is not yet reconciled.
WIP, Net This column displays the WIP Balance, which is the Total WIP less the WIP Exposure.
WIP, Total This column displays the total WIP balance.
0-30 days This column displays the WIP balance that is up to 30 days old.
31-60 days This column displays the WIP balance that is between 31 and 60 days old.
61-90 days This column displays the WIP balance that is between 61 and 90 days old.
91-120 days This column displays the WIP balance that is between 91 and 120 days old.