Post Revenue

Use this form to post confirmed revenue to the general ledger, which would normally occur at the end of a period. The process creates adjusting entries to the general ledger revenue (asset) and sales (income) accounts. The reversing adjustments for these period are created in the same step.

Use any of the filters displayed in the header of the form to search for jobs on which to calculate revenue. When entering search criteria:

To select more than one specific job (or other type), select the first one. It is copied to the field to the right of the Search field. As you select each subsequent job, it appends to the string on the right side, delimited by a comma.
To enter a range of search criteria, enter it into the field on the right side of the Search field, and use a colon to separate the lowest and highest value. For example, enter 400001:400005 to include all jobs from 400001 to 400005.
You can use wildcards to include a specific group of criteria. For example,
- 00* includes all codes with a string starting with 00
- 1* includes all codes with a string starting with 1
- *0 includes all codes ending in 0.

You can select jobs that are open, closed or finalised. You can filter jobs using the Start Date, Closed Date, or Finalised Date.

You can also filter jobs based on Job Trees.

Options Reference

Each option and field on the form is described below. Mandatory options and fields are highlighted in red.

Only show jobs with revenue confirmed for the current period

Select this option to display jobs that have had revenue confirmed for the current period. If the option is not selected, jobs with revenue confirmed in prior periods also display.

Do not show jobs with posted revenue

Select this option to not display jobs that have already had revenue posted for this period.

Search Now

Click this button to display the jobs based on your selection. Jobs that cannot be posted to the general ledger display in blue.

Selected

Click this box to select the job for action. Each selected job is highlighted in yellow.

Post Revenue

Click this button to post the Actual Revenue to the general ledger for selected jobs. A progress bar displays during this process, and when completed, the batch number created for the revenue posting displays. The Revenue Status for the period is set to Posted.

UnPost Revenue

Click this button to delete the postings from the general ledger for selected jobs. This resets the Revenue Status for the period to Reviewed. You must confirm the revenue before you can repost it.

All columns displayed in the table (other than the Select column) are read only.

Pro-Rata Calculations:

If you have selected a Pro-rata Method to spread your recognised revenue over the sales general ledger accounts, these processes apply:

Actual - The revenue is spread over the sales codes related to the activity codes used in the actual costs in the current period. This is calculated as the portion of each cost's retail value over the total costs' retail value multiplied by the revenue. If a job has revenue to post, but no costs assigned, the revenue is posted to the Revenue and Sales general ledger accounts assigned to the job on the Additional tab on the JC Job Maintenance form.
Estimate - The revenue is spread over the sales codes related to the activity codes used in the current estimate. This is calculated as the portion of each estimate activity code retail value over the total estimate retail value multiplied by the revenue. If a job has revenue to post, but no estimates, the revenue is posted to the Revenue and Sales general ledger accounts assigned to the job on the Additional tab on the JC Job Maintenance form.
None - The revenue is posted to the Revenue and Sales general ledger accounts assigned to the job on the Additional tab on the JC Job Maintenance form, with no apportioning.

Updating revenue to the general ledger becomes an interim step, if the revenue debits the Revenue Recognition Control Account and credits the sales account. When the invoice is entered, this credits the account set up in the Revenue Recognition Control GL Account.