Standard WIP Reports

This page is about how to use the standard WIP reports included with MYOB Acumatica Professional Services. For general information about running and filtering reports, see Working with Reports.

Note:
Report line colours The WIP report lines will be shaded green then the WIP amount is greater than zero, and red when it is less than zero. For WIP exactly zero, some reports will shade the lines green, others yellow.

When running a WIP report, choose the dates and other variable you want to report on, then select the Apply Filters checkbox to display the information. The reports will not display any information unless that box is selected.

WIP Project Transactions Aged (MYPEG600)

The WIP Projections Transactions Aged report gives the most detailed review of all financial transaction related to a project. It is suitable for auditing and reconciliation, or as an aged report to give accurate billing at financial reporting at a point in time.

Using this report:
  • Sort the list by WIP Amount in descending order to see the projects with the highest amounts of WIP.
  • Enter an Up To Date to see the WIP at a point in time, or leave it blank to see all WIP transactions.

WIP Project Transactions Aged+Future (MYPEG610)

The WIP Projections Transactions report is the same as the WIP Projections Transactions Aged report, except it includes future-dated transactions. Entering a date ages the transactions, but doesn't exclude future-dated transactions, so it's ideal for auditing and troubleshooting when you need to see every transaction in the system.

Using this report:
  • Sort the list by WIP Amount in descending order to see the projects with the highest amounts of WIP.
  • Enter an Up To Date to see the transactions aged. Future-dated transactions are still included in the list.

WIP Project Aged (MYPEG601)

The WIP Project Aged report shows the outstanding aged WIP for each project. Use this report to help you prioritise billing and collections to improve your cashflow.

Using this report:
  • Sort the list by WIP Amount in descending order to see the projects with the highest amounts of WIP.
  • Click the figure in the WIP Amount column to see all the WIP transactions for that project.
  • Enter an Up To Date to see the WIP at that date.

WIP Parent Aged (MYPEG601)

The WIP Parent Aged report shows the outstanding aged WIP for each project, with parent project totals including the WIP value of their children (projects that are note parents show their own WIP as normal). Use this report to identify groups of projects with outstanding WIP balances, and see which of your projects are parents.

Using this report:
  • Sort the list by WIP Amount in descending order to see the projects with the highest amounts of WIP.
  • Click the figure in the WIP Amount column to see all the WIP transactions for that project.
  • Enter an Up To Date to see the WIP at that date.
  • Compare this report to the Review WIP screen to XXXXXX.

WIP Client Aged (MYPEG603)

The WIP Client Aged report shows the outstanding aged WIP for each client. This report is ideal for collections, targeting client communications and prioritising billing.

Using this report:
  • Sort the list by WIP Amount in descending order to see the projects with the highest amounts of WIP.
  • Click the figure in the WIP Amount column to see all the WIP transactions for that project.
  • Enter an Up To Date to see the WIP at that date.

WIP Family Group Aged (MYPEG604)

The WIP Family Group Aged report shows the total outstanding aged WIP for clients across family groups, simplifying WIP tracking for clients with close relationships. Clients who are not in a family group are included in "UnSpec" (unspecified).

Using this report:
  • Sort the list by WIP Amount in descending order to see the projects with the highest amounts of WIP.
  • Click the figure in the WIP Amount column to see all the WIP transactions for that project.
  • Enter an Up To Date to see the WIP at that date.

WIP Project Partner Aged (MYPEG605)

The WIP Project Partner Aged report shows the aged WIP for projects for each partner. Run this report to look at the profitability and and performance of each partner. Projects without a partner are grouped under "UnSpec".

Using this report:
  • Sort the list by WIP Amount in descending order to see the projects with the highest amounts of WIP.
  • Click the figure in the WIP Amount column to see all the WIP transactions for that project.
  • Enter an Up To Date to see the WIP at that date.

WIP Project Task Aged (MYPEG606)

The WIP Project Task Aged report shows the aged WIP for projects for each task. This report shows you which tasks are most profitable, to help with billing. Projects without a partner are grouped under "UnSpec".

Using this report:
  • Sort the list by WIP Amount in descending order to see the projects with the highest amounts of WIP.
  • Click the figure in the WIP Amount column to see all the WIP transactions for that project.
  • Enter an Up To Date to see the WIP at that date.