Earned Revenue


EARNED REVENUE ACCRUAL

Screen Label

 

Sample Values

Mouseover text

Budgeted Revenue

 

12000

Revenue Budget from Budget Lines (local Currency)

Budgeted Cost

 

10000

Cost Budget from Budget Lines

Budgeted Profit

 

2000

Budgeted Revenue - Budgeted Cost

Budgeted Profit Markup % on Cost

20.00%

 

Budgeted Profit / Budgeted Cost

Budgeted Profit Margin % on Sales

16.67%

 

Budgeted Profit / Budgeted Revenue

 

 

 

 

Time Costs

 

500

Cost of all Time Activity transactions to current Year/Period

Other Costs

 

1000

Cost of all Non Time Activity transactions current Year/Period

PO Accrual at Cost

 

200

PO Accruals for current Year/Period from PO Accruals table (If used. If PO Accrual used then AP Voucher Accruals is not used)

AP Voucher Accrual at Cost

 

 

AP Voucher Accruals for current Year/Period from PO Accruals table (If used. If AP Voucher Accrual used then PO Accruals is not used)

Cost Accrual - General

 

10

Manually entered Cost Accrual if required

Total Cost to Date

 

1710

Time Cost + Other Costs + PO / Voucher Accruals at Cost

 

 

 

 

Actual % Complete on Cost

17%

 

Total Cost to Date / Budgeted Cost as percentage

Adjusted % Complete on Cost

20%

 

Manual entry if different to Actual % Complete on Cost. Defaults to Actual % Complete on Cost

 

 

 

 

Earned Revenue on Adjusted % Complete

 

2400

Adjusted % Complete on Cost * Budgeted Revenue

 

 

 

 

less Profit Retention

10%

-69

Percent of Budgeted Profit to be retained. Auto calculated from Charge Type Profit Retention % value. Always negative. Calculation is Profit Retention % *( Earned Revenue on % Complete - Total Cost to Date). Values are Read Only

Assessed Revenue

 

2331

Earned Revenue on Actual % Complete + Profit Retention (-ve)

 

 

 

 

Threshold Revenue

10%

 

Take no profit if Adjusted % Complete on Cost < Threshold Revenue % . Calculation is Total Cost to Date if Adjusted % Complete on Cost < Threshold Revenue % (from Charge Type Threshold Revenue % value ) else Null

Declared Revenue

 

2331

If Threshold Revenue is not null then lesser of Assessed Revenue and Threshold Revenue, else Assessed Revenue

 

 

 

 

Revenue Adjustment - General

 

100

Manually entered Revenue adjustment

Adjusted Revenue

 

2431

Declared Revenue + Revenue Adjustment

 

 

 

 

Actual Invoicing

 

2500

Invoicing up to and including current period before tax and before retentions

WIP Revenue Accrual

 

-69

Adjusted Revenue - Actual Invoicing

 

 

 

 

Profit Taken to Date

 

621

Adjusted Revenue - Total Cost to Date

Loss Provision

 

0

If Budgeted Profit is negative then Budgeted Profit else Null. Can be manually adjusted