Navigating the form

General

Select transactions and project types, and define if calculations should be based on actual or budgeted numbers.

Profit and loss

View statements about values that are posted to profit-and-loss accounts.

WIP

View statements about values that are posted to balance accounts.

Other

View statements about consumption of hours, items, and other costs and on-account and payroll transactions.

Hour rate

View hour rates for hours that are posted to profit-and-loss accounts.

Calculate

Display values in the statements fields in the form. This button must be selected before selecting the Transactionsor Forecastbuttons.

Transactions

Select the transactions option to view the appropriate posted transactions.

Forecast

Select the forecast option to view the appropriate forecast transactions.

Export to Microsoft Office Excel

Export the calculated data to an Excel PivotTable.

Include project types

Select the project types to be displayed in the statements fields below. More than one project type can be selected.

Note
If you access the Project statements form through the Projectsform, the project type of the active project is selected automatically and the check boxes are locked for editing.

Include transaction types

Select the project transaction types to be displayed in the statement fields here. More than one project transaction type can be selected.

Project date

The time frame in which transactions were posted to a project.

• From date: Enter a start date if you want to delimit the statement calculation.

• To date: Enter an end date if you want to delimit the statements calculation.

Ledger date

The time frame in which transactions were posted to ledger.

• From date: Enter a start date if you want to delimit the statements calculation.

• To date: Enter an end date if you want to delimit the statements calculation.

Data

Select the type of statements that you want to display in the statements fields in the form. The value selected in this field determines which other fields are visible in the Project statementform.

• Actual: The actual, realized transaction numbers and values are displayed in the statements fields when you click the Update button.

• Budget: The budgeted transaction numbers and values are displayed in the statements fields when you click the Update button.

• Deviation: The actual and budgeted values and the difference between the actual and the budgeted values are displayed in their respective columns when you click the Update button.Deviation = Budget value - Actual value

• Sum: The actual and budgeted values are added. Sum = Budget value + Actual value

P&L Structure

• Revenue: Sum of invoiced revenue and accrued revenue posted to profit-and-loss accounts.

• Cost - Expense: Amount that is debited to the current profit and loss account.

• Cost - Item: Amount that is debited to the current profit and loss account.

• Accrued loss: Amount that is debited to the current profit and loss account by the estimate.

• Value-added: Total amount of revenue minus costs of expenses, items, and accrued costs; or gross margin plus hour costs.

• Cost - Hour: Amount that is debited to the current profit and loss account.

• Gross margin: Revenue minus the total costs.

P&L Ratio

• Value-added markup pct: The value-added amount as a percentage or factor of the revenue based on the parameter definition.

• Contribution ratio: The gross margin percentage or factor based on the parameter definition.

Invoice revenue

• Invoiced revenue: Amount that is credited to the current Profit and loss account.

• Invoiced revenue - On account: Amount that is credited to the current profit and loss account.

• Total invoiced revenue: The total of amounts credited to the profit-and-loss accounts.

Accrued revenue

• Accrued revenue - Sales value: Amount that is credited to the current profit and loss account.

• Accrued revenue - Production: Amount that is credited to the current profit and loss account by fixed-price estimates.

• Accrued revenue - Profit: Amount that is credited to the current profit and loss account by fixed-price estimates.

• Accrued revenue - Subscription: Amount that is credited to the current profit and loss account.

• Accrued revenue - On account: Amount posted to the current profit and loss account by fixed-price estimates estimate.

• Total accrued revenue: Total accrued revenue credited to the profit-and-loss accounts.

Cost

• Cost - Hour: Amount posted to the current profit and loss account.

• Cost - Expense: Amount that is credited to the current profit and loss account.

• Cost - Item: Amount that is credited to the current profit and loss account.

• Accrued loss: Amount that is credited to the current profit and loss account by the estimate.

• Total cost: Amount that is debited to the WIP accrued cost account, which is generated from an expense transaction.

WIP Cost price

• Sum of capitalized costs and accrued costs.

WIP Sales price

Amount that is debited to the WIP sales account.

WIP - Production

Amount that is debited to the WIP production account on fixed-price projects.

WIP - Profit

Amount that is debited to the WIP profit account on fixed-price projects.

Get pricing from

Amount that is debited to the WIP subscription account.

Total WIP sales

Sum of WIP to sales price.

Gross WIP

Total amount of WIP at cost price and WIP at sales price posted to balance accounts.

WIP - Invoiced - On account

Amount that is credited to the WIP invoiced on-account account.

Net WIP

Gross amount minus the amount that is credited to the WIP invoiced on-account account. Makes up the total investment posted to balance accounts.

Hour - Qty.

Number of hours that is consumed posted to the cost and WIP cost value accounts.

Not capitalized

Costs per hour.

Hour

Total amount that is debited to the cost and WIP cost value accounts. Generated from hourly transactions.

Expense

Total amount that is debited to the cost and WIP cost value accounts. Generated from expense transactions.

Item

Total amount that is debited to the cost, item cost, and WIP cost value item accounts. Generated from item transactions.

Total consumption

Costs that are posted to profit-and-loss accounts.

Payroll allocation

Amount that is credited to the payroll allocation account.

Invoiced on account

Amount that is invoiced and credited to the invoiced on-account account.

Hour - Qty.

The total number of hours.

Revenue hour rate

Revenue per hour.

Cost hour rate

The value added amount per hour.

Cost hour rate

Costs per hour.

Gross margin hour rate

Gross margin per hour.