Financials > Closing processes > Revenue recognition 

Use this function to calculate the revenue recognition for a single project on a specific date.

To process revenue recognition for multiple projects, see Revenue recognition validation.

You must have defined a Revenue recognition code in Revenue recognition rules and assigned that code to the project before being able to run this calculation.

About Revenue recognition

As a complement to the Project management (PJM) module, revenue recognition allows you to determine the method in which each project recognizes the revenue based on one of three methods:

Manual percentage entry

Percentage of costs with estimated margin at completion

Percentage of costs without estimated margin at completion

These methods, in conjunction with the project-related journal entries to the deferred revenue and cost accounts, allows the Revenue recognition function to calculate the values that should be recognized and then posted to the revenue and cost accounts.

Setup

After you have defined a Revenue recognition code in Revenue recognition rules, you can assign that code to projects in Project management. Before calculating revenue recognition for a period, you need to select the Revenue recognition checkbox in Financial snapshots. This way, you have the most up-to-date values for any of the project-related calculation such as estimated cost at completion and subsequent calculations.

Calculating and posting

When a project milestone or a performance obligation is met, you can calculate, validate, and then post the recognized amount. The Revenue recognition function is used to generate entries for a single Revenue recognition code and Project. When you want to process revenue for multiple projects, you can use the Revenue recognition validation function to process entries in a workbench format.

    Prerequisites

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Header

    Fields

    The following fields are present on this tab :

    Identification

    Enter an existing Revenue recognition code.

    • Description (field DESTRA)

    This field displays information from the Revenue recognition code setup and cannot be modified.

     

    • Revenue recognition method (field RRECMET)

     

    • Status (field STA)

    This field displays the status for the current revenue recognition calculation:

    • To be processed: You created the record, but it is not yet calculated.
    • Awaiting validation: You calculate the amounts.
    • Validated: You validated the amounts and they can no longer be adjusted.
    • Simulation posted: You posted the record using a simulation generation type (active or inactive).
    • Posted: The amount is posted to the general ledger.

    Project/dimension

    • Calculation basis (field REVTYP)

    This field displays information from the Revenue recognition code setup and cannot be modified.

    • Dimension type (field DIE)

     

    • Analytical dimension (field CODDIM)

     

    • Ledger type (field LEDTYP)

     

     

    This field displays information from the Revenue recognition code setup and can be modified or left empty.

    Close

     

    Tab Posting

    Presentation

    This Columns grid displays data after you click Calculation.

    You can use the Adjusted amount column to modify the calculated amounts for the following Column types:

    • Est. cost at completion
    • Percentage at completion
    • Net recognized revenue
    • Net recognized cost

    When an amount is updated, the amounts in subsequent columns are updated and if the context changed, from Sales accruals to Invoices to be issued for example, the account is reinitialized accordingly.

    Close

     

    Fields

    The following fields are present on this tab :

    Generation

    • Generation type (field GENTYP)

    Select the generation type for the calculation.

    Actual: This generates a journal entry integrated into the balance, so it is visible in the inquiries and printouts. The related entry status depends on the FRADGI - French fiscal regulation parameter (TC chapter, CPT group) setting for the company:

    Yes: The Entry status is Final.

    No: The Entry status is Temporary.

    Active simulation: This generates a journal entry integrated into the balance, so it is visible in the inquiries and printouts. The related Entry status is forced to Temporary.

    Inactive simulation: This generates a journal entry not integrated into the balance and not visible in inquiries and printouts. The related Entry status is forced to Temporary.

    • Entry status (field GENSTA)

    For an actual generation, you can select Temporary or Final. For active or inactive simulations, the status is Temporary.

    The default status depends on the FRADGI - French fiscal regulation parameter (TC chapter, CPT group) setting for the company:

    Yes: The Entry status is Final.

    No: The Entry status is Temporary.

    Additional information

    • Entry date (field INIDAT)

    When you enter the date, remember that revenue can be recognized at any time, but the relevant period end date and posting date are always used to determine the data used in the calculation.

    • Reversal date (field REVDAT)

    This date defaults to the first day of the period following the reference date.

    This date generates the reversal journal entry, which must be part of an open fiscal year or period.

    • Previous entry date (field PREDAT)

    This date defaults to the first day of the period following the reference date.This date generations the reversal journal entry, which must be part of an open fiscal year or period.

    • Currency (field LEDCUR)

    This value defaults from the project and cannot be modified.

     

    • Identifier (field NUM)

    The identifier is automatically created when you validate the calculation. It is then assigned to the relevant financial snapshot.

    Revenue posting

    The entry type is based on the ENTTYPEXP - Rev. rec. expense entry type parameter (TC chapter, REV group) setting.

    This account is defined in Accounting code lines function. The default accounts are used when generating revenue recognition journal entries. The accounting code lines are linked to the project type.

     

    • Comments (field CMT)

    You can enter comments any time before validation. These comments display in the Default description field in the journal entry.

    • Journal number (field JOUNUM)

    This field displays the related journal entry number.

    Expense posting

    The entry type is based on the ENTTYPEXP - Rev. rec. expense entry type parameter (TC chapter, REV group) setting.

    This account is defined in Accounting code lines function. The default accounts are used when generating revenue recognition journal entries. The accounting code lines are linked to the project type.

     

    • Comments (field CMTEXP)

    You can enter comments any time before validation. These comments display in the Default description field in the journal entry.

    • Journal number (field JOUNUMEXP)

     

    Close

     

    Tab Definition

    Fields

    The following fields are present on this tab :

    Grid Columns

    • Column name (field NAMCOL)

    This field displays information from the Revenue recognition code setup and cannot be modified.

    • Calculated amount (field ORIAMTLED)

    • Adjusted amount (field AMTLED)

    Depending on the Column type, you can enter an adjustment to the calculated amount. After making adjustments, you need to recalculate to update the Calculated amount field.

    This applies to the following Column types:

    • Est. cost at completion
    • Adjusted percentage
    • Adjust. net recognized revenue
    • Adjust. net recognized cost

     

    Action icon

    Journals

    Select this option to view the journal entries used to calculate the Actual revenue and Actual costcolumn types. A new screen opens that displays information such as the account, company, accounting date, document number, ledger debit or ledger credit, and the project and entry statuses.

    You cannot drill down when the Calculation basis is Dimension for an Actual Generation type.

    Text

    To facilitate inquiries after revenue recognition has been posted, you can enter a comment on a line for a specific amount or on the header for the entire record. You can also add an attachment.

    Formula description

    If you entered a custom formula, you can view the details by selecting this option.

     

    Close

     

    Specific actions

    Click this action to calculate the revenue based on the Recognition revenue code setup and values entered in the Header section.If you adjust any amounts, you need to recalculate to update data in the Columns grid.

    When you are satisfied with the Calculated amounts, click Validation. After validating, you can no longer make any changes or adjustments. Validating automatically generates the Identifier.

    Depending on your company setup, you could have the option to Cancel validation from the Actions panel and return the record to an editable state.

    After validation, you can post the calculated revenue recognition amounts to the selected debit or credit accounts.

    This action is not enabled until you validate the calculation.

    When you run a simulation, you can review journal entries and make adjustments before posting in actual mode.

    A log file displays after you post the record. If you have previously posted the record, the related entries are canceled when you re-post the record. The canceled entries display in the log file.

    The record status updates to Posting simulation.

    The Post action remains enabled, and a journal entry can still be regenerated until you post the record in actual mode.

    When you post in actual mode, the revenue recognition is posted to the relevant journals.

    The entry status defaults according to the FRADGI - French fiscal regulation parameter (TC chapter, CPT group).

    A log file displays the canceled document information as well as the new journal number generated, and its reversal entry information. The reversal journal entry can only be generated in actual mode.

    The status of the record is now Posted, and you can no longer make any modifications.

    Before posting the revenue recognition amounts, you can cancel the validation which resets the status to Awaiting validation.

    You cannot cancel the validation after you post to the selected accounts.

    Click this action to view the generated journal entry.

    Cliquez sur cette action pour afficher le cliché financier.

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation