Description
The Project Revenue by Type report sorts and groups revenue by Project Report Type or Market Sector. Many clients use either the report type or the market sector to identify the professional liability classification of a project. In this scenario you can run the report YTD to provide the necessary revenue breakdown. When you run the report you can either view billed or received. If you run the report using received the system uses the cash basis conversion to break down the receipts into its types of revenue (labor, ODC, OCC and ICC). When you run the report by market sector all metrics are factored by the market sector percentage entered on the project setup.
Note1: Can be used for Professional liability Insurance renewal.
Note2: The Project Revenue By Type report when run for received runs on the cash basis. When it is run for billed it runs on the accrual basis. It does this because the report shows revenue by type (labor, ODC, OCC and ICC). So if you want to view received first run Convert To Cash.
Note3: Works if either the Report Type or Market Sectors. Basically if gives you preceding years revenue on a cash or accrual basis group by either market sector or report type which should represent your type of work.
Note4: The report uses data ranges not G/L periods. You need to compare with G/L by date report. Most likely this is where your difference lies.
Prompt
General
| • | Start Date - Beginning Date used to filter the transactions that are brought into this report. |
| • | End Date - Ending Date used to filter the transactions that are brought into this report. |
| • | Sort By - Allows you to Sort/Group the report by Report Type or Market Sector |
| • | Show - Billed returned Revenue figures, Received Returns Received figures (Note, the received figures come from the Cash Basis Journals, so you have to run Convert to Cash before running the report). |
| • | Currency Type - The Type of Currency to be used when running the report. Options are Base, Company, Project and Transaction. |
| • | Currency Code - The Currency Code to be used when running the report. Options are set in the Multi-Currency applet. More on Multi-Currency |
Report
Report Columns
| • | JN - Journal that the transaction comes from |
| • | JN ID - ID number of the transaction |
| • | Date - Date of the transaction |
| • | Invoice - Invoice Number |
| • | Check Number - Check number of the transaction. |
| • | Labor - Portion of the transaction that has a PM type of Labor |
| • | ODC - Portion of the transaction that has a PM type of ODC (Other Direct Charges) |
| • | OCC - Portion of the transaction that has a PM type of OCC (Out of Contract Consultants) |
| • | ICC - Portion of the transaction that has a PM type of ICC (In Contract Consultants) |
| • | Misc - Portion of the transactions that are classified as Other Revenue, Late Fee, Bad Deb, Retainage or Retainer. |
| • | Total - Total of all the above items. |
Sample(s)
|