Revenue Recognition Worksheet Field List

Sage ERP Accpac Project and Job Costing 6.0

Revenue Recognition Worksheet Field List

The program displays the accounting method assigned to each project that appears on the worksheet.

The program displays the category included in a revenue calculation for:

  • Time and materials projects.

  • Cost plus projects that use the billing and costs, category percentage complete, or accrual-basis accounting method.

  • Fixed price projects that use the billings and costs or accrual-basis accounting methods.

The program displays the status assigned to contracts that are listed on the worksheet.

Note: When you generate a worksheet, you can choose to create entries for contracts that are on hold.

The program displays the status assigned to contracts that are listed on the worksheet.

Note: When you generate a worksheet, you can choose to create entries for contracts that are on hold.

The program displays in this field the Cutoff By method you used to generate the revenue recognition worksheet. The cutoff date determines the costs and charges that were included in calculating completion percentages for a given project or category (depending on the project's accounting method).

The program displays the description entered for the worksheet when it was created.

You can change the description before you post the worksheet.

The program automatically assigns a line number to each revenue recognition entry it includes on the worksheet. You cannot change the line number.

This field indicates whether revenue recognition optional fields have been assigned to a revenue recognition entry.

Select (highlight) an entry on the grid, then double-click the Optional Fields column to open a separate form where you can view or edit the assigned optional fields. If you set up any revenue recognition optional fields for automatic insertion, they appear on the form, along with the default values specified in the optional field setup records.

You can edit or delete the optional fields that appear, and you can add different optional fields that are defined for revenue recognition entries.

If the revenue recognition transaction uses the same optional fields as the transaction optional fields used for a general ledger account(for example, the work in progress, cost of sales, billings, or revenue account) , and you selected settings to pass optional field information to the General Ledger account, the optional field information is passed to General Ledger with the transaction.

For fixed price and cost plus projects that use a percentage complete accounting method, the program displays the percentage complete used to calculate the revenue recognition entries.

To enter a new percentage complete for an entry:

  1. Select the entry line on the grid.

  2. Click the Details button to open the G/L Entry Details form.

  3. Enter the percentage in the Percentage Complete field.

  4. Click the Recalculate button to recalculate the entry.

  5. Click Close to return to the worksheet.

This field identifies the project for which a selected entry was generated.

The program displays the status assigned the projects listed on the worksheet.

Note: When you generate a worksheet, you can choose to create entries for projects that are on hold.

The program displays the project type assigned to the selected project in the Contract Maintenance form.

When you generate a worksheet, you can choose to create entries to recognize revenue for a particular type of project or you can recognize revenue for all types of projects.

The program displays the worksheet date you specified when you created the worksheet using the Create Revenue Recognition Worksheet form.

When you generate a worksheet using the Create Revenue Recognition Worksheet form, the program assigns a unique number to identify the worksheet.

You use the Worksheet Number field to select the worksheet that you want to view, edit, or post.

The program displays the year and period to which the worksheet entries will be posted, and are determined by the posting date used for the billing worksheet.

If you want to change the posting date, click the Zoom () button beside the Year/Period field to open the Posting Date Override form, and then change the posting date as required.