Revenue Generation Calculations

When you run the revenue generation process, your enterprise's job-to-date revenue is calculated on a project-by-project basis (or phase-by-phase or task-by-task) according to the revenue methods that are assigned to each project, phase, and task.

Revenue generation calculates a project's revenue on a job-to-date basis, in the following sequence:

  1. Calculates the job-to-date revenue for each project/phase/task according to the revenue method specified in the Projects hub.
  2. Updates the current period revenue for each project/phase/task by subtracting its prior period job-to-date revenue from the current period's job-to-date revenue.
  3. Determines the unbilled amounts for each project/phase/task by subtracting job-to-date billed revenue (recognized through bill processing) from job-to-date revenue (based on the revenue method selected).
  4. Creates the Revenue Generation Journal Entry file, which contains the amounts and accounts to be debited and credited for the newly calculated revenue information.

Revenue Categories

If you set up revenue generation to use revenue categories to track multiple unbilled services and uninvoiced revenue accounts, the same revenue calculations are completed separately for each revenue category.

Revenue Groups

If you use revenue groups, see the Revenue Groups help topics for an explanation of the revenue generation calculation that occurs.

Before you run revenue generation, verify that all relevant transactions have been posted. The transactions that affect the calculation of revenue differ, depending on the revenue methods that you use.

For example, you may need to post the following transactions prior to running revenue recognition:

  • Labor (timesheets)
  • Expense (expense reports and repayments)
  • Invoices (if you do not use the Billing application)
  • Billings (if you use the Billing application)
  • Cash receipts

If you have any projects whose revenue accrual is affected by percent completes, update labor and expense percent completes before you run revenue generation.

If you created any custom revenue types that use total project cost as part of the calculation of revenue, you must also run overhead allocation.

Revenue Reports

Two reports show the results of posting revenue:

  • Transaction List: This report shows the effect of revenue generation on your general ledger and can be printed before posting occurs.
  • Revenue Generation Posting Log: This report shows the prior JTD, new incremental job-to-date, and total job-to-date revenue that will be distributed to projects when the revenue generation file is posted.

You should generate these reports each time that you run the revenue generation process.

Overall Revenue Upset Limits

If you set up overall revenue upset limits for a project, which limits the maximum job-to-date revenue that can be calculated for a project, when you run revenue generation, any amount that exceeds the upset limit is posted to an adjustment project, phase or task.

Overall Revenue Calculation

For individual projects, you have the option to specify an additional calculation for overall revenue at the project level.